【作者】 王帅；

【导师】 董明；

【作者基本信息】 大连理工大学 ， 电子信息（专业学位）， 2023， 硕士

【摘要】 供水管网作为城市的重要基础设施,是保证城市正常运行的关键一环。对供水企业而言,建设高效先进的供水管网信息平台,以数字化的手段对供水管网数据资料进行管理和利用,对于提升管网基础设施管理水平,规划供水管网的建设,指导管网维护工作以及提升供水服务水平都具有重要意义。本文面向某供水企业的实际需求,基于WebGIS技术,对供水管网地理信息系统展开研究并设计实现。本文立足于某供水企业的实际需求,展开系统分析,首先明确了供水管网WebGIS系统的六大功能模块并进行系统总体框架的设计搭建。为了能够充分发挥WebGIS的优势,提升系统性能,本文尝试将更多的Web相关技术与GIS技术相结合。以Open Layers作为前端GIS框架,在后端引入Spring、SpringMVC、MyBatis框架实现表示层(UI)、业务逻辑层(BLL)、数据访问层(DAL)三层架构模式。为达到良好的表现效果,在前端辅以Bootstrap框架和FontAwesome图标样式库进行设计。在服务端,选择Tomcat和GeoServer分别作为Web服务器和GIS服务器。以PostgreSQL及其扩展PostGIS作为空间数据库,借助PostGIS所提供的空间函数可以对空间数据进行分析操作。引入Redis实现系统缓存,减少数据访问层与数据库的直接交互,提升系统查询效率。为了使供水企业所提供的原始数据文件能够为系统所用,本文进行了文件格式转换、空间数据文件合并、数据入库、实体要素与属性信息绑定等多步处理。通过GeoServer将空间数据发布为服务,使得空间数据可以被OpenLayers请求调用,并且为地图标注图层编写SLD文件,使标注文字达到需要的显示效果。在搭建的系统总体框架的基础上,以经过处理的供水管网数据为内容主体,对系统展开具体实现。通过对实现过程中关键技术问题的研究,给出了每种功能的具体实现方案。最终,实现了所提出的地图视图、地图基础工具、信息查询与编辑、定位、区域统计分析以及爆管分析六大模块下的所有子功能,达到了预期的设计效果,基本能够满足某供水企业的使用需求,来帮助供水企业更好地管理和利用供水管网数据资源。更多还原

【Abstract】 As an important infrastructure of a city,water supply network is a key part to ensure the normal operation of the city.For water supply enterprises,it is important to build an efficient and advanced water supply network information platform to manage and utilize water supply network data by digital means to improve the management level of network infrastructure,plan the construction of water supply network,guide the maintenance of network and improve water supply service level.In this paper,we study and design the GIS of water supply network based on WebGIS technology for the actual needs of a water supply enterprise.Based on the actual needs of a water supply enterprise,this paper presents a system analysis,firstly clarifies the six functional modules of the water supply network WebGIS system,designs and builds the overall framework of the system.In order to give full play to the advantages of WebGIS and improve the system performance,this paper tries to combine more Web-related technologies with GIS technologies.OpenLayers is used as the front-end GIS framework,and Spring,Spring MVC and My Batis framework are introduced in the back-end to realize a three-tier architecture model of UI,BLL and DAL.In order to achieve good performance,the front-end is designed with Bootstrap framework and Font Awesome icon style library.On the server side,Tomcat and Geo Server are chosen as the Web server and GIS server respectively.Postgre SQL and its extension PostGIS are used as the spatial database,and the spatial functions provided by PostGIS can be used to analyze the spatial data.Redis is introduced to realize the system cache,reduce the direct interaction between the data access layer and the database,and improve the query efficiency of the system.In order to make the raw data files provided by water supply companies available to the system,this paper performs multi-step processing such as file format conversion,spatial data file merging,data entry,and entity element and attribute information binding.Publish the spatial data as a service through Geo Server so that the spatial data can be called by OpenLayers requests and write SLD files for map annotation layers so that the annotation text can achieve the desired display effect.On the basis of the general framework of the system built,the specific implementation of the system is carried out with the processed water supply network data as the main content.By studying the key technical issues in the implementation process,a specific implementation plan for each function is given.Finally,all the sub-functions under the proposed six modules of map view,map base tools,information query and editing,positioning,regional statistical analysis and pipe burst analysis were realized,which achieved the expected design effect and basically met the requirements of a water supply enterprise to help it better manage and utilize the water supply network data resources.更多还原