CN111485943A

CN111485943A - Mine excavation water detection and drainage auxiliary system and method

Info

Publication number: CN111485943A
Application number: CN202010307444.5A
Authority: CN
Inventors: 王艳彬
Original assignee: Beijing Longruan Technologies Inc
Current assignee: Beijing Longruan Technologies Inc
Priority date: 2020-04-17
Filing date: 2020-04-17
Publication date: 2020-08-04
Anticipated expiration: 2040-04-17
Also published as: CN111485943B

Abstract

The application provides a mine excavation water detection and drainage auxiliary system and a mine excavation water detection and drainage auxiliary method, which comprise a drilling track acquisition end, a spatial database and a drawing end; the drilling track acquisition end is used for acquiring actually measured space track data of the water exploration and drainage drilling; the drawing end is used for generating a four-figure-one table of water detection and drainage drilling hole design, previewing, correcting, warehousing and extracting the water detection and drainage drilling hole track, drawing a section diagram of an actually measured position of the water detection and drainage drilling hole at the head-on advanced position of the mine excavation roadway, and matching the four-figure-one table of water detection and drainage drilling hole design to realize the water detection and drainage drilling hole design of the head-on advanced position blind zone of the excavation roadway; establishing a spatial database for storing and sharing actually measured spatial trajectory data; and displaying the spatial position relation among the roadway, the coal bed, the actually-measured spatial trajectory data and the designed water exploration and drainage drilling trajectory data through the three-dimensional view port. The invention greatly improves the efficiency and the achievement quality of the related work of water exploration, drainage and drilling and protects the driving for the safe and rapid excavation of the mine tunnel.

Description

Mine excavation water detection and drainage auxiliary system and method

Technical Field

The invention relates to the technical field of water prevention and control in coal mine fields, in particular to a mine excavation water detection and drainage auxiliary system and a mine excavation water detection and drainage auxiliary method.

Background

Along with the continuous increase of the integration and recombination force of coal resources, a large number of small coal kiln mines with small yield, large pollution and non-compliance are shut down and combined, meanwhile, due to the lack of small coal kiln tunneling data of one hand, a great number of potential tunneling dangers are brought to the subsequent combined mine production, therefore, under the condition that an unknown goaf exists in the well fields of all mines, advanced detection and exploration engineering needs to be carried out in the tunneling process, and the principle of 'tunneling must be detected, and tunneling is carried out after the first detection'.

Old kilns refer primarily to those that have been a result of some coal mining activities in the past, including the present coal mine and other small kilns, and which are relatively long-lived. A part of goaf is left after the old kiln is mined, and the goaf is filled with later-stage underground water or surface water, so that some old kiln accumulated water is formed. If the later underground mining engineering touches the edge of the water body of the accumulated water in the old kiln, the accumulated water in the old kiln can burst into the underground in a sudden bursting manner, so that some sudden water damage accidents are caused.

In general, techniques of surface drilling, surface geophysical prospecting or underground geophysical prospecting can be adopted for mastering the hydrogeological conditions of the mine, but the occurrence conditions of water damage of the mine cannot be completely and reliably determined by the techniques. In the case of mine damage or adverse terrain conditions, ground exploration is difficult to determine mine water damage. Underground geophysical prospecting is susceptible to environmental influences and the effect is not ideal. Therefore, the advanced detection and drainage of water under the well becomes an important means for preventing and controlling water damage.

At present, the laying of the advanced drilling holes of the coal mine tunneling roadway and the exploration condition of the advanced position have the following defects:

firstly, water exploration and drainage work is frequent, the workload of manually compiling drilling design and calculating drilling parameters is large, and the burden of technicians is heavy;

secondly, the manual analysis has large workload, long time consumption and low efficiency when comparing the drilling results, and the possibility of manual calculation errors exists;

thirdly, track data of a drill hole at an advanced position is difficult to obtain, the exploration condition is unclear, the reliability of drilling result analysis is influenced, the deviation between the actual geological condition of a detection area and an expected resource is large, the pertinence of the original design is insufficient, and an unknown water detection blind area exists;

fourthly, artificial calculation errors often occur in the artificial calculation, which is not beneficial to timely obtaining accurate exploration conditions;

and fifthly, the visualization degree is poor, and the actual measurement condition of the drilling hole at the advanced position cannot be understood and analyzed in multiple directions.

Disclosure of Invention

Aiming at the defects in the prior art and the prior art, the application provides a mine tunneling water detection and drainage auxiliary system and a mine tunneling water detection and drainage auxiliary method, which are used for automatically designing the construction parameters of a plurality of water detection and drainage drill holes at the advanced positions according to the given overall design parameters on the basis of the design specification of the water detection and drainage drill holes at the advanced positions in a mine so as to obtain a four-figure-one table of the water detection and drainage drill hole design; the method comprises the following steps that (1) a constructor drives a head-on tunneling construction water detection and drainage drill hole according to a four-figure one table of water detection and drainage drill hole design, measures the actually measured space track data of the water detection and drainage drill hole, and stores the actually measured drill hole track data into a space database for sharing; according to the obtained actually measured space track data, a vertical section map of any position in front of the roadway driving head is drawn, the actually measured advanced exploration drilling track and the three-dimensional display view port of the three-dimensional visualization module are combined, the blind area exploration drainage drilling hole which is designed and repaired is analyzed and designed quickly, the decision-making assisting effect is achieved, and the purposes of preventing and treating old kiln water accumulation and guaranteeing coal mine safety production are achieved.

The application provides in a first aspect a mine tunnelling is visited and is released water auxiliary system, the system includes: the system comprises a drilling track acquisition end, a spatial database and a drawing end; the spatial database is in communication connection with the drawing end;

the drawing end comprises a water exploration and drainage drilling design module, a drilling actual measurement track management module, a blind area drilling inversion design module and a three-dimensional visualization module;

the water detecting and draining drill hole designing module is used for generating a four-figure one table of water detecting and draining drill hole designing according to the overall design parameters of the water detecting and draining drill holes, and constructors construct the water detecting and draining drill holes on the heading side of the roadway according to the four-figure one table of the water detecting and draining drill hole designing;

the drilling track acquisition end is used for acquiring actually measured space track data of a water detecting and draining drill hole in tunneling head-on construction;

