14 places near Ban Khlong Phai, Sikhio, Nakhon Ratchasima, Thailand
filter by placetype:
  1. Ban Khlong Phai
    Ban Khlong Phai, Sikhio, Nakhon Ratchasima, Thailand (Town)
  2. Mekong River
    Mekong River, Cambodia (Drainage)
  3. Sikhio
    Sikhio, Nakhon Ratchasima, Thailand (County)
  4. Asia/Bangkok
    Asia/Bangkok (Timezone)
  5. Asia/Vientiane
    Asia/Vientiane (Timezone)
  6. Nakhon Ratchasima
    Nakhon Ratchasima, Nakhon Ratchasima, Thailand (State)
  7. Thailand
    Thailand, Thailand (Country)
  8. Indian Ocean
    Indian Ocean (Ocean)
  9. Pacific Ocean
    Pacific Ocean (Ocean)
  10. Asia
    Asia (Continent)

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

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

        
0.031 seconds ⌛

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