17 places near Spekendorf, Landkreis Aurich, Niedersachsen, Deutschland
filter by placetype:
  1. Middels-Westerloog
    Middels-Westerloog, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  2. Spekendorf
    Spekendorf, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  3. Middels-Osterloog
    Middels-Osterloog, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  4. Gemeinde Aurich
    Gemeinde Aurich, Landkreis Aurich, Niedersachsen, Deutschland (LocalAdmin)
  5. Ostfriesland
    Ostfriesland, Niedersachsen, Deutschland (Colloquial)
  6. Landkreis Aurich
    Landkreis Aurich, Niedersachsen, Deutschland (County)
  7. Landkreis Wittmund
    Landkreis Wittmund, 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.03 seconds ⌛; show me the details?

        
0.03 seconds ⌛

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