CN115292791A - Method for converting JSL-route expert design data into general data format - Google Patents

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

Info

Publication number
CN115292791A
CN115292791A CN202210977937.9A CN202210977937A CN115292791A CN 115292791 A CN115292791 A CN 115292791A CN 202210977937 A CN202210977937 A CN 202210977937A CN 115292791 A CN115292791 A CN 115292791A
Authority
CN
China
Prior art keywords
attribute
model
data
file
name
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.)
Granted
Application number
CN202210977937.9A
Other languages
Chinese (zh)
Other versions
CN115292791B (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 general 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 firstly carrying out deep analysis on the BIM attribute file; s2: carrying out model analysis and format conversion operation on an FBX model file in JSL-route expert design result data; s3: performing attribute analysis on the BIM attribute file; s4: carrying out model format conversion on the DWG model file of the result obtained in the step S2; s5: carrying out 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 (4) performing attribute import operation on the Excel attribute data table obtained from the step (5) and the DGN model file obtained from the step (4) to obtain a DGN data file with attribute information. The invention realizes the lossless conversion of JSL-route expert design result data to DGN data and achieves the purpose of cross-platform transmission of the building information model.

Description

Method for converting JSL-route expert design data into general data format
Technical Field
The invention relates to the field of cross-platform data transmission of a Building Information Model (BIM), in particular to a method for converting JSL-route expert design data into a general data format.
Background
The JSL-route expert system is road design software developed by second highway reconnaissance design research institute limited company, completely covers all layers of municipal road design and highway design, can effectively assist designers to carry out design work such as roads, bridges and the like, has the advantages of being simple to operate, easy to master and learn and the like, and is used by vast road designers. The DGN file format is a data format developed by the pentley (Bentley) engineering software systems limited company, and is a general data format that is widely applied in the field of engineering design, and the DGN file includes not only geometric information of a model but also information such as codes, colors, materials, and customized engineering attributes.
With the deep application of Building Information Models (BIM), how designed information models can be integrated and used on various platforms becomes a key issue. At present, the mainstream BIM platform supports a DGN universal data format well, and the DGN universal data format is generally required to be provided for delivering model geometric 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 loss becomes an increasingly outstanding problem when entering a mainstream platform. Although the mode of importing the DWG or FBX model supported by the Bentley software system can 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 initial pile numbers, design materials and the like, cannot be imported.
Therefore, a method for converting JSL-route expert design data into a general data format is provided for solving the problems.
Disclosure of Invention
In order to solve the above problems, the present invention provides a method for converting JSL-route expert design data into a general data format, which realizes lossless conversion of JSL-route expert design result data (model and attribute information) into DGN data, and achieves the purpose of cross-platform transmission of a building information model.
In order to achieve the purpose, the technical scheme adopted by the invention is as follows: a method for converting JSL-route expert design data into a general data format comprises the following steps:
s1: outputting an FBX model file and a BIM attribute file from JSL-route expert design software, firstly carrying out deep analysis on the BIM attribute file, extracting attribute classifications and related attribute fields in the BIM attribute file, and establishing a plurality of Excel empty tables corresponding to attribute classification names, wherein the Excel empty tables comprise Element IDs and the attribute fields;
s2: carrying out 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 a model name and attribute data in the BIM attribute file, and converting the model name and the attribute data into an Excel table to obtain the Excel table with the model name and the attribute data;
s4: carrying out model format conversion on the DWG model file obtained by the step S2 to obtain a DGN model file with Element ID;
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, writing the result into the Excel empty table of the result obtained in the step S1, and obtaining an Excel table with Element ID and attribute data;
s6: and (5) performing attribute import operation on the Excel attribute data table obtained from the step (5) and the DGN model file obtained from 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 attribute information.
Preferably, the attribute classification, the attribute field extraction, and the establishment of the Excel empty table in step S1 specifically include:
(1.1) attribute classification: the BIM attribute file stores attribute information of the model by adopting 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 part, an excavation part, a drainage ditch, a bridge and the like;
(1.2) attribute field extraction: analyzing specific attribute fields under the attribute classification in the step (1.1), wherein the attribute fields under the traffic lane classification comprise BIM codes, structural layer thicknesses, areas, names, starting point pile numbers, end point pile numbers, roads to which the starting point pile numbers belong, pile number segment lengths and the like;
(1.3) establishing an Excel empty table: respectively establishing a working table in Excel according to the attribute classification obtained by analyzing in the step (1.1), wherein the working table name is an attribute classification name, establishing a working table header under the corresponding working table name according to the attribute field obtained by analyzing in the step (1.2), wherein the working table header name is an attribute field under each attribute classification, and inserting an Element ID field into a first column.
Preferably, the FBX model parsing and model format conversion in step S2 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 component model by using a Deaggregator converter, analyzing the hierarchical relationship and the name of the model, and extracting the name of the model by using a GeometryPropertyExtractor converter;
(2.2) model format conversion: and (3) converting each component model decomposed in the step (2.1) into a three-dimensional grid, storing the Name of each extracted component model into the Layer Name 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, the BIM attribute analysis and attribute data conversion in step S3 specifically include:
(3.1) BIM attribute analysis: the BIM attribute file stores the 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, extracts the attribute values of modelName, key2 and Attribute fields in the BIM attribute file, and the modelName attribute values correspond to the model names in the FBX model file extracted in the step S2 one by one;
(3.2) attribute data conversion: and (4) writing the modelName, key2 and Attrib 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 step S4 is to convert the DWG model file obtained in step S2 into the DGN format through an ORD (OpenRoads Designer) software under the Bentley platform, so that 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 given a unique Element ID by the ORD software, so as to obtain a DGN model file with an Element ID and Level name attribute information.
Preferably, the matching process of the model and the attribute data in the step S5 is to expose the attribute information in the DGN model file of the result obtained in the step S4 and classify the attribute; carrying out attribute classification on the Excel table of the result obtained in the step S3 and creating a list set; matching and associating the attribute information in the DGN model file of the result obtained in the step S4 with the attribute information in the Excel table of the result obtained in the step S3 through the model name, and finally writing the attribute information into the Excel empty table in the step S1; the method specifically comprises the following steps:
(5.1) DGN model file attribute exposure: reading the DGN model file of the result obtained in the step S4 through a DGN reading module of FME software, exposing igds Element ID, igds Level name and igds type format attributes, 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 entering the next step of flow processing for the igds type of igds _ mesh;
(5.2) DGN model file attribute classification: performing attribute classification on 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 the step S1, and if the igds level name attribute values comprise a 'lane', the igds element id and the igds level name attribute of the model enter a 'lane' port for next-step processing;
(5.3) Excel table attribute classification: reading the attribute values of the modeName, key2 and Attribute in the Excel table of the result obtained in the step S3 through an Excel reading module of FME software, and performing attribute classification on the modeName attribute values, wherein the classification method is the same as that in the step S1, and if the modeName attribute values comprise a 'carriageway', the data enters a 'carriageway' port for next-step processing;
(5.4) creating a list set: creating a list set for Attrib attribute data under the same classification name in the step (5.3) through a ListBuilder converter of FME software, and enabling attribute values such as BIM codes, structural layer thicknesses, areas, names, starting point pile numbers, end point pile numbers, roads to which the building blocks belong, pile number segment lengths and modelName under the classification name of a 'lane' to be used as the list set to enter the next step of processing;
(5.5) matching and associating: 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 Requester parameter of the FeatureMerger converter is from the igds level name attribute in the step (5.2), and a supervisor parameter of the FeatureMerger converter is from the data set containing the modeName in the step (5.4); merging the data with the same igds level name attribute value and modelName attribute value, wherein the merging result is that a new list set comprises attribute value data such as an igds element id, a modelName, a BIM code under an attribute classification name, a structure layer thickness, an area, a starting point pile number, an end point pile number and the like;
(5.6) write Excel table: writing the list set matched and associated in the step (5.5) into an Excel empty table with Element ID of the result obtained in the step S1 through an Excel writing module of FME software;
wherein, the attribute classification in the step (5.5) corresponds to the same name table name of the Excel table obtained in the step S1, the igds Element ID attribute value of the model is written into an Element ID column of the Excel empty table, and other attribute values of the model such as BIM code, structural layer thickness, area, starting point pile number, end point pile number and the like are written into a column corresponding to the Excel empty table.
Preferably, the attribute import in step S6 is to perform matching import on the DGN model file with Element ID obtained in step S4 and the Excel table with Element ID obtained in step S5 through the ORD software under the Bentley platform, and link other attribute values, such as BIM code, structural layer thickness, area, start point stake number, end point stake number and the like, in the same row corresponding to the Element ID attribute value in the Excel table on the DGN model corresponding to the Element ID to obtain a DGN data file with attribute values.
In the above specific steps, steps S2, S3 and step S5 are key, steps S2 and S3 are decomposition of JSL-route expert design result data, and step S5 is a process of re-matching the decomposed model and attribute information and attaching the Element ID attribute of the decomposed model, so that the model and attribute information can be smoothly written into the DGN data file with the result of step S5. The steps solve the technical problem that the model geometric information and the attribute information in the JSL-route expert design result data cannot be converted into the DGN data file together at present, and the difficulty is that the storage formats of different software are different. The method solves the technical problems, realizes the lossless conversion of JSL-route expert design result data to a general format DGN data format, and reserves 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 introducing JSL-route expert design result data into ORD software, attribute information cannot be converted, and the attribute information needs to be manually input into the ORD software at a later stage.
Compared with the prior art, the method realizes the automatic model decomposition and the automatic attribute conversion Excel table through the FME software in the steps S2 and S3, realizes the operations of automatic model and attribute matching, automatic Excel table writing and the like 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.
In the method for converting JSL-route expert design data into the general data format, the FBX model file and the BIM attribute file of the JSL-route expert design result data are analyzed, and a proper conversion module and a proper processing flow are researched and constructed based on the FME software of the spatial data conversion tool, so that the lossless conversion of the JSL-route expert design result data into DGN data is realized, and the 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 exchange barrier between JSL-route expert data and DGN data at present, and achieves the purpose of cross-platform transmission of the building information model. The processing process of the method is not approximate, and the method can be used in the application fields of three-dimensional design, visualization, management and the like of a road model, and effectively improves the exchange and information sharing efficiency of JSL-route expert design results.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings required to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the description below are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flow chart of a method for converting JSL-route expert design data into a general data format according to the invention;
FIG. 2 is a flow chart of FBX model parsing format conversion;
FIG. 3 is a flow chart of model and attribute data matching processing;
FIG. 4 is a model and attribute information interface diagram in JSL-route expert design software;
fig. 5 is an interface diagram of the model and attribute information in the DGN format after the ORD software opens the conversion.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments.
The method for converting JSL-route expert design data into a general data format according to the invention is explained in detail according to the steps shown in figure 1.
Step S1: outputting an FBX model file and a BIM attribute file in JSL-route expert design software, firstly carrying out deep analysis on the BIM attribute file, extracting attribute classification and related attribute fields in the BIM attribute file, and establishing an Excel empty table containing the 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 attribute information, wherein the attribute classification comprises a traffic lane, a hard road shoulder, a soil road shoulder, a filling part, an excavation part, a drainage ditch, a bridge and the like;
(1.2) attribute field extraction: analyzing specific attribute fields under the attribute classification in the step (1.1), wherein the attribute fields under the traffic lane classification comprise BIM codes, structural layer thicknesses, areas, names, starting point stake numbers, end point stake numbers, roads to which the stake numbers belong, stake number section lengths and the like; the attribute fields under the classification of the soil shoulder comprise BIM codes, areas, names, starting point pile numbers, end point pile numbers, roads to which the soil shoulder belongs, pile number segment lengths and the like; the attribute fields under the bridge classification comprise BIM codes, names, starting point pile numbers, end point pile numbers, roads to which the attribute fields belong, bridge span data, bridge framing and the like;
(1.3) establishing an Excel empty table: respectively establishing a working table in Excel according to the attribute classification obtained by analyzing in the step (1.1), wherein the working table name is an attribute classification name, establishing a working table header under the corresponding working table name according to the attribute field obtained by analyzing in the step (1.2), wherein the working table header name is an attribute field under each attribute classification, and inserting an Element ID field into a first column. The attribute field for attribute classification as lane is shown in table 1, and the attribute field for attribute classification as shoulder is shown in table 2.
TABLE 1 Attribute Classification of Attribute as Attribute fields for traffic lanes
Figure 433636DEST_PATH_IMAGE002
Table 2 attribute field for attribute classification as dirt shoulder
Figure 255836DEST_PATH_IMAGE004
Step S2: and carrying out model analysis, format conversion and other operations 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 the 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 component model by using a Deaggregator converter, analyzing the hierarchical relationship and the name of the model, and extracting the name of the model by using a GeometryPropertyExtractor converter;
(2.2) model format conversion: converting each component model decomposed in the step (2.1) into a three-dimensional grid, storing each extracted component model Name to the 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.
And step S3: and (3) carrying out attribute analysis on the BIM attribute file in the JSL-route expert design result data, extracting the model name and the attribute data in the BIM attribute file and converting the model name and the attribute data into an Excel table to obtain the Excel table with the model name and the attribute data. The method comprises the following specific steps:
(3.1) BIM attribute analysis: 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 attributes, extracts the modelName, key2 and Attrib field attribute values, and the modelName attribute values correspond to the model names in the FBX model file extracted in the step S2 one by one;
(3.2) attribute data conversion: and (3) writing the modelName, key2 and 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, wherein the result is shown in Table 3.
TABLE 3 data sheet after BIM Attribute File parsing
Figure 504415DEST_PATH_IMAGE006
And step S4: and D, carrying out 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 a Bentley platform, and then the DWG model file is stored in a DGN format. Layer information in the DWG model file is reserved and is represented as a Level name attribute in the DGN file, and any model Element entering 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 (4) carrying out 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), writing the result into the Excel empty table of the result obtained in the step (S1), and obtaining 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: reading the DGN model file of the result obtained in the step S4 through a DGN reading module of FME software, exposing igds Element ID, igds Level name and igds type format attributes, 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 entering the next step of flow processing for the igds type of igds _ mesh;
(5.2) DGN model file attribute classification: performing attribute classification on 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 the step S1, and if the igds level name attribute values comprise a 'lane', the igds element id and the igds level name attribute of the model enter a 'lane' port for next-step processing;
(5.3) classifying Excel table attributes: reading the attribute values of the modeName, key2 and Attribute in the Excel table of the result obtained in the step S3 through an Excel reading module of FME software, and performing attribute classification on the modeName attribute values, wherein the classification method is the same as that in the step S1, and if the modeName attribute values comprise a 'carriageway', the data enters a 'carriageway' port for next-step processing;
(5.4) creating list set: creating a list set for Attrib attribute data under the same classification name in the step (5.3) through a ListBuilder converter of FME software, and enabling attribute values such as BIM codes, structural layer thicknesses, areas, names, starting point pile numbers, end point pile numbers, roads to which the building blocks belong, pile number segment lengths and modelName under the classification name of a 'lane' to be used as the list set to enter the next step of processing;
(5.5) matching and associating: and (5) 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 Requester parameter of the FeatureMerger converter is from the igds level name attribute in the step (5.2), and a supervisor parameter of the FeatureMerger converter is from the data set containing the modelName in the step (5.4). Therefore, data with the same igds level name attribute value and modelName attribute value are merged, and a new list set comprises attribute value data such as an igds element id, a modelName, a BIM code under an attribute classification name, a structure layer thickness, an area, a starting point pile number, an end point pile number and the like as a result of merging;
(5.6) write Excel table: and (4) writing the list set matched and associated in the step (5.5) into an Excel empty table with 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 same name table name of the Excel table obtained in the step S1, the igds Element ID attribute value of the model is written into an Element ID column of the Excel empty table, other attribute values of the model such as BIM codes, structural layer thicknesses, areas, starting point pile numbers, end point pile numbers and the like are written into a column corresponding to the Excel empty table, the attribute data table (part) with the attribute classified as the traffic lane is shown in the table 4, and the attribute data table (part) with the attribute classified as the soil shoulder is shown in the table 5.
Table 4 attribute data table (section) for attribute classification into traffic lane
Figure 509411DEST_PATH_IMAGE008
Table 5 attribute data table (part) for classifying attributes as dirt shoulder
Figure 792625DEST_PATH_IMAGE010
Step S6: and (5) performing attribute import 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 attribute of the model according to the Element ID to obtain the DGN data file with attribute information. The method mainly comprises the steps that 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 are matched and imported through ORD software under a Bentley platform, other attribute values such as BIM codes, structural layer thicknesses, areas, starting point pile numbers, end point pile numbers and the like on the same line of the corresponding Element ID attribute values in the Excel table can be connected to the DGN model corresponding to the Element ID, and the DGN data file with the attribute values is obtained.
Therefore, the JSL-route expert design result data is converted into DGN data in a lossless mode as shown in figure 4, and the complete model geometric information and attribute information of the DGN data are reserved as shown in figure 5.
The above description is only an embodiment of the present invention, and the scope of the present invention is not limited thereto, and any person skilled in the art can understand that the modifications or substitutions should be included in the scope of the present invention disclosed in the present invention, so the scope of the present invention should be subject to the protection scope of the claims.

