18 places near Mandera, North-Eastern, Kenya
filter by placetype:
  1. Mandera
    Mandera, North-Eastern, Kenya (Town)
  2. Mandera
    Mandera, North-Eastern, Kenya (Town)
  3. Liben
    Liben, Somali, Ethiopia (County)
  4. Africa/Addis_Ababa
    Africa/Addis_Ababa (Timezone)
  5. Africa/Mogadishu
    Africa/Mogadishu (Timezone)
  6. Africa/Nairobi
    Africa/Nairobi (Timezone)
  7. North-Eastern
    North-Eastern, North-Eastern, Kenya (State)
  8. Gedo
    Gedo, Gedo, Somalia (State)
  9. Oromia
    Oromia, Oromia, Ethiopia (State)
  10. Kenya
    Kenya, Kenya (Country)

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": [
                  41.860619,
                  3.93454
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}