16 places near Ambatofisaorana, Manjakandriana, Antananarivo, Madagascar
filter by placetype:
  1. Ambatofisaorana
    Ambatofisaorana, Manjakandriana, Antananarivo, Madagascar (Town)
  2. Madagascar
    Madagascar, Madagascar (Island)
  3. Anjozorobe
    Anjozorobe, Antananarivo, Madagascar (County)
  4. Antananarivo Avaradrano
    Antananarivo Avaradrano, Antananarivo, Madagascar (County)
  5. Manjakandriana
    Manjakandriana, Antananarivo, Madagascar (County)
  6. Indian/Antananarivo
    Indian/Antananarivo (Timezone)
  7. Indian/Kerguelen
    Indian/Kerguelen (Timezone)
  8. Eastern
    Eastern, Eastern, Fiji (State)
  9. Mahajanga
    Mahajanga, Mahajanga, Madagascar (State)
  10. Toamasina
    Toamasina, Toamasina, Madagascar (State)

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

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

        
0.02 seconds ⌛

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