34 places near Oberhofen bei Kreuzlingen, Kreuzlingen, Kanton Thurgau, Schweiz
  1. Alterswilen
    Alterswilen, Kreuzlingen, Kanton Thurgau, Schweiz (Town)
  2. Siegershausen
    Siegershausen, Kreuzlingen, Kanton Thurgau, Schweiz (Town)
  3. Oberhofen
    Oberhofen, Kreuzlingen, Kanton Thurgau, Schweiz (Town)
  4. Dettighofen
    Dettighofen, Kreuzlingen, Kanton Thurgau, Schweiz (Town)
  5. Dippishausen
    Dippishausen, Kreuzlingen, Kanton Thurgau, Schweiz (Town)
  6. Illighausen
    Illighausen, Kreuzlingen, 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. Rüthof
    Rüthof, 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.023 seconds ⌛; show me the details?

        
0.023 seconds ⌛

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