A borehole-based geological longitudinal section generation method, device and electronic equipment

Abstract

The application discloses a geological longitudinal section generation method and device based on drilling and electronic equipment, and the method comprises the following steps: obtaining original drilling data, screening target drilling data for generating a geological longitudinal section; performing spatial clustering retrieval analysis on the target drilling data to obtain a plurality of drilling subsets; determining the spatial position relationship between each drilling subset and a preset longitudinal section generation path; generating segmented geological profiles according to each drilling subset based on the spatial position relationship and a preset terrain constraint condition; and fusing the segmented geological profiles to obtain a full-line geological longitudinal section. The drilling subsets are obtained by screening multi-dimensional drilling data, the segmented geological profiles are determined according to the drilling subsets, and the drilling distribution characteristics can be clearly displayed; the segmented geological profiles are spliced and fused, a reliable full-line geological longitudinal section is generated, and a practical analysis tool is provided for geological investigation and engineering investigation of long-line large projects.

Description

Technical Field

[0001] This invention relates to the field of geological exploration technology, and specifically to a method, apparatus, electronic device, and computer-readable storage medium for generating geological longitudinal profiles based on boreholes. Background Technology

[0002] Geological longitudinal sections / geological profiles are common output maps in geological surveys and engineering exploration. Traditional methods for generating geological longitudinal sections mainly rely on manual interactive creation, which is labor-intensive. With the development of geological informatization, rapidly obtaining geological longitudinal sections and geological profiles through information technology has become a trend.

[0003] Existing information technology methods mainly include the following two approaches: The first is to construct a three-dimensional geological model and obtain geological profile maps through plotting cross-sections. The quality of the geological profile maps obtained using this method depends heavily on the model construction and often suffers from difficulty in controlling accuracy and quality. The second approach involves selecting boreholes along the profile map trajectory lines to obtain geological profile maps by connecting stratigraphic layers. This method often fails to account for topographic constraints and is less effective when the profile trajectory lines do not pass through borehole points. In long-distance pipeline projects, boreholes are unevenly distributed and exhibit a zonal pattern, making it difficult to construct high-quality three-dimensional geological models, and generating a full-line geological profile from selected boreholes is also challenging. Furthermore, in traditional engineering survey work, the generation of geological longitudinal sections for a linear project often utilizes a small number of reference boreholes and boreholes obtained from project surveys, resulting in incomplete utilization of existing borehole data from various units.

[0004] Therefore, there is an urgent need to propose a borehole-based geological profile generation method to solve the problems of difficulty in generating geological profiles and insufficient display of local borehole distribution characteristics when existing geological profile generation methods are applied to long-distance railway projects. Summary of the Invention

[0005] This invention provides a method, apparatus, electronic device, and computer-readable storage medium for generating geological longitudinal profiles based on boreholes, in order to solve the technical problems of low reliability of the generated geological longitudinal profiles when existing geological longitudinal profile generation methods are applied to long-distance railway projects, due to difficulties in selecting boreholes, unclear display of local borehole distribution characteristics, and other issues.

[0006] To address the above problems, this invention provides a method for generating geological longitudinal profiles based on boreholes, comprising:

[0007] Obtain raw borehole data, and filter out target borehole data from the raw borehole data to generate geological longitudinal profiles;

[0008] Spatial clustering retrieval analysis was performed on the target borehole data to obtain multiple borehole subsets;

[0009] Determine the spatial positional relationship between each of the aforementioned borehole subsets and the preset longitudinal profile generation path;

[0010] Based on the spatial location relationship and preset terrain constraints, segmented geological profiles are generated according to each of the borehole subsets;

[0011] The segmented geological profiles are merged and constructed to obtain the geological longitudinal profile of the entire line.

[0012] Furthermore, spatial clustering retrieval analysis is performed on the target borehole data to obtain multiple data subsets, including:

[0013] Based on a preset clustering retrieval radius, a preset clustering analysis algorithm is used to retrieve the target borehole data, resulting in multiple borehole subsets.

[0014] The number of boreholes in each of the borehole subsets is determined. When the number of boreholes in a borehole subset is greater than the number of boreholes in a preset subset, the outer boundary of each of the borehole subsets is determined, and the distribution characteristics of each of the borehole subsets are obtained based on the outer boundary.

[0015] Furthermore, the distribution characteristics of each of the borehole subsets are obtained based on the outer boundary, including:

[0016] When the outer boundary is a closed boundary, it is determined that the borehole subset is distributed in a planar manner, and after topologically constructing the outer boundary, the planar range of the borehole subset is established.

[0017] When the outer boundary is not closed, the borehole subset is determined to be linearly distributed.

[0018] Furthermore, based on the aforementioned spatial relationships and preset terrain constraints, segmented geological profiles are generated according to each of the borehole subsets, including:

[0019] When a subset of boreholes distributed in a planar pattern intersects with the preset longitudinal profile generation path, a local three-dimensional geological structure model is established based on the outer boundary of the borehole subset and the preset terrain constraints.

[0020] Based on the local three-dimensional geological structure model, segmented geological profiles are generated by using the intersection lines of the preset longitudinal profile generation path and the borehole subset.

[0021] Furthermore, based on the aforementioned spatial relationships and preset terrain constraints, generating segmented geological profiles according to each of the borehole subsets also includes:

[0022] When the area-distributed subset of boreholes is tangent to or separate from the preset longitudinal profile generation path, the boreholes in the subset of boreholes are determined to be within a preset distance threshold.

[0023] Based on preset terrain constraints, a geological cross section is generated along the direction perpendicular to the preset longitudinal section generation path of the borehole.

[0024] Determine the virtual borehole at the intersection of the geological cross section and the path generated by the preset longitudinal section;

[0025] When the number of virtual boreholes is greater than the preset number of virtual boreholes, the virtual boreholes are connected sequentially based on the preset terrain constraints to generate segmented geological profiles.

[0026] Furthermore, based on preset terrain constraints, a geological cross-section is generated along the direction perpendicular to the preset longitudinal section production path of the borehole, including:

[0027] Determine the layering information and geological cross-section generation path of the borehole; wherein, the geological cross-section generation path is centered on the borehole trajectory line, extended by a preset distance threshold, and extended in the opposite direction by the straight line formed by the shortest distance between the borehole and the preset longitudinal section production path.

[0028] Based on the layered information and preset terrain constraints, segmented geological profiles are generated along the geological cross-section generation path.

[0029] Furthermore, the segmented geological profiles are merged and constructed to obtain the entire geological longitudinal profile, including:

[0030] Based on the preset terrain constraints, the sections between the segmented geological profiles are supplemented by drilling through layers, and the segmented profiles are extended to the starting point of the preset geological longitudinal section generation path in a manner parallel to the terrain.

[0031] The geological boundaries and strata of the segmented geological profiles are spliced ​​and merged to obtain the entire geological longitudinal profile.

[0032] The present invention also provides a borehole-based geological longitudinal profile generation device, comprising:

[0033] The data acquisition module is used to acquire raw borehole data and filter out target borehole data for generating geological longitudinal sections from the raw borehole data.

[0034] The clustering retrieval module is used to perform spatial clustering retrieval analysis on the target borehole data to obtain multiple borehole subsets;

[0035] The analysis module is used to determine the spatial positional relationship between each of the borehole subsets and the preset longitudinal profile generation path;

[0036] The profile generation module is used to generate segmented geological profiles based on the spatial location relationship and preset terrain constraints, according to each of the borehole subsets.

[0037] The longitudinal profile output module is used to fuse and construct the segmented geological profiles to obtain the entire geological longitudinal profile.

[0038] The present invention also provides an electronic device, including a processor and a memory, wherein the memory stores a computer program, and when the computer program is executed by the processor, it implements a method for generating geological longitudinal sections based on boreholes as described in any of the above technical solutions.

[0039] The present invention also provides a computer-readable storage medium storing a computer program, which, when executed by a processor, implements a method for generating geological longitudinal sections based on boreholes as described in any of the above technical solutions.

[0040] Compared with existing technologies, the beneficial effects of this invention include: First, selecting target borehole data for generating geological longitudinal profiles from the original borehole data; second, clustering the target borehole data to obtain borehole subsets and determining the spatial positional relationship between each borehole subset and the preset longitudinal profile generation path; third, generating segmented geological profiles based on the spatial positional relationship and preset terrain constraints according to each borehole subset; and finally, fusing the segmented geological profiles to obtain the full-line geological longitudinal profile. This invention, by filtering and analyzing multi-dimensional borehole data to obtain target borehole data and borehole subsets, and determining segmented geological profiles based on the borehole subsets, can clearly display the local distribution characteristics of boreholes; after splicing and fusing the segmented geological profiles to obtain the full-line geological longitudinal profile, it can generate reliable geological longitudinal profiles suitable for long-distance large-scale projects, providing an effective automated tool for geological surveys and engineering exploration. Attached Figure Description

[0041] Figure 1 A schematic flowchart of a method for generating geological longitudinal profiles based on boreholes, provided for an embodiment of the present invention;

[0042] Figure 2 This is a schematic diagram of the borehole clustering analysis process provided in an embodiment of the present invention;

[0043] Figure 3 A schematic diagram of the process for generating segmented geological profiles provided in an embodiment of the present invention;

[0044] Figure 4 A schematic diagram illustrating the process of constructing a fusion of geological longitudinal sections along the entire line, provided in an embodiment of the present invention;

[0045] Figure 5A schematic diagram of an embodiment of the borehole-based geological longitudinal profile generation device provided by the present invention;

[0046] Figure 6 This is a schematic diagram of an embodiment of an electronic device provided by the present invention. Detailed Implementation

[0047] Preferred embodiments of the present invention will now be described in detail with reference to the accompanying drawings, which form part of this application and are used together with the embodiments of the present invention to illustrate the principles of the present invention, but are not intended to limit the scope of the present invention.

[0048] This invention provides a method for generating geological longitudinal profiles based on boreholes, mainly applied to geological surveys and engineering explorations of long-distance railway lines. Figure 1 As shown, Figure 1 This is a flowchart illustrating the method for generating geological longitudinal profiles based on boreholes, the method comprising:

[0049] Step S101: Obtain the original borehole data and filter out the target borehole data for generating the geological longitudinal profile from the original borehole data;

[0050] Step S102: Perform spatial clustering retrieval analysis on the target borehole data to obtain multiple borehole subsets;

[0051] Step S103: Determine the spatial positional relationship between each of the aforementioned borehole subsets and the preset longitudinal profile generation path;

[0052] Step S104: Based on the spatial location relationship and preset terrain constraints, generate segmented geological profiles according to each of the borehole subsets;

[0053] Step S105: The segmented geological profiles are merged and constructed to obtain the entire geological longitudinal profile.

[0054] The borehole-based geological longitudinal profile generation method provided in this embodiment first selects target borehole data for generating the geological longitudinal profile from the original borehole data; second, clusters the target borehole data to obtain borehole subsets and determines the spatial positional relationship between each borehole subset and a preset longitudinal profile generation path; third, based on the spatial positional relationship and preset terrain constraints, generates segmented geological profiles according to each borehole subset; finally, merges the segmented geological profiles to obtain the full-line geological longitudinal profile. This invention, by filtering and analyzing multi-dimensional borehole data to obtain target borehole data and borehole subsets, and determining segmented geological profiles based on the borehole subsets, can clearly display the local distribution characteristics of boreholes; after splicing and merging the segmented geological profiles to obtain the full-line geological longitudinal profile, it can generate reliable geological longitudinal profiles, suitable for long-distance large-scale projects, and provides an effective automated tool for geological surveys and engineering exploration.

[0055] As a specific embodiment, in step S101, the raw borehole data is obtained from a data storage server, which can be a local server or a remote server. Specifically, the user obtains the raw borehole data in the following two ways:

[0056] (1) The user selects the drilling data files stored in the local Access MDB and Excel and parses and converts them into memory-level drilling data;

[0057] (2) Users can remotely access the database server using their username and password to obtain drilling data from the server.

[0058] It should be noted that before accessing the borehole database, users should ensure that the borehole data has been standardized and that at least the following conditions are met: (1) the stratigraphic layer information is complete; (2) the borehole elevation or height information is available; and (3) the latitude and longitude coordinates and the distance between latitude and longitude coordinates are complete. For the mileage offset coordinates of the line project, the mileage offset coordinates should be converted to the distance between latitude and longitude coordinates and the latitude and longitude coordinates.

[0059] Furthermore, after a user successfully connects to the borehole database, the borehole location information can be displayed to the user in a graphical visualization format. Overlaying with a GIS geographic base map is supported when necessary. This provides users with borehole data more intuitively and makes the interface more user-friendly.

[0060] As a specific example, the user filters the target borehole data for generating the geological profile from the original borehole data, including spatial query filtering and conditional query filtering;

[0061] The steps for filtering borehole data using spatial queries include: obtaining the intersection topology of the input spatial data range file, selecting using a rectangular bounding box, and obtaining data through point and line buffer analysis, among other methods. The steps for filtering based on conditions include: filtering borehole data based on conditions such as the input of the linear engineering project ID and the linear engineering scheme name.

[0062] After users obtain and filter target borehole data using spatial or conditional queries, the target data will also be displayed on the visualization interface for easy understanding and subsequent selection.

[0063] If the user does not perform borehole filtering, all existing borehole data will be used by default. Therefore, the purpose of borehole filtering is to reduce the computational complexity of subsequent steps.

[0064] In a preferred embodiment, in step S102, spatial clustering retrieval analysis is performed on the target borehole data to obtain multiple data subsets, including:

[0065] Based on a preset clustering retrieval radius, a preset clustering analysis algorithm is used to retrieve the target borehole data, resulting in multiple borehole subsets.

[0066] The number of boreholes in each of the borehole subsets is determined. When the number of boreholes in a borehole subset is greater than the number of boreholes in a preset subset, the outer boundary of each of the borehole subsets is determined, and the distribution characteristics of each of the borehole subsets are obtained based on the outer boundary.

[0067] In one specific embodiment, the preset clustering retrieval radius can be customized by the user according to their needs. For example, the clustering retrieval radius can be set to 20m.

[0068] In actual processing, each target borehole data corresponds to a borehole ID. The system automatically sorts the borehole IDs and, based on the user-defined search radius, starts with the borehole with the smallest sub-ID. The DBSCAN algorithm (Density-Based Spatial Clustering of Applications with Noise) is used to perform clustering retrieval calculations. The user obtains and stores the subset of boreholes obtained from the borehole clustering retrieval.

[0069] It should be noted that if no new boreholes are found based on the preset clustering retrieval radius, a subset of borehole data for this round of retrieval is established. Simultaneously, it is further determined whether all borehole IDs have been completely traversed.

[0070] If all borehole IDs in the borehole database have not been completely traversed, then obtain the smallest ID of the remaining boreholes to carry out the next round of DBSCAN retrieval calculation;

[0071] If all borehole IDs in the borehole database have been completely traversed, the search calculation terminates. After terminating the search calculation, the system stores the information of the subset of boreholes that have been retrieved.

[0072] In a specific embodiment, the number of holes in the preset drilling subset is 3. If the number of holes in the drilling subset is greater than 3, the outer boundary of the drilling subset is obtained by a preset algorithm. If the number of holes in the drilling subset is less than or equal to 3, the drilling subset is marked as scattered holes, the boundary range is not calculated, and these scattered holes are processed later.

[0073] like Figure 2 As shown, Figure 2 The overall process of the above borehole clustering analysis is shown.

[0074] In a preferred embodiment, the distribution characteristics of each of the borehole subsets are obtained based on the outer boundary, including:

[0075] When the outer boundary is a closed boundary, it is determined that the borehole subset is distributed in a planar manner, and after topologically constructing the outer boundary, the planar range of the borehole subset is established.

[0076] When the outer boundary is not closed, the borehole subset is determined to be linearly distributed.

[0077] As a specific implementation, the outer boundary of the borehole subset can be obtained using the Alpha Shapes algorithm. The outer boundary of each subset is calculated based on the planar coordinates of the boreholes, and the outer boundary may take the form of a surface or a line.

[0078] As a specific embodiment, in step S103, the preset longitudinal profile generation path is obtained by user selection or setting, and may specifically include the following methods:

[0079] (1) Import path files, such as .shp line files, .kml spatial data files, etc.; (2) The user manually enters the path on the human-computer interaction interface; (3) If the user has already created a line database, select a line database from the line database list and use it as the generated path.

[0080] As a specific embodiment, the method for determining the spatial positional relationship between each borehole subset and the preset longitudinal profile generation path is as follows: An intersection operation is performed on the outer boundary of the borehole subset and the preset longitudinal profile generation path. Based on the result of the intersection operation, the relative positional relationship between the route path and each borehole subset is determined. The main positional relationships include: (1) line-surface intersection, meaning the borehole subset is distributed in a surface shape and intersects with the route path; (2) line-line intersection, meaning the borehole subset is distributed in a linear shape and intersects with the route path; (3) line-surface and line-line separation, meaning the outer boundary of the borehole subset has no intersection with the route path. Geological profiles can be generated and obtained in segments based on the relative positional relationship between the route path and the borehole subset, combined with terrain constraints.

[0081] like Figure 3 As shown, Figure 3 A flowchart illustrating the method for generating segmented geological profiles is provided. It includes the following steps:

[0082] Step S301: Perform an intersection operation on the outer boundary of the route path and the borehole subset;

[0083] Step S302: Determine the relative positional relationship between the borehole subset and the path;

[0084] Step S303: Generate segmented geological profiles by combining preset terrain constraints.

[0085] In a preferred embodiment, step S104 involves generating segmented geological profiles based on the spatial relationship and preset terrain constraints, according to each of the borehole subsets, including:

[0086] When a subset of boreholes distributed in a planar pattern intersects with the preset longitudinal profile generation path, a local three-dimensional geological structure model is established based on the outer boundary of the borehole subset and the preset terrain constraints.

[0087] Based on the local three-dimensional geological structure model, segmented geological profiles are generated by using the intersection lines of the preset longitudinal profile generation path and the borehole subset.

[0088] As a preferred embodiment, based on the spatial relationship and preset terrain constraints, generating segmented geological profiles according to each of the borehole subsets further includes:

[0089] When the area-distributed subset of boreholes is tangent to or separate from the preset longitudinal profile generation path, the boreholes in the subset of boreholes are determined to be within a preset distance threshold.

[0090] Based on preset terrain constraints, a geological cross section is generated along the direction perpendicular to the preset longitudinal section generation path of the borehole.

[0091] Determine the virtual borehole at the intersection of the geological cross section and the path generated by the preset longitudinal section;

[0092] When the number of virtual boreholes is greater than the preset number of virtual boreholes, the virtual boreholes are connected sequentially based on the preset terrain constraints to generate segmented geological profiles.

[0093] As a specific embodiment, the preset terrain constraints are set by the user. The user obtains the preset terrain constraints (hereinafter referred to as DEM terrain constraints) by inputting a DEM (Digital Elevation Model). The preset distance threshold is the clustering retrieval radius in the above technical solution by default, and the preset distance threshold represents the maximum distance threshold between the borehole and the route path.

[0094] Based on the above analysis, the spatial relationship between the borehole subset and the preset longitudinal profile generation path can be divided into four types: 1) the path intersects with the borehole subset that is distributed in a planar pattern; 2) the path is separate from or tangent to the borehole subset that is distributed in a planar pattern; 3) the path intersects with the borehole subset that is distributed in a linear pattern; 4) the path is separate from or tangent to the borehole subset that is distributed in a linear pattern. The handling methods for these four cases are explained below.

[0095] Scenario 1:

[0096] If the route intersects with a subset of boreholes that are distributed in a planar manner, a local three-dimensional geological structure model is established using the boreholes of that subset and in combination with DEM terrain constraints and the outer boundary of the borehole subset.

[0097] Based on the constructed three-dimensional geological structure model, a cross-sectional profile is generated by using the intersection segments of the route path and the borehole subset. This cross-sectional profile is a segmented geological profile.

[0098] Scenario 2:

[0099] If the route path is separate from or tangent to a subset of boreholes that are distributed in a planar manner, then based on a preset distance threshold, the measured boreholes within the distance threshold range of that subset are selected.

[0100] If the screening result is empty, the calculation of the borehole subset is terminated; if the screening result is not empty, geological cross sections are generated for the selected boreholes along the direction perpendicular to the route path based on the DEM terrain constraints.

[0101] Obtain the intersection of the route and the geological cross-section, and use the geological cross-section map to obtain the virtual borehole at the intersection;

[0102] If the number of virtual boreholes obtained by the borehole subset is greater than or equal to 2, then the virtual boreholes are connected sequentially in combination with the DEM terrain constraints to generate segmented geological profiles; if the number of virtual boreholes obtained by the borehole subset is only 1, then the virtual borehole is retained and processed in subsequent steps.

[0103] The process of generating geological cross-sections based on borehole and DEM topography includes:

[0104] Obtain the layered information of the borehole, the cross-section generation path, and the terrain constraints; the geological cross-section generation path is a straight line formed by the borehole trajectory line as the center line, the distance threshold as the extension radius, and the shortest distance between the borehole and the route path as the extension direction.

[0105] Based on the known layers and thicknesses of the borehole, a geological cross-section map is generated along the cross-section generation path, roughly parallel to the terrain.

[0106] Scenario 3:

[0107] If the route intersects with a subset of boreholes that are distributed linearly, then based on the set distance threshold, the measured boreholes within the distance threshold range of that subset are selected.

[0108] Based on the DEM terrain constraint, geological cross sections were generated for the boreholes along the vertical direction of the route path, and the intersection points of the route path and the geological cross sections were obtained.

[0109] The virtual boreholes at the intersection point are obtained using the geological cross-section map. Combined with the DEM terrain constraints, the virtual boreholes are connected sequentially to generate segmented geological profiles.

[0110] Scenario 4:

[0111] If the route path is separate from or tangent to a linearly distributed subset of boreholes, the processing method for when the route path is separate from or tangent to a planarly distributed subset of boreholes can be referenced to obtain segmented geological profiles or virtual boreholes to be used on the route path.

[0112] Through the above processing, the details of the segmented geological profile can be enriched, and the local distribution characteristics of the borehole can be clearly displayed by combining the DEM topographic constraints.

[0113] In a preferred embodiment, in step S105, the segmented geological profiles are fused and constructed to obtain a full-line geological longitudinal profile, including:

[0114] Based on the preset terrain constraints, the sections between the segmented geological profiles are supplemented by drilling through layers, and the segmented profiles are extended to the starting point of the preset geological longitudinal section generation path in a manner parallel to the terrain.

[0115] The geological boundaries and strata of the segmented geological profiles are spliced ​​and merged to obtain the entire geological longitudinal profile.

[0116] As a specific example, such as Figure 4 As shown, Figure 4 This is a flowchart illustrating the process of constructing a fusion of geological longitudinal sections along the entire line. The specific steps involved in this process include:

[0117] Step S401: Obtain segmented geological profiles and virtual boreholes at the start and end points;

[0118] Step S402: Perform calculations on the scattered holes according to the method in Case 2 to obtain the virtual holes on the line path;

[0119] Step S403: Summarize all virtual boreholes retained during the above processing;

[0120] Step S404: Combine the DEM terrain constraints to automatically complete the segmented geological profiles: use boreholes to connect layers to supplement the profiles between the segmented geological profiles; based on the DEM terrain constraints, extend the segmented profiles at both ends to the starting point of the route path by using a method that is basically parallel to the terrain.

[0121] Step S405: Automatically stitch and merge all segmented geological profiles. The main elements of stitching and merging are geological boundaries and ground planes. At the same time, redundant elements (such as collinearity and common points) are removed to construct the entire geological longitudinal profile.

[0122] This embodiment also provides a geological longitudinal profile generation device based on boreholes, such as... Figure 5 As shown, the borehole-based geological profile generation device 500 includes:

[0123] The data acquisition module 501 is used to acquire raw borehole data and filter out target borehole data for generating geological longitudinal profiles from the raw borehole data.

[0124] Clustering retrieval module 502 is used to perform spatial clustering retrieval analysis on the target borehole data to obtain multiple borehole subsets;

[0125] Analysis module 503 is used to determine the spatial positional relationship between each of the borehole subsets and the preset longitudinal profile generation path;

[0126] The profile generation module 504 is used to generate segmented geological profiles based on the spatial location relationship and preset terrain constraints, according to each of the borehole subsets.

[0127] The longitudinal profile output module 505 is used to fuse and construct the segmented geological profiles to obtain the geological longitudinal profile of the entire line.

[0128] like Figure 6 As shown in the above-described method for generating geological longitudinal profiles based on boreholes, this invention also provides an electronic device 600, which can be a mobile terminal, desktop computer, laptop, handheld computer, server, or other computing device. The electronic device includes a processor 601, a memory 602, and a display 603.

[0129] In some embodiments, memory 602 may be an internal storage unit of a computer device, such as a hard disk or memory. In other embodiments, memory 602 may be an external storage device of a computer device, such as a plug-in hard disk, smart media card (SMC), secure digital card (SD), flash card, etc. Further, memory 602 may include both internal and external storage units of the computer device. Memory 602 is used to store application software and various types of data installed on the computer device, such as program code for installing the computer device. Memory 602 may also be used to temporarily store data that has been output or will be output. In one embodiment, memory 602 stores a borehole-based geological longitudinal section generation method program 604, which can be executed by processor 601 to implement a borehole-based geological longitudinal section generation method according to various embodiments of the present invention.

[0130] In some embodiments, processor 601 may be a central processing unit (CPU), a microprocessor, or other data processing chip, used to run program code stored in memory 602 or process data, such as executing a program for generating geological longitudinal profiles based on boreholes.

[0131] In some embodiments, display 603 may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, or an OLED (Organic Light-Emitting Diode) touchscreen. Display 603 is used to display information on the computer device and to display a visual user interface. Components 601-603 of the computer device communicate with each other via a system bus.

[0132] This embodiment also provides a computer-readable storage medium storing a computer program. When the computer program is executed by a processor, it implements the borehole-based geological longitudinal profile generation method described in any of the above technical solutions.

[0133] The computer-readable storage medium and computing device provided in the above embodiments of the present invention can be implemented with reference to the content specifically described in the above-described method for generating a borehole-based geological longitudinal profile, and have similar beneficial effects to the above-described method for generating a borehole-based geological longitudinal profile, which will not be repeated here.

[0134] The present invention discloses a method, apparatus, electronic device, and computer-readable storage medium for generating geological longitudinal profiles based on boreholes. First, target borehole data for generating geological longitudinal profiles is selected from the original borehole data. Second, the target borehole data is clustered to obtain borehole subsets, and the spatial positional relationship between each borehole subset and a preset longitudinal profile generation path is determined. Third, based on the spatial positional relationship and preset terrain constraints, segmented geological profiles are generated according to each borehole subset. Finally, the segmented geological profiles are fused and constructed to obtain the entire geological longitudinal profile.

[0135] This invention filters and analyzes multidimensional borehole data to obtain target borehole data and borehole subsets. Based on the borehole subsets, segmented geological profiles are determined, which can clearly show the local distribution characteristics of boreholes. After splicing and merging the segmented geological profiles, a full-line geological longitudinal profile is obtained. The generated geological longitudinal profile is reliable and suitable for long-distance large-scale projects, providing an effective automated tool for geological surveys and engineering exploration.

[0136] The above description is only a preferred embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Any changes or substitutions that can be easily conceived by those skilled in the art within the scope of the technology disclosed in the present invention should be included within the scope of protection of the present invention.

Claims

1. A method for generating geological longitudinal profiles based on boreholes, characterized in that, include; Obtain raw borehole data, and filter out target borehole data from the raw borehole data to generate geological longitudinal profiles; Spatial clustering retrieval analysis was performed on the target borehole data to obtain multiple borehole subsets; Determine the spatial positional relationship between each of the aforementioned borehole subsets and the preset longitudinal profile generation path; Based on the spatial location relationship and preset terrain constraints, segmented geological profiles are generated according to each of the borehole subsets; The segmented geological profiles are merged and constructed to obtain the geological longitudinal profile of the entire line.

2. The method for generating geological longitudinal profiles based on boreholes according to claim 1, characterized in that, Spatial clustering retrieval analysis was performed on the target borehole data to obtain multiple data subsets, including: Based on the preset clustering retrieval radius, the DBSCAN clustering algorithm is used to retrieve the target borehole data to obtain multiple borehole subsets; The number of boreholes in each of the borehole subsets is determined. When the number of boreholes in a borehole subset is greater than the number of boreholes in a preset subset, the outer boundary of each of the borehole subsets is determined, and the distribution characteristics of each of the borehole subsets are obtained based on the outer boundary.

3. The method for generating geological longitudinal sections based on boreholes according to claim 2, characterized in that, The distribution characteristics of each of the borehole subsets are obtained based on the outer boundary, including: When the outer boundary is a closed boundary, it is determined that the borehole subset is distributed in a planar manner, and after topologically constructing the outer boundary, the planar range of the borehole subset is established. When the outer boundary is not closed, the borehole subset is determined to be linearly distributed.

4. The method for generating geological longitudinal sections based on boreholes according to claim 1, characterized in that, Based on the spatial relationship and preset terrain constraints, segmented geological profiles are generated according to each of the borehole subsets, including: When a subset of boreholes distributed in a planar pattern intersects with the preset longitudinal profile generation path, a local three-dimensional geological structure model is established based on the outer boundary of the borehole subset and the preset terrain constraints. Based on the local three-dimensional geological structure model, segmented geological profiles are generated by using the intersection lines of the preset longitudinal profile generation path and the borehole subset.

5. The method for generating geological longitudinal sections based on boreholes according to claim 1, characterized in that, Based on the aforementioned spatial relationships and preset terrain constraints, the generation of segmented geological profiles according to each of the borehole subsets further includes: When the borehole subset is distributed in a planar shape and is tangent to or separate from the preset longitudinal profile generation path, the boreholes in the borehole subset are determined to be within the preset distance threshold. Based on preset terrain constraints, a geological cross section is generated along the direction perpendicular to the preset longitudinal section generation path of the borehole. Determine the virtual borehole at the intersection of the geological cross section and the path generated by the preset longitudinal section; When the number of virtual boreholes is greater than the preset number of virtual boreholes, the virtual boreholes are connected sequentially based on the preset terrain constraints to generate segmented geological profiles.

6. The method for generating geological longitudinal sections based on boreholes according to claim 5, characterized in that, Based on preset terrain constraints, a geological cross-section is generated along the direction perpendicular to the preset longitudinal profile generation path of the borehole, including: Determine the layer information of the borehole and the geological cross-section generation path; wherein, the geological cross-section generation path is centered on the borehole trajectory line, extended by a preset distance threshold, and extended in the opposite direction by the straight line formed by the shortest distance between the borehole and the preset longitudinal section generation path. Based on the layered information and preset terrain constraints, segmented geological profiles are generated along the geological cross-section generation path.

7. The method for generating geological longitudinal sections based on boreholes according to claim 1, characterized in that, The segmented geological profiles are merged and constructed to obtain the entire geological longitudinal profile, including: Based on the preset terrain constraints, the sections between the segmented geological profiles are supplemented by drilling through layers, and the segmented profiles are extended to the starting point of the preset geological longitudinal section generation path in a manner parallel to the terrain. The geological boundaries and strata of the segmented geological profiles are spliced ​​and merged to obtain the entire geological longitudinal profile.

8. A device for generating geological longitudinal profiles based on boreholes, characterized in that, include: The data acquisition module is used to acquire raw borehole data and filter out target borehole data for generating geological longitudinal sections from the raw borehole data. The clustering retrieval module is used to perform spatial clustering retrieval analysis on the target borehole data to obtain multiple borehole subsets; The analysis module is used to determine the spatial positional relationship between each of the borehole subsets and the preset longitudinal profile generation path; The profile generation module is used to generate segmented geological profiles based on the spatial location relationship and preset terrain constraints, according to each of the borehole subsets. The longitudinal profile output module is used to fuse and construct the segmented geological profiles to obtain the entire geological longitudinal profile.

9. An electronic device, characterized in that, It includes a processor and a memory, wherein the memory stores a computer program, and when the computer program is executed by the processor, it implements the borehole-based geological longitudinal profile generation method as described in any one of claims 1-7.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program, which, when executed by a processor, implements a method for generating geological longitudinal sections based on boreholes as described in any one of claims 1-7.

Images