18 places near Hetendorf, Landkreis Celle, Niedersachsen, Deutschland
filter by placetype:
  1. Bonstorf
    Bonstorf, Landkreis Celle, Niedersachsen, Deutschland (Town)
  2. Hetendorf
    Hetendorf, Landkreis Celle, Niedersachsen, Deutschland (Town)
  3. Elbe
    Elbe, Deutschland (Drainage)
  4. Weser River
    Weser River, Deutschland (Drainage)
  5. Gemeinde Bergen
    Gemeinde Bergen, Landkreis Celle, Niedersachsen, Deutschland (LocalAdmin)
  6. Gemeinde Hermannsburg
    Gemeinde Hermannsburg, Landkreis Celle, Niedersachsen, Deutschland (LocalAdmin)
  7. Gemeinde Wietzendorf
    Gemeinde Wietzendorf, Soltau-Fallingbostel, Niedersachsen, Deutschland (LocalAdmin)
  8. Landkreis Celle
    Landkreis Celle, Niedersachsen, Deutschland (County)
  9. Soltau-Fallingbostel
    Soltau-Fallingbostel, 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.018 seconds ⌛; show me the details?

        
0.018 seconds ⌛

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