17 places near Sa Kaeo, Thailand
filter by placetype:
  1. Mekong River
    Mekong River, Cambodia (Drainage)
  2. Aranyaprathet
    Aranyaprathet, Sa Kaeo, Thailand (County)
  3. Watthana Nakhon
    Watthana Nakhon, Sa Kaeo, Thailand (County)
  4. Ou Chrov
    Ou Chrov, Banteay Mean Cheay, Cambodia (County)
  5. Asia/Bangkok
    Asia/Bangkok (Timezone)
  6. Asia/Phnom_Penh
    Asia/Phnom_Penh (Timezone)
  7. Asia/Ho_Chi_Minh
    Asia/Ho_Chi_Minh (Timezone)
  8. Sa Kaeo
    Sa Kaeo, Thailand (State)
  9. Banteay Mean Cheay
    Banteay Mean Cheay, Cambodia (State)
  10. Thailand
    Thailand, Thailand (Country)

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": [
                  102.400978,
                  13.71657
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}