17 places near Ban Hatkham, Bolikhamxai, Laos
filter by placetype:
  1. Ban Hatkham
    Ban Hatkham, Bolikhamxai, Laos (Town)
  2. Mekong River
    Mekong River, Cambodia (Drainage)
  3. Asia/Bangkok
    Asia/Bangkok (Timezone)
  4. Asia/Ho_Chi_Minh
    Asia/Ho_Chi_Minh (Timezone)
  5. Asia/Vientiane
    Asia/Vientiane (Timezone)
  6. Asia/Shanghai
    Asia/Shanghai, 中國 (Timezone)
  7. Bolikhamxai
    Bolikhamxai, Laos (State)
  8. Laos
    Laos, Laos (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.033 seconds ⌛; show me the details?

        
0.033 seconds ⌛

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