the drilling hole actual measurement track management module is used for previewing and correcting the actual measurement space track data collected by the drilling hole track collection end and storing the actual measurement space track data to the space database;

the three-dimensional visualization module is used for displaying a spatial position relation among the roadway, the coal bed, the actually measured spatial trajectory data and the designed water exploration and drainage drilling trajectory data through the three-dimensional viewport so as to provide the blind area drilling inversion design module for performing macro control when automatically analyzing whether a blind area exists at an advanced position of a specified heading distance of the roadway; the design water exploration and drainage drill hole track data are generated according to the overall design parameters of the water exploration and drainage drill hole;

the blind area drilling inversion design module is used for updating a water detection and drainage drilling design plan in the updated water detection and drainage drilling design four-diagram one table and the spatial position relation displayed by the three-dimensional visualization module after the drilling actual measurement track management module updates the water detection and drainage drilling design four-diagram one table according to the actual measurement space track data stored in the space database, arbitrarily sectioning the advanced position of the roadway head so as to automatically analyze whether a blind area exists in the advanced position of the roadway head at a specified distance, and calculating blind area drilling construction parameters under the condition that the blind area exists so as to provide operators for constructing the blind area water detection and drainage drilling in the roadway head according to the blind area drilling construction parameters.

The blind area drilling inversion design module is further configured to update the actually measured spatial trajectory data in the spatial database after the drilling actually measured trajectory management module uses the blind area drilling actually measured spatial trajectory data of the blind area water detection and drainage drilling to update the actually measured spatial trajectory data in the spatial database, and after the water detection and drainage drilling design four-diagram one table is updated according to the updated actually measured spatial trajectory data, the advanced position of the roadway head is arbitrarily sectioned by using the water detection and drainage drilling design plan in the updated water detection and drainage drilling design four-diagram one table, so as to automatically analyze whether a blind area exists at the advanced position of the specified distance of the roadway head until the blind area is eliminated.

Further, the drilling hole actual measurement track management module comprises a preview submodule, and the preview submodule is used for acquiring the actual measurement space track data from the drilling hole track acquisition end and judging whether the actual measurement space track data contains abnormal data or not.

Further, the drilling hole actual measurement track management module comprises a correction submodule, and the correction submodule is used for correcting abnormal data in the actual measurement space track data.

Furthermore, the actually measured space trajectory data consists of relative position information of a plurality of measuring points of each water exploring drill hole; wherein the relative position information of each measuring point comprises azimuth angle, inclination angle and distance information of the measuring point relative to the previous measuring point.

Further, the drilling actual measurement track management module comprises a warehousing submodule, wherein the warehousing submodule is used for converting the relative position information of each measuring point into absolute geodetic coordinate system data consistent with a mining engineering plane diagram in a mining area and storing the absolute geodetic coordinate system data in the spatial database; wherein the actually measured spatial trajectory data comprises two states: before the measured space track data is recorded into the space database, the relative position information of water exploration and drainage drill holes is recorded, and after the measured space track data is recorded into the space database, the absolute geodetic coordinate system data consistent with a mining area mining engineering plan is recorded.

Further, the drilling hole actual measurement track management module comprises an extraction submodule, wherein the extraction submodule is used for extracting the actual measurement space track data from the space database, and then updating the water exploration and drainage drilling hole design four-figure-one table according to the actual measurement space track data.

Further, the water exploration and drainage drill hole design four-diagram one table comprises: the method comprises the following steps of designing a plan view of water exploration and drainage drill holes, designing a section view of the water exploration and drainage drill holes, laying a section view of head-on water exploration and drainage drill holes of a roadway, laying a section view of final holes of the water exploration and drainage drill holes and listing the overall design parameters of the water exploration and drainage drill holes.

Further, the blind area drilling construction parameters are obtained as follows:

and acquiring a starting point position from the updated roadway head-on water detection and drainage drill hole layout sectional diagram, sectioning the advanced position of a specified distance in the updated water detection and drainage drill hole design plane diagram to acquire an end point position, and acquiring the blind area drill hole construction parameters according to the starting point position, the end point position and the space vector of the roadway tunneling direction.

The second aspect of the application provides a mine excavation water detection and drainage auxiliary method which is applied to the mine excavation water detection and drainage auxiliary system; the system comprises: the system comprises a drilling track acquisition end, a spatial database and a drawing end; the spatial database is in communication connection with the drawing end; the drawing end comprises a water exploration and drainage drilling design module, a drilling actual measurement track management module, a blind area drilling inversion design module and a three-dimensional visualization module;

the method comprises the following steps:

step S1, the water detecting and draining drill hole designing module generates a four-drawing one table of water detecting and draining drill hole designing according to the overall design parameters of the water detecting and draining drill hole, and constructors construct the water detecting and draining drill hole on the heading side of the roadway according to the four-drawing one table of water detecting and draining drill hole designing; checking whether the water exploration and drainage drill hole meets design expectations or not by using a three-dimensional visualization module;

step S2, the drilling track acquisition end measures the water detecting and releasing drilling hole of the roadway driving head-on construction to obtain the actually measured space track data; when a constructor designs a four-figure-one table according to the water detecting and draining drill hole to construct the water detecting and draining drill hole at the head of the roadway driving, the constructed water detecting and draining drill hole is measured every time one water detecting and draining drill hole is constructed, so that actually measured space track data is obtained;

step S3, the drilling hole actual measurement track management module previews and corrects the actual measurement space track data and stores the actual measurement space track data in the space database;

step S4, the drilling actual measurement track management module extracts the actual measurement space track data from the spatial database according to the actual measurement space track data in the spatial database so as to update the water exploration and drainage drilling design four-diagram-one table, and the three-dimensional visualization module is used for checking the spatial position relationship between the designed drilling track and the actual measurement drilling track; the designed drilling track is obtained by calculation according to the overall design parameters of the water exploration and drainage drilling; the actual measurement drilling track is obtained according to the actual measurement space track data;

step S5, the blind zone drilling inversion design module arbitrarily cuts at the advanced position of the specified distance of the head of the roadway according to the updated water exploration and drainage drilling design plan in the four-diagram-one table of the water exploration and drainage drilling design and the spatial position relationship displayed by the three-dimensional visualization module, and judges whether a blind zone exists at the advanced position;

step S6, under the condition that a blind area exists at the advanced position of the specified distance of the tunneling head, calculating blind area drilling construction parameters, and detecting and discharging a water drilling hole in the blind area of the tunneling head construction by constructors according to the blind area drilling construction parameters;

step S7, the drilling track acquisition end measures a blind area water detecting and discharging drilling hole of roadway driving head-on construction to obtain actual measurement space track data of the blind area drilling hole; the drilling hole actual measurement track management module updates actual measurement space track data in a space database by using blind area drilling hole actual measurement space track data, and updates the water exploration, drainage and drilling hole design four-figure one table based on the updated actual measurement space track data;

in step S8, steps S3 to S7 are repeatedly executed until the blind area is eliminated.

Based on the design specification of mine advanced water detection and drilling, the invention integrates the data processing and visual analysis of coal mine underground water detection and drainage drilling into a whole based on the theories and technologies of various special researches in the fields of GIS (geographic information system), computational geometry, mine informatization, ground water detection and prevention and control and the like, realizes the standardized storage and real-time sharing of coal mine underground advanced water detection and drainage drilling information, solves the problems of automatic mapping of standardized parameters of advanced position water detection and drainage drilling, spatial topological relation processing, arbitrary sectioning, two-dimensional visualization, blind zone drilling inversion calculation and the like, fully decomposes and processes the business flow, accurately and truly expresses the data required by users by adopting the mode of automatic mapping and manual interactive operation, improves the quality and the working efficiency, reduces the workload of workers, thereby replacing the traditional advanced detection working mode, the method realizes the efficient production of the mining area and promotes the safety management of the mining area, and has important significance for preventing and controlling the water accumulation of the old kiln and ensuring the safety production of the coal mine.

It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings needed to be used in the description of the embodiments of the present application will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and it is obvious for those skilled in the art that other drawings can be obtained according to these drawings without creative efforts.

Fig. 1 is a block diagram of a mine excavation water detecting and discharging auxiliary system provided in an embodiment of the present invention;

FIG. 2 is a schematic view of an elevation projection provided by an embodiment of the present invention;

fig. 3 is a flowchart of a mine excavation water detecting and discharging auxiliary method according to an embodiment of the present invention;

fig. 4 is a four-diagram effect diagram drawn by the mine excavation water detecting and discharging auxiliary method provided by the embodiment of the invention;

fig. 5 is a 'one-table' effect diagram drawn by the mine excavation water detection and drainage auxiliary method provided by the embodiment of the invention.

Detailed Description

In order to make the aforementioned objects, features and advantages of the present application more comprehensible, the present application is described in further detail with reference to the accompanying drawings and the detailed description.

In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be obtained by a person skilled in the art without any inventive step based on the embodiments of the present invention, are within the scope of the present invention.

Referring to fig. 1, fig. 1 shows a block diagram of a mine excavation water detection and drainage auxiliary system in this embodiment, which specifically includes the following structures:

the method comprises the steps of configuring an address of a spatial database in a drawing end based on a mine ground survey graphic processing platform, and realizing wireless/wired connection between the drawing end and the spatial database through a network.

The drilling track acquisition end is used for measuring the actually measured spatial track data of the water detection and drainage drill hole from the water detection and drainage drill hole at the heading end of the mine roadway by using acquisition equipment such as a drilling track measuring instrument; the water exploration and drainage drill hole space track data is composed of a plurality of measuring points, wherein each measuring point comprises azimuth angle, inclination angle and distance information relative to the previous measuring point.

The spatial database is used for storing actually measured spatial trajectory data and attribute data of the water exploration and drainage drill holes; the actually measured spatial track data of the water detecting and draining drill holes comprise opening coordinates (X, Y, Z) of the water detecting and draining drill holes and spatial coordinates (X, Y, Z) of each point on the track, wherein X, Y, Z coordinates are absolute geodetic coordinate system coordinates consistent with a mining area mining engineering plan; the property data of the water-exploration and drainage borehole comprises: drilling serial number, drilling time, drilling place, constructor and recorder.

The drawing end comprises a water exploration and drainage drilling design module, a drilling actual measurement track management module, a blind area drilling inversion design module and a three-dimensional visualization module; the water detecting and draining drill hole design module is used for generating a four-figure one-table water detecting and draining drill hole design, and generating construction parameters of water detecting and draining drill holes according to the overall design parameters of the water detecting and draining drill holes (the construction parameters of the water detecting and draining drill holes refer to the parameters of a single water detecting and draining drill hole per se); the drilling hole actual measurement track management module is used for processing actual measurement space track data collected by the drilling hole track collection end; the three-dimensional visualization module is used for displaying the spatial position relationship among the designed water detecting and draining drilling track, the actually measured water detecting and draining drilling track, the roadway and the coal seam, and is convenient for understanding the exploration condition of the water detecting and draining drilling from a three-dimensional space angle; and the blind area drilling inversion design module is used for calculating the construction parameters of the blind area water detecting and discharging drill holes in a repairing mode by combining the inversion of the section diagram of the roadway head-on drill hole arrangement according to the spatial position relation displayed by the three-dimensional visualization module and the blind area of the roadway head-on advance position at the specified distance.

The water detecting and draining drilling hole design module is used for generating a four-figure one table of water detecting and draining drilling hole design according to overall design parameters of water detecting and draining drilling holes, and constructors can carry out head-on construction water detecting and draining drilling holes in the roadway according to the four-figure one table of water detecting and draining drilling hole design. Meanwhile, the water detecting and draining drill hole design module is used for generating construction parameters of the water detecting and draining drill hole according to the overall design parameters of the water detecting and draining drill hole (the construction parameters of the water detecting and draining drill hole refer to the parameters of a single water detecting and draining drill hole).

Specifically, the overall design parameters of the water detecting and draining drill hole are designed aiming at the heading of the roadway excavation. The overall distribution of all water detecting and draining drill holes on the tunneling head can be determined according to the overall design parameters of the water detecting and draining drill holes.

The overall design parameters of the water detecting and discharging drill hole comprise long hole design parameters and short hole design parameters; wherein, the slot hole design parameter includes: the method comprises the following steps of (1) roadway head-on bottom center point coordinates, roadway head-on top width, roadway head-on bottom width, roadway height, roadway azimuth angle, roadway inclination angle, advanced position section inclination angle, coal seam average thickness, design advance distance, left fan width, right fan width, roadway head-on drill hole layout parameters (bottom distance, longitudinal distance and transverse distance), and advanced section drill hole layout parameters (bottom distance, top distance, longitudinal distance and transverse distance); short hole design parameters include: designing the advance distance and advance section drilling layout parameters (distance from bottom to top, distance from top to top, longitudinal spacing and transverse spacing).

