A CAD-based intelligent computing pile length method, system, device and medium

Abstract

This invention relates to the fields of building structure design and geotechnical engineering technology, and provides a CAD-based intelligent method, system, equipment, and medium for calculating pile length. The method includes: reading the borehole plan view to extract borehole plan coordinate data and establishing a borehole spatial location database; reading geological data tables to extract stratigraphic parameter data and establishing a borehole-soil layer database; overlaying and registering the pile foundation layout drawing with the geological borehole plan view to extract pile position plan coordinate data and pile diameter data; calculating the spatial distance between the pile position and the borehole and screening valid boreholes to establish the correlation between the pile position and the stratigraphic parameter data; obtaining design requirements; and calculating the design pile length of each pile using various pile length calculation strategies based on the design requirements and stratigraphic parameter data; classifying and statistically analyzing the design pile lengths based on the pile diameter data, simultaneously calculating the length of empty piles and the length of penetration into the rock layer, and generating a pile foundation engineering quantity statistics table. This invention achieves a one-stop, fully automated process for pile calculation, drawing generation, and table generation.

Description

Technical Field

[0001] This invention belongs to the fields of building structure design and geotechnical engineering technology, specifically relating to a CAD-based intelligent method, system, equipment, and medium for calculating pile length. Background Technology

[0002] In the design of building pile foundation engineering, determining the pile length and calculating the engineering quantity are key steps. At present, the industry generally adopts traditional manual operation methods for pile foundation design. Designers rely on manually reviewing geological survey data, manually organizing various geological information, and sequentially completing multiple tasks such as reading geological survey data, matching pile location with exploration boreholes, identifying bearing strata, calculating pile length, and compiling engineering quantity statistics.

[0003] Such manual processes are cumbersome and redundant, involving a lot of repetitive work. This not only results in low overall design efficiency, but also means that completing all pile foundation calculations for a single project often consumes a significant amount of time and is prone to human error in calculations and data processing. Furthermore, the pile length values ​​determined by manual experience tend to be conservative, making it difficult to accurately control project construction costs. Traditional operating methods struggle to achieve standardized, automated, and refined pile foundation design, failing to simultaneously meet the practical needs of efficient engineering design, cost reduction, and structural safety. Summary of the Invention

[0004] This invention addresses the problems of low efficiency, large human error, conservative values, and difficulty in achieving standardized and automated design in existing manual calculations of pile foundation lengths. It provides a CAD-based intelligent method, system, equipment, and medium for calculating pile lengths, enabling full automation and intelligence of the pile foundation calculation process.

[0005] To achieve the above objectives, the present invention adopts one or more of the following technical solutions: In a first aspect, the present invention provides a CAD-based intelligent method for calculating pile length, comprising the following steps: Read the geological exploration borehole plan, extract the planar coordinate data of each borehole, bind the planar coordinate data of each borehole with the corresponding borehole number, and establish a borehole spatial location database; Read the geological survey data tables, extract the stratigraphic parameter data of each borehole corresponding to the borehole number, and establish a borehole-soil database; The pile foundation layout drawing designed in the CAD environment is overlaid and registered with the geological exploration borehole plan, and the plane coordinate data and pile diameter data of each pile position in the pile foundation layout drawing are extracted. Based on the planar coordinate data of each pile location and the borehole spatial location database, the spatial distance between each pile location and each borehole is calculated. Based on the spatial distance, valid boreholes that meet the preset distance conditions are selected. The stratum parameter data corresponding to the valid boreholes are obtained from the borehole-soil layer database, and the correlation between the pile location and the stratum parameter data is established. Obtain the design requirements from the user's end, and calculate the design pile length of each pile using various pile length calculation strategies based on the design requirements and the geological parameter data; Based on the pile diameter data, the design pile lengths obtained by different pile length calculation strategies are classified and statistically analyzed. The total pile length for each pile diameter is calculated, and the empty pile length and rock penetration length of each pile are calculated simultaneously to generate a corresponding pile foundation engineering quantity statistics table to achieve multi-scheme comparison.

