Underwater pile foundation scouring calculation method and system

Abstract

The invention relates to the technical field of underwater pile foundations, and provides an underwater pile foundation scouring calculation method and system, and the method comprises the steps: obtaining the point cloud data of an underwater pile foundation and the surrounding terrain of the underwater pile foundation; the coordinates of the underwater pile foundation and the radius of the square round hole are obtained, the point cloud data are screened, and the coordinates and the elevation value of each point in the point cloud data obtained through screening are extracted; obtaining a scouring radius, an underwater pile foundation radius, a reference mud surface elevation related radius and an edge radius, dividing the screened point clouds into a scouring area, an edge area and a reference mud surface area in combination with coordinates of each point, putting elevation values of midpoints of the scouring area, the edge area and the reference mud surface area into different sets respectively, and calculating the elevation values of the midpoints of the scouring area, the edge area and the reference mud surface area; performing elevation value analysis on each set; and based on elevation analysis results of different sets, calculating to obtain a filling amount. Effective monitoring of underwater pile foundation scouring is achieved, and valuable reference is provided for engineering decision making.

Description

Technical Field

[0001] The present invention belongs to the technical field of underwater piles, and particularly relates to a method and system for calculating underwater pile foundation scour. Background Art

[0002] The statements in this part only provide background technical information related to the present invention, and do not necessarily constitute prior art.

[0003] For the calculation of underwater pile foundation scour, when the prior art processes the point cloud data of underwater pile foundations and the surrounding terrain, it lacks comprehensive data extraction for the structural characteristics of underwater pile foundations and the actual engineering requirements: First, for the complex terrain around underwater pile foundations and the special shape of the underwater pile foundations themselves, it is difficult to accurately extract the required data, and thus it is impossible to effectively analyze the underwater pile foundation scour amount; Second, the integrity of the extracted data is poor, and it cannot fully reflect the real situation of the underwater pile foundation and the surrounding terrain, which will lead to deviations in subsequent pile foundation elevation analysis; Moreover, there is a lack of a quantitative calculation method for the filling volume, and the filling volume is mostly determined by the experience of technicians. Summary of the Invention

[0004] In order to solve the technical problems existing in the above background art, the present invention provides a method and system for calculating underwater pile foundation scour. During the data extraction process, the structural characteristics of underwater pile foundations are fully considered, and a method based on coordinate judgment and region screening is adopted to accurately extract the square circular hole point cloud of the terrain around the underwater pile foundation. In the elevation analysis, by reasonably setting parameters, it is divided into a scour area, an edge area, and a reference mud surface area to realize the filling volume calculation, and effectively monitor the underwater pile foundation scour, providing valuable reference for engineering decision-making.

[0005] In order to achieve the above object, the present invention adopts the following technical solutions:

[0006] The first aspect of the present invention provides a method for calculating underwater pile foundation scour, which includes:

[0007] Obtain the point cloud data of the underwater pile foundation and its surrounding terrain;

[0008] Obtain the coordinates of the underwater pile foundation and the radius of the square circular hole, judge the relationship between the coordinates of the underwater pile foundation, the radius of the square circular hole and the coordinates of each point in the point cloud data, screen the point cloud data, screen out the point cloud data that is within the square area around the coordinates of the underwater pile foundation and outside the circular hole area, and extract the coordinates and elevation values of each point in the screened point cloud data;

[0009] Obtain the scouring radius, the radius of the underwater pile foundation, the radius related to the reference mud surface elevation, and the edge radius. Combine the coordinates of each point to divide the filtered point cloud into the scouring area, the edge area, and the reference mud surface area. After putting the elevation values of the points in the scouring area, the edge area, and the reference mud surface area into different sets respectively, perform elevation value analysis on each set to obtain the elevation analysis results;

[0010] Based on the elevation analysis results of different sets, calculate the volume of fill.

[0011] Further, the sets include:

[0012] Scouring area set: Points between the radius of the underwater pile foundation and the scouring radius with the coordinates of the underwater pile foundation as the center are put into the scouring area set with their elevation values;

[0013] Edge area set: Points between the scouring radius and the edge radius with the coordinates of the underwater pile foundation as the center are put into the edge area set with their elevation values;

[0014] Reference mud surface elevation set: For points within a set radius area with the coordinates of the underwater pile foundation as the center, if the difference between the elevation value and the reference mud surface elevation is less than the threshold, put their elevation values into the reference mud surface elevation set.

[0015] Further, when the average elevation value of the edge area set is less than the average elevation of the reference mud surface, calculate the volume of fill, and the volume of fill is:

[0016] V = ρ × S × (h0 - h1)

[0017] Where h1 is the average elevation of the points below the average reference mud surface elevation in the scouring area set, h0 is the reference mud surface elevation, S is the area of the scouring area, and ρ is the fill volume coefficient.

