A method for calculating the volume of soil in a stratum based on multi-borehole point layered data

By constructing a triangular network of soil layer thickness based on borehole points, the problem of large layer measurement error in traditional earthwork volume calculation methods is solved, thereby improving the accuracy and efficiency of earthwork volume calculation and meeting the needs of layered excavation and settlement.

CN123111402APending Publication Date: 2026-11-17HANGZHOU FEISHIDA SOFTWARE CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202611282177.4
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2026-08-24
Publication Date
2026-11-17

AI Technical Summary

Technical Problem

Traditional earthwork volume calculation methods cannot effectively utilize borehole stratification data, resulting in large errors in stratification measurement results. This fails to meet the needs of stratified excavation and settlement, and is prone to generating boundary-crossing triangular units, increasing manual operation time and calculation errors.

Method used

By acquiring borehole point data and topographic point data of the engineering area, a global benchmark point set is constructed, distinguishing between points inside the boundary and adjacent points to form an initial triangular network. Then, a soil layer thickness triangular network is constructed with the borehole points as vertices, and natural and design elevations are processed to generate engineering quantity data.

Benefits of technology

It integrates surface topographic data with underground strata data, outputs the total excavation and filling volume of the site and the excavation and filling volume of each layer, reduces manual operation time, reduces calculation errors, meets the on-site needs of layered excavation and settlement, and improves engineering measurement efficiency.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN123111402A_ABST
    Figure CN123111402A_ABST
Patent Text Reader

Abstract

This invention discloses a method for calculating the volume of earthwork in a stratum based on multi-borehole point layered data, belonging to the field of building engineering measurement technology. The key technical points include the following steps: acquiring borehole point data and topographic point data for the engineering area; integrating the borehole point data and topographic point data within the earthwork volume calculation range to form a global benchmark point set; determining the contour boundary of the earthwork volume calculation range based on the global effective benchmark point set, constructing a soil layer thickness triangulation network with all borehole points as vertices and the soil layer thickness at each borehole point as elevation values; processing the initial triangulation network to obtain natural elevation and design elevation, and obtaining the soil layer thickness at the corresponding corner points of the soil layer thickness triangulation network based on interpolation; and processing the natural elevation, design elevation, and soil layer thickness to generate engineering quantity data, thereby improving the overall efficiency of engineering measurement work.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This invention relates to the field of building engineering measurement technology, and more specifically, to a method for calculating the volume of earthwork in a stratum based on multi-drill point layered data. Background Technology

[0002] Earthwork volume calculation is a fundamental step in project cost estimation, construction schedule planning, and excavation scheme design. Traditional earthwork calculation methods rely solely on a single triangular network constructed from topographic points obtained through surface surveying. The entire process only collects and stores natural surface elevation data, completely failing to incorporate borehole stratification data obtained from drilling operations. Ultimately, it can only output the total excavation and fill volume for the entire project site, without breaking down the excavation and fill volume for each individual underground soil layer. However, most actual civil engineering projects employ a layered excavation and layered settlement construction model. Cost estimators need to calculate the earthwork volume for each soil layer separately. Traditional techniques can only repeatedly adjust the calculation range, not only increasing manual operation time significantly but also accumulating numerical errors through repeated calculations, making it impossible to guarantee the reliability of the layered measurement results.

[0003] Relying solely on coordinate extreme values ​​to select survey points does not distinguish between points inside the boundary and points adjacent to the boundary. When building triangular meshes, it is easy to generate out-of-bounds triangular units that extend beyond the measured contour. This results in these out-of-bounds units being included in invalid space outside the measurement range, directly causing significant deviations in the earthwork volume calculation values. Summary of the Invention

[0004] To address the shortcomings of existing technologies, the present invention aims to provide a method for calculating the volume of soil in strata based on multi-drill point layered data.

[0005] To achieve the above objectives, the present invention provides the following technical solution:

[0006] A method for calculating the volume of soil in a stratum based on multi-borehole point layered data includes the following steps:

[0007] Acquire borehole point data and topographic point data for the engineering area;

[0008] The borehole point data and topographic point data of the earthwork volume calculation range are integrated to form a global reference point set; the outline boundary condition of the earthwork volume calculation range is determined based on the global effective reference point set; and the relative positional relationship between the reference point position and the boundary line in the global effective reference point set is determined based on the outline boundary condition.

[0009] The points inside the boundary and the points adjacent to the boundary are distinguished according to their relative positions. The set of global constraint reference points is obtained based on the points inside the boundary and the points adjacent to the boundary. The initial triangular network is obtained by continuously splicing the set of global constraint reference points.

[0010] A triangular network of soil layer thickness is constructed using all borehole points on the map as vertices and the thickness of the soil layer at each borehole point as the elevation value.

[0011] The initial triangulation network is processed to obtain the natural elevation and the design elevation. Based on interpolation, the soil layer thickness at the corresponding corner of the triangulation network is obtained.

[0012] The natural elevation, design elevation, and soil layer thickness are processed to generate engineering quantity data.

[0013] Preferably, the initial triangulation network is processed to obtain the natural elevation and the design elevation, specifically including the following steps:

[0014] The natural elevation of the corresponding corner points of the initial triangulation is obtained by interpolating the natural terrain points of the entire map.

[0015] The design elevation of the corresponding corner points of the initial triangulation is obtained by interpolating the borehole points of the entire map.

[0016] Preferably, the natural elevation, design elevation, and soil layer thickness are processed to generate engineering quantity data, specifically including the following steps:

[0017] Traverse each triangular cell of the initial triangular network, obtain the average cut-and-fill depth based on the natural elevation and design elevation of the triangular cell, and obtain the total cut-and-fill volume based on the average cut-and-fill depth and cell area;

[0018] The volume of excavation and filling for each soil layer is obtained based on the soil layer thickness and the unit area.

[0019] The engineering quantity data is generated based on the total excavation and filling volume and the excavation and filling volume of each soil layer.

[0020] Preferably, determining the contour boundary condition of the earthwork volume calculation range based on the global effective reference point set specifically includes the following steps:

[0021] Extract the spatial distribution range of the effective benchmark point set across the entire region, and determine the basic delineation area for earthwork volume calculation based on the spatial distribution range.

[0022] Select valid reference points located at the edge of the basic delineation area and use these valid reference points as the basic units for boundary definition.

[0023] Based on the boundary definition of the basic unit, a closed edge line is formed, and the overall outline of the earthwork volume calculation range is formed by the closed edge line.

[0024] The boundary condition of the earthwork volume calculation range is determined based on the extended shape and boundary orientation of the overall outline.

[0025] Preferably, determining the relative positional relationship between the concentrated reference points of the global effective reference points and the boundary lines based on the contour boundary conditions specifically includes the following steps:

[0026] Extract the continuous edge trend and overall boundary coverage based on the contour boundary conditions;

[0027] Based on the continuous edge trend, the reference points of the entire effective reference point set are traversed, and the fit between the reference points and the overall coverage of the boundary is compared one by one to obtain the comparison results.

[0028] The relative positional relationship between the benchmark point and the boundary line is determined based on the comparison results.

[0029] Preferably, distinguishing between points inside the boundary and points adjacent to the boundary based on their relative positional relationship specifically includes the following steps:

[0030] Determine the spatial ownership status of the benchmark point relative to the boundary line based on the relative positional relationship;

[0031] Based on the spatial attribution status, the reference points located inside the contour boundary are selected to obtain the points inside the boundary.

[0032] Based on the spatial attribution status, reference points located inside the contour boundary and conforming to the boundary direction are selected to obtain the boundary-adjacent points.

[0033] Preferably, the global constraint reference point set is obtained based on the points inside the boundary and the points adjacent to the boundary, specifically including the following steps:

[0034] By verifying the points inside the boundary and the points adjacent to the boundary using the boundary line adaptation criteria, the effective points inside the boundary and the effective points adjacent to the boundary are obtained.

[0035] The effective points inside the boundary and the effective points adjacent to the boundary are integrated and collected to obtain the global constraint benchmark point set.

[0036] Preferably, the initial triangulation is obtained by continuously stitching together a set of global constraint reference points, specifically including the following steps:

[0037] A closed boundary grid is constructed using the boundary proximity points of the global constraint reference point set and the outline of the earthwork volume calculation range.

[0038] Based on the spatial adjacency of the points, various reference points are sequentially connected within the closed boundary grid to obtain the initial triangulation.

[0039] Preferably, a soil layer thickness triangulation is constructed using all borehole points on the map as vertices and the soil layer thickness at each borehole point as elevation values. This specifically includes the following steps:

[0040] Using all borehole points as vertices and continuous triangular units based on the thickness of the soil layer at each borehole point, a preliminary global soil layer grid structure is formed.

[0041] Using the regional outline boundary as a constraint, the preliminary soil layer grid structure is trimmed and its shape is corrected to obtain a soil layer thickness triangular mesh.

[0042] Preferably, determining the spatial attribution status of a reference point relative to its boundary line based on relative positional relationships specifically includes the following steps:

