A dam earthwork quantity generation method, system, device and medium

Abstract

The application discloses a dam earthwork volume generation method, system, device and medium, and particularly relates to the technical field of water conservancy and hydropower engineering, and points are as follows: terrain point cloud data of a dam to-be-built area and dam excavation area data sources are acquired, and a terrain three-dimensional model and a dam excavation model are constructed; a seven-parameter Boolean algorithm is used for coordinate system conversion of the terrain three-dimensional model and the dam excavation model, and model fusion of the terrain three-dimensional model and the dam excavation model is performed; geometric parameters of a layered surface are determined, a total assembly three-dimensional model is subjected to grid cutting in a Dynamo grid cutting program based on the geometric parameters, a three-dimensional layered and blocked excavation entity model containing a plurality of dam excavation blocks is obtained, and earthwork volumes of each dam excavation block are obtained; a pre-constructed construction progress file is used to access the three-dimensional layered and blocked excavation entity model, a construction progress is associated with the plurality of dam excavation blocks in the three-dimensional layered and blocked excavation entity model, and a dynamic earthwork volume curve diagram is obtained.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of water conservancy and hydropower engineering, in particular to a dam earthwork volume generation method, system, device and medium. BACKGROUND

[0002] As the core infrastructure of national energy and water resources safety, earthwork engineering is the basic link in the whole cycle of water conservancy and hydropower engineering construction, and the calculation accuracy of engineering quantity directly determines the project cost control, construction resource allocation and progress plan, and has a decisive influence on project investment benefit and construction efficiency. In recent years, with the development of water conservancy and hydropower engineering towards high altitude, deep valley and large span, the topography involved in the engineering is more and more complex, and the scale of the original terrain data and the excavation design model increases exponentially. The traditional earthwork volume generation method has been difficult to adapt to the three requirements of high precision, high efficiency and high timeliness of modern engineering, and its inherent technical defects have gradually become the key bottleneck restricting the fine management of the project.

[0003] In the process of engineering construction, the traditional method relies on manual division of grid in drawing software, which is time-consuming and prone to error, and the cutting efficiency is low. Meanwhile, the original terrain and excavation model data sources are heterogeneous, and after superposition, gaps or overlaps may occur. Moreover, manual cutting cannot be associated with the construction progress in real time, and the earthwork volume needs to be updated manually, which affects the timeliness of decision-making.

[0004] Therefore, the present application aims to provide a dam earthwork volume generation method, system, device and medium to solve the above-mentioned related problems. SUMMARY

[0005] The technical problem to be solved by the present application is the low efficiency of manual cutting, large model fusion error and disconnection between progress and engineering quantity in the existing dam excavation process. The purpose is to provide a dam earthwork volume generation method, system, device and medium. The original terrain three-dimensional model of the mountain is generated by collecting terrain data by a drone, the dam excavation model is quickly constructed according to the design drawing, and the terrain model and the dam excavation model are assembled to form a total assembly three-dimensional model. Then, based on Dynamo, an automatic grid cutting program is prepared to pick up the boundary line and input the grid edge length data. Finally, a layered and block excavation entity three-dimensional model is generated, the earthwork quantity is output, and the dam construction progress simulation is carried out. Through the technical scheme, the technical personnel can quickly obtain the data operation and related control functions that cannot be provided by the conventional interface, and quickly and efficiently obtain the required grid model cutting, so as to realize the automatic output of dam excavation engineering quantity and progress simulation.

[0006] The present application is realized by the following technical scheme:

[0007] A dam earthwork volume generation method, the method comprising:

[0008] Obtain the terrain point cloud data of the dam body to be built area and the dam body excavation area data source, and construct the terrain three-dimensional model and the dam body excavation model respectively;

[0009] Perform coordinate system conversion on the terrain three-dimensional model and the dam body excavation model by using the seven-parameter Bursa algorithm, and perform model fusion on the terrain three-dimensional model and the dam body excavation model by using the Dynamo grid cutting program after coordinate conversion to obtain a total assembly three-dimensional model;

[0010] Determine the geometric parameters of the layer surface, perform grid cutting on the total assembly three-dimensional model based on the geometric parameters in the Dynamo grid cutting program to obtain a three-dimensional layered and blocked excavation entity model containing multiple dam body excavation blocks, and the earthwork volume of each dam body excavation block;

