Batch rapid modeling analysis method and system for outdoor tube wells

Abstract

The invention discloses an outdoor tube well batch rapid modeling analysis method and system, and the method comprises the steps: carrying out the arrangement according to drawing information, and forming Excel data; the Excel data comprises a well serial number, a tube well coordinate position, a well surface elevation, a well bottom elevation, a well depth and a specification; customizing a tube well family, and preparing an input interface for the Excel data; based on the customized tube well family, defining an Excel file path, an Excel workbook name and a tube well family name as freely selectable input ends, and compiling a script node package; and generating the tube well according to the tube well coordinate position, the well bottom elevation, the well depth and the specification by utilizing the compiled script node package. According to the method, tube well models can be quickly and accurately created in batches, and the modeling efficiency is greatly improved.

Description

Technical Field

[0001] The present invention relates to the field of building construction, and particularly to a method and system for batch rapid modeling and analysis of outdoor pipe wells. Background Art

[0002] At present, when using the BIM modeling software Revit to add outdoor pipe wells, each pipe well needs to be added and its parameters modified one by one, and the design table data cannot be used to batch add parameters. For example: adding the "pipe well family" to the project file, linking the CAD floor plan of the pipe well as a reference base map, translating the "pipe well family" to the corresponding position according to the pipe well position in the design floor plan, adjusting the bottom elevation of the pipe well to the absolute elevation, and finally adjusting the buried depth of the pipe well, and manually entering the well number, ground elevation, and well surface elevation.

[0003] There are more than 100 outdoor pipe wells in an ordinary project, and up to 500 - 600 pipe wells in a large project. Suppose a large project has 500 pipe wells. The number of clicks and entries and the time required to complete the addition of one pipe well are: 6 times (30 seconds) / piece, 6×500 = 3000 times (30×500 = 10000 seconds). Adding the process of screen switching between multiple views of the drawing, the overall completion time is about 5 hours. At the same time, relying entirely on manual input, there will inevitably be misentry situations, and a proofreading process needs to be added to ensure complete accuracy. Coupled with frequent changes to the on-site drawings, it is normal to modify them comprehensively 3 - 5 times. Without considering drawing comparison, drawing and data processing, the entire project only requires about 5×5 = 25 hours for pipe well modeling. It can be seen that the current modeling of pipe wells requires a large amount of time and has low modeling efficiency.

[0004] Therefore, to solve the above problems, a method and system for batch rapid modeling and analysis of outdoor pipe wells are needed, which can quickly, accurately, and batch create pipe well models, greatly improving the modeling efficiency. Summary of the Invention

[0005] In view of this, the purpose of the present invention is to overcome the defects in the prior art and provide a method and system for batch rapid modeling and analysis of outdoor pipe wells, which can quickly, accurately, and batch create pipe well models, greatly improving the modeling efficiency.

[0006] The batch rapid modeling and analysis method for outdoor pipe wells of the present invention includes:

[0007] Sorting out Excel data according to the drawing information; the Excel data includes well number, pipe well coordinate position, well surface elevation, bottom elevation of the well, well depth, and specifications;

[0008] Customizing the pipe well family and preparing an input interface for the Excel data;

[0009] Based on the customized pipe well family, define the Excel file path, Excel workbook name, and pipe well family name as freely selectable input terminals, and compile a script node package;

[0010] Use the compiled script node package to generate pipe wells according to the pipe well coordinate position, bottom elevation, well depth, and specifications.

[0011] Furthermore, customize the pipe well family, specifically including:

[0012] Select the family template and family type; among them, the family template includes a metric generic model and / or a metric pipe fitting model; the family type includes a panel family and / or a nested family;

[0013] Add the parameters in the Excel data to the pipe well family;

[0014] Ensure that the pipe well family can be resized according to the parameters by means of stretching or arraying.

[0015] Furthermore, use Dynamo for Revit to compile a script node package, specifically including:

[0016] Use the Data.ImportExcel node to load the Excel file corresponding to the Excel data;

[0017] Extract the column data in the Excel data;

[0018] Place a pipe well family instance at the pipe well coordinate position using FamilyInstance.ByPoint; use Element.SetParameterByName to assign values to the parameters of the pipe well family;

[0019] Package the Dynamo code as a custom node or a Dynamo package.