[0043] The comparison results are obtained by comparing the relative positions of the reference points with the boundary lines.

[0044] The verification results are obtained by verifying the spatial fit of the benchmark points based on the comparison results.

[0045] Based on the verification results, the spatial morphology of different points is divided to obtain the spatial ownership status of the benchmark point relative to the boundary line.

[0046] Compared with the prior art, the present invention has the following beneficial effects:

[0047] This invention achieves bidirectional fusion of surface topographic data and underground layered strata data. It inputs the original surface elevation recorded from topographic points and the multi-layered soil thickness data stored from borehole points. Based on the soil layer thickness triangulation, it extracts the overall soil layer thickness values, ultimately outputting the total excavation and fill volume for the entire site and the corresponding excavation and fill volume for each soil layer. This directly matches the on-site business needs of layered excavation and layered settlement pricing, effectively reducing the manual operation time for earthwork calculation. The invention sequentially completes multiple screening processes, including contour boundary extraction, determination of the relative boundary position of points, and point validity verification. Only compliant points within the boundary and points adjacent to the boundary are retained to build the initial triangulation, effectively avoiding the problem of extending outwards beyond the calculation range, reducing the calculation error of earthwork values, and finally outputting complete engineering quantity data including unit details and global totals, improving the overall efficiency of engineering measurement work. Attached Figure Description

[0048] Figure 1 This is a flowchart illustrating a method for calculating the volume of earthwork in a stratum based on multi-borehole point layered data, as provided in an embodiment of the present invention.

[0049] Figure 2 This is a flowchart illustrating the process of obtaining the contour boundary condition in a method for calculating the earthwork volume of a stratum based on multi-drill point layered data, as provided in an embodiment of the present invention. Detailed Implementation

[0050] To make the above-mentioned objects, features and advantages of the present invention more apparent and understandable, the specific embodiments of the present invention will be described in detail below with reference to the accompanying drawings.

[0051] Many specific details are set forth in the following description in order to provide a full understanding of the invention. However, the invention may also be practiced in other ways different from those described herein, and those skilled in the art can make similar extensions without departing from the spirit of the invention. Therefore, the invention is not limited to the specific embodiments disclosed below.

[0052] Secondly, the term "an embodiment" or "embodiment" as used herein refers to a specific feature, structure, or characteristic that may be included in at least one implementation of the present invention. The phrase "in one embodiment" appearing in different places in this specification does not necessarily refer to the same embodiment, nor is it a single embodiment or an embodiment selectively excluded from other embodiments.

[0053] Reference Figures 1-2 As shown.

[0054] The embodiments further illustrate the method for calculating the volume of soil in strata based on multi-drill point layered data proposed in this invention.

[0055] A method for calculating the volume of soil in a stratum based on multi-borehole point layered data includes the following steps:

[0056] Acquire borehole point data and topographic point data for the engineering area;

[0057] Construction surveyors set up boreholes and survey points as topographic points within the site to be surveyed. Using drilling equipment, they drilled into the ground to determine the distribution of different soil layers. At each borehole, three sets of planar spatial values ​​and two types of vertical strata values ​​were recorded simultaneously. The three sets of planar spatial values ​​were the horizontal and vertical coordinates of the point. The two types of vertical values ​​were the original natural ground elevation at the point's location and the designed ground elevation after site completion. The thickness of each soil layer was also recorded. For example, borehole number 1 in the site has a horizontal coordinate of 3250 meters, a vertical coordinate of 4160 meters, a natural ground elevation of 28.6 meters, a designed ground elevation of 26.2 meters after site completion, a first layer of silty clay thickness of 3.4 meters, and a second layer of sand thickness of 5.1 meters. All the numerical information for this borehole point is categorized as borehole data.

[0058] Surveyors use total stations or UAVs to scan and collect information on the undulations of the site's surface. For each topographic point, three values ​​are recorded: horizontal plane coordinates, vertical plane coordinates, and the natural ground elevation. For example, a typical topographic point in the site has a horizontal plane coordinate of 3242 meters, a vertical plane coordinate of 4155 meters, and a natural ground elevation of 28.8 meters. The topographic point data collected by the surveying equipment is classified as topographic point data.

[0059] Integrate borehole point data and topographic point data within the earthwork volume calculation range to form a global benchmark point set;

[0060] The site boundary range corresponding to this earthwork volume calculation is defined. The horizontal and vertical plane coordinates of all borehole points and topographic points are retrieved. The point selection operation is completed by comparing with the pre-defined site coordinate range. Only borehole points and topographic points whose two plane coordinates fall within the calculation site range are retained.

[0061] Data normalization processing is carried out on the selected and retained valid points to standardize the data storage format of each point. All retained points record their own horizontal plane coordinate values ​​and vertical plane coordinate values. The selected and retained borehole points retain their own design ground elevation values ​​and the thickness values ​​of each underground soil layer. The selected and retained topographic points retain their own natural ground elevation values. All valid points after coordinate screening and format normalization processing are combined into a global reference point set.

[0062] For example, there were a total of 62 original borehole locations and 115 original topographic locations. After screening the locations against the site's calculated coordinate range, 12 borehole locations whose planar coordinates exceeded the site's boundaries were removed, along with 27 topographic locations whose planar coordinates also exceeded the site's boundaries. This left 50 valid borehole locations and 88 valid topographic locations, totaling 138 valid locations after normalization. These 138 locations together form the global reference point set corresponding to this earthwork volume calculation. The global reference point set is the data carrier for determining the site's outline boundary, distinguishing the spatial relative positions of the locations and the site boundary, and building the initial triangular mesh model.

[0063] The outline boundary condition of the earthwork volume calculation range is determined based on the set of effective reference points across the entire region, specifically including the following steps:

[0064] Extract the spatial distribution range of the effective benchmark point set across the entire region, and determine the basic delineation area for earthwork volume calculation based on the spatial distribution range.

[0065] The system reads the horizontal and vertical plane coordinates of all points within the global set of valid reference points. It then extracts the maximum, minimum, maximum, and minimum values ​​of the horizontal and vertical coordinates of all points, combining them to form a rectangular region enclosing the point distribution. This rectangular region represents the spatial distribution range corresponding to the global set of valid reference points. For example, a site might have 138 valid reference points. The minimum horizontal coordinate value is 3240 meters, the maximum is 3290 meters, the minimum is 4150 meters, and the maximum is 4205 meters. The rectangular area enclosed by these four values ​​represents the spatial distribution range of this point set. This rectangular spatial distribution range is directly used as the basic delineation area for earthwork volume calculation. This basic delineation area serves as a preliminary constraint on the site dimensions, quickly filtering out invalid spaces too far from the point group and reducing the spatial range that needs to be processed in boundary calculations.

[0066] Select valid reference points located at the edge of the basic delineation area and use these valid reference points as the basic units for boundary definition.

[0067] Within the rectangular space of the defined area, the differences between the horizontal and vertical coordinates of each valid reference point and the extreme coordinates of the defined area are compared to determine the spatial location of the point. If the difference between the horizontal coordinate value and the minimum horizontal coordinate value is less than 5 meters, or the difference between the horizontal coordinate value and the maximum horizontal coordinate value is less than 5 meters, or the difference between the vertical coordinate value and the minimum vertical coordinate value is less than 5 meters, or the difference between the vertical coordinate value and the maximum vertical coordinate value is less than 5 meters, then the point is determined to be at the edge of the defined area. For example, if the extreme horizontal coordinates of the defined area are 3240 meters and 3290 meters, and the extreme vertical coordinates are 4150 meters and 4205 meters, and the horizontal coordinate of a certain valid reference point is 3243 meters, the difference between this value and the minimum horizontal coordinate value of 3240 meters is 3 meters. Since 3 meters is less than the set threshold of 5 meters, this point is identified as a valid reference point at the edge. The valid reference points on the edge that have been identified and screened are marked as the boundary definition basic units. The boundary definition basic units are the smallest constituent elements of the closed edge line of the site. Each unit carries planar coordinate values, and the units are connected in an orderly manner by relying on the proximity of the coordinate values.

[0068] Based on the boundary definition of the basic unit, a closed edge line is formed, and the overall outline of the earthwork volume calculation range is formed by the closed edge line.

[0069] The planar coordinate values ​​corresponding to the boundary defining base units are retrieved. The planar straight-line distance between any two boundary defining base units is calculated by taking the square root of the square of the difference between the horizontal and vertical coordinates. Adjacent boundary defining base units are connected sequentially in ascending order of distance. The line segments generated by connecting units are called edge line segments. All edge line segments are connected end-to-end to form a closed edge line without breaks. For example, if 22 boundary defining base units are selected within the site, the planar straight-line distance between all pairs of units is calculated. Adjacent units with a distance of less than 10 meters are connected first, and the end-to-end connection of the 22 units is completed sequentially, ultimately generating a complete closed edge line surrounding the group of points. The closed edge line encloses a continuous closed area in planar space. This closed area is the overall outline corresponding to the earthwork calculation range. The overall outline can conform to the distribution of actual survey points on the site, which is different from the regular rectangular base demarcation area. It can eliminate blank corners in the base demarcation area without survey points, ensuring that earthwork calculation is only carried out for the site space supported by survey data.

