BIM-based parameterized spatial steel grid structure modeling method

Abstract

According to the BIM-based parameterized spatial steel truss structure modeling method, electronic drawing spatial steel truss data are extracted through simple operation, an Excel table is processed and generated, spatial steel truss node three-dimensional coordinate data are extracted, precision errors caused by human factors are eliminated, meanwhile, a Revit template file is created, and a BIM-based parameterized spatial steel truss structure modeling method is provided. According to the method, a self-adaptive rod piece and bolt-sphere joint parameterization family is established, the modeling efficiency of the space steel truss in Revit is effectively improved, at least 90% of modeling time is saved, a running program written by Dynamo is applied, table data and parameterization family data are automatically called, accurate space steel truss and bolt-sphere joints are automatically generated, and the modeling efficiency and the model quality are greatly improved.

Description

Technical Field

[0001] The invention belongs to the technical field of steel structure modeling, and relates to a BIM-based parameterized spatial steel grid structure modeling method. Background Art

[0002] In recent years, with the rapid development of BIM (Building Information Modeling) technology, this technology has received widespread attention from all project participants, and more and more large-scale venue projects have begun to adopt BIM technology to implement the management of the entire life cycle of buildings. As the mainstream BIM modeling software platform in the industry, Revit has been widely used in creating building information models. Creating models is the primary task of implementing BIM technology. The integrity, compliance, and spatial topological relationship of the model play a vital role in serving the application of BIM technology in various life cycles.

[0003] However, Revit has low efficiency in modeling spatial steel grid structures, and many spatial grid nodes cannot be expressed; traditional spatial steel grid structure modeling uses other software such as YJK, PKPM, TEKLA and other professional structural modeling software for modeling, and then imports the model into Revit after converting the format to generate a spatial steel grid structure model. Although these professional structural modeling software are highly professional, they have a low penetration rate and high learning cost. In addition, the models imported into Revit will also have problems such as missing rods and missing bolt ball nodes. These problems have always troubled modelers; especially when placing bolt ball nodes, the traditional method is for modelers to pick up grid nodes one by one and manually place bolt ball nodes in the three-dimensional space view of Revit modeling software. Placing thousands of bolt balls one by one is time-consuming and laborious, and the spatial position accuracy of the placement cannot be guaranteed. It is also impossible to truly ensure the integrity of the model, and the modeling efficiency is very low. Summary of the invention

[0004] The purpose of the present invention is to provide a BIM-based parametric spatial steel grid structure modeling method to address the problems of complex operation and low efficiency of existing modeling methods in the background technology.

[0005] To this end, the present invention adopts the following technical solutions: A BIM-based parametric spatial steel grid structure modeling method comprises the following steps: 1) Extract data of spatial steel grid, extract data from the node coordinate table and bar unit table of the spatial grid in the electronic version of the construction drawing design, and the extracted data is in Excel format; 2) Spatial steel grid data processing, retaining the node number and X, Y, Z coordinates of the nodes in the extracted data, deleting other useless information, retaining the member number, 1-end node number, 2-end node number, geometric dimensions of the members in the extracted data, and deleting other useless information; 3) Revit template file creation: create a structural template file in Revit, create a new conceptual mass member adaptive family and a bolt ball node parametric family, and load them into the Revit template file for standby use; 4) Writing Dynamo programs: Write the rod automatic generation program and the bolt ball node automatic generation program in Dynamo programs. Specifically: The rod automatic generation program edits the File path node in Dynamo, and the next step is to edit the String node and create a worksheet with the string specifying the Excel table. The next step is to edit the Data.importExcel node and read the loaded node coordinate data and rod unit data. The next step is to edit the List.Transpose node and swap the row and column data to adapt. The next step is to edit the List.Clean node and clear the null values ​​to sort the data. The next step is to edit the Code Block node. The next step is to edit the List.GetltemAtIndex node and give the list item. The next step is to edit the LIst. Deconstruct node and generate a new list item. The next step is to edit the String from Obeject node and convert the string. The next step is to edit the String.Remove node and delete the error string. The next step is to edit the Python Script node and run the embedded Ironpython script. The next step is to edit the String node and create the rod name string. The next step is to edit the Family Type.ByName node and extract the rod with the same name in the template file. The next step is to edit the AdaptiveComponent.ByPoints node and create an adaptive component through a two-dimensional array of points. The bolt ball node automatic generation program uses the File path node in Dynamo. The next step is to edit the File FromPath node to create a file object from the path, the String node and create a string to specify the Excel table. The next step is to edit the Data.importExcel node and read the loaded node coordinate data. The next step is to edit the List.Transpose node and swap the row and column data adaptation. The next step is to edit the Code Block node. The next step is to edit the List.GetltemAtIndex node to return the item of the given list at the specified index. The next step is to edit the List.Restofltems node and delete the first item of the given list. The next step is to edit the Point.Bycoordinates node and form a point through the given 3 Cartesian coordinates. The next step is to edit the String node and create a bolt ball node name string. The next step is to edit the FamilyType.ByName node and extract the bolt ball node with the same name in the template file. The next step is to edit the Family Instance.Bypoint node and place the bolt ball node according to the bolt ball node family and coordinates; 5) Run the Dynamo program to automatically generate rods and bolt ball nodes. Specifically: To run the automatic generation of rods, the File path node is used to load the Excel table data of node coordinates and rod units respectively, and then the string of the String node rod name is modified. The string name should be consistent with the rod name in the template file, and finally the spatial steel structure grid BIM model is generated; The bolt ball node is automatically generated at runtime. The Excel table data of the node coordinates is loaded using the File path node, and then the bolt ball node name string of the String node is modified. The string name should be consistent with the bolt ball name in the template file. Finally, the bolt ball is automatically placed to the BIM model at the rod node.

