Abstract
In coal mining technology systems, it is very important to acquire, store, and represent basic geological data comprehensively and accurately. Based on the current working mode and information level in mining geology at coal mines, this paper proposes a process of building basic geological database for modeling of coal mines by using existing results’ data of mining geology and develops the efficient program for getting the basic geological data from the important 2D plane drawings’ achievement at mines, such as the contour maps of mine coal seam floors, geological cross-sections, underground drilling results, and geological survey results, based on AutoLISP, which is a programming language for the secondary development of AutoCAD. The obtained data in general text format is stored and managed by the MongoDB database, which realizes the storage, query, analysis, and correction of massive data of geological objects in the space of the underground coalmine. The application results show that compared with the previous data acquisition methods such as manual input and graphic transformation attribute, the extraction of spatial and attribute data from the existing mine 2D plane drawings by programming can effectively avoid the prominent problems such as artificial gross error, distortion of graph conversion, and different database structure, make the obtained spatial geological data more comprehensive, accurate, and effective, and, meanwhile, increase the rate by more than 60%, which plays an important role in data support for the construction of the geological modeling systems for transparent mines.
Highlights
Coal mining industry supports China’s rapid social and economic development by providing critical resources, and it will occupy a dominant position in China’s energy structure for a long time
Considering the basic geological technology systems being used in coal mines in China and the mode of operation thereof, it is required to improve, based on a comprehensive collection of massive and multisource heterogeneous basic geological data of coal mines, the management of coal mine geological databases, build high-resolution and dynamic 3D geological models for coal mines, fully integrate various geophysical exploration results and multiphysics monitoring data, and continuously and deeply push forward the construction of transparent mines relying on cutting-edge technologies such as geophysical inversion and big data. erefore, acquiring basic geological data at coal mines comprehensively and accurately has become a critical basic link to be completed before geological data which can be used at deep levels
To ensure the reliability of basic geological data stored in databases, some static data can be replaced by newly acquired dynamic data or the old and new data can be mathematically fitted in order to continuously reduce data errors and improve data consistency
Summary
Coal mining industry supports China’s rapid social and economic development by providing critical resources, and it will occupy a dominant position in China’s energy structure for a long time. Erefore, in order to solve this problem, considering the current mode and informatization level of geological work at coal mines in some old mining areas in the central and eastern regions of China, the authors propose a process for building the basic geological database for coal mine modeling using existing results data of mining geology, select the key 2D mine drawings, underground geologic survey results, and underground drilling results as the objects of study, develop a series of programs using AutoLISP, a programming language for the secondary development of AutoCAD to extract the basic geological spatial data and attribute data of coal mines, use MongoDB which is a document-oriented nonrelational database for data storage and management, and continuously diversify the ways to acquire big geological data and the connotations of such data. Literature [14,15,16] mainly analyzed the classification and spatial data extraction methods of various geological technical data in coal mines from different perspectives, studied the construction principle and data structure of spatial geological databases, and showed that the conventional data acquisition methods are still limited to manual input, graphic conversion and importing from old data based on the large amount of data, different formats, and different scales, and lack of standardization. ere are some prominent problems such as too much workload, data redundancy, and poor data consistency. erefore, in order to solve this problem, considering the current mode and informatization level of geological work at coal mines in some old mining areas in the central and eastern regions of China, the authors propose a process for building the basic geological database for coal mine modeling using existing results data of mining geology, select the key 2D mine drawings, underground geologic survey results, and underground drilling results as the objects of study, develop a series of programs using AutoLISP, a programming language for the secondary development of AutoCAD to extract the basic geological spatial data and attribute data of coal mines, use MongoDB which is a document-oriented nonrelational database for data storage and management, and continuously diversify the ways to acquire big geological data and the connotations of such data. e proposed method can provide important supporting data for building the high-resolution 3D geological models for coal mines and has great practical significance in supporting the construction of digitalized, and intelligent mines, especially in mining areas where the informatization level is relatively low
Sign-in/Register to view highlights & summary Sign-in/Register to access full text options 
Free) 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call
