17 places near Hamshorn, Achtkarspelen, Friesland, Nederland
filter by placetype:
  1. Hamshorn
    Hamshorn, Achtkarspelen, Friesland, Nederland (Town)
  2. Harkema-Opeinde
    Harkema-Opeinde, Achtkarspelen, Friesland, Nederland (Town)
  3. West Friese Eilanden
    West Friese Eilanden, Nederland (Island)
  4. Achtkarspelen
    Achtkarspelen, Friesland, Nederland (County)
  5. Tytsjerksteradiel
    Tytsjerksteradiel, Friesland, Nederland (County)
  6. Europe/Amsterdam
    Europe/Amsterdam (Timezone)
  7. Europe/Berlin
    Europe/Berlin (Timezone)
  8. Friesland
    Friesland, Friesland, Nederland (State)
  9. Nederland
    Nederland, Nederland (Country)
  10. North Sea
    North Sea (Sea)

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

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

        
0.047 seconds ⌛

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