18 places near 29225, Landkreis Celle, Niedersachsen, Deutschland
filter by placetype:
  1. Celle
    Celle, Landkreis Celle, Niedersachsen, Deutschland (Town)
  2. Wietzenbruch
    Wietzenbruch, Landkreis Celle, Niedersachsen, Deutschland (Town)
  3. Elbe
    Elbe, Deutschland (Drainage)
  4. Weser River
    Weser River, Deutschland (Drainage)
  5. Gemeinde Celle
    Gemeinde Celle, Landkreis Celle, Niedersachsen, Deutschland (LocalAdmin)
  6. Gemeinde Hambühren
    Gemeinde Hambühren, Landkreis Celle, Niedersachsen, Deutschland (LocalAdmin)
  7. Landkreis Celle
    Landkreis Celle, Niedersachsen, Deutschland (County)
  8. Soltau-Fallingbostel
    Soltau-Fallingbostel, Niedersachsen, Deutschland (County)
  9. Region Hannover
    Region Hannover, 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.025 seconds ⌛; show me the details?

        
0.025 seconds ⌛

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