20 places near Osterhausen, Landkreis Cloppenburg, Niedersachsen, Deutschland
filter by placetype:
  1. Darrenkamp
    Darrenkamp, Landkreis Vechta, Niedersachsen, Deutschland (Town)
  2. Mintewede
    Mintewede, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  3. Nordenbrok
    Nordenbrok, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  4. Osterhausen
    Osterhausen, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  5. Schwichteler
    Schwichteler, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  6. Ems River
    Ems River, Deutschland (Drainage)
  7. Gemeinde Cappeln
    Gemeinde Cappeln, Landkreis Cloppenburg, Niedersachsen, Deutschland (LocalAdmin)
  8. Gemeinde Emstek
    Gemeinde Emstek, Landkreis Cloppenburg, Niedersachsen, Deutschland (LocalAdmin)
  9. Landkreis Cloppenburg
    Landkreis Cloppenburg, Niedersachsen, Deutschland (County)
  10. Landkreis Vechta
    Landkreis Vechta, Niedersachsen, Deutschland (County)

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": [
                  8.15685,
                  52.782459
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}