[0006] Furthermore, in the step 2), the coordinate units of the node coordinates X, Y, and Z are converted into m, and the geometric length units of the rods are converted into m.

[0007] Furthermore, in the step 2), select the management tab to set the project unit length to m.

[0008] Furthermore, when writing the rod automatic generation program in step 4), the Designscript code can be directly written in the Code Block node.

[0009] Furthermore, when writing the bolt ball node automatic generation program in step 4), the Designscript code can be directly written in the Code Block node.

[0010] Furthermore, in the step 4), when using the File path node, it is allowed to select a file on the operating system to obtain its file name.

[0011] The beneficial effects of the present invention are: (1) Through simple operations, the spatial steel grid data of the electronic drawings is extracted, processed and generated into Excel tables, and the three-dimensional coordinate data of the spatial steel grid nodes is extracted to eliminate the precision errors caused by human factors. At the same time, a Revit template file is created to establish a parametric family of adaptive rods and bolt ball nodes, which effectively improves the modeling efficiency of the spatial steel grid in Revit and saves at least 90% of the modeling time; (2) Using the running program written in Dynamo, the table data and parametric family data are automatically called to automatically generate accurate spatial steel grids and bolt ball nodes, greatly improving the modeling efficiency and model quality. BRIEF DESCRIPTION OF THE DRAWINGS

[0012] Figure 1 It is a modeling flow chart of the automatic generation of a spatial steel grid structure according to the present invention; Figure 2 It is a bar element table diagram extracted from a CAD electronic version drawing in an embodiment of the present invention; Figure 3 It is a diagram of a node coordinate table extracted from a CAD electronic version drawing in an embodiment of the present invention; Figure 4 It is an EXCEL table after node coordinate data processing in an embodiment of the present invention; Figure 5 It is an EXCEL table after the bar element data is processed in an embodiment of the present invention; Figure 6 is a creation diagram of a Revit template file in an embodiment of the present invention; Figure 7 It is a BIM model diagram of the automatically generated spatial steel grid structure in the embodiment of the present invention.

[0013] Figure 8 It is a partial enlarged view of the BIM model of the bolt ball node of the spatial steel grid structure automatically generated in the embodiment of the present invention. DETAILED DESCRIPTION

