CN114320267A - Database-managed drilling depth calculation method - Google Patents
Database-managed drilling depth calculation method Download PDFInfo
- Publication number
- CN114320267A CN114320267A CN202111401263.XA CN202111401263A CN114320267A CN 114320267 A CN114320267 A CN 114320267A CN 202111401263 A CN202111401263 A CN 202111401263A CN 114320267 A CN114320267 A CN 114320267A
- Authority
- CN
- China
- Prior art keywords
- drilling
- data
- track
- database
- depth
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000005553 drilling Methods 0.000 title claims abstract description 306
- 238000004364 calculation method Methods 0.000 title claims abstract description 29
- 238000000034 method Methods 0.000 claims abstract description 91
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 claims abstract description 51
- 239000003245 coal Substances 0.000 claims abstract description 34
- 238000012544 monitoring process Methods 0.000 claims abstract description 24
- 230000005540 biological transmission Effects 0.000 claims abstract description 22
- 230000008859 change Effects 0.000 claims abstract description 19
- 238000010276 construction Methods 0.000 claims abstract description 19
- 238000005259 measurement Methods 0.000 claims abstract description 17
- 238000004458 analytical method Methods 0.000 claims abstract description 12
- 238000007726 management method Methods 0.000 claims abstract description 10
- 238000012545 processing Methods 0.000 claims description 36
- 230000008569 process Effects 0.000 claims description 34
- 238000007405 data analysis Methods 0.000 claims description 28
- 238000009499 grossing Methods 0.000 claims description 25
- 238000005516 engineering process Methods 0.000 claims description 20
- 230000009466 transformation Effects 0.000 claims description 14
- 238000007476 Maximum Likelihood Methods 0.000 claims description 11
- 239000011435 rock Substances 0.000 claims description 10
- 238000004891 communication Methods 0.000 claims description 9
- 238000001914 filtration Methods 0.000 claims description 9
- 230000035939 shock Effects 0.000 claims description 5
- 239000000654 additive Substances 0.000 claims description 3
- 230000000996 additive effect Effects 0.000 claims description 3
- 238000012937 correction Methods 0.000 claims description 3
- 239000013307 optical fiber Substances 0.000 claims description 3
- 238000005070 sampling Methods 0.000 claims description 3
- 230000004304 visual acuity Effects 0.000 claims description 3
- 238000012935 Averaging Methods 0.000 claims description 2
- 238000013461 design Methods 0.000 abstract description 5
- 238000000605 extraction Methods 0.000 abstract description 3
- 238000003672 processing method Methods 0.000 abstract description 3
- 230000000694 effects Effects 0.000 description 7
- 239000000243 solution Substances 0.000 description 4
- 239000000835 fiber Substances 0.000 description 2
- 230000002706 hydrostatic effect Effects 0.000 description 2
- 238000002347 injection Methods 0.000 description 2
- 239000007924 injection Substances 0.000 description 2
- 238000005065 mining Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000011160 research Methods 0.000 description 2
- 230000001502 supplementing effect Effects 0.000 description 2
- 230000000007 visual effect Effects 0.000 description 2
- 230000015572 biosynthetic process Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000006073 displacement reaction Methods 0.000 description 1
- 230000004438 eyesight Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 230000002265 prevention Effects 0.000 description 1
- 239000000523 sample Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
- 230000003313 weakening effect Effects 0.000 description 1
Images
Landscapes
- Earth Drilling (AREA)
Abstract
The application provides a drilling depth calculation method for database management, and S1, the data of the roadway and the drilling points in the database are called for analysis; s2, realizing effective drilling treatment on the drilling points through drilling equipment; s3, acquiring data information of the drilling points during drilling; s4, monitoring the change condition of the water pressure in the drill rod by using a water pressure sensor; s5, realizing real-time transmission of drilling data from an underground drilling site to a ground monitor through an underground industrial ring network; and S6, remotely commanding the drilling operation under the mine according to the calculation result. The method uploads track data in real time through an industrial ring network, realizes drilling data acquisition by adopting a water pressure sensor and a track instrument for measurement, realizes three-dimensional display of drilling group tracks and coal bed distribution by adopting drilling track processing software based on a full data processing method, guides design and construction of subsequent drilling, and reduces or eliminates a gas extraction drilling coverage blind area.
Description
Technical Field
The application relates to the technical field of mines, in particular to a drilling depth calculation method for database management.
Background
The geological conditions of the mining area are complex, and coal and gas are seriously extruded. Coal and gas outburst are major hidden dangers affecting the safety of each coal mine. In order to eliminate and reduce the risk of coal and gas outburst, a tunnel drilling machine is generally adopted for constructing a gas drainage drill hole for gas pre-drainage in each coal mine, and the gas pressure in the coal bed is reduced through pre-drainage gas, so that the coal and gas outburst accidents are effectively prevented.
At present, the underground drilling construction modes of the coal mine comprise directional drilling and rotary drilling. The directional drilling technology has good application effect under the coal mine because the drilling track is adjustable and controllable, but the cost is high, the construction process is complex, and most of the drilling holes of all the coal mines belonging to the Huaibei mining group still adopt a rotary drilling construction mode.
In rotary drilling construction, a track-while-drilling apparatus is usually used for measuring a drilling track. The track-while-drilling instrument performs fixed-point measurement in the drilling stopping process, the acquired attitude data is stored in a measurement probe, the stored data is exported after drilling is completed and drilling track is obtained after processing. The track-while-drilling instrument has high measurement efficiency and simple operation, and is widely applied to underground coal mines.
But the shortages of data processing of the tracing instrument while drilling are obvious:
(1) the vertical deviation and the left-right deviation formed by the track-while-drilling instrument are two-dimensional graphs, and the form of a drilling track in a three-dimensional space cannot be intuitively reflected.
(2) The track-while-drilling instrument can only realize the trace mapping of a single drill hole, cannot simultaneously display the traces of a plurality of drill holes, and cannot determine the position relationship among the plurality of drill holes.
(3) The data of the existing inclinometer can only be manually carried into a well for data analysis, but the measured data cannot be uploaded to the ground in real time for data processing, analysis and management, and the subsequent drilling construction cannot be guided in time.
(4) The measurement of the hole depth depends on the manual counting of the drill rods of the video, the time and the labor are wasted, and the hole depth counterfeiting cannot be eliminated. At present, the problem of artificial cheating and misreport of the drilling depth can not be solved only by depending on a track measurement instrument while drilling.
The field drilling construction practice shows that the problems of inaccurate manual hole depth recording, drilling deflection and the like exist in the drilling construction process, so that the drilling track and the dropping point are displaced, the precision cannot reach the design requirement, an unknown and uncontrollable blind area is formed, the disaster control effects such as gas control and the like are influenced, and the great disaster cannot be accurately controlled.
Disclosure of Invention
In order to make up for the defects, the application provides a drilling depth calculation method for database management, and aims to solve the problems of inaccurate manual recording of hole depth, deviation of drilling and the like in the conventional drilling construction process, displacement of drilling tracks and drop points, difficulty in reaching of design precision, formation of unknown and uncontrollable blind areas, influence on disaster control effects such as gas control and the like, and difficulty in accurate prevention and control of major disasters.
The embodiment of the application provides a drilling depth calculation method for database management, which comprises the following steps:
s1, retrieving roadway data and drilling point data in the database for analysis: the data information of the roadway and the drilling points stored in the database is called, then analysis processing is carried out, the direction and the depth of the drilling points are judged, the direction and the depth of the drilling points can be clearly and definitely obtained through data analysis, and the drilling processing is convenient to carry out;
s2, the drilling equipment is used for effectively drilling the drilling points: after the direction and the depth of the drilling point are calculated and processed, drilling equipment is adopted to realize drilling processing on the drilling point in the roadway, namely, the drilling of the drilling point is completed;
s3, acquiring data information of the drilling points during drilling: during drilling, the YZG7 trajectory-while-drilling instrument or YQG1 trajectory instrument is adopted to realize drilling trajectory data measurement, namely, the trajectory during drilling is detected, and the route of the drilling trajectory is obtained;
s4, monitoring the change condition of the water pressure in the drill rod by adopting a water pressure sensor: in the drilling process, a water pressure sensor is additionally adopted to monitor the change condition of water pressure in a drill rod in the drilling construction process, the change of pressure pulse is generated by collecting the water pressure condition and further arranging a choke valve controlled by a measuring sensor when a flowing water column is controlled, the information is coded by pulse number or coded by pulse amplitude and pulse phase by binary numerical system and received by an earth surface pressure detector, and parameters of a drilling top angle, an azimuth angle and a tool face are respectively measured by adopting various sensors;
s5, realizing real-time transmission of drilling data from the underground drilling site to a ground monitor through an underground industrial ring network: when drilling is carried out, real-time transmission of drilling data from an underground drilling field to a ground monitor is realized through an underground industrial ring network, three-dimensional display of a coal rock interface, coal seam thickness and trend, drilling group tracks and the like of the drilling field is completed through drilling track data processing software of a full data analysis method, and a drilling track on-line monitoring technology based on the full data analysis method is used for determining a drilling blind area;
s6, remotely commanding the drilling operation under the mine according to the calculation result: after the acquired data information is calculated and processed through the drilling track on-line monitoring technology of the full data analysis method, three-dimensional display of a coal rock interface of a drilling site, the thickness and the trend of a coal bed, the track of a drilling group and the like is completed, and remote monitoring and commanding on the drilling process are realized according to the calculation and processing result.
In the implementation process, a new technology is applied to accurately judge the drilling track and the final hole drop point and quickly analyze and control the blind area, so that a scientific basis is imperatively provided for supplementing disaster control engineering in real time. Aiming at the actual requirements of measurement and analysis of the underground coal mine drilling group track, the drilling track on-line monitoring technology and system based on the full data analysis method are designed and developed. The technology adopts a water pressure sensor to monitor the change condition of water pressure in a drill rod in the drilling construction process, accurately judges the drilling depth by combining the inclination angle data of a track tracing while drilling instrument, eliminates the human error of the drilling depth, simultaneously realizes the real-time transmission of the drilling data from an underground drilling field to a ground monitor by means of the existing underground industrial ring network, and completes the three-dimensional display of a coal-rock interface of the drilling field, the thickness and the trend of a coal bed, the track of a drilling group and the like by utilizing the drilling track data processing software of an autonomously developed full data analysis method. The drilling track on-line monitoring technology based on the full data analysis method provides visual and scientific basis for determining drilling blind areas and guiding drilling construction, and has practical values of research and application; the drilling track data measurement is realized by adopting a YZG7 track tracing instrument while drilling or a YQG1 track tracing instrument, a drilling data transmission system is built by using the existing industrial ring network, the real-time uploading of track data after hole forming is realized, the change of water pressure in a drilling hole is continuously monitored by adopting a water pressure sensor, the hydrostatic pressure in the drilling hole is determined by adopting a full data analysis method, the drilling depth is determined by combining the inclination data measured by the track tracing instrument, the three-dimensional display of drilling group tracks and coal bed distribution is realized by adopting drilling track processing software based on a full data processing method, the actual tracks of all drilling holes in a drilling field are visually displayed, the measured data of the drilling holes are analyzed by statistics, the drilling deviation rule of the drilling field is summarized, the design and construction of subsequent drilling holes are guided according to the deviation rule and the drilling coverage blind area, and the gas extraction drilling coverage blind area is reduced or eliminated.
In a specific embodiment, the data information of the roadway and the drill points in S1, after being extracted from the database, is processed by a computer to determine calibration data comprising the difference between the magnetic azimuth and the grid azimuth, and to calculate the number of exit holes, the left and right deviation, the up and down deviation, the tool azimuth, the tool inclination, the gamma polygon plot, and the measurements of vibration and shock as a function of depth.
In the implementation process, calculation processing is carried out according to data information in the database, information of each parameter can be effectively judged, and drilling processing is facilitated.
In a specific embodiment, the drilling device in S1 is used for introducing water flow into the drill rod during drilling, and a plurality of overflow holes are arranged on the side wall of the drill rod, and water is injected into the drill hole through the overflow holes.
In the implementation process, the water injection operation can be realized by setting the drill rod, and the process of detecting and drilling according to the change of water pressure can be realized.
In a specific embodiment, the S2 drilling point determines a range of the drilling point by a difference between a left-right deviation amount, a tool azimuth, a tool inclination, a magnetic azimuth, and a grid azimuth while drilling, and maintains a smooth fixation of the drilling equipment while drilling, and then performs drilling within the left-right deviation amount, the tool azimuth, and the tool inclination, and maintains vibration and shock to operate within a predicted range for safety.
In the implementation process, according to the calculated parameters, the drilling position and the drilling path can be conveniently predicted and assumed, and the drilling efficiency is improved.
In a specific embodiment, the industrial ring network in S5 is in communication connection with the water pressure sensor, the YZG7 track-while-drilling instrument or the YQG1 track instrument, and performs communication connection through distributed nodes of the industrial ring network under the mine, so as to transmit data information, and in order to improve transmission accuracy, an optical fiber cable is selected for communication transmission.
In the implementation process, the detected data information is transmitted through the industrial ring network, and the optical fiber with small interference item is adopted for transmission, so that the transmission efficiency is improved.
In a specific embodiment, the online monitoring technology of the drilling trajectory of the full data analysis method in S6 preprocesses the data information before receiving the data information when the data information is under the mine, that is, the data processing module receives and filters the data information.
In the implementation process, in order to improve the accuracy of the data information, before receiving the data information, the data information is filtered, so that the accuracy of the data information is improved.
In a specific implementation scheme, the filtering process includes wavelet transform denoising, maximum likelihood estimation thresholding denoising, and pulse signal smoothing, the wavelet transform denoising breaks through the limitation that fourier transform does not have any resolving power in the time domain, signal components in a specified frequency band and time period are analyzed, a baseline drift exists in the acquired signal, and the denoised signal needs to be subjected to smoothing.
In the implementation process, in order to improve the accuracy and the accuracy of data information and improve the filtering effect, a plurality of groups of filtering algorithms are adopted for processing, and the linear smoothness degree can be improved.
In a specific embodiment, the characteristics of wavelet transform denoising in frequency domain and time domain make wavelet transform denoising have good application in signal denoising, and the threshold denoising method based on wavelet transform denoising comprises the following steps:
s601, selecting proper wavelets, and performing wavelet transformation on a given signal to obtain a wavelet transformation coefficient W;
s602, calculating a threshold value, selecting a proper threshold value method to accept or reject the wavelet coefficient, wherein the threshold value is a hard threshold value or a soft threshold value, and obtaining a new wavelet coefficient W delta;
s603, performing inverse transformation on the obtained coefficient to obtain denoised data;
the functional expression of the hard threshold is η (ω) ═ ω I (| ω | > T), and the functional expression of the soft threshold is η (ω) ═(ω -sgn (ω) T) I (| ω | > T).
In the implementation process, the threshold value can be effectively calculated and processed through wavelet transformation denoising, and the denoising effect is realized.
In a specific embodiment, the smaller the entropy value of denoising by the maximum likelihood estimation threshold method, the more sparse the distribution is, and the worse the uniformity is; sparse distribution has no quantitative definition, and generally refers to the distribution of a peak existing at the zero point of a probability density function; the signals collected at the well mouth are additive mixed signals of water pressure positive pulse signals and noise, the probability density function of the signals is typical sparse distribution, and the following threshold criteria are obtained for the signals conforming to the sparse distribution form according to the maximum likelihood principle:
wherein,
d and sigma are standard deviations of the signal and the noise respectively, and when the square term is less than 0, the open term is 0.
In the implementation process, the threshold value can be obtained through the calculation processing of the maximum likelihood estimation threshold value method denoising, and the filtering processing can be effectively implemented.
In a specific embodiment, the pulse signal smoothing is to smooth the data of the denoised signal, to reduce the influence of the interference signal and improve the smoothness of the curve, and the signal smoothing method is a linear sliding smoothing method, which is a method for performing linear smoothing on discrete data by using the principle of least square, and mainly performs amplitude correction on a certain point according to the amplitude of a sampling point adjacent to the point, so as to achieve the purpose of smoothing and denoising the waveform, and generally, data points of 5 adjacent points are taken for calculation, and the calculation formula is shown as the following formula:
wherein i is 3, 4, … m-2.
In the implementation process, the influence of interference signals can be weakened through pulse signal smoothing, the smoothness of a curve is improved, and data smoothing processing is carried out on the denoised signals.
Drawings
In order to more clearly explain the technical solutions of the embodiments of the present application, the drawings that are required to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present application and therefore should not be considered as limiting the scope, and that for those skilled in the art, other related drawings can be obtained from these drawings without inventive effort.
FIG. 1 is a schematic flow chart of the method steps provided by an embodiment of the present application;
fig. 2 is a schematic flow chart illustrating steps of a threshold denoising method based on wavelet transform denoising according to an embodiment of the present disclosure.
Detailed Description
The technical solutions in the embodiments of the present application will be described below with reference to the drawings in the embodiments of the present application.
To make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions of the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are some embodiments of the present application, but not all embodiments. All other embodiments obtained by a person of ordinary skill in the art without any inventive work based on the embodiments in the present application are within the scope of protection of the present application.
Thus, the following detailed description of the embodiments of the present application, as presented in the figures, is not intended to limit the scope of the claimed application, but is merely representative of selected embodiments of the application. All other embodiments obtained by a person of ordinary skill in the art without any inventive work based on the embodiments in the present application are within the scope of protection of the present application.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, it need not be further defined and explained in subsequent figures.
In the description of the present application, it is to be understood that the terms "center," "longitudinal," "lateral," "length," "width," "thickness," "upper," "lower," "front," "rear," "left," "right," "vertical," "horizontal," "top," "bottom," "inner," "outer," "clockwise," "counterclockwise," and the like are used in the orientations and positional relationships indicated in the drawings for convenience in describing the present application and for simplicity in description, and are not intended to indicate or imply that the referenced device or element must have a particular orientation, be constructed in a particular orientation, and be operated in a particular manner, and thus should not be considered limiting.
Furthermore, the terms "first", "second" and "first" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of that feature. In the description of the present application, "a plurality" means two or more unless specifically limited otherwise.
In this application, unless expressly stated or limited otherwise, the terms "mounted," "connected," "secured," and the like are to be construed broadly and can include, for example, fixed connections, removable connections, or integral parts; either directly or indirectly through intervening media, either internally or in any other relationship. The specific meaning of the above terms in the present application can be understood by those of ordinary skill in the art as appropriate.
In this application, unless expressly stated or limited otherwise, the first feature "on" or "under" the second feature may comprise direct contact of the first and second features, or may comprise contact of the first and second features not directly but through another feature in between. Also, the first feature being "on," "above" and "over" the second feature includes the first feature being directly on and obliquely above the second feature, or merely indicating that the first feature is at a higher level than the second feature. A first feature being "under," "below," and "beneath" a second feature includes the first feature being directly under and obliquely below the second feature, or simply meaning that the first feature is at a lesser elevation than the second feature.
Referring to fig. 1-2, the present application provides a method for database-managed borehole depth calculation, comprising the following steps:
s1, retrieving roadway data and drilling point data in the database for analysis: the data information of the roadway and the drilling points stored in the database is called, then analysis processing is carried out, the direction and the depth of the drilling points are judged, the direction and the depth of the drilling points can be clearly and definitely obtained through data analysis, and the drilling processing is convenient to carry out;
s2, the drilling equipment is used for effectively drilling the drilling points: after the direction and the depth of the drilling point are calculated and processed, drilling equipment is adopted to realize drilling processing on the drilling point in the roadway, namely, the drilling of the drilling point is completed;
s3, acquiring data information of the drilling points during drilling: during drilling, the YZG7 trajectory-while-drilling instrument or YQG1 trajectory instrument is adopted to realize drilling trajectory data measurement, namely, the trajectory during drilling is detected, and the route of the drilling trajectory is obtained;
s4, monitoring the change condition of the water pressure in the drill rod by adopting a water pressure sensor: in the drilling process, a water pressure sensor is additionally adopted to monitor the change condition of water pressure in a drill rod in the drilling construction process, the change of pressure pulse is generated by collecting the water pressure condition and further arranging a choke valve controlled by a measuring sensor when a flowing water column is controlled, the information is coded by pulse number or coded by pulse amplitude and pulse phase by binary numerical system and received by an earth surface pressure detector, and parameters of a drilling top angle, an azimuth angle and a tool face are respectively measured by adopting various sensors;
s5, realizing real-time transmission of drilling data from the underground drilling site to a ground monitor through an underground industrial ring network: when drilling is carried out, real-time transmission of drilling data from an underground drilling field to a ground monitor is realized through an underground industrial ring network, three-dimensional display of a coal rock interface, coal seam thickness and trend, drilling group tracks and the like of the drilling field is completed through drilling track data processing software of a full data analysis method, and a drilling track on-line monitoring technology based on the full data analysis method is used for determining a drilling blind area;
s6, remotely commanding the drilling operation under the mine according to the calculation result: after the acquired data information is calculated and processed through the drilling track on-line monitoring technology of the full data analysis method, three-dimensional display of a coal rock interface of a drilling site, the thickness and the trend of a coal bed, the track of a drilling group and the like is completed, and remote monitoring and commanding on the drilling process are realized according to the calculation and processing result.
In the implementation process, a new technology is applied to accurately judge the drilling track and the final hole drop point and quickly analyze and control the blind area, so that a scientific basis is imperatively provided for supplementing disaster control engineering in real time. Aiming at the actual requirements of measurement and analysis of the underground coal mine drilling group track, the drilling track on-line monitoring technology and system based on the full data analysis method are designed and developed. The technology adopts a water pressure sensor to monitor the change condition of water pressure in a drill rod in the drilling construction process, accurately judges the drilling depth by combining the inclination angle data of a track tracing while drilling instrument, eliminates the human error of the drilling depth, simultaneously realizes the real-time transmission of the drilling data from an underground drilling field to a ground monitor by means of the existing underground industrial ring network, and completes the three-dimensional display of a coal-rock interface of the drilling field, the thickness and the trend of a coal bed, the track of a drilling group and the like by utilizing the drilling track data processing software of an autonomously developed full data analysis method. The drilling track on-line monitoring technology based on the full data analysis method provides visual and scientific basis for determining drilling blind areas and guiding drilling construction, and has practical values of research and application; the drilling track data measurement is realized by adopting a YZG7 track tracing instrument while drilling or a YQG1 track tracing instrument, a drilling data transmission system is built by using the existing industrial ring network, the real-time uploading of track data after hole forming is realized, the change of water pressure in a drilling hole is continuously monitored by adopting a water pressure sensor, the hydrostatic pressure in the drilling hole is determined by adopting a full data analysis method, the drilling depth is determined by combining the inclination data measured by the track tracing instrument, the three-dimensional display of drilling group tracks and coal bed distribution is realized by adopting drilling track processing software based on a full data processing method, the actual tracks of all drilling holes in a drilling field are visually displayed, the measured data of the drilling holes are analyzed by statistics, the drilling deviation rule of the drilling field is summarized, the design and construction of subsequent drilling holes are guided according to the deviation rule and the drilling coverage blind area, and the gas extraction drilling coverage blind area is reduced or eliminated.
In a specific embodiment, after the data information of the tunnels and the drilling points in S1 is extracted from the database, calibration data including the difference between the magnetic azimuth and the grid azimuth is determined by computer processing, and the number of exit holes, the left-right deviation amount, the up-down deviation amount, the tool azimuth, the tool inclination, the gamma polygon graph, and the measurement results of vibration and shock as a function of depth are calculated. And the calculation processing is carried out according to the data information in the database, so that the information of each parameter can be effectively judged, and the drilling processing is convenient. When the drilling point of S2 is drilled, the range of the drilling point is determined by the difference between the left and right deviation, the tool azimuth, the tool inclination, the magnetic azimuth and the grid azimuth, and when the drilling is performed, the drilling equipment is kept stable and fixed, then the drilling is performed within the range of the left and right deviation, the tool azimuth and the tool inclination, and in order to keep the safety, the vibration and the impact are kept to be operated within the prediction range, according to the calculated parameters, the drilling position and the drilling path can be conveniently predicted and assumed, and the drilling efficiency is improved.
In a specific embodiment, the drilling device in S1 is used for introducing water flow into the drill rod during drilling, and a plurality of overflow holes are arranged on the side wall of the drill rod, and water is injected into the drill hole through the overflow holes. The water injection operation can be realized through the setting of the drill rod, and the process of detecting and drilling according to the change of the water pressure can be realized.
In the implementation process, the industrial looped netowrk and water pressure sensor among S5, YZG7 follow track appearance or YQG1 track appearance communication connection along with boring, and carry out communication connection through the distributed node of industrial looped netowrk under the mine, realize transmitting data information, and in order to improve the precision of transmission, select the optic fibre cable to carry out communication transmission, realize transmitting the data information that detects through the industrial looped netowrk, and adopt the optic fibre that the interference item is little to transmit, improve the efficiency of transmission.
In a specific embodiment, the online monitoring technology of the drilling trajectory of the full data analysis method in S6 preprocesses the data information before receiving the data information when the data information is under the mine, that is, the data processing module receives and filters the data information. In order to improve the accuracy of the data information, the data information is filtered before being received, so that the accuracy of the data information is improved. The filtering processing comprises wavelet transformation denoising, maximum likelihood estimation threshold value method denoising and pulse signal smoothing, the wavelet transformation denoising breaks through the limitation that Fourier transformation does not have any resolving power in a time domain, signal components in a specified frequency band and a time period are analyzed, the acquired signals have baseline drift, and the denoised signals need to be smoothed. In order to improve the accuracy and the accuracy of data information and improve the filtering effect, a plurality of groups of filtering algorithms are adopted for processing, and the linear smoothness degree can be improved. The wavelet transform denoising method has the characteristics of frequency domain and time domain, so that the wavelet transform denoising method has good application in signal denoising, and the threshold denoising method based on the wavelet transform denoising method comprises the following steps:
s601, selecting proper wavelets, and performing wavelet transformation on a given signal to obtain a wavelet transformation coefficient W;
s602, calculating a threshold value, selecting a proper threshold value method to accept or reject the wavelet coefficient, wherein the threshold value is a hard threshold value or a soft threshold value, and obtaining a new wavelet coefficient W delta;
s603, performing inverse transformation on the obtained coefficient to obtain denoised data;
the functional expression of the hard threshold is η (ω) ═ ω I (| ω | > T), and the functional expression of the soft threshold is η (ω) ═(ω -sgn (ω) T) I (| ω | > T). The threshold value can be effectively calculated through wavelet transformation denoising, and the denoising effect can be realized. The smaller the entropy value of denoising by the maximum likelihood estimation threshold method is, the more sparse the distribution is, and the worse the uniformity is; sparse distribution has no quantitative definition, and generally refers to the distribution of a peak existing at the zero point of a probability density function; the signals collected at the well mouth are additive mixed signals of water pressure positive pulse signals and noise, the probability density function of the signals is typical sparse distribution, and the following threshold criteria are obtained for the signals conforming to the sparse distribution form according to the maximum likelihood principle:
wherein,
d and sigma are standard deviations of the signal and the noise respectively, and when the square term is less than 0, the open term is 0. The threshold value can be obtained through the calculation processing of the threshold value denoising by the maximum likelihood estimation method, and the filtering processing can be effectively realized. The pulse signal smoothing is used for weakening the influence of interference signals, improving the smoothness of a curve and smoothing data of the denoised signals, a common signal smoothing method is a linear sliding smoothing method, a linear sliding averaging method is a method for linearly smoothing discrete data by using a least square principle, amplitude correction is mainly carried out on a certain point according to the amplitude of a sampling point adjacent to the point, so that the purpose of smoothing and denoising a waveform is achieved, generally, data points of 5 adjacent points are taken for calculation, and the calculation formula is shown as the following formula:
wherein i is 3, 4, … m-2. The influence of interference signals can be weakened through pulse signal smoothing, the smoothness of a curve is improved, and data smoothing processing is carried out on the denoised signals.
Specifically, the working principle of the vision testing device for ophthalmic examination is as follows:
firstly, taking roadway data and drilling point data in a database for analysis: the data information of the roadway and the drilling points stored in the database is called, then analysis processing is carried out, the direction and the depth of the drilling points are judged, the direction and the depth of the drilling points can be clearly and definitely obtained through data analysis, and the drilling processing is convenient to carry out;
step two, realize carrying out effectual drilling treatment to the drilling point through drilling equipment: after the direction and the depth of the drilling point are calculated and processed, drilling equipment is adopted to realize drilling processing on the drilling point in the roadway, namely, the drilling of the drilling point is completed;
thirdly, acquiring data information of the drilling points during drilling: during drilling, the YZG7 trajectory-while-drilling instrument or YQG1 trajectory instrument is adopted to realize drilling trajectory data measurement, namely, the trajectory during drilling is detected, and the route of the drilling trajectory is obtained;
fourthly, monitoring the change condition of the water pressure in the drill rod by adopting a water pressure sensor: in the drilling process, a water pressure sensor is additionally adopted to monitor the change condition of water pressure in a drill rod in the drilling construction process, the change of pressure pulse is generated by collecting the water pressure condition and further arranging a choke valve controlled by a measuring sensor when a flowing water column is controlled, the information is coded by pulse number or coded by pulse amplitude and pulse phase by binary numerical system and received by an earth surface pressure detector, and parameters of a drilling top angle, an azimuth angle and a tool face are respectively measured by adopting various sensors;
and fifthly, realizing real-time transmission of drilling data from the underground drilling site to a ground monitor through an underground industrial ring network: when drilling is carried out, real-time transmission of drilling data from an underground drilling field to a ground monitor is realized through an underground industrial ring network, three-dimensional display of a coal rock interface, coal seam thickness and trend, drilling group tracks and the like of the drilling field is completed through drilling track data processing software of a full data analysis method, and a drilling track on-line monitoring technology based on the full data analysis method is used for determining a drilling blind area;
and sixthly, remotely commanding the underground drilling operation according to the calculation result: after the acquired data information is calculated and processed through the drilling track on-line monitoring technology of the full data analysis method, three-dimensional display of a coal rock interface of a drilling site, the thickness and the trend of a coal bed, the track of a drilling group and the like is completed, and remote monitoring and commanding on the drilling process are realized according to the calculation and processing result.
The above description is only an example of the present application and is not intended to limit the scope of the present application, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present application shall be included in the protection scope of the present application. It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, it need not be further defined and explained in subsequent figures.
The above description is only for the specific embodiments of the present application, but the scope of the present application is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present application, and shall be covered by the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.
Claims (10)
1. The drilling depth calculation method for database management is characterized by comprising the following steps:
s1, retrieving roadway data and drilling point data in the database for analysis: the data information of the roadway and the drilling points stored in the database is called, then analysis processing is carried out, the direction and the depth of the drilling points are judged, the direction and the depth of the drilling points can be clearly and definitely obtained through data analysis, and the drilling processing is convenient to carry out;
s2, the drilling equipment is used for effectively drilling the drilling points: after the direction and the depth of the drilling point are calculated and processed, drilling equipment is adopted to realize drilling processing on the drilling point in the roadway, namely, the drilling of the drilling point is completed;
s3, acquiring data information of the drilling points during drilling: during drilling, the YZG7 trajectory-while-drilling instrument or YQG1 trajectory instrument is adopted to realize drilling trajectory data measurement, namely, the trajectory during drilling is detected, and the route of the drilling trajectory is obtained;
s4, monitoring the change condition of the water pressure in the drill rod by adopting a water pressure sensor: in the drilling process, a water pressure sensor is additionally adopted to monitor the change condition of water pressure in a drill rod in the drilling construction process, the change of pressure pulse is generated by collecting the water pressure condition and further arranging a choke valve controlled by a measuring sensor when a flowing water column is controlled, the information is coded by pulse number or coded by pulse amplitude and pulse phase by binary numerical system and received by an earth surface pressure detector, and parameters of a drilling top angle, an azimuth angle and a tool face are respectively measured by adopting various sensors;
s5, realizing real-time transmission of drilling data from the underground drilling site to a ground monitor through an underground industrial ring network: when drilling is carried out, real-time transmission of drilling data from an underground drilling field to a ground monitor is realized through an underground industrial ring network, three-dimensional display of a coal rock interface, coal seam thickness and trend, drilling group tracks and the like of the drilling field is completed through drilling track data processing software of a full data analysis method, and a drilling track on-line monitoring technology based on the full data analysis method is used for determining a drilling blind area;
s6, remotely commanding the drilling operation under the mine according to the calculation result: after the acquired data information is calculated and processed through the drilling track on-line monitoring technology of the full data analysis method, three-dimensional display of a coal rock interface of a drilling site, the thickness and the trend of a coal bed, the track of a drilling group and the like is completed, and remote monitoring and commanding on the drilling process are realized according to the calculation and processing result.
2. The database-managed borehole depth calculation method of claim 1, wherein said data information of the tunnels and the borehole points in S1, after being extracted from the database, is processed by a computer to determine calibration data comprising the difference between the magnetic azimuth and the grid azimuth, and to calculate the number of exit holes, the left-right deviation, the up-down deviation, the tool azimuth, the tool inclination, the gamma polygon plot, and the measurement of vibration and shock as a function of depth.
3. The database-managed drilling depth calculation method according to claim 1, wherein the drilling equipment in S1 injects water into the drill rod during drilling, and a plurality of overflow holes are formed in a side wall of the drill rod, and water is injected into the drill hole through the overflow holes.
4. The database-managed borehole depth calculation method according to claim 2, wherein the S2 boring point determines a range of boring points by a difference between a left-right deviation amount, a tool azimuth, a tool inclination, a magnetic azimuth, and a grid azimuth while boring, and maintains a smooth fixation of boring equipment while boring, and then boring is performed within the range of the left-right deviation amount, the tool azimuth, and the tool inclination, and in order to maintain safety, operation is performed within a prediction range while maintaining vibration and shock.
5. The method for calculating the drilling depth under database management according to claim 1, wherein the industrial ring network in S5 is in communication connection with a water pressure sensor, a YZG7 track-while-drilling instrument or a YQG1 track instrument, and data information is transmitted by performing communication connection at distributed nodes of the industrial ring network under the mine, and an optical fiber cable is selected for communication transmission in order to improve transmission accuracy.
6. The method for calculating the drilling depth under database management according to claim 5, wherein the online monitoring technology of the drilling trajectory of the full data analysis in step S6 preprocesses the data information before receiving the data information while under the mine, that is, the data processing module receives and filters the data information.
7. The method for calculating the borehole depth under database management according to claim 6, wherein the filtering process comprises wavelet transform denoising, maximum likelihood estimation thresholding denoising and pulse signal smoothing, the wavelet transform denoising breaks through the limitation that Fourier transform does not have any resolving power in the time domain, the signal components in a specified frequency band and time period are analyzed, the acquired signal has baseline drift, and the denoised signal needs to be smoothed.
8. The database-managed borehole depth computation method of claim 7, wherein the wavelet transform denoising has characteristics in frequency domain and time domain, so that the wavelet transform denoising has good application in signal denoising, and the threshold denoising method based on wavelet transform denoising comprises the following steps:
s601, selecting proper wavelets, and performing wavelet transformation on a given signal to obtain a wavelet transformation coefficient W;
s602, calculating a threshold value, selecting a proper threshold value method to accept or reject the wavelet coefficient, wherein the threshold value is a hard threshold value or a soft threshold value, and obtaining a new wavelet coefficient W delta;
s603, performing inverse transformation on the obtained coefficient to obtain denoised data;
the functional expression of the hard threshold is η (ω) ═ ω I (| ω | > T), and the functional expression of the soft threshold is η (ω) ═(ω -sgn (ω) T) I (| ω | > T).
9. The database-managed borehole depth computation method of claim 7, wherein the smaller the entropy of the maximum likelihood estimation thresholding de-noising, the more sparse the distribution is illustrated, and the worse the uniformity is; sparse distribution has no quantitative definition, and generally refers to the distribution of a peak existing at the zero point of a probability density function; the signals collected at the well mouth are additive mixed signals of water pressure positive pulse signals and noise, the probability density function of the signals is typical sparse distribution, and the following threshold criteria are obtained for the signals conforming to the sparse distribution form according to the maximum likelihood principle:
wherein,
d and sigma are standard deviations of the signal and the noise respectively, and when the square term is less than 0, the open term is 0.
10. The method for calculating the drilling depth under database management according to claim 7, wherein the pulse signal smoothing is used for reducing the influence of interference signals, improving the smoothness of a curve, and performing data smoothing on the denoised signals, the commonly used signal smoothing method includes a linear sliding smoothing method, the linear sliding averaging method is a method for performing linear smoothing on discrete data by using a least square principle, and amplitude correction is mainly performed on a certain point according to the amplitude of a sampling point adjacent to the point, so as to achieve the purpose of smoothing and denoising the waveform, and the calculation formula is shown as the following formula:
wherein i is 3, 4, … m-2.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111401263.XA CN114320267A (en) | 2021-11-24 | 2021-11-24 | Database-managed drilling depth calculation method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111401263.XA CN114320267A (en) | 2021-11-24 | 2021-11-24 | Database-managed drilling depth calculation method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114320267A true CN114320267A (en) | 2022-04-12 |
Family
ID=81045960
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111401263.XA Pending CN114320267A (en) | 2021-11-24 | 2021-11-24 | Database-managed drilling depth calculation method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114320267A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116644975A (en) * | 2023-07-27 | 2023-08-25 | 山东卓越精工集团有限公司 | Intelligent supervision method and system for anti-collision hidden engineering construction |
| CN117514128A (en) * | 2024-01-08 | 2024-02-06 | 山西郎腾信息科技有限公司 | Underground coal mine horizontal directional intelligent drilling control method |
-
2021
- 2021-11-24 CN CN202111401263.XA patent/CN114320267A/en active Pending
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116644975A (en) * | 2023-07-27 | 2023-08-25 | 山东卓越精工集团有限公司 | Intelligent supervision method and system for anti-collision hidden engineering construction |
| CN116644975B (en) * | 2023-07-27 | 2023-10-10 | 山东卓越精工集团有限公司 | Intelligent supervision method and system for anti-collision hidden engineering construction |
| CN117514128A (en) * | 2024-01-08 | 2024-02-06 | 山西郎腾信息科技有限公司 | Underground coal mine horizontal directional intelligent drilling control method |
| CN117514128B (en) * | 2024-01-08 | 2024-03-19 | 山西郎腾信息科技有限公司 | Underground coal mine horizontal directional intelligent drilling control method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11591900B2 (en) | Method to predict overpressure uncertainty from normal compaction trendline uncertainty | |
| US10928537B2 (en) | Prediction of formation and stratigraphic layers while drilling | |
| CN114320267A (en) | Database-managed drilling depth calculation method | |
| US11162349B2 (en) | Systems and methods for geosteering during well drilling | |
| US8960326B2 (en) | Formation dip geo-steering method | |
| EP2895950B1 (en) | System, method and computer program product for a rug plot for geosteering applications | |
| CA2160968C (en) | Downhole depth correlation and computation apparatus and methods for combining multiple borehole measurements | |
| US8902701B2 (en) | Methods, apparatus and articles of manufacture to determine anisotropy indicators for subterranean formations | |
| CN115279990A (en) | Automatic geosteering based on distance to oil-water interface | |
| CN113074695A (en) | Tunnel stability interpretation method based on tunnel face three-dimensional deformation monitoring | |
| CN112034530B (en) | House column type goaf investigation system and method | |
| CN114332354A (en) | Mapping method for calculating three-dimensional data of drill hole | |
| GB2591098A (en) | Sub-surface well location determination | |
| CN105888652A (en) | With-depth relative flow rate logging method | |
| CN114861271A (en) | Method for analyzing disease causes of goaf in railway tunnel construction | |
| CN115492639A (en) | Coal roadway driving working face coal and gas outburst early warning method | |
| CN107542448A (en) | A kind of system for wellbore trace monitoring | |
| RU2806206C1 (en) | Horizontal well drilling method | |
| CN102944897B (en) | Correction method for sea well shock speed scissors difference based on standard reference layer | |
| CN115126475B (en) | Multi-point full-period monitoring method for mining damage rule of overburden rock in coal seam mining | |
| CN113433123A (en) | Method for testing geological parameters in drilled hole and intelligent device | |
| Tao | A Brief Discussion on the Geological Guiding Role of FEWD | |
| CN118011470A (en) | Method and system for advanced detection of earthquake while drilling among drilled holes | |
| CN111984721A (en) | Geothermal resource comprehensive evaluation system and method | |
| CN116484457A (en) | Three-dimensional refined grading method, device and medium for surrounding rock of tunnel face by drilling and blasting method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |