20 places near Gemeinde Hambühren, Landkreis Celle, Niedersachsen, Deutschland
filter by placetype:
  1. Hambühren
    Hambühren, Landkreis Celle, Niedersachsen, Deutschland (Town)
  2. Ovelgönne
    Ovelgönne, Landkreis Celle, Niedersachsen, Deutschland (Town)
  3. Schonhop
    Schonhop, Landkreis Celle, Niedersachsen, Deutschland (Town)
  4. Rixförde
    Rixförde, Landkreis Celle, Niedersachsen, Deutschland (Town)
  5. Allerhop
    Allerhop, Landkreis Celle, Niedersachsen, Deutschland (Town)
  6. Elbe
    Elbe, Deutschland (Drainage)
  7. Weser River
    Weser River, Deutschland (Drainage)
  8. Gemeinde Hambühren
    Gemeinde Hambühren, Landkreis Celle, Niedersachsen, Deutschland (LocalAdmin)
  9. Landkreis Celle
    Landkreis Celle, Niedersachsen, Deutschland (County)
  10. Soltau-Fallingbostel
    Soltau-Fallingbostel, Niedersachsen, Deutschland (County)

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

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

        
0.034 seconds ⌛

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