According to the overall design parameters of the water detection and drainage drill hole, the construction parameters of a single water detection and drainage drill hole can be generated, and the construction parameters of the single water detection and drainage drill hole specifically comprise a hole number, an inclination angle (an angle between the axial direction of the water detection and drainage drill hole and the horizontal plane), an included angle (an angle between the axial direction of the water detection and drainage drill hole and the roadway tunneling direction) and a hole depth.

Specifically, the water-exploration and drainage borehole design four-diagram one table (as shown in fig. 4 and 5) includes: the method comprises the following steps of designing a plan view of a water detecting and draining drill hole, designing a section view of the water detecting and draining drill hole, laying a section view of a head-on water detecting and draining drill hole of a roadway, laying a section view of a final hole of the water detecting and draining drill hole and listing the overall design parameters of the water detecting and draining drill hole.

The water exploration and drainage drill hole design plan, the water exploration and drainage drill hole design profile, the roadway head-on water exploration and drainage drill hole arrangement profile and the water exploration and drainage drill hole final hole arrangement profile are obtained by performing elevation projection or plane projection on spatial data, so that the spatial data can be visually displayed from different visual angles. More specifically, the water detecting and discharging drill hole design plan is formed by projecting spatial data to a horizontal plane by taking the horizontal plane as a projection plane; the design section diagram of the water detecting and draining drill hole is formed by projecting spatial data to an axial vertical surface of a roadway by taking the axial vertical surface of the roadway as a projection surface; the method comprises the following steps that a roadway head-on water detecting and draining drill hole layout section diagram is formed by projecting spatial data (including water detecting and draining drill hole construction parameters and actually measured spatial trajectory data) to a transverse vertical surface of a roadway head-on position by taking the transverse vertical surface of the roadway head-on position as a projection surface; and the water detecting and draining drilling hole final hole layout cross-section diagram is formed by projecting the spatial data (including water detecting and draining drilling construction parameters and actually measured spatial trajectory data) to the transverse vertical surface of the roadway at the position of the advanced final hole by taking the transverse vertical surface where the roadway at the position of the advanced final hole is positioned as a projection surface.

The principle of the elevation projection is consistent with that of the plane projection, and the key principle and model of the space projection are explained by taking the elevation projection as an example.

The elevation projection is to project points, lines and surfaces of a space onto a vertical plane along a horizontal direction by taking the vertical plane as a projection reference plane, wherein the projection direction is perpendicular to the vertical plane (similarly, the plane projection is to project the points, lines and surfaces of the space onto a horizontal plane along the vertical direction by taking the horizontal plane as the projection reference plane, and the projection direction is perpendicular to the horizontal plane). The line can be regarded as being composed of numerous points closely, and the line can be subjected to elevation projection by establishing an elevation projection model as shown in fig. 2.

In fig. 2, P represents a horizontal projection reference plane, and P' represents a vertical plane (vertical projection reference plane), which are perpendicular to each other. And OY is an intersection line of the vertical projection reference plane and the horizontal projection reference plane, and is called a projection axis for short. The line ABCDE is five continuous points in a certain section of track in the measured space track of the borehole, and the elevation projection of the line ABCDE on the elevation map is represented as a line A ' B ' C ' D ' E ', namely: the line A ' B ' C ' D ' E ' is a projection trajectory line of a certain section of track ABCDE in the measured space track of the drilling hole on the vertical surface. AA ', BB', CC ', DD', EE 'are projection connecting lines which are perpendicular to the vertical plane P'.

Taking point D as an example: and (3) making a vertical line DD 'of the vertical surface P' through the point D, wherein the foot D 'is a projection point of the point D on the vertical surface P'. Similarly, A, B, C, E four points can be projected on the vertical surface P ' to obtain points A ', B ', C ', E ', connecting points A ', B ', C ', D ', E ' to obtain a line A ' B ' C ' D ' E ', which is the trajectory vertical surface projection line of a certain section of trajectory line ABCDE in the drilling measured space trajectory.

In the prior art, the drawing mode of a four-figure one-table for water exploration and drainage drilling design is hand drawing, and the specific process is as follows: drawing the water detecting and draining drilling hole parameters point by point on drawing software manually by depending on the overall design parameters of the water detecting and draining drilling hole; and the relative position calculation of the measuring points in the water detecting and discharging drill hole depends on manual calculation point by point. It can be seen that the prior art approach of drawing a four-figure-one table of water-exploration drilling designs is time consuming and prone to error.

According to the water detecting and draining drilling hole design method and device, the water detecting and draining drilling hole design four-diagram one table is automatically generated according to the whole design parameters of the water detecting and draining drilling hole by the water detecting and draining drilling hole design module, the work load of workers for compiling the water detecting and draining drilling hole design four-diagram one table and the calculation work load of the drilling hole construction parameters are saved, and the work load of the workers can be reduced; by designing a four-diagram one-diagram for the water exploration and drainage drill hole, accurate and visual diagram data can be quickly obtained so that an operator can more visually dig the water exploration and drainage drill hole in the roadway and perform head-on construction; by automatically generating the four-diagram one table for water exploration and drainage drilling design, the links of human errors can be reduced, and the probability of errors of water exploration and drainage drilling is reduced.

Furthermore, the drilling track acquisition end is used for acquiring the actually measured space track data of the water exploration and drainage drilling hole in the tunneling head-on construction.

The constructor is according to exploring the drilling design four pictures one table and exploring the drilling of putting the drilling of putting the head into construction in the tunnel driving, however, in the in-process of constructor construction, because of some surveys the drilling of putting the drilling and takes place uncontrollable skew in the drilling in-process, there is the error between the drilling of exploring the drilling of putting the drilling and the design of exploring of putting the drilling, and the exploration of even the construction is put the drilling and is wrong. The reason for this is that during construction by a constructor, since the drilling environment faced by the drill bit is different, for example, when the drill bit passes through different strata, the density of the strata changes, and when the density of the strata changes, the drill bit is generally uncontrollably deviated, so that the water detecting and discharging drill hole for construction is not in accordance with the design expectation.

