7 places near 22043, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland
filter by placetype:
  1. Hamburg-Nord
    Hamburg-Nord, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  2. Hamburg-Wandsbek
    Hamburg-Wandsbek, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  3. Hinschenfelde
    Hinschenfelde, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  4. Kirchsteinbek
    Kirchsteinbek, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  5. Öjendorf
    Öjendorf, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  6. Schiffbek
    Schiffbek, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Suburb)
  7. Steinfurth
    Steinfurth, 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.098 seconds ⌛; show me the details?

        
0.098 seconds ⌛

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