17 places near Mehrenkamp, Landkreis Cloppenburg, Niedersachsen, Deutschland
filter by placetype:
  1. Eggershausen
    Eggershausen, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  2. Friesoythe
    Friesoythe, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  3. Mehrenkamp
    Mehrenkamp, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  4. Ems River
    Ems River, Deutschland (Drainage)
  5. Gemeinde Friesoythe
    Gemeinde Friesoythe, Landkreis Cloppenburg, Niedersachsen, Deutschland (LocalAdmin)
  6. Landkreis Cloppenburg
    Landkreis Cloppenburg, Niedersachsen, Deutschland (County)
  7. Landkreis Leer
    Landkreis Leer, 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.027 seconds ⌛; show me the details?

        
0.027 seconds ⌛

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