The Management And Services Of Mine Foundmental Surveying Spatial Data Based On Open Source GIS Software

Mine surveying is an important guarantee of safety production in coal mines, and mine foundmental surveying spatial data is the important data type of mine surveying, mainly including the mining ground's DLG of different scales (resolution), digital terrain models and digital orthophotos. With the rapid development of the mine construction and production, how to effectively manage the mine foundmental surveying spatial data, and then provide application services are an important technical issues of digital mine construction. The rapid development of enterprise geographic information system technology for the solution to this problem provides an effective technical approach, but the application has been mainly based on the enterprise geographic information system software of the commercial version, and most of the software sale price. In recent years the rapid development of the open-source geographic information system software, characterized by source code opened, non-commercial and so on, attracts more and more attention.The application research based on the open source database named PostgreSQL is mainly aimed at the city or some related industries, but the application research of the mining areas is also less and the technology is not a complete application system. By the analysis the characteristics of the mine foundmental surveying spatial data in this paper, using the open source spatial database named PostgreSQL/PostGIS achieves the management of the mine foundmental surveying spatial data, and builds the application service system based on open source WebGIS to achieve the basic application services of data.Firstly, this paper analyzed the work theory of the PostgreSQL database server to client, the characteristics of spatial extension PostGIS, and studied the OGC simple feature model in PostgreSQL and the metadata table structure in PostGIS. Further the structure of the WebGIS system was studied, combining with the service needs of the mining spatial data to build the three-tier data management and service systems.Secondly, the storage methods of the vector and raster data in PostgGIS were studied, and the mining foundmental surveying spatial database was established. When storing the three types of the mine foundmental surveying spatial data(DEM,DOM,DLG), in order to ensure consistency of data in the database, it was necessary to normalize the data, such as respectively processing the different data, unified coding and coordinate system to make them meet storage standards. Based on the open source spatial database named PostgreSQL, the vector or raster data of shp, tab, mid/mif, mdb,tif was respectively stored management.Finally, used open source software which contains GeoServer, OpenLayers, PostgreSQL/PostGIS build B/S three-layers structure of data management service system,which is developed based on JAVA, JSP and HTML language in Myeclipse software development environment. Taking an example introducs the operation processes of some services of meeting OGC specification in details which contained WFS,WMS,SLD,and so on, and customise service functions with Filterf and WFS to expand to service and meet the needs of different users.Used the mine foundmental surveying spatial data which has been stored realized the functions of location positioning query, spatial information query, measuring distance and area, and so on.Through the above study, the thesis realized the storing of mine foundmental surveying spatial data based on open source geographic information system software,and the data management services system was established, preliminarily achieve the functions of data publishing, location positioning query, spatial information query, establishment of this system for the construction of digital mine provided a scientific basis and some references.