20 places near 4221 Delmenhorst, Niedersachsen, Deutschland
filter by placetype:
  1. Bremen
    Bremen, Stadtkreis Bremen, Freie Hansestadt Bremen, Deutschland (Town)
  2. Delmenhorst
    Delmenhorst, Stadtkreis Delmenhorst, Niedersachsen, Deutschland (Town)
  3. Weser River
    Weser River, Deutschland (Drainage)
  4. Gemeinde Delmenhorst
    Gemeinde Delmenhorst, Stadtkreis Delmenhorst, Niedersachsen, Deutschland (LocalAdmin)
  5. Gemeinde Ganderkesee
    Gemeinde Ganderkesee, Landkreis Oldenburg, Niedersachsen, Deutschland (LocalAdmin)
  6. Gemeinde Stuhr
    Gemeinde Stuhr, Landkreis Diepholz, Niedersachsen, Deutschland (LocalAdmin)
  7. Landkreis Diepholz
    Landkreis Diepholz, Niedersachsen, Deutschland (County)
  8. Landkreis Oldenburg
    Landkreis Oldenburg, Niedersachsen, Deutschland (County)
  9. Stadtkreis Delmenhorst
    Stadtkreis Delmenhorst, Niedersachsen, Deutschland (County)
  10. Stadtkreis Bremen
    Stadtkreis Bremen, Freie Hansestadt Bremen, Deutschland (County)

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

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

        
0.018 seconds ⌛

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