Conversion method between BIM model data and structural calculation data of high-pile wharf

Abstract

The present invention relates to a method for converting BIM model data and structural calculation data of a high-pile wharf, comprising the following steps: S1, setting the corner point on the upstream side of the front edge of the high-pile wharf as the origin, so that the REVIT coordinate system is consistent with the structural calculation model coordinate system; S2, opening the BIM model in the REVIT software, loading the data extraction plug-in, and extracting the original data of the BIM model of the high-pile wharf; S3, the data extraction plug-in performs the extracted data inspection; S4, the data extraction plug-in organizes and encapsulates the data and transmits it to the data conversion system through the http protocol; S5, uploading it to the system background through the http protocol, the background service extracts the data in the EXCEL original data table through the pandas library in the python environment, and inputs it into the data conversion system; S6, the data conversion system performs data analysis on the received encapsulated data; S7, generating a data table. The present invention greatly improves the efficiency of inputting structural calculation data of the high-pile wharf, improves the quality of structural calculation data, and thus improves the convenience of structural calculation of the high-pile wharf and the accuracy of the results.

Description

Technical Field

[0001] The present invention relates to the technical field of BIM models for port engineering, and more specifically, to a method and system for converting BIM model data and structural calculation data of a high-pile wharf. Background Art

[0002] At present, BIM technology has been widely used in the field of water transport engineering. The use of BIM technology can greatly improve the design and construction efficiency of the wharf and the quality of the project. At present, REVIT is the most commonly used BIM design software. Based on REVIT software, a three-dimensional model of a high-pile wharf in a port can be quickly built; ROBOT is the most commonly used three-dimensional structural calculation software. ROBOT can be used to calculate the structural internal forces of the high-pile wharf, providing a theoretical basis for project quality and safety.

[0003] Currently, when using ROBOT to perform structural calculations on the three-dimensional model built by REVIT, a large number of calculation parameters need to be manually input. At the same time, the parameters in the REVIT model need to be manually counted and converted into the parameters required for structural calculation. The workload is large, the input efficiency is low, the steps are cumbersome, and it is easy to make mistakes. It not only wastes a lot of human resources but also greatly delays the design progress. Summary of the invention

[0004] The technical problem to be solved by the present invention is to provide a method for converting BIM model data and structural calculation data of a high-pile wharf, which greatly improves the efficiency of inputting structural calculation data of the high-pile wharf, improves the quality of structural calculation data, and thus improves the convenience of structural calculation of the high-pile wharf and the accuracy of the results.

[0005] The technical solution adopted by the present invention to solve the technical problem is: constructing a method for converting BIM model data and structural calculation data of a high-pile wharf, comprising the following steps:

[0006] S1. Set the upstream corner point of the high-pile wharf front edge as the origin to make the REVIT coordinate system consistent with the structural calculation model coordinate system;

[0007] S2. Open the BIM model in REVIT software, load the data extraction plug-in, and extract the original data of the high-pile wharf BIM model set in step S1;

[0008] S3, data extraction plug-in to check the extracted data;

[0009] S4, the data extraction plug-in organizes and encapsulates the extracted data and transmits it to the data conversion system via the http protocol;

[0010] S5. Use the data extraction plug-in to upload the original EXCEL data table to the system backend through the http protocol. The backend service extracts the data in the original EXCEL data table through the pandas library in the python environment and inputs it into the data conversion system in the format of table name, parameter name, and parameter value.

[0011] S6. The data conversion system performs data analysis on the received encapsulated data according to the data analysis rules;

[0012] S7. The data conversion system converts the parsed original data according to the data conversion rules and generates a data table.

[0013] According to the above scheme, in step S1, in the structural calculation model: the base point of the pile foundation is set to the bottom surface of the beam, the base point of the beam is set to the point where the center line of the bottom surface on the river side is located, the base points of the track beam, longitudinal beam, front beam and rear beam are set on the center line, the base point of the steel mooring column is set at the point where the axis is connected to the upper structure, the base point of the reinforced concrete mooring column is set at the top center point of the mooring member, the base point of the steel mooring beam is set on the axis, the base point of the reinforced concrete mooring beam is set on the center line of the mooring beam rectangle, and the surface layer family base point is set at the lower left corner of the surface layer bottom plate.

