22 places near Sài Đồng, Ha Noi, Vietnam
filter by placetype:
  1. Sài Đồng
    Sài Đồng, Ha Noi, 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. Ha Noi
    Ha Noi, Ha Noi, Vietnam (State)
  9. Ha Tay
    Ha Tay, Ha Tay, Vietnam (State)
  10. 广西省
    广西省, 中國 (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": [
                  105.913002,
                  21.0394
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}