[0018] Further, the elevation analysis results include: the average elevation of the reference mud surface, the minimum elevation, the maximum elevation, the average elevation, and the pit depth of the scouring area, and the minimum elevation, the maximum elevation, and the average elevation of the edge area.

[0019] The second aspect of the present invention provides an underwater pile foundation scouring calculation system, which includes:

[0020] Point cloud acquisition module, which is configured to: acquire the point cloud data of the underwater pile foundation and its surrounding terrain;

[0021] A point cloud screening module, which is configured to: obtain the coordinates of the underwater pile foundation and the radius of the square round hole, determine the relationship between the coordinates of the underwater pile foundation, the radius of the square round hole and the coordinates of each point in the point cloud data, screen the point cloud data, and screen out the point cloud data that is within the square area and outside the round hole area around the coordinates of the underwater pile foundation, and extract the coordinates and elevation values of each point in the screened point cloud data;

[0022] An elevation analysis module, which is configured to: obtain the scour radius, the radius of the underwater pile foundation, the radius related to the reference mud surface elevation, and the edge radius, combine the coordinates of each point, divide the screened point cloud into a scour area, an edge area and a reference mud surface area, put the elevation values of the points in the scour area, the edge area and the reference mud surface area into different sets respectively, and then perform elevation value analysis on each set to obtain the elevation analysis result;

[0023] A filling volume calculation module, which is configured to: calculate the filling volume based on the elevation analysis results of different sets.

[0024] Further, the sets include:

[0025] Scour area set: Points between the radius of the underwater pile foundation and the scour radius with the coordinates of the underwater pile foundation as the center, and their elevation values are put into the scour area set;

[0026] Edge area set: Points between the scour radius and the edge radius with the coordinates of the underwater pile foundation as the center, and their elevation values are put into the edge area set;

[0027] Reference mud surface elevation set: For points within the set radius area with the coordinates of the underwater pile foundation as the center, if the difference between the elevation value and the reference mud surface elevation is less than the threshold, then put their elevation values into the reference mud surface elevation set.

[0028] Further, when the average elevation value of the edge area set is less than the average reference mud surface elevation, calculate the filling volume, and the filling volume is:

[0029] V = ρ × S × (h0 - h1)

[0030] Wherein, h1 is the average elevation of the points in the scour area set that are lower than the average reference mud surface elevation, h0 is the reference mud surface elevation, S is the area of the scour area, and ρ is the filling volume coefficient.

[0031] Further, the elevation analysis result includes: the average reference mud surface elevation, the minimum elevation, the maximum elevation, the average elevation and the pit depth of the scour area, and the minimum elevation, the maximum elevation and the average elevation of the edge area.

[0032] The third aspect of the present invention provides a computer-readable storage medium, on which a computer program is stored. When the program is executed by a processor, the steps in a method for calculating underwater pile foundation scour as described above are implemented.

[0033] The fourth aspect of the present invention provides a computer device, including a computer-readable storage medium, a processor, and a computer program stored on the computer-readable storage medium and executable on the processor. When the processor executes the program, the steps in a method for calculating underwater pile foundation scour as described above are implemented.

[0034] Compared with the prior art, the beneficial effects of the present invention are as follows:

[0035] In the process of data extraction of the present invention, the structural characteristics of the underwater pile foundation are fully considered, and a method based on coordinate judgment and region screening is adopted to accurately extract the square circular hole point cloud of the terrain around the underwater pile foundation. In the elevation analysis, by reasonably setting parameters, it is divided into a scour area, an edge area, and a reference mud surface area to realize the calculation of the filling volume, effectively monitoring the underwater pile foundation scour, and providing valuable reference for engineering decision-making. BRIEF DESCRIPTION OF THE DRAWINGS

[0036] The accompanying drawings forming a part of this invention are used to provide a further understanding of the present invention. The schematic embodiments and descriptions thereof of the present invention are used to explain the present invention and do not constitute an improper limitation of the present invention.

[0037] Figure 1 is a flowchart of a method for calculating underwater pile foundation scour according to Embodiment 1 of the present invention;

[0038] Figure 2 is a schematic diagram of a square circular hole according to Embodiment 1 of the present invention;

[0039] Figure 3 is a schematic structural diagram of a computer device according to Embodiment 4 of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0040] To make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention.

[0041] It should be noted that the following detailed descriptions are all illustrative and are intended to provide further explanations of the present invention. Unless otherwise specified, all technical and scientific terms used herein have the same meaning as commonly understood by those of ordinary skill in the technical field to which the present invention belongs.

[0042] Embodiment 1

[0043] This embodiment provides a method for calculating underwater pile foundation scour.

[0044] An underwater pile foundation scour calculation method provided by this embodiment is as follows Figure 1 shown, including the following steps:

[0045] Step 1: Data reading and preprocessing. Read the point cloud data file of the underwater pile foundation and the surrounding terrain (supporting xyz format) from the specified path. The surrounding terrain range is 100m×100m centered on the wind turbine. Convert the point cloud data into a format convenient for processing through the o3d.io.read_point_cloud function, and extract the x, y, and z coordinate information; read the underwater pile foundation coordinate information from the specified path.

[0046] In this embodiment, the coordinates of the point cloud data are represented in the world coordinate system.

[0047] Step 101: Determine the file path.

[0048] (1) Input path of the point cloud file: Specify the source location of the point cloud data, for example, set it to "C: / Users / Administrator / Desktop / POINT / GMT / txt / H2GPS / ". The point cloud files to be processed are stored under this path, and these files record the three-dimensional point cloud information in different scenarios.

[0049] (2) File path of the underwater pile foundation coordinates: Specify the file path of the underwater pile foundation coordinate information, such as "C: / Users / Administrator / Desktop / POINT / GMT / txt / H2GPS / fengji / H2_fengji.txt". This file contains the position coordinates of each underwater pile foundation and is the key basis for locating the underwater pile foundation in the point cloud data later.

[0050] (3) Output paths for each processing stage: Define the output paths for different stages such as after point cloud screening and final result output. For example, the screened point cloud may be output to "C: / Users / Administrator / Desktop / POINT / GMT / txt / H2GPS / xyz / ". These output paths are used to store the result data of each processing stage, facilitating subsequent viewing and further analysis.

[0051] Step 102: Set parameters.

[0052] (1) Radius of the square round hole: Set the circular hole radius parameter for point cloud screening. For example, the circular radius is 3m. In the square area centered on the underwater pile foundation coordinates, the points whose distance from the underwater pile foundation coordinates is greater than the circular hole radius will be retained for subsequent processing.

[0053] AsFigure 2 As shown, the square range is the measurement range, which is generally larger than the research range of scouring calculation; the circular hole range is the position where the cylindrical part of the wind turbine tower is located. All the points inside the cylinder are noise points and need to be removed.

[0054] (2) Scouring radius, underwater pile foundation radius, edge radius: Different radius parameters related to scouring calculation are defined respectively. The scouring radius (such as 17 m) is used to determine the range for scouring analysis around the underwater pile foundation; the underwater pile foundation radius (such as 2.5 m) represents the size range of the underwater pile foundation itself; the edge radius (such as 35 m) is used to define the edge area around the underwater pile foundation and has specific functions in different calculations and analyses.

[0055] (3) Benchmark mud surface elevation range: Set the range of the benchmark mud surface elevation according to specific engineering or analysis requirements. In scouring calculation, it is used to judge the relationship between the elevation of a point and the benchmark mud surface elevation for operations such as calculating the filling volume.

[0056] Step 103: Read the underwater pile foundation coordinate file.

[0057] Open the underwater pile foundation coordinate file (such as "C: / Users / Administrator / Desktop / POINT / GMT / txt / H2GPS / fengji / H2_fengji.txt"), read the content of the file line by line. For each line of data (in the format of underwater pile foundation number, x, y, measurement time), parse the underwater pile foundation name and the corresponding coordinate information according to a specific format, usually in the format of "underwater pile foundation name horizontal coordinate vertical coordinate". For example, extract "underwater pile foundation 1" and its coordinate values (such as the horizontal coordinate is 100.5 and the vertical coordinate is 200.3), and store this information in a suitable data structure (such as a list or a dictionary) for quickly locating the position of the underwater pile foundation in the point cloud data and performing operations such as point cloud screening and calculation based on the position of the underwater pile foundation.

[0058] Step 2: Data screening and extraction.

[0059] Step 201: Traverse the point cloud file.

[0060] Loop through the directory where the point cloud files are located, process each point cloud file in the directory. During the traversal, obtain the file name of each point cloud file for subsequent reading and operation.

[0061] Step 202: Read the point cloud.

[0062] Read the currently traversed point cloud file (for example, functions from the Open3D library can be used), and convert it into a point cloud data structure that can be processed internally by the program. This data structure contains the coordinate information of points (such as x, y, z coordinates) and possibly other attribute information (such as color, intensity, etc., if these are included in the point cloud file).

[0063] Step 203: Filter the point cloud according to the coordinates of the underwater pile foundation. That is, extract the point cloud of the square circular hole of the underwater pile foundation, and extract the point cloud of the square circular hole of the underwater pile foundation from the point cloud data according to the coordinates of the underwater pile foundation. First, determine the range boundaries of the point cloud data (by finding the minimum and maximum values of the x and y coordinates); then judge whether the coordinates of the underwater pile foundation are within this range; for the underwater pile foundation within the range, further determine the boundaries of its square area (by setting the side length of the square, such as r_zhengfang), and remove the points within the range of the underwater pile foundation cylinder (by setting the cylinder radius, such as r_yuan).

[0064] (1) Traverse the point cloud data: For the read point cloud data, traverse each point in it one by one, and access the information of each point through an index or iterator, etc.

