14 places near Ap Ca Coi, Tra Vinh, Vietnam
filter by placetype:
  1. Ap Ca Coi
    Ap Ca Coi, 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. Tra Vinh
    Tra Vinh, Tra Vinh, Vietnam (State)
  6. Vietnam
    Vietnam, Vietnam (Country)
  7. Indian Ocean
    Indian Ocean (Ocean)
  8. South China Sea
    South China Sea (Sea)
  9. Pacific Ocean
    Pacific Ocean (Ocean)
  10. Asia
    Asia (Continent)

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

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

        
0.014 seconds ⌛

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