A pile length and rock penetration amount rapid estimation method, system, device and storage medium

Abstract

The present application provides a pile length and rock penetration amount rapid estimation method, system, device and storage medium, the method comprising: obtaining a histogram block, taking any histogram block as a reference block, obtaining the coordinates of a fixed identifier and a plurality of characteristic region positions set by a user, and calculating the relative displacement vectors between each characteristic region and the fixed identifier; traversing all histogram blocks, mapping the actual positions of each characteristic region according to the coordinates of the fixed identifier and the relative displacement vectors in each block, extracting text element information and summarizing it into two-dimensional stratum data records; selecting target stratum records, extracting the plane position of the survey hole and the target stratum elevation to construct a three-dimensional discrete point set, and generating an irregular triangular mesh model through triangulation; calculating the target stratum elevation according to the position relationship of the to-be-interpolated pile in the triangular mesh model, combining the estimated pile bottom elevation to calculate the pile length and / or rock penetration amount of each pile and outputting. The present application can realize batch automatic extraction and calculation, effectively improving efficiency and accuracy.

Description

Technical Field

[0001] This invention relates to the field of geotechnical engineering investigation data processing, and in particular to a method, system, equipment, and storage medium for rapid estimation of pile length and rock penetration. Background Technology

[0002] During the bidding or project budgeting stage, after receiving the pile foundation drawings and geological survey report from the tendering party, the design unit typically needs to quickly calculate key parameters such as pile length and rock penetration for hundreds or thousands of piles within hours to days to inform bidding decisions. However, each columnar section in the geological survey report is independently drawn in DWG format, containing borehole numbers, coordinates, names of each soil layer, and bottom elevation of the layer. The data volume is large, and the format varies from survey institute to institute. Traditional methods, limited by technical means, can only rely on manually copying and pasting the soil layer information for each borehole and then manually estimating the correspondence between each pile location and the survey borehole. When dealing with hundreds of survey boreholes and thousands of piles, this method often takes hours or even days, and errors and omissions are easily made during data copying and matching, resulting in rough statistical results. This not only affects the accuracy of the bid price but also makes it difficult to meet the time requirements of urgent bidding. Summary of the Invention

[0003] This invention provides a method, system, device, and storage medium for rapid estimation of pile length and rock penetration, to solve the problems existing in related technologies. The technical solution is as follows: In a first aspect, embodiments of the present invention provide a rapid estimation method for pile length and rock penetration, including: Obtain a bar chart file containing at least one bar block, where each bar block corresponds to an exploration hole and contains textual graphic element information; Using any bar chart as a reference chart, obtain the coordinate information of the fixed marker in the reference chart and the position information of multiple pre-defined feature regions, and calculate the relative displacement vector between each feature region and the fixed marker in the reference chart. Traverse all columnar blocks, map the actual positions of each feature region in each columnar block according to the coordinate information of the fixed markers and the relative displacement vector in each columnar block, extract the textual graphic element information in each actual position, and summarize the textual graphic element information extracted from the same columnar block into a two-dimensional stratigraphic data record; The target stratum is selected from the two-dimensional stratigraphic data records. The planar position of the exploration borehole and the elevation of the target stratum are extracted from each selected record to construct a three-dimensional discrete point set. The three-dimensional discrete point set is then triangulated to generate an irregular triangular mesh model. Based on the positional relationship of the planar location of the pile to be interpolated in the irregular triangular network model, calculate the target stratum elevation of each pile to be interpolated. Based on the target stratum elevation and the estimated pile bottom elevation of each pile to be interpolated, calculate and output the pile length and / or rock penetration of each pile.

[0004] In one embodiment, the plurality of feature regions include at least a first region for characterizing borehole number information, a second region for characterizing borehole planar coordinate information, a third region for characterizing stratum name information, and a fourth region for characterizing stratum bottom elevation information.

[0005] In one implementation, textual graphic element information at each actual location is extracted, including borehole number, borehole plane coordinates, stratum name, and stratum bottom elevation corresponding to each feature region.

[0006] In one implementation, the actual position of each feature region in each bar chart is mapped based on the coordinate information of fixed markers in each bar chart and the relative displacement vector, including: The coordinates of the fixed markers in each bar chart are vector-superimposed with the relative displacement vectors corresponding to each feature region to obtain the actual position coordinates of each feature region.

[0007] In one implementation, the two-dimensional stratigraphic data records are stored in tabular form, with the stratigraphic records of the same exploration borehole arranged in order of stratigraphic depth. Each record includes at least the borehole number, borehole opening plane coordinates, stratigraphic name, and bottom elevation of the stratigraphic layer.