[0014] The present invention is described in detail below in conjunction with embodiments: like Figure 1 As shown, a BIM-based parametric spatial steel grid structure modeling method includes the following steps: 1) Extract the data of the spatial steel grid, extract the data of the node coordinate table and the bar unit table of the spatial grid in the electronic version of the construction drawing design (such as Figure 2 and 3 The extracted data is in Excel format. Specifically, CAD output or CAD quick view can be used to extract the table in Excel format. Excel table can facilitate the editing, importing and management of data, thereby improving work efficiency and reducing human errors.

[0015] 2) Spatial steel grid data processing: import the node coordinates and bar unit Excel format data of the extracted spatial grid into WPS for data processing, retain the node number and X, Y, and Z coordinates of the node in the extracted data, and convert the coordinate units of the X, Y, and Z of the node coordinates from mm to m, so as to keep them consistent with the units of the Revit template file, avoid the problem of incorrect component position generation caused by different units, and delete other useless information (such as Figure 4 As shown in the figure), retain the member number, end 1 node number, end 2 node number, and geometric dimensions of the member in the extracted data, where the geometric dimensions include the diameter and wall thickness of the member, convert the unit of the member geometry length from mm to m, and then keep it consistent with the Revit template file unit to avoid the problem of incorrect component position generation due to different units, and delete other useless information (such as Figure 5 As shown in the figure), the section size information processing format is taken as an example: Φ159*8.0→p159×8.0. After the information processing is completed, all blank lines after the end of the table must be deleted and left blank without any placeholders, otherwise an error message will appear when running the Dynamo program later.

[0016] 3) Revit template file creation, create a structural template file in Revit (such as Figure 6 As shown in the figure), create a new conceptual mass member adaptive family and a bolt ball node parametric family, and load them into the Revit template file for use.

[0017] 4) Writing Dynamo programs: Write the rod automatic generation program and the bolt ball node automatic generation program in Dynamo programs. Specifically: The rod automatic generation program in Dynamo first edits the File path node. When editing the File path node, you can select a file on the operating system (Windows operating system in this embodiment) to obtain its file name, and then you can select the EXCEL file of the processed file node coordinates and rod unit on the operating system. The next step is to edit the String node and create a worksheet of the Excel table specified by the string. Specifically, the Excel table specified by the string is the sheet1 worksheet in the EXCEL table extracted from the coordinate file. The next step is to edit the Data.importExcel node and read the rod data after loading and processing. The next step is to edit the List.Transpose node and swap the row and column data for adaptation. The next step is to edit the List.Clean node and clear the null values ​​to organize the data. In order to prevent the existence of null value data and empty rows in the imported data, which will affect the output conditions of the data, data cleaning is performed to avoid affecting the output of the data. The next step is to edit the Code Block node. When writing the Code Block node, you can directly write the Designscript code to improve efficiency. The next step is to edit the List.GetltemAtIndex node and give the list item. The next step is to edit the LIst. Deconstruct node and generate a new list item. The next step is to edit the String from Obeject node and convert the string. Next, edit the String.Remove node and delete the error string. Next, edit the Python Script node and run the embedded Ironpython script. Next, edit the String node and create the member name string. Next, edit the Family Type.ByName node and extract the member with the same name from the template file. Next, edit the AdaptiveComponent.ByPoints node and create an adaptive component through a two-dimensional array of points to complete the program.

[0018] The automatic generation program of the bolt ball node uses the File path node in Dynamo. When using the File path node, you can select a file on the system to obtain its file name → File From Path node, create a file object from the path, String node and create a string to specify the Excel table. The next step is to edit the Data.importExcel node and read the loaded node coordinate data. The next step is to edit the List.Transpose node and swap the row and column data adaptation. The next step is to edit the Code Block node. When writing the Code Block node, you can directly write the Designscript code. The next step is to edit the List.GetltemAtIndex node and give a list item. Specifically, the list item is to return the item of the given list at the specified index. The next step is to edit the List.Restofltems node and delete the first item of the given list. The next step is to edit the Point.Bycoordinates node and form a point through the given 3 Cartesian coordinates. The next step is to edit the String node and create a bolt ball node name string. The next step is to edit the Family Type.ByName node and extract the bolt ball node with the same name in the template file. The next step is to edit the Family Instance. Bypoint node and place the bolt ball node according to the bolt ball node family and coordinates to complete the program writing.

[0019] 5) Run the Dynamo program to automatically generate rods and bolt ball nodes. Specifically: To automatically generate rods, use the File path node to load the Excel table data of node coordinates and rod units respectively, then modify the String node rod name string, and the string name should be consistent with the rod name in the template file, and finally generate the spatial steel structure grid BIM model.

[0020] The bolt ball node is automatically generated. When running, the file path node is used to load the Excel table data of the node coordinates, and then the string node bolt ball node name string is modified. The string name should be consistent with the bolt ball name in the template file. Finally, the bolt ball is automatically placed to the BIM model at the member node (such as Figure 7 and 8 as shown).

