16 places near Pho Sai, Ubon Ratchathani, Thailand
filter by placetype:
  1. Mekong River
    Mekong River, Cambodia (Drainage)
  2. Pho Sai
    Pho Sai, Ubon Ratchathani, Thailand (County)
  3. Asia/Bangkok
    Asia/Bangkok (Timezone)
  4. Asia/Ho_Chi_Minh
    Asia/Ho_Chi_Minh (Timezone)
  5. Asia/Vientiane
    Asia/Vientiane (Timezone)
  6. Ubon Ratchathani
    Ubon Ratchathani, Ubon Ratchathani, Thailand (State)
  7. Salavan
    Salavan, Laos (State)
  8. Thailand
    Thailand, Thailand (Country)
  9. Indian Ocean
    Indian Ocean (Ocean)
  10. South China Sea
    South China Sea (Sea)

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

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

        
0.028 seconds ⌛

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