[0008] In one implementation, triangulation of a three-dimensional discrete point set to generate an irregular triangular mesh model includes: A super triangle enclosing all discrete points is constructed based on the extreme coordinate values ​​of each discrete point in the three-dimensional discrete point set. Each discrete point in the three-dimensional discrete point set contains a first coordinate component and a second coordinate component formed by the plane position of the exploration hole, and a third coordinate component formed by the elevation of the target stratum. Each discrete point is inserted into the current triangulation as the current insertion point. All triangles in the current triangulation whose circumcircles contain the current insertion point are retrieved and marked as affected triangles. All affected triangles are deleted and all their edges are extracted. After removing duplicate edges, a set of boundary edges is formed. Each edge in the set of boundary edges is connected to the current insertion point to form a new triangle. All triangles containing super triangle vertices are deleted to obtain an irregular triangular mesh model composed of discrete points as vertices. Each triangular patch in the irregular triangular mesh model is used to characterize the local stratigraphic surface defined by the target stratigraphic elevation of the three exploration holes.

[0009] In one implementation, the target ground elevation of each interpolated pile is calculated based on its positional relationship within the irregular triangular network model, including: If the planar position of the pile to be interpolated is located inside a triangular patch in the irregular triangular network model, then a spatial plane equation is constructed based on the three-dimensional coordinates of the three vertices of the triangular patch. The planar coordinates of the pile to be interpolated are substituted into the spatial plane equation to calculate its target stratum elevation. If the planar location of the pile to be interpolated is outside the irregular triangular mesh model, then the target stratum elevation of the pile to be interpolated is taken as the target stratum elevation of the pile to be interpolated by the target stratum elevation of the discrete point closest to the pile in the three-dimensional discrete point set.

[0010] Secondly, embodiments of the present invention provide a rapid estimation system for pile length and rock penetration, which executes the rapid estimation method for pile length and rock penetration as described above, including: The data acquisition module is used to acquire a bar chart file containing at least one bar chart block, each bar chart block corresponding to an exploration hole and containing text and graphic element information; The positioning and benchmark construction module is used to take any bar chart block as a benchmark block, obtain the coordinate information of the fixed marker in the benchmark block and the position information of multiple preset feature regions, and calculate the relative displacement vector between each feature region and the fixed marker in the benchmark block. The data extraction and mapping module is used to traverse all columnar blocks, map the actual positions of each feature area in each columnar block according to the coordinate information of the fixed markers and the relative displacement vector in each columnar block, extract the text primitive information in each actual position, and summarize the text primitive information extracted from the same columnar block into a two-dimensional stratigraphic data record. The 3D modeling and subdivision module is used to filter records of the target stratum from 2D stratigraphic data records, extract the plane position of the exploration borehole and the elevation of the target stratum from each filtered record to construct a 3D discrete point set, and perform triangulation on the 3D discrete point set to generate an irregular triangular mesh model. The interpolation calculation module is used to calculate the target stratum elevation of each pile to be interpolated based on the positional relationship of the planar position of the pile to be interpolated in the irregular triangular network model. The pile foundation parameter calculation and output module is used to calculate and output the pile length and / or rock penetration of each pile based on the target stratum elevation and estimated pile bottom elevation of each pile location to be interpolated.

[0011] Thirdly, embodiments of the present invention provide an electronic device comprising a memory and a processor. The memory and the processor communicate with each other via an internal connection path. The memory stores instructions, and the processor executes the instructions stored in the memory. When the processor executes the instructions stored in the memory, it causes the processor to perform the method described in any of the above embodiments.

[0012] Fourthly, embodiments of the present invention provide a computer-readable storage medium that stores a computer program, wherein when the computer program is run on a computer, the methods in any of the embodiments described above are executed.

[0013] The advantages or beneficial effects of the above technical solutions include at least the following: This invention uses fixed markers in columnar plots as positioning references, sets feature regions, and calculates the relative displacement vector between them and the fixed markers. When traversing all columnar plots, it only needs to vectorically superimpose the coordinate information of the fixed markers in each plot with the relative displacement vector to automatically map the actual position of each feature region in each columnar plot. This achieves batch automatic extraction of all borehole layer data, eliminating the reliance on manual copying and pasting, and shortening the manual statistical time from several hours to several days to a few minutes. Moreover, the entire process relies solely on coordinate calculation to automatically complete positioning and extraction, effectively avoiding problems such as missing soil layers, data serialization, and misaligned correspondences in traditional manual transcription, ensuring the integrity and accuracy of the data.

[0014] Based on this, by constructing a three-dimensional discrete point set based on the plane position of the exploration borehole and the elevation of the target stratum and generating an irregular triangular network model through triangulation, the automatic matching and accurate interpolation of the spatial relationship between any pile location and the exploration borehole are realized. Combined with the estimated pile bottom elevation, the pile length and rock penetration of each pile can be automatically calculated, providing timely and accurate data support for bidding decisions and project budgeting, and significantly improving work efficiency and decision reliability.

[0015] The above overview is for illustrative purposes only and is not intended to be limiting in any way. In addition to the illustrative aspects, embodiments, and features described above, further aspects, embodiments, and features of the invention will become readily apparent from the accompanying drawings and the following detailed description. Attached Figure Description

[0016] In the accompanying drawings, unless otherwise specified, the same reference numerals throughout the various drawings denote the same or similar parts or elements. These drawings are not necessarily drawn to scale. It should be understood that these drawings depict only some embodiments disclosed in the invention and should not be construed as limiting the scope of the invention.

