22 places near Trai Quan, Hai Duong, Vietnam
filter by placetype:
  1. Trai Quan
    Trai Quan, 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. Quang Ninh
    Quang Ninh, Quang Ninh, Vietnam (State)
  9. 广西省
    广西省, 中國 (State)
  10. Hai Duong
    Hai Duong, Vietnam (State)

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": [
                  106.454002,
                  21.165001
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}