22 places near Stadtteil Altenwerder, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland
  1. Stadtkreis Hamburg
    Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (County)
  2. Harburg
    Harburg, Niedersachsen, Deutschland (County)
  3. Europe/Berlin
    Europe/Berlin (Timezone)
  4. Freie und Hansestadt Hamburg
    Freie und Hansestadt Hamburg, Freie und Hansestadt Hamburg, Deutschland (State)
  5. Schleswig-Holstein
    Schleswig-Holstein, Schleswig-Holstein, Deutschland (State)
  6. Deutschland
    Deutschland, Deutschland (Country)
  7. Atlantic Ocean
    Atlantic Ocean (Ocean)
  8. Pacific Ocean
    Pacific Ocean (Ocean)
  9. Europe
    Europe (Continent)
  10. Western Europe
    Western Europe (Supername)

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

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

        
0.021 seconds ⌛

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