6 places near Watt bei Roggwil, Arbon, Kanton Thurgau, Schweiz
filter by placetype:
  1. Egnach
    Egnach, Arbon, Kanton Thurgau, Schweiz (LocalAdmin)
  2. Häggenschwil
    Häggenschwil, Skt. Gallen, Kanton St. Gallen, Schweiz (LocalAdmin)
  3. Wittenbach
    Wittenbach, Skt. Gallen, Kanton St. Gallen, Schweiz (LocalAdmin)
  4. Roggwil
    Roggwil, Arbon, Kanton Thurgau, Schweiz (LocalAdmin)
  5. Waldkirch
    Waldkirch, Gossau, Kanton St. Gallen, Schweiz (LocalAdmin)
  6. Berg
    Berg, Rorschach, Kanton St. Gallen, Schweiz (LocalAdmin)

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

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

        
0.066 seconds ⌛

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