CN114155341B - Cross-platform consistency method for large-scale digital workshop three-dimensional model based on Unity platform - Google Patents

Cross-platform consistency method for large-scale digital workshop three-dimensional model based on Unity platform Download PDF

Info

Publication number
CN114155341B
CN114155341B CN202111287290.9A CN202111287290A CN114155341B CN 114155341 B CN114155341 B CN 114155341B CN 202111287290 A CN202111287290 A CN 202111287290A CN 114155341 B CN114155341 B CN 114155341B
Authority
CN
China
Prior art keywords
model
revit
mapping relation
platform
relation table
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
CN202111287290.9A
Other languages
Chinese (zh)
Other versions
CN114155341A (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.)
China Tobacco Hubei Industrial LLC
Original Assignee
China Tobacco Hubei Industrial LLC
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 China Tobacco Hubei Industrial LLC filed Critical China Tobacco Hubei Industrial LLC
Priority to CN202111287290.9A priority Critical patent/CN114155341B/en
Publication of CN114155341A publication Critical patent/CN114155341A/en
Application granted granted Critical
Publication of CN114155341B publication Critical patent/CN114155341B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06TIMAGE DATA PROCESSING OR GENERATION, IN GENERAL
    • G06T17/00Three dimensional [3D] modelling, e.g. data description of 3D objects
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Landscapes

  • Physics & Mathematics (AREA)
  • Engineering & Computer Science (AREA)
  • Computer Graphics (AREA)
  • Geometry (AREA)
  • Software Systems (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Processing Or Creating Images (AREA)

Abstract

The invention discloses a method for cross-platform consistency of a large-scale digital workshop three-dimensional model based on a Unity platform, which is used for exporting a file in nwc format on a Revit platform; opening the exported file in nwc format and exporting the file in fbx format at Naviswork platform; importing the fbx file into a Unity platform, and establishing a Revit model and material ball mapping relation table and a Revit model structure information mapping relation table; exporting the fbx file on a Revit platform, and exporting data to a database through ODBC; importing the fbx file into a Unity platform, and establishing a Revit model data mapping relation table; replacing the Revit model according to the Revit model structure information mapping relation table; according to the Revit model and the material ball mapping relation table, replacing the material ball; optimizing the hierarchical structure of the model according to the Revit model data mapping relation table, and dividing the model into the belonging elevation, family and type; and establishing a corresponding relation between the model and the data according to the unique ID of the model and the derived database. The invention solves the problems of the integrity of the data importing of the three-dimensional model and the consistency of the model data.

Description

Cross-platform consistency method for large-scale digital workshop three-dimensional model based on Unity platform
Technical Field
The invention belongs to the technical field of digital workshop operation and maintenance management based on a three-dimensional model, relates to a large-scale digital workshop three-dimensional model cross-platform consistency method, and in particular relates to a large-scale digital workshop three-dimensional model cross-platform consistency method based on a Unity platform.
Background
With the increasing application of large-scale digital workshop integral solutions to actual production, three-dimensional models of workshops play different roles in the full life cycle of design, construction, operation and scrapping of workshops, and as professional intelligent system support is often provided at each stage, the three-dimensional models of the whole workshops (including production lines, equipment and environments) can be used as key data in each professional system.
The workshop construction needs to be subjected to various stages such as design, construction, operation and maintenance. In the plant design stage, a designer uses a Revit platform to perform Building Information Modeling (BIM), and the stage establishes all three-dimensional models of the whole plant and also comprises data of a lot of building information. After the factory building construction is completed, the factory building enters into an operation and maintenance stage, and a specific system platform is required to support the operation and maintenance management of the digital workshop based on the three-dimensional model. In order to solve the problem, the invention provides a method for cross-platform consistency of a large-scale digital workshop three-dimensional model, which ensures data communication of three-dimensional model data between a design platform (Revit platform) and a digital workshop operation and maintenance management platform (Unity platform) and keeps the consistency of the data.
Both the Revit platform and the Unity platform support the export and import of model files in the FBX format, so the invention selects the model files in the format as a cross-platform standard. There are two methods for supporting the export of the FBX file through research, but both methods have the problem of data loss. One method is to export the FBX format file through plug-in the Revit platform, but this way the material sphere information of the three-dimensional model is lost. One method derives nwc-formatted files from the Revit platform and derives FBX-formatted files after opening the files at NavisWork platform, but this way some three-dimensional models are lost. Because a large-scale data workshop contains tens of thousands of three-dimensional models and data, the association relationship is complex, and the cross-platform supplementation is not realized no matter the material ball or the model is lost.
Disclosure of Invention
In order to solve the technical problems, the invention provides a method for cross-platform consistency of a large-scale digital workshop three-dimensional model based on a Unity platform.
The technical scheme adopted by the invention is as follows: a cross-platform consistency method of a large-scale digital workshop three-dimensional model based on a Unity platform comprises the following steps:
Step 1: exporting a file in nwc format on a Revit platform;
step 2: opening the file in nwc format exported in the step 1 at Naviswork platform, and exporting the file in fbx format;
Step 3: importing the fbx file into a Unity platform, and establishing a Revit model and material ball mapping relation table and a Revit model structure information mapping relation table;
The Revit model and material ball mapping relation table comprises a single material mapping relation table and a multi-material mapping relation table; the single material mapping relation table takes a family name and a type name as unique identifiers, and establishes a corresponding relation with the material names; the multi-material mapping relation table takes the group name and the type name as unique identifiers, but does not need to establish a relation with material comparison;
The Revit model structure information mapping relation table establishes a mapping relation between the unique key words of elevation, family and type and the Revit model;
step 4: exporting the fbx file on a Revit platform, and exporting data to a database through ODBC;
step 5: importing the fbx file into a Unity platform, and establishing a Revit model data mapping relation table;
The Revit model data mapping relation table establishes a mapping relation between the Revit model ID as a unique keyword and the Revit model data;
step 6: performing Revit model replacement according to the Revit model structure information mapping relation table in the step 3;
Step 7: according to the Revit model and the material ball mapping relation table in the step 3, material ball replacement is carried out;
Step 8: optimizing the hierarchical structure of the model according to the Revit model data mapping relation table established in the step 5, and dividing the model into the belonging elevation, family and type; and (3) establishing a corresponding relation between the model and the data according to the unique model ID and the database derived in the step (4).
According to the method for cross-platform consistency of the large-scale digital workshop three-dimensional model based on the Unity platform, cross-platform model import realized by development of the Unity platform can be combined with the advantages of two import modes, the association relation between the model and the data can be automatically established, the integrity of the large-scale three-dimensional model data import of the digital workshop can be solved, and the model data consistency between a three-dimensional model design platform (Revit) and a digital workshop operation and maintenance management platform (Unity) can be solved.
Drawings
FIG. 1 is a flow chart of an embodiment of the present invention.
Detailed Description
In order to facilitate the understanding and practice of the invention, those of ordinary skill in the art will now make further details with reference to the drawings and examples, it being understood that the examples described herein are for the purpose of illustration and explanation only and are not intended to limit the invention thereto.
The present embodiment will use the following terms:
(1) And (3) a digital workshop: the digital and networked technology is applied to the production workshop comprehensively, and integrates the numerical control equipment with the information of a process design system, a production organization system and other management systems to form an integrated manufacturing system with automatic comprehensive information flow.
(2) Three-dimensional modeling: a digitized representation of characteristic information for a real three-dimensional object formed by a 3D modeling tool.
(3) Data consistency: in different 3D modeling systems, the models express attributes of consistency.
(4) Revit platform: building Information Model (BIM) construction can help building designers to design, build and maintain buildings with better quality and higher energy efficiency. One of the most widely used software in the building industry BIM system in China.
(5) Naviswork platform: the three-dimensional model is integrated with data and information from other software, and is convenient for users to browse, view and manage.
(6) Unity platform: the game development tool is developed by Unity Technologies, so that a developer can easily create multi-platform comprehensive game development tools for types of interactive contents such as three-dimensional games, building visualizations, real-time three-dimensional animations and the like, and is a comprehensive integrated professional game engine.
Referring to fig. 1, the method for cross-platform consistency of a large-scale digital workshop three-dimensional model based on a Unity platform provided by the invention comprises the following steps:
Step 1: exporting a file in nwc format on a Revit platform;
because the Revit platform exports the fbx file of the model, the problem that the model material ball is lost after importing the fbx file into the Unity platform can appear. The large-scale digital workshop has tens of thousands of high-precision model data, and after the material balls are lost, if the mapping relation between the model and the material balls is found again in the Unity platform, the mapping relation is not feasible. If the mapping relation between the model and the material balls is re-associated in 3dmax, the workload is large and the method is not feasible. The Reivt platform was found to provide a way to derive a model of ribbon quality sphere, i.e., a file in the nwc format was derived from the Revit platform.
Step 2: opening the file in nwc format exported in the step 1 at Naviswork platform, and exporting the file in fbx format;
After opening the file in the nwc format in the Naviswork platform, the model's fbx file is exported. When the material balls are imported into the Unity platform, the material balls are not lost. Meanwhile, the structural information of the Revit model is also completely exported, and the structural information of the Revit model comprises elevation, family and type.
Step 3: importing the fbx file into a Unity platform, and establishing a Revit model and material ball mapping relation table and a Revit model structure information mapping relation table;
the Revit model and material sphere mapping relation table of the embodiment comprises a single material mapping relation table and a multi-material mapping relation table; the application of the two tables is different, and the single material mapping relation table is required to realize material replacement according to the comparison relation in the application. However, the multi-material mapping relation table needs to realize the replacement of the model according to the comparison relation in application.
In the single material mapping relation table of the embodiment, a group name and a type name are used as unique identifiers, and a corresponding relation with the material names is established; for example, the group name is a basic wall, the type name is NQ-100m, the material ball name is a wall column, namely, the basic wall and the NQ-100 are used as unique identifiers, and the corresponding relation with the wall column material ball is established.
The multi-material mapping relation table of the embodiment takes the group name and the type name as unique identifications, but does not need to establish a relation with material comparison; for example, the family name is an audible and visual alarm, the type name is an audible and visual alarm, that is, the audible and visual alarm and the audible and visual alarm are unique identifiers, and the model of multiple materials is determined.
There are two ways in which the Revit platform queries the model. One is by model unique ID query, which enables quick localization to the position of the model in the 3D view. The other is that three attributes of the type query the position of the same type model in the 3D view through the family. Based on the data mapping relation of the Revit platform, two model structure information mapping relation tables are required to be established in the Unity platform, one model structure information mapping relation table is in elevation, the family is the unique keyword and model mapping relation, and when the FBX file in the step (3) is imported, the plug-in automatically establishes a comparison relation and stores the comparison relation in a database. One is to use model ID as unique key word and model mapping relation, and this relation is automatically established by plug-in unit and stored in database when the FBX file is imported in step (5).
Although the method can find the mapping relation between the model and the material ball and the structural information of the model, the problem of model loss exists in the application process. Considering that the number shop models are more, it is not feasible to compensate for the lost models in Unity or 3DMax, and in addition, the models that the building designer designs in Revit include data of construction profession, which are missing if the models are designed by Unity or 3 DMax. Research finds that the Revit platform plugin provides a method for exporting the model FBX file, namely exporting the file in the FBX format from the Revit platform. And establishing a mapping relation between the model and the material balls, and establishing a mapping relation of model structure information.
The method comprises the steps of establishing a Revit model structure information mapping relation table, and establishing a mapping relation between a Revit model and a unique keyword which is elevation, family and type; for example, +5.1 is building elevation, walls are database table names, base walls are families, NQ-100m is type, and a mapping relationship is established with the model base wall 77.
Step 4: exporting the fbx file on a Revit platform, and exporting data to a database through ODBC;
In this embodiment, the mapping relationship between the Revit model ID and the building related attribute data is found through the derived database table, as shown in the following figure. For example, the derived data table contains all building related attribute data for the wall model. The wall table contains model ID, type, stage of creation, and building related attributes of volume, area, length, etc.
Step 5: importing the fbx file into a Unity platform, and establishing a Revit model data mapping relation table;
The model is exported through the Revit platform, the fbx file is imported to the Unity platform, and the problem of model loss does not exist. The model name derived at the same time contains family, type, model ID data. The correspondence between the model and the data in the database can be established according to the name of the model. The data building designer designs and builds the basic data of the model, such as the length, width, height, radius, material, model, maintenance period, qualification certificate, manufacturer and other information, which are recorded in the construction process. The information is necessary data for realizing design, construction, operation and maintenance and scrapping full life cycle management, and the operation and maintenance system is required to be synchronized with a digital workshop in a Revit system. The system can dynamically bind data according to the unique ID of the model, and can realize the data synchronization of two systems and the latest data bound by the model if the data is updated in any one of the Revit system or the digital workshop operation and maintenance system.
The Revit model data mapping relation table of the embodiment establishes a mapping relation between the Revit model ID as a unique keyword and the Revit model data; the model imported in this embodiment has a model unique ID, which is an association relationship between the model and the data. For example: the model is a basic wall NQ-200mm [8683740] where the basic wall represents a family, NQ-200mm represents a type, 8683740 is a model ID. The basic wall of the family can be inquired through the Revit model structure information mapping relation table in the step 3, the type is NQ-200mm, the table name of the corresponding database is a wall, and the model ID 8683740 is used for searching the building data related to the model in the wall table of the database; in this way, a Revit model and data mapping relation is established.
Step 6: performing Revit model replacement according to the Revit model structure information mapping relation table in the step 3;
Step 7: according to the Revit model and the material ball mapping relation table in the step 3, material ball replacement is carried out;
Step 8: optimizing the hierarchical structure of the model according to the Revit model data mapping relation table established in the step 5, and dividing the model into the belonging elevation, family and type; and (3) establishing a corresponding relation between the model and the data according to the unique model ID and the database derived in the step (4).
The method of the embodiment can be made into a Unity plugin and automatically generate a model.
1. Models under the same family and type in the Revit platform are the same, and model object relations are established according to the Revit model structure information mapping relation table in the step 3 and combining with Prefab object characteristics in the Unity platform. And establishing a corresponding relation between the unique keywords and the Unity platform Prefab objects through the family and the type. After the model is imported, the Unity plugin can automatically create Prefab objects according to the family and the category to which the model belongs, and establish a mapping relation and store the mapping relation in a database.
2. And (3) according to the Revit model and material ball mapping relation table in the step (3). The Unity plugin can automatically derive two models and a material sphere mapping relation table, wherein one model is a single material mapping relation table, and the other model is a multi-material mapping relation table. The application of the two tables is different, and the single material mapping relation table is required to realize material replacement according to the comparison relation in the application. However, the multi-material mapping relation table needs to realize the replacement of the model according to the comparison relation in application.
3. The model material balls derived according to the step 4 are lost, and the mesh of the multi-material model is merged. Because the mesh is merged, the modeling is needed to be remodelled in max to map the model, and the workload is huge after the mesh is segmented. Studies have found that by way of these two derived models, the Revit derives the model forward in the Z-axis, naviswork derives the model forward in the Z-axis, the Rotation of the model differs by 90 degrees, but the scaling is uniform, due to the different specifications of the computing coordinate systems of the different three-dimensional platforms. The system develops a Unity plugin to automatically analyze a model to be replaced, acquires position. Xyz, rotation. Xyz and scale. Xyz of the model, finds a corresponding Prefab according to the name of the model, instantiates an object by using the position. Xyz, (rotation. X, rotation. Y-90, rotation. Z) and scale. Xyz attributes, and then carries out automatic model replacement according to a model structure information mapping relation table. After the initialization work of all models in the digital workshop is completed, the system develops a Unity plugin which can automatically replace the material balls of all models according to the mapping relation table of the models and the material balls.
4. The system development Unity plugin can optimize the hierarchical structure of the model according to the model name, and divide the model to the belonging elevation, family and type. And establishing a corresponding relation between the model and the data according to the unique ID of the model.
It should be understood that the foregoing description of the preferred embodiments is not intended to limit the scope of the invention, but rather to limit the scope of the claims, and that those skilled in the art can make substitutions or modifications without departing from the scope of the invention as set forth in the appended claims.

Claims (1)

1. A method for cross-platform consistency of a large-scale digital workshop three-dimensional model based on a Unity platform is characterized by comprising the following steps:
Step 1: exporting a file in nwc format on a Revit platform;
step 2: opening the file in nwc format exported in the step 1 at Naviswork platform, and exporting the file in fbx format;
Step 3: importing the fbx file into a Unity platform, and establishing a Revit model and material ball mapping relation table and a Revit model structure information mapping relation table;
The Revit model and material ball mapping relation table comprises a single material mapping relation table and a multi-material mapping relation table; the single material mapping relation table takes a family name and a type name as unique identifiers, and establishes a corresponding relation with the material names; the multi-material mapping relation table takes the group name and the type name as unique identifiers, but does not need to establish a relation with material comparison;
The Revit model structure information mapping relation table establishes a mapping relation between the unique key words of elevation, family and type and the Revit model;
step 4: exporting the fbx file on a Revit platform, and exporting data to a database through ODBC;
step 5: importing the fbx file into a Unity platform, and establishing a Revit model data mapping relation table;
The Revit model data mapping relation table establishes a mapping relation between the Revit model ID as a unique keyword and the Revit model data;
step 6: performing Revit model replacement according to the Revit model structure information mapping relation table in the step 3;
Step 7: according to the Revit model and the material ball mapping relation table in the step 3, material ball replacement is carried out;
Step 8: optimizing the hierarchical structure of the model according to the Revit model data mapping relation table established in the step 5, and dividing the model into the belonging elevation, family and type; and (3) establishing a corresponding relation between the model and the data according to the unique model ID and the database derived in the step (4).
CN202111287290.9A 2021-11-02 2021-11-02 Cross-platform consistency method for large-scale digital workshop three-dimensional model based on Unity platform Active CN114155341B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111287290.9A CN114155341B (en) 2021-11-02 2021-11-02 Cross-platform consistency method for large-scale digital workshop three-dimensional model based on Unity platform

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111287290.9A CN114155341B (en) 2021-11-02 2021-11-02 Cross-platform consistency method for large-scale digital workshop three-dimensional model based on Unity platform

Publications (2)

Publication Number Publication Date
CN114155341A CN114155341A (en) 2022-03-08
CN114155341B true CN114155341B (en) 2024-04-19

Family

ID=80459479

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111287290.9A Active CN114155341B (en) 2021-11-02 2021-11-02 Cross-platform consistency method for large-scale digital workshop three-dimensional model based on Unity platform

Country Status (1)

Country Link
CN (1) CN114155341B (en)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116933976B (en) * 2023-09-13 2023-12-12 北京广安融盛投资有限公司 Real estate project management method based on BIM
CN117556507A (en) * 2023-11-20 2024-02-13 中交第二公路勘察设计研究院有限公司 Modulus combining method based on fbx format modulus-first and modulus-last

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108170881A (en) * 2017-11-21 2018-06-15 中国建筑第八工程局有限公司 A kind of adjustable solar street lamp production method based on BIM technology
KR101885089B1 (en) * 2017-01-26 2018-08-03 홍익대학교세종캠퍼스산학협력단 Excel export method for bim design files
CN108537891A (en) * 2017-03-01 2018-09-14 黎志毅 The method that three-dimensional material and textures data are automatically switched to UE4
CN109740241A (en) * 2018-12-29 2019-05-10 浙江精工钢结构集团有限公司 A kind of method and application based on BIM model and component extension information MAP

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR101885089B1 (en) * 2017-01-26 2018-08-03 홍익대학교세종캠퍼스산학협력단 Excel export method for bim design files
CN108537891A (en) * 2017-03-01 2018-09-14 黎志毅 The method that three-dimensional material and textures data are automatically switched to UE4
CN108170881A (en) * 2017-11-21 2018-06-15 中国建筑第八工程局有限公司 A kind of adjustable solar street lamp production method based on BIM technology
CN109740241A (en) * 2018-12-29 2019-05-10 浙江精工钢结构集团有限公司 A kind of method and application based on BIM model and component extension information MAP

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
房屋建筑结构三维信息模型集成的BIM方法研究与应用;鲍鹏玲;张玉辉;;信阳师范学院学报(自然科学版);20190314(第04期);全文 *

Also Published As

Publication number Publication date
CN114155341A (en) 2022-03-08

Similar Documents

Publication Publication Date Title
CN114155341B (en) Cross-platform consistency method for large-scale digital workshop three-dimensional model based on Unity platform
CN113033001B (en) Three-dimensional digital factory modeling method and system for digital twin application
CN103020393B (en) Aircraft assembly data visualization method based on Web
CN112818446A (en) Construction method of intelligent workshop digital twin system
CN115713161B (en) Building information management system based on BIM technology
CN104933265A (en) Method for designing interior decoration of building based on BIM
CN112084385B (en) Part-process-equipment association relationship topological view generation method based on digital twinning
CN101566981A (en) Method for establishing dynamic virtual data base in analyzing and processing system
CN108629836B (en) Method for converting CATIA BIM entity model into Supermap GIS standardized model
CN104915524A (en) BIM-based interior module group library construction method for building interior design
CN113051650B (en) Real-time acquisition method and device for building information model component data
CN104392037B (en) City scene parameterization modeling system
CN112527944A (en) Method for building spatial semantic database based on BIM and GIS data integration
CN113378011B (en) Construction method and system of complex product assembly digital twin body
CN104794272A (en) Machining method of airplane component
WO2024045615A1 (en) Automatic labeling method and system for pipeline three-dimensional building information modeling
CN108170855B (en) CityGML and IFC data unified query and data extraction method
CN108875087B (en) Method for describing object space attribute and searching based on description
CN111897971A (en) Knowledge graph management method and system suitable for field of power grid dispatching control
CN110704653A (en) Method for searching component by graph in BIM (building information modeling) model and graph-text searching system
CN111428310A (en) Underground pipe gallery model construction method based on BIM and GIS
Li Brief analysis of the application and limitation of BIM in project life cycle management
CN107480364B (en) BIM (building information modeling) model dynamic organization method for engineering construction information management
CN101620744A (en) Method for processing three-dimensional scene data based on XML
CN115630437A (en) Product data management method compatible with ship design and construction

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