Dynamo-based municipal drainage pipe network automatic modeling method

Abstract

The invention discloses a Dynamo-based municipal drainage pipe network automatic modeling method, and relates to the technical field of building information model and municipal pipe network modeling. An external data file containing inspection well and pipeline information is created, automatic data analysis and processing are achieved through a Dynamo environment, and a parameterized data set is generated. And automatically generating an inspection well family instance based on the inspection well space coordinate attribute subset, and generating a pipeline family instance in combination with the pipeline connection relation attribute subset to realize endpoint space association. According to the method, classified generation of the sewage pipe network and the rainwater pipe network is supported, batch processing is achieved through List.FilterByBoolMask nodes, the modeling time is obviously shortened, the modeling efficiency is remarkably improved, and dynamic synchronization of the model is supported by updating external data files.

Description

Technical Field

[0001] This invention relates to the field of building information modeling and municipal pipeline network modeling technology, specifically to an automatic modeling method for municipal drainage pipeline networks based on Dynamo. Background Technology

[0002] In municipal drainage engineering, the drainage network system, composed of drainage pipes and manholes, is an important component of urban infrastructure. Currently, the construction of the network's BIM model primarily relies on designers manually placing manholes and pipes point-by-point in Revit software, and manually inputting coordinates, elevations, and connection data.

[0003] However, this process is cumbersome, time-consuming, and prone to data deviations due to manual input, such as inconsistent coordinate units or incorrect elevation values, leading to decreased model accuracy. Furthermore, when external data (such as survey coordinates or design elevations) needs frequent updates, manual model modification is labor-intensive, easily causing inconsistencies between the model and design information, affecting the real-time nature and traceability of engineering designs. Currently, although some automated tools assist in modeling, most still rely on customized scripts, lacking versatility and unable to efficiently handle the batch generation and parameter synchronization of point and line-type construction elements.

[0004] Therefore, there is an urgent need in this field for an automated modeling method that can automatically read external data files and generate manhole and pipe models in batches in Revit, so as to improve the efficiency and accuracy of BIM model modeling. Summary of the Invention

[0005] The purpose of this invention is to provide an automatic modeling method for municipal drainage pipe networks based on Dynamo, so as to overcome the above-mentioned problems in the existing technology. It realizes the parametric construction of manhole and pipe models through external data file driving, and realizes the automated interaction between data and model by using the Dynamo visual programming environment, thereby reducing manual intervention and improving the level of modeling intelligence.

[0006] To achieve the above objectives, the technical solution adopted by the present invention is as follows: An automatic modeling method for municipal drainage networks based on Dynamo includes the following steps: Create an external data file containing information on manholes and pipelines. The manhole data should include at least the manhole number, X coordinate, Y coordinate, and ground elevation. The pipeline data should include at least the bottom elevation, pipe diameter, starting manhole number, and ending manhole number. Import the external data file into the Dynamo environment, read the file content through Dynamo nodes, and parse it into a structured data list; The structured data list is processed to unify units and standardize format to generate a parameterized data set, wherein the parameterized data set includes a subset of manhole spatial coordinate attributes and a subset of pipeline connection relationship attributes; Based on the parameterized dataset, construct a parameterized modeling script in the Dynamo environment; Based on the subset of spatial coordinate attributes of the manholes, manhole family instances are automatically generated in Revit through Dynamo nodes, and the parameters parsed from external data files are automatically mapped to the parameters of the manhole family instances. Based on the subset of pipe connection relationship attributes and the spatial coordinates in the manhole family instance, a pipe family instance is automatically generated in Revit through Dynamo nodes, wherein the endpoints of the pipe family instance are spatially associated with the corresponding manhole family instance. Run the parametric modeling script to integrate the manhole family instance and pipe family instance, and output a complete drainage network BIM model in Revit. The BIM model supports dynamic adjustment of model parameters by updating external data files.