[0021] After the operation is completed, the spatial steel grid BIM model can be checked. After the automatic construction of the spatial steel grid structure BIM model is completed, it will be comprehensively checked and verified to ensure the accuracy, completeness and coordination of the model.

Claims

1. A BIM-based parametric spatial steel grid structure modeling method, characterized in that: The following steps are involved: 1) Extract data of spatial steel grid, extract data from the node coordinate table and bar unit table of the spatial grid in the electronic version of the construction drawing design, and the extracted data is in Excel format; 2) Spatial steel grid data processing, retaining the node number and X, Y, Z coordinates of the nodes in the extracted data, deleting other useless information, retaining the member number, 1-end node number, 2-end node number, geometric dimensions of the members in the extracted data, and deleting other useless information; 3) Revit template file creation: create a structural template file in Revit, create a new conceptual mass member adaptive family and a bolt ball node parametric family, and load them into the Revit template file for standby use; 4) Writing Dynamo programs: Write the rod automatic generation program and the bolt ball node automatic generation program in Dynamo programs. Specifically: The rod automatic generation program edits the File path node in Dynamo, and the next step is to edit the String node and create a worksheet with the string specifying the Excel table. The next step is to edit the Data.importExcel node and read the loaded node coordinate data and rod unit data. The next step is to edit the List.Transpose node and swap the row and column data to adapt. The next step is to edit the List.Clean node and clear the null values ​​to sort the data. The next step is to edit the Code Block node. The next step is to edit the List.GetltemAtIndex node and give the list item. The next step is to edit the LIst. Deconstruct node and generate a new list item. The next step is to edit the String from Obeject node and convert the string. The next step is to edit the String.Remove node and delete the error string. The next step is to edit the Python Script node and run the embedded Ironpython script. The next step is to edit the String node and create the rod name string. The next step is to edit the Family Type.ByName node and extract the rod with the same name in the template file. The next step is to edit the AdaptiveComponent.ByPoints node and create an adaptive component through a two-dimensional array of points. The bolt ball node automatic generation program uses the File path node in Dynamo. The next step is to edit the File FromPath node to create a file object from the path, the String node and create a string to specify the Excel table. The next step is to edit the Data.importExcel node and read the loaded node coordinate data. The next step is to edit the List.Transpose node and swap the row and column data adaptation. The next step is to edit the Code Block node. The next step is to edit the List.GetltemAtIndex node to return the item of the given list at the specified index. The next step is to edit the List.Restofltems node and delete the first item of the given list. The next step is to edit the Point.Bycoordinates node and form a point through the given 3 Cartesian coordinates. The next step is to edit the String node and create a bolt ball node name string. The next step is to edit the FamilyType.ByName node and extract the bolt ball node with the same name in the template file. The next step is to edit the Family Instance.Bypoint node and place the bolt ball node according to the bolt ball node family and coordinates; 5) Run the Dynamo program to automatically generate rods and bolt ball nodes. Specifically: To run the automatic generation of rods, the File path node is used to load the Excel table data of node coordinates and rod units respectively, and then the string of the String node rod name is modified. The string name should be consistent with the rod name in the template file, and finally the spatial steel structure grid BIM model is generated; The bolt ball node is automatically generated at runtime. The Excel table data of the node coordinates is loaded using the File path node, and then the bolt ball node name string of the String node is modified. The string name should be consistent with the bolt ball name in the template file. Finally, the bolt ball is automatically placed to the BIM model at the rod node.

2. The BIM-based parameterized spatial steel grid structure modeling method according to claim 1 is characterized in that: In the step 2), the coordinate units of the X, Y, and Z coordinates of the node are converted into m, and the geometric length units of the rods are converted into m.

3. The BIM-based parameterized spatial steel grid structure modeling method according to claim 1 is characterized in that: In step 2), select the Management tab and set the project unit length to m.

4. The BIM-based parameterized spatial steel grid structure modeling method according to claim 1 is characterized in that: When writing the rod automatic generation program in step 4), the Designscript code can be directly written in the Code Block node.

5. The BIM-based parameterized spatial steel grid structure modeling method according to claim 1 is characterized in that: When writing the automatic generation program of the bolt ball node in step 4), the Designscript code can be directly written in the Code Block node.

6. The BIM-based parameterized spatial steel grid structure modeling method according to claim 1 is characterized in that: Using the File path node in step 4) allows you to select a file on the operating system to obtain its file name.

Images