[0014] According to the above scheme, when the upstream surface corner point is not set as the model origin (0,0,0) when the model is created, a new REVIT file is created, the existing file is linked to it, and it is moved to the project base point.

[0015] According to the above scheme, in step S5, the original data table of EXCEL contains the mooring load arrangement table required for structural calculation, the ship impact load arrangement table, the ship crowding load arrangement table, the designated ship berthing load arrangement table, the loading and unloading machinery track load arrangement table, the loading and unloading machinery arrangement table, the automobile arrangement table, and the trailer arrangement table.

[0016] According to the above scheme, in step S6, specifically: first, the received data string is split into a string array according to the "\r\n" separator, and then the string of each array is split into a JSON file in the following format according to the "$$" separator in a loop;

[0017] JSON data format

[0018] {

[0019] Table 62-10010105: [

[0020] {parameter name 1: parameter value 1},

[0021] {parameter name 2: parameter value 2}, ...],

[0022] Table 62-10010103: [{

[0023] Parameter name 1: parameter value 1},

[0024] {parameter name 2: parameter value 2}, ...],

[0025] Table 62-10011100: [

[0026] {parameter name 1: parameter value 1},

[0027] {parameter name 2: parameter value 2}, ...],

[0028] …

[0029] }.

[0030] According to the above scheme, in step S7, the data conversion rules replace the numbering table name with the component name, and the parameter conversion rules include: geometric dimensions are directly replaced by converting millimeters to meters, parameters that need to generate serial numbers, sorting, etc. are sorted by the pandas function library and then generated in sequence, angle parameters are calculated and generated through model coordinate attribute values, quantity statistics parameters are filtered and statistically generated by the pandas library, and special attributes are generated by the calculation method specified in the high-pile wharf BIM model application data interface standard.

[0031] According to the above scheme, in step S7, the generated data tables also include: front platform table, wharf segment table, pile type table, pile foundation arrangement table, cross beam component characteristic value table, cross beam arrangement table, reinforced concrete composite track beam component characteristic value table, prestressed concrete composite track beam component characteristic value table, track beam arrangement table, reinforced concrete composite longitudinal beam component characteristic value table, prestressed concrete composite longitudinal beam component characteristic value table, longitudinal beam arrangement table, front side beam component characteristic value table, rear side beam component characteristic value table, steel pipe mooring column component characteristic value table, front edge mooring column arrangement table, rear edge mooring column arrangement table, reinforced concrete mooring beam component characteristic value table, steel pipe mooring beam component characteristic value table, mooring beam arrangement table, front edge mooring beam arrangement table, rear edge mooring beam arrangement table, composite panel component characteristic value table, panel arrangement table.

[0032] The method for converting high-pile wharf BIM model data and structural calculation data according to the present invention has the following beneficial effects:

[0033] 1. The present invention can realize the automatic extraction and import of BIM model data of high-pile wharf, improve work efficiency and reduce the probability of errors in original data input; checking model data according to standards can improve the accuracy of structural calculation results and provide designers with a reliable design basis;

[0034] 2. The present invention provides a data conversion method and system that can quickly complete the automatic conversion of model data to structural calculation data. Compared with the traditional method of manually inputting calculation data, it greatly improves the data accuracy and calculation efficiency of structural calculation. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] The present invention will be further described below with reference to the accompanying drawings and embodiments, in which:

[0036] Figure 1 It is a flow chart of a method for converting high-pile wharf BIM model data and structural calculation data of the present invention;

[0037] Figure 2 It is the original data table of the high-pile wharf BIM model extracted by the present invention;

[0038] Figure 3 It is the original data table of the BIM model imported by the present invention;

[0039] Figure 4 It is a partial display diagram of the converted structure calculation data table in the system of the present invention;

[0040] Figure 5 It is an architecture diagram of the high-pile wharf BIM model data and structure calculation data conversion system of the present invention. DETAILED DESCRIPTION

[0041] In order to have a clearer understanding of the technical features, purposes and effects of the present invention, specific embodiments of the present invention are now described in detail with reference to the accompanying drawings.

