15 places near Ambohidranandriana, Antsirabe, Antananarivo, Madagascar
filter by placetype:
  1. Ambohidranandriana
    Ambohidranandriana, Antsirabe, Antananarivo, Madagascar (Town)
  2. Madagascar
    Madagascar, Madagascar (Island)
  3. Antsirabe
    Antsirabe, Antananarivo, Madagascar (County)
  4. Antanifotsy
    Antanifotsy, Antananarivo, Madagascar (County)
  5. Betafo
    Betafo, Antananarivo, Madagascar (County)
  6. Indian/Antananarivo
    Indian/Antananarivo (Timezone)
  7. Indian/Kerguelen
    Indian/Kerguelen (Timezone)
  8. Eastern
    Eastern, Eastern, Fiji (State)
  9. Antananarivo
    Antananarivo, Antananarivo, Madagascar (State)
  10. Toliara
    Toliara, Toliara, Madagascar (State)

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": [
                  47.150002,
                  -19.883301
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}