18 places near Sa Rài, Dong Thap, Vietnam
filter by placetype:
  1. Sa Rài
    Sa Rài, Dong Thap, Vietnam (Town)
  2. Mekong River
    Mekong River, Cambodia (Drainage)
  3. Preah Sdach
    Preah Sdach, Prey Veng, Cambodia (County)
  4. Asia/Bangkok
    Asia/Bangkok (Timezone)
  5. Asia/Phnom_Penh
    Asia/Phnom_Penh (Timezone)
  6. Asia/Ho_Chi_Minh
    Asia/Ho_Chi_Minh (Timezone)
  7. Prey Veng
    Prey Veng, Prey Veng, Cambodia (State)
  8. An Giang
    An Giang, An Giang, Vietnam (State)
  9. Dong Thap
    Dong Thap, Dong Thap, 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.018 seconds ⌛; show me the details?

        
0.018 seconds ⌛

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