18 places near Huai, Pathum Ratchawongsa, Amnat Charoen, Thailand
filter by placetype:
  1. Huai
    Huai, Pathum Ratchawongsa, Amnat Charoen, Thailand (Town)
  2. Mekong River
    Mekong River, Cambodia (Drainage)
  3. Pathum Ratchawongsa
    Pathum Ratchawongsa, Amnat Charoen, Thailand (County)
  4. Kut Kaopun
    Kut Kaopun, Ubon Ratchathani, Thailand (County)
  5. Asia/Bangkok
    Asia/Bangkok (Timezone)
  6. Asia/Ho_Chi_Minh
    Asia/Ho_Chi_Minh (Timezone)
  7. Asia/Vientiane
    Asia/Vientiane (Timezone)
  8. Ubon Ratchathani
    Ubon Ratchathani, Ubon Ratchathani, Thailand (State)
  9. Amnat Charoen
    Amnat Charoen, Amnat Charoen, 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.016 seconds ⌛; show me the details?

        
0.016 seconds ⌛

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