26 places near Gemeinde Spenge, Landkreis Herford, Nordrhein-Westfalen, Deutschland
filter by placetype:
  1. Ems River
    Ems River, Deutschland (Drainage)
  2. Weser River
    Weser River, Deutschland (Drainage)
  3. Gemeinde Spenge
    Gemeinde Spenge, Landkreis Herford, Nordrhein-Westfalen, Deutschland (LocalAdmin)
  4. Gemeinde Melle
    Gemeinde Melle, Landkreis Osnabrück, Niedersachsen, Deutschland (LocalAdmin)
  5. Landkreis Osnabrück
    Landkreis Osnabrück, Niedersachsen, Deutschland (County)
  6. Landkreis Herford
    Landkreis Herford, Nordrhein-Westfalen, Deutschland (County)
  7. Europe/Berlin
    Europe/Berlin (Timezone)
  8. Nordrhein-Westfalen
    Nordrhein-Westfalen, Nordrhein-Westfalen, Deutschland (State)
  9. Deutschland
    Deutschland, Deutschland (Country)
  10. North Sea
    North Sea (Sea)

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

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

        
0.039 seconds ⌛

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