| The urban underground pipe network is an important part of the "Intelligent City"building.The traditional pipeline management model is no longer suitable for the management of all kinds of pipelines.Hysteresis management can not meet the needs of handling huge pipeline data.Not only the time required for querying statistics is more and more,but also the error data is more likely to occur.GIS data processing platform is undoubtedly a powerful weapon to deal with this issue.Based on GIS platform,this paper takes Taixing City as an example,using ArcSDE and commercial database SQL Server to store massive pipeline data,and C#programming language to develop ArcEngine secondary development to research Taixing city underground pipeline information management system.The main research of this paper is divided into the following sections:1.Spatial data storage technology based on ArcSDENo matter by what kind of functional operation,the basis is spatial data input and output.The biggest difference between spatial data and ordinary data is that the spatial data possesses attribute and spatial characteristics.As a result,it can not be directly stored in SQL Server database software.In this paper,the ComGIS’s spatial database storage and indexing technology are used as a link to jointly manage spatial data with SQL Server.2.Component development technology research based on ComGISComGIS is one of the features of GIS platform.In this paper,ComGIS technology is used to design and research various functions to realize data query,data statistics and data analysis of underground pipelines.3.Design and implementation of underground pipeline query and statistical functionsPipeline data have features of numerical data,compact space,fast update speed and so on.Therefore,a good management system needs to consider convenient and fast query and statistics,and to design different search functions with different actual needs to provide users with intuitive statistics output;On the other hand,it is necessary to achieve timely updates of the pipeline data to provide users with data entry and deletion pipeline.4.Design and implementation of analysis and management of underground pipelineUnderground pipeline analysis is focus on the data space analysis.The data space location,topology,geometry and other aspects of the information are needed to take into account,which is the key to the development of GIS.Based on the spatial analysis,this paper studies and realizes the spatial analysis function of horizontal and vertical section of underground pipeline,horizontal and vertical clearance analysis to provide technical support for the design and maintenance of pipeline. |