14 places near Tsarafidy, Ambohimahasoa, Fianarantsoa, Madagascar
filter by placetype:
  1. Tsarafidy
    Tsarafidy, Ambohimahasoa, Fianarantsoa, Madagascar (Town)
  2. Madagascar
    Madagascar, Madagascar (Island)
  3. Fianarantsoa
    Fianarantsoa, Fianarantsoa, Madagascar (County)
  4. Ambalavao
    Ambalavao, Fianarantsoa, Madagascar (County)
  5. Ambohimahasoa
    Ambohimahasoa, Fianarantsoa, Madagascar (County)
  6. Indian/Antananarivo
    Indian/Antananarivo (Timezone)
  7. Indian/Kerguelen
    Indian/Kerguelen (Timezone)
  8. Fianarantsoa
    Fianarantsoa, Fianarantsoa, Madagascar (State)
  9. Toliara
    Toliara, Toliara, Madagascar (State)
  10. Madagascar
    Madagascar, Madagascar (Country)

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

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

        
0.027 seconds ⌛

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