22 places near Gemeinde Brande-Hörnerkirchen, Landkreis Pinneberg, Schleswig-Holstein, Deutschland
filter by placetype:
  1. Landkreis Stade
    Landkreis Stade, Niedersachsen, Deutschland (County)
  2. Stadtkreis Hamburg
    Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (County)
  3. Landkreis Pinneberg
    Landkreis Pinneberg, Schleswig-Holstein, Deutschland (County)
  4. Europe/Berlin
    Europe/Berlin (Timezone)
  5. Schleswig-Holstein
    Schleswig-Holstein, Schleswig-Holstein, Deutschland (State)
  6. Deutschland
    Deutschland, Deutschland (Country)
  7. Atlantic Ocean
    Atlantic Ocean (Ocean)
  8. Pacific Ocean
    Pacific Ocean (Ocean)
  9. Europe
    Europe (Continent)
  10. Western Europe
    Western Europe (Supername)

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

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

        
0.02 seconds ⌛

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