19 places near 4434 Colnrade, Landkreis Oldenburg, Niedersachsen, Deutschland
filter by placetype:
  1. Hölingen
    Hölingen, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  2. Kellinghausen
    Kellinghausen, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  3. Reckum
    Reckum, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  4. Winkelsett
    Winkelsett, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  5. Weser River
    Weser River, Deutschland (Drainage)
  6. Gemeinde Winkelsett
    Gemeinde Winkelsett, Landkreis Oldenburg, Niedersachsen, Deutschland (LocalAdmin)
  7. Gemeinde Twistringen
    Gemeinde Twistringen, Landkreis Diepholz, Niedersachsen, Deutschland (LocalAdmin)
  8. Landkreis Diepholz
    Landkreis Diepholz, Niedersachsen, Deutschland (County)
  9. Landkreis Oldenburg
    Landkreis Oldenburg, Niedersachsen, Deutschland (County)
  10. Europe/Berlin
    Europe/Berlin (Timezone)

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

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

        
0.019 seconds ⌛

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