[0006] By extracting and numbering borehole coordinate data from the borehole plan, digital management of borehole spatial location is achieved, providing basic data support for subsequent spatial matching between pile location and borehole. By extracting and structuring stratigraphic parameter data from geological data tables, the geological data is digitized and standardized, providing stratigraphic basis for pile length calculation. By registering the pile foundation layout map with the geological borehole plan and selecting effective boreholes based on spatial distance, automatic association between pile location and stratigraphic parameter data is achieved, replacing the traditional manual matching method and improving matching efficiency and accuracy. By calculating the design pile length of each pile based on multiple pile length calculation strategies, and simultaneously completing the statistics of total pile length, empty pile length, and rock penetration length, batch and refined calculation of pile length and automatic statistics of engineering quantities are achieved, improving the automation level and efficiency of pile foundation design.

[0007] Furthermore, the method also includes: The designed pile length is displayed visually in the CAD interface and marked on the CAD drawings. Based on the pile foundation engineering quantity statistics table, calculation sheets and bill of quantities are automatically generated and exported.

[0008] It enables the visualization of pile length design results, automatic annotation of CAD drawings, and automatic output of engineering quantity results, thereby improving the efficiency of pile foundation design result generation and the degree of design automation, and reducing the amount of repetitive manual work.

[0009] Furthermore, the stratigraphic parameter data includes at least one or more of the following: soil layer thickness data, soil layer top elevation data, soil layer bottom elevation data, and geotechnical physical and mechanical parameter data.

[0010] Furthermore, the design requirements from the user's end are obtained. Based on the design requirements and the geological parameter data, the design pile length of each pile is calculated using various pile length calculation strategies, specifically including: The design requirements input from the user terminal are obtained. These design requirements include at least the pile diameter bearing capacity requirements, the bearing layer type requirements, and the minimum depth requirement for penetration into the bearing layer. Based on the design requirements, the design pile length of each pile was calculated using the most unfavorable working condition method, the average value method, and the linear interpolation method, respectively, and the design pile length results were obtained. The design pile length results corresponding to different pile length calculation strategies are output to different layers in the CAD drawings.

[0011] Furthermore, the most unfavorable operating condition method specifically includes: Based on the design requirements and the geological parameter data corresponding to each effective borehole, the candidate pile length is calculated, and the maximum value among all candidate pile lengths is selected as the design pile length of the corresponding pile, so as to improve the safety and reliability of the pile length design results under complex geological conditions.

[0012] Furthermore, the average value method specifically includes: Based on the design requirements and the geological parameter data corresponding to each effective borehole, the candidate pile length is calculated, and the average value of all candidate pile lengths is obtained as the design pile length for the corresponding pile, so as to improve the stability and economy of pile length calculation in areas with relatively uniform geological conditions.

[0013] Furthermore, the linear interpolation method specifically includes: Based on the spatial distance between the effective borehole and the corresponding pile location, linear interpolation calculations are performed on the geological parameter data corresponding to each effective borehole to obtain the interpolated geological parameter data for the corresponding pile location. The design pile length of the corresponding pile is then calculated based on the interpolated geological parameter data to improve the precision of pile length calculation in areas with gently changing geological conditions.

[0014] Secondly, the present invention provides a CAD-based intelligent pile length calculation system, comprising: The borehole data processing module is used to extract the planar coordinate data of each borehole, bind the planar coordinate data of each borehole with the corresponding borehole number, and establish a borehole spatial location database. The formation data processing module is used to extract formation parameter data for each borehole number and establish a borehole-soil database. The pile location matching module is used to overlay and register the pile foundation layout drawing pre-designed in the CAD environment with the geological exploration borehole plan, extract the planar coordinate data and pile diameter data of each pile location in the pile foundation layout drawing; calculate the spatial distance between each pile location and each borehole based on the planar coordinate data of each pile location and the borehole spatial location database; filter valid boreholes that meet preset distance conditions based on the spatial distance; obtain the stratigraphic parameter data corresponding to the valid boreholes from the borehole-soil layer database; and establish the correlation between the pile location and the stratigraphic parameter data. The pile length calculation module is used to obtain the design requirements from the user end, and calculate the design pile length of each pile using various pile length calculation strategies based on the design requirements and the geological parameter data. The engineering quantity statistics module is used to classify and statistically analyze the design pile lengths obtained by different pile length calculation strategies based on the pile diameter data, calculate the total pile length for each pile diameter, and simultaneously calculate the empty pile length and the length of penetration into the rock layer for each pile, generating a corresponding pile foundation engineering quantity statistics table to enable comparison of multiple schemes.

[0015] Thirdly, the present invention provides a CAD-based intelligent pile length calculation device, comprising: At least one processor; and, A memory communicatively connected to the at least one processor; wherein, The memory has instructions that can be executed by the at least one processor, which, when executed by the at least one processor, enables the at least one processor to perform the above-described method.

[0016] Fourthly, the present invention provides a non-volatile computer storage medium storing computer-executable instructions configured to implement the above-described method.

[0017] The technical solution of this invention can achieve the following beneficial effects: (1) It can realize the automated calculation of pile length, which significantly improves the efficiency of pile length calculation and shortens the design cycle compared with the traditional manual calculation method; (2) By automatically matching borehole data with pile location data, the error of manual matching is reduced, the accuracy of pile length calculation and the reliability of results are improved; (3) By adapting to different geological conditions through various pile length calculation strategies, the pile length optimization design can be achieved, which is conducive to reducing the project cost; (4) Improve the consistency and standardization of pile foundation design results by unifying the pile length calculation rules; (5) To achieve integrated processing of pile calculation, drawing output, table output and engineering quantity statistics, reduce repetitive manual work and improve the degree of design automation. Attached Figure Description

[0018] Figure 1 This is a flowchart of a CAD-based intelligent pile length calculation method provided by the present invention; Figure 2 This is a structural schematic diagram of a CAD-based intelligent pile length calculation system provided by the present invention; Figure 3 This is a structural schematic diagram of a CAD-based intelligent pile length calculation device provided by the present invention. Detailed Implementation

[0019] The technical solutions of the embodiments of the present invention will now be described in detail and completely with reference to the accompanying drawings. It should be noted that the described embodiments are merely some examples of the present invention and do not represent all possible implementations of the present invention. Any other implementations obtained by those skilled in the art based on the embodiments of the present invention without creative effort are within the protection scope of the present invention.

[0020] Figure 1 The flowchart illustrates a CAD-based intelligent method for calculating pile length, as provided in this invention.

[0021] The method flow steps of the embodiments in this specification are as follows: Read the borehole plan view, extract the planar coordinate data of each borehole, bind the planar coordinate data of each borehole with the corresponding borehole number, and establish a borehole spatial location database.

[0022] Read the geological survey data tables, extract the stratigraphic parameter data of each borehole corresponding to its number, and establish a borehole-soil database.

[0023] Specifically, the stratigraphic parameter data includes at least soil layer thickness data, top soil layer elevation data, bottom soil layer elevation data, and geotechnical physical and mechanical parameter data.

[0024] The pile foundation layout drawing, which was designed in the CAD environment in advance, is overlaid and registered with the geological drilling plan. The planar coordinate data and pile diameter data of each pile location in the pile foundation layout drawing are then extracted.

[0025] Based on the planar coordinate data of each pile location and the borehole spatial location database, the spatial distance between each pile location and each borehole is calculated. Valid boreholes that meet the preset distance conditions are selected based on the spatial distance. The stratum parameter data corresponding to the valid boreholes are obtained from the borehole-soil layer database, and the correlation between the pile location and the stratum parameter data is established.

[0026] Obtain the design requirements from the user's end, and calculate the design pile length of each pile using various pile length calculation strategies based on the design requirements and the geological parameter data.

[0027] Specifically, the design requirements input by the user are obtained, including at least the pile diameter bearing capacity requirement, the bearing layer type requirement, and the minimum depth requirement for entering the bearing layer; based on the design requirements, the design pile length of each pile is calculated using the most unfavorable working condition method, the average value method, and the linear interpolation method respectively; the design pile length results corresponding to different pile length calculation strategies are output to different layers in the CAD drawings.

[0028] Specifically, the most unfavorable operating condition method includes: Based on the design requirements and the geological parameter data corresponding to each effective borehole, the candidate pile length is calculated, and the maximum value among all candidate pile lengths is selected as the design pile length of the corresponding pile.

[0029] Specifically, the average value method includes: Based on the design requirements and the geological parameter data corresponding to each effective borehole, the candidate pile length is calculated, and the average value of all candidate pile lengths is taken as the design pile length of the corresponding pile.

[0030] Specifically, the linear interpolation method includes: Based on the spatial distance between the effective borehole and the corresponding pile location, linear interpolation calculations are performed on the geological parameter data corresponding to each effective borehole to obtain the interpolated geological parameter data for the corresponding pile location, and the design pile length of the corresponding pile is calculated based on the interpolated geological parameter data.

[0031] Based on the pile diameter data, the design pile lengths obtained by different pile length calculation strategies are classified and statistically analyzed. The total pile length for each pile diameter is calculated, and the empty pile length and rock penetration length of each pile are calculated simultaneously to generate a corresponding pile foundation engineering quantity statistics table to achieve multi-scheme comparison.

[0032] The designed pile length is displayed visually in the CAD interface and marked on the CAD drawings. Based on the pile foundation engineering quantity statistics table, calculation sheets and bill of quantities are automatically generated and exported.

[0033] Figure 2 The present invention provides a structural schematic diagram of a CAD-based intelligent pile length calculation system, which includes: a borehole data processing module, a stratum data processing module, a pile location matching module, a pile length calculation module, and an engineering quantity statistics module.

[0034] The borehole data processing module is used to extract the planar coordinate data of each borehole, bind the planar coordinate data of each borehole with the corresponding borehole number, and establish a borehole spatial location database. The formation data processing module is used to extract formation parameter data for each borehole number and establish a borehole-soil database. The pile location matching module is used to overlay and register the pile foundation layout drawing pre-designed in the CAD environment with the geological exploration borehole plan, extract the planar coordinate data and pile diameter data of each pile location in the pile foundation layout drawing; calculate the spatial distance between each pile location and each borehole based on the planar coordinate data of each pile location and the borehole spatial location database; filter valid boreholes that meet preset distance conditions based on the spatial distance; obtain the stratigraphic parameter data corresponding to the valid boreholes from the borehole-soil layer database; and establish the correlation between the pile location and the stratigraphic parameter data. The pile length calculation module is used to obtain the design requirements from the user end, and calculate the design pile length of each pile using various pile length calculation strategies based on the design requirements and the geological parameter data. The engineering quantity statistics module is used to classify and statistically analyze the design pile lengths obtained by different pile length calculation strategies based on the pile diameter data, calculate the total pile length for each pile diameter, and simultaneously calculate the empty pile length and the length of penetration into the rock layer for each pile, generating a corresponding pile foundation engineering quantity statistics table to enable comparison of multiple schemes.

[0035] Figure 3 A structural schematic diagram of a CAD-based intelligent pile length calculation device provided by the present invention includes: At least one processor; and, A memory communicatively connected to the at least one processor; wherein, The memory has instructions that can be executed by the at least one processor, which, when executed by the at least one processor, enables the at least one processor to perform the above-described method.

[0036] The present invention also provides a non-volatile computer storage medium storing computer-executable instructions configured to implement the above-described method.

[0037] The various embodiments in this specification are described in a progressive manner. Similar or identical parts between embodiments can be referred to interchangeably. Each embodiment focuses on describing the differences from other embodiments. In particular, the system, device, and non-volatile computer storage medium embodiments are basically similar to the method embodiments, so the descriptions are relatively simple; relevant parts can be referred to the descriptions of the method embodiments.

[0038] The foregoing has described specific embodiments of this specification. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recited in the claims may be performed in a different order than that shown in the embodiments and may still achieve the desired result. Furthermore, the processes depicted in the drawings do not necessarily require the specific or sequential order shown to achieve the desired result. In some embodiments, multitasking and parallel processing are possible or may be advantageous.

[0039] The above description is merely one or more embodiments of this specification and is not intended to limit this specification. Various modifications and variations can be made to the one or more embodiments of this specification by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principle of one or more embodiments of this specification should be included within the scope of the claims of this specification.

Claims

1. A CAD-based intelligent method for calculating pile length, characterized in that, Includes the following steps: Read the geological exploration borehole plan, extract the planar coordinate data of each borehole, bind the planar coordinate data of each borehole with the corresponding borehole number, and establish a borehole spatial location database; Read the geological survey data tables, extract the stratigraphic parameter data of each borehole corresponding to the borehole number, and establish a borehole-soil database; The pile foundation layout drawing designed in the CAD environment is overlaid and registered with the geological exploration borehole plan, and the plane coordinate data and pile diameter data of each pile position in the pile foundation layout drawing are extracted. Based on the planar coordinate data of each pile location and the borehole spatial location database, the spatial distance between each pile location and each borehole is calculated. Based on the spatial distance, valid boreholes that meet the preset distance conditions are selected. The stratum parameter data corresponding to the valid boreholes are obtained from the borehole-soil layer database, and the correlation between the pile location and the stratum parameter data is established. Obtain the design requirements from the user's end, and calculate the design pile length of each pile using various pile length calculation strategies based on the design requirements and the geological parameter data; Based on the pile diameter data, the design pile lengths obtained by different pile length calculation strategies are classified and statistically analyzed. The total pile length for each pile diameter is calculated, and the empty pile length and rock penetration length of each pile are calculated simultaneously to generate a corresponding pile foundation engineering quantity statistics table to achieve multi-scheme comparison.

2. The intelligent pile length calculation method based on CAD according to claim 1, characterized in that, The method further includes: The designed pile length is displayed visually in the CAD interface and marked on the CAD drawings. Based on the pile foundation engineering quantity statistics table, calculation sheets and bill of quantities are automatically generated and exported.

3. The intelligent pile length calculation method based on CAD according to claim 1, characterized in that, The stratigraphic parameter data includes at least one or more of the following: soil layer thickness data, soil layer top elevation data, soil layer bottom elevation data, and geotechnical physical and mechanical parameter data.

4. The intelligent pile length calculation method based on CAD according to claim 1, characterized in that, Obtain the user's design requirements, and calculate the design pile length for each pile using various pile length calculation strategies based on the design requirements and the geological parameter data. Specifically, this includes: The design requirements input from the user terminal are obtained. These design requirements include at least the pile diameter bearing capacity requirements, the bearing layer type requirements, and the minimum depth requirement for penetration into the bearing layer. Based on the design requirements, the design pile length of each pile was calculated using the most unfavorable working condition method, the average value method, and the linear interpolation method, respectively, and the design pile length results were obtained. The design pile length results corresponding to different pile length calculation strategies are output to different layers in the CAD drawings.

5. The intelligent pile length calculation method based on CAD according to claim 4, characterized in that, The most unfavorable operating condition method specifically includes: Based on the design requirements and the geological parameter data corresponding to each effective borehole, the candidate pile length is calculated, and the maximum value among all candidate pile lengths is selected as the design pile length of the corresponding pile.

6. The intelligent pile length calculation method based on CAD according to claim 4, characterized in that, The average value method specifically includes: Based on the design requirements and the geological parameter data corresponding to each effective borehole, the candidate pile length is calculated, and the average value of all candidate pile lengths is taken as the design pile length of the corresponding pile.

7. The intelligent pile length calculation method based on CAD according to claim 4, characterized in that, The linear interpolation method specifically includes: Based on the spatial distance between the effective borehole and the corresponding pile location, linear interpolation calculations are performed on the geological parameter data corresponding to each effective borehole to obtain the interpolated geological parameter data for the corresponding pile location, and the design pile length of the corresponding pile is calculated based on the interpolated geological parameter data.

8. A CAD-based intelligent pile length calculation system, used to implement the method described in any one of claims 1-7, characterized in that, The system includes: The borehole data processing module is used to extract the planar coordinate data of each borehole, bind the planar coordinate data of each borehole with the corresponding borehole number, and establish a borehole spatial location database. The formation data processing module is used to extract formation parameter data for each borehole number and establish a borehole-soil database. The pile location matching module is used to overlay and register the pile foundation layout drawing pre-designed in the CAD environment with the geological exploration borehole plan, extract the planar coordinate data and pile diameter data of each pile location in the pile foundation layout drawing; calculate the spatial distance between each pile location and each borehole based on the planar coordinate data of each pile location and the borehole spatial location database; filter valid boreholes that meet preset distance conditions based on the spatial distance; obtain the stratigraphic parameter data corresponding to the valid boreholes from the borehole-soil layer database; and establish the correlation between the pile location and the stratigraphic parameter data. The pile length calculation module is used to obtain the design requirements from the user end, and calculate the design pile length of each pile using various pile length calculation strategies based on the design requirements and the geological parameter data. The engineering quantity statistics module is used to classify and statistically analyze the design pile lengths obtained by different pile length calculation strategies based on the pile diameter data, calculate the total pile length for each pile diameter, and simultaneously calculate the empty pile length and the length of penetration into the rock layer for each pile, generating a corresponding pile foundation engineering quantity statistics table to enable comparison of multiple schemes.

9. A CAD-based intelligent pile length calculation device, characterized in that, include: At least one processor; as well as, A memory communicatively connected to the at least one processor; wherein, The memory has instructions executable by the at least one processor, which, when executed by the at least one processor, enables the at least one processor to perform the method as described in any one of claims 1-7.

10. A non-volatile computer storage medium, characterized in that, The device stores computer-executable instructions configured to implement the method as described in any one of claims 1-7.

Images