[0065] (2) Filter based on conditions. For each underwater pile foundation, traverse each point in the point cloud data. Calculate the distance from this point to the center of the underwater pile foundation (by taking the square root of the sum of the squares of the coordinate differences). If the point is within the square area and not within the range of the cylinder, then retain this point. Specifically:

[0066] Square range judgment: According to the coordinates of the underwater pile foundation and the square range radius (such as 55), judge whether the coordinates of the current point are within the square range centered on the coordinates of the underwater pile foundation. If the point coordinates are not within this square range, then skip this point and continue to process the next point. For example, if the coordinates of the underwater pile foundation are (100, 100) and the square range radius is 55, then judge whether the abscissa of the point is within the range of [100 - 55, 100 + 55] (that is, [45, 155]), and whether the ordinate is within the same range.

[0067] Circular hole radius judgment: For the points within the square range, further calculate the square of the distance from this point to the coordinates of the underwater pile foundation. If the square of the distance from the point to the coordinates of the underwater pile foundation is greater than the square of the circular hole radius (assuming the circular hole radius is 3, then the radius square is 9), then retain this point; otherwise, exclude this point.

[0068] Through this filtering operation, the point cloud data around the coordinates of the underwater pile foundation within the square range and outside the specific circular hole range is extracted for subsequent analysis of features such as the terrain around the underwater pile foundation.

[0069] Step 204: Save the filtered point cloud.

[0070] Form a new point cloud data structure with the qualified points after screening, and save the extracted qualified point cloud as a separate file with the name of the underwater pile foundation plus a specific suffix (such as fengji1.xyz), and save it to the specified output path.

[0071] For example, the point cloud belonging to "Underwater Pile Foundation 1" after screening is saved as "Underwater Pile Foundation 1.xyz" to the path of "C: / Users / Administrator / Desktop / POINT / GMT / txt / H2GPS / xyz / ". This facilitates subsequent separate analysis and processing of the point cloud data of different underwater pile foundations, making data management more orderly.

[0072] Step 3: Scour calculation and analysis.

[0073] Step 301: Read the underwater pile foundation coordinate file.

[0074] Read the underwater pile foundation coordinate file again to prepare for scour calculation. In the scour calculation stage, the relative position relationship between the point and the underwater pile foundation is judged based on the underwater pile foundation coordinates. Therefore, accurate underwater pile foundation coordinate data needs to be obtained again.

[0075] Step 302: Traverse the point cloud files.

[0076] Loop through the point cloud file directory and perform scour calculations on each point cloud file. During the traversal, the subsequent scour calculation operation steps are executed on each point cloud file in turn to ensure that the entire point cloud data set is scoured and analyzed.

[0077] Step 303: Read the point cloud for scour calculation.

[0078] (1) Read the point cloud data: For the currently traversed point cloud file, read the point cloud data and load it into the program for subsequent calculation and analysis. Specifically, read the point cloud data file of the underwater pile foundation and the surrounding terrain (the relevant file after extraction, such as fengji1.xyz), obtain the x, y, and z coordinate information, and determine the position of the underwater pile foundation in the terrain (through coordinate matching).

[0079] (2) Extract the point information: Extract the coordinates and elevation values of each point from the read point cloud data. The coordinate information is used to determine the position of the point, and the elevation value is used to judge whether the point is within the scour range and for operations such as filling volume calculation.

[0080] Step 304: Assign points to different sets (ranges).

[0081] (1) Filter points according to the radius range conditions. Based on the set scouring range radius (such as r_chongshua), underwater pile foundation radius (such as r_fengji), reference mud surface elevation related radius (such as r_jizhun), and edge range radius (such as r_bianyuan), determine the range boundaries of different regions (scouring region, edge region, reference mud surface region, etc.). The data of the scouring range radius (such as r_chongshua), underwater pile foundation radius (such as r_fengji), reference mud surface elevation related radius (such as r_jizhun), and edge range radius (such as r_bianyuan) are set based on engineering practical experience and previous research and observations of scouring phenomena. In actual engineering, different geological conditions, water flow velocities, pile foundation structures, and other factors will affect the scouring region. Through a large amount of on-site measured data and numerical simulation analysis, the approximate value ranges of these radii under different working conditions have been summarized. For example, for a specific geological type and water flow velocity range, the scouring range radius r_chongshua may fluctuate within a relatively stable interval, and this interval is obtained through statistical analysis of multiple similar engineering cases. These data are relatively stable within a certain time range. However, as time goes by, if the engineering environment changes significantly, such as the water flow velocity changes due to the construction of upstream water conservancy projects, or the geological conditions change due to geological disasters such as earthquakes, then these data may need to be re-evaluated and adjusted. Under normal circumstances, the errors of these data are within the acceptable range in the short term. When setting these data, a certain safety factor has been considered to cope with possible errors. For example, when determining the scouring range radius r_chongshua, the value is taken according to the most unfavorable working conditions to ensure that the maximum possible scouring region can be covered in actual applications.