[0070] The boundary condition of the earthwork volume calculation range is determined based on the extended shape and boundary orientation of the overall outline.

[0071] The entire closed edge line constituting the overall outline is read, and the extension shape and boundary direction of the overall outline are extracted. The curvature of different segments of the closed edge line is statistically analyzed to distinguish whether the outline belongs to a rectangular straight extension shape, an arc-shaped extension shape, or an irregular zigzag free extension shape. The lateral and longitudinal coordinate changes of each edge line segment are calculated segment by segment. The lateral coordinate change equals the lateral coordinate of the end point minus the lateral coordinate of the start point of the line segment, and the longitudinal coordinate change equals the longitudinal coordinate of the end point minus the longitudinal coordinate of the start point of the line segment. The inclination direction of a single edge line segment is determined based on the changes in these two coordinates. The direction information of all line segments is integrated to obtain the complete boundary direction information of the entire closed edge line. For example, the overall outline of this site includes 16 straight edge lines and 6 short zigzag edge lines. The extension shape of the overall outline is determined to be an irregular zigzag free extension shape. All edge line segments have east, northeast, north, and northwest directions, respectively. The identified extension shape information and boundary direction information are integrated and summarized to finally generate the outline boundary condition corresponding to the earthwork calculation range. The outline boundary condition records the geometric features of the site boundary and serves as the criterion for traversing reference points, comparing the coverage of points with the boundary, and determining the relative positional relationship between points and edge lines.

[0072] Determining the relative positional relationship between the concentrated reference points of the global effective reference points and the boundary lines based on the contour boundary conditions includes the following steps:

[0073] Extract the continuous edge trend and overall boundary coverage based on the contour boundary conditions;

[0074] The geometric information stored within the contour boundary is decomposed and analyzed to separate the continuous edge trend parameters and the overall boundary coverage parameters. When extracting the continuous edge trend, the complete closed edge is divided into multiple independent segments connected end-to-end. For each independent edge segment, the horizontal coordinates of the starting point, the vertical coordinates of the starting point, the horizontal coordinates of the ending point, and the vertical coordinates of the ending point are retrieved. The change in the horizontal coordinates of a single edge segment is calculated as follows: the change in the horizontal coordinates of the ending point = the change in the horizontal coordinates of the starting point; the change in the vertical coordinates of a single edge segment is calculated as: the change in the vertical coordinates of the ending point = the change in the vertical coordinates of the starting point. The positive or negative values ​​of these two coordinate changes are used to determine the spatial direction of the single edge segment. The directions of all segmented edge segments are recorded sequentially according to the order of their connection. The integrated records of all directions constitute the continuous edge trend.

[0075] When extracting the overall boundary coverage, the horizontal and vertical coordinate values ​​corresponding to all vertices of the closed edge are collected. The maximum, minimum, maximum, and minimum values ​​of the horizontal and vertical coordinates of all vertices are then selected. These four extreme values ​​enclose a rectangular planar area, which represents the overall boundary coverage. All dimensions within this area are measured in meters. For example, if the closed edge of a site is broken down into 22 independent segments, the coordinate changes of each segment are calculated sequentially, and the direction of travel (east, northwest, north, and southwest) is identified. Connecting all these directions yields a continuous edge trend. Then, the coordinates of all edge vertexes are extracted, and the minimum horizontal coordinate value is 3240 meters, the maximum is 3290 meters, the minimum is 4150 meters, and the maximum is 4205 meters. The rectangular area enclosed by these four values ​​represents the overall boundary coverage of the site.

[0076] Based on the continuous edge trend, the reference points of the entire effective reference point set are traversed, and the fit between the reference points and the overall coverage of the boundary is compared one by one to obtain the comparison results.

[0077] Following the storage order of the points, the horizontal and vertical coordinate values ​​of each reference point within the set of valid reference points across the entire region are retrieved sequentially. For each reference point retrieved, a complete round of alignment comparison is performed. First, a point's location within a defined interval is determined. The horizontal coordinate value of the current reference point is compared to the horizontal extreme value of the overall boundary coverage area. Simultaneously, the vertical coordinate value of the point is compared to the vertical extreme value of the overall boundary coverage area. If the horizontal coordinate value of a point is greater than or equal to the minimum horizontal value, and less than or equal to the maximum horizontal value, and the vertical coordinate value is greater than or equal to the minimum vertical value, and less than or equal to the maximum vertical value, then the point is determined to fall within the rectangular interval of the overall boundary coverage area. Points that do not meet these constraints are directly determined to fall outside the coverage area.

[0078] The process of determining the degree of alignment between a reference point and the boundary line uses the continuous boundary line trend as the calculation benchmark. It searches for the closest closed boundary line segment to the current reference point, calculates the straight-line distance between the reference point and this boundary line segment, calculates the difference between the horizontal coordinate of the reference point and the horizontal coordinate of the boundary line segment vertex and squares it, then calculates the difference between the vertical coordinate of the reference point and the vertical coordinate of the boundary line segment vertex and squares it. The two sets of squared values ​​are added together and the square root of the sum is taken to obtain the final distance value. The unit of measurement for the distance value is meters. A preset threshold of 10 meters is used for the alignment judgment. If the straight-line distance value is less than or equal to 10 meters, it means that the degree of alignment between the reference point and the boundary line is high. If the straight-line distance value is greater than 10 meters, it means that the degree of alignment between the reference point and the boundary line is low.

[0079] The system integrates three types of information: the location's interval assignment result, the straight-line distance from the location to the edge line, and the degree of fit of the location, to generate the comparison result for the benchmark location. For example, if the effective benchmark point set for the entire site contains 138 benchmark locations, the coordinate data of each location is retrieved iteratively for comparison. Taking one benchmark location as an example, its horizontal coordinate value is 3245 meters and its vertical coordinate value is 4162 meters. Both coordinate values ​​fall within the extreme range of the overall boundary coverage area, so the initial judgment of interval assignment is that it is within the interval. The calculated straight-line distance of this location from the nearest edge line segment is 6 meters. Since 6 meters is less than the preset fit threshold of 10 meters, the fine judgment of fit is that the fit is high. The two judgments are integrated to generate the complete comparison result for this location.

[0080] The relative positional relationship between the benchmark point and the boundary line is determined based on the comparison results.

[0081] Based on the multiple judgment data stored within the comparison results, the relative positional relationship between the reference point and the boundary line is determined. After retrieving the complete comparison results of a single reference point, a two-layer progressive logic is used to qualitatively classify the relative positional relationship. The first layer of logic relies on the point interval attribution information in the comparison results to complete the basic classification. If the comparison results record that the reference point does not fall within the rectangular interval of the overall boundary coverage, the relative positional relationship between the reference point and the boundary line is determined to be outside the boundary. If the comparison results record that the reference point falls within the rectangular interval of the overall boundary coverage, the second layer of refined judgment logic is initiated. The second layer of logic relies on the straight-line distance value from the point to the boundary line recorded within the comparison results to complete the classification. A 10-meter fit judgment threshold is used as the classification standard. When the straight-line distance value from the point to the boundary line is less than or equal to 10 meters, the relative positional relationship between the reference point and the boundary line is determined to be adjacent to the inner side of the boundary. When the straight-line distance value from the point to the boundary line is greater than 10 meters, the relative positional relationship between the reference point and the boundary line is determined to be the center of the inner side of the boundary.

[0082] The relative positional relationship labels are marked for the current benchmark points. The labels are divided into three categories: outside the boundary, adjacent to the inside of the boundary, and center of the inside of the boundary. Each point's label is simultaneously bound to the point's horizontal and vertical coordinate values. The comparison result of one benchmark point in the site shows that the point falls within the coverage area, and the straight-line distance from the point to the edge line is equal to 6 meters. Since 6 meters meets the threshold condition of less than or equal to 10 meters, the relative positional relationship of this point is determined to be adjacent to the inside of the boundary. The comparison result of another benchmark point in the site shows that the point falls within the coverage area, and the straight-line distance from the point to the edge line is equal to 35 meters. Since 35 meters exceeds the threshold condition of 10 meters, the relative positional relationship of this point is determined to be center of the inside of the boundary. There is also a benchmark point in the site that shows that the horizontal coordinate value of the point is equal to 3230 meters. This value is less than the minimum horizontal value of 3240 meters for the overall coverage area of ​​the boundary. The initial judgment of the interval assignment result is that it is outside the interval, and this point is directly determined to be outside the boundary.

[0083] Distinguishing between points inside the boundary and points adjacent to the boundary based on their relative positions involves the following steps:

[0084] Determining the spatial attribution of a benchmark point relative to its boundary line based on relative positional relationships involves the following steps:

[0085] The comparison results are obtained by comparing the relative positions of the reference points with the boundary lines.

