0 Preface Drilling is an effective means to obtain information on underground rock formations, ground temperature, gas and water content, and is also an important way to understand the distribution of underground minerals. Traditional data management foundation for the drilling of a number of coal mines, usually in a way to save paper map, the way to save not only take up a lot of space, but also due to various factors, often there will not be the outcome of the information required Finding in time, or the same data, is subject to multiple statistics, resulting in unnecessary waste of manpower, material resources and financial resources, not to mention further statistical analysis to provide decision-making basis for designers and relevant leaders. Therefore, when establishing the mine information system, the drilling information management system is established to store, manage, query and analyze the drilling information reasonably, and provide a convenient operation mechanism for the design and decision-makers. It is a need for the mine geographic information system. Important task. The application of GIS software in the basic data of drilling is mainly to establish the corresponding database system to standardize, standardize and systematically manage the spatial data and attribute data of underground resource information, and to quickly and efficiently visualize the query and retrieval of related data. The underground resource management space assisted decision support system provides support and basis. In the past, due to the limitation of computer technology, GIS software is difficult to integrate with MIS system and professional application model efficiently and seamlessly, and the cost of secondary development is very high. In recent years, with the development of computer technology, COM software technology has become one of the trends of today's software technology, providing a new idea for the development of application systems: developers first achieve reliable, small object modules (components) or directly from Other software developers get the features they need and then use them to assemble more complex systems that control the entire application system by controlling the reliability and maintainability of each small part. 1Design of component-based GIS drilling information management system 1.1 Overall structural design The drilling information management system mainly manages the drilling space and attribute information, and the information is applied to the internal database of the system for unified management to achieve effective integration. Based on the above information, decision support and business inquiry services can be provided. Such as creating thematic maps and contour maps, information query and positioning. The system structure is shown in Figure 1. 1.2 software platform In combination with the development of mine geographic information system, this development selected GIS component - MapX, unified use of visual language VB 6.0 control program flow, use ACCESS database to manage relevant geological basic data, and use Surfer Automation technology to call Surfer program to draw equivalent line graph. MapX is a cost-effective and powerful ActiveX-based programmable OCX control provided by Mapinfo. It has the general common properties of OCX components, which can be performed through MapX properties, events, and methods. Graph browsing, thematic mapping, data binding, annotation, layering, automatic labeling, selection, primitive factory, tools, map editing, projection and coordinate system, remote space server connection, etc. Surfer software is a geographic data mapping software developed by GOLDEN Software Company in the Windows environment. It has powerful graphics and computational analysis capabilities and is specifically designed for drawing software. Starting with the Surfer7 version, the software adds Automation technology to support the secondary development of the VB programming language. 1.3 System Interface The Drilling Information Management System module can be connected to the mine geographic information system via a menu or toolbar interface. The implementation of the interface allows the drill management information system to ultimately interact with the user and also expands the system functionality. 1.4 database design The drilling basic data is placed in the ACCESS database for unified management according to system requirements. Drilling information can be divided into spatial and non-spatial information. The spatial information of the borehole mainly specifies the spatiality of the borehole distribution. The non-spatial information generally specifies its engineering information and post-sampling information, such as the ground elevation, the ceiling elevation, the number of layers, and the thickness of the clamp. The drilling space and attribute data are stored in a two-dimensional table of the relational database, and are associated by key fields. 1.5 functional design - Unified management of basic data. There are many ways to obtain drilling geological space and attribute data, including from existing systems, charts, GIS tools, statistical surveys, field surveys (earthquake, drilling, geophysical surveys). The data obtained by these different means have different storage formats and extraction and processing methods. In order to enable the system to make full use of these data for further development, spatial data of different formats will be uniformly converted into a format that can be recognized by the GIS platform, and all spatial and attribute data will be guided to a unified relational database to realize unified management of basic data. . - Data query analysis. In addition to the basic functions of drilling addition and deletion, the drilling information management subsystem also supports two types of drilling query methods: GIS map positioning query and non-spatial information retrieval of drilling patterns, including drilling name, Information such as coal thickness and number of layers. At the same time, the user can conveniently display the position of the specified drilling hole in the GIS map and highlight it in the center, so that the staff can intuitively understand the spatial distribution of the drilling hole. The drilling data management process is shown in Figure 2. - Thematic map production. According to the needs of users, the relevant database information in the information management system can be used to perform statistical analysis and display the results on the map in the form of thematic maps to provide relevant auxiliary decision support. - Contour map production. Various contour maps are the most commonly used maps for mine technicians. This paper uses the Automation technology of Surfer 8 to realize the drawing of various contour maps, such as coal seam floor and thickness contours, which can not only improve work efficiency, avoid human error, improve the quality of technical achievements, but also can be used by technicians. It is used for multi-faceted analysis of coal mines to accurately and reasonably arrange normal and efficient production. 2 system implementation Taking a mine in Anhui as an example to introduce the realization of the drilling information management system. 2.1 Interface interface between drilling information management and mine geographic information system The drilling information management interface provides a user interface for drilling information by opening the “Drilling Data Management†menu communicated with the mine geographic information system, as shown in Figure 3. Since the borehole information management system is a subsystem of the mine geographic information system, its architecture must meet the extended design of the mine geographic information system. 2.2 MapX-based drilling basic data query analysis - Browse and edit the map. You can zoom in, zoom out and roam the drill holes and related layers, view the data of each hole, etc., and control the display, add, copy, delete, edit layers of each layer to make changes in drilling and underground related information. Timely reflection in the application system to ensure timely update of information. - Visual query of drilling basic data. It mainly includes two aspects from attribute to space and space to attribute. The main purpose of the query is to understand the spatial location, distribution and related attribute data of the hole. The visual query method from space to attribute can be point, circle, rectangle and polygon query, etc., and its implementation can be implemented in the interface shown in FIG. The visual query interface from attribute to space is shown in Figure 4. - Editing of drilling information. It includes the addition, modification, and deletion of drill holes. The relevant drilling information can be edited through the interface of Figure 4. The addition and deletion requirements of the drill hole are not only reflected in the increase or decrease of the corresponding record in the attribute library, but also require the corresponding addition and deletion of the drill hole in the specified position on the space graphic, that is, the real-time association between the drilling attribute and the spatial data. - Thematic map production. Users can display information according to thematic maps such as points, thematic rendering areas, pie charts, and histograms to provide relevant decision-making basis, as well as some basic operations such as controlling, scaling, or roaming the graphics. Taking the drilling coal thickness information production range diagram as an example, the implementation interface is shown in Fig. 5. - The drawing of the contour map. By referring to Surfer's Application object, it communicates with Surfer's main program in Visual Basic6, making full use of Surfer8's powerful drawing function to draw various contour maps for drilling basic information. Taking the coal thickness data of the drilling information as an example, a 3D surface map is drawn, and the effect is shown in FIG. 6. 3 Conclusion ——The drilling information management system uses the combination of relational database and GIS spatial information storage format to solve the storage problem of drilling related information, and provides the graphical management and performance related functions of drilling information for future drilling. Spatial and non-spatial analysis of hole information provides a powerful implementation platform; -- Object-oriented programming and implementation, providing the system with good stability, scalability and compatibility with other systems, and easy integration with other systems or platforms; ——The mine geographic information system can support the expansion of the system through a series of interfaces. By inheriting these interfaces, the function of interface definition can be realized, and the function expansion of the mine geographic information system can be realized. The method helps to reduce the coupling between different modules and improve the cohesion of the module. At the same time, the extended part can be separately designed and implemented outside the system, which is convenient for development and maintenance, and meets the requirements of software engineering for system design. Car Sun Shade,Sun Visor Car Window,Sun Visor For Car,Windshield Visors Ningbo Longyang Auto Products Co., Ltd. , https://www.longyang-manufacturer.com