Under the condition that errors or errors exist in the water detecting and discharging drill holes during construction, part of advanced positions are not detected by the drill holes in the range of the designed drill holes, the geological condition of the region is unknown, and blind areas are generated. The blind area has the potential safety hazard, for example, if the blind area has old kiln ponding, when not looking over the blind area, leads to unexpected water damage accident easily.

This application is for can judging whether there is the blind area in the leading position, then need gather the actual measurement orbit data of the spy water drainage drilling of construction, further analysis is carried out to the actual measurement orbit data of spy water drainage drilling. The embodiment of the application adopts the drilling track acquisition end to measure the water detecting and draining drill hole of the roadway tunneling head-on construction, and the actually measured space track data is obtained. The drilling track acquisition end can adopt a drilling track measuring instrument.

The actually measured space trajectory data consists of relative position information of a plurality of measuring points of each water exploring drill hole; wherein the relative position information of each measuring point comprises azimuth angle, inclination angle and distance information of the measuring point relative to the previous measuring point. That is, the measured spatial trajectory data obtained by the borehole trajectory acquisition end is relatively speaking. For example, the opening coordinates of the water-exploring and water-draining drill hole (the opening coordinates are absolute geodetic coordinate data which are consistent with the coordinate system of the mining engineering plan in the mining area) are firstly obtained, and then the relative position information of the next measuring point of the water-exploring and water-draining drill hole is measured by taking the opening coordinates as reference until the actually measured space track data of the water-exploring and water-draining drill hole is obtained.

This application is gathered in real time through the actual measurement space orbit data of the spy water drainage drilling of drilling orbit collection end pair construction, can obtain the first hand data of real-time drilling, supplies the constructor of drilling designer and on-the-spot drilling to in time adjust the current error of the design of spying water drainage drilling and construction, in order to reduce the probability of later stage reworking, also can reduce the risk of the incident of appearing.

Further, the drilling hole actual measurement track management module is used for previewing and correcting the actual measurement space track data collected by the drilling hole track collection end, and storing the actual measurement space track data to the space database. Specifically, the drilling hole actual measurement track management module is used for previewing, correcting, warehousing and extracting actual measurement space track data. Wherein, the preview is realized by a preview sub-module; the correction is realized by a correction submodule; the warehousing is realized by a warehousing submodule; the extraction is realized by an extraction submodule; wherein the actually measured spatial trajectory data comprises two states: before the measured space track data is recorded into the spatial database, the relative position information of the water detecting and discharging drill holes is recorded, and after the measured space track data is recorded into the spatial database, the absolute geodetic coordinate system data consistent with the coordinate system of the mining area mining engineering plan is recorded.

The drilling actual measurement track management module comprises a preview submodule, and the preview submodule is used for acquiring the actual measurement space track data from the drilling track acquisition end and judging whether abnormal data exist in the actual measurement space track data or not; whether the actually measured space track data is abnormal or not refers to whether the acquired data is ordered or not, and whether the horizontal deviation or the vertical deviation of the measuring point is overlarge or not.

In actual measurement, if the data has too large error, the data has no reference meaning, and the data without the reference meaning is invalid data (also called abnormal data). In order to accurately acquire the actually measured spatial trajectory data, the effectiveness of the actually measured spatial trajectory data acquired by the drilling trajectory acquisition end is judged through the preview submodule, invalid actually measured spatial trajectory data are abandoned, or abnormal data are corrected (the drilling actual measurement trajectory management module comprises a correction submodule which is used for correcting the abnormal data in the actually measured spatial trajectory data), so that the data are called as effective data, and the effective actually measured spatial trajectory data are sent to the storage submodule of the drilling actual measurement trajectory management module to be processed in the next step. The previewing submodule is used for realizing coordinate previewing, horizontal deviation diagram previewing and vertical deviation diagram previewing of the actual measurement space track, and the horizontal deviation diagram previewing and the vertical deviation diagram previewing have zooming functions, can zoom in the horizontal direction and the vertical direction, and can calculate horizontal deviation and vertical deviation of the final hole position of the water detecting and discharging drill hole relative to the hole opening position.

On one hand, the influence of invalid measured space track data on the judgment of the blind area can be avoided; on the other hand, the invalid measured space track data can be prevented from occupying the storage space, and the valid measured space track data can be better stored.

The drilling hole actual measurement track management module comprises a correction submodule, and the correction submodule is used for correcting the actual measurement space track data. After the preview submodule judges the effectiveness of the data of the actual measurement space track, if the actual measurement space track data is found to have abnormal data, the point coordinates corresponding to the corresponding abnormal data in the actual measurement space track data can be corrected, so that the actual measurement space track data becomes effective actual measurement space track data. In the actual operation process, the actual measurement space trajectory data may have the situation that the horizontal deviation or the vertical deviation of individual measurement point data and the front and rear adjacent measurement points is too large, and at this time, the measurement point data needs to be corrected, so that the horizontal deviation or the vertical deviation curve is relatively smooth, and the effective actual measurement space trajectory data is obtained.

The drilling actual measurement track management module comprises a warehousing submodule, and the warehousing submodule is used for converting the relative position information of each measuring point into absolute geodetic coordinate system data consistent with a mining engineering plan of a mining area and storing the absolute geodetic coordinate system data into the spatial database.

The actual measurement space track data collected by the drilling track collection end is the relative position information of the water detection and drainage drill holes, and the reference coordinates of the relative position information of each water detection and drainage drill hole are different, so that the actual measurement space track data of the water detection and drainage drill holes cannot be comprehensively utilized. Therefore, the relative position information of each measuring point is converted into absolute geodetic coordinate system data consistent with a mining area excavation engineering plane graph through the warehousing submodule, namely, the actual measurement space track data of the water exploration and drainage drill holes with different reference coordinate systems are converted into the actual measurement space track data of the water exploration and drainage drill holes with a uniform reference coordinate system, and the utilization rate of the actual measurement space track data is improved.

The drilling track acquisition end also records attribute data matched with the actually measured space track data, wherein the attribute data comprises drilling serial numbers, drilling time, final hole time, drilling places, constructors, recording personnel, verification personnel and other information related to water exploration and drainage drilling.

