Drilling trajectory monitoring method and device, electronic equipment and storage medium

Abstract

The invention relates to a drilling trajectory monitoring method and device, electronic equipment and a storage medium, and belongs to the technical field of geological prospecting. The method comprises the steps that the drilling position sent by a theodolite is obtained; the hole depth sent by a drilling depth gauge is obtained; acquiring an azimuth angle and a vertex angle sent by an inclinometer arranged on the drill bit; synchronously generating a real-time virtual drill hole in a preset drilling virtual model according to the drilling position, the hole depth, the azimuth angle and the vertex angle, and displaying the real-time virtual drill hole; and monitoring a drilling track by comparing the real-time virtual drill hole with a preset virtual drill hole in the drilling virtual model, and when the drilling track is abnormal, generating alarm information and displaying the alarm information on the drilling virtual model. The method has the effect of improving the monitoring intuition of the well drilling track.

Description

Technical Field

[0001] The present application relates to the technical field of geological exploration, and in particular to a drilling trajectory monitoring method, device, electronic equipment and storage medium. Background Art

[0002] During the exploration process, drilling holes is done to obtain important evidence such as underground address information, mineral resource distribution, groundwater conditions, etc. During the drilling process, it is necessary not only to grasp the drilling depth and drilling direction in real time, but also to compare with the preset drilling trajectory, analyze the degree of conformity between the actual drilling and the preset drilling, and the change trend, so that the staff can take timely adjustment measures to ensure that the target is hit and maintain good well depth quality.

[0003] However, the current monitoring of drilling trajectories lacks realism, intuitiveness, and effectiveness, and is difficult to meet demand. Summary of the invention

[0004] In order to improve the intuitiveness of drilling trajectory monitoring, the present application provides a drilling trajectory monitoring method, device, electronic equipment and storage medium.

[0005] In a first aspect, the present application provides a drilling trajectory monitoring method, which adopts the following technical solution: Get the drilling position sent by the theodolite; Get the hole depth sent by the drilling depth gauge; Acquire the azimuth and top angle sent by the inclinometer arranged on the drill bit; Synchronously generating and displaying a real-time virtual drilling in a preset drilling virtual model according to the drilling position, the hole depth, the azimuth angle and the vertex angle; The drilling trajectory is monitored by comparing the real-time virtual drilling with the preset virtual drilling in the drilling virtual model, and when the drilling trajectory is abnormal, an alarm message is generated and displayed on the drilling virtual model.

[0006] By adopting the above technical solutions, the theodolite can accurately measure the geographical location of the borehole, the borehole depth meter can measure the hole depth in real time, and the inclinometer can measure the azimuth and top angle of the drill bit. Based on these measurement data, a real-time virtual borehole can be generated synchronously in the drilling virtual model to intuitively display the position, depth and posture of the borehole. This helps operators to monitor the drilling process in real time, promptly discover and correct deviations, improve data processing efficiency and accuracy, and improve the accuracy of drilling operations. When an abnormality occurs in the drilling, the system can automatically generate an alarm message and display it on the drilling virtual model, which helps operators to quickly locate the problem and take appropriate measures to deal with it to avoid the expansion of the accident.

[0007] Further, the synchronously generating and displaying a real-time virtual drilling in a preset drilling virtual model according to the drilling position, the hole depth, the azimuth angle and the vertex angle includes: Establishing a coordinate system in the virtual model and mapping the coordinate system to the actual longitude and latitude; Determining a corresponding drill top position in the drilling virtual model according to the drilling hole position; A cylindrical real-time virtual borehole with a preset diameter is generated and displayed according to the hole depth, the azimuth angle and the top angle, and the real-time virtual borehole takes the drill top position as a starting point.

[0008] By adopting the above technical solution, a coordinate system is established in the virtual model and mapped with the actual longitude and latitude, so as to ensure the accuracy of the drilling position in the virtual space. The cylindrical real-time virtual borehole generated according to the drilling position, hole depth, azimuth and vertex angle can be intuitively displayed in the virtual model, which helps the operator to understand the shape and position of the borehole more clearly, thereby guiding the drilling operation more accurately.

[0009] Furthermore, the drilling trajectory is monitored by comparing the real-time virtual drilling with a preset real-time virtual drilling in the drilling virtual model, including: Acquiring preset drilling data, wherein the preset drilling data includes a preset hole depth, a preset azimuth angle, and a preset vertex angle; Determining a preset virtual borehole according to the preset drilling data; Determine the deviation distance of the current drilling position according to the comparison between the hole depth, the azimuth and the preset virtual drilling hole; When the deviation distance is greater than the deviation allowable value, a first warning message is generated; If the preset drilling hole is a straight hole, the actual hole depth is obtained every time the preset hole depth reaches 100m. When the error rate between the actual hole depth and the preset hole depth at that time is greater than the preset error rate, the second warning information is generated; If the preset drilling hole is an inclined hole, the actual hole depth is obtained every time the preset hole depth reaches 50m. When the error rate between the actual hole depth and the preset hole depth at that time is greater than the preset error rate, a second warning information is generated; If the preset drilling hole is a straight hole, initially, the actual vertex angle is obtained once every time the preset hole depth reaches 100m, and when the difference between the actual vertex angle and the preset vertex angle is greater than a first preset value, a third warning message is generated, and the actual vertex angle is measured once every time the preset hole depth reaches 50m, and the step of comparing the difference between the actual vertex angle and the preset vertex angle with the preset value is repeated; If the preset drill hole is an inclined hole, initially the actual vertex angle is obtained every time the preset hole depth reaches 50m. When the difference between the actual vertex angle and the preset vertex angle is greater than a second preset value, a third warning message is generated. The actual vertex angle is measured every time the preset hole depth reaches 25m, and the step of comparing the difference between the actual vertex angle and the preset vertex angle with the preset value is repeated.

[0010] By adopting the above technical solution, by comparing the deviation line distance between the real-time virtual drilling and the preset virtual drilling, as well as the error rate between the actual hole depth and the preset hole depth, the technology can detect deviations in the drilling operation in real time and immediately generate early warning information. This helps operators take timely measures to correct the deviations, thereby improving the accuracy of drilling. At the same time, early warning based on the difference between the actual vertex angle and the preset vertex angle can further ensure the accuracy of the drilling direction. For straight holes and inclined holes, the technology sets different measurement frequencies. Straight holes are measured every 100m in depth, and inclined holes are measured every 50m in depth. This setting not only ensures the accuracy of the measurement, but also avoids the cost increase caused by too frequent measurements. When deviations are found, the measurement frequency will be automatically encrypted to track and correct the deviations more accurately.

[0011] Furthermore, the method further comprises: Acquire each drilling data, wherein the drilling data includes at least one of location information, line number, drilling time and section name; According to the drilling data, determining the number corresponding to each drilling hole; Establishing a database, establishing a storage unit corresponding to the drilling hole according to the number in the database, and storing the drilling hole data in the storage unit; In response to an instruction to generate a report, obtaining a current section name corresponding to the instruction; Arrange the boreholes corresponding to the current section name in the order of location information or drilling time, and generate a report based on the corresponding data in the arrangement order; If there are boreholes for which no corresponding section name is saved, the boreholes associated with the current section name are determined, and a report is generated based on the drilling data corresponding to the associated boreholes.

[0012] By adopting the above technical solution, by establishing a database, the data of each borehole is centrally stored, and corresponding storage units are established according to the number. This centralized management method helps to ensure the integrity and consistency of the data and avoid the dispersion and duplication of data. The drilling data in the database is organized according to the number, making the data retrieval fast and efficient. Whether it is based on the drilling number, location information, line number, drilling time or section name, the corresponding data can be quickly found. In response to the instruction to generate a report, the system can automatically obtain the current section name corresponding to the instruction, and arrange the boreholes according to the location information sequence or drilling time. This method of generating reports on demand not only meets the specific needs of users, but also improves the accuracy and timeliness of reports.

[0013] Furthermore, if there is a borehole without a corresponding section name saved, then the boreholes related to the current section name are determined, and a report is generated according to the borehole data corresponding to the related boreholes, including: Acquire a first borehole corresponding to each of the section names; According to the position information of each of the first boreholes, the tops of each of the first boreholes are connected in the drilling virtual model to form a largest closed figure corresponding to each of the current section names; Determine the boreholes within a preset range of the edge of the closed figure as candidate boreholes; Determine whether the drilling data of the candidate borehole has location information and drilling time; If so, determining the distance between each of the candidate boreholes and each of the closed figures; Determine the difference between the drilling time of each candidate borehole and the current section name setting time; Arrange the candidate boreholes in descending order of the distances to determine a first sequence, and determine a first sequence number of the candidate borehole in the first sequence; Deleting candidate boreholes with negative difference values, arranging the remaining candidate boreholes in descending order of the difference values, determining a second sequence, and determining a second sequence number of the candidate borehole in the second sequence; Calculate the first serial number and the second serial number according to a preset weight to obtain a correlation value; Otherwise, generating a third sequence according to the distance of the position information of each candidate borehole from the closed image or the difference between the drilling time of the candidate borehole and the setting time of the current section name, and determining the third sequence number of the candidate borehole in the third sequence as the relevant value; Determine the candidate borehole whose correlation value is greater than a preset value as a borehole related to the current section; The drilling data corresponding to the drilling holes related to the current section are obtained, and the drilling data corresponding to the drilling holes contained in the current section name are combined and arranged in order of position, and a report is generated according to the corresponding data in the arrangement order.

[0014] By adopting the above technical solution, a closed figure is formed by connecting the top of the first borehole in the drilling virtual model, and the candidate boreholes within the preset range of the closed figure edge are determined. This step effectively narrows the search range of related boreholes and improves the accuracy of data processing. The candidate boreholes are sorted and screened using the dual standards of distance and drilling time, further ensuring the close correlation between the final related boreholes and the current section name. After determining the related boreholes, the borehole data corresponding to the current section name are combined, arranged in position order, and a report is generated. This report generation method not only meets the user's specific needs for data, but also ensures the accuracy and completeness of the report content.

[0015] Further, the number includes a first number corresponding to the section name, a second number corresponding to the line number, a third number corresponding to the drilling time, and a fourth number corresponding to the location information, and the storage unit corresponding to the drilling hole is established in the database according to the number, including: For each of the first numbers, a storage unit group corresponding to the same section name is established; A two-dimensional table corresponding to the position information and the drilling time is established in the storage unit group, and each two-dimensional table is a storage unit corresponding to a unique drilling.

[0016] By adopting the above technical solution, a hierarchical data management structure is formed by establishing a storage unit group for the section name and establishing a unique corresponding two-dimensional table storage unit for each borehole in the group. This structure makes the storage and retrieval of data more orderly and efficient, and the composite numbering system ensures the uniqueness of each borehole in the database. By combining multiple dimensions such as section name, line number, drilling time and location information, a unique number is generated for each borehole, thereby avoiding data duplication and confusion.

[0017] In a second aspect, the present application provides a drilling trajectory monitoring device, which adopts the following technical solution: A drilling position acquisition module is used to obtain the drilling position sent by the theodolite; A hole depth acquisition module is used to obtain the hole depth sent by the drilling depth meter; An angle acquisition module, used to acquire the azimuth and vertex angle sent by the inclinometer arranged on the drill bit; A real-time virtual drilling generation module, used to synchronously generate and display a real-time virtual drilling in a preset drilling virtual model according to the drilling position, the hole depth, the azimuth angle and the vertex angle; The trajectory monitoring module is used to monitor the drilling trajectory by comparing the real-time virtual drilling with the preset virtual drilling in the drilling virtual model, and to generate an alarm message when the drilling trajectory is abnormal and display it on the drilling virtual model.

