[1]侯煜堃,王冉,张萌,等.基于ArcGIS和Excel的市政雨水管网设计流程优化[J].中国给水排水,2024,40(8):87-92.
　HOUYu-kun,WANGRan,ZHANGMeng,et al.Design Process Optimization of Municipal Rainwater Pipe Network Based on ArcGIS and Excel[J].China Water & Wastewater,2024,40(8):87-92.
点击复制

基于ArcGIS和Excel的市政雨水管网设计流程优化

中国给水排水[ISSN:1000-4062/CN:12-1073/TU] 卷: 第40卷 期数: 2024年第8期 页码: 87-92 栏目: 出版日期: 2024-04-17
Title:
Design Process Optimization of Municipal Rainwater Pipe Network Based on ArcGIS and Excel
作者:
侯煜堃， 王冉， 张萌， 冯玉冠
（华北水利水电大学 环境与市政工程学院，河南 郑州 450045）
Author(s):
HOU　Yu-kun， WANG　Ran， ZHANG　Meng， FENG　Yu-guan
（School of Environmental and Municipal Engineering， North China University of Water Resources and Electric Power， Zhengzhou 450045， China）
关键词:
市政雨水管网;  设计流程优化;  ArcGIS;  Excel;  VBA;  流量叠加法
Keywords:
municipal rainwater pipe network;  design process optimization;  ArcGIS;  Excel;  VBA;  flow superposition method
摘要:
为优化市政雨水管网设计流程，提出了将CAD、ArcGIS和Excel软件联用的全流程系统性设计方法。主要内容包括：运用CAD的制图功能和ArcGIS强大的空间分析功能建立雨水管网模型，通过ArcGIS合并关键节点、线段和子汇水面并生成属性表，然后通过Excel对该表进行相关数学计算，利用Excel中的透视表功能与VBA（Visual Basic for Application）编程结合，实现雨水管段各属性信息的自动计算。通过以上各软件的联合应用实现了城市雨水管网系统的设计，可为雨水设计软件的开发提供参考。
Abstract:
This paper proposed a systematic whole process design method integrating CAD, ArcGIS and Excel, so as to optimize the design process of municipal rainwater pipe network. The rainwater pipe network model was established through the drawing function of CAD and the powerful spatial analysis function of ArcGIS. The attribute table was generated by merging key nodes, line segments and sub-catchment surfaces through ArcGIS. The table was then calculated by Excel, and the automatic calculation of each attribute information of rainwater pipe section was realized by using the perspective table function in combination with VBA(Visual Basic for Application) programming in Excel software. The design of urban rainwater pipe network system was realized through the combined application of the above software. The results aim to provide reference for the development of rainwater design software.
更新日期/Last Update: 2024-04-17