21 places near 4120 Ellerhoop, Landkreis Pinneberg, Schleswig-Holstein, Deutschland
filter by placetype:
  1. Bentkrögen
    Bentkrögen, Landkreis Pinneberg, Schleswig-Holstein, Deutschland (Town)
  2. Ellerhoop
    Ellerhoop, Landkreis Pinneberg, Schleswig-Holstein, Deutschland (Town)
  3. Hamburg
    Hamburg, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Town)
  4. Gemeinde Seeth-Ekholt
    Gemeinde Seeth-Ekholt, Landkreis Pinneberg, Schleswig-Holstein, Deutschland (LocalAdmin)
  5. Gemeinde Hemdingen
    Gemeinde Hemdingen, Landkreis Pinneberg, Schleswig-Holstein, Deutschland (LocalAdmin)
  6. Gemeinde Bevern
    Gemeinde Bevern, Landkreis Pinneberg, Schleswig-Holstein, Deutschland (LocalAdmin)
  7. Gemeinde Ellerhoop
    Gemeinde Ellerhoop, Landkreis Pinneberg, Schleswig-Holstein, Deutschland (LocalAdmin)
  8. Landkreis Steinburg
    Landkreis Steinburg, Schleswig-Holstein, Deutschland (County)
  9. Landkreis Stade
    Landkreis Stade, Niedersachsen, Deutschland (County)
  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.049 seconds ⌛; show me the details?

        
0.049 seconds ⌛

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