21 places near 桑园, 沧州市, 河北省, 中國
filter by placetype:
  1. 桑园
    桑园, 沧州市, 河北省, 中國 (Town)
  2. Huang River
    Huang River, 忻州市, 山西省, 中國 (Drainage)
  3. 景县
    景县, 衡水市, 河北省, 中國 (LocalAdmin)
  4. 吴桥县
    吴桥县, 沧州市, 河北省, 中國 (LocalAdmin)
  5. 德州市
    德州市, 德州市, 山东省, 中國 (LocalAdmin)
  6. 陵县
    陵县, 德州市, 山东省, 中國 (LocalAdmin)
  7. 德州市
    德州市, 山东省, 中國 (County)
  8. 衡水市
    衡水市, 河北省, 中國 (County)
  9. 沧州市
    沧州市, 河北省, 中國 (County)
  10. Asia/Shanghai
    Asia/Shanghai, 中國 (Timezone)

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

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

        
0.022 seconds ⌛

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