CN115292791B - Method for converting JSL-route expert design data into universal data format - Google Patents

Method for converting JSL-route expert design data into universal data format Download PDF

Info

Publication number
CN115292791B
CN115292791B CN202210977937.9A CN202210977937A CN115292791B CN 115292791 B CN115292791 B CN 115292791B CN 202210977937 A CN202210977937 A CN 202210977937A CN 115292791 B CN115292791 B CN 115292791B
Authority
CN
China
Prior art keywords
attribute
model
data
file
excel
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202210977937.9A
Other languages
Chinese (zh)
Other versions
CN115292791A (en
Inventor
何鲁鄂
陈中治
刘东升
望开潘
周鹏光
杨明
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
CCCC Second Highway Consultants Co Ltd
Original Assignee
CCCC Second Highway Consultants Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by CCCC Second Highway Consultants Co Ltd filed Critical CCCC Second Highway Consultants Co Ltd
Priority to CN202210977937.9A priority Critical patent/CN115292791B/en
Publication of CN115292791A publication Critical patent/CN115292791A/en
Application granted granted Critical
Publication of CN115292791B publication Critical patent/CN115292791B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F30/00—Computer-aided design [CAD]
    • G06F30/10—Geometric CAD
    • G06F30/13—Architectural design, e.g. computer-aided architectural design [CAAD] related to design of buildings, bridges, landscapes, production plants or roads

Landscapes

  • Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Geometry (AREA)
  • General Physics & Mathematics (AREA)
  • Computer Hardware Design (AREA)
  • Theoretical Computer Science (AREA)
  • Mathematical Optimization (AREA)
  • Computational Mathematics (AREA)
  • Architecture (AREA)
  • Mathematical Analysis (AREA)
  • Structural Engineering (AREA)
  • Pure & Applied Mathematics (AREA)
  • Evolutionary Computation (AREA)
  • General Engineering & Computer Science (AREA)
  • Civil Engineering (AREA)
  • Stored Programmes (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a method for converting JSL-route expert design data into a universal data format, which comprises the following steps: s1: outputting an FBX model file and a BIM attribute file in JSL-route expert design software, and performing deep analysis on the BIM attribute file; s2: performing model analysis and format conversion operation on the FBX model file in the JSL-route expert design result data; s3: performing attribute analysis on the BIM attribute file; s4: performing model format conversion on the DWG model file of the result obtained in the step S2; s5: performing model and attribute data matching processing on the Excel table of the result obtained in the step S3 and the DGN model file of the result obtained in the step S4; s6: and (3) performing attribute importing operation on the Excel attribute data table obtained in the step (5) and the DGN model file obtained in the step (4) to obtain the DGN data file with the attribute information. The invention realizes the lossless conversion from JSL-route expert design result data to DGN data, and achieves the purpose of cross-platform transmission of building information models.

Description

Method for converting JSL-route expert design data into universal data format
Technical Field
The invention relates to the field of Building Information Model (BIM) cross-platform data transmission, in particular to a method for converting JSL-route expert design data into a universal data format.
Background
The JSL-route expert system is road design software developed by the middle-traffic second road investigation design institute Limited company, relatively completely covers all layers of municipal road design and road design, can effectively assist designers in carrying out road, bridge and other design works, has the advantages of simple operation, easy mastering and learning and the like, and is used by wide road designers. The DGN file format is a data format developed by Bentley engineering software systems, inc., and is a general data format widely applied in the engineering design field, and the DGN file contains not only geometric information of a model but also information such as codes, colors, materials, custom engineering properties and the like.
As Building Information Model (BIM) applications go deep, how designed information models can be integrated and used on various platforms becomes a key issue. The current mainstream BIM platform supports DGN generic data formats better, and generally requires that DGN generic data formats be provided for delivering model geometry information and attribute information. Therefore, how to convert the model generated by the JSL-route expert system and the attribute information into DGN data without damage to enter the mainstream platform becomes an increasingly prominent problem. While the Bentley software system supports the mode of importing a DWG or FBX model to import JSL-route expert design result data, only the geometric information of the model can be imported, and the engineering attribute information of the JSL-route expert system, such as design information of codes, design start stake marks, design materials and the like, cannot be imported.
Therefore, a method of converting JSL-route expert design data into a generic data format has been proposed to address the above-mentioned problems.
Disclosure of Invention
In order to solve the problems, the invention aims to provide a method for converting JSL-route expert design data into a general data format, thereby realizing lossless conversion from JSL-route expert design result data (model and attribute information) to DGN data and achieving the purpose of cross-platform transmission of building information models.
In order to achieve the above purpose, the technical scheme adopted by the invention is as follows: a method of converting JSL-route expert design data to a generic data format, comprising the steps of:
s1: outputting an FBX model file and a BIM attribute file in JSL-route expert design software, performing deep analysis on the BIM attribute file, extracting attribute classification and related attribute fields in the BIM attribute file, and establishing Excel empty tables of a plurality of corresponding attribute classification names, wherein the Excel empty tables comprise Element IDs and attribute fields;
s2: performing model analysis and format conversion operation on an FBX model file in JSL-route expert design result data, storing a model name in the FBX model file into a layer name in a DWG format, and converting a three-dimensional model object into a grid object in the DWG format to obtain a DWG model file with the model name;
s3: performing attribute analysis on a BIM attribute file in JSL-route expert design result data, extracting and converting model names and attribute data in the BIM attribute file into an Excel table, and obtaining an Excel table with the model names and the attribute data;
s4: performing model format conversion on the DWG model file obtained in the step S2 to obtain a DGN model file with Element ID;
s5: performing model and attribute data matching processing on the Excel table obtained in the step S3 and the DGN model file obtained in the step S4, and writing the result into the Excel empty table obtained in the step S1 to obtain an Excel table with Element ID and attribute data;
s6: and (3) performing attribute importing operation on the Excel attribute data table obtained in the step (5) and the DGN model file obtained in the step (4), and performing matching assignment on the attributes of the model according to the Element ID to obtain the DGN data file with the attribute information.
Preferably, in the step S1, attribute classification, attribute field extraction, and Excel blank table establishment specifically include:
(1.1) attribute classification: the BIM attribute file stores attribute information of the model in an XML format, and analyzes attribute classification in the model, wherein the attribute classification comprises a traffic lane, a hard road shoulder, a soil road shoulder, a filling, a digging, a drainage ditch, a bridge and the like;
(1.2) extraction of attribute fields: analyzing specific attribute fields under attribute classification in the step (1.1), wherein the attribute fields under the classification of the traffic lanes comprise BIM codes, thickness of a structural layer, area, name, start pile number, end pile number, belonging roads, pile number section length and the like;
(1.3) establishing an Excel blank table: and (3) respectively establishing a worksheet in Excel according to the attribute classification obtained by the analysis in the step (1.1), wherein the worksheet name is an attribute classification name, establishing a worksheet header under the corresponding worksheet name according to the attribute field obtained by the analysis in the step (1.2), wherein the worksheet header is an attribute field under each attribute classification, and inserting an Element ID field in a first column.
Preferably, in the step S2, the FBX model parsing and the model format conversion specifically include:
(2.1) FBX model analysis: reading an FBX model file through an FBX reading module of FME software, decomposing the FBX model into a minimum-level component model by using a deagglomerator converter, analyzing the hierarchical relationship and the name of the model, and extracting the model name by using a geometry PropertyExpactor converter;
(2.2) model Format conversion: converting each component model decomposed in the step (2.1) into a three-dimensional grid, storing the extracted Name of each component model into a Layer Name attribute, and writing the three-dimensional grid and the Layer Name into a DWG file through a DWG writing module of FME software.
Preferably, in the step S3, BIM attribute parsing and attribute data conversion specifically include:
(3.1) BIM Attribute resolution: the BIM attribute file stores attribute information of the model in an XML format, reads the BIM attribute file through an XML reading module of FME software, analyzes the hierarchical relationship of the attribute, and extracts modelName, key and Attrie field attribute values in the BIM attribute file, wherein the ModelName attribute values correspond to model names in the FBX model file extracted in the step S2 one by one;
(3.2) conversion of attribute data: and (3) writing modelName, key and Attrie field attribute values of each piece of data obtained in the step (3.1) into an Excel table through an Excel writing module of FME software.
Preferably, the model format conversion in the step S4 means that the DWG model file obtained in the step S2 is converted into the DGN format by the ORD (OpenRoads Designer) software under the Bentley platform, the layer information in the DWG model file is retained and is represented as a Level name attribute in the DGN file, and any model Element entering the ORD software is assigned a unique Element ID by the ORD software, so that a DGN model file with the Element ID and the Level name attribute information is obtained.
Preferably, the matching processing of the model and the attribute data in the step S5 refers to exposing the attribute information in the DGN model file obtained in the step S4 and classifying the attribute information; performing attribute classification on the Excel table of the result obtained in the step S3, and creating a list set; matching and associating attribute information in the DGN model file of the result obtained in the step S4 with attribute information in the Excel table of the result obtained in the step S3 through a model name, and finally writing the attribute information into the Excel empty table of the step S1; the method specifically comprises the following steps:
(5.1) DGN model file attribute exposure: the DGN model file of the result obtained in the step S4 is read through a DGN reading module of FME software, and the formats of the igds Element ID, the igds Level name and the igds type are exposed, wherein the igds Element ID is the Element ID attribute of the model, the igds Level name is the Level name attribute of the model, the igds type is the model type, and the igds type is the igds_mesh, and then the next flow process is entered;
(5.2) classification of DGN model file attributes: classifying the attributes of the igds level name attribute values exposed in the step (5.1) through a TestFilter converter of FME software, wherein the classification method is the same as that of the step S1, and if the igds level name attribute values comprise a "traffic lane", the igds element id and the igds level name attribute of the model enter a "traffic lane" port to carry out the next processing;
(5.3) Excel table attribute classification: the Excel reading module of FME software reads the attribute values of modelName, key and Attrieb fields in the Excel table of the result obtained in the step S3, and attribute classification is carried out on the ModelName attribute values, wherein the classification method is the same as that in the step S1, and if the ModelName attribute values comprise a "traffic lane", data enter a "traffic lane" port to carry out the next step of processing;
(5.4) creating a list set: creating a list set for Attrie attribute data under the same classification name in the step (5.3) through a ListBulder converter of FME software, wherein attribute values such as BIM codes, structure layer thicknesses, areas, names, starting point stake numbers, end point stake numbers, belonging roads, stake number segment lengths and the like under the classification name of a 'traffic lane' and a modelName are used as the list set to enter the next step of processing;
(5.5) matching association: performing matching association processing on the data under the same attribute classification in the step (5.2) and the step (5.4) through a FeatureMerger converter of FME software, wherein a request parameter of the FeatureMerger converter is from an igds level name attribute of the step (5.2), and a Supplier parameter of the FeatureMerger converter is from a data set containing a modelName in the step (5.4); combining the data with the same igds level name attribute value and the same modelName attribute value, wherein the combined result is that a new list set comprises attribute value data such as igds element id, modelName, BIM code under the attribute classification name, structure layer thickness, area, start point pile number, end point pile number and the like;
(5.6) writing into Excel table: writing the list set matched and associated in the step (5.5) into an Excel empty table with the Element ID of the result obtained in the step S1 through an Excel writing module of FME software;
the attribute classification in the step (5.5) corresponds to the name of the same name of the Excel table obtained in the step (S1), the igds Element ID attribute value of the model is written into the Element ID column of the Excel blank table, and other attribute values of the model, such as BIM code, thickness of the structural layer, area, start point pile number, end point pile number and the like, are written into the column corresponding to the Excel blank table.
Preferably, the attribute importing in step S6 refers to matching and importing the DGN model file with the Element ID obtained in step S4 and the Excel table with the Element ID obtained in step S5 through the ORD software under the Bentley platform, and other attribute values corresponding to the same line of the attribute values of the Element ID in the Excel table, such as BIM code, thickness of structural layer, area, start-point pile number, end-point pile number, and the like, are linked to the DGN model corresponding to the Element ID, so as to obtain the DGN data file with the attribute values.
In the specific steps, the steps S2, S3 and S5 are key, the steps S2, S3 are the decomposition of JSL-route expert design result data, the step S5 is the process of re-matching the decomposed model and attribute information and attaching the Element ID attribute of the decomposed model, and the model and attribute information can be smoothly written into the DGN data file only with the result of the step S5. The steps solve the technical problem that model geometric information and attribute information in JSL-route expert design result data cannot be converted into DGN data files together at present, and the difficulty is that storage formats of different software are different. The method solves the technical problems, realizes the lossless conversion from JSL-route expert design result data to a general-format DGN data format, and retains the complete model geometric information and attribute information. In the prior art, only model geometric information in JSL-route expert design result data can be converted by directly importing the JSL-route expert design result data into ORD software, and attribute information cannot be converted and is required to be manually input into the ORD software in the later period.
Compared with the prior art, the method realizes automatic model decomposition and automatic attribute conversion of the Excel table through the FME software in the steps S2 and S3, realizes automatic model and attribute matching, automatic Excel table writing and other operations through constructing a proper conversion module and a proper processing flow in the FME software in the step S5, does not need manual information input in the whole process automation, and greatly improves the conversion efficiency.
By the method for converting JSL-route expert design data into the universal data format, the JSL-route expert design result data FBX model file and BIM attribute file are analyzed, and based on the space data conversion tool FME software, a proper conversion module and a proper processing flow are researched and constructed, so that lossless conversion from the JSL-route expert design result data into DGN data is realized, and complete model geometric information and attribute information of the JSL-route expert design result data are reserved. The method is simple and easy to implement, has better practicability and flexibility, solves the problem of the exchange barrier between the prior JSL-route expert data and DGN data, and achieves the purpose of cross-platform transmission of the building information model. The processing process of the method is not similar, and the method can be used in the application fields of three-dimensional design, visualization, management and the like of the road model, and the exchange and information sharing efficiency of JSL-route expert design results is effectively improved.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for the description of the embodiments will be briefly described below, and it is apparent that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart of a method for converting JSL-route expert design data into a generic data format in accordance with the present invention;
FIG. 2 is a flow chart of the conversion of the FBX model parsing format;
FIG. 3 is a flow chart of a model and attribute data matching process;
FIG. 4 is a diagram of a model and attribute information interface in JSL-route expert design software;
FIG. 5 is a diagram of the model and attribute information interface of the DGN format after the ORD software opens the conversion.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments.
A method for converting JSL-route expert design data into a generic data format according to the present invention will be described in detail with reference to the steps shown in fig. 1.
Step S1: outputting an FBX model file and a BIM attribute file in JSL-route expert design software, performing deep analysis on the BIM attribute file, and extracting attribute classification and related attribute fields in the BIM attribute file to establish an Excel blank table containing attribute fields and Element IDs. The method comprises the following specific steps:
(1.1) attribute classification: the BIM attribute file stores attribute information of the model in an XML format, and analyzes attribute classification in the model, wherein the attribute classification comprises a traffic lane, a hard road shoulder, a soil road shoulder, a filling, a digging, a drainage ditch, a bridge and the like;
(1.2) extraction of attribute fields: analyzing specific attribute fields under attribute classification in the step (1.1), wherein the attribute fields under the classification of the traffic lanes comprise BIM codes, thickness of a structural layer, area, name, start pile number, end pile number, belonging roads, pile number section length and the like; the attribute fields under the classification of the road shoulder comprise BIM codes, areas, names, start point pile numbers, end point pile numbers, the length of the belonging road and pile number sections and the like; the attribute fields under the bridge classification comprise BIM codes, names, start point stake numbers, end point stake numbers, belonging roads, bridge span data, bridge framing and the like;
(1.3) establishing an Excel blank table: and (3) respectively establishing a worksheet in Excel according to the attribute classification obtained by the analysis in the step (1.1), wherein the worksheet name is an attribute classification name, establishing a worksheet header under the corresponding worksheet name according to the attribute field obtained by the analysis in the step (1.2), wherein the worksheet header is an attribute field under each attribute classification, and inserting an Element ID field in a first column. As shown in table 1, the attribute is classified as an attribute field of a traffic lane, and as shown in table 2, the attribute is classified as an attribute field of a road shoulder.
Table 1 attribute classification as attribute field of traffic lane
Figure 433636DEST_PATH_IMAGE002
Table 2 attribute classification as attribute field of road shoulder
Figure 255836DEST_PATH_IMAGE004
Step S2: performing operations such as model analysis, format conversion and the like on the FBX model file in the JSL-route expert design result data, storing the model name in the FBX model file into the layer name in the DWG format, and converting the three-dimensional model object into a grid object in the DWG format to obtain the DWG model file with the model name. As shown in fig. 2, the method comprises the following specific steps:
(2.1) FBX model analysis: reading an FBX model file through an FBX reading module of FME software, decomposing the FBX model into a minimum-level component model by using a deagglomerator converter, analyzing the hierarchical relationship and the name of the model, and extracting the model name by using a geometry PropertyExpactor converter;
(2.2) model Format conversion: converting each component model decomposed in the step (2.1) into a three-dimensional grid, storing the extracted Name of each component model into a Layer Name attribute, and writing the three-dimensional grid and the Layer Name into a DWG file through a DWG writing module of FME software.
Step S3: and carrying out attribute analysis on the BIM attribute file in the JSL-route expert design result data, extracting and converting the model name and the attribute data in the BIM attribute file into an Excel table, and obtaining the Excel table with the model name and the attribute data. The method comprises the following specific steps:
(3.1) BIM Attribute resolution: the BIM attribute file stores attribute information of the model in an XML format, reads the BIM attribute file through an XML reading module of FME software, analyzes the hierarchical relationship of the attribute, and extracts modelName, key and Attrie field attribute values in the BIM attribute file, wherein the ModelName attribute values correspond to model names in the FBX model file extracted in the step S2 one by one;
(3.2) conversion of attribute data: the modelName, key, attrib field attribute values of each piece of data obtained in step (3.1) are written into an Excel table by an Excel writing module of FME software, and the result is shown in table 3.
TABLE 3BIM Attribute File parsed data Table
Figure 504415DEST_PATH_IMAGE006
Step S4: and (3) performing model format conversion on the DWG file obtained in the step (S2) to obtain a DGN model file with the Element ID. The main steps are that the DWG model file obtained in the step S2 is opened through ORD software under the Bentley platform and then stored in a DGN format. The layer information in the DWG model file is reserved and is expressed as a Level name attribute in the DGN file, and any model Element entering the ORD software is endowed with a unique Element ID by the ORD software, so that the DGN model file with the Element ID and the Level name attribute information is obtained.
Step S5: and (3) carrying out model and attribute data matching processing on the Excel table obtained in the step (S3) and the DGN model file obtained in the step (S4), and writing the result into the Excel blank table obtained in the step (S1) to obtain the Excel table with Element ID and attribute data. As shown in fig. 3, the method mainly comprises the following steps:
(5.1) DGN model file attribute exposure: the DGN model file of the result obtained in the step S4 is read through a DGN reading module of FME software, and the formats of the igds Element ID, the igds Level name and the igds type are exposed, wherein the igds Element ID is the Element ID attribute of the model, the igds Level name is the Level name attribute of the model, the igds type is the model type, and the igds type is the igds_mesh, and then the next flow process is entered;
(5.2) classification of DGN model file attributes: classifying the attributes of the igds level name attribute values exposed in the step (5.1) through a TestFilter converter of FME software, wherein the classification method is the same as that of the step S1, and if the igds level name attribute values comprise a "traffic lane", the igds element id and the igds level name attribute of the model enter a "traffic lane" port to carry out the next processing;
(5.3) Excel table attribute classification: the Excel reading module of FME software reads the attribute values of modelName, key and Attrieb fields in the Excel table of the result obtained in the step S3, and attribute classification is carried out on the ModelName attribute values, wherein the classification method is the same as that in the step S1, and if the ModelName attribute values comprise a "traffic lane", data enter a "traffic lane" port to carry out the next step of processing;
(5.4) creating a list set: creating a list set for Attrie attribute data under the same classification name in the step (5.3) through a ListBulder converter of FME software, wherein attribute values such as BIM codes, structure layer thicknesses, areas, names, starting point stake numbers, end point stake numbers, belonging roads, stake number segment lengths and the like under the classification name of a 'traffic lane' and a modelName are used as the list set to enter the next step of processing;
(5.5) matching association: and (3) carrying out matching association processing on the data under the same attribute classification in the step (5.2) and the step (5.4) through a FeatureMerger converter of FME software, wherein a Requester parameter of the FeatureMerger converter is from an igds level name attribute of the step (5.2), and a Supplier parameter of the FeatureMerger converter is from a data set containing a modeName in the step (5.4). The data with the same igds level name attribute value and the same modelName attribute value are combined, and the combination result is that a new list set comprises the igds element id, the modelName, BIM code under the attribute classification name, the thickness of a structural layer, the area, the starting point pile number, the end point pile number and other attribute value data;
(5.6) writing into Excel table: and (3) writing the list set matched and associated in the step (5.5) into an Excel empty table with the Element ID of the result obtained in the step S1 through an Excel writing module of FME software. The attribute classification in step (5.5) corresponds to the name of the same name of the Excel table obtained in step S1, the igds Element ID attribute value of the model is written into the Element ID column of the Excel empty table, other attribute values of the model, such as BIM code, thickness of structural layer, area, start point pile number, end point pile number, etc., are written into the column corresponding to the Excel empty table, as shown in table 4, the attribute classification is the attribute data table (part) of the traffic lane, and as shown in table 5, the attribute classification is the attribute data table (part) of the soil road shoulder.
Table 4 Property data sheet (section) for classifying Properties into lanes
Figure 509411DEST_PATH_IMAGE008
Table 5 attribute data table (section) for classifying attributes into shoulders
Figure 792625DEST_PATH_IMAGE010
Step S6: and (3) performing attribute importing operation on the Excel attribute data table obtained in the step (5) and the DGN model file obtained in the step (4), and performing matching assignment on the attributes of the model according to the Element ID to obtain the DGN data file with the attribute information. The method mainly comprises the steps of carrying out matching import on the DGN model file with the Element ID obtained in the step S4 and the Excel table with the Element ID obtained in the step S5 through ORD software under a Bentley platform, and linking other attribute values, such as BIM coding, structure layer thickness, area, starting point pile number, end point pile number and the like, of the same line of the attribute value of the corresponding Element ID in the Excel table on the DGN model of the corresponding Element ID to obtain the DGN data file with the attribute value.
From the above, the method of the invention converts JSL-route expert design result data into DGN data in a lossless manner as shown in figure 4, and retains the complete model geometric information and attribute information thereof as shown in figure 5.
The above description is only specific embodiments of the present invention, the protection scope of the present invention is not limited thereto, and any person skilled in the art should understand that modifications and substitutions within the scope of the present invention are included in the scope of the present invention, and the protection scope of the present invention should be defined by the claims.

Claims (7)

  1. A method of converting jsl-route expert design data to a generic data format, comprising the steps of:
    s1: outputting an FBX model file and a BIM attribute file in JSL-route expert design software, firstly analyzing the BIM attribute file, extracting attribute classifications and related attribute fields in the BIM attribute file, and establishing Excel empty tables of a plurality of corresponding attribute classification names, wherein the Excel empty tables comprise Element IDs and attribute fields;
    s2: performing model analysis and format conversion operation on an FBX model file in JSL-route expert design result data, storing a model name in the FBX model file into a layer name in a DWG format, and converting a three-dimensional model object into a grid object in the DWG format to obtain a DWG model file with the model name;
    s3: performing attribute analysis on a BIM attribute file in JSL-route expert design result data, extracting and converting model names and attribute data in the BIM attribute file into an Excel table, and obtaining an Excel table with the model names and the attribute data;
    s4: performing model format conversion on the DWG model file obtained in the step S2 to obtain a DGN model file with Element ID;
    s5: performing model and attribute data matching processing on the Excel table obtained in the step S3 and the DGN model file obtained in the step S4, and writing the result into the Excel empty table obtained in the step S1 to obtain an Excel table with Element ID and attribute data;
    s6: and (3) performing attribute importing operation on the Excel attribute data table obtained in the step (5) and the DGN model file obtained in the step (4), and performing matching assignment on the attributes of the model according to the Element ID to obtain the DGN data file with the attribute information.
  2. 2. The method for converting JSL-routing expert design data into a generic data format according to claim 1, wherein the step S1 includes the steps of classifying attributes, extracting attribute fields, and creating an Excel blank table, specifically including:
    (1.1) attribute classification: the BIM attribute file stores attribute information of the model in an XML format, and analyzes attribute classification in the model, wherein the attribute classification comprises a traffic lane, a hard road shoulder, a soil road shoulder, a filling, a digging, a drainage ditch and a bridge;
    (1.2) extraction of attribute fields: analyzing specific attribute fields under attribute classification in the step (1.1), wherein the specific attribute fields comprise attribute fields under traffic lane classification, and the attribute fields under traffic lane classification comprise BIM codes, structure layer thickness, area, names, start point stake marks, end point stake marks, belonging roads and stake mark segment lengths;
    (1.3) establishing an Excel blank table: and (3) respectively establishing a worksheet in Excel according to the attribute classification obtained by the analysis in the step (1.1), wherein the worksheet name is an attribute classification name, establishing a worksheet header under the corresponding worksheet name according to the attribute field obtained by the analysis in the step (1.2), wherein the worksheet header is an attribute field under each attribute classification, and inserting an Element ID field in a first column.
  3. 3. The method for converting JSL-routing expert design data into a generic data format according to claim 1, wherein the FBX model parsing and model format conversion in step S2 specifically includes:
    (2.1) FBX model analysis: reading an FBX model file through an FBX reading module of FME software, decomposing the FBX model into a minimum-level component model by using a deagglomerator converter, analyzing the hierarchical relationship and the name of the model, and extracting the model name by using a geometry PropertyExpactor converter;
    (2.2) model Format conversion: converting each component model decomposed in the step (2.1) into a three-dimensional grid, storing the extracted Name of each component model into a Layer Name attribute, and writing the three-dimensional grid and the Layer Name into a DWG file through a DWG writing module of FME software.
  4. 4. The method for converting JSL-routing expert design data into a generic data format according to claim 1, wherein the BIM attribute parsing and attribute data conversion in step S3 specifically includes:
    (3.1) BIM Attribute resolution: the BIM attribute file stores attribute information of the model in an XML format, reads the BIM attribute file through an XML reading module of FME software, analyzes the hierarchical relationship of the attribute, and extracts modelName, key and Attrie field attribute values, modelName attribute values and model names in the FBX model file extracted in the step S2 to be in one-to-one correspondence;
    (3.2) conversion of attribute data: and (3) writing modelName, key and Attrie field attribute values of each piece of data obtained in the step (3.1) into an Excel table through an Excel writing module of FME software.
  5. 5. The method for converting JSL-route expert design data into a universal data format according to claim 1, wherein the model format conversion in step S4 means that the DWG model file obtained in step S2 is converted into DGN format by the ORD software under the Bentley platform, layer information in the DWG model file is retained, a Level name attribute is represented in the DGN file, and any model Element entering the ORD software is assigned a unique Element ID by the ORD software, so that a DGN model file with the Element ID and the Level name attribute information is obtained.
  6. 6. The method for converting JSL-route expert design data into a universal data format according to claim 1, wherein the model and attribute data matching process in step S5 refers to exposing and classifying attribute information in the DGN model file of the result obtained in step S4; performing attribute classification on the Excel table of the result obtained in the step S3, and creating a list set; matching and associating attribute information in the DGN model file of the result obtained in the step S4 with attribute information in the Excel table of the result obtained in the step S3 through a model name, and finally writing the attribute information into the Excel empty table of the step S1; the method specifically comprises the following steps:
    (5.1) DGN model file attribute exposure: the DGN model file of the result obtained in the step S4 is read through a DGN reading module of FME software, and the formats of the igds Element ID, the igds Level name and the igds type are exposed, wherein the igds Element ID is the Element ID attribute of the model, the igds Level name is the Level name attribute of the model, the igds type is the model type, and the igds type is the igds_mesh, and then the next flow process is entered;
    (5.2) classification of DGN model file attributes: classifying the attributes of the igds level name attribute values exposed in the step (5.1) through a TestFilter converter of FME software, wherein the classification method is the same as that of the step S1, and comprises the steps that the igds level name attribute values comprise "traffic lanes", and the igds element id and the igds level name attribute of the model enter a port of the "traffic lanes" to carry out the next processing;
    (5.3) Excel table attribute classification: the Excel reading module of FME software reads modelName, key and Attrieb field attribute values in the Excel table of the result obtained in the step S3, attribute classification is carried out on the modelName attribute values, the classification method is the same as that of the step S1, the method comprises the step S1, the modelName attribute values comprise "traffic lanes", and data enter a "traffic lane" port for further processing;
    (5.4) creating a list set: creating a list set for Attrie attribute data under the same classification name in the step (5.3) through a ListBulder converter of FME software, wherein the list set comprises BIM codes, structure layer thicknesses, areas, names, starting point stake numbers, end point stake numbers, belonging roads, stake number segment length attribute values and ModelName under the classification name of a 'traffic lane' and is used as the list set to enter the next step for processing;
    (5.5) matching association: performing matching association processing on the data under the same attribute classification in the step (5.2) and the step (5.4) through a FeatureMerger converter of FME software, wherein a request parameter of the FeatureMerger converter is from an igds level name attribute of the step (5.2), and a Supplier parameter of the FeatureMerger converter is from a data set containing a modelName in the step (5.4); combining the data with the same igds level name attribute value and the same modelName attribute value, wherein the combined result is that a new list set comprises igds element id, modelName and BIM code, structure layer thickness, area, starting point pile number and end point pile number attribute value data under the attribute classification name;
    (5.6) writing into Excel table: writing the list set matched and associated in the step (5.5) into an Excel empty table with the Element ID of the result obtained in the step S1 through an Excel writing module of FME software;
    the attribute classification in the step (5.5) corresponds to the name of the same name of the Excel table obtained in the step (S1), the igds Element ID attribute value of the model is written into the Element ID column of the Excel blank table, and other attribute values of the model comprise BIM codes, thickness of a structural layer, area, starting point pile numbers and end point pile numbers written into columns corresponding to the Excel blank table.
  7. 7. The method for converting JSL-route expert design data into a universal data format according to claim 1, wherein the attribute importing in step S6 means that the DGN model file with the Element ID obtained in step S4 and the Excel table with the Element ID obtained in step S5 are imported in a matching manner by using the ORD software under the Bentley platform, and other attribute values corresponding to the same row of Element ID attribute values in the Excel table are linked to the DGN model corresponding to the Element ID, including BIM code, structure layer thickness, area, start pile number, end pile number attribute, and thus the DGN data file with the attribute values is obtained.
CN202210977937.9A 2022-08-16 2022-08-16 Method for converting JSL-route expert design data into universal data format Active CN115292791B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210977937.9A CN115292791B (en) 2022-08-16 2022-08-16 Method for converting JSL-route expert design data into universal data format

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210977937.9A CN115292791B (en) 2022-08-16 2022-08-16 Method for converting JSL-route expert design data into universal data format

Publications (2)

Publication Number Publication Date
CN115292791A CN115292791A (en) 2022-11-04
CN115292791B true CN115292791B (en) 2023-04-28

Family

ID=83830981

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210977937.9A Active CN115292791B (en) 2022-08-16 2022-08-16 Method for converting JSL-route expert design data into universal data format

Country Status (1)

Country Link
CN (1) CN115292791B (en)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116778084A (en) * 2023-06-21 2023-09-19 湖南省交通规划勘察设计院有限公司 Three-dimensional model determining method and system
CN117556507B (en) * 2023-11-20 2024-06-11 中交第二公路勘察设计研究院有限公司 Modulus combining method based on fbx format modulus-first and modulus-last

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113221297A (en) * 2021-03-29 2021-08-06 湘潭大学 Method for converting power grid information model into FBX three-dimensional model and storing attributes

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20140181145A1 (en) * 2012-12-26 2014-06-26 Jafer S. KAMSAMOHIDEEN Modular Software System for Use in an Integration Software Technology and Method of Use
KR101885089B1 (en) * 2017-01-26 2018-08-03 홍익대학교세종캠퍼스산학협력단 Excel export method for bim design files
WO2018161460A1 (en) * 2017-03-07 2018-09-13 The Earth Solutions Limited Land survey data management system, method of managing land survey data and site data management system (sdms)
CN107273543B (en) * 2017-07-06 2020-06-05 安徽省交通规划设计研究总院股份有限公司 DGN data format conversion method
CN110516383A (en) * 2019-08-30 2019-11-29 兰州深蓝图形技术有限公司 A kind of parsing of railway signals equipment vector graphics file, display methods and device
CN113656493A (en) * 2021-07-23 2021-11-16 贵州图智信息技术有限公司 Method and system for constructing digital twin city multi-bank fusion

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113221297A (en) * 2021-03-29 2021-08-06 湘潭大学 Method for converting power grid information model into FBX three-dimensional model and storing attributes

Also Published As

Publication number Publication date
CN115292791A (en) 2022-11-04

Similar Documents

Publication Publication Date Title
CN115292791B (en) Method for converting JSL-route expert design data into universal data format
CN110222445B (en) BIM and design information based integration, collaborative design and delivery method and system
CN101477549B (en) Knowledge base supported spatial database design method and system
US8577652B2 (en) Spreadsheet-based graphical user interface for dynamic system modeling and simulation
Fuchs et al. Formal description of a generic multi-model
CN101430714B (en) Content structuring process method and system based on model
CN104881762A (en) Engineering quantity list decomposition method and system
CN108133053A (en) A kind of method of CityGML based on RDF frames and IFC class formation Semantic mapping ontologies
Zhu et al. Web-based construction document processing via malleable frame
CN112685382B (en) BIM + GIS-based highway engineering quantity table extraction, classification and reconstruction method and system
CN102270137A (en) Method for acquiring ADL (architecture description language) and modeling tool
CN105260300B (en) Service test method based on accounting standard universal classification standard application platform
CN114757661B (en) Automatic refining method and system of BIM (building information modeling) model, electronic equipment and medium
CN104748757B (en) A kind of data in navigation electronic map update method and device
Choi et al. An approach to share architectural drawing information and document information for automated code checking system
Ismail et al. Semantic enrichment and multimodel data exchange approach for CFD analysis of bridges
Lai et al. Exchange requirement-based delivery method of structural design information for collaborative design using industry foundation classes
Halfawy et al. Developing enterprise GIS-based data repositories for municipal infrastructure asset management
CN113887171A (en) Measuring point code standardization automatic conversion method for wind power generation system
CN114611187A (en) BIM technology-based parameterized pile foundation model construction method
CN114924983A (en) Method for converting Xmind test case into Zen channel case
CN111062082B (en) Shear wall structural design system based on integrated template installation
JP4220573B2 (en) Railway signal system database verification method
CN114297766A (en) Engineering structure three-view joint design method based on AutoCAD and DotNET
Nour Using Bounding Volumes for BIM based electronic code checking for Buildings in Egypt

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant