18 places near Halenhorst, Landkreis Oldenburg, Niedersachsen, Deutschland
filter by placetype:
  1. Charlottendorf West
    Charlottendorf West, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  2. Halenhorst
    Halenhorst, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  3. Im Lager
    Im Lager, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  4. Ems River
    Ems River, Deutschland (Drainage)
  5. Gemeinde Großenkneten
    Gemeinde Großenkneten, Landkreis Oldenburg, Niedersachsen, Deutschland (LocalAdmin)
  6. Gemeinde Wardenburg
    Gemeinde Wardenburg, Landkreis Oldenburg, Niedersachsen, Deutschland (LocalAdmin)
  7. Landkreis Oldenburg
    Landkreis Oldenburg, Niedersachsen, Deutschland (County)
  8. Landkreis Cloppenburg
    Landkreis Cloppenburg, Niedersachsen, Deutschland (County)
  9. Europe/Berlin
    Europe/Berlin (Timezone)
  10. Niedersachsen
    Niedersachsen, Niedersachsen, Deutschland (State)

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

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

        
0.042 seconds ⌛

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