Directional drilling track generation method and device based on comprehensive geologic model, equipment and medium

Abstract

The invention relates to the technical field of data processing, and provides a directional drilling track generation method, device, equipment and medium based on a comprehensive geologic model.The method comprises the steps that according to a received point location selection instruction, target point locations are selected in the comprehensive geologic model, and three-dimensional coordinate information of all the target point locations in the same space coordinate system is obtained, wherein the target point location comprises a trepanning point, a key control point and a final hole target point; according to the three-dimensional coordinate information, drawing a three-dimensional spline curve under the maximum curvature constraint by utilizing a mathematical algorithm of a smooth curve, so as to obtain a continuous trajectory generatrix conforming to the engineering constraint; and by taking the continuous trajectory bus as a unique spatial path reference, generating trajectory nodes of directional drilling at equal intervals through a spatial interpolation algorithm, and outputting parameter information of each trajectory node. Through the technical scheme, the trajectory design efficiency is greatly improved, and the uniformity of trajectory node distribution and the accuracy of parameters are ensured.

Description

Technical Field

[0001] This application relates to the field of data processing technology, and in particular to a method, apparatus, equipment and medium for generating directional borehole trajectories based on a comprehensive geological model. Background Technology

[0002] Directional drilling technology, as a core technology in trenchless engineering, energy exploration, and geological disaster management, is expanding from traditional oil and gas pipeline laying to various scenarios such as marine engineering, municipal pipeline construction, intelligent coal mining, and deep geological exploration. The demand for applications such as ultra-long-distance crossings and adaptation to complex strata continues to grow. With the advancement of mine transparency and intelligent engineering construction, comprehensive geological models have become an important technical support for directional drilling construction. They provide accurate geological environment references for trajectory design and are fundamental to achieving borehole obstacle avoidance and precise target hitting. Currently, the guiding accuracy and trajectory smoothness of directional drilling directly affect construction safety and engineering efficiency. For example, in ultra-long-distance river crossings and underground gas drainage drilling in coal mines, trajectory deviations may lead to risks such as collisions between adjacent boreholes, drill rod fatigue fractures, or missing the target stratum, resulting in huge economic losses.

[0003] However, existing directional drilling trajectory design methods still have significant technical shortcomings, making it difficult to adapt to the high-precision and high-efficiency construction requirements in complex scenarios. On the one hand, the industry generally relies on office software such as Excel, manually inputting parameters, applying formulas to calculate trajectory nodes, and then drawing the trajectory using charts. This method is cumbersome and fragmented, not only failing to achieve real-time interaction and integration with comprehensive geological models, resulting in the designed trajectory failing to fully utilize the three-dimensional spatial information and geological constraints in the geological model, but also suffering from inconvenient parameter modification and long design cycles, seriously affecting work efficiency. On the other hand, the lack of a unified spatial coordinate system during manual design makes it easy for errors to occur in the coordinate matching of the borehole opening point, key control points, and final target point. Furthermore, the drawing of trajectory curves does not consider engineering constraints such as maximum curvature, resulting in poor trajectory smoothness. Frequent corrections are required during subsequent construction, which not only increases drill pipe wear and construction risks but may also lead to construction failure due to the trajectory not meeting mechanical performance requirements. In addition, the trajectories generated by traditional methods are mostly presented in the form of planar data, which cannot intuitively reflect the borehole's direction in three-dimensional space and its relative relationship with strata and obstacles, making it difficult to meet the needs of risk prediction and comparison of spatial distribution of multiple boreholes before construction. Summary of the Invention

[0004] This application provides a method, apparatus, equipment, and medium for generating directional borehole trajectories based on a comprehensive geological model, aiming to solve technical problems such as poor model fusion, cumbersome operation, uneven trajectory, and insufficient visualization in related technologies.

[0005] In a first aspect, embodiments of this application provide a method for generating directional borehole trajectories based on a comprehensive geological model, the method comprising: According to the received point selection instruction, target points are selected in the comprehensive geological model, and the three-dimensional coordinate information of each target point in the same spatial coordinate system is obtained. The target points include the hole opening point, key control point and final hole target point. Based on the three-dimensional coordinate information, a three-dimensional spline curve is drawn using a mathematical algorithm for smoothing curves under the maximum curvature constraint, so as to obtain a continuous trajectory generatrix that conforms to engineering constraints. Using the continuous trajectory generatrix as the sole spatial path reference, trajectory nodes for directional drilling are generated at equal intervals using a spatial interpolation algorithm, and parameter information for each trajectory node is output.

[0006] In one embodiment, optionally, the integrated geological model is a high-precision integrated geological model formed by the fusion of multi-source data, including three-dimensional models of strata, coal seams, faults, collapse columns, tunnel engineering, goaf, water accumulation areas, anomaly areas, and metamorphic rocks.

[0007] In one embodiment, optionally, the parameter information of the trajectory node includes: hole depth, inclination angle, azimuth, curvature, and three-dimensional coordinates.

[0008] In one embodiment, optionally, during the selection of target points: the hole opening point is selected in the underground roadway or drilling chamber model of the integrated geological model; the key control point is picked at the top and bottom interface of the target coal seam, the top and bottom interface of the water-bearing strata, or the fault plane in the integrated geological model; the final hole target point is picked on the coal and rock strata, fault, collapse column, old roadway, goaf, water accumulation area, abnormal area, or scorched rock model of the integrated geological model.

[0009] In one embodiment, optionally, based on the three-dimensional coordinate information, a three-dimensional spline curve is drawn under maximum curvature constraints using a mathematical algorithm for smoothing curves, including: Using the three-dimensional coordinate information of each target point as constraint nodes, a preset mathematical algorithm for smoothing curves is invoked. Using the maximum curvature threshold as a trajectory compliance constraint, the spatial shape of the curve is iteratively optimized to ensure that the generated three-dimensional spline curve satisfies that both the planar projection curvature and the elevation projection curvature do not exceed the maximum curvature threshold.

[0010] In one embodiment, optionally, using the continuous trajectory generatrix as the unique spatial path reference, trajectory nodes for directional drilling are generated at equal intervals using a spatial interpolation algorithm, and parameter information for each trajectory node is output, including: Obtain the preset threshold for the equal spacing between trajectory nodes; Taking the starting point of the continuous trajectory generatrix as the initial sampling point, along the extension direction of the continuous trajectory generatrix, the three-dimensional coordinates of each trajectory node are calculated sequentially according to the equal spacing distance threshold and the spatial interpolation algorithm; The corresponding hole depth, inclination angle, azimuth, and curvature are calculated based on the coordinate difference.

[0011] In one embodiment, optionally, the method further includes: Export the parameter information as a parameter table; or The parameter information is stored in the attribute database of the three-dimensional spline curve.

[0012] Secondly, embodiments of this application provide a directional drilling trajectory generation device based on a comprehensive geological model, comprising: The acquisition module is used to select target points in the comprehensive geological model according to the received point selection instructions, and to acquire the three-dimensional coordinate information of each target point in the same spatial coordinate system. The target points include the hole opening point, key control point and final hole target point. The drawing module is used to draw a three-dimensional spline curve based on the three-dimensional coordinate information and using a mathematical algorithm for smoothing curves under maximum curvature constraints, so as to obtain a continuous trajectory generatrix that conforms to engineering constraints. The generation module is used to generate trajectory nodes for directional drilling at equal intervals using the continuous trajectory generatrix as the only spatial path reference and a spatial interpolation algorithm, and outputs the parameter information of each trajectory node.

[0013] Thirdly, a computer device is provided, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the steps of the above-described method for generating directional borehole trajectories based on a comprehensive geological model.

[0014] Fourthly, a computer-readable storage medium is provided, which stores a computer program that, when executed by a processor, implements the steps of the above-described method for generating directional borehole trajectories based on a comprehensive geological model.

[0015] In the above-described scheme for generating directional borehole trajectories based on a comprehensive geological model, the target points are selected in the comprehensive geological model according to the received point selection instructions, and the three-dimensional coordinate information of each target point in the same spatial coordinate system is obtained. The target points include the borehole opening point, key control points, and the final borehole target point. Based on the three-dimensional coordinate information, a three-dimensional spline curve is drawn using a mathematical algorithm for smoothing curves under maximum curvature constraints to obtain a continuous trajectory generatrix that conforms to engineering constraints. Using the continuous trajectory generatrix as the unique spatial path reference, trajectory nodes for directional boreholes are generated at equal intervals using a spatial interpolation algorithm, and the parameter information of each trajectory node is output. The technical solution of this invention, firstly, selects target points based on a comprehensive geological model and obtains three-dimensional coordinates in the same spatial coordinate system, ensuring the coordinate consistency of the borehole opening point, key control points, and final borehole target point, avoiding trajectory positioning errors caused by multi-source coordinate deviations. Simultaneously, it achieves deep integration of trajectory design and the geological model, allowing trajectory planning to intuitively adapt to the geological environment and reducing construction risks caused by poor model interactivity. Secondly, under maximum curvature constraints, a three-dimensional spline curve is drawn using a smoothing curve mathematical algorithm to generate a continuous trajectory generatrix that conforms to engineering constraints. This ensures trajectory smoothness, avoiding problems such as frequent drill rod correction and wear breakage caused by uneven trajectory in traditional manual design. Furthermore, the curvature constraint meets the performance requirements of construction machinery, reducing construction difficulty and safety hazards. Finally, using the trajectory generatrix as the sole reference, a spatial interpolation algorithm is used to generate trajectory nodes at equal intervals and output parameters, replacing Excel's... The tedious manual calculation process significantly improves the efficiency of trajectory design and ensures the uniformity of trajectory node distribution and the accuracy of parameters. It provides standardized and directly applicable trajectory data for guidance control and progress monitoring in subsequent construction, ultimately achieving precision, efficiency and engineering adaptability of directional drilling trajectory design, and adapting to the needs of directional drilling in ultra-long distance and complex geological scenarios. Attached Figure Description

[0016] To more clearly illustrate the technical solutions of the embodiments of this application, the drawings used in the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0017] Figure 1 A schematic flowchart of a method for generating directional borehole trajectories based on an integrated geological model according to an embodiment of this application is shown.

[0018] Figure 2 A schematic flowchart of step S102 in a method for generating directional borehole trajectories based on an integrated geological model according to an embodiment of this application is shown.

[0019] Figure 3 A schematic flowchart of step S103 in a method for generating directional borehole trajectories based on an integrated geological model according to an embodiment of this application is shown.

[0020] Figure 4 A block diagram of a directional borehole trajectory generation apparatus based on an integrated geological model according to an embodiment of this application is shown.

[0021] Figure 5 A block diagram of a computer device according to one embodiment of this application is shown. Detailed Implementation

[0022] To better understand the technical solution of this application, the embodiments of this application will be described in detail below with reference to the accompanying drawings.

[0023] It should be understood that the described embodiments are merely some, not all, of the embodiments in this application. All other embodiments obtained by those skilled in the art based on the embodiments in this application without inventive effort are within the scope of protection of this application.

[0024] The terminology used in the embodiments of this application is for the purpose of describing particular embodiments only and is not intended to be limiting of this application. The singular forms “a,” “the,” and “the” used in the embodiments of this application and the appended claims are also intended to include the plural forms unless the context clearly indicates otherwise.

[0025] The following detailed description of some embodiments of this application is provided in conjunction with the accompanying drawings. Unless otherwise specified, the following embodiments and features can be combined with each other.

[0026] Please see Figure 1 , Figure 1 A schematic flowchart of a method for generating directional borehole trajectories based on an integrated geological model according to an embodiment of this application is shown.

[0027] like Figure 1 As shown, the method for generating directional borehole trajectories based on a comprehensive geological model includes: Step S101: According to the received point selection instruction, select target points in the comprehensive geological model and obtain the three-dimensional coordinate information of each target point in the same spatial coordinate system. The target points include the hole opening point, key control point and final hole target point.

[0028] Point selection instructions are operation instructions entered by users through interactive devices (such as mice and touch screens) to specify key locations in the integrated geological model. They include point type (opening point / critical control point / final hole target point) and spatial location information.

[0029] A comprehensive geological model is a three-dimensional visualization model constructed by integrating multi-source geological data (such as drilling data, geophysical data, and tunnel measurement data), which can intuitively present the underground strata, structures, and engineering distribution.

[0030] The target points are the core and critical locations in directional drilling design, including the starting point (the starting position of drilling), the critical control point (the intermediate position where risks need to be avoided or engineering requirements need to be met), and the final target point (the target position that the drilling must ultimately reach).

[0031] The same spatial coordinate system refers to a unified three-dimensional coordinate system (such as an independent coordinate system for mining areas) to ensure that the coordinates of all target points are based on the same benchmark and to eliminate coordinate deviations.

[0032] In this step, the user inputs point selection commands into the system via the operating terminal. The system responds to the commands in a pre-built integrated geological model, allowing the user to select or pick target points in the model's visualization interface. The borehole opening point typically corresponds to the actual drilling site location downhole, key control points correspond to formation interfaces, faults, and other locations that need to be avoided, and the final borehole target point corresponds to the exploration or construction target area. Simultaneously, the system automatically reads the X, Y, and Z three-dimensional coordinates of each target point in a preset unified spatial coordinate system, ensuring the consistency and accuracy of the coordinate data. In this way, the visualization selection of target points is achieved through the integrated geological model, avoiding the errors of traditional manual point estimation; the unified spatial coordinate system eliminates the deviations of multi-source coordinate transformations, ensuring the correlation of the coordinates of each target point, providing a precise spatial reference for subsequent trajectory generation, and improving the interactivity between point selection and the geological model, making the design process more intuitive.

[0033] Step S102: Based on the three-dimensional coordinate information, a three-dimensional spline curve is drawn under the maximum curvature constraint using a mathematical algorithm for smoothing curves to obtain a continuous trajectory generatrix that conforms to engineering constraints.

[0034] Mathematical algorithms for smoothing curves are mathematical methods used to generate continuous, abrupt curves. They can fit a smoothly transitioning curve using known control points. Maximum curvature constraints are upper limits of curvature set based on the drill pipe's mechanical properties and construction process requirements. This ensures that the curvature of the generated trajectory curve does not exceed the drill pipe's tolerance range, preventing drill pipe breakage or stuck drill. Three-dimensional spline curves are continuous and smooth curves generated by fitting multiple target points (control points) in three dimensions, reflecting the spatial direction of the borehole trajectory. The continuous trajectory generatrix is ​​the core form of the three-dimensional spline curve and serves as the basic spatial path reference for subsequently generating specific trajectory nodes, containing the overall direction and curvature characteristics of the borehole trajectory.

[0035] In this step, the three-dimensional coordinates of each target point are used as control points for curve fitting, and a preset smoothing curve mathematical algorithm is invoked. Simultaneously, a pre-set maximum curvature threshold is used as a constraint condition to iteratively optimize the curve shape during the fitting process. If the planar or elevation projection curvature of a certain curve segment exceeds the threshold, the algorithm automatically adjusts the curve parameters until the generated three-dimensional spline curve fully satisfies the curvature constraint, ultimately obtaining a continuous, smooth trajectory generatrix that meets engineering requirements. This scheme ensures that the smoothing curve algorithm has no abrupt inflection points in the trajectory, avoiding frequent drill pipe turning and wear caused by traditional segmented straight-line designs; the maximum curvature constraint limits the degree of trajectory curvature from an engineering feasibility perspective, reducing construction safety risks; and the continuous trajectory generatrix provides a unified and accurate spatial path reference for subsequent trajectory node generation, ensuring the consistency and compliance of the overall trajectory.

[0036] Step S103: Using the continuous trajectory generatrix as the only spatial path reference, generate trajectory nodes for directional drilling at equal intervals using a spatial interpolation algorithm, and output the parameter information of each trajectory node.

[0037] Spatial interpolation algorithm: Based on the spatial shape of a known curve (trajectory generatrix), this mathematical method (such as linear interpolation or Lagrange interpolation) estimates the coordinates of the intermediate point between any two points on the curve, enabling the generation of equally spaced nodes. Equal spacing means that the distance between trajectory nodes along the extension direction of the trajectory generatrix is ​​uniform, and the interval value is preset according to construction accuracy requirements (e.g., one node every 3 meters / 6 meters). A trajectory node is a specific sampling point on the directional drilling trajectory. Each node contains complete parameters reflecting the drilling state and is the core data unit for construction guidance and monitoring. Parameter information is key data characterizing the spatial position of the trajectory node and the drilling attitude, such as three-dimensional coordinates, hole depth, dip angle, azimuth, and curvature.

[0038] In this step, starting from the origin (drilling point) of the trajectory generatrix, the three-dimensional coordinates of each node are calculated sequentially along the trajectory generatrix based on a preset equal-spacing threshold (e.g., 3 meters). Then, based on the coordinate differences between adjacent nodes, the hole depth (cumulative distance from the drilling point to the current node), inclination angle (angle between the drilling axis and the horizontal plane), azimuth (projection direction of the drilling axis on the horizontal plane), and curvature (degree of curvature of the trajectory at the current node) are calculated using spatial geometric formulas. Finally, all parameters are integrated to form structured data output. The spatial interpolation algorithm ensures the equal-spacing distribution of trajectory nodes, avoiding the tediousness and errors of manual node calculation and improving node generation efficiency. Complete parameter information provides accurate guidance for the equipment during construction, facilitating real-time adjustment of the drilling posture. Simultaneously, the structured output of parameters can be directly connected to the subsequent data management system, achieving seamless integration between trajectory design and construction execution.

[0039] In one embodiment, optionally, the integrated geological model is a high-precision integrated geological model formed by the fusion of multi-source data, including three-dimensional models of strata, coal seams, faults, collapse columns, tunnel engineering, goaf, water accumulation areas, anomaly areas, and metamorphic rocks. Multi-source data fusion is the process of integrating geological data from different sources and of different types (such as drilling core data, seismic exploration data, mine tunnel measured data, and remote sensing data) into a unified model through technologies such as data calibration and overlay analysis. A 3D geological model is a model that presents underground geological structures such as strata, coal seams, and faults, as well as engineering entities (such as mine tunnels and goafs) in the form of 3D geometry, featuring visualization and interactivity.

[0040] The construction of the comprehensive geological model is based on the basic geological survey data of the mining area, integrating stratigraphic lithology data obtained from drilling, fault and collapse column distribution data from geophysical exploration, measured coordinate data from shaft and tunnel construction, and exploration data from special areas such as water accumulation areas and igneous rocks. Using 3D modeling software, coordinate calibration, deduplication, noise reduction, and spatial overlay are performed on the multi-source data to ultimately form a 3D visualization model containing elements such as stratigraphic layers, coal seam boundaries, fault strikes, and goaf extent. The positional accuracy and morphological details of each element in the model have been verified and corrected on-site. Multi-source data fusion ensures that the model covers all key underground geological and engineering information, avoiding information gaps caused by single data sources. The high-precision model provides accurate geological background references for target point selection, helping users avoid risky areas such as goaf and water accumulation areas. At the same time, the intuitive 3D visualization enhances the convenience and safety of the design process, reducing trajectory design errors caused by unclear geological information.

[0041] In one embodiment, optionally, the parameter information of the trajectory node includes: hole depth, inclination angle, azimuth, curvature, and three-dimensional coordinates.

[0042] Hole depth is the cumulative length from the borehole start point to the current trajectory node, usually measured in meters, and is a core indicator for measuring drilling progress. Inclination angle is the angle between the borehole axis and the horizontal plane, ranging from -90° (vertically downward) to 90° (vertically upward), determining the vertical direction of the borehole. Azimuth is the angle between the projection of the borehole axis onto the horizontal plane and true north (clockwise is positive), ranging from 0° to 360°, determining the horizontal direction of the borehole. Curvature is the degree of curvature of the curve at the trajectory node, reflecting the smoothness of the borehole's turning direction, and is directly related to the stress on the drill pipe.

[0043] The parameter information of the trajectory nodes is stored in the form of structured data. The three-dimensional coordinates (X, Y, Z) are directly calculated by spatial interpolation algorithm; the hole depth is obtained by calculating and accumulating the spatial straight-line distance between the current node and the hole opening point; the tilt angle is calculated by using the arctangent function based on the difference in Z coordinates and the difference in horizontal distance between the current node and the previous node; the azimuth is obtained by using the arctangent function combined with quadrant determination based on the difference in X and Y coordinates between the current node and the previous node; and the curvature is obtained by fitting a local arc with the coordinates of three adjacent nodes and calculating the reciprocal of the arc radius.

[0044] In this way, diverse parameter information comprehensively characterizes the spatial position and drilling attitude of trajectory nodes, providing multi-dimensional basis for guidance control, drill rod selection and risk prediction during construction; the standardized definition of parameters ensures that different construction teams have a consistent understanding of the data, avoiding construction deviations caused by ambiguous parameter meanings, and at the same time providing traceable data support for trajectory design optimization and review.

[0045] In one embodiment, optionally, during the selection of target points: the hole opening point is selected in the underground roadway or drilling chamber model of the integrated geological model; the key control point is picked at the top and bottom interface of the target coal seam, the top and bottom interface of the water-bearing strata, or the fault plane in the integrated geological model; the final hole target point is picked on the coal and rock strata, fault, collapse column, old roadway, goaf, water accumulation area, abnormal area, or scorched rock model of the integrated geological model.

[0046] The underground tunnel / drilling site chamber model is a three-dimensional geometric body used in the comprehensive geological model to represent the artificially excavated space underground. It contains information such as tunnel direction, cross-sectional dimensions, and chamber location, and is the actual carrier of the opening point.

[0047] The stratigraphic interface is the boundary between strata of different lithology or different ages (such as the boundary between the top and bottom of a coal seam, or the boundary between sandstone and mudstone layers). Selecting key control points at this location can ensure that the borehole avoids or precisely passes through the target strata.

[0048] Anomaly zones are areas in the comprehensive geological model where the geological conditions differ significantly from the surrounding areas (such as high-gas zones or high-stress zones). Selecting the final borehole target point in this area can enable targeted exploration or remediation.

[0049] In the visualization interface of the integrated geological model, users can select the target point type according to construction needs. When selecting an opening point, the system automatically locates the model area of ​​the underground roadway or drilling site chamber. Users can determine the opening point by clicking on the specific location of the chamber floor or roadway sidewall with the mouse. When selecting a key control point, the system provides a stratigraphic interface picking function. Users can click on the top and bottom interfaces of coal seams, water-bearing strata interfaces, etc. in the model, and the system automatically captures the interface coordinates as key control points. When selecting a final borehole target point, users can pick points on the model of coal and rock layers, faults, etc., according to the exploration target, or pick target points at the edge of goaf or water accumulation area for risk management needs. The coordinates of all points are automatically read and recorded by the model. In this way, the point selection range is subdivided according to geological and engineering scenarios to ensure the relevance and rationality of target point selection. Combined with the precise selection function of the model visualization interface, the positional deviation caused by manual point estimation is avoided. Especially in the selection of key control points and final hole target points, it can directly connect with geological risk avoidance and construction objectives, thereby improving the safety and purposefulness of trajectory design.

[0050] like Figure 2 As shown, in one embodiment, optionally, step S102 includes: Step S201: Using the three-dimensional coordinate information of each target point as constraint nodes, call the preset mathematical algorithm for smoothing curves. Constraint nodes are used to define the key points (i.e. target points) of the curve shape. The curve must pass through all constraint nodes to ensure that the trajectory covers the key locations of the design.

[0051] Step S202: Using the maximum curvature threshold as a trajectory compliance constraint, iteratively optimize the curve space shape to ensure that the generated three-dimensional spline curve satisfies that both the planar projection curvature and the elevation projection curvature do not exceed the maximum curvature threshold.

[0052] Planar projection curvature is the degree of curvature of the projection curve of a 3D spline curve onto a horizontal plane, reflecting the smoothness of the borehole's turning direction in the horizontal direction. Vertical projection curvature is the degree of curvature of the projection curve of a 3D spline curve onto a vertical plane, reflecting the smoothness of the borehole's turning direction in the vertical direction. Iterative optimization is a process of repeatedly calculating and adjusting curve parameters. First, a preliminary curve is fitted; then, it is determined whether the curvature exceeds the limit. If it does, the parameters are corrected until the constraints are met.

[0053] First, the 3D coordinates of each target point are marked as constraint nodes to ensure that the fitted curve must pass through these nodes. Then, a preset smoothing curve mathematical algorithm is called to initially generate a 3D curve based on the constraint nodes. Next, the system calculates the curvature of the projected curves of this curve on the horizontal plane (XY plane) and the vertical plane (XZ or YZ plane), and compares it with the preset maximum curvature threshold (e.g., horizontal curvature ≤ 0.02 / m, vertical curvature ≤ 0.03 / m). If the curvature of a certain segment of the projected curve exceeds the limit, the system automatically adjusts the curve control point parameters of the corresponding segment, recalculates the curve shape, and repeats the iterative process of calculation-comparison-correction until the planar and vertical projected curvatures of the 3D spline curve meet the threshold requirements.

[0054] In this way, the constraint nodes ensure that the curve covers all key target points and avoids the trajectory deviating from the core design; the dual constraints of planar and elevation curvature fully consider the turning restrictions of the borehole in two spatial dimensions, which is more in line with the mechanical performance requirements of the drill rod in actual construction; the iterative optimization process realizes the automatic correction of the curve shape without manual intervention, which not only improves the efficiency of trajectory generation, but also ensures that the curve conforms to the engineering constraints throughout the process, reducing the risk of drill rod breakage and stuck drill during construction.

[0055] like Figure 3 As shown, in one embodiment, optionally, step S103 includes: Step S301: Obtain the preset threshold for the equal spacing of trajectory nodes.

[0056] The equal spacing threshold is a distance interval (such as 5 meters or 10 meters) between adjacent trajectory nodes along the trajectory generatrix, preset by the user according to the construction accuracy requirements. It is the core interval standard for node generation.

[0057] Step S302: Taking the starting point of the continuous trajectory generatrix as the initial sampling point, along the extension direction of the continuous trajectory generatrix, calculate the three-dimensional coordinates of each trajectory node in sequence according to the equal spacing distance threshold and spatial interpolation algorithm.

[0058] The initial sampling point is the starting position for generating trajectory nodes, that is, the starting point (opening point) of the continuous trajectory generatrix, which serves as the reference position for the first trajectory node.

[0059] The coordinate difference is the numerical difference (ΔX, ΔY, ΔZ) between two adjacent trajectory nodes in the three coordinate directions of X, Y, and Z. It is the basic data for calculating parameters such as tilt angle and azimuth.

[0060] Step S303: Calculate the corresponding hole depth, inclination angle, orientation, and curvature based on the coordinate difference.

[0061] In this step, the user-preset equidistant distance threshold (e.g., set to 5 meters) is first read to determine the spacing standard between adjacent nodes. The starting point (aperture point) of the trajectory generatrix is ​​taken as the first trajectory node (initial sampling point), and its three-dimensional coordinates are recorded. Subsequently, along the extension direction of the trajectory generatrix, the spatial position coordinates at a distance of 5 meters from the initial sampling point are calculated using a spatial interpolation algorithm (e.g., linear interpolation), which is taken as the second trajectory node. This process is repeated to calculate the three-dimensional coordinates of all subsequent equidistant nodes in sequence. For each node, the system calculates its ΔX, ΔY, and ΔZ with respect to the previous node, derives the hole depth, inclination angle, and orientation using geometric formulas, and calculates the curvature by fitting a local arc with the coordinates of three adjacent nodes. Finally, all parameters are integrated to form a node parameter table. The equidistant spacing threshold ensures uniform node distribution, facilitating guidance monitoring at fixed intervals during construction and avoiding data redundancy due to overly dense nodes or insufficient accuracy due to overly sparse nodes. The spatial interpolation algorithm enables automatic calculation of node coordinates, significantly improving node generation efficiency and reducing operation time by more than 90% compared to traditional manual calculation in Excel. Parameter derivation based on coordinate differences ensures that each parameter is directly related to the spatial position of the node, resulting in high data accuracy and providing a reliable basis for construction guidance.

[0062] In one embodiment, optionally, the method further includes: Export the parameter information as a parameter table; or The parameter information is stored in the attribute database of the three-dimensional spline curve.

[0063] The parameter table is a collection of trajectory node parameters presented in tabular form (such as Excel or CSV format), including fields such as node number, 3D coordinates, hole depth, inclination angle, azimuth, and curvature, facilitating manual viewing and editing. The attribute database is a structured database (such as Access or SQLite database) associated with the 3D spline curve, used to store the parameter information of the trajectory nodes, supporting data querying, modification, and retrieval.

[0064] In this step, two parameter information processing methods are provided for users to choose from. If users need to view or further edit parameters offline, they can trigger the parameter table export function. The system automatically organizes the parameters of all trajectory nodes into an Excel or CSV file according to preset fields (node ​​ID, X, Y, Z, hole depth, inclination angle, azimuth, curvature) and saves it to the user-specified path. If users need to associate parameters with the 3D model, they can choose to store them in the attribute database. The system binds the parameter information to the unique identifier of the 3D spline curve according to the node number and stores it in the model's built-in attribute database. When viewing the 3D curve later, clicking on any trajectory node will retrieve the corresponding parameter information in real time. The parameter table export meets the needs of scenarios such as offline analysis and report preparation, improving the flexibility of data use. The attribute database storage realizes the deep association between parameters and the 3D model, which facilitates trajectory review and parameter modification during the design process. At the same time, it provides a data foundation for the comparative analysis of subsequent construction data and design data, realizing closed-loop data management of the entire trajectory design process.

[0065] Figure 4 A block diagram of a directional borehole trajectory generation apparatus based on an integrated geological model according to an embodiment of this application is shown.

[0066] like Figure 4 As shown, in a second aspect, embodiments of this application provide a directional drilling trajectory generation device 40 based on a comprehensive geological model, comprising: The acquisition module 41 is used to select target points in the comprehensive geological model according to the received point selection instructions, and to acquire the three-dimensional coordinate information of each target point in the same spatial coordinate system, wherein the target points include the hole opening point, the key control point and the final hole target point. The drawing module 42 is used to draw a three-dimensional spline curve based on the three-dimensional coordinate information and using a mathematical algorithm for smoothing curves under maximum curvature constraints, so as to obtain a continuous trajectory generatrix that conforms to engineering constraints. The generation module 43 is used to generate trajectory nodes for directional drilling at equal intervals using the continuous trajectory generatrix as the only spatial path reference and through a spatial interpolation algorithm, and output the parameter information of each trajectory node.

[0067] In one embodiment, optionally, the integrated geological model is a high-precision integrated geological model formed by the fusion of multi-source data, including three-dimensional models of strata, coal seams, faults, collapse columns, tunnel engineering, goaf, water accumulation areas, anomaly areas, and metamorphic rocks.

[0068] In one embodiment, optionally, the parameter information of the trajectory node includes: hole depth, inclination angle, azimuth, curvature, and three-dimensional coordinates.

[0069] In one embodiment, optionally, during the selection of target points: the hole opening point is selected in the underground roadway or drilling chamber model of the integrated geological model; the key control point is picked at the top and bottom interface of the target coal seam, the top and bottom interface of the water-bearing strata, or the fault plane in the integrated geological model; the final hole target point is picked on the coal and rock strata, fault, collapse column, old roadway, goaf, water accumulation area, abnormal area, or scorched rock model of the integrated geological model.

[0070] In one embodiment, optionally, the drawing module includes: The calling unit is used to call the preset mathematical algorithm for smoothing curves, using the three-dimensional coordinate information of each target point as constraint nodes. The optimization unit is used to iteratively optimize the spatial shape of the curve by using the maximum curvature threshold as a trajectory compliance constraint, so that the generated three-dimensional spline curve satisfies that both the planar projection curvature and the elevation projection curvature do not exceed the maximum curvature threshold.

[0071] In one embodiment, optionally, the generation module includes: The acquisition unit is used to acquire the preset equal-interval distance threshold of trajectory nodes; The first calculation unit is used to calculate the three-dimensional coordinates of each trajectory node sequentially along the extension direction of the continuous trajectory generatrix, taking the starting point of the continuous trajectory generatrix as the initial sampling point, based on the equal spacing distance threshold and the spatial interpolation algorithm. The second calculation unit is used to calculate the corresponding hole depth, inclination angle, azimuth, and curvature based on the coordinate difference.

[0072] In one embodiment, optionally, the apparatus further includes: The export module is used to export the parameter information into a parameter table; or A storage module is used to store the parameter information in the attribute database of the three-dimensional spline curve.

[0073] Thirdly, a computer device is provided, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the steps of the above-described method for generating directional borehole trajectories based on a comprehensive geological model.

[0074] Fourthly, a computer-readable storage medium is provided, which stores a computer program that, when executed by a processor, implements the steps of the above-described method for generating directional borehole trajectories based on a comprehensive geological model.

[0075] It should be noted that those skilled in the art will understand that, for the sake of convenience and brevity, the specific working processes of the directional drilling trajectory generation device and its modules based on the comprehensive geological model described above can be referred to the corresponding processes in the aforementioned embodiments of the directional drilling trajectory generation method based on the comprehensive geological model, and will not be repeated here.

[0076] It should be noted that those skilled in the art will understand that, for the sake of convenience and brevity, the specific working process of the model training device and each module described above can be referred to the corresponding process in the aforementioned embodiment of the directional drilling trajectory generation method based on a comprehensive geological model, and will not be repeated here.

[0077] The aforementioned directional drilling trajectory generation device based on a comprehensive geological model can be implemented as a computer program, which can be used in, for example... Figure 5 It runs on the computer device shown.

[0078] Figure 5 A block diagram of a computer device according to one embodiment of this application is shown.

[0079] See Figure 5 The computer device includes a processor, memory, and network interface connected via a system bus, wherein the memory may include storage media and internal memory.

[0080] The storage medium may store an operating system and a computer program. The computer program includes program instructions that, when executed, cause the processor to perform any of the multi-source data-based directional borehole trajectory generation methods provided in the embodiments of this application.

[0081] The processor provides computing and control capabilities, supporting the operation of the entire computer device.

[0082] The internal memory provides an environment for the execution of a computer program stored in the storage medium. When executed by a processor, this program enables the processor to perform any method for generating directional borehole trajectories based on a comprehensive geological model using multi-source data. The storage medium can be non-volatile or volatile.

[0083] This network interface is used for network communication, such as sending assigned tasks. Those skilled in the art will understand that... Figure 5 The structure shown is merely a block diagram of a portion of the structure related to the present application and does not constitute a limitation on the computer device to which the present application is applied. Specific computer devices may include more or fewer components than those shown in the figure, or combine certain components, or have different component arrangements.

[0084] It should be understood that the processor can be a Central Processing Unit (CPU), but it can also be other general-purpose processors, digital signal processors (DSPs), application-specific integrated circuits (ASICs), field-programmable gate arrays (FPGAs), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. Among these, a general-purpose processor can be a microprocessor or any conventional processor.

[0085] In addition, embodiments of this application provide a computer-readable storage medium storing computer-executable instructions for performing the steps of the method in the first aspect embodiment.

[0086] It should be noted that the functions or steps that can be implemented by the computer-readable storage medium or electronic device described above can be referred to the relevant descriptions in the foregoing method embodiments. To avoid repetition, they will not be described one by one here.

[0087] It should be understood that the term "and / or" used in this article is merely a description of the relationship between related objects, indicating that three relationships can exist. For example, A and / or B can represent: A existing alone, A and B existing simultaneously, and B existing alone. Additionally, the character " / " in this article generally indicates that the preceding and following related objects have an "or" relationship.

[0088] It should be understood that although the terms "first," "second," etc., may be used to describe the setting units in the embodiments of this application, these setting units should not be limited to these terms. These terms are only used to distinguish the setting units from each other. For example, without departing from the scope of the embodiments of this application, the first setting unit may also be referred to as the second setting unit, and similarly, the second setting unit may also be referred to as the first setting unit.

[0089] Depending on the context, the word "if" as used here can be interpreted as "when," "when," "in response to determination," or "in response to detection." Similarly, depending on the context, the phrase "if determination" or "if detection (of the stated condition or event)" can be interpreted as "when determination," "in response to determination," "when detection (of the stated condition or event)," or "in response to detection (of the stated condition or event)."

