3 places near Derba, Amaro Special Woreda, Southern Nations Nationalities and People's Region, Ethiopia
filter by placetype:
  1. Borena
    Borena, Oromia, Ethiopia (County)
  2. Amaro Special Woreda
    Amaro Special Woreda, Southern Nations Nationalities and People's Region, Ethiopia (County)
  3. Semen Omo
    Semen Omo, Southern Nations Nationalities and People's Region, Ethiopia (County)

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": [
                  37.890862,
                  5.83483
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 9
          }
        }
      ],
      "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"
      }
    }
  ]
}