4 places near Stadtteil Waltershof, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland
filter by placetype:
  1. Stadtteil Othmarschen
    Stadtteil Othmarschen, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (LocalAdmin)
  2. Stadtteil Francop
    Stadtteil Francop, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (LocalAdmin)
  3. Stadtteil Waltershof
    Stadtteil Waltershof, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (LocalAdmin)
  4. Stadtteil Ottensen
    Stadtteil Ottensen, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (LocalAdmin)

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

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

        
0.052 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  9.89813,
                  53.530602
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 10
          }
        }
      ],
      "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"
      }
    }
  ]
}