18 places near Stadtteil Oldhorst, Region Hannover, Niedersachsen, Deutschland
filter by placetype:
  1. Burgwedel
    Burgwedel, Region Hannover, Niedersachsen, Deutschland (Town)
  2. Klein Schillerslage
    Klein Schillerslage, Region Hannover, Niedersachsen, Deutschland (Town)
  3. Elbe
    Elbe, Deutschland (Drainage)
  4. Weser River
    Weser River, Deutschland (Drainage)
  5. Gemeinde Burgdorf
    Gemeinde Burgdorf, Region Hannover, Niedersachsen, Deutschland (LocalAdmin)
  6. Gemeinde Isernhagen
    Gemeinde Isernhagen, Region Hannover, Niedersachsen, Deutschland (LocalAdmin)
  7. Stadtteil Thönse
    Stadtteil Thönse, Region Hannover, Niedersachsen, Deutschland (LocalAdmin)
  8. Stadtteil Oldhorst
    Stadtteil Oldhorst, 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.025 seconds ⌛; show me the details?

        
0.025 seconds ⌛

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