17 places near Sanam Khli, Mueang Suphab Buri, Suphan Buri, Thailand
filter by placetype:
  1. Phlapphla Chai
    Phlapphla Chai, U Thong, Suphan Buri, Thailand (Town)
  2. Sanam Khli
    Sanam Khli, Mueang Suphab Buri, Suphan Buri, Thailand (Town)
  3. Mekong River
    Mekong River, Cambodia (Drainage)
  4. Chao River
    Chao River, Thailand (Drainage)
  5. Mueang Suphab Buri
    Mueang Suphab Buri, Suphan Buri, Thailand (County)
  6. U Thong
    U Thong, Suphan Buri, Thailand (County)
  7. Asia/Bangkok
    Asia/Bangkok (Timezone)
  8. Asia/Rangoon
    Asia/Rangoon (Timezone)
  9. Suphan Buri
    Suphan Buri, Suphan Buri, 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.02 seconds ⌛; show me the details?

        
0.02 seconds ⌛

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