Claims (7)

  1. A method for converting JSL-route expert design data into a general data format is characterized by comprising the following steps:
    s1: outputting an FBX model file and a BIM attribute file from JSL-route expert design software, performing in-depth analysis on the BIM attribute file, extracting attribute classifications and related attribute fields in the BIM attribute file, and establishing a plurality of Excel empty tables corresponding to attribute classification names, wherein the Excel empty tables comprise Element IDs and attribute fields;
    s2: carrying out 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 a model name and attribute data in the BIM attribute file, and converting the model name and the attribute data into an Excel table to obtain the Excel table with the model name and the attribute data;
    s4: carrying out model format conversion on the DWG model file obtained by the step S2 to obtain a DGN model file with Element ID;
    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, writing the result into the Excel empty table of the result obtained in the step S1, and obtaining the Excel table with Element ID and attribute data;
    s6: and (5) performing attribute import operation on the Excel attribute data table obtained from the step (5) and the DGN model file obtained from 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 attribute information.
  2. 2. The method for converting JSL-route expert design data into a generic data format according to claim 1, wherein the attribute classification, the attribute field extraction, and the establishment of the Excel empty table in step S1 specifically include:
    (1.1) attribute classification: the BIM attribute file stores attribute information of the model in an XML format, and analyzes attribute classification of the model, wherein the attribute classification comprises a traffic lane, a hard road shoulder, a soil road shoulder, a filling part, an excavation part, a drainage ditch and a bridge;
    (1.2) attribute field extraction: analyzing specific attribute fields under the attribute classification in the step (1.1), wherein the attribute fields under the traffic lane classification comprise BIM codes, structural layer thicknesses, areas, names, starting point pile numbers, end point pile numbers, roads to which the starting point pile numbers belong and pile number section lengths;
    (1.3) establishing an Excel empty table: and (2) 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 the 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 the attribute field under each attribute classification, and inserting the Element ID field into the first column.
  3. 3. The method for converting JSL-route expert design data into a generic data format according to claim 1, wherein the FBX model parsing and the model format conversion in the step S2 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 Deaggregator converter, analyzing the hierarchical relationship and the name of the model, and extracting the name of the model by using a GeometryPropertyExtractor converter;
    (2.2) model format conversion: and (3) converting each component model decomposed in the step (2.1) into a three-dimensional grid, storing the Name of each extracted component model into the Layer Name 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-route expert design data into a generic data format according to claim 1, wherein the BIM attribute parsing and attribute data conversion in the step S3 specifically includes:
    (3.1) BIM attribute analysis: the BIM attribute file stores the 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 attributes, extracts the modelName, key2 and Attrib field attribute values, and the modelName attribute values correspond to the model names in the FBX model file extracted in the step S2 one by one;
    (3.2) attribute data conversion: and (4) writing the modelName, key2 and 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 general data format according to claim 1, wherein the model format conversion in the step S4 is to convert the DWG model file obtained in the step S2 into a DGN format through ORD software under a Bentley platform, layer information in the DWG model file is reserved, the DGN file is represented as a Level name attribute, 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.
  6. 6. The method for converting JSL-route expert design data into a generic data format according to claim 1, wherein the model and attribute data matching processing in the step S5 is to expose and classify attribute information in a DGN model file of the result obtained in the step S4; classifying the attributes of the Excel table of the result obtained in the step S3 and creating a list set; matching and associating the attribute information in the DGN model file of the result obtained in the step S4 with the attribute information in the Excel table of the result obtained in the step S3 through the model name, and finally writing the attribute information into the Excel empty table in the step S1; the method specifically comprises the following steps:
    (5.1) DGN model file attribute exposure: reading the DGN model file of the result obtained in the step S4 through a DGN reading module of FME software, exposing igds Element ID, igds Level name and igds type format attributes, 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 entering the next step of flow processing for the igds type of igds _ mesh;
    (5.2) DGN model file attribute classification: performing attribute classification on 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 the step S1, and if the igds level name attribute values comprise a 'lane', the igds element id and the igds level name attribute of the model enter a 'lane' port for next-step processing;
    (5.3) Excel table attribute classification: reading the attribute values of the modeName, key2 and Attribute in the Excel table of the result obtained in the step S3 through an Excel reading module of FME software, and performing attribute classification on the modeName attribute values, wherein the classification method is the same as that in the step S1, and if the modeName attribute values comprise a 'carriageway', the data enters a 'carriageway' port for next-step processing;
    (5.4) creating list set: creating a list set for Attrib attribute data under the same classification name in the step (5.3) through a ListBuilder converter of FME software, and enabling the list set and modelName to be used as the list set to enter the next step of processing, wherein the list Builder converter is used for creating the list set for Attrib attribute data under the same classification name in the step (5.3), such as BIM codes, structural layer thicknesses, areas, names, starting point pile numbers, ending point pile numbers, roads to which the building blocks belong, pile number segment length attribute values and modelName under the classification name of 'carriageways';
    (5.5) matching and associating: 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 requester parameter of the FeatureMerger converter is from the igds level name attribute in the step (5.2), and a supervisor parameter of the FeatureMerger converter is from the data set containing the modelName in the step (5.4); merging the data with the same igds level name attribute value and modelName attribute value, wherein the merging result is that a new list set comprises the attribute value data of the igds element id, the modelName, the BIM code under the attribute classification name, the thickness of the structural layer, the area, the pile number of the starting point and the pile number of the terminal point;
    (5.6) write Excel table: writing the list set matched and associated in the step (5.5) into an Excel empty table with Element ID of the result obtained in the step S1 through an Excel writing module of FME software;
    wherein, the attribute classification in the step (5.5) corresponds to the same name table name of the Excel table obtained in the step S1, the igds Element ID attribute value of the model is written into an Element ID column of the Excel empty table, and other attribute values of the model such as BIM code, structural layer thickness, area, starting point pile number and end point pile number are written into a corresponding column of the Excel empty table.
  7. 7. The method for converting JSL-route expert design data into a universal data format according to claim 1, wherein the attribute import in the step S6 is to match and import 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 other attribute values such as BIM codes, structural layer thicknesses, areas, starting point stake numbers and ending point stake number attributes in the Excel table corresponding to the Element ID attribute values on the DGN model corresponding to the Element ID are linked to obtain the DGN data file with the attribute values.
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 true CN115292791A (en) 2022-11-04
CN115292791B 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)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117556507A (en) * 2023-11-20 2024-02-13 中交第二公路勘察设计研究院有限公司 Modulus combining method based on fbx format modulus-first and modulus-last

