16 places near 31252, Region Hannover, Niedersachsen, Deutschland
filter by placetype:
  1. Lehrte Bahnhof
    Lehrte Bahnhof, Region Hannover, Niedersachsen, Deutschland (POI)
  2. Lehrte
    Lehrte, Region Hannover, Niedersachsen, Deutschland (Town)
  3. Elbe
    Elbe, Deutschland (Drainage)
  4. Weser River
    Weser River, Deutschland (Drainage)
  5. Gemeinde Lehrte
    Gemeinde Lehrte, Region Hannover, Niedersachsen, Deutschland (LocalAdmin)
  6. Gemeinde Sehnde
    Gemeinde Sehnde, Region Hannover, Niedersachsen, Deutschland (LocalAdmin)
  7. Region Hannover
    Region Hannover, Niedersachsen, Deutschland (County)
  8. Europe/Berlin
    Europe/Berlin (Timezone)
  9. Niedersachsen
    Niedersachsen, Niedersachsen, Deutschland (State)
  10. Deutschland
    Deutschland, Deutschland (Country)

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

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

        
0.056 seconds ⌛

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