20 places near Waldhof, Landkreis Celle, Niedersachsen, Deutschland
filter by placetype:
  1. Hassel
    Hassel, Landkreis Celle, Niedersachsen, Deutschland (Town)
  2. Katensen
    Katensen, Landkreis Celle, Niedersachsen, Deutschland (Town)
  3. Sülze
    Sülze, Landkreis Celle, Niedersachsen, Deutschland (Town)
  4. Waldhof
    Waldhof, Landkreis Celle, Niedersachsen, Deutschland (Town)
  5. Elbe
    Elbe, Deutschland (Drainage)
  6. Weser River
    Weser River, Deutschland (Drainage)
  7. Gemeinde Winsen
    Gemeinde Winsen, Landkreis Celle, Niedersachsen, Deutschland (LocalAdmin)
  8. Gemeinde Bergen
    Gemeinde Bergen, Landkreis Celle, Niedersachsen, Deutschland (LocalAdmin)
  9. Gemeinde Hermannsburg
    Gemeinde Hermannsburg, Landkreis Celle, Niedersachsen, Deutschland (LocalAdmin)
  10. Landkreis Celle
    Landkreis Celle, Niedersachsen, Deutschland (County)

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

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

        
0.037 seconds ⌛

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