| Underground pipelines, as the cities ’and towns’"lifeline", carry the responsibility of transporting the energy and outputting the waste. However, with the expansion of cities and towns, types of underground pipelines are much more than before, and at the same time, the density of them is also increasing. So underground pipelines become complex increasingly. Traditional management method of underground pipelines is no longer applicable to today’s, lagging management method which results in pipeline bursting frequently not only makes querying data inefficient, but also makes emergency treatment inaccurate and late.So while leaving traditional management method of underground pipelines behind, we should be thinking about how to manage these large amounts of data better so that it can play better to support urban planning and development.GIS is no doubt to be the most powerful weapon to solve this problem. Based on GIS, while storing underground pipelines data by the way of ArcSDE and SQL Server working together, query and emergency management system of underground pipelines is designed and developed by programming language C#2005and ComGIS ArcEngine. The research can be mainly divided into the following parts:1. Research spatial database storage and indexing based on ArcSDESpatial data is the foundation of whether query or emergency management of the underground pipelines. Because of its spatial characteristics and mass properties,the spatial data which is different from general data can not be directly stored in commercial databases. This paper researchs storage and indexing techniques of spatial database based on ArcSDE, and manages spatial data by the way of combination ArcSDE and commercial databases.2. Component GIS technology (ComGIS) is used to develop query and emergency management system of underground pipelinesComGIS have an advantage in the development of geographic information system because of its powerful GIS capabilities and flexible features. By researching how to make better use of ComGIS to develop query and emergency management system of underground pipelines, the system achieve functions such as data query, data update, data statistics, emergency management and so on.3. Design and implementation of query of underground pipelines,Underground pipelines are of many kinds and high density, and they are always belong different sectors. Being a good query system, for one thing,system should ensure that the query is a convenient and practical, so the system provides users with multiple ways of query for different needs such as real-time query function which is designed innovatively to make users query more intuitively and simply.For another thing,it shoule be builted on the data sharing and data updates timely which are the basis of the data4. Design and implementation of the emergency management of the underground pipelinesGood emergency management system is based on the spatial analysis. Spatial analysis which is different from general analysis needs to take into account the object’s position, geometry and topological relations, ect. The emergency management of the underground pipelines is used to analyze and dig out the useful information among the existing space information, which is the important difference between GIS and information systems. Therefore, the effective analysis is the value of the emergency management system of underground pipelines, and supports planting and decising for town. This paper study and implement cross-sectional analysis, longitudinal analysis, the level spacing analysis, the vertical spacing analysis, the analysis of burst pipes and so on. And the analysis of burst pipes is designed by ArcGIS Spatial modeling which is the first time used for this kind of analysis. Compared with design methord of others, this idea is more clear and easy. |
