13 places near Antananarivo Avaradrano, Antananarivo, Madagascar
filter by placetype:
  1. Madagascar
    Madagascar, Madagascar (Island)
  2. Antananarivo Avaradrano
    Antananarivo Avaradrano, Antananarivo, Madagascar (County)
  3. Fenoarivo Be
    Fenoarivo Be, Antananarivo, 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. Antananarivo
    Antananarivo, Antananarivo, 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.013 seconds ⌛; show me the details?

        
0.013 seconds ⌛

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