26 places near 21039, Freie und Hansestadt Hamburg, Deutschland
  1. Achterdeich
    Achterdeich, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  2. Borghorst
    Borghorst, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  3. Horst
    Horst, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  4. Börnsen
    Börnsen, Herzogtum Lauenburg, Schleswig-Holstein, Deutschland (Town)
  5. Escheburg
    Escheburg, Herzogtum Lauenburg, Schleswig-Holstein, Deutschland (Town)
  6. Hamburg
    Hamburg, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Town)
  7. Voßmoor
    Voßmoor, Herzogtum Lauenburg, Schleswig-Holstein, Deutschland (Town)
  8. Elbe
    Elbe, Deutschland (Drainage)
  9. Weser River
    Weser River, Deutschland (Drainage)
  10. Gemeinde Börnsen
    Gemeinde Börnsen, Herzogtum Lauenburg, Schleswig-Holstein, Deutschland (LocalAdmin)

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

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

        
0.032 seconds ⌛

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