13 places near Mandronarivo, Mahabo, Toliara, Madagascar
filter by placetype:
  1. Mandronarivo
    Mandronarivo, Mahabo, Toliara, Madagascar (Town)
  2. Madagascar
    Madagascar, Madagascar (Island)
  3. Ambalavao
    Ambalavao, Fianarantsoa, Madagascar (County)
  4. Mahabo
    Mahabo, Toliara, Madagascar (County)
  5. Indian/Antananarivo
    Indian/Antananarivo (Timezone)
  6. Indian/Kerguelen
    Indian/Kerguelen (Timezone)
  7. Fianarantsoa
    Fianarantsoa, Fianarantsoa, Madagascar (State)
  8. Toliara
    Toliara, Toliara, 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.024 seconds ⌛; show me the details?

        
0.024 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  45.634441,
                  -21.11936
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}