[0020] Furthermore, generate pipe wells according to the pipe well coordinate position, bottom elevation, well depth, and specifications, specifically including:

[0021] Select the path where the Excel data is located, specify the workbook name, and load the Excel data;

[0022] Extract the pipe well parameters, and the pipe well parameters include the pipe well coordinate position, bottom elevation, well depth, and specifications;

[0023] Place a pipe well in the Revit model through FamilyInstance.ByPoint to obtain a pipe well family instance;

[0024] Use Element.SetParameterByName to assign values to the pipe well family, thereby generating a pipe well.

[0025] Further, after generating the pipe well, write four groups of data, namely the well shaft number, the bottom elevation of the well, the elevation of the well surface, and the well depth, into the pipe well family.

[0026] An outdoor pipe well batch rapid modeling and analysis system includes a data sorting unit, a pipe well family customization unit, a script node package compilation unit, and a pipe well generation unit;

[0027] The data sorting unit is used to sort and form Excel data according to the drawing information; the Excel data includes the well shaft number, the pipe well coordinate position, the elevation of the well surface, the bottom elevation of the well, the well depth, and the specification;

[0028] The pipe well family customization unit is used to customize the pipe well family and prepare an input interface for the Excel data;

[0029] The script node package compilation unit is used to define the Excel file path, the Excel workbook name, and the pipe well family name as freely selectable input terminals based on the customized pipe well family, and compile the script node package;

[0030] The pipe well generation unit is used to generate pipe wells according to the pipe well coordinate position, the bottom elevation of the well, the well depth, and the specification by using the compiled script node package.

[0031] Further, customizing the pipe well family specifically includes:

[0032] Select the family template and family type; among them, the family template includes the metric general model and / or the metric pipe equipment model; the family type includes the panel family and / or the nested family;

[0033] Add the parameters in the Excel data to the pipe well family;

[0034] Ensure that the pipe well family can be adjusted in size according to the parameters by means of stretching or arraying.

[0035] Further, using Dynamo for Revit to compile the script node package specifically includes:

[0036] Use the Data.ImportExcel node to load the Excel file corresponding to the Excel data;

[0037] Extract the column data in the Excel data;

[0038] Place pipe well family instances at the pipe well coordinate positions by using FamilyInstance.ByPoint; assign parameters to the pipe well family by using Element.SetParameterByName;

[0039] Encapsulate Dynamo code into custom nodes or Dynamo packages.

[0040] Furthermore, generate pipe wells according to the coordinate positions of the pipe wells, the bottom elevations of the wells, the well depths, and the specifications, specifically including:

[0041] Select the path where the Excel data is located, specify the workbook name, and load the Excel data;

[0042] Extract the pipe well parameters, where the pipe well parameters include the coordinate positions of the pipe wells, the bottom elevations of the wells, the well depths, and the specifications;

[0043] Place the pipe wells in the Revit model through FamilyInstance.ByPoint to obtain pipe well family instances;

[0044] Assign values to the pipe well family using Element.SetParameterByName, thereby generating the pipe wells.

[0045] Furthermore, after generating the pipe wells, write four groups of data, namely the well number, the bottom elevation of the well, the elevation of the well surface, and the well depth, into the pipe well family.

[0046] The beneficial effects of the present invention are as follows: An outdoor pipe well batch rapid modeling and analysis method and system disclosed by the present invention, by programming a script program and forming a node package from the script program, only need to read the pipe well data in Excel each time it is used, and then the pipe wells can be quickly created. Using the script program, all pipe wells can be created and accurate data entry can be completed within a few seconds, greatly improving the modeling efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0047] The present invention will be further described below with reference to the drawings and embodiments:

[0048] Figure 1 It is a schematic flow diagram of the pipe well batch rapid modeling and analysis method of the present invention;

[0049] Figure 2 It is a schematic diagram of preparing standard table Excel data of the present invention;

[0050] Figure 3 It is a schematic diagram of selecting and opening a standard table Excel file of the present invention;

[0051] Figure 4 It is a schematic diagram of entering the standard workbook name of the data of the present invention;

[0052] Figure 5 It is a schematic diagram of entering the pipe well family name of the present invention;

[0053] Figure 6 It is a schematic diagram of the result display after batch adding pipe wells of the present invention. Detailed implementation mode

[0054] The following further describes the present invention in conjunction with the accompanying drawings of the specification, as shown in the figures:

[0055] This embodiment discloses a method for batch and rapid modeling and analysis of outdoor pipe wells, including the following steps:

[0056] S1. According to the drawing information, organize and form Excel data; the Excel data includes well numbers, pipe well coordinate positions, well surface elevations, well bottom elevations, well depths, and specifications;

[0057] S2. Customize the pipe well family and prepare an input interface for the Excel data;

[0058] S3. Based on the customized pipe well family, define the Excel file path, Excel workbook name, and pipe well family name as freely selectable input ends, and compile a script node package;

[0059] S4. Use the compiled script node package to generate pipe wells according to the pipe well coordinate positions, well bottom elevations, well depths, and specifications.

[0060] The technical solution for batch creation of pipe well models based on the Dynamo script node package of the present invention can greatly improve the modeling efficiency, data accuracy, and collaboration ability. By importing Excel data, pipe wells are automatically generated with one key, avoiding manual input errors, significantly improving the modeling efficiency, and solving the problems of the traditional technology that each pipe well needs to be created separately, and four groups of pipe well-related data, such as well bottom elevation, well surface elevation, well depth, well number, etc., need to be manually entered after placing the pipe wells, and there are problems of misrecording and low work efficiency in manual entry.

[0061] In this embodiment, in step S1, the drawing can be a construction drawing of pipe well information or a layout drawing exported from a BIM model; as Figure 2 shown, the pipe well coordinate position can be the X coordinate and the Y coordinate. The XY coordinates refer to the world coordinates in the Revit project (i.e., the global coordinate system of Revit), which are used to locate the pipe well in the model space, corresponding to the center point coordinates of the pipe well, and the unit is usually meters or millimeters, specifically depending on the unit settings of the project. The X coordinate and the Y coordinate correspond to the horizontal position of the pipe well in the Revit model based on a certain measurement reference point. Among them, the well bottom elevation (corresponding to the Z coordinate): refers to the absolute height of the bottom of the pipe well (generally referenced by the project reference point or altitude).

[0062] In this embodiment, in step S2, customizing the pipe well family means creating a pipe well family (Family) in the Revit family editor and ensuring that it contains the parameters required by the script; customizing the pipe well family specifically includes:

[0063] Select family templates and family types; among them, the family templates include metric generic models and / or metric pipe fitting models; the family types include panel families and / or nested families; the panel families have parametric geometries; the nested families refer to families with pipe connections.

[0064] Add the parameters in the Excel data to the pipe shaft family; specifically, the shaft number (Text parameter), the pipe shaft coordinate position (both the X coordinate and the Y coordinate are Number parameters), the shaft top elevation (Number parameter), the shaft bottom elevation (Number parameter), the shaft depth (generally, the shaft depth = shaft top elevation - shaft bottom elevation), and the specification (Text or Type parameter, which determines the pipe shaft size).

[0065] Ensure that the pipe shaft family can be resized according to the parameters by means of stretching or arraying. With the subsequent script, the pipe shaft size, elevation, etc. can be automatically adjusted according to the new data, realizing rapid iteration.

[0066] In this embodiment, in step S3, use Dynamo for Revit to compile a script node package, which specifically includes:

[0067] Use the Data.ImportExcel node to load the Excel file corresponding to the Excel data; directly read the data from Excel to avoid manual input errors.

[0068] Extract the column data in the Excel data.

[0069] Place a pipe shaft family instance at the pipe shaft coordinate position using FamilyInstance.ByPoint; use Element.SetParameterByName to assign parameters to the pipe shaft family.

[0070] Package the Dynamo code into a custom node or a Dynamo package. After packaging, the Dynamo script can be applied to different projects, reducing repetitive development work for reuse.

[0071] In this embodiment, in step S4, generate a pipe shaft according to the pipe shaft coordinate position, the shaft bottom elevation, the shaft depth, and the specification, which specifically includes:

[0072] Select the path where the Excel data is located and specify the workbook name to load the Excel data; just modify the Excel and rerun the script to update the Revit model with one click, without adjusting one by one.

[0073] Extract the pipe shaft parameters, which include the pipe shaft coordinate position, the shaft bottom elevation, the shaft depth, and the specification.

[0074] Place pipe shafts in the Revit model through FamilyInstance.ByPoint to obtain pipe shaft family instances;

[0075] Assign values to the pipe shaft family using Element.SetParameterByName to generate pipe shafts.

[0076] In this embodiment, after generating the pipe shafts, four groups of data, namely the shaft number, bottom elevation of the shaft, top elevation of the shaft, and depth of the shaft, are written into the pipe shaft family. Through the above processing, it is convenient for marking and querying: designers can directly read these parameters in Revit without having to check Excel. It maintains data consistency: avoids the situation where the Revit model cannot be synchronized after modifying Excel. It supports BIM analysis: these parameters may be required for subsequent analysis, clash detection, etc. Combining with Revit clash detection, it automatically checks whether the pipe shafts are correctly connected to the pipes.

[0077] The present invention also relates to an outdoor pipe shaft batch rapid modeling and analysis system. The modeling and analysis system corresponds to the modeling and analysis method of the above embodiment and can be understood as a system for implementing the above modeling and analysis method. The modeling and analysis system includes a data sorting unit, a pipe shaft family customization unit, a script node package compilation unit, and a pipe shaft generation unit;

[0078] The data sorting unit is used to sort and form Excel data according to the drawing information. The Excel data includes the shaft number, pipe shaft coordinate position, top elevation of the shaft, bottom elevation of the shaft, depth of the shaft, and specifications;

[0079] The pipe shaft family customization unit is used to customize the pipe shaft family and prepare an input interface for the Excel data;

[0080] The script node package compilation unit is used to define the Excel file path, Excel workbook name, and pipe shaft family name as freely selectable input terminals based on the customized pipe shaft family and compile a script node package;

[0081] The pipe shaft generation unit is used to generate pipe shafts according to the pipe shaft coordinate position, bottom elevation of the shaft, depth of the shaft, and specifications by using the compiled script node package.

[0082] To better understand the outdoor pipe shaft batch rapid modeling and analysis method and system of the present invention, the following further illustrates with the example of generating pipe shafts with a single click of a node package:

[0083] 1. As Figure 3 shown, open the standard table file: This Excel table is the pipe shaft data to be generated and needs to be prepared in advance.

[0084] 2. As Figure 4As shown, enter the workbook name: Enter the corresponding workbook name in Excel to tell the script which workbook data to select. Among them, the default value is "Data Output - Pipe Well" of the standard table.

[0085] 3. As Figure 5 shown, enter the family name: Enter the full name of the reference pipe well family. The pipe well type generated will select the type in this pipe well family. For example, the pipe well family name is: EA - Circular Brick Sewage Inspection Well with Flat Bottom Referenced Elevation;

[0086] 4. Click to generate pipe wells. As Figure 6 shown, the result display after batch adding pipe wells is shown.

[0087] The present invention provides an objective and scientific method and system for batch and rapid modeling analysis of outdoor pipe wells, which can greatly improve the modeling efficiency, data accuracy and collaboration ability. Through Excel data import, pipe wells can be automatically generated with one key, avoiding manual input errors and increasing the efficiency by more than 80%. The script can flexibly adjust parameters such as well positions and elevations to achieve rapid change response and reduce human errors by 90%. It supports batch detection of the matching situation between pipe wells and pipelines, reducing the rework risk by 70%. It effectively improves the team collaboration ability, realizes cross - professional data sharing, improves the utilization rate of BIM data, and helps intelligent modeling and construction.

[0088] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and not to limit them. Although the present invention has been described in detail with reference to the preferred embodiments, those of ordinary skill in the art should understand that the technical solutions of the present invention can be modified or equivalently replaced without departing from the purpose and scope of the technical solutions of the present invention, and they should all be covered within the scope of the claims of the present invention.

Claims

1. An outdoor pipe well batch rapid modeling and analysis method, characterized in that: Including: Sort and form Excel data according to the drawing information; the Excel data includes shaft number, pipe well coordinate position, well surface elevation, well bottom elevation, well depth, and specifications; Customize the pipe well family and prepare an input interface for the Excel data; Based on the customized pipe well family, define the Excel file path, Excel workbook name, and pipe well family name as freely selectable input terminals, and compile a script node package; Use the compiled script node package to generate pipe wells according to the pipe well coordinate position, well bottom elevation, well depth, and specifications.

