18 places near Lehrte, Region Hannover, Niedersachsen, Deutschland
filter by placetype:
  1. Lehrte Bahnhof
    Lehrte Bahnhof, Region Hannover, Niedersachsen, Deutschland (POI)
  2. Aligse
    Aligse, Region Hannover, Niedersachsen, Deutschland (Town)
  3. Lehrte
    Lehrte, Region Hannover, Niedersachsen, Deutschland (Town)
  4. Steinwedel
    Steinwedel, 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.019 seconds ⌛; show me the details?

        
0.019 seconds ⌛

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