Road attribute-free entity unit data integration method and device
By sorting out attributeless entity units and preparing attribute data assignment tables, Dynamo for Civil 3D software automatically adds attribute categories and data assignment, the problem of low data integration efficiency of attributeless entity units is solved, and efficient and accurate data integration and the integrity of model information is achieved.
Patent Information
- Application Number
- CN202411836964.X
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-12-13
- Publication Date
- 2025-04-11
AI Technical Summary
The prior art cannot effectively add and modify parameter information for attributeless entity units, resulting in a lack of information and data integration of model units and cannot meet design delivery requirements.
Classify the attributeless unit body through classification and station number interval, establish the attributeless unit body set, and compile a category attribute data assignment table, and use Dynamo for Civil 3D software to automatically add attribute categories and assign data.
It realizes rapid and batch data integration of attributeless entity units, improves the efficiency and accuracy of data integration, avoids data misfilling and missing data, and is suitable for digital management and operation of highway engineering.
Smart Images
Figure CN119810315A_ABST
Abstract
Description
Technical Field
[0001] The invention belongs to the technical field of digital models, and in particular is a method and a device for integrating highway attributeless entity unit data. Background Art
[0002] Engineering digitization is a major industry change that reshapes business content, design processes, and delivery results, and involves extensive data integration and application. In recent years, as the national level has continuously put forward new demands for the digitalization level of the engineering construction industry, it is necessary to establish high-precision digital models, integrate data and information, and drive professional applications at all stages of the project, ultimately achieving industrial upgrades of precise construction and full-process optimization.
[0003] At present, 3D model building software is relatively mature, and the model accuracy basically meets the requirements. However, most models do not contain any information or only contain their own size information, lack identification, design, location and other information, and the above model units are collectively referred to as attributeless entity units. How to open up the key links of digital transformation and upgrading in the engineering industry, quickly and batch add and modify parameter information for attributeless entity units, realize the integration of information and data by model units, and establish digital entity units with comprehensive information has become an urgent problem to be solved. Summary of the invention
[0004] In order to solve the problem that the existing technology cannot meet the design delivery requirements, the present invention provides a highway attributeless entity unit data integration method and device applicable to the digitization of highway engineering, which improves accuracy and efficiency, facilitates data assignment and modification of large quantities of attributeless entity units, and has wide applicability and scalability.
[0005] The present invention is achieved by adopting the following technical solutions:
[0006] A highway attributeless entity unit data integration method, comprising:
[0007] 1) According to one or both of the classification and the pile number, the type and pile number interval of the attributeless unit body are classified, and the attributeless unit body set of the same type and the same pile number interval is established to form a block and named;
[0008] 2) Setting the pile number interval of the attributeless unit body, and compiling a category attribute data assignment table according to the type of the attributeless unit body;
[0009] 3) Obtaining a set of attributeless units according to the naming result of the set of attributeless units, and obtaining the attributeless units within the set of attributeless units, and establishing a digital entity unit of a highway;
[0010] 4) Read the category attribute data assignment table, traverse the category attribute data assignment table, add attribute categories and assign attribute data to each attribute-free unit.
[0011] Preferably, in step 1), the types of attributeless entity units include pavement, slope, retaining wall, and drainage facilities.
[0012] Preferably, in step 2), the preparation of the category attribute data assignment table includes: establishing a workbook, and establishing a data type worksheet, and adding category names in the first row of the worksheet in sequence; creating a category name worksheet, in which the attributeless entity unit set names are used as columns and the attribute names are used as rows, and the attribute category data are prepared and added, so as to complete the establishment of the category attribute data assignment table corresponding to each type of attributeless entity unit.
[0013] Preferably, in step 4), adding attribute categories and assigning attribute data to each of the attributeless units includes:
[0014] 1) In Dynamo for Civil 3D, create a new project, add a file path node, read the category attribute data assignment table, and enter the category attribute data assignment table results into
[0015] Data.OpenXMLImportExcel data import and read node; synchronously input the category attribute data assignment table name, starting row, starting column and read data format information, filter the category attribute data assignment table, and obtain a one-dimensional list and a two-dimensional list;
[0016] 2) In Dynamo for Civil 3D software, create the extended property PropertySetsExtensions.PropertySetDefinitionByParameters of the category add node, enter a one-dimensional list in the category add node, read the added category name, get the category name list, and enter it into the PropertyDefinition.Name property definition name attribute add node to get the property name list;
[0017] 3) In Dynamo for Civil 3D software, use Document.BlockByName to obtain the block node in the file according to the category name to obtain the attributeless unit body set to form a block, that is, the attributeless entity unit set; and use the entity unit node in the Block.Objects block to obtain each attributeless unit body; the data of the attributeless unit body and the attribute name list are respectively input into the node object adding property Object.AddPropertySet to define the attributes of the attributeless unit body;
[0018] 4) In the Code Block node, use the loop statement structure and conditional selection code to traverse the attributeless unit body. When assigning a value to each attributeless unit body, traverse the two-dimensional array generated by the category attribute data assignment table, write the data in the category attribute data assignment table through the code, and obtain the entity unit with complete category attribute data.
[0019] Preferably, the one-dimensional list and the two-dimensional list obtained include: a one-dimensional list consisting of category names and a two-dimensional list consisting of multiple segments of attributeless entity unit set names and attribute names.
[0020] The present invention also provides a highway attributeless entity unit data integration device, comprising:
[0021] A construction module is used to classify the type and pile number interval of the attributeless unit body according to one or both of the classification and the pile number, and to establish and name the attributeless unit body forming block set for the attributeless unit bodies of the same type and the same pile number interval;
[0022] A compilation module, used to set the pile number interval of the attributeless unit body, and compile a category attribute data assignment table according to the type of the attributeless unit body;
[0023] An acquisition module is used to acquire a set of attributeless unit bodies according to the naming result of the set of attributeless unit bodies, and acquire the attributeless unit bodies inside the set of attributeless unit bodies to establish a digital entity unit of a highway;
[0024] The traversal module is used to read the category attribute data assignment table, traverse the category attribute data assignment table, and add attribute categories and assign attribute data to each attribute-free unit.
[0025] Compared with the prior art, the present invention has the following beneficial effects: the present invention opens up the key links of digital transformation and upgrading of the engineering industry, quickly and batch-wise adds and modifies parameter information for attributeless entity units, and realizes the integration of information and data by model units. The attributeless unit body and the category attribute data assignment table are read separately, and the category attribute data assignment table and the attributeless unit body are traversed by loops and conditional selection codes to add attribute categories and assign category data. This method integrates data of attributeless entity units of highway subgrades and pavements, which can effectively avoid the situations of wrong filling and missing filling of attributeless entity unit data, improve data integration efficiency and accuracy, and lay a good foundation for the digital management and operation of highway projects. This method is versatile and can facilitate batch data integration of attributeless entity units, solves the problems of low precision and cumbersome process when assigning attributeless entity units, and provides a powerful tool for liberating labor and improving accuracy. BRIEF DESCRIPTION OF THE DRAWINGS
[0026] Figure 1 It is a schematic diagram of a data window for integrating attributeless entity unit data of a highway attributeless entity unit data integration method of the present invention;
[0027] Figure 2 It is a schematic diagram of the highway attributeless entity unit data integration device of the present invention. DETAILED DESCRIPTION
[0028] Embodiments of the present application are described in detail below, and examples of the embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are intended to be used to explain the present application, and should not be construed as limiting the present application.
[0029] According to an embodiment of the present application, a method for integrating highway attributeless entity unit data is provided, comprising:
[0030] 1) According to one or both of the classification and the pile number, the type and pile number range of the attributeless unit body are classified, and the attributeless unit body set of the same type and the same pile number range is established to form a block and named; and the naming result of the attributeless unit body is ensured to be unique in the entire file collection.
[0031] 2) Setting the pile number interval of the attributeless unit body, and compiling a category attribute data assignment table according to the type of the attributeless unit body;
[0032] 3) In Dynamo for Civil 3D software, obtain the attributeless unit body set according to the naming result of the attributeless unit body set, obtain the attributeless unit bodies inside the attributeless unit body set, and establish the digital entity unit of the highway;
[0033] 4) Read the category attribute data assignment table, traverse the category attribute data assignment table, add attribute categories and assign attribute data to each attributeless unit. Read the category attribute data of the entity combination, compile entity unit coding, parameters and other information; after correctly filling in the category attribute data assignment table, read the information therein, write the category attribute data mounting program through Dynamo for civil 3D to read, filter, sort the category attribute data of the entity unit, mount it on the attributeless entity unit, and output it in the digital model.
[0034] The entity unit code and parameters refer to the information that needs to be mounted on the digital model as specified in the "Uniform Standard for Application of Highway Engineering Information Model", "Highway Engineering Design Information Model Application Standard", "Highway Engineering Information Model Design Standard" and other specifications, and no special instructions are required. Dynamo for Civil 3D is a BIM solution for the infrastructure industry. It is based on the AutoCAD platform and includes all the functions of the same version of AutoCAD. It provides professional design, analysis and mapping functions for surveying, terrain processing, earthwork calculation, site planning, road design, underground pipe network design, and many other infrastructure industries.
[0035] Preferably, in step 1), the types of attributeless entity units include pavement, slope, retaining wall, drainage facilities, etc.
[0036] Preferably, in step 2), the preparation of the category attribute data assignment table includes: establishing a workbook, and establishing a data type worksheet, and adding the category names in the first row of the worksheet in sequence; creating a category name worksheet, in which the attributeless entity unit set name is used as a column and the attribute name is used as a row, the attribute category data is prepared and added, and the category attribute data assignment table corresponding to each type of attributeless entity unit is established. The attribute category data includes, but is not limited to, identification code, classification code, starting pile number, end pile number, protection length, slope height, and width of the debris platform.
[0037] Preferably, in step 4), adding attribute categories and assigning attribute data to each of the attributeless units includes:
[0038] 1) In Dynamo for Civil 3D, create a new project, add a file path node, read the category attribute data assignment table, and enter the category attribute data assignment table results into
[0039] Data.OpenXMLImportExcel data import and read node; synchronously input the category attribute data assignment table name, starting row, starting column and read data format information, filter the category attribute data assignment table, and obtain a one-dimensional list and a two-dimensional list including: a one-dimensional list composed of category names and a two-dimensional list composed of multiple segments of attributeless entity unit set names and attribute names;
[0040] 2) In Dynamo for Civil 3D software, create the extended property PropertySetsExtensions.PropertySetDefinitionByParameters defined by parameters of the category add node, enter a one-dimensional list in the category add node, read the added category name, get the category name list, and enter it into the property definition name PropertyDefinition.Name attribute add node to get the property name list;
[0041] 3) In Dynamo for Civil 3D, use blocks to name documents
[0042] Document.BlockByName obtains the block node in the file according to the category name to obtain a set of attributeless units to form a block, that is, a set of attributeless entity units; and uses the entity unit node in the Block.Objects block to obtain each attributeless unit; the data of the attributeless unit and the attribute name list are respectively input into the node object adding property Object.AddPropertySet to define the attributes of the attributeless unit;
[0043] 4) In the Code Block node, use the loop statement structure and conditional selection code to traverse the attributeless unit body. When assigning a value to each attributeless unit body, traverse the two-dimensional array generated by the category attribute data assignment table, write the data in the category attribute data assignment table through the code, and obtain the entity unit with complete category attribute data. The loop statement structure is a while statement. The data in the category attribute data assignment table is the data corresponding to the block name formed by the attributeless unit body collection, such as the starting pile number, length, etc., that is, "K100+500", "13m", etc.
[0044] Compared with the existing method that relies on manual addition of model data, the method provided by the present invention independently completes the correspondence between data and model and completes the establishment of digital model by writing a program. It is suitable for digital models that lack attribute information, improves data addition efficiency and accuracy, and has wide applicability and scalability.
[0045] like Figure 2As shown, the present invention also provides a highway attributeless entity unit data integration device, including: a construction module 210, for classifying the type and pile number interval of the attributeless unit body according to one or both of the classification and the pile number, and establishing an attributeless unit body collection block for the attributeless unit bodies of the same type and the same pile number interval and naming them;
[0046] The compilation module 220 is used to set the pile number interval of the attributeless unit body and compile the category attribute data assignment table module according to the type of the attributeless unit body;
[0047] The acquisition module 230 is used to acquire the attributeless unit body set according to the naming result of the attributeless unit body set, and acquire the attributeless unit bodies inside the attributeless unit body set to establish the highway digital entity unit;
[0048] The traversal module 240 is used to read the category attribute data assignment table, traverse the category attribute data assignment table, and add attribute categories and attribute data assignment modules to each attribute-free unit body.
[0049] Read the category attribute data of the entity combination, compile the entity unit code, parameters and other information; after correctly filling in the category attribute data assignment table, read the information in it, write the category attribute data mounting program through Dynamo for civil 3D to read, filter, sort the category attribute data of the entity unit, and mount it on the attributeless entity unit, and output it in the digital model.
[0050] Preferably, in step 1), the types of attributeless entity units include pavement, slope, retaining wall, drainage facilities, etc.
[0051] Preferably, in step 2), the module for compiling a category attribute data assignment table includes: establishing a workbook, and establishing a data type worksheet, and adding category names in the first row of the worksheet in sequence; creating a category name worksheet, in which the attributeless entity unit set names are used as columns and the attribute names are used as rows, and attribute category data are compiled and added, so as to complete the establishment of category attribute data assignment tables corresponding to various types of attributeless entity units.
[0052] Preferably, in step 4), the module for adding attribute categories and assigning attribute data to each of the attributeless units includes:
[0053] 1) In Dynamo for Civil 3D, create a new project, add a file path node, read the category attribute data assignment table, and enter the category attribute data assignment table results into
[0054] Data.OpenXMLImportExcel data import and read node; synchronously input the category attribute data assignment table name, starting row, starting column and read data format information, filter the category attribute data assignment table, and obtain a one-dimensional list and a two-dimensional list including: a one-dimensional list composed of category names and a two-dimensional list composed of multiple segments of attributeless entity unit set names and attribute names;
[0055] 2) In Dynamo for Civil 3D software, create the extended property PropertySetsExtensions.PropertySetDefinitionByParameters defined by parameters of the category add node, enter a one-dimensional list in the category add node, read the added category name, get the category name list, and enter it into the property definition name PropertyDefinition.Name attribute add node to get the property name list;
[0056] 3) In Dynamo for Civil 3D, use blocks to name documents
[0057] Document.BlockByName obtains the block node in the file according to the category name to obtain a set of attributeless units to form a block, that is, a set of attributeless entity units; and uses the entity unit node in the Block.Objects block to obtain each attributeless unit; the data of the attributeless unit and the attribute name list are respectively input into the node object adding property Object.AddPropertySet to define the attributes of the attributeless unit;
[0058] 4) In the Code Block node, use the loop statement structure and conditional selection code to traverse the attributeless unit body. When assigning a value to each attributeless unit body, traverse the two-dimensional array generated by the category attribute data assignment table, write the data in the category attribute data assignment table through the code, and obtain the entity unit with complete category attribute data.
[0059]
[0060] Embodiment 1:
[0061] In the specific implementation process, the data integration of a highway subgrade entity unit without attributes includes:
[0062] The total length of a highway slope model is 40 km, and the number of attributeless entity units is 4226, which are divided into 21 sections according to the pile number range. Attribute categories are added to the attributeless unit body. The attribute categories include: identification information, location information, and size information. Among them, the identification information includes the identification code and classification code; the location information includes the starting pile number, the end pile number, and the position; the size information includes the protection length, slope height, and the width of the debris platform.
[0063] ① In the CAD software, the command of forming blocks from attributeless unit sets was executed on the attributeless entity unit sets of 21 slope sections, and the generated blocks were named in sequence according to the uniqueness principle.
[0064] ② Prepare a table for assigning category attribute data. Figure 1 , create a workbook and a data type worksheet, add the category names in the first row of the worksheet: 01 identification information, 02 position information, 03 size information; create a 01 identification information worksheet, in which the 21 segments of attributeless entity unit set names are used as columns, and the attribute 01 identification code and 02 classification code are used as rows, and the identification information data to be added is compiled;
[0065] Create a 02 position information worksheet, in which the names of the 21 attributeless entity unit sets are used as columns, and the attributes 01 starting pile number, 02 end pile number, and 03 position are used as rows to compile the position information data to be added;
[0066] Create a 03 dimension information worksheet. In the worksheet, use the names of the 21 segments of attributeless entity units as columns, and the attributes 01 protection length, 02 slope height, and 03 debris platform width as rows. Compile the dimension information data to be added and create attribute data assignment tables for each type of attributeless entity unit category.
[0067] ③In Dynamo for Civil 3D software, create a project, add a File Path file path node, read the category attribute data assignment table, and input the result into the Data.OpenXMLImportExcel data reading node. Through the nesting of two Code Block nodes, the read worksheet is filtered with "0" and "b = a[0][i]", and a two-dimensional list 1 consisting of 21 segments of attributeless entity unit set names and 01 identification code and 02 classification code is obtained; through the nesting of two Code Block nodes, the read worksheet is filtered with "1" and "b = a[0][i]", and a two-dimensional list 2 consisting of 21 segments of attributeless entity unit set names and 01 starting pile number, 02 end pile number, and 03 position is obtained; through the nesting of two Code Block nodes, the read worksheet is filtered with "2" and "b = a[0][i]", and a two-dimensional list 3 consisting of 21 segments of attributeless entity unit set names and 01 protection length, 02 slope height, and 03 debris platform width is obtained.
[0068] ④In Dynamo for Civil 3D software, create a category and add nodes
[0069] PropertySetsExtensions.PropertySetDefinitionByParameters, enter a one-dimensional list in the category add node, read the added category name, get the category name list, such as 01 identification information, 02 location information, 03 size information, and enter it into the PropertyDefinition.Name property add node to get the property name list.
[0070] ⑤ In Dynamo for Civil 3D, use the Document.BlockByName node to get the name of the block, i.e. the collection of entity units without attributes. And use the entity unit node in the Block.Objects block to get each of the attributeless units. The attributeless units and the attribute name list are respectively input into the node Object.AddPropertySet to define the attributes of the attributeless units.
[0071] ⑥ By using the while loop in the Code Block node to traverse the attributeless unit body, when assigning a value to each unit body, traverse the generated two-dimensional list 1, two-dimensional list 2, and two-dimensional list 3 according to the requirements. Obtain the entity unit with complete category attribute data.
[0072] The present invention integrates data of non-attribute entity units of highway subgrade and pavement, which can effectively avoid the situation of wrong filling and missing filling of non-attribute entity unit data, improve the efficiency and accuracy of data integration, and lay a good foundation for the digital management and operation of highway projects. The method is universal and can facilitate batch data integration of non-attribute entity units, solves the problems of low precision and cumbersome process when assigning values to non-attribute entity units, and provides a powerful tool for liberating labor and improving accuracy.
[0073] In the description of the present invention, it is necessary to understand that the indicated orientation or positional relationship is based on the orientation or positional relationship shown in the accompanying drawings, and is only for the convenience of describing the present invention and simplifying the description, rather than indicating or implying that the device or element referred to must have a specific orientation, be constructed and operated in a specific orientation, and therefore cannot be understood as a limitation on the present invention.
[0074] Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions and variations may be made to the embodiments without departing from the principles and spirit of the present invention, and that the scope of the present invention is defined by the appended claims and their equivalents.
Claims
1. A highway attributeless entity unit data integration method, characterized by: include: 1) According to one or both of the classification and the pile number, the type and pile number interval of the attributeless unit body are classified, and the attributeless unit body set of the same type and the same pile number interval is established to form a block and named; 2) Setting the pile number interval of the attributeless unit body, and compiling a category attribute data assignment table according to the type of the attributeless unit body; 3) Obtaining a set of attributeless unit bodies according to the naming result of the set of attributeless unit bodies, and obtaining the attributeless unit bodies within the set of attributeless unit bodies, and establishing a digital entity unit of a highway; 4) Read the category attribute data assignment table, traverse the category attribute data assignment table, add attribute categories and assign attribute data to each attribute-free unit.
2. The highway attributeless entity unit data integration method according to claim 1 is characterized by: In step 1), the types of attributeless entity units include: pavement, slope, retaining wall, and drainage facilities.
3. The highway attributeless entity unit data integration method according to claim 1 is characterized by: In step 2), the preparation of the category attribute data assignment table includes: establishing a workbook, and establishing a data type worksheet, and adding category names in the first row of the worksheet in sequence; creating a category name worksheet, in which the attributeless entity unit set names are used as columns and the attribute names are used as rows, and the attribute category data are prepared and added, so as to complete the establishment of the category attribute data assignment table corresponding to each type of attributeless entity unit.
4. The highway attributeless entity unit data integration method according to claim 1 is characterized by: In step 4), adding attribute categories and assigning attribute data to each attribute-free unit body includes: 1) In Dynamo for Civil 3D software, create a new project, add a file path node, read the category attribute data assignment table, and input the category attribute data assignment table result into the data import read node; simultaneously input the category attribute data assignment table name, starting row, starting column and read data format information to obtain a one-dimensional list and a two-dimensional list; 2) Establish an extended feature defined by parameters of the category adding node, input a one-dimensional list in the category adding node, read the added category name, obtain the category name list, and input it into the feature definition name attribute adding node to obtain the attribute name list; 3) Using the block naming document to obtain the block node in the file according to the category name to obtain the attributeless unit body set to form a block, that is, the attributeless entity unit set; and using the entity unit node in the Block.Objects block to obtain each attributeless unit body; the data of the attributeless unit body and the attribute name list are respectively input into the node object addition characteristics, and the attributes of the attributeless unit body are defined; 4) In the code block node, use the loop statement structure and conditional selection code to traverse the attributeless unit body. When assigning a value to each attributeless unit body, traverse the two-dimensional array generated by the category attribute data assignment table, write the data in the category attribute data assignment table through the code, and obtain the entity unit with complete category attribute data.
5. The highway attributeless entity unit data integration method according to claim 4 is characterized by: The one-dimensional list and the two-dimensional list obtained include: a one-dimensional list composed of category names and a two-dimensional list composed of multiple segments of attributeless entity unit set names and attribute names.
6. A highway attributeless entity unit data integration device, characterized in that: include: A construction module is used to classify the type and pile number range of the attributeless unit bodies according to one or both of the classification and the pile number, and to establish and name the attributeless unit body set for the attributeless unit bodies of the same type and the same pile number range; A compilation module, used to set the pile number interval of the attributeless unit body, and compile a category attribute data assignment table according to the type of the attributeless unit body; An acquisition module is used to acquire a set of attributeless unit bodies according to the naming result of the set of attributeless unit bodies, and acquire the attributeless unit bodies inside the set of attributeless unit bodies to establish a digital entity unit of a highway; The traversal module is used to read the category attribute data assignment table, traverse the category attribute data assignment table, and add attribute categories and assign attribute data to each attribute-free unit.