16 places near Kampong Cham, Kampong Cham, Cambodia
filter by placetype:
  1. Mekong River
    Mekong River, Cambodia (Drainage)
  2. Krouch Chhmar
    Krouch Chhmar, Kampong Cham, Cambodia (County)
  3. Tboung Khmum
    Tboung Khmum, Kampong Cham, 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. Kampong Cham
    Kampong Cham, Kampong Cham, Cambodia (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.013 seconds ⌛; show me the details?

        
0.013 seconds ⌛

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