[0042] like Figure 1-5 As shown, the method for converting high-pile wharf BIM model data and structural calculation data of the present invention comprises the following steps:

[0043] S1. Set the upstream corner point of the high-pile wharf front edge as the origin to make the REVIT coordinate system consistent with the structural calculation model coordinate system;

[0044] In the step S1, in the structural calculation model: the base point of the pile foundation is set to the bottom surface of the beam, the base point of the beam is set to the point where the center line of the river side bottom surface is located, the base points of the track beam, longitudinal beam, front beam and rear beam are set on the center line, the base point of the steel mooring column is set at the point where the axis is connected to the upper structure, the base point of the reinforced concrete mooring column is set at the top center point of the mooring member, the base point of the steel mooring beam is set on the axis, the base point of the reinforced concrete mooring beam is set on the center line of the mooring beam rectangle, and the surface layer family base point is set at the lower left corner of the surface layer bottom plate.

[0045] When the upstream surface corner point is not set as the model origin (0,0,0) when the model is created, create a new REVIT file, link the existing file into it, and move it to the project base point.

[0046] S2. Open the BIM model in REVIT software, load the data extraction plug-in, and extract the original data of the high-pile wharf BIM model set in step S1;

[0047] S3, data extraction plug-in to check the extracted data;

[0048] S4, the data extraction plug-in organizes and encapsulates the extracted data and transmits it to the data conversion system via the http protocol;

[0049] S5. Use the data extraction plug-in to upload the original EXCEL data table to the system backend through the http protocol. The backend service extracts the data in the original EXCEL data table through the pandas library in the python environment and inputs it into the data conversion system in the format of table name, parameter name, and parameter value.

[0050] The original EXCEL data table contains the mooring load arrangement table required for structural calculation, the ship impact load arrangement table, the ship crowding load arrangement table, the designated ship berthing load arrangement table, the loading and unloading machinery track load arrangement table, the loading and unloading machinery arrangement table, the automobile arrangement table, and the trailer arrangement table.

[0051] S6. The data conversion system parses the received encapsulated data according to the data parsing rules; specifically, firstly, the received data string is split into a string array according to the "\r\n" separator, and then the string of each array is split into a JSON file in the following format according to the "$$" separator in a loop;

[0052] JSON data format

[0053] {

[0054] Table 62-10010105: [

[0055] {parameter name 1: parameter value 1},

[0056] {parameter name 2: parameter value 2}, ...],

[0057] Table 62-10010103: [{

[0058] Parameter name 1: parameter value 1},

[0059] {parameter name 2: parameter value 2}, ...],

[0060] Table 62-10011100: [

[0061] {parameter name 1: parameter value 1},

[0062] {parameter name 2: parameter value 2}, ...],

[0063] …

[0064] }.

[0065] S7. The data conversion system converts the parsed original data according to the data conversion rules and generates a data table.

[0066] The data conversion rules replace the number table name with the component name. The parameter conversion rules include: geometric dimensions are directly converted from millimeters to meters, parameters that need to generate serial numbers, sorting, etc. are sorted by the pandas function library and generated in ascending order, angle parameters are calculated and generated through the model coordinate attribute values, quantity statistics parameters are filtered and statistically generated by the pandas library, and special attributes are generated through the calculation method specified in the high-pile wharf BIM model application data interface standard.

[0067] The generated data tables also include: front platform table, wharf section table, pile type table, pile foundation arrangement table, cross beam component characteristic value table, cross beam arrangement table, reinforced concrete composite track beam component characteristic value table, prestressed concrete composite track beam component characteristic value table, track beam arrangement table, reinforced concrete composite longitudinal beam component characteristic value table, prestressed concrete composite longitudinal beam component characteristic value table, longitudinal beam arrangement table, front side beam component characteristic value table, rear side beam component characteristic value table, steel pipe mooring column component characteristic value table, front edge mooring column arrangement table, rear edge mooring column arrangement table, reinforced concrete mooring beam component characteristic value table, steel pipe mooring beam component characteristic value table, mooring beam arrangement table, front edge mooring beam arrangement table, rear edge mooring beam arrangement table, composite panel component characteristic value table, panel arrangement table.

[0068] Example:

[0069] Base point setting: open the original structural calculation model through REVIT, set the upstream corner point of the front edge of the high-pile wharf as the origin, and make the REVIT coordinate system consistent with the coordinate system of the structural calculation model; in the model, the base point of the pile foundation is set to the bottom surface of the beam, the base point of the beam is set to the point where the center line of the river side bottom surface is located, the base points of the track beam, longitudinal beam, front beam and rear beam are set on the center line, the base point of the steel mooring column is set at the point where the axis connects to the upper structure, the base point of the reinforced concrete mooring column is set at the top center point of the mooring member, the base point of the steel mooring beam is set on the axis, the base point of the reinforced concrete mooring beam is set on the center line of the mooring beam rectangle, and the surface layer family base point is set at the lower left corner of the surface layer bottom plate.

[0070] If the upstream surface corner point is not set as the model origin (0,0,0) when the model is created, create a new REVIT file, link the existing file into it, and move it to the project base point.

[0071] Open the data conversion system plug-in loaded in the REVIT software, select a new calculation task according to the user's actual situation, and select the project to which it belongs.

[0072] Click on model attribute data extraction, the data conversion system will automatically extract the REVIT model attribute data, verify the data, and wait for the data extraction to be completed.

[0073] The data extraction system packages the extracted data and sends it to the back-end server.

[0074] According to user needs, click the data import button and select the EXCEL data table to be imported.

[0075] The data import system will check the EXCEL data table format. If it passes, the imported data will be packaged and sent to the back-end server.

[0076] The back-end server receives the packaged model data sent by the data extraction system, including the data sent by the data extraction system and the data import system, parses the data into JSON format, and stores it in the server "JSON file temporary directory" in the form of JSON files.

[0077] After the data parsing is completed, the backend server calls the model data and structure calculation data conversion service to convert the data. During the conversion process, the data type and data unit are unified according to the model attribute standard. The geometric information is unified as float type, and the length data unit is unified as mm.

[0078] After the data conversion is completed, the conversion system will generate the data tables required for the structural calculation, including front platform table 1, front platform table 2, wharf segment table, pile type table, pile foundation arrangement table 1, pile foundation arrangement table 2, cross beam component characteristic value table, cross beam arrangement table 1, cross beam arrangement table 2, reinforced concrete composite track beam component characteristic value table, prestressed concrete composite track beam component characteristic value table, track beam arrangement table 1, reinforced concrete composite longitudinal beam component characteristic value table, prestressed concrete composite longitudinal beam component characteristic value table, longitudinal beam arrangement table, longitudinal beam arrangement table 2, front side beam component characteristic value table, rear side beam component characteristic value table, steel pipe berthing column component characteristic value table, reinforced concrete berthing column component characteristic value table, front Arrangement table of mooring columns along the edge, arrangement table of mooring columns at the rear edge, characteristic value table of reinforced concrete mooring beam components, characteristic value table of steel pipe mooring beam components, mooring beam arrangement table 1, front mooring beam arrangement table 2, rear mooring beam arrangement table 2, characteristic value table of superimposed panel components, panel arrangement table 1, panel arrangement table 2, mooring load arrangement table, ship impact load arrangement table, ship crowding load arrangement table, designated ship berthing load arrangement table, loading and unloading machinery track load arrangement table, loading and unloading machinery arrangement table, car arrangement table, trailer arrangement table, and store the data tables in the corresponding data tables in the SQLSERVER database.

[0079] The data conversion system sends the converted data in JSON format via HTTP protocol to the data extraction plug-in, and users can view the converted data table content.

[0080] In the data extraction plug-in, users can also manually edit and save all converted data tables individually.

[0081] The embodiments of the present invention are described above in conjunction with the accompanying drawings, but the present invention is not limited to the above-mentioned specific implementation modes, which are merely illustrative rather than restrictive. Under the guidance of the present invention, ordinary technicians in this field can also make many forms without departing from the scope of protection of the present invention and the claims, all of which are within the protection of the present invention.

Claims

1. A method for converting BIM model data and structural calculation data of a high-pile wharf, characterized in that: The following steps are involved: S1. Set the corner point of the upstream surface layer at the front of the high-pile wharf as the origin to make the REVIT coordinate system consistent with the coordinate system of the structural calculation model; S2. Open the BIM model in REVIT software, load the data extraction plug-in, and extract the original data of the high-pile wharf BIM model set in step S1; S3, data extraction plug-in to check the extracted data; S4, the data extraction plug-in organizes and encapsulates the extracted data and transmits it to the data conversion system via the http protocol; S5. Use the data extraction plug-in to upload the original EXCEL data table to the system backend through the http protocol. The backend service extracts the data in the original EXCEL data table through the pandas library in the python environment and inputs it into the data conversion system in the format of table name, parameter name, and parameter value. The original data table of EXCEL contains the mooring load arrangement table required for structural calculation, ship impact load arrangement table, ship berthing load arrangement table, designated ship berthing load arrangement table, loading and unloading machinery track load arrangement table, loading and unloading machinery arrangement table, automobile arrangement table, trailer arrangement table; S6, the data conversion system performs data analysis on the packaged data received in step S4 and the data in the original EXCEL data table extracted in step S5 according to the data analysis rules to obtain the analyzed original data; Specifically: first, split the received data string into a string array according to the "\r\n" separator, and then loop and split the string of each array according to the "$$" separator into a JSON file in the following format; JSON data format { Table 62-10010105: [ {parameter name 1: parameter value 1}, {parameter name 2: parameter value 2}, ...], Table 62-10010103: [{ parameter name 1: parameter value 1}, {parameter name 2: parameter value 2}, ...], Table 62-10011100: [ {parameter name 1: parameter value 1}, {parameter name 2: parameter value 2}, ...], …… }； S7, the data conversion system converts the parsed original data according to the data conversion rules. And generate the data table required for structural calculation; The data conversion rules replace the number table name with the component name. The parameter conversion rules include: geometric dimensions are directly replaced by converting millimeters to meters, parameters that need to generate serial numbers and sorting are sorted by the pandas function library and generated in ascending order, angle parameters are calculated and generated through the model coordinate attribute values, quantity statistics parameters are filtered and statistically generated by the pandas library, and special attributes are generated through the calculation method specified in the high-pile wharf BIM model application data interface standard.

2. The method for converting high-pile wharf BIM model data and structural calculation data according to claim 1 is characterized in that: In the step S1, in the structural calculation model: the base point of the pile foundation is set to the bottom surface of the beam, the base point of the beam is set to the point where the center line of the river side bottom surface is located, the base points of the track beam, longitudinal beam, front beam and rear beam are set on the center line, the base point of the steel mooring column is set at the point where the axis and the upper structure are connected, the base point of the reinforced concrete mooring column is set at the top center point of the mooring member, the base point of the steel mooring beam is set on the axis, the base point of the reinforced concrete mooring beam is set on the center line of the mooring beam rectangle, and the surface layer family base point is set at the lower left corner of the surface layer bottom plate.

3. The method for converting high-pile wharf BIM model data and structural calculation data according to claim 2 is characterized in that: When the upstream surface corner point is not set as the model origin (0, 0, 0) when the model is created, a new REVIT project file is created, the REVIT file of the existing BIM model is linked into it, and moved to the project base point.

4. The method for converting high-pile wharf BIM model data and structural calculation data according to claim 1 is characterized in that: In the step S7, the generated data tables also include: a front platform table, a wharf segmentation table, a pile type table, a pile foundation arrangement table, a crossbeam component characteristic value table, a crossbeam arrangement table, a reinforced concrete laminated track beam component characteristic value table, a prestressed concrete laminated track beam component characteristic value table, a track beam arrangement table, a reinforced concrete laminated longitudinal beam component characteristic value table, a prestressed concrete laminated longitudinal beam component characteristic value table, a longitudinal beam arrangement table, a front side beam component characteristic value table, a rear side beam component characteristic value table, a steel pipe mooring column component characteristic value table, a front edge mooring column arrangement table, a rear edge mooring column arrangement table, a reinforced concrete mooring beam component characteristic value table, a steel pipe mooring beam component characteristic value table, a mooring beam arrangement table, a front edge mooring beam arrangement table, a rear edge mooring beam arrangement table, a composite panel component characteristic value table, and a panel arrangement table.

Images