14 places near 4725 Helgoland, Landkreis Pinneberg, Schleswig-Holstein, Deutschland
filter by placetype:
  1. Helgoland
    Helgoland, Landkreis Pinneberg, Schleswig-Holstein, Deutschland (Town)
  2. Gemeinde Helgoland
    Gemeinde Helgoland, Landkreis Pinneberg, Schleswig-Holstein, Deutschland (LocalAdmin)
  3. Nordsee
    Nordsee, Schleswig-Holstein, Deutschland (Colloquial)
  4. Helgoland
    Helgoland, Landkreis Pinneberg, Schleswig-Holstein, Deutschland (Island)
  5. Landkreis Pinneberg
    Landkreis Pinneberg, Schleswig-Holstein, Deutschland (County)
  6. Europe/Berlin
    Europe/Berlin (Timezone)
  7. Schleswig-Holstein
    Schleswig-Holstein, Schleswig-Holstein, Deutschland (State)
  8. North Sea
    North Sea (Sea)
  9. Atlantic Ocean
    Atlantic Ocean (Ocean)
  10. Pacific Ocean
    Pacific Ocean (Ocean)

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

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

        
0.023 seconds ⌛

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