10 places near Kanton Thurgau, Kanton Thurgau, Schweiz
filter by placetype:
  1. Affeltrangen
    Affeltrangen, Münchwilen, Kanton Thurgau, Schweiz (Town)
  2. Märwil
    Märwil, Münchwilen, Kanton Thurgau, Schweiz (Town)
  3. Azenwilen
    Azenwilen, Münchwilen, Kanton Thurgau, Schweiz (Town)
  4. Buch bei Märwil
    Buch bei Märwil, Münchwilen, Kanton Thurgau, Schweiz (Town)
  5. Kaltenbrunnen
    Kaltenbrunnen, Münchwilen, Kanton Thurgau, Schweiz (Town)
  6. Maltbach
    Maltbach, Münchwilen, Kanton Thurgau, Schweiz (Town)
  7. Oberoppikon
    Oberoppikon, Weinfelden, Kanton Thurgau, Schweiz (Town)
  8. Schmidshof
    Schmidshof, Weinfelden, Kanton Thurgau, Schweiz (Town)
  9. Unteroppikon
    Unteroppikon, Weinfelden, Kanton Thurgau, Schweiz (Town)
  10. Holzhäusern
    Holzhäusern, Weinfelden, Kanton Thurgau, Schweiz (Town)

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

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

        
0.018 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  9.054,
                  47.536
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 7
          }
        }
      ],
      "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"
      }
    }
  ]
}