25 places near Stellau, Stormarn, Schleswig-Holstein, Deutschland
filter by placetype:
  1. Dänenheide
    Dänenheide, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  2. Fernsicht
    Fernsicht, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  3. Tonndorf Lohe
    Tonndorf Lohe, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  4. Braak
    Braak, Stormarn, Schleswig-Holstein, Deutschland (Town)
  5. Hamburg
    Hamburg, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Town)
  6. Stapelfeld
    Stapelfeld, Stormarn, Schleswig-Holstein, Deutschland (Town)
  7. Stellau
    Stellau, Stormarn, Schleswig-Holstein, Deutschland (Town)
  8. Stemwarde
    Stemwarde, Stormarn, Schleswig-Holstein, Deutschland (Town)
  9. Braaker Mühle
    Braaker Mühle, Stormarn, Schleswig-Holstein, Deutschland (Town)
  10. Gemeinde Barsbüttel
    Gemeinde Barsbüttel, Stormarn, Schleswig-Holstein, Deutschland (LocalAdmin)

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

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

        
0.102 seconds ⌛

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