2. The batch rapid modeling and analysis method for outdoor pipe shafts according to claim 1, characterized in that: Customize the pipe well family, specifically including: Select a family template and family type; among them, the family template includes a metric common model and / or a metric pipe equipment model; the family type includes a panel family and / or a nested family; Add the parameters in the Excel data to the pipe well family; Ensure that the pipe well family can be resized according to the parameters by means of stretching or arraying.

3. The batch rapid modeling and analysis method for outdoor pipe shafts according to claim 1, wherein: Use Dynamo for Revit to compile a script node package, specifically including: Use the Data.ImportExcel node to load the Excel file corresponding to the Excel data; Extract the column data in the Excel data; Place a pipe well family instance at the pipe well coordinate position using FamilyInstance.ByPoint; use Element.SetParameterByName to assign values to the parameters of the pipe well family; Package the Dynamo code as a custom node or a Dynamo package.

4. The batch rapid modeling analysis method for outdoor pipe shafts according to claim 1, characterized in that: Generate pipe wells according to the pipe well coordinate position, well bottom elevation, well depth, and specifications, specifically including: Select the path where the Excel data is located, specify the workbook name, and load the Excel data; Extract the pipe well parameters, and the pipe well parameters include the pipe well coordinate position, well bottom elevation, well depth, and specifications; Place a pipe well in the Revit model through FamilyInstance.ByPoint to obtain a pipe well family instance; Use Element.SetParameterByName to assign values to the pipe well family, thereby generating pipe wells.

5. The method for batch rapid modeling and analysis of outdoor pipe shafts according to claim 1, wherein: After generating the pipe wells, write four groups of data, namely the shaft number, well bottom elevation, well surface elevation, and well depth, into the pipe well family.

6. An outdoor pipe well batch rapid modeling and analysis system, characterized in that: Including a data sorting unit, a pipe well family customization unit, a script node package compilation unit, and a pipe well generation unit; The data sorting unit is used to sort and form Excel data according to the drawing information; the Excel data includes shaft number, pipe well coordinate position, well surface elevation, well bottom elevation, well depth, and specifications; The pipe well family customization unit is used to customize the pipe well family and prepare an input interface for the Excel data; The script node package compilation unit is used to, based on the customized pipe well family, define the Excel file path, Excel workbook name, and pipe well family name as freely selectable input terminals, and compile a script node package; The pipe well generation unit is used to use the compiled script node package to generate pipe wells according to the pipe well coordinate position, well bottom elevation, well depth, and specifications.

7. The outdoor pipe well batch rapid modeling and analysis system according to claim 6, characterized in that: Customize the pipe well family, specifically including: Select family templates and family types; among them, the family templates include metric generic models and / or metric pipe fitting models; the family types include panel families and / or nested families; Add the parameters in the Excel data to the pipe shaft family; Ensure that the pipe shaft family can be resized according to the parameters by means of extrusion or array.

8. The outdoor pipe shaft batch rapid modeling and analysis system according to claim 6, characterized in that: Use Dynamo for Revit to compile a script node package, specifically including: Use the Data.ImportExcel node to load the Excel file corresponding to the Excel data; Extract the column data in the Excel data; Place pipe shaft family instances at the pipe shaft coordinate positions using FamilyInstance.ByPoint; assign parameters to the pipe shaft family using Element.SetParameterByName; Package the Dynamo code as a custom node or a Dynamo package.

9. The outdoor pipe well batch rapid modeling and analysis system according to claim 6, characterized in that: Generate pipe shafts according to the pipe shaft coordinate positions, bottom elevation, well depth, and specifications, specifically including: Select the path where the Excel data is located, specify the workbook name, and load the Excel data; Extract pipe shaft parameters, where the pipe shaft parameters include pipe shaft coordinate positions, bottom elevation, well depth, and specifications; Place pipe shafts in the Revit model using FamilyInstance.ByPoint to obtain pipe shaft family instances; Assign values to the pipe shaft family using Element.SetParameterByName to generate pipe shafts.

10. The outdoor pipe well batch rapid modeling and analysis system according to claim 6, characterized in that: After generating the pipe shafts, write four groups of data, namely the shaft number, bottom elevation, wellhead elevation, and well depth, into the pipe shaft family.

Images