[0018] By adopting the above technical solutions, the drilling position acquisition module can accurately measure the geographical location of the borehole through the theodolite, the hole depth acquisition module can measure the hole depth in real time through the drilling depth meter, and the angle acquisition module can measure the azimuth and top angle of the drill bit through the inclinometer. Based on these measurement data, the real-time virtual drilling generation module can synchronously generate a real-time virtual borehole in the drilling virtual model, intuitively displaying the position, depth and posture of the borehole, which helps operators monitor the drilling process in real time, promptly discover and correct deviations, and improve the accuracy of drilling operations. When an abnormality occurs in the drilling, the trajectory monitoring module can automatically generate an alarm message and display it on the drilling virtual model. This helps operators quickly locate the problem and take appropriate measures to deal with it, thereby avoiding the expansion of the accident. In a third aspect, the present application provides an electronic device, which adopts the following technical solution: An electronic device, comprising: at least one processor; Memory; At least one computer program, wherein the at least one computer program is stored in the memory and configured to be executed by the at least one processor, the at least one computer program being configured to: execute a method as described in any one of the first aspects.

[0019] By adopting the above technical solution, the processor executes the computer program in the memory, and according to the measurement data, a real-time virtual borehole can be synchronously generated in the drilling virtual model, which can intuitively display the position, depth and posture of the borehole, help the operator to monitor the drilling process in real time, promptly discover and correct deviations, improve data processing efficiency and accuracy, and improve the accuracy of drilling operations. When an abnormality occurs in the drilling, an alarm message can be automatically generated and displayed on the drilling virtual model, which helps the operator to quickly locate the problem and take appropriate measures to deal with it, so as to avoid the expansion of the accident.

[0020] In a fourth aspect, the present application provides a computer-readable storage medium, which adopts the following technical solution: A computer-readable storage medium stores a computer program that can be loaded by a processor and executes the method as described in any one of the first aspects.

[0021] By adopting the above technical solution, the processor executes the computer program in the computer-readable storage medium, and according to the measurement data, a real-time virtual borehole can be synchronously generated in the drilling virtual model, which can intuitively display the position, depth and posture of the borehole, help the operator to monitor the drilling process in real time, promptly discover and correct deviations, improve data processing efficiency and accuracy, and improve the accuracy of drilling operations. When an abnormality occurs in the drilling, an alarm message can be automatically generated and displayed on the drilling virtual model, which helps the operator to quickly locate the problem and take appropriate measures to deal with it, so as to avoid the expansion of the accident.

[0022] In summary, the present application includes at least one of the following beneficial technical effects: 1. Based on the measurement data, a real-time virtual borehole can be generated synchronously in the drilling virtual model, which can intuitively display the position, depth and posture of the borehole, helping operators to monitor the drilling process in real time, timely discover and correct deviations, improve data processing efficiency and accuracy, and improve the accuracy of drilling operations. When the drilling is abnormal, an alarm message can be automatically generated and displayed on the drilling virtual model, which helps operators to quickly locate the problem and take appropriate measures to deal with it to avoid the expansion of the accident; 2. By comparing the deviation distance between the real-time virtual drilling and the preset virtual drilling, as well as the error rate between the actual hole depth and the preset hole depth, the deviation in the drilling operation can be discovered in real time and early warning information can be generated immediately, which helps the operator to take timely measures to correct it, thereby improving the drilling accuracy; 3. For straight holes and inclined holes, the technology sets different measurement frequencies. Straight holes are measured every 100m, and inclined holes are measured every 50m. This setting not only ensures the measurement accuracy, but also avoids the cost increase caused by too frequent measurements. When deviations are found, the measurement frequency will be automatically encrypted to track and correct the deviations more accurately. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] Figure 1 It is a flow chart of the drilling trajectory monitoring method in the embodiment of the present application.

[0024] Figure 2 It is a structural block diagram of the drilling trajectory monitoring device in an embodiment of the present application.

[0025] Figure 3 It is a structural block diagram of an electronic device in an embodiment of the present application. DETAILED DESCRIPTION

[0026] In order to make the purpose, technical solution and advantages of the embodiments of the present application clearer, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

[0027] In addition, the term "and / or" in this article is only a description of the association relationship of associated objects, indicating that there can be three relationships. For example, A and / or B can represent: A exists alone, A and B exist at the same time, and B exists alone. In addition, the character " / " in this article, unless otherwise specified, generally means that the associated objects before and after are in an "or" relationship.

[0028] The present application embodiment discloses a drilling trajectory monitoring method. Figure 1 , executed by an electronic device, which can be a server or a terminal device, wherein the server can be an independent physical server, a server cluster or a distributed system composed of multiple physical servers, or a cloud server providing cloud computing services. The terminal device can be a smart phone, a tablet computer, a desktop computer, etc., but is not limited thereto. It includes (steps S101 to S105): Step S101: Acquire the drilling position sent by the theodolite.

[0029] Step S102: Acquire the hole depth sent by the drilling depth meter.

[0030] Step S103: Acquire the azimuth and vertex angle sent by the inclinometer arranged on the drill bit.

[0031] Specifically, the electronic device executes steps S101 to S103 in any order.

[0032] The electronic equipment communicates with the theodolite, the borehole depth gauge and the inclinometer on the drill bit to obtain the borehole position, hole depth, azimuth and top angle respectively.

[0033] Before drilling begins, the theodolite determines the location of the hole to be drilled and obtains the longitude and latitude corresponding to the drilling location. Then, when drilling begins, the hole depth, azimuth and top angle are measured once according to preset time intervals.

[0034] Step S104: Synchronously generate a drilling virtual model according to the drilling position, hole depth, azimuth and vertex angle, including (steps S1041 to S1043): Step S1041: Establish a coordinate system in the drilling virtual model, and map the coordinate system to the actual longitude and latitude.

[0035] Specifically, the electronic device first determines the approximate actual latitude and longitude range of the drilling area, and then establishes a coordinate system corresponding to the range. When the drilling area is subsequently expanded, it is extended using the established coordinate system.

[0036] For example, when initially generating a drilling virtual model, a coordinate system corresponding to geographic area A is generated. When conducting exploration in geographic area B, the relative position relationship between area A and area B, such as distance and direction, is determined, and then the coordinate area corresponding to geographic area B is determined in the coordinate system.

[0037] Step S1042: determining the corresponding drill top position in the drilling virtual model according to the drilling position.

[0038] Specifically, the electronic device determines a coordinate point in the drilling virtual model according to the drilling position, and then determines the coordinate point as the drill top position.

[0039] Step S1043: Generate and display a cylindrical real-time virtual borehole of a preset diameter according to the hole depth, azimuth and top angle, with the real-time virtual borehole taking the drill top position as the starting point.

[0040] Specifically, the length corresponding to the hole depth per unit length is predetermined in the coordinate system. After determining the azimuth and top angle of the borehole, the coordinate point corresponding to the bottom of the borehole is determined in the coordinate system, and then the top position of the drill is connected to the bottom coordinate point to obtain a real-time virtual borehole, and the real-time virtual borehole is further thickened according to the actual borehole width to obtain a cylindrical real-time virtual borehole.

[0041] Step S105: monitoring the drilling trajectory by comparing the real-time virtual drilling with the preset virtual drilling in the drilling virtual model, and generating an alarm message when the drilling trajectory is abnormal and displaying it on the drilling virtual model.

[0042] Wherein, when the electronic device monitors the drilling trajectory by comparing the real-time virtual drilling with the preset virtual drilling in the drilling virtual model, the process includes (steps S1051 to S1058): Step S1051: Acquire preset drilling data, where the preset drilling data includes a preset hole depth, a preset azimuth angle, and a preset vertex angle.

[0043] Specifically, when conducting geological exploration, workers will pre-plan the depth, azimuth and top angle of the drilling hole according to the terrain, and input them into an electronic device, which will save them as preset drilling data.

[0044] Step S1052: Determine a preset virtual drilling hole according to preset drilling data.

[0045] Specifically, the electronic device generates a preset virtual drill hole on the virtual model according to actual drill hole data corresponding to the preset drill hole.

[0046] Step S1053: Determine the deviation distance of the current drilling position based on the comparison of the hole depth, azimuth and preset virtual drilling.

[0047] Specifically, the electronic device draws a perpendicular line from the maximum hole depth point of the actual drilling axis to the preset drilling axis. The intersection of the perpendicular line and the preset drilling axis is the preset position of the depth point, and the distance from the actual depth point to its preset position is the deviation distance of the point.

[0048] Step S1054: When the deviation distance is greater than the deviation allowable value, a first warning message is generated.

[0049] Specifically, when conducting each drilling project, the drilling requirements for the corresponding area of ​​each project are different, and the allowable deviation value is also different. The allowable deviation value can also be refined into the allowable deviation value of the end hole position and the allowable deviation value along the line. The allowable deviation value of the end hole position is the allowable deviation distance at the bottom of the borehole after the drilling is completed, and the allowable deviation value along the line is the allowable deviation distance at any position on the borehole. For example, the allowable deviation value of the end hole position is 80m, and the allowable deviation value of the along the line is 50m.

[0050] Therefore, when the deviation distance is greater than the corresponding deviation allowable value, the current drilling is significantly different from the preset drilling, and the electronic device generates a first warning message, which includes information such as the content and location of the drilling anomaly.

[0051] Step S1055: If the preset drilling hole is a straight hole, the actual hole depth is obtained every time the preset hole depth reaches 100m. When the error rate between the actual hole depth and the preset hole depth at that time is greater than the preset error value, a second warning information is generated.

[0052] Step S1056: If the preset drilling hole is an inclined hole, the actual hole depth is obtained every time the preset hole depth reaches 50m. When the error rate between the actual hole depth and the preset hole depth at that time is greater than the preset error value, a second warning information is generated.

[0053] Specifically, in order to maintain the stability of the drilling process, when drilling a straight hole, the number of casings is used to know how many meters the preset hole depth has penetrated. And because a straight hole is easier to control than an inclined hole, when the preset hole is a straight hole, the actual hole depth is measured every 100 meters of the preset hole, and when the preset hole is an inclined hole, the actual hole depth is measured every 50 meters of the preset hole.

[0054] Among them, the error rate = (actual hole depth - preset hole depth at that time) / (preset hole depth at that time × 100%).

[0055] The preset error rate may be 1%. When the error rate is greater than 1%, correction is required, and the electronic device generates a second warning message including the error rate.

[0056] In order to further improve the drilling accuracy of the borehole, when drilling on a thick ore body (thickness ≥ 30m), the actual hole depth is obtained once when entering and exiting the mine; when drilling on a thin ore body (thickness < 30m), the actual hole depth is obtained once when entering the mine. In addition, the actual hole depth is obtained once before casing installation and after drilling is completed, realizing hole depth monitoring throughout the drilling process.

[0057] Step S1057: If the preset drilling hole is a straight hole, initially the actual vertex angle is obtained every time the preset hole depth reaches 100m. When the difference between the actual vertex angle and the preset vertex angle is greater than the first preset value, a third warning message is generated, and the actual vertex angle is measured every time the preset hole depth reaches 50m, and the step of comparing the difference between the actual vertex angle and the preset vertex angle with the preset value is repeated.

[0058] Step S1058: If the preset drilling hole is an inclined hole, initially the actual vertex angle is obtained every time the preset hole depth reaches 50m. When the difference between the actual vertex angle and the preset vertex angle is greater than the second preset value, a third warning message is generated, and the actual vertex angle is measured every time the preset hole depth reaches 25m. The step of comparing the difference between the actual vertex angle and the preset vertex angle with the preset value is repeated.

[0059] Specifically, since straight holes are easier to control than inclined holes, the preset hole depth in meters is obtained by observing the depth of the sleeve. The actual top angle is measured every time a certain distance is drilled, and the difference is calculated between the actual top angle and the preset top angle, and the difference is compared with the preset value.

[0060] The first preset value may be 2°, and the second preset value may be 3°.

[0061] When the difference is greater than the corresponding preset value, the interval hole depth of each measurement of the actual vertex angle is shortened to perform denser measurement.

[0062] In another possible implementation, the method further includes (steps S11 to S16): Step S11: Acquire each drilling data, the drilling data including at least one of location information, line number, drilling time and section name.

[0063] The location information is the latitude and longitude of the borehole location, the line number is the number corresponding to the exploration line, the drilling time is the time when the drilling starts, and the section name is the name of the area where the drilling project is located. After the drilling is completed, the electronic device automatically records each drilling data. When entering the drilling data, there may be cases where the section name and drilling time are not recorded.

[0064] Step S12: Determine the number corresponding to each drill hole according to the drill hole data.

[0065] Specifically, the number includes a first number corresponding to the section name, a second number corresponding to the line number, a third number corresponding to the drilling time, and a fourth number corresponding to the location information. Step S12 includes: establishing a storage unit group corresponding to the same section name for each first number; establishing a two-dimensional table corresponding to the location information and the drilling time in the storage unit group, and each two-dimensional table is a storage unit corresponding to a unique drilling.

[0066] For example, the first number is the first letter of the full pinyin of each word corresponding to the section name, the second number is input by the staff, the third number corresponding to the drilling time is the abbreviation of the drilling time, and the fourth number is the longitude and latitude. If the drilling time is 10:05 on November 14, 2024, the third number is 2411141005, so the number structure in each storage unit is the first number-second number-third number-fourth number.

[0067] Taking the section name Qinglongshan at longitude and latitude 118.46,39.84, the borehole with line number 26, which was started at 14:33 on May 12, 2023, as an example, the corresponding number is QLS-26-2305121433-118.46,39.84.

[0068] Step S13: Establish a database, establish a storage unit corresponding to the drilling hole according to the number in the database, and store the drilling data in the storage unit.

[0069] Step S14: In response to the instruction to generate a report, the current section name corresponding to the instruction is obtained.

[0070] Specifically, when the staff clicks to generate a report on the terminal, the electronic device responds to the instruction to generate the report and determines the current section name included in the report.

[0071] Step S15: Arrange the boreholes corresponding to the current section name in order of location information or drilling time, and generate a report based on the corresponding data in the arrangement order.

[0072] Specifically, the electronic device presets the order of sorting the location information, such as from north to south and from west to east; and also presets the order of sorting the drilling time, such as in chronological order. When both the location information and the drilling time exist, the report is generated in the order of the drilling time, so that the staff can intuitively view the drilling data corresponding to the current section name in the report.

[0073] Step S16: If there are boreholes without corresponding section names saved, then the boreholes related to the current section name are determined, and a report is generated based on the drilling data corresponding to the related boreholes.

[0074] Specifically, during the drilling process, the staff may miss the drilling information. When there is a drilling without a section name saved, in the process of generating a report, it is necessary to analyze whether the drilling without a section name needs to be added to the report.

[0075] Including (step Sa to step S1): Step Sa: Obtain the first borehole corresponding to each section name.

[0076] Step Sb: According to the position information of each first borehole, the tops of each first borehole are connected in the drilling virtual model to form a largest closed figure corresponding to each current section name.

[0077] Specifically, the first boreholes are displayed in the drilling virtual model according to the corresponding positions, and the electronic device connects the tops of the two adjacent first boreholes to obtain a mesh of lines, and determines the outermost contour in the mesh as the largest closed figure. The largest closed figure represents the drilling range corresponding to the current section name.

[0078] Step Sc: Determine the drill holes within the preset range of the closed figure edge as candidate drill holes.

[0079] Specifically, the drill holes located within the closed figure are all the drill holes corresponding to the current segment name, while the drill holes located within the preset range around the edge of the closed image may be related to the current segment, wherein the preset range can be a ring range of a preset width outward from the edge of the closed figure. Therefore, the drill holes within the preset range are determined as candidate drill holes to be added to the generated report.

[0080] Step Sd: Determine whether the drilling data of the candidate borehole has location information and drilling time.

[0081] If yes, execute step Se to step Si.

[0082] Step Se: Determine the distance between each candidate drill hole and each closed figure.

[0083] Specifically, the electronic device can determine the straight-line distance between the candidate drill hole and the closed figure in the virtual model.

[0084] Step Sf: Determine the difference between the drilling time of each candidate borehole and the current section name setting time.

[0085] Step Sg: Arrange the candidate boreholes in descending order of distance to determine a first sequence, and determine the first sequence number of the candidate borehole in the first sequence.

[0086] Step Sh: Delete candidate boreholes with negative difference values, arrange the remaining candidate boreholes in descending order of difference values, determine a second sequence, and determine the second sequence number of the candidate borehole in the second sequence.

[0087] Specifically, when the difference is negative, it means that the drilling time of the candidate borehole is earlier than the setting time of the current section name, that is, it does not belong to the current section, so it is deleted from the candidate borehole. When the candidate borehole has location information and drilling time, it is arranged according to the two factors to obtain the first sequence and the second sequence. The larger the first sequence number, the closer it is to the closed figure; the larger the second sequence number, the closer it is to the current section drilling time.

[0088] Step Si: Calculate the first serial number and the second serial number according to the preset weight to obtain a correlation value.

[0089] Specifically, the electronic device presets weights corresponding to the first serial number and the second serial number, and the sum of the weights is 1. The electronic device multiplies the first serial number and the second serial number by the corresponding weights and then adds them together, and the obtained correlation value combines the two factors of distance and drilling time.

[0090] Otherwise, execute step Sj: generate a third sequence according to the distance of the location information of each candidate borehole from the closed image or the difference between the drilling time of the candidate borehole and the current section name setting time, and determine the third sequence number of the candidate borehole in the third sequence as the relevant value.

[0091] When the drilling data does not include both location information and drilling time, the electronic device can generate a third sequence according to the descending order of the location information, or calculate the difference between the drilling time of the candidate boreholes and the setting time of the current section name, delete the candidate boreholes with negative difference, and obtain the third sequence according to the descending order of the drilling time, and then determine the relevant value.

[0092] Step Sk: Determine the candidate boreholes whose correlation values ​​are greater than a preset value as boreholes related to the current section.

[0093] Step S1: Obtain the drilling data corresponding to the drilling holes related to the current section, combine the drilling data corresponding to the drilling holes contained in the current section name, arrange them in order of position, and generate a report based on the corresponding data in the order of arrangement.

[0094] Specifically, after the electronic device determines the correlation value, the larger the correlation value is, the closer the candidate borehole is to the current section. The electronic device sets a preset value, and the candidate borehole with a correlation greater than the preset value is regarded as a borehole related to the current section.

[0095] Furthermore, when generating a report, the electronic device generates a report including the data of related drillings in addition to the drilling data including the current section name.

[0096] In order to better implement the above method, the present application embodiment also provides a drilling trajectory monitoring device, referring to Figure 2 , the drilling trajectory monitoring device 200 comprises: The drilling position acquisition module 201 is used to acquire the drilling position sent by the theodolite; The hole depth acquisition module 202 is used to acquire the hole depth sent by the drilling depth meter; An angle acquisition module 203, used to acquire the azimuth and vertex angle sent by the inclinometer arranged on the drill bit; A real-time virtual drilling generation module 204 is used to synchronously generate and display a real-time virtual drilling in a preset drilling virtual model according to the drilling position, the hole depth, the azimuth angle and the vertex angle; The trajectory monitoring module 205 is used to monitor the drilling trajectory by comparing the real-time virtual drilling with the preset virtual drilling in the drilling virtual model, and generate an alarm message when the drilling trajectory is abnormal and display it on the drilling virtual model.

[0097] Furthermore, the real-time virtual drilling generation module 204 is specifically used for: Establish a coordinate system in the virtual model and map the coordinate system to the actual longitude and latitude; Determine the corresponding drill top position in the drilling virtual model according to the drilling hole position; A cylindrical real-time virtual drill hole with a preset diameter is generated and displayed according to the hole depth, azimuth and top angle. The real-time virtual drill hole takes the drill top position as the starting point.

[0098] Furthermore, the trajectory monitoring module 205 is specifically used for: Acquire preset drilling data, the preset drilling data including preset hole depth, preset azimuth angle and preset vertex angle; Determining a preset virtual drilling hole according to preset drilling data; Determine the deviation distance of the current drilling position based on the comparison of hole depth, azimuth and preset virtual drilling; When the deviation distance is greater than the deviation allowable value, a first warning message is generated; If the preset drilling hole is a straight hole, the actual hole depth is obtained every time the preset hole depth reaches 100m. When the error rate between the actual hole depth and the preset hole depth at that time is greater than the preset error rate, the second warning information is generated; If the preset drilling hole is an inclined hole, the actual hole depth is obtained every time the preset hole depth reaches 50m. When the error rate between the actual hole depth and the preset hole depth at that time is greater than the preset error rate, the second warning information is generated; If the preset drilling hole is a straight hole, initially, the actual vertex angle is obtained once every time the preset hole depth reaches 100m, and when the difference between the actual vertex angle and the preset vertex angle is greater than the first preset value, a third warning message is generated, and the actual vertex angle is measured once every time the preset hole depth reaches 50m, and the step of comparing the difference between the actual vertex angle and the preset vertex angle with the preset value is repeated; If the preset drilling hole is an inclined hole, initially the actual vertex angle is obtained every time the preset hole depth reaches 50m. When the difference between the actual vertex angle and the preset vertex angle is greater than the second preset value, a third warning message is generated, and the actual vertex angle is measured every time the preset hole depth reaches 25m. The step of comparing the difference between the actual vertex angle and the preset vertex angle with the preset value is repeated.

[0099] Furthermore, the monitoring module 205 is also used for: When drilling in thick ore bodies (thickness ≥ 30m), obtain the actual hole depth once when entering and exiting the ore; When drilling in a thin ore body (thickness < 30m), obtain the actual hole depth once when entering the mine; The actual hole depth is obtained once before casing is lowered and once after drilling is completed.

[0100] Furthermore, the drilling trajectory monitoring device 200 further includes: A data acquisition module, used to acquire each drilling data, the drilling data including at least one of location information, line number, drilling time and section name; A number determination module is used to determine the number corresponding to each borehole according to the drilling data; A database establishment module is used to establish a database, establish a storage unit corresponding to the drilling hole according to the number in the database, and store the drilling data in the storage unit; An instruction response module, used for responding to an instruction to generate a report and obtaining a current section name corresponding to the instruction; The first report generation module is used to arrange the boreholes corresponding to the current section name according to the position information sequence or the drilling time, and generate a report according to the corresponding data in the arrangement sequence; The second report generation module is used to determine the boreholes related to the current section name if there are boreholes without corresponding section names saved, and generate a report based on the drilling data corresponding to the related boreholes.

[0101] Furthermore, the second report generation module is specifically used for: Get the first borehole corresponding to each section name; According to the position information of each first borehole, the tops of each first borehole are connected in the drilling virtual model to form a largest closed figure corresponding to each current section name; Determine the drill holes within the preset range of the edge of the closed figure as candidate drill holes; Determine whether the drilling data of the candidate borehole has location information and drilling time; If so, determine the distance between each candidate borehole and each closed figure; Determine the difference between the drilling time of each candidate borehole and the current section name setting time; Arrange the candidate boreholes in descending order of distance to determine a first sequence, and determine the first sequence number of the candidate borehole in the first sequence; Deleting candidate boreholes with negative difference values, arranging the remaining candidate boreholes in descending order of difference values, determining a second sequence, and determining a second sequence number of the candidate borehole in the second sequence; Calculate the first serial number and the second serial number according to the preset weight to obtain a correlation value; Otherwise, a third sequence is generated according to the distance of the location information of each candidate borehole from the closed image or the difference between the drilling time of the candidate borehole and the setting time of the current section name, and the third sequence number of the candidate borehole in the third sequence is determined as the relevant value; Determine the candidate boreholes whose correlation values ​​are greater than a preset value as boreholes related to the current section; Get the drilling data corresponding to the drilling holes related to the current section, combine the drilling data corresponding to the drilling holes contained in the current section name, arrange them in order of position, and generate a report based on the corresponding data in the arrangement order.

[0102] Furthermore, the database establishment module is specifically used for: For each first number, a storage unit group corresponding to the same section name is established; A two-dimensional table corresponding to the position information and the drilling time is established in the storage unit group, and each two-dimensional table is a storage unit corresponding to a unique drilling.

[0103] The various variations and specific examples of the methods in the aforementioned embodiments are also applicable to the drilling trajectory monitoring device in this embodiment. Through the aforementioned detailed description of the drilling trajectory monitoring method, those skilled in the art can clearly know the implementation method of the drilling trajectory monitoring device in this embodiment, so for the sake of brevity of the specification, it will not be described in detail here.

[0104] In order to better implement the above method, the present application embodiment provides an electronic device, referring to Figure 3 , the electronic device 300 includes: a processor 301, a memory 303 and a display screen 305. Among them, the memory 303 and the display screen 305 are connected to the processor 301, such as through a bus 302. Optionally, the electronic device 300 may also include a transceiver 304. It should be noted that in actual applications, the transceiver 304 is not limited to one, and the structure of the electronic device 300 does not constitute a limitation on the embodiments of the present application.

[0105] The processor 301 may be a CPU (Central Processing Unit), a general-purpose processor, a DSP (Digital Signal Processor), an ASIC (Application Specific Integrated Circuit), an FPGA (Field Programmable Gate Array) or other programmable logic devices, transistor logic devices, hardware components or any combination thereof. It may implement or execute various exemplary logic blocks, modules and circuits described in conjunction with the disclosure of this application. The processor 301 may also be a combination that implements computing functions, such as a combination of one or more microprocessors, a combination of a DSP and a microprocessor, etc.

[0106] The bus 302 may include a path to transmit information between the above components. The bus 302 may be a PCI (Peripheral Component Interconnect) bus or an EISA (Extended Industry Standard Architecture) bus, etc. The bus 302 may be divided into an address bus, a data bus, a control bus, etc.

[0107] The memory 303 may be a ROM (Read Only Memory) or other types of static storage devices that can store static information and instructions, a RAM (Random Access Memory) or other types of dynamic storage devices that can store information and instructions, or an EEPROM (Electrically Erasable Programmable Read Only Memory), a CD-ROM (Compact Disc Read Only Memory) or other optical disk storage, optical disk storage (including compressed optical disk, laser disk, optical disk, digital versatile disk, Blu-ray disk, etc.), a magnetic disk storage medium or other magnetic storage device, or any other medium that can be used to carry or store the desired program code in the form of instructions or data structures and can be accessed by a computer, but is not limited thereto.

[0108] The memory 303 is used to store the application code for executing the solution of the present application, and the execution is controlled by the processor 301. The processor 301 is used to execute the application code stored in the memory 303 to implement the contents shown in the above method embodiment.

[0109] Figure 3 The electronic device 300 shown is merely an example and should not bring any limitation to the functions and scope of use of the embodiments of the present application.

[0110] The embodiment of the present application also provides a computer-readable storage medium, which stores a computer program. When the program is executed by a processor, the drilling trajectory monitoring method provided in the above embodiment is implemented. The processor executes the computer program in the computer-readable storage medium, and based on the measurement data, synchronously generates a real-time virtual borehole in the drilling virtual model, which intuitively displays the position, depth and posture of the borehole, helps operators to monitor the drilling process in real time, promptly discover and correct deviations, improve data processing efficiency and accuracy, and improve the accuracy of drilling operations. When an abnormality occurs in the drilling, an alarm message can be automatically generated and displayed on the drilling virtual model, which helps operators to quickly locate the problem and take appropriate measures to deal with it, thereby avoiding the expansion of the accident.

[0111] In this embodiment, the computer-readable storage medium may be a tangible device that holds and stores instructions used by the instruction execution device. The computer-readable storage medium may be, but is not limited to, an electrical storage device, a magnetic storage device, an optical storage device, an electromagnetic storage device, a semiconductor storage device, or any combination thereof. Specifically, the computer-readable storage medium may be a portable computer disk, a hard disk, a USB flash drive, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a static random access memory (SRAM), a portable compact disk read-only memory (CD-ROM), a digital versatile disk (DVD), a memory stick, a floppy disk, an optical disk, a magnetic disk, a mechanical encoding device, and any combination thereof.

[0112] The computer program in this embodiment includes program codes for executing all the aforementioned methods, and the program codes may include instructions corresponding to the steps of the methods provided in the above embodiments. The computer program can be downloaded from a computer-readable storage medium to various computing / processing devices, or downloaded to an external computer or external storage device via a network (such as the Internet, a local area network, a wide area network, and / or a wireless network). The computer program can be executed completely on the user's computer or as an independent software package.

[0113] The above are all preferred embodiments of the present application, and the protection scope of the present application is not limited thereto. Therefore, any equivalent changes made according to the structure, shape, and principle of the present application should be included in the protection scope of the present application.

[0114] In addition, it is to be understood that relational terms such as first and second are used only to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. The terms "comprises," "comprising," or any other variation thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or device that includes a series of elements includes not only those elements, but also other elements that are not explicitly listed, or elements that are inherent to such process, method, article, or device.

Claims

1. A drilling trajectory monitoring method, characterized in that: include: Get the drilling position sent by the theodolite; Get the hole depth sent by the drilling depth gauge; Acquire the azimuth and top angle sent by the inclinometer arranged on the drill bit; Synchronously generating and displaying a real-time virtual drilling in a preset drilling virtual model according to the drilling position, the hole depth, the azimuth angle and the vertex angle; The drilling trajectory is monitored by comparing the real-time virtual drilling with the preset virtual drilling in the drilling virtual model, and when the drilling trajectory is abnormal, an alarm message is generated and displayed on the drilling virtual model.

2. The method according to claim 1, characterized in that The step of synchronously generating and displaying a real-time virtual borehole in a preset drilling virtual model according to the borehole position, the hole depth, the azimuth angle and the vertex angle comprises: Establishing a coordinate system in the drilling virtual model and mapping the coordinate system to actual longitude and latitude; Determining a corresponding drill top position in the drilling virtual model according to the drilling hole position; A cylindrical real-time virtual borehole with a preset diameter is generated and displayed according to the hole depth, the azimuth angle and the top angle, and the real-time virtual borehole takes the drill top position as a starting point.

