24 places near Ekern, Ammerland, Niedersachsen, Deutschland
filter by placetype:
  1. Aschwege
    Aschwege, Ammerland, Niedersachsen, Deutschland (Town)
  2. Bad Zwischenahn
    Bad Zwischenahn, Ammerland, Niedersachsen, Deutschland (Town)
  3. Burgfelde
    Burgfelde, Ammerland, Niedersachsen, Deutschland (Town)
  4. Dänikhorst
    Dänikhorst, Ammerland, Niedersachsen, Deutschland (Town)
  5. Edewecht
    Edewecht, Ammerland, Niedersachsen, Deutschland (Town)
  6. Ekern
    Ekern, Ammerland, Niedersachsen, Deutschland (Town)
  7. Ohrwege
    Ohrwege, Ammerland, Niedersachsen, Deutschland (Town)
  8. Querenstede
    Querenstede, Ammerland, Niedersachsen, Deutschland (Town)
  9. Ems River
    Ems River, Deutschland (Drainage)
  10. Gemeinde Bad Zwischenahn
    Gemeinde Bad Zwischenahn, Ammerland, Niedersachsen, Deutschland (LocalAdmin)

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

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

        
0.03 seconds ⌛

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