16 places near 105, Ambohidratrimo, Antananarivo, Madagascar
filter by placetype:
  1. Madagascar
    Madagascar, Madagascar (Island)
  2. Ambohidratrimo
    Ambohidratrimo, Antananarivo, Madagascar (County)
  3. Anjozorobe
    Anjozorobe, Antananarivo, Madagascar (County)
  4. Antananarivo Avaradrano
    Antananarivo Avaradrano, Antananarivo, Madagascar (County)
  5. Ankazobe
    Ankazobe, 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. Antananarivo
    Antananarivo, Antananarivo, Madagascar (State)

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

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

        
0.021 seconds ⌛

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