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

Design of Source Control Facility Database for SpongeeCitiesinChina

我国开展城市雨洪管理研究起步较晚,在海绵城市建设中可参考借鉴的本地化数据不多,为可持续地支持我国海绵城市建设,亟需参照国外相关数据库建设的经验,对我国海绵城市试点建设实践取得的相关数据进行归纳整理,建立海绵城市源头设施数据库。首先分析了我国海绵城市试点建设中海绵城市源头设施相关数据的实际情况,借鉴美国国际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.