22 places near Spijkerboor, Aa en Hunze, Drenthe, Nederland
filter by placetype:
  1. Annen
    Annen, Aa en Hunze, Drenthe, Nederland (Town)
  2. Annerveenschekanaal
    Annerveenschekanaal, Aa en Hunze, Drenthe, Nederland (Town)
  3. Nieuw Annerveen
    Nieuw Annerveen, Aa en Hunze, Drenthe, Nederland (Town)
  4. Oud-Annerveen
    Oud-Annerveen, Aa en Hunze, Drenthe, Nederland (Town)
  5. Spijkerboor
    Spijkerboor, Aa en Hunze, Drenthe, Nederland (Town)
  6. Annerveen
    Annerveen, Aa en Hunze, Drenthe, Nederland (Town)
  7. Aa en Hunze
    Aa en Hunze, Drenthe, Nederland (County)
  8. Hoogezand-Sappemeer
    Hoogezand-Sappemeer, Groningen, Nederland (County)
  9. Tynaarlo
    Tynaarlo, Drenthe, Nederland (County)
  10. Europe/Amsterdam
    Europe/Amsterdam (Timezone)

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

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

        
0.03 seconds ⌛

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