18 places near 5132 Lehrte, Region Hannover, Niedersachsen, Deutschland
filter by placetype:
  1. Aligse
    Aligse, Region Hannover, Niedersachsen, Deutschland (Town)
  2. Ilten
    Ilten, Region Hannover, Niedersachsen, Deutschland (Town)
  3. Klein Kolshorn
    Klein Kolshorn, Region Hannover, Niedersachsen, Deutschland (Town)
  4. Lehrte
    Lehrte, Region Hannover, Niedersachsen, Deutschland (Town)
  5. Elbe
    Elbe, Deutschland (Drainage)
  6. Weser River
    Weser River, Deutschland (Drainage)
  7. Gemeinde Lehrte
    Gemeinde Lehrte, Region Hannover, Niedersachsen, Deutschland (LocalAdmin)
  8. Gemeinde Sehnde
    Gemeinde Sehnde, 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.013 seconds ⌛; show me the details?

        
0.013 seconds ⌛

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