[0011] Use the pre-constructed construction progress file to access the three-dimensional layered and blocked excavation entity model, associate the construction progress with the multiple dam body excavation blocks in the three-dimensional layered and blocked excavation entity model, and obtain a dynamic earthwork volume curve graph.

[0012] Further, obtain the terrain point cloud data of the dam body to be built area and the dam body excavation area data source, and construct the terrain three-dimensional model and the dam body excavation model respectively, specifically:

[0013] Obtain the terrain point cloud data of the dam body to be built area by using a drone, and generate a triangular mesh by grouping the discrete points of the terrain point cloud data according to X-Y-Z coordinates; splice the triangular mesh into a continuous surface, and generate a terrain three-dimensional model in Revit software;

[0014] Based on the dam body excavation area data source in the pre-constructed dam body design drawing, extract the excavation interface contact points in the dam body excavation area data source; construct a dam body excavation model by using the excavation interface contact points.

[0015] Further, perform coordinate system conversion on the terrain three-dimensional model and the dam body excavation model by using the seven-parameter Bursa algorithm, specifically:

[0016] Uniformly arrange multiple control points in the dam area, measure the WGS84 coordinates of the multiple control points by using a GNSS receiver, and measure the construction coordinates of the multiple control points by using a total station;

[0017] Based on the WGS84 coordinates and the construction coordinates, perform coordinate system conversion on the terrain three-dimensional model and the dam body excavation model by using the seven-parameter Bursa algorithm.

[0018] Further, the geometric parameters of the layer surface include the height, length and width of the layer surface.

[0019] Further, the geometric parameters of the layers are determined, the total assembly three-dimensional model is meshed based on the geometric parameters in the Dynamo meshing program, and a three-dimensional layered and block excavation entity model containing a plurality of dam body excavation blocks is obtained, specifically:

[0020] The geometric parameters of the layers are obtained based on the pre-constructed dam body design scheme and the excavation layer elevations;

[0021] According to the excavation layer elevations and the geometric parameters of the layers, a reference plane and a plurality of layer surfaces are created in the Dynamo meshing program;

[0022] The intersection lines of each layer surface with the terrain three-dimensional model or the dam body excavation model are determined by using the geometric intersection module of the Dynamo meshing program;

[0023] The plurality of intersection lines are projected and combined with the boundary lines of the dam body excavation model to generate a plurality of excavation range ground projection areas;

[0024] Based on the plurality of excavation range ground projection areas, preset grid length data is input, the grid points are projected to the surface of the total assembly three-dimensional model along the Z axis by using the ray method, and the total assembly three-dimensional model is meshed to form a three-dimensional layered and block excavation entity model.

[0025] Further, the pre-constructed construction progress file is connected to the three-dimensional layered and block excavation entity model, the construction progress is associated with the plurality of dam body excavation blocks in the three-dimensional layered and block excavation entity model, and a dynamic earthwork quantity curve graph is obtained, specifically:

[0026] The construction progress WBS code in the pre-constructed construction progress file is obtained, and the construction progress WBS code is associated with the plurality of dam body excavation blocks in the three-dimensional layered and block excavation entity model;

[0027] Based on the earthwork quantity of each dam body excavation block, the total earthwork quantity of each construction progress is obtained;

[0028] The dynamic earthwork quantity curve graph is obtained by combining the total earthwork quantity of each construction progress and the time parameter of the construction progress.

[0029] The application also provides a dam earthwork quantity generation system, which is used in the dam earthwork quantity generation method described above, and the system comprises:

[0030] A model construction module is configured to obtain terrain point cloud data of a dam body to-be-built area and dam body excavation area data sources, and construct a terrain three-dimensional model and a dam body excavation model, respectively;

[0031] The model fusion module is used for coordinate system conversion of the terrain three-dimensional model and the dam body excavation model by using a seven-parameter Bursa algorithm, and model fusion of the terrain three-dimensional model and the dam body excavation model by using a Dynamo grid cutting program after coordinate conversion, so as to obtain a total assembly three-dimensional model;

[0032] The earthwork volume generation module is used for determining geometric parameters of a layered surface, cutting a grid of the total assembly three-dimensional model based on the geometric parameters in the Dynamo grid cutting program, so as to obtain a three-dimensional layered and blocked excavation entity model containing a plurality of dam body excavation blocks, and earthwork volumes of each dam body excavation block;