[0017] Figure 1 This is a flowchart illustrating the rapid estimation method for pile length and rock penetration volume of the present invention. Figure 2 This is a schematic diagram of the bar chart of the present invention; Figure 3 This is a structural block diagram of an electronic device according to an embodiment of the present invention. Detailed Implementation

[0018] In the following description, only certain exemplary embodiments are briefly described. As those skilled in the art will recognize, the described embodiments can be modified in various ways without departing from the spirit or scope of the invention. Therefore, the drawings and description are considered to be exemplary in nature and not restrictive.

[0019] Example 1 This embodiment provides a rapid method for estimating pile length and rock penetration volume, referencing... Figure 1 As shown, the method specifically includes the following steps: Step S1: Obtain a bar chart file containing at least one bar chart block, each bar chart block corresponding to an exploration hole and containing textual graphic element information.

[0020] In engineering practice, borehole columnar sections in geological survey reports are typically provided as DWG format CAD files. These CAD files contain numerous graphic elements, the most crucial of which are multiple columnar sections. Each columnar section corresponds to an independent borehole and records all soil layer information for that borehole location. Each columnar section contains rich textual graphic information, such as borehole number, borehole coordinates, the name of each soil layer, and its corresponding bottom elevation.

[0021] It should be noted that while the columnar sections issued by different exploration institutes vary in layout format, their core data structure is similar. They all use textual elements to represent the complete stratigraphic layering data of each exploration borehole within the CAD drawing. For example... Figure 2 As shown, Figure 2 This is one of the bar chart blocks in the bar chart file.

[0022] Step S2: Using any bar chart as a reference chart, obtain the coordinate information of the fixed marker in the reference chart; set multiple feature regions corresponding to the information to be extracted in the reference chart, and calculate the relative displacement vector between each feature region and the fixed marker in the reference chart.

[0023] After obtaining the column chart file in CAD format, select any column block from the column chart file as the base block.

[0024] In this reference block, the program or user pre-specifies a fixed identifier. This identifier has the characteristics of being unique in content and fixed in position in all column blocks of the same project, including but not limited to text elements, block base points, attribute block labels, etc. For example, the fixed identifier can be the text "Project Name". This fixed identifier will exist in all column blocks of the same project and its position will be fixed. The precise coordinate information of the fixed identifier in the drawing coordinate system is automatically obtained as the positioning reference point of the entire block.

[0025] Subsequently, the user simply selects multiple rectangular areas corresponding to the information to be extracted on the baseline map, obtaining multiple feature regions. Here, a feature region refers to the rectangular area selected by the user on the baseline map (e.g., selecting the rectangular area containing the "borehole number"), and the information to be extracted is the specific text content contained within that rectangular area. The multiple feature regions include at least a first region representing the borehole number information, a second region representing the borehole opening plane coordinate information, a third region representing the stratum name information, and a fourth region representing the stratum bottom elevation information. Specifically, in this embodiment, the feature regions include a borehole number region, a borehole opening coordinate region, a soil layer name region, and a stratum bottom elevation region. The system automatically records the diagonal coordinates of each feature region. For example... Figure 2 As shown, Figure 2 The bolded area represents the area containing the fixed identifier and various feature areas.

[0026] Finally, calculate the relative displacement vector of the diagonal coordinates of each feature region relative to the coordinates of the aforementioned positioning reference point. Specifically, for any feature region, the coordinates of its diagonal points (X1, Y1) and (X2, Y2) and the coordinates of the positioning reference point P (X0, Y0) are all obtained, then: The relative displacement vector of this feature region = coordinates of the diagonal point of the region - coordinates of point P; specifically: The relative displacement vector of the first diagonal point: V1 = (X1) X0, Y1 Y0) The relative displacement vector of the second diagonal point: V2 = (X2) X0, Y2 Y0) The relative displacement vector essentially constitutes a "data extraction template" that records the relative positional relationship of each piece of information to be extracted in the bar chart. Subsequent steps only need to use this template and the same fixed identifier in each bar chart to batch map the actual coordinate position of the feature area in all bar charts, thereby avoiding the need for repeated manual selection in each bar chart and greatly simplifying the operation process.

[0027] Step S3: Traverse all columnar plots, map the actual positions of each feature region in each columnar plot according to the coordinate information of the fixed markers and the relative displacement vector, extract the textual primitive information in each actual position, and summarize the textual primitive information extracted from the same columnar plot into a two-dimensional stratigraphic data record.

[0028] After setting the feature areas and calculating the relative displacement vectors in the baseline block, the batch data extraction stage can begin. First, all column blocks in the CAD column chart file are traversed. In each column block, the same fixed identifier text (such as "Project Name") as in the baseline block is automatically searched, and the actual coordinates of this fixed identifier text in the current block are obtained. This actual coordinate value is denoted as P', and its physical meaning is the same as point P in the baseline block—the coordinates of the insertion point of the fixed identifier in that block. Since column blocks in the same project typically use a unified block template, the content of the fixed identifier text in different blocks is consistent; only the coordinate positions differ due to the different layouts of the blocks in the drawing.

[0029] Subsequently, the relative displacement vectors of each feature region calculated above are vector-superimposed with the actual coordinates P' of the fixed marker in the columnar block, thereby mapping the actual position coordinates of each feature region in the columnar block. Specifically, for the four feature regions—the borehole number region, the coordinate region, the soil layer name region, and the bottom elevation region—their respective relative displacement vectors are added to P' to reconstruct the precise position of each feature region in the current columnar block. This mapping process is entirely automated, relying on coordinate calculations, and requires no manual intervention.

[0030] After obtaining the actual location of each feature area, the CAD text search function is used to extract the textual graphic information within each feature area, including the borehole number, borehole opening plane coordinates, stratum name, and corresponding bottom elevation. During extraction, the textual information of each soil layer is read sequentially from top to bottom according to the stratigraphic order of the columnar section to ensure the accuracy of the correspondence between stratum name and bottom elevation. The extracted textual information is then arranged in depth order.

[0031] After extracting data from a single column block, all textual element information corresponding to that column block is summarized into a single two-dimensional stratigraphic data record. This record includes the borehole number, borehole plane coordinates, stratigraphic name, and corresponding bottom elevation. Then, the system automatically jumps to the next column block, repeating the search, mapping, extraction, and summarization operations until all column blocks have been processed.

[0032] Finally, the two-dimensional stratigraphic data records of all exploration wells are summarized and output as a two-dimensional form in Excel or TXT format. Each record in the form corresponds to a specific stratigraphic layer information of an exploration well. The stratigraphic records of the same exploration well are arranged from top to bottom according to the stratigraphic depth, and the records of different exploration wells are arranged sequentially according to the borehole number, forming a standardized two-dimensional data table as shown in Table 1, which provides a structured data foundation for subsequent three-dimensional modeling and spatial interpolation calculations.

[0033] Table 1 Two-dimensional form Serial Number Kong Hao Orifice coordinates Soil layer name Floor top elevation 1 ZK1 1223.453,3524.624 Fill soil 12.5 2 ZK1 1223.453,3524.624 Silty clay 7.85 3 ZK1 1223.453,3524.624 Completely weathered 5.62 4 ZK1 1223.453,3524.624 Strong weathering 4.62 5 ZK1 1223.453,3524.624 Stroke 1.62 6 ZK2 1223.453,3524.624 Plain fill soil 12.5 7 ZK2 1223.453,3524.624 silt 7.85 8 ZK2 1223.453,3524.624 medium sand 5.62 9 ZK2 1223.453,3524.624 Strong weathering 4.62 10 ZK2 1223.453,3524.624 Stroke 1.62 ······ ······ ······ ······ ······ Step S4: Filter the records of the target stratum from the two-dimensional stratigraphic data records, extract the plane position of the exploration borehole and the elevation of the target stratum from each filtered record to construct a three-dimensional discrete point set, and perform triangulation on the three-dimensional discrete point set to generate an irregular triangular network model.

[0034] After summarizing all the two-dimensional stratigraphic data records from all exploration wells, the three-dimensional stratigraphic model construction phase begins. First, based on the user-specified target stratigraphic name, such as "strongly weathered" or "moderately weathered," all records matching the target stratigraphic stratum are selected from the two-dimensional stratigraphic data records. Each selected record includes the well number, planar coordinates, and the elevation of the bottom of the target stratigraphic layer.

[0035] From these filtered records, the planar coordinates (X, Y) of each exploration borehole and its corresponding bottom elevation (Z) of the target stratum are extracted one by one, and these three are combined to form a discrete point in three-dimensional space. Each exploration borehole corresponds to a discrete point, and the target stratum data of all exploration boreholes together constitute a three-dimensional discrete point set A. Each discrete point in this set contains a first coordinate component (X), a second coordinate component (Y), and a third coordinate component (Z). The first two components come from the planar coordinates of the borehole opening, and the third component comes from the bottom elevation of the target stratum at that borehole location.

[0036] Subsequently, the program performs Delaunay triangulation on the three-dimensional discrete point set A to establish the spatial topological relationships between the exploration holes. Specifically, the Bowyer-Watson incremental insertion algorithm is used: First, a super triangle sufficient to enclose all discrete points in set A is constructed as the initial triangulation based on the extreme coordinates of all discrete points in set A; then, each discrete point in set A is inserted into the triangulation as the current insertion point. For each discrete point to be inserted, all triangles in the current triangulation whose circumcircles contain that point are retrieved, these triangles are marked as affected triangles and deleted; all edges of the affected triangles are extracted, duplicate edges are removed to form a boundary edge set, and each edge in the boundary edge set is connected to the current insertion point to form a new triangle; as all discrete points are inserted in sequence, the triangulation is continuously updated, eventually forming a triangulation composed of adjacent exploration holes.

