24 places near 22147, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland
filter by placetype:
  1. Berne
    Berne, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  2. Dänenheide
    Dänenheide, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  3. Farmsen
    Farmsen, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  4. Fernsicht
    Fernsicht, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  5. Hellbrook
    Hellbrook, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  6. Meiendorf
    Meiendorf, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  7. Saselheide
    Saselheide, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  8. Tonndorf Lohe
    Tonndorf Lohe, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  9. Hamburg
    Hamburg, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Town)
  10. Farmsen-Berne
    Farmsen-Berne, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (LocalAdmin)

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

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

        
0.076 seconds ⌛

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