39 places near Roggwil, Arbon, Kanton Thurgau, Schweiz
  1. Roggwil
    Roggwil, Arbon, Kanton Thurgau, Schweiz (Town)
  2. Freidorf
    Freidorf, Arbon, Kanton Thurgau, Schweiz (Town)
  3. Berg
    Berg, Rorschach, Kanton St. Gallen, Schweiz (Town)
  4. Baumannshaus
    Baumannshaus, Arbon, Kanton Thurgau, Schweiz (Town)
  5. Esserswil
    Esserswil, Arbon, Kanton Thurgau, Schweiz (Town)
  6. Hahnberg
    Hahnberg, Rorschach, Kanton St. Gallen, Schweiz (Town)
  7. Riedern
    Riedern, Arbon, Kanton Thurgau, Schweiz (Town)
  8. Stachen
    Stachen, Arbon, Kanton Thurgau, Schweiz (Town)
  9. Watt bei Roggwil
    Watt bei Roggwil, Arbon, Kanton Thurgau, Schweiz (Town)
  10. Bühlhof
    Bühlhof, Arbon, Kanton Thurgau, Schweiz (Town)

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

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

        
0.029 seconds ⌛

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