[0082] (2) According to the underwater pile foundation coordinates and different radius range conditions, assign the elevation values of points to different sets:

[0083] (a) Scouring range set: Points with a radius between the underwater pile foundation radius (such as 2.5 m) and the scouring radius (such as 17 m) centered on the underwater pile foundation coordinates, their elevation values are put into the elevation set within the scouring range. For example, calculate the distance from the point to the underwater pile foundation coordinates. If it is within the range of [2.5, 17], then add the elevation value of this point to the scouring range set.

[0084] (b) Edge range set: Points with a radius between the scouring radius (such as 17 m) and the edge radius (such as 35 m) centered on the underwater pile foundation coordinates, their elevation values are put into the elevation set within the edge range, which is used to analyze the topographic features and elevation changes in the edge region around the underwater pile foundation.

[0085] (c) Reference mud surface elevation set: Taking the underwater pile foundation coordinates as the center, the points within a specific radius range (for example, the points between a radius of 14 - 16 m), their elevation values are put into the reference mud surface elevation set. The specific radius range is set according to actual requirements and engineering standards, generally in the range of 3 times the radius of the wind turbine tower barrel ± 1 m. The average elevation of all points in this set is the reference mud surface elevation.

[0086] (3) Elevation value of the allocated points.

[0087] After determining the set to which the point belongs, add the elevation value of the point to the corresponding set accordingly. That is, traverse each point in the point cloud data, judge the area it belongs to according to its position, and collect the z - coordinate values in different areas into the corresponding lists (such as Z_chongshua, Z_bianyuan, Z_jizhun) respectively. Classifying the point cloud data according to different area ranges facilitates subsequent separate processing and analysis of points in different areas, and accurately calculates scour - related parameters and filling volumes, etc.

[0088] Step 305: Calculate the parameters of each set.

[0089] (1) Calculate the parameters of the scour range set:

[0090] For the points in the scour range set, calculate parameters such as the minimum elevation, maximum elevation, and average elevation. The minimum elevation is the minimum value of the elevation values of all points in the set, reflecting the lowest point height in the scour area; the maximum elevation is the maximum value, representing the highest point height; the average elevation is the average value, measuring the overall elevation level of the scour area. The pit depth can also be calculated, that is, the difference between the maximum elevation and the minimum elevation, reflecting the degree of topographic undulation in the scour area.

[0091] The maximum elevation H in the scour area max Calculation: First, traverse all the point cloud data points in the scour area, record the z - coordinate value z of each point i , and then by comparing these z - coordinate values, find the maximum value among them, that is, H max = max{z i}, where i represents the serial number of the point cloud data point in the scour area.

[0092] The minimum elevation H min Calculation: Similarly, by comparing the z - coordinate values of all points, find the minimum value, H min = min{z i}.

[0093] The average elevation H avg Calculation: Add up the z - coordinate values of all points in the scour area, and then divide by the total number of points n, that is

[0094] The reference mud surface elevation Hjizhun Calculation: Calculate the average value of all points of the mud surface elevation (reference mud surface elevation set) in the non-eroded area.

[0095] Calculation of the scour pit depth D: Taking the reference mud surface elevation H jizhun as a reference, the scour pit depth D = H jizhun - H min .

[0096] (2) Calculate the parameters of the edge range set:

[0097] Similarly, calculate parameters such as the minimum elevation, maximum elevation, and average elevation in the edge range set for analyzing the topographic features of the edge area. These parameters can help understand the elevation changes in the edge area around the underwater pile foundation and are of great significance for evaluating the overall condition of the underwater pile foundation surrounding environment.

[0098] Step 306: Calculate the volume of fill.

[0099] For the points within the scour range, if the average value of their elevation values is lower than the average value of the elevation values in the reference mud surface elevation set, calculate the volume of fill. First, calculate the difference between the average elevation of the points below the average reference mud surface elevation and the reference mud surface elevation; then, according to the area of the scour range and a certain proportional relationship, multiply this difference by the corresponding coefficient to obtain the volume of fill.

[0100] Calculation of the volume of fill V: Consider the scour area as an irregular geometric body. First, perform 3D modeling on the point cloud data of the scour area to obtain the volume model of the scour area; then, according to the bulk density ρ of the fill material, calculate the volume of fill V = ρ × V model , where V model is the volume of the scour area, which is calculated through 3D modeling software or related algorithms.

[0101] For example, assume that the average elevation of the points below the average reference mud surface elevation (the average elevation value of the reference mud surface elevation set) within the scour range is h1, the reference mud surface elevation is h0, the area of the scour range is S, and the fill volume coefficient is ρ, then the fill volume V = ρ × S × (h0 - h1).

