22 places near Gemeinde Colnrade, Landkreis Oldenburg, Niedersachsen, Deutschland
filter by placetype:
  1. Austen
    Austen, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  2. Beckstedt
    Beckstedt, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  3. Colnrade
    Colnrade, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  4. Duveneck
    Duveneck, Landkreis Diepholz, Niedersachsen, Deutschland (Town)
  5. Holtorf
    Holtorf, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  6. Ostersehlt
    Ostersehlt, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  7. Weser River
    Weser River, Deutschland (Drainage)
  8. Gemeinde Colnrade
    Gemeinde Colnrade, Landkreis Oldenburg, Niedersachsen, Deutschland (LocalAdmin)
  9. Gemeinde Winkelsett
    Gemeinde Winkelsett, Landkreis Oldenburg, Niedersachsen, Deutschland (LocalAdmin)
  10. Gemeinde Twistringen
    Gemeinde Twistringen, Landkreis Diepholz, Niedersachsen, Deutschland (LocalAdmin)

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

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

        
0.04 seconds ⌛

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