16 places near Kampong Rou, Svay Rieng, Cambodia
filter by placetype:
  1. Mekong River
    Mekong River, Cambodia (Drainage)
  2. Kampong Rou
    Kampong Rou, Svay Rieng, Cambodia (County)
  3. Asia/Phnom_Penh
    Asia/Phnom_Penh (Timezone)
  4. Asia/Ho_Chi_Minh
    Asia/Ho_Chi_Minh (Timezone)
  5. Svay Rieng
    Svay Rieng, Svay Rieng, Cambodia (State)
  6. Long An
    Long An, Long An, Vietnam (State)
  7. Dong Thap
    Dong Thap, Dong Thap, Vietnam (State)
  8. Cambodia
    Cambodia, Cambodia (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.027 seconds ⌛; show me the details?

        
0.027 seconds ⌛

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