[0007] Furthermore, the external data file is in Excel or CSV format, and the inspection well data and pipeline data are stored in a tabular organization.

[0008] Furthermore, the step of reading file content and parsing it into a structured data list through Dynamo nodes specifically includes: selecting a file path through the File.Path node, reading the file content using the Date.ImportExcel node to generate a two-dimensional data list, and transposing the two-dimensional data list by row and column through the List.Transpose node to form the structured data list.

[0009] Furthermore, the unit unification and format standardization processing includes: unifying the X and Y coordinates in the inspection well data into metric units; unifying the pipe diameter in the pipeline data into millimeter units; performing offset correction processing on the X and Y coordinates; and standardizing the data format, including data structure normalization and field alignment.

[0010] Furthermore, the automatic generation of manhole family instances in Revit via Dynamo nodes specifically includes: generating manhole family instances based on the subset of manhole spatial coordinate attributes using the FamilyInstance.ByPoint node, and batch setting manhole number, manhole depth, manhole cover elevation, and manhole bottom elevation parameters for the manhole family instances using the Element.SetParameterByName node with a loop-based automatic assignment method, wherein the manhole depth is automatically calculated by the difference between the manhole cover elevation and the manhole bottom elevation.

[0011] Furthermore, the automatic generation of pipe family instances in Revit via Dynamo nodes specifically includes: generating pipe family instances based on a subset of pipe connection relationship attributes and spatial coordinates in the manhole family instance using the AdaptiveComponent.ByPoints node, and setting the pipe diameter, starting elevation, ending elevation, and slope parameters using the Element.SetParameterByName node.

[0012] Furthermore, the dynamic adjustment of the BIM model includes: when the external data file is modified, the model parameters are automatically synchronized by rerunning the parametric modeling script to maintain the consistency between the model and the external data file.

[0013] Furthermore, the municipal drainage network includes sewage network and rainwater network.

[0014] Furthermore, the manhole family instances and pipe family instances can be generated according to the type of pipeline network, and the List.FilterByBoolMask node can be used to collaboratively filter and batch process different types of manholes and pipes.

[0015] Another objective of this invention is to provide the application of the aforementioned Dynamo-based automatic modeling method for municipal drainage networks in the automated modeling of municipal water supply networks, gas pipelines, or heating networks.

[0016] Compared with the prior art, the present invention has the following beneficial effects: First, by using external files to drive automatic model generation, manual operation steps are significantly reduced, human input errors are avoided, and modeling efficiency and accuracy are improved. Secondly, it supports rapid data updates and model synchronization. When external data changes, users only need to update the Excel or CSV file and rerun the script to achieve real-time model synchronization, ensuring the consistency between design and model, and effectively solving the problem of lagging model updates in existing technologies. Furthermore, this invention has good scalability and is not only applicable to municipal drainage networks (such as sewage networks and rainwater networks), but can also be extended to the modeling of point and line structural elements such as municipal water supply networks, gas pipelines and heating networks. Through parametric design, multi-dimensional model management is achieved, improving the traceability and reliability of engineering data. Attached Figure Description

[0017] Figure 1 This is a flowchart of the method of the present invention; Figure 2 This is a schematic diagram of the external data file of the present invention; Figure 3This is a schematic diagram of the BIM model generated in the Revit environment of this invention. Detailed Implementation

[0018] To make the objectives, technical solutions, and advantages of this invention clearer, the invention will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the invention. Furthermore, the technical features involved in the various embodiments of this invention described below can be combined with each other as long as they do not conflict with each other.

