26 places near 22179, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland
filter by placetype:
  1. Alstertal
    Alstertal, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  2. Barmbek
    Barmbek, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  3. Berne
    Berne, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  4. Farmsen
    Farmsen, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  5. Hellbrook
    Hellbrook, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  6. Klein Borstel
    Klein Borstel, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  7. Pfeilshof
    Pfeilshof, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  8. Saselheide
    Saselheide, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  9. Sophienhof
    Sophienhof, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  10. Hamburg
    Hamburg, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Town)

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

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

        
0.075 seconds ⌛

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