20 places near Koldehörn, Landkreis Aurich, Niedersachsen, Deutschland
filter by placetype:
  1. Aurich
    Aurich, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  2. Eschen
    Eschen, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  3. Koldehörn
    Koldehörn, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  4. Neu Sandhorst
    Neu Sandhorst, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  5. Sandhorst
    Sandhorst, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  6. Wallinghausen
    Wallinghausen, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  7. Gemeinde Aurich
    Gemeinde Aurich, Landkreis Aurich, Niedersachsen, Deutschland (LocalAdmin)
  8. Ostfriesland
    Ostfriesland, Niedersachsen, Deutschland (Colloquial)
  9. Landkreis Aurich
    Landkreis Aurich, Niedersachsen, Deutschland (County)
  10. Landkreis Wittmund
    Landkreis Wittmund, Niedersachsen, Deutschland (County)

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

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

        
0.04 seconds ⌛

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