Method and device for drawing realistic data effect picture of coal mine stope face

By building a data storage structure in the spatial database and using interpolation algorithm to correct the data, and combining the GIS platform to draw a coal mine mining work surface, the problems of cumbersome drawing and dynamic update are solved, efficiency and accuracy are improved, and are suitable for the needs of different mines.

CN118967861APending Publication Date: 2024-11-15BEIJING LONGRUAN TECHNOLOGIES INC
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202411115673.1
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-08-14
Publication Date
2024-11-15

Smart Images

  • Figure CN118967861A_ABST
    Figure CN118967861A_ABST
Patent Text Reader

Abstract

The invention discloses a coal mine stope face realistic data effect picture drawing method and device, and relates to the technical field of computer software charting.The drawing method comprises the steps that a stope face data and realistic data storage structure is constructed in a GIS platform spatial database, stope face realistic data are collected and corrected, and the realistic data effect picture of the stope face is obtained; storing the corrected stope face realistic data into a spatial database; setting a profile map style, drawing a stope profile map, setting a planar graph style, and drawing a stope planar graph; according to the method for drawing the realistic data effect picture of the coal mine stope face, unified storage and management, automatic mapping and dynamic updating of the realistic data of the stope face are achieved, the drawing efficiency of coal mine geological survey personnel is improved, efficient utilization of the realistic data and diversified drawing requirements of different mines are guaranteed, and the method is suitable for popularization and application. Good application values and popularization prospects are realized.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of computer software drawing, and in particular to a method and device for drawing a realistic data effect diagram of a coal mine working face. Background Art

[0002] The geological support system is one of the important contents of the intelligent construction of coal mines, and it is of great significance to ensure the safe production of coal mines. Therefore, digitization and informatization are the basic requirements for the intelligentization of coal mines. The use of GIS technology to realize the dynamic integration of geological realistic data and geological modeling of working faces is of great significance to the safe and efficient production of mines and the construction of intelligent working faces. In the mining process of the comprehensive mining face of a coal mine, with the orderly recovery of the comprehensive mining face, it is necessary to realistically describe the stratigraphic structure of the mining face at a certain interval. The profile of the mining face is used to indicate the ups and downs and thickness changes of the rock layer and coal seam on the mining line, the rock properties of the top and bottom plates of the coal seams, and the structural forms contained therein. It is used to guide the subsequent cutting planning of the mining face, and also serves as the basic basis for reserve calculation, mine construction design, and the preparation of other thematic maps. At present, there are two main methods for drawing profiles and plan views of mining faces:

[0003] (1) Completely rely on manual data sorting, and then manually input the data to generate the cross-section and plan views of the mining face through the computer;

[0004] When drawing the profile and plan of the mining face, it is necessary to include the profile of the mining face, small columns, coal seam information, automatic calculation of recovery rate, coal exploration points and other information. The thematic map contains a huge amount of information, the operation is cumbersome, the workload is large, and it is easy to make mistakes.

[0005] (2) Organize the data with the help of EXCEL tables, and then generate graphics through the computer through the data interface;

[0006] Coal mine geological survey personnel store manually recorded realistic data in files such as Excel, and use auxiliary mapping software such as AutoCAD and other software plug-ins to draw thematic maps. On the one hand, there are problems such as separation of thematic maps and data processing interfaces and poor visualization effects. On the other hand, there is a lack of dynamic updates of the gallery, and the thematic maps cannot be updated in a timely manner, which is not conducive to the dynamic update and efficient use of realistic data. Summary of the invention

[0007] In view of the shortcomings of the above-mentioned prior art, the embodiments of the present application provide a method and device for drawing realistic data renderings of a coal mine working face, so as to solve the problems of cumbersome drawing of the mining working face profile and the need for automatic mapping and dynamic updating of realistic data.

[0008] In a first aspect of an embodiment of the present application, a method for drawing a realistic data rendering of a coal mine working face is provided, the drawing method comprising:

[0009] Based on the business data collected from the coal mining face, the data storage structure and realistic data storage structure of the coal mining face are constructed in the spatial database;

[0010] Based on the business process, collect original realistic data and mining face data from the mining face;

[0011] Using an interpolation algorithm to modify the original realistic data into complete realistic data, and storing the complete realistic data in the spatial database using the realistic data storage structure, and storing the mining face data in the spatial database using the mining face data storage structure;

[0012] Based on the GIS platform and the spatial database, the profile style is set and the profile of the mining face is drawn;

[0013] Based on the GIS platform and the spatial database, the plan view style is set and the plan view of the mining working face is drawn.

[0014] Furthermore, based on the business data collected from the coal mine working face, a data storage structure for the working face and a realistic data storage structure are constructed in the spatial database, including:

[0015] Based on the data collected from the coal mine working face, determining the associated fields between the working face data storage structure and the realistic data storage structure;

[0016] Based on the associated fields, the mining face data storage structure and the realistic data storage structure are constructed in the spatial database.

[0017] Furthermore, the method of correcting the original realistic data into complete realistic data by using an interpolation algorithm includes:

[0018] The original realistic data is obtained, wherein the original realistic data includes: first realistic data and second realistic data; the first realistic data at least includes: a support number with a positive number, a roadway mining height, a top coal thickness, a bottom coal thickness, a top breaking thickness, and a bottom cutting thickness; the second realistic data at least includes: a support number with a negative number and a roadway floor elevation;

