15 places near Sai Ngam, Kamphaeng Phet, Thailand
filter by placetype:
  1. Mekong River
    Mekong River, Cambodia (Drainage)
  2. Chao River
    Chao River, Thailand (Drainage)
  3. Sai Ngam
    Sai Ngam, Kamphaeng Phet, Thailand (County)
  4. Asia/Bangkok
    Asia/Bangkok (Timezone)
  5. Asia/Rangoon
    Asia/Rangoon (Timezone)
  6. Kamphaeng Phet
    Kamphaeng Phet, Kamphaeng Phet, Thailand (State)
  7. Phitsanulok
    Phitsanulok, Phitsanulok, Thailand (State)
  8. Thailand
    Thailand, Thailand (Country)
  9. Indian Ocean
    Indian Ocean (Ocean)
  10. Pacific Ocean
    Pacific Ocean (Ocean)

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": [
                  99.871078,
                  16.444679
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}