25 places near Spiekershausen, Landkreis Göttingen, Niedersachsen, Deutschland
  1. Hasenhecke
    Hasenhecke, Stadtkreis Kassel, Hessen, Deutschland (Suburb)
  2. Wolfsanger/hasenhecke
    Wolfsanger/hasenhecke, Stadtkreis Kassel, Hessen, Deutschland (Suburb)
  3. Kassel
    Kassel, Stadtkreis Kassel, Hessen, Deutschland (Town)
  4. Spiekershausen
    Spiekershausen, Landkreis Göttingen, Niedersachsen, Deutschland (Town)
  5. Wahnhausen
    Wahnhausen, Landkreis Kassel, Hessen, Deutschland (Town)
  6. Rhein
    Rhein, Deutschland (Drainage)
  7. Weser River
    Weser River, Deutschland (Drainage)
  8. Gemeinde Staufenberg
    Gemeinde Staufenberg, Landkreis Göttingen, Niedersachsen, Deutschland (LocalAdmin)
  9. Gemeinde Fuldatal
    Gemeinde Fuldatal, Landkreis Kassel, Hessen, Deutschland (LocalAdmin)
  10. Gemeinde Niestetal
    Gemeinde Niestetal, Landkreis Kassel, Hessen, Deutschland (LocalAdmin)

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

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

        
0.029 seconds ⌛

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