23 places near Ngọc Trì, Bac Ninh, Vietnam
filter by placetype:
  1. Ngọc Trì
    Ngọc Trì, Bac Ninh, Vietnam (Town)
  2. Cẩm Giàng
    Cẩm Giàng, Hung Yen, Vietnam (Town)
  3. Mekong River
    Mekong River, Cambodia (Drainage)
  4. Song Hong Ha River
    Song Hong Ha River, Phu Tho, Vietnam (Drainage)
  5. Asia/Ho_Chi_Minh
    Asia/Ho_Chi_Minh (Timezone)
  6. Asia/Vientiane
    Asia/Vientiane (Timezone)
  7. Asia/Chongqing
    Asia/Chongqing, 中國 (Timezone)
  8. Asia/Shanghai
    Asia/Shanghai, 中國 (Timezone)
  9. 广西省
    广西省, 中國 (State)
  10. Hung Yen
    Hung Yen, Vietnam (State)

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

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

        
0.04 seconds ⌛

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