19 places near Table Rocher, Kiri Sakor, Kaoh Kong, Cambodia
filter by placetype:
  1. Mekong River
    Mekong River, Cambodia (Drainage)
  2. Table Rocher
    Table Rocher, Kiri Sakor, Kaoh Kong, Cambodia (Island)
  3. Samit Islands
    Samit Islands, Kiri Sakor, Kaoh Kong, Cambodia (Island)
  4. Botum Sakor
    Botum Sakor, Kaoh Kong, Cambodia (County)
  5. Kiri Sakor
    Kiri Sakor, Kaoh Kong, Cambodia (County)
  6. Asia/Bangkok
    Asia/Bangkok (Timezone)
  7. Asia/Phnom_Penh
    Asia/Phnom_Penh (Timezone)
  8. Asia/Ho_Chi_Minh
    Asia/Ho_Chi_Minh (Timezone)
  9. Kampot
    Kampot, Kampot, Cambodia (State)
  10. Kaoh Kong
    Kaoh Kong, Kaoh Kong, Cambodia (State)

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

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

        
0.009 seconds ⌛

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