24 places near Hoheluft-West, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland
filter by placetype:
  1. Stadtteil Eppendorf
    Stadtteil Eppendorf, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (LocalAdmin)
  2. Hoheluft-Ost
    Hoheluft-Ost, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (LocalAdmin)
  3. Stadtkreis Hamburg
    Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (County)
  4. Landkreis Pinneberg
    Landkreis Pinneberg, Schleswig-Holstein, Deutschland (County)
  5. Europe/Berlin
    Europe/Berlin (Timezone)
  6. Freie und Hansestadt Hamburg
    Freie und Hansestadt Hamburg, Freie und Hansestadt Hamburg, Deutschland (State)
  7. Schleswig-Holstein
    Schleswig-Holstein, Schleswig-Holstein, Deutschland (State)
  8. Deutschland
    Deutschland, Deutschland (Country)
  9. Atlantic Ocean
    Atlantic Ocean (Ocean)
  10. Pacific Ocean
    Pacific Ocean (Ocean)

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

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

        
0.043 seconds ⌛

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