21 places near Dreibeken, Landkreis Pinneberg, Schleswig-Holstein, Deutschland
filter by placetype:
  1. Dreibeken
    Dreibeken, Landkreis Pinneberg, Schleswig-Holstein, Deutschland (Town)
  2. Ellerau
    Ellerau, Segeberg, Schleswig-Holstein, Deutschland (Town)
  3. Friedrichsgabe
    Friedrichsgabe, Segeberg, Schleswig-Holstein, Deutschland (Town)
  4. Hamburg
    Hamburg, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Town)
  5. Norderstedt
    Norderstedt, Segeberg, Schleswig-Holstein, Deutschland (Town)
  6. Quickbornerheide
    Quickbornerheide, Landkreis Pinneberg, Schleswig-Holstein, Deutschland (Town)
  7. Rhen
    Rhen, Segeberg, Schleswig-Holstein, Deutschland (Town)
  8. Gemeinde Norderstedt
    Gemeinde Norderstedt, Segeberg, Schleswig-Holstein, Deutschland (LocalAdmin)
  9. Gemeinde Quickborn
    Gemeinde Quickborn, Landkreis Pinneberg, Schleswig-Holstein, Deutschland (LocalAdmin)
  10. Stadtkreis Hamburg
    Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (County)

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

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

        
0.018 seconds ⌛

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