XUChang-qing,ZHANGRong-rong,SHIXin-mei,et al.Design of Source Control Facility Database for Sponge Cities in China[J].China Water & Wastewater,2023,39(8):53-60.
Design of Source Control Facility Database for Sponge Cities in China
China Water & Wastewater[ISSN:1000-4062/CN:12-1073/TU]
volume:
第39卷
Number:
第8期
Page:
53-60
Column:
Date of publication:
2023-04-17
- Keywords:
- sponge city; demand analysis; source control facilities; UML model
- Abstract:
- China started the research on urban stormwater management relatively late, and there are not many localized data that can be referred to and learned from in sponge city construction. To sustainably support the construction of sponge city in China, it is urgent to refer to the experience of building related databases abroad, summarize and organize the relevant data obtained from the pilot construction of sponge cities in China, and establish a database of sponge city source control facilities. Firstly, the actual situation of sponge city source control facility data in the pilot construction of sponge cities in China was analyzed. Referring to the architecture of the American international BMP database, the demand analysis of the sponge city source control facility database was completed. Then, through three steps of conceptual design, logical design, and physical design, a sponge city source control facility database with clear structure, easy management, and high execution efficiency was designed. The database is mainly divided into five entity sets: sponge city source control facilities, research areas, monitoring stations, monitoring events, and monitoring data, containing 45 tables and thousands of field properties. Through the construction of the Chinese sponge city source control facility database, data support can be provided for the efficiency evaluation, operation and maintenance, and cost-benefit analysis of sponge city source control facilities, serving the planning, design, and construction of sponge city.
Last Update:
2023-04-17