19 places near 5084 Hambuehren, Landkreis Celle, Niedersachsen, Deutschland
filter by placetype:
  1. Hambühren
    Hambühren, Landkreis Celle, Niedersachsen, Deutschland (Town)
  2. Wietzenbruch
    Wietzenbruch, Landkreis Celle, Niedersachsen, Deutschland (Town)
  3. Schonhop
    Schonhop, Landkreis Celle, Niedersachsen, Deutschland (Town)
  4. Elbe
    Elbe, Deutschland (Drainage)
  5. Weser River
    Weser River, Deutschland (Drainage)
  6. Gemeinde Celle
    Gemeinde Celle, Landkreis Celle, Niedersachsen, Deutschland (LocalAdmin)
  7. Gemeinde Hambühren
    Gemeinde Hambühren, Landkreis Celle, Niedersachsen, Deutschland (LocalAdmin)
  8. Landkreis Celle
    Landkreis Celle, Niedersachsen, Deutschland (County)
  9. Soltau-Fallingbostel
    Soltau-Fallingbostel, Niedersachsen, Deutschland (County)
  10. Region Hannover
    Region Hannover, Niedersachsen, Deutschland (County)

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

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

        
0.016 seconds ⌛

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