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

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

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

        
0.047 seconds ⌛

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