[0019] The first realistic data and the second realistic data are corrected by using an interpolation algorithm to obtain the complete realistic data; wherein the complete realistic data includes: the bracket number with a positive number or the bracket number with a negative number, the tunnel floor elevation, the tunnel mining height, the coal top thickness, the coal bottom thickness, and the coal thickness; wherein the coal top thickness includes the top coal thickness or the broken top thickness, the coal bottom thickness includes the bottom coal thickness or the cut bottom thickness, and the bracket number with a positive number and the bracket number with a negative number are continuous brackets. The support number is a positive number, and the support length corresponding to the support number is equal to the support length corresponding to the negative number; the top coal thickness is the thickness of the coal seam lifted by the top of the coal mining support at the mining face at the position of the specified support number; the bottom coal thickness is the thickness of the coal seam retained at the bottom of the coal mining support at the mining face at the position of the specified support number; the broken top thickness is the thickness of the coal seam roof rock layer cut at the mining face at the position of the specified support number; the cut bottom thickness is the thickness of the coal seam bottom rock layer cut at the mining face at the position of the specified support number.

[0020] Furthermore, the method of correcting the original realistic data by using an interpolation algorithm comprises the following steps:

[0021] Step S1: sorting the first realistic data from small to large according to the bracket numbers which are positive numbers;

[0022] Step S2: sorting the second realistic data from small to large according to the absolute values ​​of the bracket numbers whose numbers are negative numbers;

[0023] Step S3: using the tunnel floor elevation in the second realistic data to correct the tunnel floor elevation in the first realistic data through the interpolation algorithm;

[0024] Step S4: using the mining height of the tunnel in the first realistic data, and correcting the mining height of the tunnel in the second realistic data by the interpolation algorithm;

[0025] Step S5: using the top coal thickness or the broken top thickness in the first realistic data to correct the coal top thickness in the second realistic data through the interpolation algorithm;

[0026] Step S6: using the bottom coal thickness or the cut bottom thickness in the first realistic data to correct the coal bottom thickness in the second realistic data through the interpolation algorithm;

[0027] Step S7: Correct the coal thickness in the first realistic data and the second realistic data.

[0028] Furthermore, the interpolation algorithm formula includes:

[0029] If the absolute value of the first bracket number corresponding to the first variable data exists and the absolute value of the second bracket number corresponding to the second variable data is greater than or less than the absolute value of the first bracket number, the first interpolation algorithm formula is selected for correction, and the first interpolation algorithm formula is:

[0030]

[0031] Among them, P is the absolute value of the first bracket number, P z is the first variable data; P1 is the second bracket number absolute value that is smaller than the largest absolute value of the first bracket number, P1 z is the second variable data corresponding to P1; P2 is the absolute value of the second bracket number which is greater than the smallest absolute value of the first bracket number, P2 z is the second variable data corresponding to P2;

[0032] If the absolute value of the first bracket number corresponding to the first variable data only has an absolute value of the bracket number corresponding to the second variable data that is greater than the absolute value of the first bracket number, the second interpolation algorithm formula is selected for correction, and the second interpolation algorithm formula is:

[0033]

[0034] Among them, P is the absolute value of the first bracket number, P z is the first variable data; P3 is the absolute value of the second bracket number which is greater than the smallest absolute value of the first bracket number, P3 z is the second variable data corresponding to P3; P4 is the absolute value of the smallest second bracket number greater than P3, P4 z is the second variable data corresponding to P4;

[0035] If the absolute value of the first bracket number corresponding to the first variable data only has the absolute value of the second bracket number corresponding to the second variable data that is smaller than the absolute value of the first bracket number, the third interpolation algorithm formula is selected for correction, and the third interpolation algorithm formula is:

[0036]

[0037] Among them, P is the absolute value of the first bracket number, P z is the first variable data; P5 is the second bracket number absolute value which is smaller than the largest one among the absolute values ​​of the first bracket number, P5 z is the second variable data corresponding to P5; P6 is the absolute value of the largest second bracket number less than P5, P6 z is the second variable data corresponding to P6;

[0038] If the absolute value of the first bracket number corresponding to the first variable data has only one absolute value of the second bracket number corresponding to the second variable data that is smaller than or greater than the absolute value of the first bracket number, the fourth interpolation algorithm formula is selected for correction, and the fourth interpolation algorithm formula is:

[0039] P z =P7 z

[0040] Among them, P is the absolute value of the first bracket number, P z is the first variable data; P7 is the absolute value of the second bracket number which is less than or greater than the absolute value of the first bracket number, P7 z is the second variable data corresponding to P7;

[0041] Among them, the first variable data is the elevation of the tunnel floor in the first realistic data, and the second variable data is the elevation of the tunnel floor in the second realistic data; or the first variable data is the tunnel mining height in the second realistic data, and the second variable data is the tunnel mining height in the first realistic data; or the first variable data is the coal top thickness in the second realistic data, and the second variable data is the top coal thickness or the broken top thickness in the first realistic data; or the first variable data is the coal bottom thickness in the second realistic data, and the second variable data is the bottom coal thickness or the cut bottom thickness in the first realistic data.

[0042] Furthermore, before the original realistic data is corrected by using an interpolation algorithm, the method further includes:

[0043] Determine whether there is a second bracket number absolute value greater than or less than the first bracket number absolute value;

[0044] If not, it is determined that the first realistic data and / or the second realistic data are incorrect, and data fault information is reported.

[0045] Furthermore, the formula for correcting the coal thickness in the first realistic data and the second realistic data is:

[0046] H=h+th+bh

[0047] Among them, H is the coal thickness; h is the mining height of the tunnel; th is the thickness of the coal top; bh is the thickness of the coal bottom.

[0048] Furthermore, the mining face profile includes information on the recovery rate and the amount of mined coal; wherein the calculation formula for the recovery rate is:

[0049]

[0050] Among them, Q is the recovery rate; ah is the average roadway mining height; ath is the average top-breaking coal thickness; abh is the average bottom-cutting coal thickness; ach is the average coal thickness;

[0051] The calculation formula for the amount of coal produced is:

[0052] W=L×(ah+ath+abh)×d×ρ

