13 places near Amparafaravola, Toamasina, Madagascar
filter by placetype:
  1. Madagascar
    Madagascar, Madagascar (Island)
  2. Ambatondrazaka
    Ambatondrazaka, Toamasina, Madagascar (County)
  3. Amparafaravola
    Amparafaravola, Toamasina, Madagascar (County)
  4. Indian/Antananarivo
    Indian/Antananarivo (Timezone)
  5. Indian/Kerguelen
    Indian/Kerguelen (Timezone)
  6. Eastern
    Eastern, Eastern, Fiji (State)
  7. Mahajanga
    Mahajanga, Mahajanga, Madagascar (State)
  8. Toamasina
    Toamasina, Toamasina, Madagascar (State)
  9. Madagascar
    Madagascar, Madagascar (Country)
  10. Indian Ocean
    Indian Ocean (Ocean)

Search again including deprecated places, unknown places, places that visit Null Island or everything?

This query took 0.011 seconds ⌛; show me the details?

        
0.011 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  48.263599,
                  -17.601179
                ]
              }
            }
          }
        }
      ],
      "must_not": [
        {
          "terms": {
            "woe:placetype": [
              0,
              11,
              25
            ]
          }
        },
        {
          "term": {
            "geom:latitude": {
              "value": 0.0
            }
          }
        },
        {
          "term": {
            "geom:longitude": {
              "value": 0.0
            }
          }
        },
        {
          "exists": {
            "field": "woe:superseded_by"
          }
        }
      ]
    }
  },
  "aggs": {
    "placetypes": {
      "terms": {
        "field": "woe:placetype_name",
        "size": 10000
      }
    }
  },
  "sort": [
    {
      "woe:scale": {
        "order": "desc",
        "mode": "max"
      }
    },
    {
      "woe:id": {
        "order": "asc",
        "mode": "max"
      }
    }
  ]
}