25 places near 21077, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland
  1. Appelbüttel
    Appelbüttel, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  2. Lürade
    Lürade, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  3. Beckedorf
    Beckedorf, Harburg, Niedersachsen, Deutschland (Town)
  4. Hamburg
    Hamburg, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Town)
  5. Hittfeld
    Hittfeld, Harburg, Niedersachsen, Deutschland (Town)
  6. Elbe
    Elbe, Deutschland (Drainage)
  7. Weser River
    Weser River, Deutschland (Drainage)
  8. Gemeinde Rosengarten
    Gemeinde Rosengarten, Harburg, Niedersachsen, Deutschland (LocalAdmin)
  9. Gemeinde Seevetal
    Gemeinde Seevetal, Harburg, Niedersachsen, Deutschland (LocalAdmin)
  10. Stadtteil Eißendorf
    Stadtteil Eißendorf, 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.081 seconds ⌛; show me the details?

        
0.081 seconds ⌛

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