19 places near Sapphaya, Chai Nat, Thailand
filter by placetype:
  1. Ban Hat a Sa (1)
    Ban Hat a Sa (1), Sapphaya, Chai Nat, Thailand (Town)
  2. Mekong River
    Mekong River, Cambodia (Drainage)
  3. Chao River
    Chao River, Thailand (Drainage)
  4. Takhli
    Takhli, Nakhon Sawan, Thailand (County)
  5. Sapphaya
    Sapphaya, Chai Nat, Thailand (County)
  6. Mueang Chai Nat
    Mueang Chai Nat, Chai Nat, Thailand (County)
  7. Asia/Bangkok
    Asia/Bangkok (Timezone)
  8. Asia/Rangoon
    Asia/Rangoon (Timezone)
  9. Asia/Vientiane
    Asia/Vientiane (Timezone)
  10. Nakhon Sawan
    Nakhon Sawan, Nakhon Sawan, Thailand (State)

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

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

        
0.019 seconds ⌛

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