Citations (7)

* 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
CN107273543A (en) * 2017-07-06 2017-10-20 安徽省交通规划设计研究总院股份有限公司 A kind of conversion method of DGN data formats
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)
CN110516383A (en) * 2019-08-30 2019-11-29 兰州深蓝图形技术有限公司 A kind of parsing of railway signals equipment vector graphics file, display methods and device
CN113221297A (en) * 2021-03-29 2021-08-06 湘潭大学 Method for converting power grid information model into FBX three-dimensional model and storing attributes
CN113656493A (en) * 2021-07-23 2021-11-16 贵州图智信息技术有限公司 Method and system for constructing digital twin city multi-bank fusion

Patent Citations (7)

* 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)
CN107273543A (en) * 2017-07-06 2017-10-20 安徽省交通规划设计研究总院股份有限公司 A kind of conversion method of DGN data formats
CN110516383A (en) * 2019-08-30 2019-11-29 兰州深蓝图形技术有限公司 A kind of parsing of railway signals equipment vector graphics file, display methods and device
CN113221297A (en) * 2021-03-29 2021-08-06 湘潭大学 Method for converting power grid information model into FBX three-dimensional model and storing attributes
CN113656493A (en) * 2021-07-23 2021-11-16 贵州图智信息技术有限公司 Method and system for constructing digital twin city multi-bank fusion

