35 places near Bostelbek, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland
filter by placetype:
  1. Krusenbusch
    Krusenbusch, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  2. Moorwerder
    Moorwerder, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  3. Neu Wiedenthal
    Neu Wiedenthal, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  4. Neuhof
    Neuhof, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  5. Niedergeorgswerder
    Niedergeorgswerder, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  6. Rotehaus
    Rotehaus, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  7. Stillhorn
    Stillhorn, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  8. Bostelbek
    Bostelbek, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  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.082 seconds ⌛; show me the details?

        
0.082 seconds ⌛

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