17 places near Phing Phuai, Si Rattana, Sisaket, Thailand
filter by placetype:
  1. Phing Phuai
    Phing Phuai, Si Rattana, Sisaket, Thailand (Town)
  2. Mekong River
    Mekong River, Cambodia (Drainage)
  3. Si Rattana
    Si Rattana, Sisaket, 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. Ubon Ratchathani
    Ubon Ratchathani, Ubon Ratchathani, 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": [
                  104.436867,
                  14.75563
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}