17 places near Markhausen, Landkreis Cloppenburg, Niedersachsen, Deutschland
filter by placetype:
  1. Markhausen
    Markhausen, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  2. Ems River
    Ems River, Deutschland (Drainage)
  3. Gemeinde Friesoythe
    Gemeinde Friesoythe, Landkreis Cloppenburg, Niedersachsen, Deutschland (LocalAdmin)
  4. Gemeinde Molbergen
    Gemeinde Molbergen, Landkreis Cloppenburg, Niedersachsen, Deutschland (LocalAdmin)
  5. Gemeinde Vrees
    Gemeinde Vrees, Emsland, Niedersachsen, Deutschland (LocalAdmin)
  6. Emsland
    Emsland, Niedersachsen, Deutschland (County)
  7. Landkreis Cloppenburg
    Landkreis Cloppenburg, Niedersachsen, Deutschland (County)
  8. Europe/Berlin
    Europe/Berlin (Timezone)
  9. Niedersachsen
    Niedersachsen, Niedersachsen, Deutschland (State)
  10. Deutschland
    Deutschland, Deutschland (Country)

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

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

        
0.033 seconds ⌛

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