The Design And Achievement Of Coal Mine GIS

In the process of design, construction and production of coal mine, a series of coal minegeological problems need to be solved. Thus accumulate a large number of coal minegeological data. Through the data collation processing, extracting useful coal mine geologicalinformation to improve the rational use of coal resources, it is also the key of geologicaldisaster prevention. Data management mode of geological data in many mine geologydepartment is still very backward, coal mine data management is still in scattered way. Thedemand to realize informationization is extremely urgent. Coal mine geological informationrelates to many subjects, such as Geology, Surveying and Mapping Science and ComputerScience, and the content cross is the research of Geographical Information Science. So usingGIS technology to integrate coal mine geological information is the trend of coal geologicalsystem development. At present, system using professional GIS platform for mine geologicalinformation management and analysis is still relatively less.This paper studies the design and implementation method of coal mine geological spatialdatabase, the way using the spatial database to manage graphics data that coal mine geologyrelated. Relation database was used to manage coal mine geological files, user informationand system logs and other non-spatial data. The visualization and spatial analysis methodbased on GIS using in coal mine area is also the study content in this paper. The unifiedorganization of geological drilling information, showing to users in integration way in twoand three dimensional, the visualization of drilling information is realized; using the surfacemodeling method, spatial interpolation of the coal mine drilling floor data, the Multi-DEMmodel is constructed. To deal with the rock loss phenomenon, a method by using gridcalculating to extend the Multi-DEM geological modeling method is propused. To display thegeology profile and solve the problems of3D profile modeling in the application, atechnology of building geology3D profile model is proposed in this paper. By building2DProfile Frame FeatureClass, using Left algorithm for constructing two-dimensional profile, using affine transformation for reconstruct2D profile polygon FeatureClass, constructs a3Dgeological section and stores as Multipatch FeatureClass, realizing cutting analysis andgeological profile reconstruction. The stratified geological body modeling is realized based onMultipatch. Reserves Management can meet the needs of daily production of coal mine. Therequirements analysis, overall design and detailed design are based on the system integrationdemand of Shaanxi Hong Shiyan Coal Mine. Using unified modeling languageobject-oriented to specify modeling description of requirement analysis and design stages.Using ESRI company’s ArcSDE spatial database engine and Sun’s Oracle database to storespatial and non-spatial data, using C#language and ArcEngine component technology todevelop the system, and good result is achieved.The first chapter introduces the background and significance of this research.The second chapter introduces the key technology and technical route of this paper. Thekey techniques include the unified modeling language, modeling of spatial database,component development technology and multivariate data processing.The third chapter discusses mine geological information visualization method and spatialanalysis method based on GIS.The fourth chapter includes system requirements analysis, business process analysis,describes system role definition and functional requirement of the system.The fifth chapter is about system design and function implementation, including databasedesign, overall design, detailed design and function realization.The sixth chapter summarizes the research results of the paper, puts forward theprospects for further work.