16 places near Ban Tha Kwian, Watthana Nakhon, Sa Kaeo, Thailand
filter by placetype:
  1. Ban Tha Kwian
    Ban Tha Kwian, Watthana Nakhon, Sa Kaeo, Thailand (Town)
  2. Mekong River
    Mekong River, Cambodia (Drainage)
  3. Aranyaprathet
    Aranyaprathet, Sa Kaeo, Thailand (County)
  4. Watthana Nakhon
    Watthana Nakhon, Sa Kaeo, Thailand (County)
  5. Khlong Hat
    Khlong Hat, Sa Kaeo, Thailand (County)
  6. Asia/Bangkok
    Asia/Bangkok (Timezone)
  7. Asia/Ho_Chi_Minh
    Asia/Ho_Chi_Minh (Timezone)
  8. Sa Kaeo
    Sa Kaeo, Thailand (State)
  9. Thailand
    Thailand, Thailand (Country)
  10. Indian Ocean
    Indian Ocean (Ocean)

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

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

        
0.024 seconds ⌛

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