[0033] The dynamic curve generation module is used for connecting the three-dimensional layered and blocked excavation entity model with a construction progress by using a pre-constructed construction progress file, associating the construction progress with the plurality of dam body excavation blocks in the three-dimensional layered and blocked excavation entity model, so as to obtain a dynamic earthwork volume curve diagram.

[0034] The application further provides a computer device including a system memory and a processor, the system memory stores a computer program, and the processor implements the steps of the method in any one of the above methods when executing the computer program.

[0035] The application further provides a computer readable storage medium, which stores a computer program, and the computer program implements the steps of the method in any one of the above methods when executed by a processor.

[0036] The application further provides a computer program product containing instructions, which, when executed by a computer device cluster, causes the computer device cluster to execute the method in any one of the above methods.

[0037] Compared with the prior art, the application has the following advantages and beneficial effects:

[0038] In the application, the terrain data is collected by a UAV to generate a mountain original terrain three-dimensional model, a dam body excavation model is quickly constructed according to design drawings, the terrain model and the dam body excavation model are assembled to form a total assembly three-dimensional model, then an automatic grid cutting program is compiled based on Dynamo to pick up a boundary line and input grid edge length data, finally a layered and blocked excavation entity three-dimensional model is generated, earthwork engineering quantities are output, and dam body construction progress simulation is performed; through the technical solution, a technical personnel can quickly obtain data operation and control functions that cannot be provided by a non-conventional interface, and can quickly and efficiently obtain a required grid model cutting, so as to realize automatic output of dam body excavation engineering quantities and progress simulation. BRIEF DESCRIPTION OF DRAWINGS

[0039] In order to more clearly illustrate the technical solutions of the exemplary embodiments of the present application, the following will briefly introduce the drawings needed to be used in the embodiments. It should be understood that the following drawings only show some of the embodiments of the present application, and therefore should not be considered as limiting the scope. For those skilled in the art, other related drawings can also be obtained without creative labor. In the drawings:

[0040] Figure 1 The method flow diagram of the dam earthwork volume generation method in the embodiment is shown in the figure.

[0041] Figure 2 The module connection diagram of the dam earthwork volume generation system in the embodiment is shown in the figure.

[0042] Figure 3 The structure diagram of the computer device in the embodiment is shown in the figure. DETAILED DESCRIPTION

[0043] The exemplary embodiments of the present disclosure are described below in conjunction with the accompanying drawings, which include various details of the embodiments of the present disclosure to help understanding, and should be considered as merely exemplary. Therefore, those skilled in the art should recognize that various changes and modifications can be made to the embodiments described herein without departing from the scope of the present disclosure. Also, in order to be clear and concise, the description below omits the description of well-known functions and structures.

[0044] In the present disclosure, the terms "first", "second", and the like are used to describe various elements, and are not intended to limit the positional relationship, time sequence relationship or importance relationship of the elements, and the terms are only used to distinguish one element from another. In some examples, the first element and the second element can refer to the same instance of the element, and in some cases, based on the context of the description, they can also refer to different instances.

[0045] The terms used in the description of various examples in the present disclosure are only for the purpose of describing the specific examples, and are not intended to be limiting. Unless the number of elements is specifically limited, the element can be one or more. In addition, the term "and / or" used in the present disclosure covers any one of the listed items and all possible combinations.

[0046] Embodiment 1

[0047] Referring to Figure 1 , Figure 1 A method flow diagram of a dam earthwork volume generation method is shown, wherein the method comprises:

[0048] S1: Obtain the terrain point cloud data of the dam body to be built area and the dam body excavation area data source, and construct a terrain three-dimensional model and a dam body excavation model respectively;

[0049] Specifically, in the present embodiment, the terrain point cloud data of the dam body to be built area is obtained by using a UAV, and the discrete points of the terrain point cloud data are grouped according to X-Y-Z coordinates to generate a triangular mesh; the triangular mesh is spliced into a continuous curved surface, and a terrain three-dimensional model is generated in Revit software;

[0050] Based on the dam body excavation area data source in the pre-constructed dam body design drawing, the excavation interface contact points are extracted in the dam body excavation area data source; the dam body excavation model is constructed by using the excavation interface contact points.