[0019] This embodiment provides an automatic modeling method for municipal drainage pipe networks based on Dynamo. Figure 1 The process includes the following steps: creating an external data file containing manhole and pipeline information, wherein the manhole data includes at least the manhole number, X coordinate, Y coordinate, and ground elevation, and the pipeline data includes at least the pipe bottom elevation, pipe diameter, starting manhole number, and ending manhole number; importing the external data file into the Dynamo environment, reading the file content through Dynamo nodes, and parsing it into a structured data list; performing unit unification and format standardization processing on the structured data list to generate a parametric data set, wherein the parametric data set includes a subset of manhole spatial coordinate attributes and a subset of pipeline connection relationship attributes; constructing a parametric modeling script in the Dynamo environment based on the parametric data set; and... The subset of spatial coordinate attributes of the manholes is used to automatically generate manhole family instances in Revit via Dynamo nodes, and to automatically map the parameters parsed from the external data file to the parameters of the manhole family instances. Based on the subset of pipe connection relationship attributes and the spatial coordinates in the manhole family instances, pipe family instances are automatically generated in Revit via Dynamo nodes, wherein the endpoints of the pipe family instances are spatially associated with the corresponding manhole family instances. The parametric modeling script is run to integrate the manhole family instances and pipe family instances, and to output a complete drainage network BIM model in Revit. The BIM model supports dynamic adjustment of model parameters by updating the external data file. The above method process is described in detail below with reference to embodiments.

[0020] 1. Create an external data file containing information on manholes and pipelines. The manhole data should include at least the manhole number, X coordinate, Y coordinate, and ground elevation. The pipeline data should include at least the bottom elevation, pipe diameter, starting manhole number, and ending manhole number.

[0021] First, users need to create an external data file containing complete information on manholes and pipelines. This file serves as the data source for the entire automated modeling process. For example... Figure 2As shown, this file uses an industry-standard table organization format. It is recommended to use Excel format (.xlsx) or CSV format (.csv). The storage path can be customized by the user according to project needs, such as C:\Project\ModelData\Drainage_Network.xlsx.

[0022] The manhole data section of the document should include the following core fields: manhole number (e.g., Y01, Y02, etc., as a unique identifier), X-coordinate (plane coordinate, unit: meters), Y-coordinate (plane coordinate, unit: meters), and ground elevation (unit: meters); the pipeline data section should include: pipe bottom elevation (unit: meters), pipe diameter (unit: millimeters), starting manhole number, and ending manhole number. The manhole number field ensures that each manhole has a unique identifier, facilitating system identification and differentiation of different manholes; the starting and ending manhole numbers are used to precisely define the topological connections between pipelines, forming a complete pipeline network system.

[0023] When creating data files, attention should be paid to the standardization of field naming and the consistency of data format. For coordinate data, all coordinate values ​​should use a unified coordinate system, such as a local coordinate system or a national geodetic coordinate system; for elevation data, the datum should be clearly defined, such as the Yellow Sea elevation system. Pipeline connections should form a closed network system, avoiding isolated manholes or pipelines. This standardized data preparation lays the foundation for subsequent automated processing, demonstrating the advantages of improving modeling quality through standardized data input.

[0024] Second, the external data file is imported into the Dynamo environment, and its content is read and parsed into a structured data list using Dynamo nodes. Specifically, reading the file content and parsing it into a structured data list using Dynamo nodes includes: selecting the file path using the File.Path node, using the Date.ImportExcel node to read the file content and generate a two-dimensional data list, and then transposing the two-dimensional data list using the List.Transpose node to form the structured data list. This specific implementation process of importing the external data file into the Dynamo environment achieves the crucial transformation from raw data to a format that the program can process.

[0025] First, the storage path of the external data file is selected through Dynamo's "File.Path" node, establishing a connection between the program and the data file. Then, the "Date.ImportExcel" node (or "Date.ImportCsv" node when processing CSV format files) is used to read the file content, converting the tabular data into a two-dimensional data structure.

[0026] After the data is read, the "List.Transpose" node performs a row and column transpose operation on the two-dimensional data list. This step converts the data, originally organized by rows, into an organized list by columns, so that the data for each field forms an independent list structure. Then, the "List.GetItemAtIndex" node precisely extracts the data for each field according to the preset column index values, including key parameters such as X-coordinate, Y-coordinate, ground elevation, and pipe bottom elevation. The index values ​​should be configured according to the actual column order of the data table; for example, index 0 corresponds to the manhole number, index 1 corresponds to the X-coordinate, and so on.

