21 places near Osterfeld, Landkreis Cloppenburg, Niedersachsen, Deutschland
filter by placetype:
  1. Bethen
    Bethen, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  2. Cloppenburg
    Cloppenburg, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  3. Höltinghausen
    Höltinghausen, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  4. Osterfeld
    Osterfeld, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  5. Ostermoor
    Ostermoor, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  6. Ems River
    Ems River, Deutschland (Drainage)
  7. Gemeinde Cloppenburg
    Gemeinde Cloppenburg, Landkreis Cloppenburg, Niedersachsen, Deutschland (LocalAdmin)
  8. Gemeinde Emstek
    Gemeinde Emstek, Landkreis Cloppenburg, Niedersachsen, Deutschland (LocalAdmin)
  9. Landkreis Oldenburg
    Landkreis Oldenburg, Niedersachsen, Deutschland (County)
  10. Landkreis Cloppenburg
    Landkreis Cloppenburg, Niedersachsen, Deutschland (County)

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

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

        
0.024 seconds ⌛

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