26 places near Hoisbüttel, Stormarn, Schleswig-Holstein, Deutschland
filter by placetype:
  1. Rothenbek
    Rothenbek, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  2. Trillup
    Trillup, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  3. Wohldorferweg
    Wohldorferweg, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  4. Hamburg
    Hamburg, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Town)
  5. Hoisbüttel
    Hoisbüttel, Stormarn, Schleswig-Holstein, Deutschland (Town)
  6. Laberg
    Laberg, Stormarn, Schleswig-Holstein, Deutschland (Town)
  7. Ammersbek
    Ammersbek, Stormarn, Schleswig-Holstein, Deutschland (Town)
  8. Lottbek
    Lottbek, Stormarn, Schleswig-Holstein, Deutschland (Town)
  9. Lehmkuhle
    Lehmkuhle, Stormarn, Schleswig-Holstein, Deutschland (Town)
  10. Gemeinde Ammersbek
    Gemeinde Ammersbek, Stormarn, Schleswig-Holstein, Deutschland (LocalAdmin)

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

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

        
0.031 seconds ⌛

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