18 places near Altwarmbüchen, Region Hannover, Niedersachsen, Deutschland
filter by placetype:
  1. Altwarmbüchen
    Altwarmbüchen, Region Hannover, Niedersachsen, Deutschland (Town)
  2. Hannover
    Hannover, Region Hannover, Niedersachsen, Deutschland (Town)
  3. Isernhagen
    Isernhagen, Region Hannover, Niedersachsen, Deutschland (Town)
  4. Elbe
    Elbe, Deutschland (Drainage)
  5. Weser River
    Weser River, Deutschland (Drainage)
  6. Gemeinde Isernhagen
    Gemeinde Isernhagen, Region Hannover, Niedersachsen, Deutschland (LocalAdmin)
  7. Gemeinde Sehnde
    Gemeinde Sehnde, Region Hannover, Niedersachsen, Deutschland (LocalAdmin)
  8. Stadtteil Lahe
    Stadtteil Lahe, Region Hannover, Niedersachsen, Deutschland (LocalAdmin)
  9. Region Hannover
    Region Hannover, Niedersachsen, Deutschland (County)
  10. Europe/Berlin
    Europe/Berlin (Timezone)

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

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

        
0.034 seconds ⌛

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