[0027] This complete data processing workflow can automatically identify and parse external data files of different formats, effectively eliminating errors that may arise from manual data entry, while ensuring the accuracy and efficiency of data extraction. This structured data processing approach provides high-quality data input for subsequent parametric modeling.

[0028] Third, the structured data list is processed to unify units and standardize format to generate a parameterized data set, wherein the parameterized data set includes a subset of manhole spatial coordinate attributes and a subset of pipeline connection relationship attributes.

[0029] The parsed structured data list undergoes comprehensive unit unification and format standardization to generate a parametric data set that conforms to the Revit environment requirements. This includes: unifying the X and Y coordinates of the manhole data to metric units; unifying the pipe diameters of the pipe data to millimeters; performing offset correction on the X and Y coordinates; and standardizing the data format, including data structure normalization and field alignment. Specifically, this includes the following key processing steps: First, unit standardization is performed. The X and Y coordinates in the manhole data are standardized to metric units to ensure all coordinate values ​​use a consistent unit of length. For pipe diameter parameters in the pipeline data, millimeter units are used to ensure compliance with industry standards. Accuracy must be maintained during unit conversion; floating-point arithmetic is typically used to ensure the accuracy of the measurement data.

[0030] Next, coordinate offset correction is performed, eliminating systematic errors in the X and Y coordinates using preset correction parameters. The correction formula is: Corrected coordinates = Original coordinates × Scale factor + Offset constant, where the scale factor is used to reconcile scale differences between different coordinate systems, and the offset constant is used to correct inconsistencies in the coordinate system origins. This step ensures accurate matching between the surveying coordinate system and the Revit environment.

[0031] Finally, data format standardization is performed, including data structure normalization and field alignment. Data structure normalization ensures that all data fields conform to predefined format requirements, such as numeric fields not containing text characters and coordinate fields having sufficient precision. Field alignment ensures a consistent structure across different data records, facilitating subsequent program processing.

[0032] IV. Based on the aforementioned parameterized dataset, construct a parameterized modeling script in the Dynamo environment. This script contains two important data subsets: a subset of manhole spatial coordinate attributes and a subset of pipe connection relationship attributes. The manhole spatial coordinate attribute subset contains the spatial location information of all manholes, used for subsequent manhole instance generation; the pipe connection relationship attribute subset defines the connection topology between pipes, used for automatic pipe layout.

[0033] V. Based on the aforementioned subset of manhole spatial coordinate attributes, automatically generate manhole family instances in Revit using Dynamo nodes, and automatically map the parameters parsed from external data files to the manhole family instance parameters. Specifically, automatically generating manhole family instances in Revit using Dynamo nodes includes: generating manhole family instances based on the aforementioned subset of manhole spatial coordinate attributes using the FamilyInstance.ByPoint node, and batch setting the manhole number, manhole depth, manhole cover elevation, and manhole bottom elevation parameters for the manhole family instances using the Element.SetParameterByName node with a loop-based automatic assignment method. The manhole depth is automatically calculated by the difference between the manhole cover elevation and the manhole bottom elevation. The specific implementation process adopts a layered and progressive technical solution. First, the "Point.ByCoordinates" node combines the X-coordinate, Y-coordinate, and pipe bottom elevation (i.e., well bottom elevation) to generate a three-dimensional spatial point set. The formula for calculating the coordinates of a spatial point is: point coordinates = (X, Y, pipe bottom elevation), where X and Y determine the planar position, and the pipe bottom elevation determines the vertical position. Each spatial point corresponds to the precise location of a manhole, forming a spatial reference for the layout of manholes.

[0034] The manhole family is then instantiated in Revit based on the generated spatial point coordinates using the "FamilyInstance.ByPoint" node. This process automatically places a predefined manhole family type at each spatial point location, enabling batch placement of manholes. The choice of family type should be determined according to project requirements, such as different specifications like circular manholes or rectangular manholes.

