17 places near Ostfriesland, Niedersachsen, Deutschland
filter by placetype:
  1. Middels-Westerloog
    Middels-Westerloog, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  2. Spekendorf
    Spekendorf, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  3. Pfalzdorf
    Pfalzdorf, 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.032 seconds ⌛; show me the details?

        
0.032 seconds ⌛

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