21 places near Groß Roscharden, Landkreis Cloppenburg, Niedersachsen, Deutschland
filter by placetype:
  1. Gingermühlen
    Gingermühlen, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  2. Groß Roscharden
    Groß Roscharden, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  3. Klein Roscharden
    Klein Roscharden, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  4. Lastrup
    Lastrup, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  5. Oldendorf
    Oldendorf, Landkreis Cloppenburg, Niedersachsen, Deutschland (Town)
  6. Ems River
    Ems River, Deutschland (Drainage)
  7. Gemeinde Lastrup
    Gemeinde Lastrup, Landkreis Cloppenburg, Niedersachsen, Deutschland (LocalAdmin)
  8. Gemeinde Lindern
    Gemeinde Lindern, 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.025 seconds ⌛; show me the details?

        
0.025 seconds ⌛

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