15 places near Phrom Phiram, Phitsanulok, Thailand
filter by placetype:
  1. Mekong River
    Mekong River, Cambodia (Drainage)
  2. Chao River
    Chao River, Thailand (Drainage)
  3. Phrom Phiram
    Phrom Phiram, Phitsanulok, Thailand (County)
  4. Asia/Bangkok
    Asia/Bangkok (Timezone)
  5. Asia/Rangoon
    Asia/Rangoon (Timezone)
  6. Asia/Vientiane
    Asia/Vientiane (Timezone)
  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.012 seconds ⌛; show me the details?

        
0.012 seconds ⌛

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