Engineering blasting drilling position information batch processing method and system
By applying computer programs and automated algorithms in blasting design to process drilling position information, the problems of inaccurate position relationship representation and complex calculation in the prior art are solved, and efficient and accurate position information processing and big data application are achieved.
Patent Information
- Application Number
- CN202411470393.2
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-10-21
- Publication Date
- 2025-03-25
AI Technical Summary
The prior art cannot accurately represent the positional relationship between drills in blasting design, and the calculation is complex and the accuracy is low.
Through computer programs and automated algorithms, the polygons and triangles formed by central drilling and adjacent drilling are used to batch process the position information, including adjacent drilling screening, polygon division, angle rearrangement and position information processing.
The intelligence and efficiency of position information acquisition and batch processing are improved. The generated position information can accurately represent the position relationship between each drill, improve practicality, and provide high-value data support for training big data models.
Smart Images

Figure CN119691585A_ABST
Abstract
Description
Technical Field
[0001] The invention belongs to the technical field of engineering blasting, and in particular relates to a method and system for batch processing of engineering blasting drilling position information. Background Art
[0002] In blasting design, the spacing and row spacing of the boreholes in the entire blasting block are unified design values, but the spacing and row spacing between the actual borehole positions are biased. The design value of the row spacing between the boreholes in the blasting block can only guide the arrangement of the holes, and cannot accurately represent the actual row spacing of the boreholes inside the blasting area. Secondly, the foundation in blasting engineering often occurs near the centroid of the triangle formed by adjacent boreholes. The charging parameters of the boreholes at the corner points of the triangle are superimposed and calculated to the centroid. This process is complex and has low accuracy. Summary of the invention
[0003] In order to solve the problems in the prior art of poor accuracy in positional relationship representation, complex process calculation and low precision, the present invention aims to provide a method and system for batch processing of engineering blasting drilling position information.
[0004] The technical solution adopted by the present invention is:
[0005] A method for batch processing of engineering blasting drilling position information comprises the following steps:
[0006] According to the actual borehole coordinate data of the blasting area boreholes including several boreholes, drilling with any borehole as the center, screening the adjacent boreholes, and obtaining several borehole center coordinate data sets;
[0007] According to the borehole center coordinate data set, a borehole polygon is constructed, and with the center of the central borehole as the center, a connecting line from the center to the centers of adjacent boreholes is constructed to divide the borehole polygon into a number of triangles;
[0008] According to the preset direction, the angle between each connecting line and the adjacent connecting line is obtained, and the drilling hole center coordinate data set is rearranged according to the angle to obtain the arranged drilling hole center coordinate data set;
[0009] Traverse all the arranged borehole center coordinate data sets to obtain the engineering blasting drilling location information corresponding to all center boreholes.
[0010] Furthermore, each borehole center coordinate data set includes central borehole center coordinate data and a plurality of adjacent borehole coordinate data.
[0011] Further, according to the actual borehole coordinate data of the blasting area boreholes including several boreholes, drilling with any borehole as the center, performing adjacent borehole screening, and obtaining several borehole center coordinate data sets, including the following steps:
[0012] Import the actual drilling coordinate data of the blasting area drilling including several boreholes, and drill with any borehole as the center;
[0013] According to the actual drilling coordinate data of the blasting area drilling, obtain the distance data from the center of all other drilling holes to the center of the central drilling hole;
[0014] According to the distance data, adjacent boreholes are screened, and several other boreholes whose hole center distances are less than a threshold are used as adjacent boreholes of the current central borehole;
[0015] According to the central borehole center coordinate data of the current central borehole and the adjacent borehole coordinate data of a number of adjacent boreholes, a corresponding borehole center coordinate data set is obtained;
[0016] All the boreholes are traversed to obtain several borehole center coordinate data sets of each borehole as the center.
[0017] Furthermore, according to the actual coordinate data of the boreholes in the blasting area, the distance data from the center of all other boreholes to the center of the central borehole are obtained using the K-NN algorithm and the distance formula.
[0018] Further, according to the borehole center coordinate data set, a borehole polygon is constructed, and with the center of the central borehole as the center, a connection line between the center and the centers of adjacent boreholes is constructed to divide the borehole polygon into a number of triangles, including the following steps:
[0019] Constructing a drilling polygon including a plurality of adjacent edges according to adjacent drilling center coordinate data sets of a plurality of adjacent drilling holes in the drilling center coordinate data set;
[0020] Taking the center of the central drill hole as the center, construct the connection line from the center to the center of the adjacent drill holes;
[0021] A triangle is constructed according to two adjacent lines and a corresponding adjacent edge, and all adjacent edges of the drilling polygon are traversed to divide the drilling polygon into several triangles.
[0022] Further, according to the preset direction, the angle between each connecting line and the adjacent connecting line is obtained, and according to the angle, the drilling hole center coordinate data set is rearranged to obtain the arranged drilling hole center coordinate data set, including the following steps:
[0023] According to the preset direction, the angle between each connecting line and the adjacent connecting line is obtained, and the angle is used as the angle data of the adjacent drilling hole corresponding to the connecting line;
[0024] The angle data and distance data of the adjacent boreholes are added to the corresponding adjacent borehole coordinate data in the borehole center coordinate data set to obtain the added borehole center coordinate data set;
[0025] According to the angle data and distance data of the adjacent boreholes, the quick sorting algorithm is used to rearrange the coordinate data set of the center points of the added boreholes to obtain the arranged coordinate data set of the center points of the boreholes.
[0026] Furthermore, all arranged borehole center coordinate data sets are traversed to obtain the engineering blasting drilling location information corresponding to all center boreholes, including the following steps:
[0027] According to the borehole center coordinate data, angle data and distance data of the adjacent boreholes in the arranged borehole center coordinate data set, the adjacent borehole position information corresponding to the adjacent boreholes is obtained;
[0028] Traversing all neighboring boreholes in the arranged borehole center coordinate data set to obtain neighboring borehole position information of several neighboring boreholes corresponding to the current center borehole;
[0029] After traversing the arranged borehole center coordinate data set of all center boreholes, the engineering blasting drilling hole location information corresponding to all center boreholes is obtained.
[0030] A batch processing system for engineering blasting drilling position information is used to implement a batch processing method for engineering blasting drilling position information. The system comprises a neighboring drilling screening unit, a triangle division unit, a rearrangement unit and a position information processing unit which are connected in sequence.
[0031] The beneficial effects of the present invention are:
[0032] The present invention provides a method and system for batch processing of engineering blasting borehole position information, which realizes data processing through computer programs and automated algorithms, thereby improving the intelligence and efficiency of position information acquisition and batch processing; the generated engineering blasting borehole position information can accurately represent the positional relationship between the boreholes, thereby improving practicality; the acquired engineering blasting borehole position information has high data value, can provide data support for other technologies, such as big data model training, and has strong scalability; the triangle formed by the central borehole and the adjacent boreholes is represented in the position information of the three boreholes, respectively, and model training is performed separately, thereby avoiding the complex process of allocating the borehole charging parameters to the triangle centroid through empirical calculation in the traditional technology, and improving the accuracy.
[0033] Other beneficial effects of the present invention will be further described in the specific embodiments. BRIEF DESCRIPTION OF THE DRAWINGS
[0034] Figure 1 It is a flowchart of the method for batch processing of engineering blasting drilling position information in the present invention.
[0035] Figure 2 It is a structural block diagram of the batch processing system of engineering blasting drilling position information in the present invention. DETAILED DESCRIPTION
[0036] The present invention will be further explained below in conjunction with the accompanying drawings and specific embodiments.
[0037] Embodiment 1:
[0038] like Figure 1 As shown, this embodiment provides a method for batch processing of engineering blasting drilling location information, comprising the following steps:
[0039] S1: Based on the actual drilling coordinate data of the blasting area drilling holes including a plurality of drilling holes, a drilling hole is taken as the center, and the neighboring drilling holes are screened to obtain a plurality of drilling hole center coordinate data sets, each drilling hole center coordinate data set including the center drilling hole center coordinate data and a plurality of neighboring drilling hole coordinate data, including the following steps:
[0040] S1-1: Import the actual drilling coordinate data of the blasting area drilling including several boreholes, and drill with any borehole as the center;
[0041] S1-2: Based on the actual drilling coordinate data of the blasting area drilling holes, the K-Nearest Neighbors (K-NN) algorithm and distance formula are used to obtain the distance data from the center of all other drilling holes to the center of the central drilling hole;
[0042] S1-3: Screen adjacent boreholes based on the distance data, and select six other boreholes whose hole center distances are less than a threshold as adjacent boreholes of the current central borehole;
[0043] S1-4: obtaining a corresponding borehole center coordinate data set according to the center borehole center coordinate data of the current center borehole and the neighboring borehole coordinate data of six neighboring boreholes;
[0044] S1-5: traverse all the boreholes to obtain six borehole center coordinate data sets with each borehole as the center;
[0045] S2: Construct a drilling polygon based on the drilling center coordinate data set, and construct a connection line from the center to the adjacent drilling centers with the center as the center, and divide the drilling polygon into 6 triangles, including the following steps:
[0046] S2-1: constructing a drilling polygon including 6 adjacent edges according to the adjacent drilling center coordinate data sets of 6 adjacent drilling holes in the drilling center coordinate data set;
[0047] S2-2: Taking the center of the central drill hole as the center, construct the connection line between the center and the center of the adjacent drill holes;
[0048] S2-3: construct a triangle based on two adjacent lines and a corresponding adjacent edge, and traverse all adjacent edges of the drilling polygon to divide the drilling polygon into 6 triangles;
[0049] S3: According to the preset direction, the angle between each connecting line and the adjacent connecting line is obtained, and the drilling hole center coordinate data set is rearranged according to the angle to obtain the arranged drilling hole center coordinate data set, including the following steps:
[0050] S3-1: according to a preset direction (clockwise or counterclockwise, globally unified), obtain the angle between each connecting line and the adjacent connecting line, and use the angle as the angle data of the adjacent drilling hole corresponding to the connecting line;
[0051] S3-2: adding the angle data and distance data of the adjacent boreholes to the corresponding adjacent borehole coordinate data set in the borehole center coordinate data set to obtain the added borehole center coordinate data set;
[0052] S3-3: according to the angle data and distance data of the adjacent boreholes, the quick sorting algorithm is used to rearrange the added borehole center coordinate data set to obtain the arranged borehole center coordinate data set;
[0053] S4: Traverse all arranged drill hole center coordinate data sets to obtain engineering blasting drill hole location information corresponding to all center drill holes, including the following steps:
[0054] S4-1: Obtaining the adjacent borehole position information corresponding to the adjacent borehole according to the borehole center coordinate data, angle data and distance data of the adjacent borehole in the arranged borehole center coordinate data set;
[0055] S4-2: traverse all neighboring boreholes in the arranged borehole center coordinate data set to obtain neighboring borehole position information of six neighboring boreholes corresponding to the current center borehole;
[0056] S4-3: using the adjacent drilling hole position information of the six adjacent drilling holes of the same central drilling hole as the corresponding engineering blasting drilling hole position information;
[0057] S4-4: Traverse the arranged drill hole center coordinate data set of all center drill holes to obtain the engineering blasting drill hole position information corresponding to all center drill holes.
[0058] This embodiment is an application of big data technology in the field of engineering blasting, and provides a fast and accurate method for batch processing of engineering blasting drilling location information.
[0059] Embodiment 2:
[0060] like Figure 2As shown, this embodiment provides a batch processing system for engineering blasting drilling position information, which is used to implement a batch processing method for engineering blasting drilling position information. The system includes a neighboring drilling screening unit, a triangle division unit, a rearrangement unit and a position information processing unit connected in sequence;
[0061] A neighboring borehole screening unit is used to perform neighboring borehole screening based on actual borehole coordinate data of the blasting area boreholes including several boreholes, taking any borehole as the center of the borehole, and obtain several borehole center coordinate data sets;
[0062] A triangle division unit is used to construct a drilling polygon according to the drilling center coordinate data set, and to construct a connection line between the center and the adjacent drilling centers with the center as the center, so as to divide the drilling polygon into a plurality of triangles;
[0063] A rearrangement unit is used to obtain the angle between each connecting line and the adjacent connecting line according to a preset direction, and rearrange the drilling hole center coordinate data set according to the angle to obtain the rearranged drilling hole center coordinate data set;
[0064] The position information processing unit is used to traverse all arranged borehole center coordinate data sets to obtain the engineering blasting drilling position information corresponding to all center boreholes.
[0065] The present invention provides a method and system for batch processing of engineering blasting borehole position information, which realizes data processing through computer programs and automated algorithms, thereby improving the intelligence and efficiency of position information acquisition and batch processing; the generated engineering blasting borehole position information can accurately represent the positional relationship between the boreholes, thereby improving practicality; the acquired engineering blasting borehole position information has high data value, can provide data support for other technologies, such as big data model training, and has strong scalability; the triangle formed by the central borehole and the adjacent boreholes is represented in the position information of the three boreholes, respectively, and model training is performed separately, thereby avoiding the complex process of allocating the borehole charging parameters to the triangle centroid through empirical calculation in the traditional technology, and improving the accuracy.
[0066] The present invention is not limited to the above optional implementations, and anyone can derive other various forms of products under the enlightenment of the present invention. The above specific implementations should not be understood as limiting the scope of protection of the present invention. The scope of protection of the present invention should be based on the definition in the claims, and the description can be used to interpret the claims.
Claims
1. A method for batch processing of engineering blasting drilling location information, characterized in that: The steps include: According to the actual borehole coordinate data of the blasting area boreholes including several boreholes, drilling with any borehole as the center, screening the adjacent boreholes, and obtaining several borehole center coordinate data sets; According to the borehole center coordinate data set, a borehole polygon is constructed, and with the center of the central borehole as the center, a connecting line from the center to the centers of adjacent boreholes is constructed to divide the borehole polygon into a number of triangles; According to the preset direction, the angle between each connecting line and the adjacent connecting line is obtained, and the drilling hole center coordinate data set is rearranged according to the angle to obtain the arranged drilling hole center coordinate data set; Traverse all the arranged borehole center coordinate data sets to obtain the engineering blasting drilling location information corresponding to all center boreholes.
2. A method for batch processing of engineering blasting drilling position information according to claim 1, characterized in that: Each of the borehole center coordinate data sets includes central borehole center coordinate data and a plurality of adjacent borehole coordinate data.
3. A method for batch processing of engineering blasting drilling position information according to claim 2, characterized in that: According to the actual drilling coordinate data of the blasting area drilling holes including several drilling holes, drilling with any drilling hole as the center, screening the adjacent drilling holes, and obtaining several drilling hole center coordinate data sets, including the following steps: Import the actual drilling coordinate data of the blasting area drilling including several boreholes, and drill with any borehole as the center; According to the actual drilling coordinate data of the blasting area drilling, obtain the distance data from the center of all other drilling holes to the center of the central drilling hole; According to the distance data, adjacent boreholes are screened, and several other boreholes whose hole center distances are less than a threshold are used as adjacent boreholes of the current central borehole; According to the central borehole center coordinate data of the current central borehole and the adjacent borehole coordinate data of a plurality of adjacent boreholes, a corresponding borehole center coordinate data set is obtained; All the boreholes are traversed to obtain several borehole center coordinate data sets of each borehole as the center.
4. A method for batch processing of engineering blasting drilling position information according to claim 3, characterized in that: According to the actual drilling coordinate data of the blasting area drilling, the K-NN algorithm and distance formula are used to obtain the distance data from the center of all other drilling holes to the center of the central drilling hole.
5. The method for batch processing of engineering blasting drilling position information according to claim 3 is characterized by: According to the borehole center coordinate data set, a borehole polygon is constructed, and with the center of the central borehole as the center, a connecting line from the center to the center of the adjacent borehole is constructed to divide the borehole polygon into several triangles, including the following steps: Constructing a drilling polygon including a plurality of adjacent edges according to adjacent drilling center coordinate data sets of a plurality of adjacent drilling holes in the drilling center coordinate data set; Taking the center of the central drill hole as the center, construct the connection line from the center to the center of the adjacent drill holes; A triangle is constructed according to two adjacent lines and a corresponding adjacent edge, and all adjacent edges of the drilling polygon are traversed to divide the drilling polygon into several triangles.
6. A method for batch processing of engineering blasting drilling location information according to claim 5, characterized in that: According to the preset direction, the angle between each connecting line and the adjacent connecting line is obtained, and the drilling hole center coordinate data set is rearranged according to the angle to obtain the arranged drilling hole center coordinate data set, including the following steps: According to the preset direction, the angle between each connecting line and the adjacent connecting line is obtained, and the angle is used as the angle data of the adjacent drilling hole corresponding to the connecting line; The angle data and distance data of the adjacent boreholes are added to the corresponding adjacent borehole coordinate data in the borehole center coordinate data set to obtain the added borehole center coordinate data set; According to the angle data and distance data of the adjacent boreholes, the quick sorting algorithm is used to rearrange the coordinate data set of the center points of the added boreholes to obtain the arranged coordinate data set of the center points of the boreholes.
7. A method for batch processing of engineering blasting drilling position information according to claim 6, characterized in that: Traversing all arranged borehole center coordinate data sets to obtain the engineering blasting drilling location information corresponding to all center boreholes includes the following steps: According to the borehole center coordinate data, angle data and distance data of the adjacent boreholes in the arranged borehole center coordinate data set, the adjacent borehole position information corresponding to the adjacent boreholes is obtained; Traversing all neighboring boreholes in the arranged borehole center coordinate data set to obtain neighboring borehole position information of several neighboring boreholes corresponding to the current center borehole; Using the adjacent borehole position information of several adjacent boreholes of the same central borehole as the corresponding engineering blasting borehole position information; After traversing the arranged borehole center coordinate data set of all center boreholes, the engineering blasting drilling hole location information corresponding to all center boreholes is obtained.
8. A system for batch processing of engineering blasting drilling position information, used to implement the method for batch processing of engineering blasting drilling position information as claimed in any one of claims 1 to 7, characterized in that: The system comprises a neighboring drilling screening unit, a triangle dividing unit, a rearrangement unit and a position information processing unit which are connected in sequence.