4 places near Stadtteil Ottensen, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland
filter by placetype:
  1. Hamburg-Altona
    Hamburg-Altona, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  2. Klein Dradenau
    Klein Dradenau, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  3. Neumühlen
    Neumühlen, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  4. Teufelsbrück
    Teufelsbrück, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)

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

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

        
0.016 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  9.91952,
                  53.5513
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 22
          }
        }
      ],
      "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"
      }
    }
  ]
}