The three-dimensional visualization module is used for displaying a spatial position relation among the roadway, the coal bed, the actually measured spatial trajectory data and the designed water exploration and drainage drilling trajectory data through the three-dimensional viewport, so that the blind area drilling inversion design module can automatically analyze whether a blind area exists at an advanced position of a specified distance of a heading head of the roadway or not, and can carry out macro control when automatically analyzing whether a blind area exists at the advanced position of the specified distance of the heading head of the roadway or not; and the design water exploration and drainage drill hole track data are generated according to the overall design parameters of the water exploration and drainage drill hole.

The three-dimensional visualization module is used for displaying the designed and actually measured water exploration and drainage drilling track, the coal seam roof and floor and the spatial position relation of the roadway in a three-dimensional scene, so that macroscopic analysis and water exploration and drainage guide work are facilitated; the exploration condition of the water drainage drill hole can be better understood by constructors and designers of the tunnel drilling from a three-dimensional space angle, so that the probability of avoiding safety accidents is reduced, and even the safety accidents are avoided.

The blind area drilling inversion design module is used for updating the water detection and drainage drilling design four-picture one table by the drilling actual measurement track management module according to the actual measurement space track data stored in the space database, randomly sectioning the advance position of the head of the roadway by using the updated water detection and drainage drilling design plan in the water detection and drainage drilling design four-picture one table so as to automatically analyze whether a blind area exists at the advance position of the specified distance of the head of the roadway, and calculating blind area drilling construction parameters under the condition of the blind area so as to provide an applicator for detecting and drainage drilling in the blind area of the head construction of the roadway according to the blind area drilling construction parameters. Specifically, the drilling hole actual measurement track management module comprises an extraction submodule, and the extraction submodule is used for extracting the actual measurement space track data from the space database so as to update a water exploration and drainage drilling hole design four-figure-one table according to the actual measurement space track data.

Specifically, the water detecting and draining drill hole design module generates a four-figure one table of water detecting and draining drill hole design according to the overall design parameters of the water detecting and draining drill hole. Namely, a water detecting and discharging drill hole design four-figure-one table generated by the water detecting and discharging drill hole design module is obtained according to the whole parameters of the water detecting and discharging drill hole in advance.

After a constructor completes the water exploration and drainage drilling construction according to the four-diagram one table of the water exploration and drainage drilling design, actual measurement space track data are obtained, the drilling actual measurement track management module depends on the extraction submodule, and the four-diagram one table of the water exploration and drainage drilling design is updated according to the actual measurement space track data. The utility model provides a "update and visit four pictures of drainage drilling design one table" means, with actual measurement space trajectory data portray in the four pictures of drainage drilling design one table of visiting that obtains according to the whole parameter of the water drainage drilling of visiting in advance, design promptly and visit drainage drilling trajectory data and actual measurement space trajectory data and all put into and visit the four pictures of drainage drilling design one table promptly to conveniently look over, also can more help the analysis to judge whether there is the blind area in the leading position of tunnel meeting head. In actual operation, the designed water detecting and discharging drilling track data and the measured space track data can be distinguished through different colors.

The actual measurement space track data in the water drainage drilling hole design plan is represented as plane projection data drawing, the actual measurement space track data in the water drainage drilling hole design section plan is represented as section projection data drawing along the roadway tunneling direction, and the actual measurement space track data in the roadway head-on water drainage drilling hole layout section plan is represented as vertical plane projection data drawing transversely through the roadway head-on position.

Under the condition that a blind area exists in the advance position of the specified head-on distance of the roadway, in order to eliminate the blind area, the blind area needs to be constructed and swept, namely specific blind area drilling construction parameters need to be determined according to the blind area, so that water detection and drainage drilling can be carried out on the blind area in the heading head-on construction of the roadway by operators according to the blind area drilling construction parameters.

The blind area drilling construction parameters are obtained according to the following modes:

and acquiring a starting point position from the updated roadway head-on water detecting and draining drill hole layout sectional diagram, sectioning the advanced position of a specified distance in the updated water detecting and draining drill hole design plane diagram to acquire an end point position, and acquiring the blind area drill hole construction parameters according to the starting point position, the end point position and the space vector of the roadway tunneling direction.

The plan view of the water drainage borehole design is obtained by displaying three-dimensional data on a two-dimensional display device, and the data constituting the two-dimensional plan view is three-dimensional attribute data, and is a three-dimensional view of the water drainage borehole design when displayed using a three-dimensional view port, although the two-dimensional plan view is presented.

Therefore, by sectioning the design plan of the water detecting and discharging drill hole, a section diagram of the three-dimensional data for designing the water detecting and discharging drill hole at any position of the advance distance of the heading head of the tunnel can be obtained, and the center position of the blind zone is found out in the section diagram by using the blind zone checking function in the blind zone drill hole inversion design module, wherein the center position of the blind zone is the final hole position of the blind zone water detecting and discharging drill hole.

And (4) constructing blind area water detecting and draining drill holes in the roadway driving head according to the blind area drilling construction parameters by constructors, and measuring the constructed blind area water detecting and draining drill holes by adopting the drilling track acquisition end to obtain the actual measurement space track data of the blind area drill holes.

The water detecting and draining drill hole design four-figure one table is updated according to the actually measured space track data, and by comparing the design water detecting and draining drill hole track data in the water detecting and draining drill hole design four-figure one table with the actually measured space track data, whether the current design has problems or not can be inversely observed, and whether the current construction has larger errors or not can be inversely observed; by arbitrarily sectioning the design plan of the water detecting and draining drill hole in the four-drawing one-sheet water detecting and draining drill hole design table, whether a blind area exists at a specified advanced position or not can be determined, the workload of manual calculation and analysis is reduced, the analysis efficiency is also improved, and the possibility of human errors is avoided.

Further, the blind area drilling inversion design module is further configured to update the measured space trajectory data in the space database by using the blind area drilling measured space trajectory data of the blind area water detection and drainage drilling in the drilling measured trajectory management module, and detect whether a blind area exists at an advanced position of a specified distance of a roadway driving head according to the updated measured space trajectory data after updating the four-figure one table of the water detection and drainage drilling design according to the updated measured space trajectory data until the blind area is eliminated.