[0035] The parameter assignment process uses the "Element.SetParameterByName" node to automatically assign values ​​to each generated manhole family instance in a loop. This process employs a list index mapping mechanism, iterating through the data to match the parameters parsed from the external data file with the parameters of each manhole family instance, ensuring an accurate match between the parameters of each manhole family instance and the corresponding records in the Excel source data. Core parameters include: manhole number (corresponding to the manhole number in the original data), manhole cover elevation (i.e., ground elevation), manhole bottom elevation (i.e., pipe bottom elevation), and manhole depth (automatically calculated by the difference between the manhole cover elevation and the manhole bottom elevation, using the formula: manhole depth = manhole cover elevation - manhole bottom elevation), etc.

[0036] When an engineering project involves multiple types of manholes, a classification and filtering function is implemented through the "List.FilterByBoolMask" node. This node classifies manhole data according to preset filtering conditions (such as manhole specifications, type, etc.) and then instantiates the corresponding family types. For mixed drainage systems containing sewage and stormwater pipe networks, a pipe network type identifier field is added to the external data file. The "List.FilterByBoolMask" node is used to collaboratively classify and filter manhole and pipe data according to pipe network type, generating manhole family instances and pipe family instances for sewage and stormwater pipe networks respectively, achieving batch automated processing based on pipe network type. This classification and processing mechanism ensures the correct generation of different types of components and pipe network systems in complex projects, demonstrating the adaptability of this invention in complex scenarios.

[0037] VI. Based on the subset of pipe connection relationship attributes and the spatial coordinates in the manhole family instance, pipe family instances are automatically generated in Revit using Dynamo nodes, wherein the endpoints of the pipe family instances are spatially associated with the corresponding manhole family instances. Specifically, the automatic generation of pipe family instances in Revit using Dynamo nodes includes: generating pipe family instances using the AdaptiveComponent.ByPoints node based on the subset of pipe connection relationship attributes and the spatial coordinates in the manhole family instance, and setting the pipe diameter, starting elevation, ending elevation, and slope parameters using the Element.SetParameterByName node. This process achieves intelligent pipe layout and automated parameter setting.

[0038] The first step in pipeline generation is establishing the correct connection mapping. A custom Python script node retrieves the index positions of each starting and ending manhole number in the manhole number list. The script input includes the manhole number list, the starting manhole number list, and the ending manhole number list, and the output is the corresponding index-value pairs. This mapping process ensures that pipelines can be correctly connected to the corresponding manhole instances.

[0039] Next, the "List.GetItemAtIndex" node extracts the corresponding start and end coordinates from the list of spatial point coordinates of the manhole based on the index value. These extracted coordinates serve as the spatial basis for pipeline generation, ensuring precise alignment between the pipeline and the manhole. Boundary checks are implemented during coordinate extraction to prevent errors such as index out-of-bounds errors.

[0040] The pipe model is generated using the "AdaptiveComponent.ByPoints" node, which takes the start and end coordinates as input and automatically creates pipe family instances in Revit. This node generates a straight pipe model based on the two point coordinates and automatically handles the pipe's direction and length parameters. Pipe type selection is achieved through the "FamilyTypes" node, supporting various pipe types such as PVC pipes and reinforced concrete pipes.

[0041] The parameter setting process uses the "Element.SetParameterByName" node to configure necessary parameter values ​​for each pipe instance, including diameter, starting elevation, ending elevation, and slope. The slope parameter is automatically calculated using the formula: Slope = (Starting Elevation - Ending Elevation) / Pipe Length. The pipe length is calculated using the Euclidean distance between the starting and ending coordinates, using the formula: ,in The coordinates of the starting manhole are... The coordinates of the endpoint manhole are used. This automated calculation mechanism ensures the accuracy and consistency of pipeline parameters.

