中国海绵城市源头设施数据库设计探讨  

Design of Source Control Facility Database for SpongeeCitiesinChina

作　　者：徐常青 张容榕 史馨玫 陈正侠[1] 贾海峰[1] XU Chang-qing;ZHANG Rong-rong;SHI Xin-mei;CHEN Zheng-xia;JIA Hai-feng(School of Environment,Tsinghua University,Bejing 100084,China;School of Management and Economics,Beijing Institute of Technology,Beijing 100081,China)

机构地区：[1]清华大学环境学院,北京100084 [2]北京理工大学管理与经济学院,北京100081

出　　处：《中国给水排水》2023年第8期53-60,共8页China Water & Wastewater

基　　金：国家自然科学基金青年项目(52200218);国家自然科学基金资助面上项目(52070112);中国博士后科学基金资助面上项目(2021M691769);城市水循环与海绵城市技术北京市重点实验室开放基金资助项目(HYD20230F01)。

摘　　要：我国开展城市雨洪管理研究起步较晚,在海绵城市建设中可参考借鉴的本地化数据不多,为可持续地支持我国海绵城市建设,亟需参照国外相关数据库建设的经验,对我国海绵城市试点建设实践取得的相关数据进行归纳整理,建立海绵城市源头设施数据库。首先分析了我国海绵城市试点建设中海绵城市源头设施相关数据的实际情况,借鉴美国国际BMP数据库的架构,完成了海绵城市源头设施数据库的需求分析,进而通过概念设计、逻辑设计和物理设计三个步骤,设计了一个结构清晰、管理方便、执行效率高的海绵城市源头设施数据库。该数据库主要分为海绵城市源头设施、研究区域、监测站、监测事件和监测数据五个实体集,包含45张表格和上千条字段属性。后续通过中国海绵城市源头设施数据库的建设,可为海绵城市源头设施的效能评估、运营维护和成本效益分析提供数据支持,服务于海绵城市的规划设计和建设。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.

关 键 词：海绵城市 需求分析 源头设施 UML模型 

分 类 号：TU992[建筑科学—市政工程]