18 places near Ban Tha Hai, Khueang Nai, Ubon Ratchathani, Thailand
filter by placetype:
  1. Ban Tha Hai
    Ban Tha Hai, Khueang Nai, Ubon Ratchathani, Thailand (Town)
  2. Mekong River
    Mekong River, Cambodia (Drainage)
  3. Khueang Nai
    Khueang Nai, Ubon Ratchathani, Thailand (County)
  4. Asia/Bangkok
    Asia/Bangkok (Timezone)
  5. Asia/Ho_Chi_Minh
    Asia/Ho_Chi_Minh (Timezone)
  6. Asia/Vientiane
    Asia/Vientiane (Timezone)
  7. Sisaket
    Sisaket, Sisaket, Thailand (State)
  8. Yasothon
    Yasothon, Yasothon, Thailand (State)
  9. Ubon Ratchathani
    Ubon Ratchathani, Ubon Ratchathani, Thailand (State)
  10. Thailand
    Thailand, Thailand (Country)

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

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

        
0.157 seconds ⌛

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