[0053] Among them, W is the amount of coal mined; L is the length of the mining face; ah is the average mining height of the tunnel; ath is the average top-breaking coal thickness; abh is the average bottom-cutting coal thickness; d is the depth of each cut; ρ is the density of coal.

[0054] Furthermore, the setting of the profile style includes: annotation height, title height, line width, annotation accuracy, small columnar annotation height, small columnar font, horizontal scale, vertical scale, small columnar scale, title name, unit name and grid spacing; the mining face profile is composed of a group of points, lines, surfaces and text annotations, and the mining face profile includes: profile title, mining face sketch, coal seam small columnar, legend, realistic data information and remarks information;

[0055] The plan view style setting includes: coal exploration point height, annotation height, line width, coal seam information location, annotation accuracy, map scale and plan point type; the mining working face plan view is composed of a group of points, lines and text annotations, and the mining working face plan view includes: mining lines, plane points, coal seam information, entry date and average coal thickness.

[0056] In a second aspect of the embodiment of the present application, a device for drawing a realistic data rendering of a coal mine working face is provided, the device comprising:

[0057] A construction module is used to collect data from coal mine working face operations and to construct working face data storage structures and realistic data storage structures in a spatial database;

[0058] The acquisition module is used to obtain original realistic data and mining face data based on business processes;

[0059] A correction module, used for correcting the original realistic data into complete realistic data by using an interpolation algorithm, storing the complete realistic data in the spatial database in the realistic data storage structure, and storing the mining face data in the spatial database in the mining face data storage structure;

[0060] The first drawing module is used to set the profile style and draw the profile of the mining face based on the GIS platform and the spatial database;

[0061] The second drawing module is used to set the plan style and draw the plan of the mining working face based on the GIS platform and the spatial database.

[0062] The present embodiment provides a method for drawing a realistic data rendering of a coal mine recovery working face, the drawing method comprising: based on the coal mine recovery working face business collection data, constructing a recovery working face data storage structure and a realistic data storage structure in a spatial database; wherein the coal mine recovery working face business collection data comprises: original realistic data and recovery working face data; using an interpolation algorithm to correct the original realistic data into complete realistic data, and storing the complete realistic data in the spatial database in the realistic data storage structure, and storing the recovery working face data in the spatial database in the recovery working face data storage structure; based on a GIS platform and a spatial database, setting a profile style and drawing a recovery working face profile, and based on a GIS platform and a spatial database, setting a plan style and drawing a recovery working face plan.

[0063] By constructing a mining face data storage structure and a realistic data storage structure in a spatial database, and using an interpolation algorithm to correct the original realistic data into complete realistic data, and storing the complete realistic data in the spatial database in the realistic data storage structure, and storing the mining face data in the spatial database in the mining face data storage structure, unified storage and management of complete realistic data and mining face data can be achieved.

[0064] Secondly, through the GIS platform and spatial database, the profile style and plan style can be set to adapt to the diverse drawing needs of different mines, and the profile and plan views of the mining working face can be drawn, thereby improving the drawing efficiency and accuracy of the realistic data renderings of the coal mine mining working face.

[0065] The present invention realizes the unified storage and management of realistic data of mining working faces, automatic mapping and dynamic updating of diversified parameter settings, improves the drawing efficiency of coal mine geological surveyors, enriches the dynamic update data source of geological models of coal mine mining working faces, ensures the efficient use of realistic data, and the diversified matching of parameters is suitable for the diversified drawing needs of different mines, and has good application value and promotion prospects. BRIEF DESCRIPTION OF THE DRAWINGS

[0066] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for use in the description of the embodiments of the present application will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative labor.

[0067] Figure 1A flowchart of the steps of a method for drawing a realistic data effect diagram of a coal mine working face provided by an embodiment of the present invention;

[0068] Figure 2 A flowchart of the steps of correcting realistic data of a mining face provided by an embodiment of the present invention;

[0069] Figure 3 A cross-sectional effect diagram of a mining working face provided by an embodiment of the present invention;

[0070] Figure 4 The effect diagram of the plan view of the mining working face provided by the embodiment of the present invention;

[0071] Figure 5 A schematic diagram of a device for drawing realistic data renderings of a coal mine working face provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0072] The exemplary embodiments of the present application will be described in more detail below in conjunction with the accompanying drawings in the embodiments of the present application. Although the exemplary embodiments of the present application are shown in the accompanying drawings, it should be understood that the present application can be implemented in various forms and should not be limited by the embodiments set forth herein. On the contrary, these embodiments are provided in order to enable a more thorough understanding of the present application and to enable the scope of the present application to be fully conveyed to those skilled in the art.

[0073] See also Figure 1 , Figure 1 A flowchart of the steps of a method for drawing a realistic data rendering of a coal mine working face provided by an embodiment of the present invention, Figure 1 The specific steps include:

[0074] Step S01: Based on the coal mine recovery working face business data collection, a recovery working face data storage structure and a realistic data storage structure are constructed in the spatial database.

[0075] In this embodiment, the coal mine recovery working face business collection data is the data that needs to be collected for the coal mine recovery working face business process. The spatial database may include a SqlServer database, a DAMO database, and a MySQL database. The recovery working face data storage structure and the realistic data storage structure are constructed in the spatial database. The recovery working face data storage structure and the realistic data storage structure can be regarded as the header fields of two tables, wherein the header fields of the table corresponding to the recovery working face data structure include: ID, mine name, mine code, working face name, entry date, support starting point coordinate X, support starting point coordinate Y, support starting point coordinate Z, support end point coordinate X, support end point coordinate Y, support end point coordinate Z, total number of supports, and support unit length.

[0076] The header fields of the table corresponding to the realistic data storage structure include: FID, bracket sequence number, bracket number, tunnel floor elevation, tunnel mining height, coal top thickness, coal bottom thickness, and coal thickness.

[0077] Since the mining face data and complete realistic data are required when drawing the realistic data rendering of the mining face, when constructing the mining face data storage structure and the realistic data storage structure, it is also necessary to determine the associated fields between the mining face data storage structure and the realistic data storage structure. The associated fields are used to characterize the unique corresponding association relationship between the mining face data storage structure and the realistic data storage structure, that is, the realistic data corresponding to the associated fields can be found through the associated fields of the mining face data storage structure. A piece of realistic data can be uniquely determined by the mine name, the face name and the entry date, such as the ID in the mining face data structure and the FID in the realistic data storage structure, wherein the FID field in the realistic data storage structure is associated with the ID field in the mining face data structure, that is, the ID field and the FID field are the associated fields of the mining face data storage structure and the realistic data storage structure, respectively.

[0078] Since there can only be one value for the top coal thickness and the broken top thickness, called the coal top thickness; there can only be one value for the bottom coal thickness and the cut bottom thickness, called the coal bottom thickness, only two fields, coal top thickness and coal bottom thickness, are added to the realistic data storage structure.

[0079] Step S02: Based on the business process, original realistic data and mining face data are collected from the mining face.

[0080] In this embodiment, the geologists are mainly responsible for studying the geological characteristics and their changing laws of coal mine strata, geological structures, coal seams, coal quality, gas, hydrogeology, rock burst, engineering geology and other mining geological conditions, and carrying out geological type classification; identifying various hidden disaster-causing geological factors that affect the safe production of coal mines; conducting geological supplementary investigations and explorations, geological observations, data compilation and comprehensive analysis, providing the geological data required for coal mine construction and production at all stages, and solving various geological problems in coal mine safety production; estimating and verifying the coal resource reserves and coal mine gas (coalbed methane) resource reserves of coal mines, mastering the dynamics of resource reserves, and providing a reliable basis for the reasonable arrangement of production; investigating and studying the occurrence and mining and utilization value of co-existing (associated) minerals in coal-bearing strata of coal mines.

[0081] Surveyors are mainly responsible for surveying, investigation, mapping and other work to provide data support and technical guarantee for coal mining. Surveyors can skillfully operate surveying instruments and equipment, and have the ability to draw drawings, process data and conduct survey analysis. They need to be proficient in using total stations, GPS and other surveying equipment to conduct comprehensive data collection and processing of ore bodies, and provide accurate data support for mine design and mining. Surveying of mining projects, including tunneling, development, and mining, also requires real-time monitoring of tunneling direction, depth, elevation and other data to ensure the smooth progress of mining projects.

[0082] According to the business process, geologists and surveyors collect mining face data and original realistic data from the mining face respectively. The original realistic data collected by geologists include at least: support number with positive number, tunnel mining height, top coal thickness, bottom coal thickness, top breaking thickness, and bottom cutting thickness. The original realistic data of the mining face collected by surveyors include at least: support number with negative number and tunnel bottom plate elevation.

[0083] In order to distinguish the data collected by geologists and surveyors respectively, the data collected by geologists can be called the first realistic data, and the data collected by surveyors can be called the second realistic data. Since there are bracket numbers in both the first realistic data and the second realistic data, in order to distinguish the first realistic data from the second realistic data, the bracket numbers in the first realistic data are marked as bracket numbers with positive numbers, and the bracket numbers in the second realistic data are marked as bracket numbers with negative numbers. The bracket numbers with negative numbers are just a negative number mark added before the number, and are not used to distinguish between large and small.

[0084] The mining face data collected by geologists and surveyors include: mine name, mining face name, and collection date. Since the mining face data collected by geologists and surveyors is the mining face morphology after the same mining cut, only one copy of the mining face data collected by geologists and surveyors is entered when entering the mining face data.

[0085] Step S03: using an interpolation algorithm to correct the original realistic data into complete realistic data, and storing the complete realistic data in the spatial database in the realistic data storage structure, and storing the mining face data in the spatial database in the mining face data storage structure.

[0086] According to the business operation process of the coal mine, the original realistic data information needs to be stored in the spatial database in the realistic data storage structure. Therefore, the information entered by the geologist includes: the support number with a positive number, the tunnel mining height, the top coal thickness, the bottom coal thickness, the top breaking thickness, and the bottom cutting thickness; the information entered by the surveyor includes: the support number with a negative number and the tunnel floor elevation. When the first realistic data collected by the geologist is entered alone, the tunnel floor elevation may be missing. When the second realistic data collected by the surveyor is entered, the tunnel mining height, the top coal thickness, the bottom coal thickness, the top breaking thickness, the bottom cutting thickness, and the coal thickness may be missing. Therefore, the first realistic data or the second realistic data entered alone are incomplete. The geologist and the surveyor need to cooperate to correct the original realistic data to complete realistic data, and then store the complete realistic data in the spatial database in the realistic data storage structure. At the same time, in order to ensure the accuracy of the drawing of the realistic data effect map of the coal mine recovery working face, the recovery working face data also needs to be stored in the spatial database in the recovery working face data storage structure.

[0087] The process of correcting the original realistic data by using the interpolation algorithm, that is, correcting the first realistic data and the second realistic data to obtain the complete realistic data, can be specifically implemented by the following steps:

[0088] Reference Figure 2 , Figure 2 A flowchart of the steps of correcting the realistic data of the mining face provided by the embodiment of the present invention, from Figure 2 It can be seen that the steps for correcting the original realistic data of the mining face measured by the geological and surveying personnel include:

[0089] Step S1: sorting the first realistic data from small to large according to the bracket numbers which are positive numbers;

[0090] Step S2: sorting the second realistic data from small to large according to the absolute values ​​of the bracket numbers whose numbers are negative numbers;