[0051] It should be noted that in the present embodiment, the dam body design drawing is constructed in advance before construction, and the extraction of the excavation interface contact points in the dam body excavation area data source in the dam body design drawing is known to those skilled in the art, and will not be described in detail here.

[0052] S2: The terrain three-dimensional model and the dam body excavation model are subjected to coordinate system conversion by using a seven-parameter Bursa algorithm, and after the coordinate conversion, the terrain three-dimensional model and the dam body excavation model are subjected to model fusion by using a Dynamo grid cutting program to obtain a general assembly three-dimensional model;

[0053] Specifically, in the present embodiment, at least six control points are uniformly arranged in the dam area, and the WGS84 coordinates of the plurality of control points are measured by a GNSS receiver, and the construction coordinates of the plurality of control points are measured by a total station;

[0054] Based on the WGS84 coordinates and the construction coordinates, the terrain three-dimensional model and the dam body excavation model are subjected to coordinate system conversion by using a seven-parameter Bursa algorithm, specifically: seven parameters are solved by a least square method, and the calculation formula is wherein, represents the construction coordinates of each axis; represents the coordinate translation of each axis; represents the scale factor; represents the rotation matrix; represents the WGS84 coordinates of each axis; at the same time, the control point residual error after settlement is required to be not more than 0.05m in the plane and not more than 0.1m in the elevation; the calibrated parameters are implanted into the Dynamo program to realize automatic conversion of the coordinate system;

[0055] After the coordinate conversion, the terrain three-dimensional model and the dam body excavation model are subjected to model fusion by using a Dynamo grid cutting program to obtain a general assembly three-dimensional model.

[0056] S3: Determine the geometric parameters of the layer surface, perform mesh cutting on the total assembly three-dimensional model based on the geometric parameters in the Dynamo mesh cutting program, obtain a three-dimensional layered and blocked excavation entity model containing multiple dam body excavation blocks, and the earthwork volume of each dam body excavation block;

[0057] Specifically, in this embodiment, the geometric parameters of the layer surface include the height, length and width of the layer surface.

[0058] First, the geometric parameters of the layer surface and the excavation layer elevation are obtained based on the pre-constructed dam design scheme.

[0059] According to the excavation layer elevation and the geometric parameters of the layer surface, a reference plane and multiple layer surfaces are created through API in the Dynamo mesh cutting program. In this embodiment, two layer surfaces are created as examples, which are the first layer surface and the second layer surface. The first layer surface corresponds to the interface between the original terrain and the excavation, and the second layer surface corresponds to the excavation design bottom surface or a certain construction layer elevation.

[0060] The intersection lines of each layer surface with the terrain three-dimensional model or the dam excavation model are determined by using the geometric intersection module of the Dynamo mesh cutting program. In this embodiment, the intersection line A is generated by the first layer surface and the terrain three-dimensional model boundary surface, and the intersection line B is generated by the second layer surface and the dam excavation model.

[0061] The multiple intersection lines are projected and combined with the dam excavation model boundary line to generate multiple excavation range bottom surface projection areas. In this embodiment, the intersection lines A and B are projected and combined with the dam excavation model boundary line to generate the excavation range bottom surface projection area C.

[0062] Based on the multiple excavation range ground projection areas, preset grid length data is input, the grid points are projected back along the Z axis to the surface of the total assembly three-dimensional model using the ray method, and the total assembly three-dimensional model is mesh cut to form a three-dimensional layered and blocked excavation entity model. Specifically, first, the terrain three-dimensional model and the first layer surface are selected as the upper surface of mesh cutting, and then the dam excavation model and the second layer surface are selected as the lower surface of mesh cutting. Then, after inputting the grid length data (n=1, 2, 3...) based on the excavation range bottom surface projection area C, the program preferentially identifies the terrain curvature, and when the curvature K>25°, the grid is automatically encrypted, and then the grid points are projected back along the Z axis to the surface of the total assembly three-dimensional model using the ray method, and the total assembly three-dimensional model is mesh cut to form a three-dimensional layered and blocked excavation entity model.

[0063] It should be noted that in this embodiment, the dam design scheme is set in advance before construction, which includes the geometric parameters of the layer surface and the excavation layer elevation. This technical content is known to those skilled in the art, and will not be described in detail here.

