27 places near Drennhausen, Harburg, Niedersachsen, 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. Kälbersteert
    Kälbersteert, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  5. Lange Grove
    Lange Grove, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  6. Drage
    Drage, Harburg, Niedersachsen, Deutschland (Town)
  7. Drennhausen
    Drennhausen, Harburg, Niedersachsen, Deutschland (Town)
  8. Elbstorf
    Elbstorf, Harburg, Niedersachsen, Deutschland (Town)
  9. Hamburg
    Hamburg, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Town)
  10. Elbe
    Elbe, Deutschland (Drainage)

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

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

        
0.054 seconds ⌛

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