19 places near Sangkae, Batdambang, Cambodia
filter by placetype:
  1. Mekong River
    Mekong River, Cambodia (Drainage)
  2. Bakan
    Bakan, Pouthisat, Cambodia (County)
  3. Moung Ruessei
    Moung Ruessei, Batdambang, Cambodia (County)
  4. Sangkae
    Sangkae, Batdambang, Cambodia (County)
  5. Asia/Bangkok
    Asia/Bangkok (Timezone)
  6. Asia/Phnom_Penh
    Asia/Phnom_Penh (Timezone)
  7. Asia/Ho_Chi_Minh
    Asia/Ho_Chi_Minh (Timezone)
  8. Siem Reap Province
    Siem Reap Province, Siem Reap Province, Cambodia (State)
  9. Batdambang
    Batdambang, Cambodia (State)
  10. Cambodia
    Cambodia, Cambodia (Country)

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": [
                  103.469498,
                  13.0732
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}