[0037] After all discrete points have been inserted, all triangles containing vertices of the super triangle are deleted. The remaining triangular mesh is the irregular triangular mesh model composed of the original discrete points of the exploration holes. In this triangular mesh model, the three vertices of each triangular facet are adjacent exploration holes, and its spatial coordinates are defined by the planar position of each exploration hole and the target stratum elevation. Each triangular facet represents the local stratum surface defined by the three exploration holes, thus providing a basis for subsequent interpolation calculations of the target stratum elevation at any pile location.

[0038] Step S5: Based on the positional relationship of the planar positions of the piles to be interpolated in the irregular triangular network model, calculate the target stratum elevation of each pile to be interpolated. Based on the target stratum elevation and the estimated pile bottom elevation of each pile to be interpolated, calculate and output the pile length and / or rock penetration of each pile.

[0039] In the design drawings (also known as pile location plan) provided by the design unit, which include the planar locations of all engineering piles, each engineering pile has a clearly defined planar coordinate position. These pile locations to be interpolated constitute the set B of interpolation points. Each pile location to be interpolated in set B is traversed, and its positional relationship is determined in the irregular triangular network model based on its planar coordinates (X, Y). The determination method is as follows: calculate the spatial inclusion relationship between the planar point of the pile location and each triangle in the triangular network. If the point is located inside the closed area enclosed by the three sides of a triangle, it is determined to be "inside the network"; if the point does not belong to the internal area of ​​any triangle, it is determined to be "outside the network". Based on the determination results, different interpolation strategies are used to calculate the target ground elevation at the pile location.

[0040] If the planar location of the pile to be interpolated is located inside a triangular facet in the irregular triangular mesh model, it indicates that there are three known exploration boreholes around the pile location, and the target stratum elevation is jointly defined by the spatial locations of these three exploration boreholes. In this case, the three-dimensional coordinates of the three vertices of the triangular facet are obtained. The X and Y coordinates of each vertex are derived from the planar location of the corresponding exploration borehole, and the Z coordinate is derived from the target stratum elevation of that borehole. Based on the three-dimensional coordinates of these three vertices, the spatial plane equation Ax + By + Cz + D = 0 is constructed. By substituting the coordinates of the three vertices into the equation, the coefficients A, B, C, and D of the plane equation are solved. Subsequently, the planar coordinates (X, Y) of the pile to be interpolated are substituted into this plane equation to calculate the target stratum elevation Z at the pile location.

[0041] If the planar location of the pile to be interpolated is outside the irregular triangular mesh model, that is, there are no three exploration boreholes forming a triangle around the pile, then interpolation cannot be performed using the planar equation. In this case, the planar distance between the pile to be interpolated and each discrete point of the exploration borehole in the three-dimensional discrete point set A is calculated, and the exploration borehole with the closest distance is selected. The target stratum elevation of this exploration borehole is directly used as the target stratum elevation of the pile to be interpolated.

[0042] After processing in the above two ways, each pile location to be interpolated has obtained the corresponding target stratum elevation value, that is, the absolute elevation of the top surface of the target stratum (such as the bearing layer) at that pile location, also known as "rock surface elevation".

[0043] After obtaining the target stratum elevation for each pile location to be interpolated, and combining this with the rock penetration depth required in the design drawings, the pile length and rock penetration amount for each pile can be calculated. The specific calculation process is as follows: The rock penetration depth is a known design value, and the target stratum elevation is the rock surface elevation. Since the pile bottom is located below the top surface of the bearing stratum, the estimated pile bottom elevation is equal to the target stratum elevation minus the rock penetration depth.

[0044] The pile length is the total length from the top of the pile to the bottom of the pile. The pile length is equal to the preset pile top elevation minus the estimated pile bottom elevation, reflecting the vertical length of the pile body from the top surface of the bearing layer to the bottom of the pile.

[0045] The rock penetration amount is equal to the rock penetration depth multiplied by the cross-sectional area of ​​the pile body, where the cross-sectional area of ​​the pile body is calculated based on the designed pile diameter as a circular cross section.

[0046] Calculate the pile length and rock penetration of all pile locations to be interpolated, and output all calculation results in Excel or TXT format. The output includes the plane coordinates, target stratum elevation, pile bottom elevation, pile length, and rock penetration of each pile location, providing complete data support for the quantity estimation and construction plan formulation during the bidding stage.

[0047] The method in this embodiment has the following beneficial effects: (I) Significantly Improved Data Extraction Efficiency. This embodiment uses fixed markers in the baseline map as positioning references, sets feature regions, and calculates the relative displacement vectors between each feature region and the fixed markers. When traversing all columnar maps, it only needs to perform vector superposition based on the coordinate information of the fixed markers in each map and the aforementioned relative displacement vectors to automatically map the actual positions of each feature region in each map, achieving batch automatic extraction of all borehole stratification data. Throughout the process, the user only needs to complete the feature region setting once on the baseline map, and the system can automatically complete the positioning and information extraction of hundreds of columnar maps, reducing the hours required for traditional manual copying and pasting to just a few minutes. This is especially suitable for time-sensitive application scenarios during the bidding stage.