[0042] 7. Run the parametric modeling script to integrate the manhole family instance and pipe family instance, and output a complete drainage network BIM model in Revit. The BIM model supports dynamic adjustment of model parameters by updating external data files.

[0043] Run the parametric modeling script, integrate all generated manhole family instances and pipe family instances, and output a complete drainage network BIM model in the Revit environment. This stage achieves complete assembly from components to system, forming a digital model that can be used in engineering applications.

[0044] Integrity checks were implemented during model integration to ensure that all manholes had corresponding pipe connections and that all pipes correctly connected between manholes. For any isolated components or connection errors, the system provided corresponding warnings to guide users in data correction. This verification mechanism ensured the quality and usability of the output model.

[0045] like Figure 3 As shown, the generated BIM model contains complete 3D geometric information and rich attribute parameters. Users can view it from all angles through Revit's 3D view to check the model's accuracy and completeness. Viewing functions include zooming, rotating, and sectioning, supporting the examination of the spatial relationships of the pipeline system from different perspectives.

[0046] The BIM model of this invention supports an efficient dynamic adjustment mechanism. When external data files are modified, users only need to update the relevant design parameters in the Excel or CSV file and rerun the parametric modeling script in the Dynamo environment. The system can automatically identify the modifications through a data change detection mechanism and achieve intelligent synchronous updates of the model parameters. This data-driven incremental update mechanism significantly improves model maintenance efficiency and ensures that the BIM model and external data files always maintain real-time consistency.

[0047] VIII. Application Expansion and Engineering Verification The method of this invention is directly applicable to the automated modeling of sewage pipe networks and stormwater pipe networks. By adding a pipe network type identification mechanism to the above specific implementation steps, and using the 'List.FilterByBoolMask' node to classify and filter manhole and pipe data according to the pipe network type field, it is possible to generate sewage pipe networks and stormwater pipe networks separately and arrange them in a mixed manner, meeting the diverse needs of complex projects.

[0048] Furthermore, this method exhibits excellent scalability and can be applied to the automated modeling of other municipal pipe networks, such as municipal water supply networks, gas pipelines, and heating networks. Adaptation to different pipe network types is primarily achieved by adjusting the family library and parameter mapping relationships, while the core data processing and model generation architecture remains unchanged. This scalability demonstrates the universality and practical value of the technical solution of this invention.

[0049] After the model is generated, key model parameters can be exported to an external file via Dynamo's "Data.ExportExcel" node for result verification and as-built data organization. The exported data includes key information such as manhole numbers, spatial coordinates, pipe diameter specifications, pipe length, and slope values. The exported data can be compared and verified with the original design data. Field tests show that the method of this invention can control the overall modeling error to the millimeter level, significantly outperforming traditional manual modeling methods.

[0050] Engineering application practice has proven that the method of this invention can shorten the pipeline network modeling work that traditionally takes several hours to complete to within a few minutes, improving efficiency by more than 10 times, while effectively avoiding modeling errors caused by human factors. This significant technological advancement provides strong technical support for the digital construction of municipal engineering.

[0051] Embodiments of the present invention may be provided as methods, systems, or computer program products. Therefore, the present invention may take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0052] This invention is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart illustrations and / or block diagrams. Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0053] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0054] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0055] Contents not described in detail in this specification are prior art known to those skilled in the art. It is hereby indicated that the above description is intended to help those skilled in the art understand this invention, but does not limit the scope of protection of this invention. Any equivalent substitutions, modifications, improvements, or simplifications of the above descriptions that do not depart from the essential content of this invention fall within the scope of protection of this invention.

Claims

