21 places near Sao Đỏ, Hai Duong, Vietnam
filter by placetype:
  1. Sao Đỏ
    Sao Đỏ, Hai Duong, Vietnam (Town)
  2. Mekong River
    Mekong River, Cambodia (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. 广西省
    广西省, 中國 (State)
  9. Hai Duong
    Hai Duong, Vietnam (State)
  10. Bac Giang
    Bac Giang, Vietnam (State)

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

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

        
0.011 seconds ⌛

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