Specifically, whether blind area drilling actual measurement space track data are abnormal or not is judged through a preview submodule of a drilling actual measurement track management module, and the abnormal blind area drilling actual measurement space track data are sent to a correction submodule of the drilling actual measurement track management module so as to correct the abnormal blind area drilling actual measurement space track data; and sending the corrected blind area drilling actual measurement space track data to a warehousing submodule of a drilling actual measurement track management module, converting the relative position information of the blind area drilling actual measurement space track data into absolute geodetic coordinate system data consistent with a mining area mining engineering plane diagram, and storing the absolute geodetic coordinate system data into a space database to update an actual measurement space track data set.

And updating the four-diagram one table of the water exploration and drainage drill hole design aiming at the updated actually measured space track data, namely updating the four-diagram one table of the water exploration and drainage drill hole design according to the updated actually measured space track data. And (4) according to the updated four-diagram one-table of the water detecting and draining drill hole design, whether a blind area exists at the advanced position of the specified head-on heading distance of the roadway driving can be further judged.

And if the blind area exists, generating a new blind area drilling construction parameter according to the updated four-drawing one-table of the water detecting and draining drilling design so that an applicator can detect whether the blind area exists again according to the blind area drilling construction parameter in the heading construction blind area of the roadway until the blind area is eliminated.

This application relies on blind area drilling inversion design module can be quick visit water drilling design four-chart one table to the update before and after the update to carry out the analysis, and then judges whether to have the blind area, under the condition that has the blind area, calculates blind area drilling construction parameter fast, reduces the work load of human analysis, improves the design efficiency of blind area visit water drilling parameter, can be safe, the quick concrete exploration condition of analysis leading position to reduce the risk that the incident takes place.

The application provides a mine tunnelling is visited and is drained auxiliary system's specific use as follows:

firstly, a spatial database is established, the address of the spatial database is configured in a drawing end, and communication between the drawing end and the spatial database is realized through a network.

And secondly, drawing a four-diagram one-diagram design table of the water detecting and releasing drill hole through a water detecting and releasing drill hole design module in the drawing end according to the whole design parameters of the water detecting and releasing drill hole.

And then, designing four water-detecting and water-discharging drill holes generated by a water-detecting and water-discharging drill hole designing module to sequentially construct water-detecting and water-discharging drill holes at advanced positions at the head of the mine excavation roadway. The track of the water detection and drainage drill hole is extracted by the drill hole track measuring instrument every time one water detection and drainage drill hole is constructed, after the water detection and drainage drill hole is constructed, the acquired actually-measured space track data of each water detection and drainage drill hole is checked whether abnormal data exist or not through a preview sub-module in a drill hole actually-measured track management module, if the abnormal data exist, the abnormal data are corrected through a correction sub-module, and after the abnormal data exist, effective actually-measured space track data are stored into a space database through a storage sub-module.

In order to detect and analyze whether the advanced position has a blind area, extracting all the actual measurement space track data of the advanced position of the roadway to be checked into a water detection and drainage drill hole design four-diagram one-diagram through an extraction submodule in a drill hole actual measurement track management module to update the water detection and drainage drill hole design four-diagram one-diagram, sectioning the water detection and drainage drill hole design plan in the updated water detection and drainage drill hole design four-diagram one-diagram through an arbitrary sectioning function in the blind area drill hole inversion design module at the appointed advanced position to obtain a water detection and drainage drill hole actual measurement position section diagram (the section diagram is obtained by sectioning the water detection and drainage drill hole design plan diagram), wherein the section diagram comprises sections, grid marks, actual measurement drill hole symbols, design drill hole symbols, drill hole numbers and the like. The design drilling track is obtained by calculation according to the overall design parameters of the water exploration and drainage drilling; the actual measurement drilling track is obtained according to the actual measurement space track data; during specific display, the actually measured drilling track is distinguished from the designed drilling track by different colors; and calculating the construction parameters of drilling of each blind zone, namely the starting position and the end position of the drilling of the blind zone by using the blind zone inversion design function in the blind zone drilling inversion design module. The starting point position is a position selected from a roadway head-on water-detecting and water-discharging drill hole arrangement section diagram generated in the water-detecting and water-discharging drill hole design module, and the starting point position is a three-dimensional space coordinate (X, Y, Z) obtained through space stereo projection calculation. The end point position is a blind area central position found out through a blind area checking function in a section diagram of an actual measurement position of the water exploration and drainage drill hole, and is also a three-dimensional space coordinate (X, Y, Z) obtained through space stereo projection calculation, and construction parameters of the blind area drill hole are obtained through a starting point position, an end point position and a space vector of a roadway tunneling direction of the blind area drill hole, wherein the construction parameters of the blind area drill hole comprise: hole number, inclination angle (angle between axial direction of drilling hole and horizontal plane), included angle (angle between axial direction of drilling hole and tunneling direction), and hole depth.

If the blind area is detected through the blind area drilling inversion design module and the blind area drilling construction parameters are obtained, water exploration and drainage drilling is continuously carried out on the roadway driving head-on construction according to the blind area drilling construction parameters, the blind area drilling actual measurement space track data is extracted by using a drilling track measuring instrument every time one drilling hole is constructed, whether abnormal data exist in the blind area drilling actual measurement space track data is checked through a preview sub-module in a drilling actual measurement track management module, if the abnormal data exist, the abnormal data are corrected through a correction sub-module, and after correction, effective blind area actual measurement space track data are stored into a space database through a storage sub-module;

and (3) detecting the blind area by the repeated blind area drilling inversion design module, designing the blind area drilling construction parameters, constructing the blind area drilling, acquiring the actual measurement space track data of the blind area drilling, and detecting the blind area again until the blind area-free condition is reached and the safe roadway tunneling condition is reached.

The application also provides a mine excavation water exploration and drainage auxiliary method as shown in fig. 3, which is used for the mine excavation water exploration and drainage auxiliary system; the system comprises: the system comprises a drilling track acquisition end, a spatial database and a drawing end; the spatial database is in communication connection with the drawing end; the drawing end comprises a water exploration and drainage drilling design module, a drilling actual measurement track management module, a blind area drilling inversion design module and a three-dimensional visualization module;

the method comprises the following steps:

step S1, the water detecting and draining drill hole designing module generates a water detecting and draining drill hole designing four-diagram one table according to the whole design parameters of the water detecting and draining drill hole, a constructor drives a heading construction water detecting and draining drill hole in a roadway according to the water detecting and draining drill hole designing four-diagram one table, and a three-dimensional visualization module is used for checking whether the water detecting and draining drill hole meets design expectations or not;

