35 places near Oftershausen, Kreuzlingen, Kanton Thurgau, Schweiz
  1. Alterswilen
    Alterswilen, Kreuzlingen, Kanton Thurgau, Schweiz (Town)
  2. Siegershausen
    Siegershausen, Kreuzlingen, Kanton Thurgau, Schweiz (Town)
  3. Altishausen
    Altishausen, Kreuzlingen, Kanton Thurgau, Schweiz (Town)
  4. Bommen
    Bommen, Kreuzlingen, Kanton Thurgau, Schweiz (Town)
  5. Dippishausen
    Dippishausen, Kreuzlingen, Kanton Thurgau, Schweiz (Town)
  6. Graltshausen
    Graltshausen, Weinfelden, Kanton Thurgau, Schweiz (Town)
  7. Lengwil-Oberhofen
    Lengwil-Oberhofen, Kreuzlingen, Kanton Thurgau, Schweiz (Town)
  8. Oberhofen bei Kreuzlingen
    Oberhofen bei Kreuzlingen, Kreuzlingen, Kanton Thurgau, Schweiz (Town)
  9. Oftershausen
    Oftershausen, Kreuzlingen, Kanton Thurgau, Schweiz (Town)
  10. Lengwil
    Lengwil, Kreuzlingen, Kanton Thurgau, Schweiz (Town)

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.16919,
                  47.61388
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}