[0048] (ii) Effectively avoids errors and omissions in manual statistics and ensures data accuracy. This embodiment automatically completes the precise positioning of feature areas and text extraction based on relative displacement vectors, avoiding positioning deviations introduced by repeatedly selecting different format column blocks manually; at the same time, the stratigraphic data of the same exploration borehole are arranged in depth order, ensuring the accurate correspondence between stratigraphic names and bottom elevations.

[0049] (III) Achieving automatic matching and accurate interpolation of the spatial relationship between pile locations and exploration boreholes. In this embodiment, a three-dimensional discrete point set is constructed based on the planar position of the exploration borehole and the elevation of the target stratum. An irregular triangular mesh model is generated using Delaunay triangulation, which enables precise quantification of the spatial distribution of the target stratum for each exploration borehole. Based on this, plane equation interpolation or nearest neighbor assignment is used according to the positional relationship of the pile location to be interpolated in the triangular mesh, thereby achieving accurate acquisition of the elevation of the target stratum at any pile location.

[0050] (iv) Automatic calculation and output of pile foundation parameters. Based on the target stratum elevation of each pile location to be interpolated, this embodiment automatically calculates the pile length and rock penetration and outputs a standardized form, providing timely and reliable data support for bidding decisions, significantly improving work efficiency and decision reliability.

[0051] Example 2 This embodiment provides a rapid estimation system for pile length and rock penetration, which executes the rapid estimation method for pile length and rock penetration as described in Embodiment 1. The system includes a data acquisition module, a positioning and benchmark construction module, a data extraction and mapping module, a 3D modeling and subdivision module, an interpolation calculation module, and a pile foundation parameter calculation and output module. The data acquisition module is used to acquire bar chart files containing at least one bar chart block. Each bar chart block corresponds to an exploration hole and contains textual graphic element information. This module is responsible for reading DWG format CAD files from external sources and providing them to subsequent modules for processing.

[0052] The positioning and benchmark construction module is used to take any columnar block as a benchmark block, obtain the coordinate information of fixed identifiers (such as the text "project name") in the benchmark block, and allow the user to set multiple feature regions corresponding to the information to be extracted in the benchmark block, including borehole number region, borehole coordinate region, stratum name region and bottom elevation region. Then, the relative displacement vector between each feature region and the fixed identifier in the benchmark block is calculated to form the coordinate mapping template for subsequent batch extraction.

[0053] The data extraction and mapping module is used to traverse all columnar blocks in the CAD file. Based on the coordinate information of the fixed markers in each columnar block and the aforementioned relative displacement vector, it automatically maps the actual positions of each feature area in each columnar block through vector superposition. It extracts the textual graphic element information in each actual position and summarizes the textual graphic element information extracted from the same columnar block into a two-dimensional stratigraphic data record in order of stratigraphic depth. This record contains fields such as borehole number, borehole plane coordinates, stratigraphic name, and bottom elevation of the stratigraphic layer, and is output in Excel or TXT format.

[0054] The 3D modeling and subdivision module is used to filter records of target strata from 2D stratigraphic data records. It extracts the planar position of exploration wells and the elevation of target strata from each filtered record to construct a 3D discrete point set. The Delaunay triangulation algorithm is used to triangulate the 3D discrete point set to generate an irregular triangular mesh model. Each triangular facet of the triangular mesh model represents a local stratigraphic surface defined by the elevation of the target strata of the three exploration wells.

[0055] The interpolation calculation module is used to calculate the target stratum elevation of each pile position to be interpolated based on the positional relationship of the planar position of the pile position in the irregular triangular network model. If the pile position is located inside a certain triangular patch, the spatial plane equation is constructed by the three-dimensional coordinates of the three vertices of the triangle for interpolation. If the pile position is located outside the triangular network, the target stratum elevation of the nearest exploration borehole discrete point is used as the target stratum elevation of the pile position.

[0056] The pile foundation parameter calculation and output module is used to automatically calculate and output the pile length and rock penetration of each pile based on the target stratum elevation and the estimated pile bottom elevation of each pile location to be interpolated. The pile length is equal to the estimated pile bottom elevation minus the target stratum elevation, the rock penetration is equal to the rock penetration depth multiplied by the cross-sectional area of ​​the pile body, and the rock penetration depth is equal to the estimated pile bottom elevation minus the target stratum elevation. Finally, the calculation results, such as the plane coordinates, target stratum elevation, pile length, and rock penetration of each pile location, are output in Excel or TXT format.

[0057] It should be noted that the functions of each module in the system of this embodiment have been disclosed in detail in the method embodiment, and will not be described again here.

[0058] Example 3 This embodiment provides an electronic device. Figure 3 A structural block diagram of an electronic device according to an embodiment of the present invention is shown. Figure 3 As shown, the electronic device includes a memory 100 and a processor 200. The memory 100 stores a computer program that can run on the processor 200. When the processor 200 executes the computer program, it implements the rapid estimation method for pile length and rock penetration volume in the above embodiment. The number of memories 100 and processors 200 can be one or more.

