With the rapid development of the socio-economic system and the close connection of inter-regional trade, the physical water consumption in production and the virtual water flow associated with inter-regional trade are both have a significant impact on local water systems, especially in megacities. Beijing is the political, economic and cultural center of China, which is a megacity that has severe water scarcity. To evaluate the status-quo of local water consumption and propose the countermeasures, this study quantitatively analyzed the evolution trend of physical water consumption and the virtual water flow in Beijing. The results show that the total physical water consumption in Beijing decreased from 2.43 billion m³ (2002) to 1.98 billion m³ (2017), while the net virtual water input increased from 1.76 billion m³ (2002) to 3.09 billion m³ (2017), which was mainly embedded in agricultural and industrial products. This study also reveals the equal importance of physical water and virtual water in ensuring the regional water security and sustainable economic development. In view of poor water resource endowment, Beijing should conduct the coupled management of physical water and virtual water to alleviate the local water shortage, i.e., to receive more virtual water embedded in agricultural and industrial products, and allocate the limited local water resources to domestic use and high-benefit sectors.

The Yellow River Basin, a cradle of Chinese civilization, hosts traditional riverside villages that embody millennia of cultural and ecological heritage. Despite their significance, rapid urbanization and homogeneous rural development have precipitated landscape homogenization and cultural erosion, threatening these villages’ spatial integrity and cultural capital. Current research predominantly focuses on qualitative characterization of architectural heritage, neglecting quantitative assessments of agroecological synergies and systematic resource endowment analysis. This oversight limits the development of proactive conservation strategies tailored to the integrated cultural–ecological value of these villages, hindering their sustainable revitalization within China’s broader Yellow River Basin high-quality development strategy. Here, we develop a comprehensive framework integrating landscape characterization, value assessment, and conservation strategies for traditional villages along Shaanxi’s Yellow River. Using GISs 10.2 multi-criteria analysis, and field surveys, we construct a hierarchical landscape database and evaluate villages across cultural, ecological, and socio-economic dimensions. Our results reveal distinct spatial patterns, with 65% of historical structures clustered in village cores, and identify four landscape zones requiring targeted conservation. High-value villages (e.g., Yangjiagou) exhibit strong cultural preservation and ecological resilience, while lower-scoring villages underscore urgent intervention needs. We propose multi-scale protection strategies, including regional clustering and village-level tailored approaches, to balance conservation with sustainable development. This study fills the critical gap in systematic resource endowment evaluation by demonstrating how integrated cultural–ecological metrics can guide proactive conservation. Our framework not only safeguards tangible and intangible heritage but also aligns with national strategies for rural revitalization and ecological protection. By bridging methodological divides between qualitative and quantitative approaches, this research offers a replicable model for sustainable rural development in ecologically sensitive cultural landscapes globally, advancing the field beyond static preservation paradigms toward dynamic, evidence-based planning.

This study addresses the critical gap in designing child-friendly school commuting routes in mountainous cities like Chongqing, where steep terrain and complex infrastructure pose unique challenges to children’s safety and accessibility. Combining Importance-Performance Analysis (IPA) and the Kano model, we systematically evaluated 19 design elements across safety, interest, and convenience dimensions through comprehensive field research and surveys involving 611 participants. Our analysis identified emergency signage systems, street greening, and parent pick-up points as pivotal optimization factors, while revealing significant improvement needs for vehicle speed limits and anti-slip pavement. The findings demonstrate how context-specific, evidence-based design solutions can effectively enhance children’s commuting experiences in challenging urban environments, providing urban planners with a scientifically-grounded framework that adapts child-friendly principles to mountainous contexts. This research advances the field of child-friendly urban planning by bridging the current theoretical-practical divide and offering actionable strategies tailored to geographically constrained cities.