3. The method according to claim 1, characterized in that The monitoring of the drilling trajectory by comparing the real-time virtual drilling with a preset real-time virtual drilling in the drilling virtual model includes: Acquiring preset drilling data, wherein the preset drilling data includes a preset hole depth, a preset azimuth angle, and a preset vertex angle; Determining a preset virtual borehole according to the preset drilling data; Determine the deviation distance of the current drilling position according to the comparison between the hole depth, the azimuth and the preset virtual drilling hole; When the deviation distance is greater than the deviation allowable value, a first warning message is generated; If the preset drilling hole is a straight hole, the actual hole depth is obtained every time the preset hole depth reaches 100m. When the error rate between the actual hole depth and the preset hole depth at that time is greater than the preset error rate, the second warning information is generated; If the preset drilling hole is an inclined hole, the actual hole depth is obtained every time the preset hole depth reaches 50m. When the error rate between the actual hole depth and the preset hole depth at that time is greater than the preset error rate, a second warning information is generated; If the preset drilling hole is a straight hole, initially, the actual vertex angle is obtained once every time the preset hole depth reaches 100m, and when the difference between the actual vertex angle and the preset vertex angle is greater than a first preset value, a third warning message is generated, and the actual vertex angle is measured once every time the preset hole depth reaches 50m, and the step of comparing the difference between the actual vertex angle and the preset vertex angle with the preset value is repeated; If the preset drill hole is an inclined hole, initially the actual vertex angle is obtained every time the preset hole depth reaches 50m. When the difference between the actual vertex angle and the preset vertex angle is greater than a second preset value, a third warning message is generated. The actual vertex angle is measured every time the preset hole depth reaches 25m, and the step of comparing the difference between the actual vertex angle and the preset vertex angle with the preset value is repeated.

4. The method according to claim 3, characterized in that The method further comprises: When drilling in thick ore bodies (thickness ≥ 30m), obtain the actual hole depth once when entering and exiting the ore; When drilling in a thin ore body (thickness < 30m), obtain the actual hole depth once when entering the mine; The actual hole depth is obtained once before casing is lowered and once after drilling is completed.

5. The method according to claim 1, characterized in that The method further comprises: Acquire each drilling data, wherein the drilling data includes at least one of location information, line number, drilling time and section name; According to the drilling data, determining the number corresponding to each drilling hole; Establishing a database, establishing a storage unit corresponding to the drilling hole according to the number in the database, and storing the drilling hole data in the storage unit; In response to an instruction to generate a report, obtaining a current section name corresponding to the instruction; Arrange the boreholes corresponding to the current section name in the order of location information or drilling time, and generate a report based on the corresponding data in the arrangement order; If there are boreholes for which no corresponding section name is saved, the boreholes associated with the current section name are determined, and a report is generated based on the drilling data corresponding to the associated boreholes.

6. The method according to claim 5, characterized in that If there is a borehole without a corresponding section name saved, then determine the borehole related to the current section name, and generate a report according to the borehole data corresponding to the related borehole, including: Acquire a first borehole corresponding to each of the section names; According to the position information of each of the first boreholes, the tops of each of the first boreholes are connected in the drilling virtual model to form a largest closed figure corresponding to each of the current section names; Determine the boreholes within a preset range of the edge of the closed figure as candidate boreholes; Determine whether the drilling data of the candidate borehole has location information and drilling time; If so, determining the distance between each of the candidate boreholes and each of the closed figures; Determine the difference between the drilling time of each candidate borehole and the current section name setting time; Arrange the candidate boreholes in descending order of the distances to determine a first sequence, and determine a first sequence number of the candidate borehole in the first sequence; Deleting candidate boreholes with negative difference values, arranging the remaining candidate boreholes in descending order of the difference values, determining a second sequence, and determining a second sequence number of the candidate borehole in the second sequence; Calculate the first serial number and the second serial number according to a preset weight to obtain a correlation value; Otherwise, generating a third sequence according to the distance of the position information of each candidate borehole from the closed image or the difference between the drilling time of the candidate borehole and the setting time of the current section name, and determining the third sequence number of the candidate borehole in the third sequence as the relevant value; Determine the candidate borehole whose correlation value is greater than a preset value as a borehole related to the current section; The drilling data corresponding to the drilling holes related to the current section are obtained, and the drilling data corresponding to the drilling holes contained in the current section name are combined and arranged in order of position, and a report is generated according to the corresponding data in the arrangement order.

7. The method according to claim 5, characterized in that The number includes a first number corresponding to the section name, a second number corresponding to the line number, a third number corresponding to the drilling time, and a fourth number corresponding to the location information. The storage unit corresponding to the drilling hole is established in the database according to the number, including: For each of the first numbers, a storage unit group corresponding to the same section name is established; A two-dimensional table corresponding to the position information and the drilling time is established in the storage unit group, and each two-dimensional table is a storage unit corresponding to a unique drilling.

8. A drilling trajectory monitoring device, characterized in that: include: A drilling position acquisition module is used to obtain the drilling position sent by the theodolite; A hole depth acquisition module is used to obtain the hole depth sent by the drilling depth meter; An angle acquisition module, used to acquire the azimuth and vertex angle sent by the inclinometer arranged on the drill bit; A real-time virtual drilling generation module, used to synchronously generate and display a real-time virtual drilling in a preset drilling virtual model according to the drilling position, the hole depth, the azimuth angle and the vertex angle; The trajectory monitoring module is used to monitor the drilling trajectory by comparing the real-time virtual drilling with the preset virtual drilling in the drilling virtual model, and to generate an alarm message when the drilling trajectory is abnormal and display it on the drilling virtual model.

9. An electronic device, characterized in that: include: at least one processor; Memory; At least one computer program, wherein the at least one computer program is stored in the memory and configured to be executed by the at least one processor, the at least one computer program being configured to: execute the method according to any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: A computer program is stored which can be loaded by a processor and execute the method according to any one of claims 1 to 7.

Images