[0059] The electronic device also includes: The communication interface 300 is used to communicate with external devices and perform data exchange and transmission.

[0060] If the memory 100, processor 200, and communication interface 300 are implemented independently, they can be interconnected via a bus to communicate with each other. This bus can be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, or an Extended Industry Standard Architecture (EISA) bus, etc. This bus can be divided into address bus, data bus, control bus, etc.

[0061] Optionally, in a specific implementation, if the memory 100, processor 200, and communication interface 300 are integrated on a single chip, then the memory 100, processor 200, and communication interface 300 can communicate with each other through an internal interface.

[0062] This invention provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the method provided in this invention.

[0063] This invention also provides a chip, which includes a processor for calling and executing instructions stored in a memory, causing a communication device on which the chip is installed to perform the method provided in this invention.

[0064] This invention also provides a chip, including: an input interface, an output interface, a processor, and a memory. The input interface, output interface, processor, and memory are connected through an internal connection path. The processor is used to execute code in the memory. When the code is executed, the processor is used to execute the method provided in this invention.

[0065] It should be understood that the aforementioned processor can be a Central Processing Unit (CPU), or 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. General-purpose processors can be microprocessors or any conventional processor. It is worth noting that the processor can be a processor supporting the Advanced Reduced Instruction Set Computing (RISC) machine (ARM) architecture.

[0066] Further, optionally, the aforementioned memory may include read-only memory and random access memory, and may also include non-volatile random access memory. The memory may be volatile or non-volatile, or may include both. Non-volatile memory may include read-only memory (ROM), programmable read-only memory (PROM), erasable programmable read-only memory (EPROM), electrically erasable programmable read-only memory (EEPROM), or flash memory. Volatile memory may include random access memory (RAM), which serves as an external cache. Many forms of RAM are available by way of example, but not limitation. Examples include static random access memory (SRAM), dynamic random access memory (DRAM), synchronous dynamic random access memory (SDRAM), double data rate synchronous dynamic random access memory (DDR SDRAM), enhanced synchronous dynamic random access memory (ESDRAM), synchronous linked dynamic random access memory (SLDRAM), and direct rambus RAM (DR RAM).

[0067] In the above embodiments, implementation can be achieved, in whole or in part, by software, hardware, firmware, or any combination thereof. When implemented in software, it can be implemented, in whole or in part, as a computer program product. A computer program product includes one or more computer instructions. When the computer program instructions are loaded and executed on a computer, all or part of the flow or function according to the present invention is generated. The computer can be a general-purpose computer, a special-purpose computer, a computer network, or other programmable device. The computer instructions can be stored in a computer-readable storage medium or transferred from one computer-readable storage medium to another.

[0068] In the description of this specification, references to terms such as "one embodiment," "some embodiments," "example," "specific example," or "some examples," etc., indicate that a specific feature, structure, material, or characteristic described in connection with that embodiment or example is included in at least one embodiment or example of the invention. Furthermore, the specific features, structures, materials, or characteristics described may be combined in any suitable manner in one or more embodiments or examples. Moreover, without contradiction, those skilled in the art can combine and integrate the different embodiments or examples described in this specification, as well as the features of those different embodiments or examples.

[0069] Furthermore, the terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance or implicitly specifying the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one of that feature. In the description of this invention, "a plurality of" means two or more, unless otherwise explicitly specified.

[0070] The above description is merely a specific embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Any person skilled in the art can easily conceive of various variations or substitutions within the technical scope disclosed in the present invention, and these should all be included within the scope of protection of the present invention. Therefore, the scope of protection of the present invention should be determined by the scope of the claims.

Claims

1. A rapid estimation method for pile length and rock penetration, characterized in that, include: Obtain a bar chart file containing at least one bar block, each bar block corresponding to an exploration hole and containing textual graphic element information; Using any of the aforementioned bar chart blocks as a reference chart block, obtain the coordinate information of the fixed marker in the reference chart block and the position information of multiple preset feature regions, and calculate the relative displacement vector between each of the aforementioned feature regions and the fixed marker in the reference chart block; Traverse all columnar plots, and based on the coordinate information of the fixed identifiers in each columnar plot and the relative displacement vector, map the actual position of each feature region in each columnar plot, extract the textual primitive information in each actual position, and summarize the textual primitive information extracted from the same columnar plot into a two-dimensional stratigraphic data record; The target stratum is selected from the two-dimensional stratigraphic data records. The borehole planar position and target stratum elevation are extracted from each selected record to construct a three-dimensional discrete point set. The three-dimensional discrete point set is then triangulated to generate an irregular triangular mesh model. Based on the positional relationship of the planar positions of the piles to be interpolated in the irregular triangular network model, the target stratum elevation of each pile to be interpolated is calculated. Based on the target stratum elevation and the estimated pile bottom elevation of each pile to be interpolated, the pile length and / or rock penetration of each pile are calculated and output.

