22 places near Poipet, Ou Chrov, Banteay Mean Cheay, Cambodia
filter by placetype:
  1. Paoy Pet
    Paoy Pet, Aranyaprathet, Sa Kaeo, Thailand (Town)
  2. Tha Kham
    Tha Kham, Aranyaprathet, Sa Kaeo, Thailand (Town)
  3. Pa Rai
    Pa Rai, Aranyaprathet, Sa Kaeo, Thailand (Town)
  4. Poipet
    Poipet, Ou Chrov, Banteay Mean Cheay, Cambodia (Town)
  5. Mekong River
    Mekong River, Cambodia (Drainage)
  6. Aranyaprathet
    Aranyaprathet, Sa Kaeo, Thailand (County)
  7. Watthana Nakhon
    Watthana Nakhon, Sa Kaeo, Thailand (County)
  8. Ou Chrov
    Ou Chrov, Banteay Mean Cheay, Cambodia (County)
  9. Asia/Bangkok
    Asia/Bangkok (Timezone)
  10. Asia/Phnom_Penh
    Asia/Phnom_Penh (Timezone)

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

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

        
0.016 seconds ⌛

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