18 places near 31319, Region Hannover, Niedersachsen, Deutschland
filter by placetype:
  1. Ilten
    Ilten, Region Hannover, Niedersachsen, Deutschland (Town)
  2. Lehrte
    Lehrte, Region Hannover, Niedersachsen, Deutschland (Town)
  3. Köthenwald
    Köthenwald, Region Hannover, Niedersachsen, Deutschland (Town)
  4. Erichssegen
    Erichssegen, 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.035 seconds ⌛; show me the details?

        
0.035 seconds ⌛

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