Method for converting BIM model data into structural calculation data for high-pile wharf

Abstract

The present invention relates to a method for converting BIM model data into structural calculation data for a high-pile wharf. The method comprises the following steps: S1, setting a corner point on the upstream side of the front edge of a high-pile wharf as an origin, and making an REVIT coordinate system be consistent with a structural calculation model coordinate system; S2, opening a BIM model in REVIT software, and loading a data extraction plug-in, so as to extract original BIM model data of the high-pile wharf; S3, checking the extracted data by means of the data extraction plug-in; S4, the data extraction plug-in organizing and packaging the data, and then transmitting the data to a data conversion system by means of an HTTP protocol; S5, uploading the data to a system background by means of the HTTP protocol, and a background service extracting data from an original EXCEL data table by means of a Pandas library in a Python environment, and inputting the data into the data conversion system; S6, the data conversion system performing data parsing on received packaged data; and S7, generating a data table. The present invention significantly improves the efficiency of inputting structural calculation data of a high-pile wharf and improves the quality of the structural calculation data, thereby improving the convenience of structural calculation of the high-pile wharf and the accuracy of results.

Description

Conversion method between BIM model data and structural calculation data of high-piled wharf Technical Field

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

[0002] Currently, BIM technology has been widely used in water transport engineering, significantly improving the design and construction efficiency and project quality of docks. REVIT is the most commonly used BIM design software, enabling rapid construction of 3D models of high-piled docks in ports. ROBOT, the most commonly used 3D structural calculation software, can be used to calculate the structural internal forces of high-piled docks, providing a theoretical basis for project quality and safety.

[0003] Currently, when using ROBOT to perform structural calculations on a 3D model built with 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 calculations. This is a large workload, has low input efficiency, and the steps are cumbersome and prone to errors. It not only wastes a lot of human resources but also greatly delays the design progress.

[0004] Summary of the Invention

[0005] 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 high-pile wharf structural calculation data input, improves the quality of structural calculation data, and thus improves the convenience of high-pile wharf structural calculation and the accuracy of the results.

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

[0007] 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;

[0008] 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;

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

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

[0011] S5. Use the data extraction plug-in to upload the original EXCEL data table to the system backend via the HTTP protocol. The backend service extracts the data from 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.

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

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

[0014] 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 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 component, 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.

[0015] According to the above solution, if 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 into it, and moved to the project base point.

[0016] According to the above scheme, in step S5, the EXCEL original data table contains the mooring load arrangement table required for structural calculation, the ship impact load arrangement table, the ship berthing 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.

[0017] 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" delimiter, and then the string of each array is split into a JSON file in the following format according to the "$$" delimiter;

[0018] JSON data format

[0019] {

[0020] Table 62-10010105:[

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

[0022] {parameter name 2: parameter value 2},……],

[0023] Table 62-10010103: [{

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

[0025] {parameter name 2: parameter value 2},……],

[0026] Table 62-10011100:[

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

[0028] {parameter name 2: parameter value 2},……],

[0029] …

[0030] }.

[0031] According to the above scheme, in step S7, the data conversion rule replaces the number table name with the component name, and the parameter conversion rules include: geometric dimensions are directly converted from millimeters to meters, parameters that need to be generated, such as serial numbers and sorting, are sorted by the pandas function library and then generated in sequence, angle parameters are calculated and generated by the model coordinate attribute values, quantitative statistical 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.

[0032] According to the above scheme, in step S7, the data tables generated also include: front platform table, wharf segmentation table, pile type table, pile foundation arrangement table, crossbeam component characteristic value table, crossbeam arrangement table, reinforced concrete laminated track beam component characteristic value table, prestressed concrete laminated track beam component characteristic value table, track beam arrangement table, reinforced concrete laminated longitudinal beam component characteristic value table, prestressed concrete laminated longitudinal beam component characteristic value table, longitudinal beam arrangement table, front edge beam component characteristic value table, rear edge 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.

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

[0034] 1. The present invention can realize the automatic extraction and import of BIM model data of high-pile wharfs, thereby improving work efficiency and reducing 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;.

[0035] 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

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

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

[0038] FIG2 is a table of original data of the high-pile wharf BIM model extracted by the present invention;

[0039] FIG3 is a table of original data of the BIM model imported by the present invention;

[0040] FIG4 is a partial display diagram of the converted structure calculation data table in the system according to the present invention;

[0041] FIG5 is an architecture diagram of a system for converting BIM model data and structural calculation data of a high-pile wharf according to the present invention. DETAILED DESCRIPTION

[0042] 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.

[0043] As shown in Figures 1-5, the method for converting high-pile wharf BIM model data and structural calculation data of the present invention includes the following steps:

[0044] 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;

[0045] 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 superstructure, the base point of the reinforced concrete mooring column is set at the top center point of the mooring component, 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.

[0046] 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.

[0047] 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;

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

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

[0050] S5. Use the data extraction plug-in to upload the original EXCEL data table to the system backend via the HTTP protocol. The backend service extracts the data from 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.

[0051] The original EXCEL data table contains the mooring load arrangement table required for structural calculation, the ship impact load arrangement table, the ship berthing 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.

[0052] S6. The data conversion system parses the received encapsulated data according to the data parsing rules. Specifically, the received data string is first split into a string array according to the "\r\n" delimiter, and then the string of each array is split into a JSON file in the following format according to the "$$" delimiter.

[0053] JSON data format

[0054] {

[0055] Table 62-10010105:[

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

[0057] {parameter name 2: parameter value 2},……],

[0058] Table 62-10010103: [{

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

[0060] {parameter name 2: parameter value 2},……],

[0061] Table 62-10011100:[

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

[0063] {parameter name 2: parameter value 2},……],

[0064] …

[0065] }.

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

[0067] 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 be generated, such as serial numbers and sorting, are sorted by the pandas function library and then generated in ascending order, angle parameters are calculated and generated through the model coordinate attribute values, quantitative statistical parameters are filtered and statistically generated by the pandas library, and special attributes are generated using the calculation method specified in the high-pile wharf BIM model application data interface standard.

[0068] The generated data tables also include: front platform table, wharf section table, pile type table, pile foundation arrangement table, crossbeam component characteristic value table, crossbeam 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, reinforced concrete mooring column component characteristic value table, front mooring column arrangement table, rear 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 mooring beam arrangement table, rear mooring beam arrangement table, composite panel component characteristic value table, panel arrangement table.

[0069] Example:

[0070] For 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 superstructure, the base point of the reinforced concrete mooring column is set at the top center point of the mooring component, 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.

[0071] 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.

[0072] Open the data conversion system plug-in loaded in the REVIT software, select New Calculation Task according to the user's actual situation, and select the project to which it belongs.

[0073] 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.

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

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

[0076] 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.

[0077] The backend 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's "JSON file temporary directory" in the form of a JSON file.

[0078] After data parsing is complete, the backend server calls the model data and structural 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. Geometric information is unified into float type, and length data unit is unified into mm.

[0079] After the data conversion is completed, the conversion system will generate the data tables required for 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 Alongside 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 1, leading edge mooring beam arrangement table 2, rear edge mooring beam arrangement table 2, composite panel component characteristic value table, 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.

[0080] 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.

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

[0082] 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 methods. The above-mentioned specific implementation methods are merely illustrative and not 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 protected by 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 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; 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. S6. The data conversion system performs data analysis on the received encapsulated data according to the data analysis rules; S7. The data conversion system converts the parsed original data according to the data conversion rules and generates a data table.

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: 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.

4. The method for converting high-pile wharf BIM model data and structural calculation data according to claim 1, characterized in that: 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 berthing 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.

5. The method for converting high-pile wharf BIM model data and structural calculation data according to claim 1, characterized in that: In the step S6, 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; 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}, ...], …… }。 6. The method for converting high-pile wharf BIM model data and structural calculation data according to claim 1, characterized in that: In step S7, the data conversion rules replace the number table name with the component name, and the parameter conversion rules include: geometric dimensions are directly replaced by converting millimeters into 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 by 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.

7. The method for converting high-pile wharf BIM model data and structural calculation data according to claim 6 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 cross beam component characteristic value table, a cross beam 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