18 places near Can Tho, Can Tho, Vietnam
filter by placetype:
  1. Mekong River
    Mekong River, Cambodia (Drainage)
  2. Asia/Bangkok
    Asia/Bangkok (Timezone)
  3. Asia/Phnom_Penh
    Asia/Phnom_Penh (Timezone)
  4. Asia/Ho_Chi_Minh
    Asia/Ho_Chi_Minh (Timezone)
  5. An Giang
    An Giang, An Giang, Vietnam (State)
  6. Dong Thap
    Dong Thap, Dong Thap, Vietnam (State)
  7. Kien Giang
    Kien Giang, Kien Giang, Vietnam (State)
  8. Can Tho
    Can Tho, Can Tho, Vietnam (State)
  9. Hau Giang
    Hau Giang, Hau Giang, Vietnam (State)
  10. Vietnam
    Vietnam, Vietnam (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": [
                  105.53,
                  10.122
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}