33 places near Hattenhausen, Kreuzlingen, Kanton Thurgau, Schweiz
  1. Rhein
    Rhein, Deutschland (Drainage)
  2. Donau
    Donau, Magyarország (Drainage)
  3. Raperswilen
    Raperswilen, Steckborn, Kanton Thurgau, Schweiz (LocalAdmin)
  4. Wäldi
    Wäldi, Kreuzlingen, Kanton Thurgau, Schweiz (LocalAdmin)
  5. Wigoltingen
    Wigoltingen, Weinfelden, Kanton Thurgau, Schweiz (LocalAdmin)
  6. Bodensee
    Bodensee, Baden-Württemberg, Deutschland (Colloquial)
  7. Alps
    Alps (Colloquial)
  8. Kreuzlingen
    Kreuzlingen, Kanton Thurgau, Schweiz (County)
  9. Weinfelden
    Weinfelden, Kanton Thurgau, Schweiz (County)
  10. Steckborn
    Steckborn, Kanton Thurgau, Schweiz (County)

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

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

        
0.032 seconds ⌛

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