[0102] By calculating the volume of fill, it is possible to evaluate the amount of fill material required for engineering construction and other activities in this area, providing an important reference for engineering planning and design.

[0103] Step 307: Store the calculation results of the underwater pile foundation.

[0104] Store the scour calculation results (elevation analysis results and filling volume) of each underwater pile foundation, including file name, average elevation of the reference mud surface, various parameters of the scour range (such as minimum elevation, maximum elevation, average elevation, pit depth), filling volume, parameters of the edge range (such as minimum elevation, maximum elevation, average elevation), etc., in the corresponding data structure.

[0105] For example, a dictionary or a custom data class can be used to store this information, where the name of the underwater pile foundation serves as the key and the corresponding parameters serve as the values. Such a storage method facilitates the subsequent unified management and further analysis and processing of the scour calculation results of underwater pile foundations. It is possible to conduct a comparative analysis of the calculation results of multiple underwater pile foundations and generate a scour monitoring report of underwater pile foundations based on these calculation results.

[0106] Step 4, Result output.

[0107] Step 401, Create an Excel workbook.

[0108] Create a new Excel workbook. For example, the xlwings library can be used. Xlwings is a library for interacting with Excel in Python, and it provides rich functions to operate Excel files. By calling relevant functions, a blank Excel workbook can be created to prepare for writing the scour calculation results later. This workbook will be used to store and display various data related to underwater pile foundations obtained through processing and calculation, so that users can view and analyze the results in a more intuitive way.

[0109] Step 402, Add a new worksheet.

[0110] Add a new worksheet to the created Excel workbook. A worksheet is an independent page in an Excel file for storing and organizing data. By adding a new worksheet, the scour calculation results can be separated from other possible data or worksheets, making the data clearer and more organized. The worksheet can be named to better identify its content, for example, named "Scour Calculation Results".

[0111] Step 403, Write the results to the worksheet.

[0112] Write the stored underwater pile foundation calculation results (elevation analysis results and filling volume) data into different columns of the worksheet. Specifically, write the file name of the underwater pile foundation into the first column, the average elevation of the reference mud surface into the second column, the minimum elevation of the scouring range into the third column, the maximum elevation into the fourth column, the average elevation into the fifth column, the pit depth into the sixth column, the filling volume into the seventh column, the minimum elevation of the edge range into the eighth column, the maximum elevation into the ninth column, the average elevation into the tenth column, etc. In this way, the complex data is presented in a structured form in the Excel worksheet, and users can conveniently view and analyze the various parameters of each underwater pile foundation. For example, relevant functions of the xlwings library (of course, other software can also be selected according to the situation) can be used to accurately write the data in Python into the specified cell positions of the Excel worksheet to ensure the integrity and accuracy of the data.

[0113] Step 404, save the Excel file.

[0114] Save the Excel workbook containing the scouring calculation results to the specified output path. For example, it can be saved to the directory "C: / Users / Administrator / Desktop / POINT / GMT / txt / H2GPS / " and named "Scouring Calculation Results.xlsx". In this way, users can conveniently open this Excel file to view and use the scouring calculation result data when needed. The save operation ensures the persistence and accessibility of the data, facilitating subsequent data analysis, report generation, or data interaction with other systems.

[0115] In the data extraction process of the underwater pile foundation scouring calculation method provided in this embodiment, the structural characteristics of the underwater pile foundation are fully considered, and the method based on coordinate judgment and region screening is adopted to accurately extract the square circular hole point cloud of the terrain around the underwater pile foundation, improving the accuracy and pertinence of data extraction, ensuring the integrity of the extracted data, and enabling it to truly reflect the actual situation of the underwater pile foundation and the surrounding terrain.

[0116] In the elevation analysis of the underwater pile foundation scouring calculation method provided in this embodiment, combined with the actual situation of the underwater pile foundation and the surrounding terrain, by reasonably setting parameters and using accurate calculation methods, it is divided into scouring areas, edge areas, and reference mud surface areas, realizing the effective monitoring of specific engineering problems related to the underwater pile foundation and providing valuable references for engineering decisions.

[0117] The underwater pile foundation scouring calculation method provided in this embodiment provides an important decision-making basis for the design, construction, and maintenance of underwater pile foundation projects, helps to optimize the engineering plan, and improves the engineering quality and safety.

[0118] Embodiment 2

[0119] This embodiment provides an underwater pile foundation scour calculation system, which specifically includes:

[0120] A point cloud acquisition module, which is configured to: acquire point cloud data of an underwater pile foundation and its surrounding terrain;

[0121] A point cloud screening module, which is configured to: acquire the coordinates of the underwater pile foundation and the radius of the square circular hole, judge the relationship between the coordinates of the underwater pile foundation, the radius of the square circular hole and the coordinates of each point in the point cloud data, screen the point cloud data, and screen out the point cloud data within the square area and outside the circular hole area around the coordinates of the underwater pile foundation, and extract the coordinates and elevation values of each point in the screened point cloud data;

