17 places near Achterhörn, Landkreis Cloppenburg, Niedersachsen, Deutschland
filter by placetype:
  1. Achterhörn
    Achterhörn, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  2. Hilkenbrook
    Hilkenbrook, Emsland, Niedersachsen, Deutschland (Town)
  3. Neuscharrel
    Neuscharrel, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  4. Ems River
    Ems River, Deutschland (Drainage)
  5. Gemeinde Friesoythe
    Gemeinde Friesoythe, Landkreis Cloppenburg, Niedersachsen, Deutschland (LocalAdmin)
  6. Emsland
    Emsland, Niedersachsen, Deutschland (County)
  7. Landkreis Cloppenburg
    Landkreis Cloppenburg, Niedersachsen, Deutschland (County)
  8. Europe/Berlin
    Europe/Berlin (Timezone)
  9. Niedersachsen
    Niedersachsen, Niedersachsen, Deutschland (State)
  10. Deutschland
    Deutschland, Deutschland (Country)

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

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

        
0.041 seconds ⌛

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