[0086] The system sequentially retrieves the horizontal and vertical coordinates of each reference point within the entire region, along with the vertex coordinates of all segments of the closed boundary line. For the currently used reference point, it searches for the closest single-segment boundary line segment to that point. Then, it calculates the vertical distance from the reference point to this segment: Horizontal coordinate difference = Horizontal coordinate of reference point - Horizontal coordinate of the midpoint of the boundary line segment; Vertical coordinate difference = Vertical coordinate of reference point - Vertical coordinate of the midpoint of the boundary line segment. The square of the horizontal coordinate difference = Horizontal coordinate difference × Horizontal coordinate difference; the square of the vertical coordinate difference = Vertical coordinate difference × Vertical coordinate difference; the square of the distance = Square of the horizontal coordinate difference + Square of the vertical coordinate difference. Finally, the vertical distance is obtained by taking the square root. After completing the distance calculation, two auxiliary comparison information items are recorded. The first item is whether the benchmark point falls within the site outline enclosed by the closed edge line. The second item is the direction of the continuous edge line corresponding to the nearest edge line segment. The distance value, the information on the inside and outside of the outline, and the edge line direction information are integrated to form the comparison result corresponding to the benchmark point. For example, the horizontal coordinate of a certain benchmark point is 3245 meters and the vertical coordinate is 4162 meters. The horizontal coordinate of the midpoint of the nearest edge segment is 3240 meters and the vertical coordinate of the midpoint is 4160 meters. The difference in horizontal coordinates is 3245-3240=5 meters and the difference in vertical coordinates is 4162-4160=2 meters. The square of the difference in horizontal coordinates is 5×5=25 square meters and the square of the difference in vertical coordinates is 2×2=4 square meters. The square of the distance is 25+4=29 square meters. Taking the square root of 29 square meters, the vertical distance is approximately 5.39 meters. At the same time, it is identified that the benchmark point is located inside the site outline and the direction of the nearest edge segment is due east. The distance, the location within the outline, and the due east direction are combined to generate a complete comparison result for the benchmark point.

[0087] The verification results are obtained by verifying the spatial fit of the benchmark points based on the comparison results.

[0088] An 8-meter threshold is pre-set as the fit threshold between the reference point and the boundary line. A dual-judgment logic is used to verify the spatial fit. The first judgment logic reads the boundary information. If the comparison result shows that the reference point is outside the boundary, it is directly determined that there is no spatial fit between the reference point and the boundary line. If the comparison result shows that the reference point is inside the boundary, the second distance threshold judgment process is initiated. The vertical distance value is compared with the 8-meter fit threshold. When the vertical distance value is less than or equal to 8 meters, the reference point and the boundary line are determined to have a high degree of spatial fit. When the vertical distance value is greater than 8 meters, the reference point and the boundary line are determined to have only a low degree of spatial fit. The verification result for the benchmark point is formed by integrating the contour attribution conclusion, the vertical distance value, and the spatial fit level. For example, if the vertical distance value of the point is 5.39 meters, since 5.39 meters is less than the set 8-meter fit threshold, and the point is attributable to the interior of the site contour, the spatial fit of the point is determined to be high fit. The interior of the contour, 5.39 meters, and high fit are integrated to generate the corresponding verification result.

[0089] Based on the verification results, the spatial morphology of different points is divided to obtain the spatial ownership status of the benchmark points relative to the boundary lines.

[0090] Based on the contour attribution information and spatial fit level within the verification results, three spatial attribution states are classified. The first spatial attribution state is for points outside the boundary, and the corresponding judgment condition is that the point recorded in the verification result is outside the site contour, regardless of the distance from the point to the edge line. The second spatial attribution state is for adjacent points inside the boundary, and the corresponding judgment condition is that the point recorded in the verification result is inside the site contour, and the spatial fit level is high fit. The third spatial attribution state is for the center point inside the boundary, and the corresponding judgment condition is that the point recorded in the verification result is inside the site contour, and the spatial fit level is low fit. For each reference point, a corresponding spatial attribution status label is matched. The label and the planar coordinate value of the point are bound together. After all points have completed label matching, a complete spatial attribution status dataset is generated. For example, the first point inside the contour with a planar vertical distance of 5.39 meters is marked as highly aligned in the verification result, and its spatial attribution status is a nearby point inside the boundary; the second point inside the contour with a planar vertical distance of 16 meters is marked as poorly aligned in the verification result, and its spatial attribution status is a center point inside the boundary; the third reference point outside the contour is marked as a point outside the boundary. The spatial location attributes of all reference points are distinguished.

[0091] Based on the spatial attribution status, the reference points located inside the contour boundary are selected to obtain the points inside the boundary.

[0092] The spatial attribution status tags bound to each benchmark point across the entire area are retrieved. These spatial attribution statuses are categorized as external boundary points, adjacent points inside the boundary, and central points inside the boundary. If a benchmark point's spatial attribution status does not belong to the external boundary point category, that point is included in the internal boundary point set. The total number of internal boundary points equals the sum of the number of adjacent points inside the boundary and the number of central points inside the boundary. For example, if a site has a total of 138 valid benchmark points, after preliminary spatial attribution determination, 20 external boundary points, 22 adjacent points inside the boundary, and 96 central points inside the boundary are identified. The total number of internal boundary points is 22 + 96 = 118. The 20 external boundary points are automatically removed, and the remaining 22 adjacent points inside the boundary and 96 central points inside the boundary are all collected and included, forming a set of 118 internal boundary points. The set of points within the boundary completely covers all points with survey data within the earthwork calculation outline. The set includes points near the boundary line and points in the central area of ​​the site, and can fully carry all sampling information of the surface, topography and underground soil layers within the site.

[0093] Based on the spatial attribution status, reference points located inside the contour boundary and conforming to the boundary direction are selected to obtain the boundary-adjacent points.

[0094] The screening process requires retrieving two types of preliminary data. The first type of data is the spatial attribution status label of the benchmark point, and the second type of data is the vertical plane distance value from each point to the nearest boundary line segment. The entire screening process is divided into two progressive judgment conditions. The first-level judgment condition constrains the spatial attribution attribute of the point. Only benchmark points whose spatial attribution status is equal to the adjacent points inside the boundary can enter the second-level judgment process. The second-level judgment condition verifies the degree of fit between the point and the boundary line. An 8-meter threshold is preset as the boundary line fit judgment threshold. The result of the point boundary line fit judgment is that the vertical distance value from the point to the boundary line is less than or equal to 8 meters. When the vertical distance value of the point satisfies this equation, it means that the point fits the boundary direction and can be included in the set of adjacent points of the boundary. If the vertical distance value does not meet the requirement, even if the point belongs to the adjacent points inside the boundary, it is also removed. For example, the candidate points are 22 adjacent points inside the boundary selected by the first layer of operation. The vertical distance values ​​of each of the 22 points are retrieved one by one for verification. The vertical distance values ​​of 21 points are 5.39 meters, 6.12 meters, 7.45 meters, etc., all of which are less than 8 meters. They all meet the equation conditions corresponding to the edge line fitting judgment result. The vertical distance value of the remaining point is 9 meters. Since the equation that 9 meters is less than or equal to 8 meters cannot be true, this point is directly eliminated. The total number of adjacent points inside the boundary = the number of adjacent points inside the boundary that pass both levels of judgment conditions. The total number of adjacent points inside the boundary = 21. The 21 points are uniformly collected and summarized to form a set of adjacent points inside the boundary. All points within the boundary proximity point set are distributed close to the closed edge of the site outline. The planar coordinate values ​​of the points are highly matched with the direction of the boundary edge, forming the basic unit for building a closed boundary grid. The grid boundary is built based on the points within this set, ensuring that the outer contour of the generated triangular network completely coincides with the contour of the pre-defined earthwork calculation range, and preventing the grid boundary from deviating from the actual survey range.

[0095] The global constraint reference point set is obtained based on the points inside the boundary and the points adjacent to the boundary, specifically including the following steps:

[0096] By verifying the points inside the boundary and the points adjacent to the boundary using the boundary line adaptation criteria, the effective points inside the boundary and the effective points adjacent to the boundary are obtained.

