23 places near Cẩm Giàng, Hung Yen, 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.012 seconds ⌛; show me the details?

        
0.012 seconds ⌛

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