[0091] Step S3: using the tunnel floor elevation in the second realistic data to correct the tunnel floor elevation in the first realistic data through the interpolation algorithm;

[0092] Step S4: using the mining height of the tunnel in the first realistic data, and correcting the mining height of the tunnel in the second realistic data by the interpolation algorithm;

[0093] Step S5: using the top coal thickness or the broken top thickness in the first realistic data to correct the coal top thickness in the second realistic data through the interpolation algorithm;

[0094] Step S6: using the bottom coal thickness or the cut bottom thickness in the first realistic data to correct the coal bottom thickness in the second realistic data through the interpolation algorithm;

[0095] Step S7: Correct the coal thickness in the first realistic data and the second realistic data.

[0096] The first realistic data and the second realistic data are corrected by the correction method of steps S1-S7, and the complete realistic data obtained is: the first realistic data and the second realistic data are corrected by using the interpolation algorithm to obtain the complete realistic data, and the complete realistic data includes the first realistic data and the second realistic data, so the complete realistic data includes: bracket number, tunnel floor elevation, tunnel mining height, coal top thickness, coal bottom thickness, coal thickness; wherein, the bracket number is continuous, and the length of the bracket corresponding to each bracket number is equal, so the bracket length corresponding to the bracket number with a positive number is equal to the bracket length corresponding to the bracket number with a negative number. The top coal thickness is the thickness of the coal seam supported by the top of the coal mining support at the mining face at the specified support number position, expressed by a positive number or zero; the broken top thickness is the thickness of the coal seam roof stratum cut by the mining face at the specified support number position, expressed by a negative number; the bottom coal thickness is the thickness of the coal seam retained at the bottom of the coal mining support at the mining face at the specified support number position, expressed by a positive number or zero; the cut bottom thickness is the thickness of the coal seam bottom stratum cut by the mining face at the specified support number position, expressed by a negative number; there can only be one value for the top coal thickness and the broken top thickness, called the coal roof thickness; among them, there can only be one value for the bottom coal thickness and the cut bottom thickness, called the coal bottom thickness.

[0097] During the correction process, different interpolation algorithm formulas can be selected to correct the first realistic data and the second realistic data according to different situations to obtain complete realistic data. Specifically, the second realistic data can be corrected by the first realistic data to obtain complete realistic data, or the first realistic data can be corrected by the second realistic data to obtain complete realistic data.

[0098] Therefore, when the first variable data is the tunnel floor elevation in the first realist data, the second variable data is the tunnel floor elevation in the second realist data; or when the first variable data is the tunnel mining height in the second realist data, the second variable data is the tunnel mining height in the first realist data; or when the first variable data is the coal top thickness in the second realist data, the second variable data is the top coal thickness or the broken top thickness in the first realist data; or when the first variable data is the coal bottom thickness in the second realist data, the second variable data is the bottom coal thickness or the cut bottom thickness in the first realist data.

[0099] The first case: if the absolute value of the first bracket number corresponding to the first variable data exists and the absolute value of the second bracket number corresponding to the second variable data is greater than or less than the absolute value of the first bracket number, the first interpolation algorithm formula is selected for correction, and the first interpolation algorithm formula is:

[0100]

[0101] Among them, P is the absolute value of the first bracket number, P z is the first variable data; P1 is the second bracket number absolute value that is smaller than the largest absolute value of the first bracket number, P1 z is the second variable data corresponding to P1; P2 is the absolute value of the second bracket number which is greater than the smallest absolute value of the first bracket number, P2 z is the second variable data corresponding to P2;

[0102] Second case: if the absolute value of the first bracket number corresponding to the first variable data only has an absolute value of the bracket number corresponding to the second variable data that is greater than the absolute value of the first bracket number, the second interpolation algorithm formula is selected for correction, and the second interpolation algorithm formula is:

[0103]

[0104] Among them, P is the absolute value of the first bracket number, P z is the first variable data; P3 is the absolute value of the second bracket number which is greater than the smallest absolute value of the first bracket number, P3 z is the second variable data corresponding to P3; P4 is the absolute value of the smallest second bracket number greater than P3, P4 z is the second variable data corresponding to P4;

[0105] The third case: if the absolute value of the first bracket number corresponding to the first variable data only has the second bracket number absolute value corresponding to the second variable data that is smaller than the absolute value of the first bracket number, the third interpolation algorithm formula is selected for correction, and the third interpolation algorithm formula is:

[0106]

[0107] Among them, P is the absolute value of the first bracket number, P z is the first variable data; P5 is the second bracket number absolute value which is smaller than the largest one among the absolute values ​​of the first bracket number, P5 z is the second variable data corresponding to P5; P6 is the absolute value of the largest second bracket number less than P5, P6 z is the second variable data corresponding to P6;

[0108] Fourth case: if the absolute value of the first bracket number corresponding to the first variable data has only one absolute value of the second bracket number corresponding to the second variable data that is smaller than or larger than the absolute value of the first bracket number, the fourth interpolation algorithm formula is selected for correction, and the fourth interpolation algorithm formula is:

[0109] P z =P7 z

[0110] Among them, P is the absolute value of the first bracket number, P z is the first variable data; P7 is the absolute value of the second bracket number which is less than or greater than the absolute value of the first bracket number, P7 z is the second variable data corresponding to P7;

[0111] In addition to the above five situations, there may be situations where the first realistic data and the second realistic data cannot be used, that is, there is no absolute value of the second bracket number that is greater than or less than the absolute value of the first bracket number. At this time, it is proved that the first realistic data or the second realistic data is wrong, and the first realistic data or the second realistic data cannot be corrected through the interpolation algorithm to obtain complete realistic data. Data fault information will be reported and the entry of realistic data for the coal mine recovery working face will be stopped.

[0112] By the correction method of step S5, the coal thickness in the first realistic data and the second realistic data is corrected, and the formula is:

[0113] H=h+th+bh

[0114] Among them, H is the coal thickness; h is the mining height of the tunnel; th is the thickness of the coal top; bh is the thickness of the coal bottom.

[0115] Step S04: Based on the GIS platform and the spatial database, set the profile style and draw the profile of the mining working face.

[0116] The profile drawing style includes: annotation height (unit mm), title height (unit mm), line width (unit mm), annotation accuracy, small columnar annotation height (unit mm), small columnar font, horizontal scale, vertical scale, small columnar scale, title name, unit name, grid spacing; the profile drawing of the mining working face is composed of a set of point, line, surface, and text annotations, including: profile drawing title, mining working face sketch, coal seam small column, legend, realistic data information and remarks information.

[0117] In addition, Figure 3 It can be seen that the mining face profile also includes: recovery rate and mined coal volume annotation information, where the calculation formula for the recovery rate is:

[0118]

[0119] Among them, Q is the recovery rate; ah is the average roadway mining height; ath is the average top-breaking coal thickness; abh is the average bottom-cutting coal thickness; ach is the average coal thickness;

[0120] The calculation formula for the amount of coal produced is:

[0121] W=L×(ah+ath+abh)×d×ρ

[0122] Wherein, W is the amount of coal mined; L is the length of the mining face; ah is the average mining height of the tunnel; ath is the average top-breaking coal thickness; abh is the average bottom-cutting coal thickness; d is the depth of each cut; ρ is the density of coal; in this embodiment, each cut refers to the coal mining machine cutting coal once from the head to the tail of the mining face, or from the tail to the head.

[0123] Reference Figure 3 , Figure 3 The cross-sectional effect diagram of the mining working face provided by the embodiment of the present invention is as follows: Figure 3 It can be seen that the profile of the mining face is used to show the thickness changes of rock and coal seams on the mining line, the lithology of the coal seam roof and floor, and the structural morphology. It can be used to guide the cutting plan of the subsequent mining face, and can also be used as a basic basis for reserve calculation, mine construction design, and the preparation of other thematic maps. In actual work, the top coal thickness is obtained by using a pneumatic drill to detect from the top of the support to the top of the coal seam, the bottom coal thickness is obtained by detecting the coal thickness from the bottom of the support to the bottom of the coal seam with professional equipment, the top-breaking thickness is measured by referring to the coal seam line on the coal wall at the top of the support and the support roof, and the top-breaking thickness is measured by referring to the coal seam line on the coal wall at the bottom of the support and the support bottom. The support height is the mining height of the tunnel. The profile of the mining face includes: a profile title, a sketch of the mining face, a small columnar coal seam, a legend, realistic data information and note information, wherein the sketch of the mining face may include the top and bottom plate lines of the tunnel, the top and bottom plate lines of the coal seam, the mining area, the top and bottom coal loss area, the rock layer area, and the support position information; the realistic data information may include realistic mining data and working face information, and working face excavation conditions; the note information may include the recovery rate notes and the mined coal quantity notes for each cut, wherein the recovery rate notes are obtained through the recovery rate calculation formula, and the mined coal quantity notes are obtained through the mined coal quantity calculation formula; the mined coal quantity of each cut of the mining face can be used as basic data for dynamic calculation of coal mine reserves.

[0124] Reference Figure 4 , Figure 4 The effect diagram of the plan view of the mining working face provided by the embodiment of the present invention is as follows: Figure 4It can be seen that the plan view of the mining face can be used to represent the shape of the mining line on the plane, and to display the coal seam information of the frame number position entered in the realistic data, including the coal top thickness, support height, coal bottom thickness and other information. In order to display the recorded realistic data on the plane in the thematic map, it is necessary to calculate the actual plane coordinates of each realistic point. When the starting coordinates and end coordinates of the support are known, the plane coordinates of each realistic point can be obtained by setting the support sorting method and using the point offset algorithm. By setting the plane map style, the realistic data point symbols and coal seam information annotations are saved as a unified whole to ensure the beauty and convenience of the realistic data point mapping, and users can easily edit, modify, delete and other operations. The coal seam thickness of the realistic point is calculated by the realistic point data, and the calculated data is stored in the coal seam geological measurement database, and the coal seam geological measurement data of the mining face is continuously updated and enriched, so as to improve the accuracy of the high-precision three-dimensional dynamic geological model of the mining face.

[0125] Through the method provided by the present invention, unified storage and management of realistic data of mining working faces are realized, and automatic mapping and dynamic updating of diversified parameter settings are realized, which improves the drawing efficiency of coal mine geological surveyors, enriches the dynamic update data source of geological models of coal mine mining working faces, ensures the efficient use of realistic data, and the diversified matching of parameters is suitable for the diversified drawing needs of different mines, and has good application value and promotion prospects.

[0126] Reference Figure 5 , Figure 5 A schematic diagram of a device for drawing a realistic data effect diagram of a coal mine working face provided by an embodiment of the present invention. Figure 5 It can be seen that the drawing device provided in this embodiment includes:

[0127] Construction module 501, for constructing a mining face data storage structure and a realistic data storage structure in a spatial database based on coal mine mining face business collection data;

[0128] The acquisition module 502 is used to acquire original realistic data and mining face data based on the business process;

[0129] A correction module 503 is used to correct the original realistic data into complete realistic data by using an interpolation algorithm, and store the complete realistic data in the spatial database in the realistic data storage structure, and store the mining face data in the spatial database in the mining face data storage structure;

[0130] The first drawing module 504 is used to set the profile style and draw the profile of the mining face based on the GIS platform and the spatial database;

[0131] The second drawing module 505 is used to set the plan style and draw the plan of the mining face based on the GIS platform and the spatial database;

[0132] In addition, the correction module includes a mining face realistic data management module, which is used for adding, modifying, correcting, deleting and querying mining face data and realistic data in the spatial database.

[0133] The first drawing module includes: a profile style setting module and a profile drawing module: the profile style setting module is used to set the display style of the profile of the mining working face; the profile drawing module is used to obtain the mining working face data and realistic data of the specified mine name, working face name, and entry date, and to display the progress of the working face advancement and the thickness changes of the rock layer and coal seam on the mining line, the lithology of the coal seam roof and floor, and the structural morphology in the form of a profile.

[0134] The second drawing module includes: a plan view style setting module and a plan view drawing module. The plan view style setting module is used to set the display style of the plan view of the mining face; the plan view drawing module is used to obtain the mining face data and realistic data of the specified mine name, working face name, and entry date, and display the coal seam information of the working face mining line and the specified support position in the form of a plan view.

[0135] The various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The same or similar parts between the various embodiments can be referenced to each other.

[0136] The embodiments of the present invention are described with reference to the flowcharts and / or block diagrams of the methods and devices according to the embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of the processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing terminal device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing terminal device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0137] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing terminal device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce a manufactured product including an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1A function specified in one or more boxes.

[0138] These computer program instructions can also be loaded onto a computer or other programmable data processing terminal device so that a series of operating steps are executed on the computer or other programmable terminal device to produce a computer-implemented process, thereby providing instructions for executing on the computer or other programmable terminal device to implement the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0139] Although the preferred embodiments of the present invention have been described, those skilled in the art may make additional changes and modifications to these embodiments once they have learned the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications that fall within the scope of the embodiments of the present invention.

[0140] Finally, it should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or terminal device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or terminal device. In the absence of further restrictions, the elements defined by the sentence "including one..." do not exclude the existence of other identical elements in the process, method, article or terminal device including the elements.

[0141] The above is a detailed introduction to the method and device for drawing a realistic data rendering of a coal mine recovery working face provided by the present invention. Specific examples are used in this article to illustrate the principles and implementation methods of the present invention. The description of the above embodiments is only used to help understand the method of the present invention and its core idea; at the same time, for general technical personnel in this field, according to the idea of ​​the present invention, there will be changes in the specific implementation method and application scope. In summary, the content of this specification should not be understood as a limitation on the present invention.

Claims

1. A method for drawing a realistic data effect diagram of a coal mine working face, characterized in that: The drawing method comprises: Based on the business data collected from the coal mining face, the data storage structure and realistic data storage structure of the coal mining face are constructed in the spatial database; Based on the business process, collect original realistic data and mining face data from the mining face; Using an interpolation algorithm to modify the original realistic data into complete realistic data, and storing the complete realistic data in the spatial database using the realistic data storage structure, and storing the mining face data in the spatial database using the mining face data storage structure; Based on the GIS platform and the spatial database, the profile style is set and the profile of the mining face is drawn; Based on the GIS platform and the spatial database, the plan view style is set and the plan view of the mining working face is drawn.

2. The drawing method according to claim 1, characterized in that: Based on the business data collected from the coal mining face, the mining face data storage structure and the realistic data storage structure are constructed in the spatial database, including: Based on the data collected from the coal mine working face, determining the associated fields between the working face data storage structure and the realistic data storage structure; Based on the associated fields, the mining face data storage structure and the realistic data storage structure are constructed in the spatial database.

3. The drawing method according to claim 1, characterized in that: The method of modifying the original realistic data into complete realistic data by using an interpolation algorithm includes: The original realistic data is obtained, wherein the original realistic data includes: first realistic data and second realistic data; the first realistic data at least includes: a support number with a positive number, a roadway mining height, a top coal thickness, a bottom coal thickness, a top breaking thickness, and a bottom cutting thickness; the second realistic data at least includes: a support number with a negative number and a roadway floor elevation; The first realistic data and the second realistic data are corrected by using an interpolation algorithm to obtain the complete realistic data; wherein the complete realistic data includes: the bracket number with a positive number or the bracket number with a negative number, the tunnel floor elevation, the tunnel mining height, the coal top thickness, the coal bottom thickness, and the coal thickness; wherein the coal top thickness includes the top coal thickness or the broken top thickness, the coal bottom thickness includes the bottom coal thickness or the cut bottom thickness, and the bracket number with a positive number and the bracket number with a negative number are continuous brackets. The support number is a positive number, and the support length corresponding to the support number is equal to the support length corresponding to the negative number; the top coal thickness is the thickness of the coal seam lifted by the top of the coal mining support at the mining face at the position of the specified support number; the bottom coal thickness is the thickness of the coal seam retained at the bottom of the coal mining support at the mining face at the position of the specified support number; the broken top thickness is the thickness of the coal seam roof rock layer cut at the mining face at the position of the specified support number; the cut bottom thickness is the thickness of the coal seam bottom rock layer cut at the mining face at the position of the specified support number.

4. The drawing method according to claim 3, characterized in that: The method of correcting the original realistic data by using an interpolation algorithm comprises the following steps: Step S1: sorting the first realistic data from small to large according to the bracket numbers which are positive numbers; Step S2: sorting the second realistic data from small to large according to the absolute values ​​of the bracket numbers whose numbers are negative numbers; Step S3: using the tunnel floor elevation in the second realistic data to correct the tunnel floor elevation in the first realistic data through the interpolation algorithm; Step S4: using the mining height of the tunnel in the first realistic data, and correcting the mining height of the tunnel in the second realistic data by the interpolation algorithm; Step S5: using the top coal thickness or the broken top thickness in the first realistic data to correct the coal top thickness in the second realistic data through the interpolation algorithm; Step S6: using the bottom coal thickness or the cut bottom thickness in the first realistic data to correct the coal bottom thickness in the second realistic data through the interpolation algorithm; Step S7: Correct the coal thickness in the first realistic data and the second realistic data.

5. The drawing method according to claim 4, characterized in that: The interpolation algorithm formula includes: If the absolute value of the first bracket number corresponding to the first variable data exists and the absolute value of the second bracket number corresponding to the second variable data is greater than or less than the absolute value of the first bracket number, the first interpolation algorithm formula is selected for correction, and the first interpolation algorithm formula is: Among them, P is the absolute value of the first bracket number, P z is the first variable data; P1 is the second bracket number absolute value that is smaller than the largest absolute value of the first bracket number, P1 z is the second variable data corresponding to P1; P2 is the absolute value of the second bracket number which is greater than the smallest absolute value of the first bracket number, P2 z is the second variable data corresponding to P2; If the absolute value of the first bracket number corresponding to the first variable data only has an absolute value of the bracket number corresponding to the second variable data that is greater than the absolute value of the first bracket number, the second interpolation algorithm formula is selected for correction, and the second interpolation algorithm formula is: Among them, P is the absolute value of the first bracket number, P z is the first variable data; P3 is the absolute value of the second bracket number which is greater than the smallest absolute value of the first bracket number, P3 z is the second variable data corresponding to P3; P4 is the absolute value of the smallest second bracket number greater than P3, P4 z is the second variable data corresponding to P4; If the absolute value of the first bracket number corresponding to the first variable data only has the absolute value of the second bracket number corresponding to the second variable data that is smaller than the absolute value of the first bracket number, the third interpolation algorithm formula is selected for correction, and the third interpolation algorithm formula is: Among them, P is the absolute value of the first bracket number, P z is the first variable data; P5 is the second bracket number absolute value which is smaller than the largest one among the absolute values ​​of the first bracket number, P5 z is the second variable data corresponding to P5; P6 is the absolute value of the second bracket number that is smaller than P5, z is the second variable data corresponding to P6; If the absolute value of the first bracket number corresponding to the first variable data has only one absolute value of the second bracket number corresponding to the second variable data that is smaller than or greater than the absolute value of the first bracket number, the fourth interpolation algorithm formula is selected for correction, and the fourth interpolation algorithm formula is: P z =P7 z Among them, P is the absolute value of the first bracket number, P z is the first variable data; P7 is the absolute value of the second bracket number which is less than or greater than the absolute value of the first bracket number, P7 z is the second variable data corresponding to P7; Among them, the first variable data is the elevation of the tunnel floor in the first realistic data, and the second variable data is the elevation of the tunnel floor in the second realistic data; or the first variable data is the tunnel mining height in the second realistic data, and the second variable data is the tunnel mining height in the first realistic data; or the first variable data is the coal top thickness in the second realistic data, and the second variable data is the top coal thickness or the broken top thickness in the first realistic data; or the first variable data is the coal bottom thickness in the second realistic data, and the second variable data is the bottom coal thickness or the cut bottom thickness in the first realistic data.

6. The drawing method according to claim 4, characterized in that: Before the method of correcting the original realistic data by using an interpolation algorithm, the method further includes: Determine whether there is a second bracket number absolute value greater than or less than the first bracket number absolute value; If not, it is determined that the first realistic data and / or the second realistic data are incorrect, and data fault information is reported.

7. The drawing method according to claim 4, characterized in that: The formula for correcting the coal thickness in the first realistic data and the second realistic data is: H=h+th+bh Among them, H is the coal thickness; h is the mining height of the tunnel; th is the thickness of the coal top; bh is the thickness of the coal bottom.

8. The method according to claim 1, characterized in that The mining face profile includes information on the recovery rate and the amount of coal mined; wherein the calculation formula for the recovery rate is: Among them, Q is the recovery rate; ah is the average roadway mining height; ath is the average top-breaking coal thickness; abh is the average bottom-cutting coal thickness; ach is the average coal thickness; The calculation formula for the amount of coal produced is: W=L×(ah+ath+abh)×d×ρ Among them, W is the amount of coal mined; L is the length of the mining face; ah is the average mining height of the tunnel; ath is the average top-breaking coal thickness; abh is the average bottom-cutting coal thickness; d is the depth of each cut; ρ is the density of coal.

9. The drawing method according to claim 1, characterized in that: The setting of the profile style includes: annotation height, title height, line width, annotation accuracy, small columnar annotation height, small columnar font, horizontal scale, vertical scale, small columnar scale, title name, unit name and grid spacing; the mining face profile consists of a group of points, lines, surfaces and text annotations, and the mining face profile includes: profile title, mining face sketch, coal seam small columnar, legend, realistic data information and remarks information; The plan view style setting includes: coal exploration point height, annotation height, line width, coal seam information location, annotation accuracy, map scale and plan point type; the mining working face plan view is composed of a group of points, lines and text annotations, and the mining working face plan view includes: mining lines, plane points, coal seam information, entry date and average coal thickness.

10. A device for drawing realistic data effect diagrams of coal mine working faces, characterized in that: The device comprises: A construction module is used to collect data from coal mine working face operations and to construct working face data storage structures and realistic data storage structures in a spatial database; The acquisition module is used to obtain original realistic data and mining face data based on business processes; A correction module, used for correcting the original realistic data into complete realistic data by using an interpolation algorithm, storing the complete realistic data in the spatial database in the realistic data storage structure, and storing the mining face data in the spatial database in the mining face data storage structure; The first drawing module is used to set the profile style and draw the profile of the mining face based on the GIS platform and the spatial database; The second drawing module is used to set the plan style and draw the plan of the mining working face based on the GIS platform and the spatial database.

Citation Information

Patent Citations

  • Geological cataloguing and drawing system for mine roadway

    CN107990882A

  • Mining surface movement deformation prediction analysis system

    CN110781257A