[0064] S4: access the three-dimensional layered and block excavation entity model by using the pre-constructed construction progress file, associate the construction progress with the plurality of dam body excavation blocks in the three-dimensional layered and block excavation entity model, and obtain a dynamic earthwork quantity curve graph.

[0065] Specifically, in the embodiment, first, the pre-constructed construction progress file is imported into the Project / P6 progress software, and then the three-dimensional layered and block excavation entity model is interfaced with the Project / P6 progress software application program interface; then the construction progress WBS code in the pre-constructed construction progress file is obtained, and the construction progress WBS code is associated with the plurality of dam body excavation blocks in the three-dimensional layered and block excavation entity model, respectively;

[0066] After the time parameter is input, the system automatically queries the task interval to which the current time belongs, extracts the dam body excavation block ID corresponding to the task interval; based on the extracted dam body excavation block ID, the earthwork quantity of the corresponding dam body excavation block is extracted, and the total earthwork quantity of each construction progress is obtained;

[0067] The total earthwork quantity of each construction progress and the time parameter of the construction progress are combined to obtain a dynamic earthwork quantity curve graph; at the same time, the OverrideGraphicSettings method of Revit API is used to set the block color to realize automatic highlight display; in the embodiment, gray is set to represent unexcavated, red is set to represent in progress, and green is set to represent completed, and other colors can also be used in other embodiments, which will not be described in detail here.

[0068] Specifically, in the embodiment, the terrain data is collected by the unmanned aerial vehicle to generate a mountain original terrain three-dimensional model, the dam body excavation model is quickly constructed according to the design drawing, and the terrain model and the dam body excavation model are assembled to form a total assembly three-dimensional model; then an automatic mesh cutting program is compiled based on Dynamo to pick up the boundary line and input the mesh edge length data, and finally a layered and block excavation entity three-dimensional model is generated, the earthwork quantity is output, and the dam body construction progress simulation is performed; through the technical solution, the technical personnel can quickly obtain the data operation and related control functions that cannot be provided by the irregular interface, and can quickly and efficiently obtain the required mesh model cutting, so as to realize automatic output of the dam body excavation quantity and progress simulation.

[0069] Embodiment 2

[0070] Referring to Figure 2 The application further provides a dam body earthwork quantity generation system, which is used in the dam body earthwork quantity generation method described in any one of the above embodiments, and comprises:

[0071] The model construction module 100 is configured to acquire terrain point cloud data of a dam body to-be-constructed area and dam body excavation area data sources, and construct a terrain three-dimensional model and a dam body excavation model, respectively.

[0072] The model fusion module 200 is configured to perform coordinate system conversion on the terrain three-dimensional model and the dam body excavation model by using a seven-parameter Bursa algorithm, and perform model fusion on the terrain three-dimensional model and the dam body excavation model by using a Dynamo grid cutting program after coordinate conversion, to obtain a total assembly three-dimensional model.

[0073] The earthwork volume generation module 300 is configured to determine geometric parameters of a layered surface, perform grid cutting on the total assembly three-dimensional model based on the geometric parameters in the Dynamo grid cutting program, to obtain a three-dimensional layered and blocked excavation entity model containing a plurality of dam body excavation blocks, and earthwork volumes of each dam body excavation block.

[0074] The dynamic curve generation module 400 is configured to access the three-dimensional layered and blocked excavation entity model by using a pre-constructed construction progress file, associate the construction progress with the plurality of dam body excavation blocks in the three-dimensional layered and blocked excavation entity model, and obtain a dynamic earthwork volume curve graph.

[0075] It should be noted that the modules in the system of Embodiment 2 correspond to the steps in the method of Embodiment 1, and the steps in the method of Embodiment 1 have been described in detail in Embodiment 1, and the content of the modules in the system will not be described in detail in Embodiment 2.

[0076] Embodiment 3

[0077] The embodiment also provides a computer device including a system memory 1005 and a processor 1001, the system memory 1005 stores a computer program, and the processor 1001 implements the steps of the method of any one of the above embodiments when executing the computer program.

[0078] It should be noted that the processor 1001 is configured to execute the steps in the method embodiments described above according to instructions in the program code. Alternatively, the processor 1001 implements the functions of each module / unit in each system / device embodiment described above when executing the computer program.

