21 places near Madlage, Landkreis Cloppenburg, Niedersachsen, Deutschland
filter by placetype:
  1. Benstrup
    Benstrup, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  2. Gravenholt
    Gravenholt, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  3. Hammel
    Hammel, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  4. Madlage
    Madlage, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  5. Steinrieden
    Steinrieden, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  6. Duderstadt
    Duderstadt, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  7. Ems River
    Ems River, Deutschland (Drainage)
  8. Gemeinde Lastrup
    Gemeinde Lastrup, Landkreis Cloppenburg, Niedersachsen, Deutschland (LocalAdmin)
  9. Gemeinde Löningen
    Gemeinde Löningen, Landkreis Cloppenburg, Niedersachsen, Deutschland (LocalAdmin)
  10. Emsland
    Emsland, Niedersachsen, Deutschland (County)

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

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

        
0.02 seconds ⌛

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