Non-Patent Citations (5)

* Cited by examiner, † Cited by third party
Title
ABDUL-QUAYYUM GBADAMOSI等: "Big data for Design Options Repository: Towards a DFMA approach for offsite construction" *
王晶，郑亮: "多种测图软件数据的无损传递方法" *
闻平;王冲;吴小东;桂林;: "FBX三维模型自动转换为OBJ三维模型方法研究" *
陈辰等: "面向输变电工程三维设计模型整合研究" *
韩雪培;赵杰;: "数据格式转换中空间参考的变异性分析" *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117556507A (en) * 2023-11-20 2024-02-13 中交第二公路勘察设计研究院有限公司 Modulus combining method based on fbx format modulus-first and modulus-last
CN117556507B (en) * 2023-11-20 2024-06-11 中交第二公路勘察设计研究院有限公司 Modulus combining method based on fbx format modulus-first and modulus-last

Also Published As

Publication number Publication date
CN115292791B (en) 2023-04-28

Similar Documents

Publication Publication Date Title
Lu et al. Semi-automatic geometric digital twinning for existing buildings based on images and CAD drawings
CN110222445B (en) BIM and design information based integration, collaborative design and delivery method and system
Ansah et al. A review and outlook for integrated BIM application in green building assessment
US20230274045A1 (en) Building information modeling (bim)-based intelligent drafting method for prefabricated buildings
CN112685804B (en) Highway engineering design information-based WBS automatic construction method and system
CN106951432A (en) BIM data light weight method and device
CN101477549B (en) Knowledge base supported spatial database design method and system
Fuchs et al. Formal description of a generic multi-model
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
CN102693317A (en) Method and device for data mining process generating
CN112685382B (en) BIM + GIS-based highway engineering quantity table extraction, classification and reconstruction method and system
CN104978411A (en) Train model development method and apparatus for high-speed train
CN115292791A (en) Method for converting JSL-route expert design data into general data format
CN101916267A (en) Intelligent spatial data object modeling method applied to management of spatial data resource of road system
Choi et al. An approach to share architectural drawing information and document information for automated code checking system
Alvarado et al. Multilevel modeling of geographic information systems based on international standards
CN116719898B (en) Geographic entity generation method and system based on multi-source heterogeneous data
WO2002097727A1 (en) Automatic knowledge creating method, automatic knowledge creating system, automatic knowledge creating program, automatic designing method and automatic designing system
Du et al. Ontology-Based Information Integration and Decision Making in Prefabricated Construction Component Supply Chain.
CN117076463A (en) Multi-source data aggregation storage system for smart city
Do et al. Object-oriented software design with axiomatic design
CN115827885A (en) Operation and maintenance knowledge graph construction method and device and electronic equipment
CN114297766A (en) Engineering structure three-view joint design method based on AutoCAD and DotNET
CN111291444B (en) Modeling method, device, equipment and storage medium for aircraft assembly

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