[0079] Specifically, in the embodiment, the computer program can be divided into one or more modules / units, and the one or more modules / units are stored in the system memory 1005 and executed by the processor 1001 to complete the present application. The one or more modules / units can be a series of computer program instruction segments capable of completing a specific function, and the instruction segments are used to describe the execution process of the computer program in the terminal device.

[0080] The terminal device can be a desktop computer, a notebook computer, a palm computer, a cloud server, and the like. The terminal device can include, but is not limited to, a processor 1001, a system memory 1005. Those skilled in the art can understand that the terminal device is not limited to the above, and can include more or less components, or combine some components, or different components, for example, the terminal device can also include an input / output device 1003, a network access device 1002, a bus 1006, and the like.

[0081] The processor 1001 can be a central processing unit (CPU), and can also be other general-purpose processors, a digital signal processor (DSP), an application specific integrated circuit (ASIC), a field-programmable gate array (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, and the like. The general-purpose processor can be a microprocessor or the processor can also be any conventional processor.

[0082] The system memory 1005 can be an internal storage unit of the terminal device, for example, a hard disk or a memory of the terminal device. The system memory 1005 can also be a storage device 1004 of the terminal device, for example, a plug-in hard disk, a smart media card (SMC), a secure digital (SD) card, a flash card, and the like. Further, the system memory 1005 can include both the internal storage unit and the storage device 1004 of the terminal device. The system memory 1005 is used to store computer programs and other programs and data required by the terminal device. The system memory 1005 can also be used to temporarily store data that has been output or will be output.

[0083] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the above-described system, system and unit can refer to the corresponding processes in the foregoing method embodiments, which will not be described herein.

[0084] Embodiment 4

[0085] The embodiment provides a computer readable storage medium, which stores a computer program. The computer program is executed by a processor to implement the steps of the method in any one of the above embodiments.

[0086] The computer readable storage medium, for example, can be, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, or apparatus or device, or any suitable combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium include: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or Flash memory), registers, a hard disk, an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. The computer readable storage medium of the foregoing is non-transitory only in the general sense that it does not have its data modified by the program executing on the computer system. The computer readable storage medium of the foregoing remains tangible even though non-transitory.

[0087] An exemplary storage medium is coupled to the processor such that the processor can read information from, and can write information to, the storage medium. Of course, the storage medium can be part of the processor. Consistent with the teachings of the present disclosure, a storage medium can be implemented using any appropriate media, such as optical, magnetic or semiconductor storages. In the present embodiment, the computer readable storage medium can be any tangible medium that can contain or store a program for use by or in connection with an instruction execution system, apparatus, or device.

[0088] Embodiment 5

[0089] The present embodiment also provides a computer program product containing instructions which, when executed by a cluster of computer devices, cause the cluster of computer devices to perform the method as described in embodiment 1.

[0090] The above detailed description merely describes exemplary embodiments of the application, and is not intended to limit the scope of the application. The above examples are merely illustrative, and the present application is not limited thereto. Rather, the present application is limited only by the claims.

Claims

1. A method for generating the earthwork volume of a dam body, characterized in that the method... include: Obtain topographic point cloud data of the area to be built and data source of the dam excavation area, and construct a 3D topographic model and a dam excavation model respectively; The seven-parameter Bursa algorithm was used to transform the coordinate system of the terrain 3D model and the dam excavation model. After the coordinate transformation, the Dynamo mesh cutting program was used to fuse the terrain 3D model and the dam excavation model to obtain the general assembly 3D model. Determine the geometric parameters of the layers, and perform mesh cutting on the 3D model of the general assembly based on the geometric parameters in the Dynamo mesh cutting program to obtain a 3D layered and block excavation solid model containing multiple dam excavation blocks, as well as the earthwork volume of each dam excavation block. By integrating a pre-built construction schedule file into a three-dimensional layered and block-based excavation entity model, the construction schedule is associated with multiple dam excavation blocks in the three-dimensional layered and block-based excavation entity model, resulting in a dynamic earthwork volume curve. The process involves determining the geometric parameters of each layer, and then meshing the 3D model of the assembly unit using the Dynamo meshing program to obtain a 3D layered and segmented excavation entity model containing multiple dam excavation blocks. Specifically, this involves: obtaining the geometric parameters and excavation layer elevations of each layer based on a pre-constructed dam design scheme; creating a reference plane and multiple layers in the Dynamo meshing program based on the excavation layer elevations and the geometric parameters of each layer; using the geometric intersection module of the Dynamo meshing program to determine the intersection lines between each layer and the 3D terrain model or the dam excavation model; projecting and combining the multiple intersection lines with the boundary lines of the dam excavation model to generate multiple bottom surface projection areas of the excavation range; inputting preset mesh side length data based on the multiple ground projection areas of the excavation range, and using the ray casting method to back-project the mesh points along the Z-axis onto the surface of the 3D model of the assembly unit, and then meshing the 3D model of the assembly unit to form a 3D layered and segmented excavation entity model. By integrating a pre-built construction schedule file into a 3D layered and segmented excavation entity model, and associating the construction schedule with multiple dam excavation blocks in the 3D layered and segmented excavation entity model, a dynamic earthwork volume curve is obtained. Specifically, the construction schedule WBS code in the pre-built construction schedule file is obtained, and the construction schedule WBS code is associated with multiple dam excavation blocks in the 3D layered and segmented excavation entity model; based on the earthwork volume of each dam excavation block, the total earthwork volume of each construction schedule is obtained; and by combining the total earthwork volume of each construction schedule with the time parameter of the construction schedule, a dynamic earthwork volume curve is obtained.