The embodiment of the application integrates the data processing and visual analysis of underground exploration water drilling of a coal mine based on the theories and technologies of various special researches in the fields of GIS (geographic information system), computational geometry, mine informatization, ground exploration water control and the like on the basis of the design specifications of the underground exploration drilling of the mine, realizes the standardized storage and real-time sharing of the underground exploration drilling information of the coal mine, solves the problems of automatic mapping of standardized parameters of the exploration drilling, spatial topological relation processing, arbitrary sectioning, two-three-dimensional visualization, blind zone drilling inversion calculation and the like, fully decomposes and processes the business flow, accurately and truly expresses the data required by a user in a mode of automatic mapping and manual interactive operation, improves the quality and the working efficiency, reduces the workload of workers, replaces the traditional advanced exploration working mode, realizes the efficient production of a mining area and promotes the safety management of the mining area, has important significance for preventing and controlling the water accumulation of the old kiln and ensuring the safe production of the coal mine.

Furthermore, those skilled in the art will appreciate that embodiments of the present invention may be provided as a method, apparatus, or computer program product. Accordingly, embodiments of the present invention may take the form of an embodiment combining software and hardware aspects. Furthermore, embodiments of the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.

Embodiments of the present invention are described with reference to block diagrams of terminal devices (systems) and computer program products according to the invention. It will be understood that each block of the block diagrams can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing terminal to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing terminal, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing terminal to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be loaded onto a computer or other programmable data processing terminal to cause a series of operational steps to be performed on the computer or other programmable terminal to produce a computer implemented process such that the instructions which execute on the computer or other programmable terminal provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

It should also be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or terminal that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or terminal. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or terminal that comprises the element.

The above is only a preferred embodiment of the present invention, and is not intended to limit the present invention, and various modifications and changes will occur to those skilled in the art. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

For the system embodiment, since it is basically similar to the method embodiment, the description is simple, and for the relevant points, refer to the partial description of the method embodiment.

The embodiments in the present specification are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other.

The mine excavation water detection and drainage auxiliary system and the mine excavation water detection and drainage auxiliary method are introduced in detail, specific examples are applied in the system to explain the principle and the implementation mode of the system, and the method and the core idea of the system are described above; meanwhile, for a person skilled in the art, according to the idea of the present application, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present application.

Claims

1. A mine excavation water exploration and drainage assistance system, the system comprising: the system comprises a drilling track acquisition end, a spatial database and a drawing end; the spatial database is in communication connection with the drawing end;

the blind area drilling inversion design module is used for updating the water detection and drainage drilling design four-picture one table by the drilling actual measurement track management module according to the actual measurement space track data stored in the space database, randomly sectioning the advance position of the head of the roadway by using the updated water detection and drainage drilling design plan in the water detection and drainage drilling design four-picture one table so as to automatically analyze whether a blind area exists at the advance position of the specified distance of the head of the roadway, and calculating blind area drilling construction parameters under the condition of the blind area so as to provide an applicator for detecting and drainage drilling in the blind area of the head construction of the roadway according to the blind area drilling construction parameters.

2. The system of claim 1, wherein the blind zone borehole inversion design module is further configured to update the measured spatial trajectory data in the spatial database by using the blind zone borehole measured spatial trajectory data of the blind zone water-detecting and water-discharging borehole at the borehole measured trajectory management module, update the water-detecting and water-discharging borehole design four-picture one table according to the updated measured spatial trajectory data, and arbitrarily cut the leading position of the heading head of the roadway by using the water-detecting and water-discharging borehole design plan in the updated water-detecting and water-discharging borehole design four-picture one table, so as to automatically analyze whether a blind zone exists at the leading position of the specified distance of the heading head of the roadway until the blind zone is eliminated.

3. The system of claim 1, wherein the borehole actual measurement trajectory management module comprises a preview sub-module, the preview sub-module is configured to obtain the actual measurement spatial trajectory data from the borehole trajectory acquisition end and determine whether abnormal data exists in the actual measurement spatial trajectory data.

4. A mine excavation water detection and drainage assistance system as claimed in claim 1, wherein the borehole measured trajectory management module includes a correction submodule for correcting for abnormal data in the measured spatial trajectory data.

5. The mine excavation water detection and discharge assisting system according to claim 1, wherein the actually measured spatial trajectory data is composed of relative position information of a plurality of measurement points of each water detection and discharge borehole; wherein the relative position information of each measuring point comprises azimuth angle, inclination angle and distance information of the measuring point relative to the previous measuring point.

6. The mine excavation water exploring and discharging auxiliary system according to claim 5, wherein the drilling measured trajectory management module comprises a warehousing sub-module, and the warehousing sub-module is used for converting the relative position information of each measuring point into absolute geodetic coordinate system data consistent with a mining area excavation engineering plan and storing the absolute geodetic coordinate system data into the space database; wherein the actually measured spatial trajectory data comprises two states: before the measured space track data is recorded into the space database, the relative position information of water exploration and drainage drill holes is recorded, and after the measured space track data is recorded into the space database, the absolute geodetic coordinate system data consistent with a mining area mining engineering plan is recorded.

7. A mine excavation water sounding auxiliary system as claimed in claim 1, wherein the borehole measured trajectory management module includes an extraction sub-module for extracting the measured spatial trajectory data from the spatial database and further updating the water sounding borehole design four-map-one table based on the measured spatial trajectory data.

8. The system of claim 1, wherein the water-detecting and draining drilling design four-chart one table comprises: the method comprises the following steps of designing a plan view of water exploration and drainage drill holes, designing a section view of the water exploration and drainage drill holes, laying a section view of head-on water exploration and drainage drill holes of a roadway, laying a section view of final holes of the water exploration and drainage drill holes and listing the overall design parameters of the water exploration and drainage drill holes.

9. The mine excavation water detecting and discharging auxiliary system according to claim 1, wherein the blind zone drilling construction parameters are obtained as follows:

10. A mine excavation water detection and drainage auxiliary method is characterized by being applied to a mine excavation water detection and drainage auxiliary system; the system comprises: the system comprises a drilling track acquisition end, a spatial database and a drawing end; the spatial database is in communication connection with the drawing end; the drawing end comprises a water exploration and drainage drilling design module, a drilling actual measurement track management module, a blind area drilling inversion design module and a three-dimensional visualization module;

the method comprises the following steps: