4 places near U Lutterothstrasse Bahnhof, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland
filter by placetype:
  1. Stadtteil Stellingen
    Stadtteil Stellingen, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (LocalAdmin)
  2. Stadtteil Lokstedt
    Stadtteil Lokstedt, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (LocalAdmin)
  3. Stadtteil Eimsbüttel
    Stadtteil Eimsbüttel, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (LocalAdmin)
  4. Hoheluft-West
    Hoheluft-West, 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.08 seconds ⌛; show me the details?

        
0.08 seconds ⌛

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