2. The method for generating the earthwork volume of a dam body according to claim 1, characterized in that, The topographic point cloud data of the area to be built and the data source of the dam excavation area were obtained, and a 3D topographic model and a dam excavation model were constructed respectively, specifically as follows: UAVs were used to acquire topographic point cloud data of the area to be built on the dam, and the discrete points of the topographic point cloud data were grouped according to the XYZ coordinates to generate triangular meshes; the triangular meshes were spliced ​​into a continuous surface, and a 3D topographic model was generated in Revit software; Based on the data source of the dam excavation area in the pre-constructed dam design drawings, the contact points of the excavation interface are extracted from the data source of the dam excavation area. A dam excavation model was constructed using the contact points at the excavation interface.

3. The method for generating the earthwork volume of a dam body according to claim 1, characterized in that, The seven-parameter Bursa algorithm is used to perform coordinate system transformation on the 3D terrain model and the dam excavation model, specifically as follows: Multiple control points were evenly distributed in the dam area, and the WGS84 coordinates of the multiple control points were measured using a GNSS receiver. The construction coordinates of the multiple control points were measured using a total station. Based on WGS84 coordinates and construction coordinates, the seven-parameter Bursa algorithm is used to perform coordinate system transformation on the 3D terrain model and the dam excavation model.

4. The method for generating the earthwork volume of a dam body according to claim 1, characterized in that, The geometric parameters of a layer include its height, length, and width.

5. A system for generating earthwork volume of a dam body, characterized in that, This system is used in the method for generating earthwork volume of a dam body according to any one of claims 1-4, the system comprising: The model building module is used to acquire topographic point cloud data of the area to be built and data source of the dam excavation area, and to build a 3D topographic model and a dam excavation model respectively. The model fusion module is used to perform coordinate system transformation on the terrain 3D model and the dam excavation model using the seven-parameter Bursa algorithm, and then use the Dynamo mesh cutting program to fuse the terrain 3D model and the dam excavation model to obtain the overall assembly 3D model. The earthwork volume generation module is used to determine the geometric parameters of the layers. Based on the geometric parameters, the 3D model of the assembly is meshed in the Dynamo mesh cutting program to obtain a 3D layered and block excavation entity model containing multiple dam excavation blocks, as well as the earthwork volume of each dam excavation block. The dynamic curve generation module is used to connect the pre-built construction progress file to the three-dimensional layered and block-based excavation entity model, associate the construction progress with multiple dam excavation blocks in the three-dimensional layered and block-based excavation entity model, and obtain a dynamic earthwork volume curve.

6. A computer device comprising a system memory and a processor, wherein the system memory stores a computer program, characterized in that, When the processor executes the computer program, it implements the steps of the method according to any one of claims 1 to 4.

7. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by a processor, it implements the steps of the method described in any one of claims 1 to 4.

8. A computer program product containing instructions, characterized in that, When the instructions are executed by a cluster of computer devices, the cluster of computer devices causes the cluster of computer devices to perform the method as described in any one of claims 1 to 4.

Images