[0122] An elevation analysis module, which is configured to: acquire the scour radius, the radius of the underwater pile foundation, the radius related to the reference mud surface elevation, and the edge radius, combine the coordinates of each point, divide the screened point cloud into a scour area, an edge area and a reference mud surface area, put the elevation values of the points in the scour area, the edge area and the reference mud surface area into different sets respectively, and then perform elevation value analysis on each set to obtain an elevation analysis result;

[0123] A filling calculation module, which is configured to: calculate the filling volume based on the elevation analysis results of different sets.

[0124] Further, the set includes:

[0125] Scour area set: Points between the radius of the underwater pile foundation and the scour radius with the coordinates of the underwater pile foundation as the center are put into the scour area set with their elevation values;

[0126] Edge area set: Points between the scour radius and the edge radius with the coordinates of the underwater pile foundation as the center are put into the edge area set with their elevation values;

[0127] Reference mud surface elevation set: For points within a set radius area with the coordinates of the underwater pile foundation as the center, if the difference between the elevation value and the reference mud surface elevation is less than the threshold, then their elevation values are put into the reference mud surface elevation set.

[0128] Further, when the average elevation value of the edge area set is less than the average reference mud surface elevation, the filling volume is calculated, and the filling volume is:

[0129] V = ρ×S×(h0 - h1)

[0130] Wherein, h1 is the average elevation of the points below the average reference mud surface elevation in the scour area set, h0 is the reference mud surface elevation, S is the area of the scour area, and ρ is the filling volume coefficient.

[0131] Further, the elevation analysis results include: the average elevation of the reference mud surface, the minimum elevation, maximum elevation, average elevation and pit depth of the scouring area, and the minimum elevation, maximum elevation and average elevation of the edge area.

[0132] It should be noted here that each module in this embodiment corresponds to each step in the first embodiment one by one, and the specific implementation process is the same, so it will not be repeated here.

[0133] Embodiment 3

[0134] This embodiment provides a computer-readable storage medium, on which a computer program is stored. When the program is executed by a processor, it implements the steps in a method for calculating underwater pile foundation scouring as described in the first embodiment above.

[0135] Embodiment 4

[0136] This embodiment provides a computer device, as Figure 3 shown, including a display device, an input device, a computer-readable storage medium (volatile memory and non-volatile storage medium), a processor, a communication interface (i.e., a network interface), and a computer program stored on the computer-readable storage medium and executable on the processor. Among them, the processor, the communication interface, and the computer-readable storage medium can be connected through a bus or other means. Among them, the communication interface is used to receive and send data, and when the processor executes the program, it implements the steps in a method for calculating underwater pile foundation scouring as described in the first embodiment above.

[0137] Among them, any reference to a memory, storage, database, or other medium provided in this application and used in the embodiments may include non-volatile and / or volatile memories. The non-volatile memory may include a read-only memory (ROM), a programmable ROM (PROM), an electrically programmable ROM (EPROM), an electrically erasable programmable ROM (EEPROM), or a flash memory. The volatile memory may include a random access memory (RAM) or an external cache memory. By way of illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (SSRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), etc.

[0138] The present invention is described with reference to the flowcharts and / or block diagrams of methods, apparatuses (systems), and computer program products according to embodiments of the present invention. It should be understood that each flow and / or block in the flowcharts and / or block diagrams, as well as the combination of flows and / or blocks in the flowcharts and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to the processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing devices to generate a machine, such that the instructions executed by the processor of the computer or other programmable data processing devices generate means for implementing the functions specified in one or more of the flows Figure 1 one or more of the flows and / or blocks Figure 1 or means for implementing the functions specified in one or more of the blocks.

[0139] These computer program instructions can also be stored in a computer-readable memory that can direct a computer or other programmable data processing device to operate in a specific manner, such that the instructions stored in the computer-readable memory generate a manufactured article including instruction means for implementing the functions specified in one or more of the flows Figure 1 one or more of the flows and / or blocks Figure 1 or means for implementing the functions specified in one or more of the blocks.

[0140] These computer program instructions can also be loaded onto a computer or other programmable data processing device, such that a series of operation steps are executed on the computer or other programmable device to generate a computer-implemented process, and thus the instructions executed on the computer or other programmable device provide steps for implementing the functions specified in one or more of the flows Figure 1 one or more of the flows and / or blocks Figure 1 or means for implementing the functions specified in one or more of the blocks.

[0141] The above are only preferred embodiments of the present invention and are not used to limit the present invention. For those skilled in the art, the present invention can have various changes and modifications. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

Claims

1. An underwater pile foundation scour calculation method, characterized in that, Including: Obtain the point cloud data of the underwater pile foundation and its surrounding terrain; Obtain the coordinates of the underwater pile foundation and the radius of the square circular hole, judge the relationship between the coordinates of the underwater pile foundation, the radius of the square circular hole and the coordinates of each point in the point cloud data, screen the point cloud data, and screen out the point cloud data that is within the square area and outside the circular hole area around the coordinates of the underwater pile foundation, and extract the coordinates and elevation values of each point in the screened point cloud data; Obtain the scour radius, the radius of the underwater pile foundation, the radius related to the reference mud surface elevation, and the edge radius. Combine the coordinates of each point to divide the screened point cloud into a scour area, an edge area, and a reference mud surface area. After putting the elevation values of the points in the scour area, edge area, and reference mud surface area into different sets respectively, perform elevation value analysis on each set to obtain the elevation analysis result; Based on the elevation analysis results of different sets, calculate the volume of fill.

2. The underwater pile foundation scour calculation method according to claim 1, wherein The sets include: Scour area set: Points between the radius of the underwater pile foundation and the scour radius with the coordinates of the underwater pile foundation as the center, and their elevation values are put into the scour area set; Edge area set: Points between the scour radius and the edge radius with the coordinates of the underwater pile foundation as the center, and their elevation values are put into the edge area set; Reference mud surface elevation set: For points within the set radius area with the coordinates of the underwater pile foundation as the center, if the difference between the elevation value and the reference mud surface elevation is less than the threshold, then put their elevation values into the reference mud surface elevation set.

3. The underwater pile foundation scour calculation method according to claim 1, characterized in that, When the average elevation value of the edge area set is less than the average reference mud surface elevation, calculate the volume of fill, and the volume of fill is: V = ρ × S × (h0 - h1) Where h1 is the average elevation of the points below the average reference mud surface elevation in the scour area set, h0 is the reference mud surface elevation, S is the area of the scour area, and ρ is the fill volume coefficient.

4. The underwater pile foundation scour calculation method according to claim 1, characterized in that The elevation analysis result includes: the average reference mud surface elevation, the minimum elevation, maximum elevation, average elevation, and pit depth of the scour area, and the minimum elevation, maximum elevation, and average elevation of the edge area.

5. An underwater pile foundation scouring calculation system, characterized in that, Including: Point cloud acquisition module, which is configured to: obtain the point cloud data of the underwater pile foundation and its surrounding terrain; Point cloud screening module, which is configured to: obtain the coordinates of the underwater pile foundation and the radius of the square circular hole, judge the relationship between the coordinates of the underwater pile foundation, the radius of the square circular hole and the coordinates of each point in the point cloud data, screen the point cloud data, and screen out the point cloud data that is within the square area and outside the circular hole area around the coordinates of the underwater pile foundation, and extract the coordinates and elevation values of each point in the screened point cloud data; Elevation analysis module, which is configured to: obtain the scour radius, the radius of the underwater pile foundation, the radius related to the reference mud surface elevation, and the edge radius. Combine the coordinates of each point to divide the screened point cloud into a scour area, an edge area, and a reference mud surface area. After putting the elevation values of the points in the scour area, edge area, and reference mud surface area into different sets respectively, perform elevation value analysis on each set to obtain the elevation analysis result; Fill calculation module, which is configured to: calculate the volume of fill based on the elevation analysis results of different sets.

6. The underwater pile foundation scour calculation system according to claim 5, characterized in that The sets include: Scouring area set: Taking the underwater pile foundation coordinates as the center, the points between the underwater pile foundation radius and the scouring radius, and their elevation values are put into the scouring area set; Edge area set: Taking the underwater pile foundation coordinates as the center, the points between the scouring radius and the edge radius, and their elevation values are put into the edge area set; Reference mud surface elevation set: Taking the underwater pile foundation coordinates as the center, for the points within the set radius area, if the difference between the elevation value and the reference mud surface elevation is less than the threshold, then their elevation values are put into the reference mud surface elevation set.

7. The underwater pile foundation scour calculation system according to claim 5, characterized in that, When the average elevation value of the edge area set is less than the average elevation of the reference mud surface, calculate the filling volume, and the filling volume is: V = ρ × S × (h0 - h1) Where, h1 is the average elevation of the points in the scouring area set that are lower than the average reference mud surface elevation, h0 is the reference mud surface elevation, S is the area of the scouring area, and ρ is the filling volume coefficient.

8. The underwater pile foundation scour calculation system according to claim 5, characterized in that, The elevation analysis result includes: the average elevation of the reference mud surface, the minimum elevation, the maximum elevation, the average elevation and the pit depth of the scouring area, and the minimum elevation, the maximum elevation and the average elevation of the edge area.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the program is executed by the processor, it implements the steps in a method for calculating underwater pile foundation scouring described in any one of claims 1-4.

10. A computer device, comprising a computer-readable storage medium, a processor, and a computer program stored on the computer-readable storage medium and executable on the processor, characterized in that, When the processor executes the program, it implements the steps in a method for calculating underwater pile foundation scouring described in any one of claims 1-4.

Images