2. The rapid estimation method for pile length and rock penetration volume according to claim 1, characterized in that, The plurality of feature regions include at least a first region for characterizing borehole number information, a second region for characterizing borehole plane coordinate information, a third region for characterizing stratum name information, and a fourth region for characterizing stratum bottom elevation information.

3. The rapid estimation method for pile length and rock penetration volume according to claim 1, characterized in that, The extraction of textual graphic element information from each actual location includes the borehole number, borehole plane coordinates, stratum name, and stratum bottom elevation corresponding to each of the aforementioned feature regions.

4. The rapid estimation method for pile length and rock penetration volume according to claim 1, characterized in that, The step of mapping the actual position of each feature region in each bar chart block to the coordinate information of the fixed identifier in each bar chart block and the relative displacement vector includes: The coordinates of the fixed markers in each bar chart block are vector-superimposed with the relative displacement vectors corresponding to each feature region to obtain the actual position coordinates of each feature region.

5. The rapid estimation method for pile length and rock penetration volume according to claim 1, characterized in that, The two-dimensional stratigraphic data records are stored in tabular form. The stratigraphic records of the same exploration borehole are arranged in order of stratigraphic depth. Each record includes at least the borehole number, borehole opening plane coordinates, stratigraphic name, and bottom elevation of the stratigraphic layer.

6. The rapid estimation method for pile length and rock penetration volume according to claim 1, characterized in that, Triangulation of the three-dimensional discrete point set to generate an irregular triangular mesh model includes: A super triangle enclosing all discrete points is constructed based on the extreme coordinate values ​​of each discrete point in the three-dimensional discrete point set. Each discrete point in the three-dimensional discrete point set contains a first coordinate component and a second coordinate component formed by the plane position of the exploration hole, and a third coordinate component formed by the elevation of the target stratum. Each discrete point is inserted into the current triangulation as the current insertion point. All triangles in the current triangulation whose circumcircles contain the current insertion point are retrieved and marked as affected triangles. All affected triangles are deleted and all their edges are extracted. After removing duplicate edges, a set of boundary edges is formed. Each edge in the set of boundary edges is connected to the current insertion point to form a new triangle. All triangles containing the vertices of the super triangle are deleted to obtain the irregular triangular mesh model composed of the discrete points as vertices. Each triangular patch in the irregular triangular mesh model is used to characterize the local stratigraphic surface defined by the target stratigraphic elevation of the three exploration holes.

7. The rapid estimation method for pile length and rock penetration volume according to claim 1, characterized in that, The step of calculating the target ground elevation of each interpolated pile location based on its positional relationship within the irregular triangular network model, according to the planar position of the pile location to be interpolated, includes: If the planar position of the pile to be interpolated is located inside a certain triangular facet in the irregular triangular network model, then a spatial plane equation is constructed based on the three-dimensional coordinates of the three vertices of the triangular facet, and the planar coordinates of the pile to be interpolated are substituted into the spatial plane equation to calculate its target stratum elevation. If the planar position of the pile to be interpolated is located outside the irregular triangular network model, then the target stratum elevation of the pile to be interpolated is taken as the target stratum elevation of the pile to be interpolated by the target stratum elevation of the discrete point closest to the pile in the three-dimensional discrete point set.

8. A rapid estimation system for pile length and rock penetration, characterized in that, The system implements the rapid estimation method for pile length and rock penetration as described in any one of claims 1 to 7; the system includes: The data acquisition module is used to acquire a bar chart file containing at least one bar chart block, each bar chart block corresponding to an exploration hole and containing textual graphic element information; The positioning and benchmark construction module is used to take any of the columnar blocks as a benchmark block, obtain the coordinate information of the fixed markers in the benchmark block and the position information of multiple preset feature regions, and calculate the relative displacement vector between each feature region and the fixed markers in the benchmark block. The data extraction and mapping module is used to traverse all columnar blocks, map the actual positions of the feature regions in each columnar block according to the coordinate information of the fixed identifiers in each columnar block and the relative displacement vector, extract the text primitive information in each actual position, and summarize the text primitive information extracted from the same columnar block into a two-dimensional stratigraphic data record. The 3D modeling and subdivision module is used to filter records of the target stratum from the 2D stratigraphic data records, extract the plane position of the exploration hole and the elevation of the target stratum from each filtered record to construct a 3D discrete point set, and perform triangulation on the 3D discrete point set to generate an irregular triangular mesh model. The interpolation calculation module is used to calculate the target stratum elevation of each pile to be interpolated based on the positional relationship of the planar position of the pile to be interpolated in the irregular triangular network model. The pile foundation parameter calculation and output module is used to calculate and output the pile length and / or rock penetration of each pile based on the target stratum elevation and estimated pile bottom elevation of each pile location to be interpolated.

9. An electronic device, characterized in that, include: A processor and a memory, wherein the memory stores instructions that are loaded and executed by the processor to implement the rapid estimation method for pile length and rock penetration as described in any one of claims 1 to 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 the rapid estimation method for pile length and rock penetration as described in any one of claims 1 to 7.

Images