20 places near Etzhorn, Stadtkreis Oldenburg, Niedersachsen, Deutschland
filter by placetype:
  1. Etzhorn
    Etzhorn, Stadtkreis Oldenburg, Niedersachsen, Deutschland (Town)
  2. Großbornhorst
    Großbornhorst, Stadtkreis Oldenburg, Niedersachsen, Deutschland (Town)
  3. Oldenburg
    Oldenburg, Stadtkreis Oldenburg, Niedersachsen, Deutschland (Town)
  4. Ems River
    Ems River, Deutschland (Drainage)
  5. Gemeinde Oldenburg
    Gemeinde Oldenburg, Stadtkreis Oldenburg, Niedersachsen, Deutschland (LocalAdmin)
  6. Gemeinde Rastede
    Gemeinde Rastede, Ammerland, Niedersachsen, Deutschland (LocalAdmin)
  7. Wesermarsch
    Wesermarsch, Niedersachsen, Deutschland (County)
  8. Landkreis Cloppenburg
    Landkreis Cloppenburg, Niedersachsen, Deutschland (County)
  9. Stadtkreis Oldenburg
    Stadtkreis Oldenburg, Niedersachsen, Deutschland (County)
  10. Ammerland
    Ammerland, Niedersachsen, Deutschland (County)

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

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

        
0.022 seconds ⌛

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