24 places near Borghorst, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland
  1. Borghorst
    Borghorst, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  2. Horst
    Horst, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  3. Hamburg
    Hamburg, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Town)
  4. Stove
    Stove, Harburg, Niedersachsen, Deutschland (Town)
  5. Voßmoor
    Voßmoor, Herzogtum Lauenburg, Schleswig-Holstein, Deutschland (Town)
  6. Elbe
    Elbe, Deutschland (Drainage)
  7. Weser River
    Weser River, Deutschland (Drainage)
  8. Gemeinde Drage
    Gemeinde Drage, Harburg, Niedersachsen, Deutschland (LocalAdmin)
  9. Gemeinde Escheburg
    Gemeinde Escheburg, Herzogtum Lauenburg, Schleswig-Holstein, Deutschland (LocalAdmin)
  10. Gemeinde Geesthacht
    Gemeinde Geesthacht, Herzogtum Lauenburg, Schleswig-Holstein, Deutschland (LocalAdmin)

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

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

        
0.046 seconds ⌛

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