25 places near Museumshafen Oevelgönne, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland
filter by placetype:
  1. Museumshafen Oevelgönne
    Museumshafen Oevelgönne, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (POI)
  2. Hamburg-Altona
    Hamburg-Altona, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  3. Klein Dradenau
    Klein Dradenau, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  4. Klein Grasbrook
    Klein Grasbrook, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  5. Neumühlen
    Neumühlen, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  6. Reiherstieg
    Reiherstieg, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  7. Steinwärder
    Steinwärder, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  8. Teufelsbrück
    Teufelsbrück, 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.087 seconds ⌛; show me the details?

        
0.087 seconds ⌛

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