16 places near Tiểu Cần, Tra Vinh, Vietnam
filter by placetype:
  1. Tiểu Cần
    Tiểu Cần, Tra Vinh, Vietnam (Town)
  2. Mekong River
    Mekong River, Cambodia (Drainage)
  3. Asia/Phnom_Penh
    Asia/Phnom_Penh (Timezone)
  4. Asia/Ho_Chi_Minh
    Asia/Ho_Chi_Minh (Timezone)
  5. Ben Tre
    Ben Tre, Ben Tre, Vietnam (State)
  6. Soc Trang
    Soc Trang, Soc Trang, Vietnam (State)
  7. Tra Vinh
    Tra Vinh, Tra Vinh, Vietnam (State)
  8. Vietnam
    Vietnam, Vietnam (Country)
  9. Indian Ocean
    Indian Ocean (Ocean)
  10. South China Sea
    South China Sea (Sea)

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

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

        
0.031 seconds ⌛

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