[0090] In the several embodiments provided in this application, it should be understood that the disclosed systems, apparatuses, and methods can be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative; for instance, the division of units is only a logical functional division, and in actual implementation, there may be other division methods. For example, multiple units or components may be combined or integrated into another system, or some features may be ignored or not executed. Furthermore, the coupling or direct coupling or communication connection shown or discussed may be through some interfaces; the indirect coupling or communication connection between apparatuses or units may be electrical, mechanical, or other forms.

[0091] Furthermore, the functional units in the various embodiments of this application can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit. The integrated unit can be implemented in hardware or in a combination of hardware and software functional units.

[0092] Those skilled in the art will understand that all or part of the processes in the methods of the above embodiments can be implemented by a computer program instructing related hardware. The computer program can be stored in a non-volatile computer-readable storage medium. When executed, the computer program can include the processes of the embodiments of the above methods. Any references to memory, storage, databases, or other media used in the embodiments provided in this application can include non-volatile and / or volatile memory. Non-volatile memory may include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), or flash memory. Volatile memory may include random access memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), dual data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link DRAM (SLDRAM), RAMbus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), etc.

[0093] The above-described embodiments are only used to illustrate the technical solutions of the present invention, and are not intended to limit it. Although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features. Such modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention, and should all be included within the protection scope of the present invention.

Claims

1. A method for generating directional borehole trajectories based on a comprehensive geological model, characterized in that, The method includes: According to the received point selection instruction, target points are selected in the comprehensive geological model, and the three-dimensional coordinate information of each target point in the same spatial coordinate system is obtained. The target points include the hole opening point, key control point and final hole target point. Based on the three-dimensional coordinate information, a three-dimensional spline curve is drawn using a mathematical algorithm for smoothing curves under the maximum curvature constraint, so as to obtain a continuous trajectory generatrix that conforms to engineering constraints. Using the continuous trajectory generatrix as the sole spatial path reference, trajectory nodes for directional drilling are generated at equal intervals using a spatial interpolation algorithm, and parameter information for each trajectory node is output.

2. The method according to claim 1, characterized in that, The comprehensive geological model is a high-precision comprehensive geological model formed by the fusion of multi-source data, including three-dimensional models of strata, coal seams, faults, collapse columns, tunnel engineering, goaf, water accumulation areas, anomaly areas, and metamorphic rocks.

3. The method according to claim 1, characterized in that, The parameters of the trajectory nodes include: hole depth, inclination angle, azimuth, curvature, and three-dimensional coordinates.

4. The method according to claim 1, characterized in that, During the selection of target points: the hole opening point is selected in the underground roadway or drilling chamber model of the integrated geological model; the key control point is picked at the top and bottom interface of the target coal seam, the top and bottom interface of the water-bearing strata, or the fault plane in the integrated geological model; the final hole target point is picked on the coal and rock strata, fault, collapse column, old roadway, goaf, water accumulation area, abnormal area, or scorched rock model of the integrated geological model.

5. The method according to claim 1, characterized in that, Based on the aforementioned three-dimensional coordinate information, a three-dimensional spline curve is drawn using a mathematical algorithm for smoothing curves under maximum curvature constraints, including: Using the three-dimensional coordinate information of each target point as constraint nodes, a preset mathematical algorithm for smoothing curves is invoked. Using the maximum curvature threshold as a trajectory compliance constraint, the spatial shape of the curve is iteratively optimized to ensure that the generated three-dimensional spline curve satisfies that both the planar projection curvature and the elevation projection curvature do not exceed the maximum curvature threshold.

6. The method according to claim 1, characterized in that, Using the continuous trajectory generatrix as the unique spatial path reference, trajectory nodes for directional drilling are generated at equal intervals using a spatial interpolation algorithm, and the parameter information of each trajectory node is output, including: Obtain the preset threshold for the equal spacing between trajectory nodes; Taking the starting point of the continuous trajectory generatrix as the initial sampling point, along the extension direction of the continuous trajectory generatrix, the three-dimensional coordinates of each trajectory node are calculated sequentially according to the equal spacing distance threshold and the spatial interpolation algorithm; The corresponding hole depth, inclination angle, azimuth, and curvature are calculated based on the coordinate difference.

7. The method according to claim 1, characterized in that, The method further includes: Export the parameter information as a parameter table; or The parameter information is stored in the attribute database of the three-dimensional spline curve.

8. A directional drilling trajectory generation device based on a comprehensive geological model, characterized in that, include: The acquisition module is used to select target points in the comprehensive geological model according to the received point selection instructions, and to acquire the three-dimensional coordinate information of each target point in the same spatial coordinate system. The target points include the hole opening point, key control point and final hole target point. The drawing module is used to draw a three-dimensional spline curve based on the three-dimensional coordinate information and using a mathematical algorithm for smoothing curves under maximum curvature constraints, so as to obtain a continuous trajectory generatrix that conforms to engineering constraints. The generation module is used to generate trajectory nodes for directional drilling at equal intervals using the continuous trajectory generatrix as the only spatial path reference and a spatial interpolation algorithm, and outputs the parameter information of each trajectory node.

9. A computer device, characterized in that, include: At least one processor; And, a memory communicatively connected to the at least one processor; The memory stores instructions executable by the at least one processor, the instructions being configured to perform the method according to any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that, The device stores computer-executable instructions for performing the method as described in any one of claims 1 to 7.

Images