[0097] The boundary line adaptation criteria internally employ two independent decision-making logics. These logics adapt to points within the boundary and points adjacent to the boundary, respectively. The adaptation decision-making logic for points within the boundary involves verifying the site outline coordinate range. It pre-retrieves the minimum and maximum horizontal coordinates, minimum and maximum vertical coordinates of the outline within the earthwork calculation range. Then, it sequentially retrieves the horizontal and vertical coordinate values ​​of each point within the boundary. The outline range adaptation decision equation is: the horizontal coordinate of the point is greater than or equal to the minimum horizontal coordinate of the outline, and the horizontal coordinate of the point is less than or equal to the maximum horizontal coordinate of the outline. The vertical coordinate of the point is greater than or equal to the minimum vertical coordinate of the outline, and the vertical coordinate of the point is less than or equal to the maximum vertical coordinate of the outline. When the coordinate values ​​of a point within the boundary fully satisfy this decision equation, the point is determined to be a valid point within the boundary. If any coordinate value exceeds the extreme value range of the outline, the point is directly marked as an invalid point and removed from the dataset. The total number of valid points within the boundary equals the number of points within the entire boundary that satisfy the outline range adaptation decision equation. The adaptation judgment logic for boundary proximity points involves verifying the boundary line fitting distance. It retrieves the planar coordinates of a single boundary proximity point, searches for the closest single-segment boundary line segment to that point within the entire closed contour line, and then calculates the coordinate difference between the point and the midpoint of the segment. The horizontal coordinate difference is calculated as: Horizontal coordinate difference = Horizontal coordinate of the boundary proximity point - Horizontal coordinate of the midpoint of the segment; Vertical coordinate difference = Vertical coordinate of the boundary proximity point - Vertical coordinate of the midpoint of the segment; Squared distance = Horizontal coordinate difference × Horizontal coordinate difference + Vertical coordinate difference × Vertical coordinate difference; Planar vertical distance = Square root of the squared distance. A pre-set threshold of 9 meters is used for the adaptation distance of boundary proximity points. The boundary line fitting adaptation judgment equation is: Planar vertical distance less than or equal to 9 meters. Boundary proximity points satisfying this equation are judged as valid boundary proximity points. Points with a plane vertical distance exceeding the 9-meter threshold are directly discarded. The total number of valid boundary proximity points equals the number of points among all boundary proximity points that satisfy the boundary line fitting adaptation judgment equation. For example, after preliminary screening, a site has a total of 118 points inside the boundary and 21 points adjacent to the boundary. The minimum horizontal coordinate of the earthwork calculation outline of the site is 3240 meters, the maximum horizontal coordinate is 3290 meters, the minimum vertical coordinate is 4150 meters, and the maximum vertical coordinate is 4205 meters. The system traverses all 118 points inside the boundary to complete the outline interval verification. Among them, the horizontal and vertical coordinates of 116 points all fall within the interval formed by the four extreme coordinates, which fully meets the outline interval fitting judgment equation. The vertical coordinate of the remaining 2 points is 4208 meters, which is greater than the maximum vertical coordinate of the outline of 4205 meters, and cannot meet the judgment equation. Therefore, these 2 points are directly removed. After substituting the corresponding values ​​into the statistical formula, the total number of valid points inside the boundary is 116.

[0098] Continue iterating through the 21 boundary proximity points, calculating the vertical distance to each point. The vertical distances to 19 points are 4.2 meters, 6.7 meters, and 8.1 meters, respectively, all satisfying the boundary fit matching equation (vertical distance <= 9 meters). The remaining two points have vertical distances of 10.3 meters and 11.6 meters, exceeding the preset distance threshold and therefore not satisfying the equation. These two points are then removed, leaving a total of 19 valid boundary proximity points. After completing the fitting verification for all points, the complete coordinates, elevations, and soil thickness data of the 116 valid points inside the boundary and the 19 valid boundary proximity points are stored separately.

[0099] The effective points inside the boundary and the effective points adjacent to the boundary are integrated and collected to obtain the global constraint benchmark point set.

[0100] First, a duplicate point identification and removal operation is performed. Valid points near the boundary are themselves a subset of valid points within the boundary. There are a large number of duplicate points stored within the two valid point datasets. Duplicate points are identified based on the planar coordinate values ​​of the points. The duplicate point determination equation is: the horizontal coordinate of the first point equals the horizontal coordinate of the second point, and the vertical coordinate of the first point equals the vertical coordinate of the second point. When the horizontal and vertical coordinate values ​​of the two points are all equal, the two points are determined to be the same survey point. Only a single complete point data is retained, and duplicate point copies stored within the dataset are deleted.

[0101] After removing duplicates, all valid points are sorted in ascending order of their horizontal coordinate values. Simultaneously, the natural elevation, design elevation, and soil thickness of each point are retained. Once all points are organized, they are combined to generate a global constraint benchmark set. The total number of global constraint benchmark points equals the total number of valid points within the boundary plus the total number of valid points adjacent to the boundary minus the total number of duplicate points. For example, if the total number of valid points within the site boundary is 116, and the total number of valid points adjacent to the boundary is 19, there are 19 completely overlapping duplicate points between the two datasets. Substituting all values ​​into the statistical formula, the total number of global constraint benchmark points is calculated to be 116 + 19 - 19 = 116. After removing duplicate points, 116 valid benchmark points without duplicates remain. All points are then uniformly sorted and organized to generate the global constraint benchmark set for the site.

[0102] All points within the global constraint benchmark set have been double-verified by the boundary line adaptation criterion. It includes complete topographic and stratum sampling points in the central area of ​​the site, which can provide sufficient data support for filling the internal area of ​​the triangular mesh. It also retains constraint points that fit the closed boundary line of the site outline, which can control the outer boundary shape of the subsequent triangular mesh to completely coincide with the earthwork calculation range outline, avoiding the calculation defects of the triangular mesh exceeding the survey range.

[0103] The initial triangulation is obtained by continuously stitching together a set of global constraint reference points, specifically including the following steps:

[0104] A closed boundary grid is constructed using the boundary proximity points of the global constraint reference point set and the outline of the earthwork volume calculation range.

[0105] The horizontal coordinate difference is calculated as follows: horizontal coordinate of adjacent boundary points - horizontal coordinate of the midpoint of the edge segment. The vertical coordinate difference is calculated as follows: vertical coordinate of adjacent boundary points - vertical coordinate of the midpoint of the edge segment. The square of the point-edge spacing is calculated as follows: horizontal coordinate difference × horizontal coordinate difference + vertical coordinate difference × vertical coordinate difference. The planar fitting distance is calculated by taking the square root of the square of the point-edge spacing. A threshold of 7 meters is pre-set for binding the point-edge. The corresponding fitting judgment equation is that the planar fitting distance is less than or equal to 7 meters. Only when the planar fitting distance of adjacent boundary points meets this judgment equation will the point be bound to the corresponding contour edge segment. Points that do not meet the equation are temporarily suspended and do not participate in the boundary mesh construction.

[0106] After all boundary adjacent points are bound to the edge line segments, the continuous direction information of the entire outline edge line is read. The bound boundary adjacent points are arranged in the order of east, northeast, north, and northwest. Boundary grid segments are generated between two adjacent bound boundary adjacent points. After all points are connected in pairs, a closed line segment is generated between the last boundary adjacent point in the sequence and the first boundary adjacent point in the sequence. After all boundary grid segments are connected end to end, a complete closed boundary grid without gaps is formed.

[0107] For example, the set of global constraint reference points for a certain site contains 19 valid boundary adjacent points. The outline of the earthwork volume calculation range of the site is divided into 22 independent boundary segments by the system. The plane fitting distances corresponding to the 19 boundary adjacent points are calculated. The plane fitting distance values ​​of all points are distributed in the range of 2.1 meters to 6.8 meters. All values ​​meet the fitting judgment equation that the plane fitting distance is less than or equal to 7 meters. All 19 points are successfully bound to the corresponding outline segments. Following the complete direction of the outline, 19 adjacent boundary points are sorted. 19 basic boundary grid segments are generated between adjacent points. Then, a closed line segment is added between the last point and the first point, bringing the total number of closed boundary grid segments to 19 + 1 = 20. These 20 segments enclose each other to form a complete closed boundary grid. The outer contour of this grid completely coincides with the outline of the site's earthwork calculation area, which can geometrically constrain the maximum extension range of the triangular network and prevent the triangular units generated by the internal network from exceeding the pre-defined earthwork calculation area.

[0108] Based on the spatial adjacency relationship of the points, various reference points are sequentially connected within the closed boundary grid to obtain the initial triangulation;

[0109] The horizontal spacing difference = horizontal coordinate of the first reference point - horizontal coordinate of the second reference point; the vertical spacing difference = vertical coordinate of the first reference point - vertical coordinate of the second reference point; the square of the point spacing = horizontal spacing difference × horizontal spacing difference + vertical spacing difference × vertical spacing difference; the planar spacing of the points = square root of the square of the point spacing. Extract any boundary grid segment from the closed boundary grid as the initial starting edge. Traverse all reference points within the closed grid that have not yet participated in the network formation, calculate the planar spacing between this point and the two endpoints of the starting edge, and select the reference point with the smallest sum of the two spacing values. Generate two connecting line segments between this reference point and the two endpoints of the starting edge. These two new line segments and the original starting edge together form a triangular element. The sides of newly generated triangular cells that do not conform to the closed boundary mesh are used as new starting edges. The entire process of adjacent point selection, line segment connection, and triangular cell generation is repeated, continuously filling the central region of the closed boundary mesh with triangular cells. This cycle continues until all global constraint reference points within the closed boundary mesh are connected by line segments, and there are no isolated or unconnected reference points. The entire planar space within the closed mesh is completely filled with triangular cells. At this point, all triangular cells are continuously spliced ​​together to form a complete initial triangular mesh. The total number of triangles in the initial triangular mesh = the total number of line segments in the closed boundary mesh + the total number of reference points to be networked within the mesh - 2. For example, if the total number of closed boundary grid segments for the site is 20, and excluding 19 boundary-adjacent points within the global constraint reference point set, there are 97 remaining internal site reference points awaiting network formation, the initial triangulation triangle has a total of 20 + 97 - 2 = 115 triangles. Following the adjacency determination rule of increasing planar spacing between points, the line segments of all 97 internal reference points are connected, ultimately generating 115 continuous, seamless, and non-overlapping triangular units. The outer edges of all triangular units completely fit the first layer of the closed boundary grid, and the interior completely covers all verified survey reference points within the site. The initial triangulation stores the planar coordinate values ​​corresponding to each triangulation vertex, enabling the reconstruction of the planar distribution of points within the engineering site.

[0110] A triangulation network of soil layer thickness is constructed using all borehole points on the map as vertices and the thickness of the soil layer at each borehole point as the elevation value. This process includes the following steps:

[0111] Using all borehole points as vertices and continuous triangular units based on the thickness of the soil layer at each borehole point, a preliminary global soil layer grid structure is formed.

[0112] Two planar coordinates of the borehole points are used as planar positioning parameters for the grid vertices, and the soil thickness is equivalent to the vertical elevation parameter corresponding to the grid vertex, thus constructing grid vertices that possess both planar position and thickness attributes. A standardized planar spacing calculation formula is used to determine whether two borehole points are spatially adjacent: lateral coordinate difference = lateral coordinate of the first borehole point - lateral coordinate of the second borehole point; longitudinal coordinate difference = longitudinal coordinate of the first borehole point - longitudinal coordinate of the second borehole point; squared borehole point spacing = lateral coordinate difference × lateral coordinate difference + longitudinal coordinate difference × longitudinal coordinate difference; and planar borehole spacing = square root of the squared borehole point spacing. A threshold of 15 meters is pre-set for borehole point adjacency determination, with the corresponding adjacency determination equation being that the planar borehole spacing is less than or equal to 15 meters. Only when the calculated planar borehole spacing values ​​of two borehole points satisfy this determination equation are the two points considered spatially adjacent, allowing the generation of connecting line segments between the two points to participate in triangular element splicing. A borehole point is randomly selected as the initial vertex for the network. All other borehole points in the site that are not part of the network are traversed. The borehole plane distance between each point and the initial vertex is calculated one by one. Two adjacent borehole points with the smallest distance from the initial vertex are selected. Connecting line segments are generated between the three borehole points. The three line segments enclose the first complete soil triangular unit. The two sides of this new triangular unit that are not attached to the existing grid boundary are extracted as new starting edges. The entire process of traversing unnetworked borehole points, calculating borehole plane distance, selecting adjacent points, and splicing to generate new triangular units is repeated. Triangular units are continuously filled into the blank areas of the grid. The operation is repeated until all borehole points in the entire site are connected to the grid system and there are no isolated borehole points without connecting line segments. At this time, all triangular units are spliced ​​end to end, completely covering the planar distribution range of all borehole points, thus generating a preliminary global soil grid structure.

[0113] The total number of preliminary grid triangular units = the total number of valid boreholes on the entire map - 2. For a certain earthwork survey site, there are a total of 50 valid boreholes on the entire map. The total number of preliminary grid triangular units = 50 - 2 = 48. The coordinate values ​​of any two boreholes are retrieved sequentially to complete the planar distance calculation. Taking boreholes numbered 1 and 2 on the site as examples, borehole number 1 has a horizontal coordinate of 3240 meters and a vertical coordinate of 4150 meters. Borehole number 2 has a horizontal coordinate of 3248 meters and a vertical coordinate of 4156 meters. The standard deviation is 3240-3248=-8 meters, the longitudinal coordinate difference is 4150-4156=-6 meters, the square of the borehole point spacing is (-8)×(-8)+(-6)×(-6)=100 square meters, and the borehole plane spacing is 10 meters. The adjacency determination equation is satisfied, and the two borehole points are determined by the system to be spatially adjacent points. They can be connected to each other to participate in the splicing of triangular units. The network calculation of all 50 borehole points is continuously completed, and finally a preliminary global soil layer grid structure composed of 48 continuous triangular units is generated.

[0114] Using the regional outline boundary as a constraint, the preliminary soil layer grid structure is trimmed and its shape is corrected to obtain a soil layer thickness triangular mesh;

[0115] The planar coordinates of each vertex of the initial soil layer mesh are extracted. Vertex affixation is determined based on the four extreme coordinates of the region's contour boundary. The contour interval determination equation is: the vertex's horizontal coordinate is greater than or equal to the minimum horizontal coordinate of the contour, the vertex's horizontal coordinate is less than or equal to the maximum horizontal coordinate of the contour, the vertex's vertical coordinate is greater than or equal to the minimum vertical coordinate of the contour, and the vertex's vertical coordinate is less than or equal to the maximum vertical coordinate of the contour. The number of vertices satisfying this determination equation within a single triangular unit is counted to classify triangular units into different attributes. The first category consists of three vertices that all satisfy the determination equation; these are considered completely internal triangular units and are retained without modification. The second category consists of three vertices that do not satisfy the determination equation; these are considered completely out-of-boundary triangular units and are removed from the mesh structure. The third category consists of only some vertices that satisfy the determination equation; these are considered cross-boundary triangular units and are marked for boundary trimming.

[0116] Retrieve all marked cross-boundary triangular elements, extract the planar coordinates of the two intersection points formed by the intersection of the three edges of the triangular element and the region contour edge, discard the planar area of ​​the triangular element outside the region contour edge, connect the two intersection points of the contour edge with the vertices of the triangular element inside the contour to generate small internal triangular elements, replace the original cross-boundary triangular elements with the small triangular elements, and complete the mesh boundary clipping operation.

[0117] Iterate through all the trimmed triangular elements, using a preset standard side length threshold of 15 meters. Identify any elongated, irregular triangular elements with a single side length greater than 15 meters. Search for the grid vertex within this irregular triangular element that is closest to the three sides. Add a dividing line segment inside the element, splitting the single elongated, irregular triangular element into two uniformly sized standard triangular elements. This eliminates the soil thickness interpolation calculation error caused by the irregular mesh structure. Count all remaining valid triangular elements. The total number of soil thickness triangular mesh elements = the number of fully internal triangular elements + the number of small triangular elements added by boundary trimming + the number of standard triangular elements added by shape correction splitting. For example, the minimum lateral coordinate of the site area is 3240 meters, the maximum lateral coordinate is 3290 meters, the minimum longitudinal coordinate is 4150 meters, and the maximum longitudinal coordinate is 4205 meters. The initial global soil layer grid contains 48 original triangular units. 39 completely internal triangular units are directly retained, 6 completely out-of-boundary triangular units are completely removed, and the remaining 3 cross-boundary triangular units enter the boundary trimming process. After the trimming operation, 6 small internal triangular units are added. 4 elongated and distorted triangular units are identified in the trimmed grid. The morphology correction process splits the 4 distorted units into 8 standard triangular units. The total number of soil layer thickness triangular network units = 39 + 6 + 8 = 53. All 53 triangular units are constrained within the plane bounded by the boundary line of the area. There are no outward-extending out-of-boundary grids, nor are there any elongated and distorted grids that would interfere with the interpolation accuracy.

[0118] The initial triangulation network is processed to obtain the natural elevation and the design elevation, specifically including the following steps:

[0119] The natural elevation of the corresponding corner points of the initial triangulation is obtained by interpolating the natural terrain points of the entire map.

[0120] Each natural terrain point records its lateral plane coordinates, longitudinal plane coordinates, and natural surface elevation. The lateral coordinate difference = lateral coordinates of the target triangulation corner point - lateral coordinates of the natural terrain point. The longitudinal coordinate difference = longitudinal coordinates of the target triangulation corner point - longitudinal coordinates of the natural terrain point. The square of the point spacing = lateral coordinate difference × lateral coordinate difference + longitudinal coordinate difference × longitudinal coordinate difference. The plane distance between two points = the square root of the calculated result of the square of the point spacing. The system automatically selects the six closest natural terrain points to the target triangulation corner as interpolation reference points. The weight of a single terrain point is calculated as 1 ÷ the plane distance between the two points. The weighted sum of natural elevations is calculated as: (1) natural elevation of the first reference terrain point × (1) weight of the first terrain point + (2) natural elevation of the second reference terrain point × (2) weight of the second terrain point + (3) natural elevation of the third reference terrain point × (3) weight of the third terrain point + (4) natural elevation of the fourth reference terrain point × (4) weight of the fourth terrain point + (5) natural elevation of the fifth reference terrain point × (5) weight of the fifth terrain point + (6) natural elevation of the sixth reference terrain point × (6) weight of the sixth terrain point. The total weight of all reference terrain points is calculated as: (1) weight of the first terrain point + (2) weight of the second terrain point + (3) weight of the third terrain point + (4) weight of the fourth terrain point + (5) weight of the fifth terrain point + (6) weight of the sixth terrain point. The natural elevation of the target corner is calculated as: (Total weighted natural elevation ÷ Total weight of all reference terrain points) For example, within an initial triangulation network, a corner point has a horizontal coordinate of 3252 meters and a vertical coordinate of 4165 meters. Six natural terrain points closest to this corner point are selected. Two of these points are chosen for calculation. The first natural terrain point has a horizontal coordinate of 3250 meters and a vertical coordinate of 4163 meters, with a natural elevation of 28.6 meters. Substituting these values ​​into the distance calculation formula, the horizontal coordinate difference is 3252 - 3250 = 2 meters, and the vertical coordinate difference is 4165 - 4163 = 2 meters. The square of the distance between the points is 2 × 2 + 2 × 2 = 8 square meters. The plane distance between the two points is approximately 2.83 meters, and the weight of a single terrain point is 1 ÷ 2.83 ≈ 0.353. The second natural terrain point... The horizontal coordinate is 3255 meters, the vertical coordinate is 4166 meters, and the natural elevation is 28.4 meters. The difference in horizontal coordinates is 3252-3255=-3 meters, and the difference in vertical coordinates is 4165-4166=-1 meter. The square of the distance between points is (-3)×(-3)+(-1)×(-1)=10 square meters. The plane distance between two points is approximately 3.16 meters. The weight of a single terrain point is 1÷3.16≈0.316. The distance, weight, and elevation product of the remaining 4 natural terrain points are calculated simultaneously. The weighted natural elevation is obtained by adding the 6 sets of elevation weight product values ​​and then dividing by the weight of the 6 terrain points. Finally, the natural elevation value corresponding to the corner point of the triangular network is obtained.

[0121] The design elevation of the corresponding corner points of the initial triangulation is obtained by interpolating the borehole points of the entire map.

[0122] Horizontal coordinate difference = Horizontal coordinate of target triangulation corner point - Horizontal coordinate of borehole point; Vertical coordinate difference = Vertical coordinate of target triangulation corner point - Vertical coordinate of borehole point; Square of point spacing = Horizontal coordinate difference × Horizontal coordinate difference + Vertical coordinate difference × Vertical coordinate difference; Planar distance between two points = Square root of the square of the point spacing. Select the 5 boreholes closest to the target triangulation corner as interpolation reference points. The weight of a single borehole point = 1 ÷ the plane distance between the two points. The total weight of all reference boreholes = weight of borehole 1 + weight of borehole 2 + weight of borehole 3 + weight of borehole 4 + weight of borehole 5. The total weighted design elevation = design elevation of borehole 1 × weight of borehole 1 + design elevation of borehole 2 × weight of borehole 2 + design elevation of borehole 3 × weight of borehole 3 + design elevation of borehole 4 × weight of borehole 4 + design elevation of borehole 5 × weight of borehole 5. The design elevation of the target corner point = total weighted design elevation ÷ total weight of all reference boreholes. The corner point has a horizontal coordinate of 3252 meters and a vertical coordinate of 4165 meters. Five closest borehole locations are selected, and one of these locations is chosen for calculation. This borehole location has a horizontal coordinate of 3251 meters and a vertical coordinate of 4164 meters, with a design elevation of 26.2 meters. The horizontal coordinate difference is 3252 - 3251 = 1 meter, and the vertical coordinate difference is 4165 - 4164 = 1 meter. The square of the distance between the points is 1 × 1 + 1 × 1 = 2 square meters. The plane distance between the two points is approximately 1.41 meters. The weight of a single borehole location is 1 ÷ 1.41 ≈ 0.709. The remaining four borehole locations are used for the final numerical calculation. The product of the five sets of elevation weights is added together and then divided by the total weight of all boreholes to obtain the design elevation value corresponding to the corner point of the triangulation.

[0123] The soil layer thickness at the corresponding corner point of the triangular mesh is obtained based on interpolation;

[0124] Extract the three borehole vertices of the soil triangular unit, defined as the first borehole vertex, the second borehole vertex, and the third borehole vertex, respectively. The areas of these three areas are denoted as the areas of the first sub-triangle, the second sub-triangle, and the third sub-triangle, respectively. The total area of ​​the soil triangular unit = the area of ​​the first sub-triangle + the area of ​​the second sub-triangle + the area of ​​the third sub-triangle. The thickness weight of the first vertex = the area of ​​the first sub-triangle ÷ the total area of ​​the soil triangular unit. The thickness weight of the second vertex = the area of ​​the second sub-triangle ÷ the total area of ​​the soil triangular unit. The thickness weight of the third vertex = the area of ​​the third sub-triangle ÷ the total area of ​​the soil triangular unit. The soil thickness at the target corner point = the soil thickness at the first borehole vertex × the thickness weight of the first vertex + the soil thickness at the second borehole vertex × the thickness weight of the second vertex + the soil thickness at the third borehole vertex × the thickness weight of the third vertex. The lateral coordinate of this corner point is equal to... At a depth of 3252 meters and a longitudinal coordinate of 4165 meters, the point is identified as falling within a triangular unit of the soil thickness triangulation network. The soil thickness values ​​at the three borehole vertices of this unit are 3.4 meters, 3.6 meters, and 3.2 meters, respectively. The areas of the three sub-triangles are calculated to be 12 square meters, 18 square meters, and 10 square meters, respectively. Substituting these values ​​into the total area calculation formula, the total area of ​​the soil triangular unit is 12 + 18 + 10 = 40 square meters. The thickness weights of the first vertex and third vertex are 12 ÷ 40 = 0.3, 18 ÷ 40 = 0.45, and 10 ÷ 40 = 0.25, respectively. The soil thickness at the target corner point is calculated as 3.4 × 0.3 + 3.6 × 0.45 + 3.2 × 0.25 = 1.02 + 1.62 + 0.8 = 3.44 meters. This gives the final soil thickness value corresponding to the corner point of the grid.

[0125] The process of processing natural elevation, design elevation, and soil layer thickness to generate engineering quantity data includes the following steps:

[0126] Traverse each triangular cell of the initial triangular network, obtain the average cut-and-fill depth based on the natural elevation and design elevation of the triangular cell, and obtain the total cut-and-fill volume based on the average cut-and-fill depth and cell area;

[0127] Following the triangular mesh storage order, each triangular unit is retrieved sequentially. Each triangular unit has three grid corner points. Each corner point stores the natural elevation value and the design elevation value obtained through interpolation calculation. The cut-fill height difference of each of the three corner points is extracted. The cut-fill height difference of a single point = natural elevation of the corner point - design elevation of the corner point. A positive cut-fill height difference value indicates that soil needs to be excavated at that point, and a negative value indicates that soil needs to be filled at that point. The average cut-fill depth of the unit = cut-fill height difference of the first corner point + cut-fill height difference of the second corner point + cut-fill height difference of the third corner point. The average cut-fill depth of the unit = average cut-fill depth of the unit ÷ 3. The planar area value of the triangular unit is retrieved. This area value is pre-calculated based on the horizontal and vertical coordinates of the three corner points of the unit, and the unit is square meters. The total cut-fill volume of a single unit = average cut-fill depth of the unit × planar area of ​​the triangular unit, and the unit of the total cut-fill volume is cubic meters.

[0128] A triangular unit contains three grid corner points. The natural elevation of the first corner point is 28.6 meters, and the design elevation is 26.2 meters. The difference in cut-fill elevation at this single point is 28.6 - 26.2 = 2.4 meters. The natural elevation of the second corner point is 28.4 meters, and the design elevation is 26.2 meters. The difference in cut-fill elevation at this single point is 28.4 - 26.2 = 2.2 meters. The natural elevation of the third corner point is 28.8 meters, and the design elevation is 26.2 meters. The difference in cut-fill elevation at this single point is 28.8 - 26.2 = 2.6 meters. The average cut-fill depth of the unit is 2.4 + 2.2 + 2.6, and the average cut-fill depth of the unit is 7.2 ÷ 3 = 2.4 meters. The plane area of ​​this triangular unit is 45 square meters. The total cut-fill volume of a single unit is 2.4 × 45 = 108 cubic meters. This value represents the total excavation volume of all soil within the triangular unit.

[0129] The volume of excavation and filling for each soil layer is obtained based on the soil layer thickness and the unit area.

[0130] The average thickness of a unit soil layer = the thickness of the soil layer at the first corner point + the thickness of the soil layer at the second corner point + the thickness of the soil layer at the third corner point. The average thickness of a unit soil layer = the average thickness of the unit soil layer ÷ 3. A layered cut-and-fill depth constraint rule is set: the effective layered cut-and-fill depth of a unit equals the average cut-and-fill depth of the unit. When the average thickness of a unit soil layer is less than the average cut-and-fill depth of the unit, the effective layered cut-and-fill depth of the unit equals the average thickness of the unit soil layer. This rule is used to constrain the upper limit of the calculated earthwork volume for each layer, preventing the volume of earthwork in each layer from exceeding the actual thickness of that layer. The volume of soil layer excavation and filling is calculated as follows: Effective layer excavation and filling depth of the unit × Planar area of ​​the triangular unit. The soil layer thicknesses at the three corner points of this unit are 3.3 meters, 3.5 meters, and 3.4 meters, respectively. The average soil layer thickness of the unit is calculated as 3.3 + 3.5 + 3.4 meters, and the average soil layer thickness is calculated as 10.2 ÷ 3 = 3.4 meters. The previously calculated average excavation and filling depth of this unit is 2.4 meters. Since 2.4 meters is less than 3.4 meters, the effective layer excavation and filling depth of the unit is directly taken as 2.4 meters. The planar area of ​​the unit is 45 square meters. Substituting these values ​​into the formula for calculating the volume of soil layer excavation and filling, the volume of soil layer excavation and filling is calculated as 2.4 × 45 = 108 cubic meters. This value represents the excavation volume corresponding to the current soil layer within the triangular unit.

[0131] The engineering quantity data is generated based on the total excavation and filling volume and the excavation and filling volume of each soil layer.

[0132] The system retrieves all triangular unit data from the traversal process. Each unit data entry is synchronously bound to its planar position, total cut and fill volume for a single unit, and layered cut and fill volume for each soil layer, ensuring complete retention of detailed data for the smallest calculation unit. The global total cut and fill volume equals the sum of the first, second, and third triangular unit cut and fill volumes. This is continuously accumulated, with separate calculations for the global total cut and fill volume. The global layered cut and fill volume for a single soil layer equals the sum of the first, second, and third triangular unit layered cut and fill volumes for that soil layer. This is continuously accumulated, with layered earthwork values ​​for the same soil layer for all triangular units, generating a global layered cut and fill total for each soil layer. The global total cut volume, global total fill volume, global layered cut and fill volume for each soil layer, and detailed earthwork values ​​for all triangular units are then integrated and summarized to form complete engineering quantity data. The initial triangulation network of the site contains a total of 115 triangular units. By summing the total excavation and filling volumes of these 115 units, the total excavation volume of the site is obtained as 12,680 cubic meters. The total excavation and filling volume of the first layer of silty clay is 7,920 cubic meters, and the total excavation and filling volume of the second layer of sand is 4,760 cubic meters. By integrating and encapsulating the total global volume, the detailed values ​​of the 115 units, and the total volume values ​​of the two soil layers, the complete engineering quantity data of the site is generated.

[0133] The device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate. The components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the modules can be selected to achieve the purpose of this embodiment according to actual needs. Those skilled in the art can understand and implement this without any creative effort.

[0134] Through the above description of the embodiments, those skilled in the art can clearly understand that each embodiment can be implemented by means of software plus necessary general-purpose hardware platforms, and of course, it can also be implemented by hardware. Based on this understanding, the above technical solutions, in essence or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, magnetic disk, optical disk, etc., and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute the methods described in the various embodiments or some parts of the embodiments.

[0135] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, and not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features; and these modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for calculating the volume of soil in a stratum based on multi-borehole point layered data, characterized in that, Includes the following steps: Acquire borehole point data and topographic point data for the engineering area; The borehole point data and topographic point data of the earthwork volume calculation range are integrated to form a global reference point set; the outline boundary condition of the earthwork volume calculation range is determined based on the global effective reference point set; and the relative positional relationship between the reference point position and the boundary line in the global effective reference point set is determined based on the outline boundary condition. The points inside the boundary and the points adjacent to the boundary are distinguished according to their relative positions. The set of global constraint reference points is obtained based on the points inside the boundary and the points adjacent to the boundary. The initial triangular network is obtained by continuously splicing the set of global constraint reference points. A triangular network of soil layer thickness is constructed using all borehole points on the map as vertices and the thickness of the soil layer at each borehole point as the elevation value. The initial triangulation network is processed to obtain the natural elevation and the design elevation. Based on interpolation, the soil layer thickness at the corresponding corner of the triangulation network is obtained. The natural elevation, design elevation, and soil layer thickness are processed to generate engineering quantity data.

2. The method for calculating the volume of soil excavation based on multi-borehole point layered data according to claim 1, characterized in that, The initial triangulation network is processed to obtain the natural elevation and the design elevation, specifically including the following steps: The natural elevation of the corresponding corner points of the initial triangulation is obtained by interpolating the natural terrain points of the entire map. The design elevation of the corresponding corner points of the initial triangulation is obtained by interpolating the borehole points of the entire map.

3. The method for calculating the volume of soil excavation based on multi-borehole point layered data according to claim 2, characterized in that, The process of processing natural elevation, design elevation, and soil layer thickness to generate engineering quantity data includes the following steps: Traverse each triangular cell of the initial triangular network, obtain the average cut-and-fill depth based on the natural elevation and design elevation of the triangular cell, and obtain the total cut-and-fill volume based on the average cut-and-fill depth and cell area; The volume of excavation and filling for each soil layer is obtained based on the soil layer thickness and the unit area. The engineering quantity data is generated based on the total excavation and filling volume and the excavation and filling volume of each soil layer.

4. The method for calculating the volume of soil excavation based on multi-borehole point layered data according to claim 1, characterized in that, The outline boundary condition of the earthwork volume calculation range is determined based on the aforementioned set of effective reference points across the entire region, specifically including the following steps: Extract the spatial distribution range of the effective benchmark point set across the entire region, and determine the basic delineation area for earthwork volume calculation based on the spatial distribution range. Select valid reference points located at the edge of the basic delineation area and use these valid reference points as the basic units for boundary definition. Based on the boundary definition of the basic unit, a closed edge line is formed, and the overall outline of the earthwork volume calculation range is formed by the closed edge line. The boundary condition of the earthwork volume calculation range is determined based on the extended shape and boundary orientation of the overall outline.

5. The method for calculating the volume of soil excavation based on multi-borehole point layered data according to claim 4, characterized in that, Determining the relative positional relationship between the concentrated reference points of the global effective reference points and the boundary lines based on the contour boundary conditions includes the following steps: Extract the continuous edge trend and overall boundary coverage based on the contour boundary conditions; Based on the continuous edge trend, the reference points of the entire effective reference point set are traversed, and the fit between the reference points and the overall coverage of the boundary is compared one by one to obtain the comparison results. The relative positional relationship between the benchmark point and the boundary line is determined based on the comparison results.

6. The method for calculating the volume of soil excavation based on multi-borehole point layered data according to claim 1, characterized in that, Distinguishing between points inside the boundary and points adjacent to the boundary based on their relative positions involves the following steps: Determine the spatial ownership status of the benchmark point relative to the boundary line based on the relative positional relationship; Based on the spatial attribution status, the reference points located inside the contour boundary are selected to obtain the points inside the boundary. Based on the spatial attribution status, reference points located inside the contour boundary and conforming to the boundary direction are selected to obtain the boundary-adjacent points.

7. The method for calculating the volume of soil excavation based on multi-borehole point layered data according to claim 6, characterized in that, The global constraint reference point set is obtained based on the points inside the boundary and the points adjacent to the boundary, specifically including the following steps: By verifying the points inside the boundary and the points adjacent to the boundary using the boundary line adaptation criteria, the effective points inside the boundary and the effective points adjacent to the boundary are obtained. The effective points inside the boundary and the effective points adjacent to the boundary are integrated and collected to obtain the global constraint benchmark point set.

8. The method for calculating the volume of soil excavation based on multi-borehole point layered data according to claim 7, characterized in that, The initial triangulation is obtained by continuously stitching together a set of global constraint reference points, specifically including the following steps: A closed boundary grid is constructed using the boundary proximity points of the global constraint reference point set and the outline of the earthwork volume calculation range. Based on the spatial adjacency of the points, various reference points are sequentially connected within the closed boundary grid to obtain the initial triangulation.

9. The method for calculating the volume of soil excavation based on multi-borehole point layered data according to claim 8, characterized in that, A triangulation network of soil layer thickness is constructed using all borehole points on the map as vertices and the thickness of the soil layer at each borehole point as the elevation value. This process includes the following steps: Using all borehole points as vertices and continuous triangular units based on the thickness of the soil layer at each borehole point, a preliminary global soil layer grid structure is formed. Using the regional outline boundary as a constraint, the preliminary soil layer grid structure is trimmed and its shape is corrected to obtain a soil layer thickness triangular mesh.

10. The method for calculating the volume of soil excavation based on multi-borehole point layered data according to claim 6, characterized in that, Determining the spatial attribution of a benchmark point relative to its boundary line based on relative positional relationships involves the following steps: The comparison results are obtained by comparing the relative positions of the reference points with the boundary lines. The verification results are obtained by verifying the spatial fit of the benchmark points based on the comparison results. Based on the verification results, the spatial morphology of different points is divided to obtain the spatial ownership status of the benchmark point relative to the boundary line.