23 places near Middelburg, Landkreis Aurich, Niedersachsen, Deutschland
filter by placetype:
  1. Aurich
    Aurich, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  2. Kirchdorf
    Kirchdorf, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  3. Middelburg
    Middelburg, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  4. Popens
    Popens, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  5. Schirum
    Schirum, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  6. Westerfeld
    Westerfeld, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  7. Schirumerfeld
    Schirumerfeld, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  8. Gemeinde Aurich
    Gemeinde Aurich, Landkreis Aurich, Niedersachsen, Deutschland (LocalAdmin)
  9. Gemeinde Großefehn
    Gemeinde Großefehn, Landkreis Aurich, Niedersachsen, Deutschland (LocalAdmin)
  10. Gemeinde Ihlow
    Gemeinde Ihlow, Landkreis Aurich, Niedersachsen, Deutschland (LocalAdmin)

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

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

        
0.06 seconds ⌛

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