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.
中国海绵城市源头设施数据库设计探讨
- Title:
- Design of Source Control Facility Database for Sponge Cities in China
- Keywords:
- sponge city; demand analysis; source control facilities; UML model
- 摘要:
- 我国开展城市雨洪管理研究起步较晚，在海绵城市建设中可参考借鉴的本地化数据不多，为可持续地支持我国海绵城市建设，亟需参照国外相关数据库建设的经验，对我国海绵城市试点建设实践取得的相关数据进行归纳整理，建立海绵城市源头设施数据库。首先分析了我国海绵城市试点建设中海绵城市源头设施相关数据的实际情况，借鉴美国国际BMP数据库的架构，完成了海绵城市源头设施数据库的需求分析，进而通过概念设计、逻辑设计和物理设计三个步骤，设计了一个结构清晰、管理方便、执行效率高的海绵城市源头设施数据库。该数据库主要分为海绵城市源头设施、研究区域、监测站、监测事件和监测数据五个实体集，包含45张表格和上千条字段属性。后续通过中国海绵城市源头设施数据库的建设，可为海绵城市源头设施的效能评估、运营维护和成本效益分析提供数据支持，服务于海绵城市的规划设计和建设。
- 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.
相似文献/References:
[1]吴耀珊,计波,刘卓成.透水砖材料和下垫面对城市雨洪的影响[J].中国给水排水,2018,34(21):133.
WU Yao shan,JI Bo,LIU Zhuo cheng.Influence of Permeable Brick Material and Underlying Surface on Urban Stormwater[J].China Water & Wastewater,2018,34(8):133.
[2]汤忠,张亮,俞露,等.南方某滨海机场海绵建设策略探索[J].中国给水排水,2018,34(20):1.
TANG Zhong,ZHANG Liang,YU Lu,et al.Exploration on the Sponge Construction Strategies of a Coastal Airport in South China[J].China Water & Wastewater,2018,34(8):1.
[3]李胜海,陈思,白静,等.山地城市市政道路低影响开发雨水系统设计与构建[J].中国给水排水,2018,34(20):60.
LI Sheng hai,CHEN Si,BAI Jing,et al.Design and Construction of Stormwater Systems for Low-Impact-Development of Municipal Roads in Mountainous City[J].China Water & Wastewater,2018,34(8):60.
[4]许可,郭迎新,吕梅,等.对完善我国海绵城市规划设计体系的思考[J].中国给水排水,2020,36(12):1.
XU Ke,GUO Ying-xin,Lü Mei,et al.Thinking on Improving Sponge City Planning and Design System in China[J].China Water & Wastewater,2020,36(8):1.
[5]杨文辉,张伟,张海行,等.常州海绵城市试点区建设中的闲置用地近远期管控[J].中国给水排水,2020,36(14):1.
YANG Wen-hui,ZHANG Wei,ZHANG Hai-xing,et al.Short-and Long-term Control of Idle Land in the Construction of Changzhou Sponge City Pilot Area[J].China Water & Wastewater,2020,36(8):1.
[6]聂超,周丹,林韵婕,等.建筑与小区低影响开发设计问题及对策[J].中国给水排水,2020,36(14):6.
NIE Chao,ZHOU Dan,LIN Yun-jie,et al.Design Problems and Countermeasures of Low Impact Development in Buildings and Communities[J].China Water & Wastewater,2020,36(8):6.
[7]张伟,王翔.基于海绵城市建设理念的慈城新城水安全系统构建[J].中国给水排水,2020,36(14):12.
ZHANG Wei,WANG Xiang.Construction of Cicheng New Town Drainage Safety System Based on Sponge City Concept[J].China Water & Wastewater,2020,36(8):12.
[8]张净,崔建军,蒋礼兵,等.基于窄带物联网的海绵城市滤水养鱼智能监控系统设计[J].中国给水排水,2020,36(14):61.
ZHANG Jing,CUI Jian-jun,JIANG Li-bing,et al.Design of Intelligent Monitoring System for Fish Culture in Filtered Water of Sponge City Based on Narrow-band Internet of Things (NB-IoT)[J].China Water & Wastewater,2020,36(8):61.
[9]李国君,王永,梁振凯,等.海绵城市建设区域化效果评估探讨[J].中国给水排水,2020,36(14):76.
LI Guo-jun,WANG Yong,LIANG Zhen-kai,et al.Evaluation of Regionalized Effect of Sponge City Construction[J].China Water & Wastewater,2020,36(8):76.
[10]方帅,徐洁,刘绪为,等.镇江虹桥港上游黑臭水体系统性治理工程设计[J].中国给水排水,2020,36(14):94.
FANG Shuai,XU Jie,LIU Xu-wei,et al.Project Design of Systematic Treatment of Black-smelly Water Body in Upstream of Hongqiaogang, Zhenjiang City[J].China Water & Wastewater,2020,36(8):94.