20 places near 19000, Lao Cai, Vietnam
filter by placetype:
  1. Mekong River
    Mekong River, Cambodia (Drainage)
  2. Xi River
    Xi River, 红河哈尼族彝族自治州, 云南省, 中國 (Drainage)
  3. Song Hong Ha River
    Song Hong Ha River, Phu Tho, Vietnam (Drainage)
  4. Asia/Ho_Chi_Minh
    Asia/Ho_Chi_Minh (Timezone)
  5. Asia/Vientiane
    Asia/Vientiane (Timezone)
  6. Asia/Chongqing
    Asia/Chongqing, 中國 (Timezone)
  7. Asia/Shanghai
    Asia/Shanghai, 中國 (Timezone)
  8. Lao Cai
    Lao Cai, Lao Cai, Vietnam (State)
  9. Yen Bai
    Yen Bai, Yen Bai, Vietnam (State)
  10. 云南省
    云南省, 中國 (State)

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

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

        
0.029 seconds ⌛

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