1. An automatic modeling method for municipal drainage pipe networks based on Dynamo, characterized in that, Includes the following steps: Create an external data file containing information on manholes and pipelines. The manhole data should include at least the manhole number, X coordinate, Y coordinate, and ground elevation. The pipeline data should include at least the bottom elevation, pipe diameter, starting manhole number, and ending manhole number. Import the external data file into the Dynamo environment, read the file content through Dynamo nodes, and parse it into a structured data list; The structured data list is processed to unify units and standardize format to generate a parameterized data set, wherein the parameterized data set includes a subset of manhole spatial coordinate attributes and a subset of pipeline connection relationship attributes; Based on the parameterized dataset, construct a parameterized modeling script in the Dynamo environment; Based on the subset of spatial coordinate attributes of the manholes, manhole family instances are automatically generated in Revit through Dynamo nodes, and the parameters parsed from external data files are automatically mapped to the parameters of the manhole family instances. Based on the subset of pipe connection relationship attributes and the spatial coordinates in the manhole family instance, a pipe family instance is automatically generated in Revit through Dynamo nodes, wherein the endpoints of the pipe family instance are spatially associated with the corresponding manhole family instance. Run the parametric modeling script to integrate the manhole family instance and pipe family instance, and output a complete drainage network BIM model in Revit. The BIM model supports dynamic adjustment of model parameters by updating external data files.

2. The automatic modeling method for municipal drainage pipe networks based on Dynamo according to claim 1, characterized in that, The external data file is in Excel or CSV format and stores manhole and pipeline data in a tabular organization.

3. The automatic modeling method for municipal drainage pipe networks based on Dynamo according to claim 1, characterized in that, The step of reading file content and parsing it into a structured data list using Dynamo nodes specifically includes: selecting a file path using the File.Path node, reading the file content using the Date.ImportExcel node to generate a two-dimensional data list, and transposing the two-dimensional data list using the List.Transpose node to form the structured data list.

4. The automatic modeling method for municipal drainage pipe networks based on Dynamo according to claim 1, characterized in that, The unit unification and format standardization processing includes: unifying the X and Y coordinates in the inspection well data into metric units; unifying the pipe diameter in the pipeline data into millimeter units; performing offset correction processing on the X and Y coordinates; and standardizing the data format, including data structure normalization and field alignment.

5. The automatic modeling method for municipal drainage pipe networks based on Dynamo according to claim 1, characterized in that, The automatic generation of manhole family instances in Revit via Dynamo nodes specifically includes: generating manhole family instances based on the subset of manhole spatial coordinate attributes using the FamilyInstance.ByPoint node, and batch setting manhole number, manhole depth, manhole cover elevation, and manhole bottom elevation parameters for the manhole family instances using the Element.SetParameterByName node with a loop-based automatic assignment method. The manhole depth is automatically calculated by the difference between the manhole cover elevation and the manhole bottom elevation.

6. The automatic modeling method for municipal drainage pipe networks based on Dynamo according to claim 1, characterized in that, The automatic generation of pipe family instances in Revit using Dynamo nodes specifically includes: generating pipe family instances based on a subset of pipe connection relationship attributes and spatial coordinates in the manhole family instance using the AdaptiveComponent.ByPoints node, and setting the pipe diameter, starting elevation, ending elevation, and slope parameters using the Element.SetParameterByName node.

7. The automatic modeling method for municipal drainage pipe networks based on Dynamo according to claim 1, characterized in that, The dynamic adjustment of the BIM model includes: when the external data file is modified, the model parameters are automatically synchronized by rerunning the parametric modeling script to maintain the consistency between the model and the external data file.

8. The automatic modeling method for municipal drainage pipe networks based on Dynamo according to claim 1, characterized in that, The municipal drainage network includes sewage network and rainwater network.

9. The automatic modeling method for municipal drainage pipe networks based on Dynamo according to claim 1 or 8, characterized in that, The manhole family instances and pipe family instances can be generated according to the type of pipeline network. The List.FilterByBoolMask node can be used to collaboratively filter and batch process different types of manholes and pipes.

10. The application of the Dynamo-based automatic modeling method for municipal drainage networks according to any one of claims 1-9 in the automated modeling of municipal water supply networks, gas pipelines, or heating networks.

Images