Python and BIM-based three-dimensional geological model creation method
Through Python and BIM-based methods, drilling data is quickly extracted and processed, three-dimensional geological models are generated and designed in Revit, which solves the problems of cumbersome data sorting and long modeling time in the existing technology, and achieves rapid and efficient three-dimensional geological model creation.
Patent Information
- Application Number
- CN202411481606.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-10-23
- Publication Date
- 2025-03-18
AI Technical Summary
When creating a three-dimensional geological model, the existing technology is complicated to organize a large amount of drilling data, resulting in a long modeling time and cumbersome steps, and it is impossible to achieve fast and efficient modeling.
Using Python and BIM-based methods, drilling data is extracted through the Python library and stored in Excel tables, thereby extracting different stratigraphic data required for surface modeling and saving it as a .csv file. Civil3d software is used to generate three-dimensional geological surfaces and generate three-dimensional geological entities. Dynamo visual programming is used to convert geometric information into .sat files, and import them into Revit software for BIM model construction and design.
The Python library quickly extracts and processes drilling data, simplifies the data collation process, reduces modeling time, realizes the rapid and efficient creation of 3D geological models, and provides an editable 3D geological model in Revit.
Smart Images

Figure CN119648930A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of three-dimensional geological model creation, and in particular to a three-dimensional geological model creation method based on Python and BIM. Background Art
[0002] 3D geological modeling can efficiently and accurately reflect geological problems encountered in the design, and accurately provide owners, designers and construction personnel with visual renderings. BIM technology is now popular in all walks of life. It is used by many engineering industries with its information-based and digital modeling concepts. BIM forward design is now the general trend of all industries, and geology is the foundation of all engineering projects. Therefore, it is very necessary to combine BIM technology to produce 3D geology.
[0003] In the existing technology, when creating a 3D geological model, it is relatively cumbersome to collate the data of a large number of boreholes, which will increase the modeling time, and the direction point acquisition and surface projection are also cumbersome. The technical solution for creating a 3D geological model based on Civil3d is relatively complete. Civil3d is a basic software of BIM technology, which has great advantages in the establishment of 3D surfaces and earthwork excavation. However, the formed 3D geological entity is only a 3D model and cannot be designed in Revit, the design software of BIM technology. This is also the disadvantage of single software modeling. Summary of the invention
[0004] The present application provides a three-dimensional geological model creation method based on Python and BIM to solve the problems of the prior art in that the collation of a large amount of drilling data is cumbersome, the modeling time is long, the steps are cumbersome, and fast and efficient modeling cannot be achieved.
[0005] According to the first aspect, an embodiment provides a method for creating a three-dimensional geological model based on Python and BIM, the method comprising:
[0006] Use the python library to extract the drilling data from the geotechnical engineering survey PDF file and store it in an Excel table;
[0007] Extract different stratum data required for surface modeling from the Excel table and save them as .csv files for different strata;
[0008] Based on the .csv files of different strata, Civil3d software is used to generate 3D geological surfaces of different strata, and 3D geological entities are generated based on the 3D geological surfaces;
[0009] Use Dynamo visual programming to convert the geometric information and geometric models of three-dimensional geological entities into .sat files;
[0010] Import the .sat file of the 3D geological entity into Revit software for BIM model construction and design.
[0011] Furthermore, the drilling data in the geotechnical engineering survey PDF file is extracted using the python library and stored in an Excel table, including:
[0012] The pdfplumber library is used to extract the drilling data of the drilling column chart in the PDF file, wherein the drilling data includes the drilling number, soil layer name, soil layer number, and layer bottom elevation data;
[0013] Use the pandas library to save the extracted data as an Excel file.
[0014] Furthermore, the different stratum data required for surface modeling are extracted from the Excel table and saved as .csv files of different strata, including:
[0015] The data required for modeling include hole position coordinates, soil layer name and layer bottom elevation. The data required for modeling are extracted from the Excel file of each soil layer and saved as a .csv file.
[0016] Furthermore, based on the .csv files of different strata, Civil3d software is used to generate three-dimensional geological surfaces of different strata, and three-dimensional geological entities are generated according to the three-dimensional geological surfaces, specifically including:
[0017] Create a surface and change the surface name to the soil layer name, add a .csv file to the created surface, and generate a three-dimensional geological surface;
[0018] Repeat the corresponding steps to generate multiple three-dimensional geological surfaces of different strata.
[0019] Furthermore, Dynamo visual programming is used to convert the geometric information and geometric model of the 3D geological entity into a .sat file, including:
[0020] Select the created 3D geological entity;
[0021] Convert the geometric information of three-dimensional entities into Dynamo objects for display;
[0022] Imports the specified geometry information into the given sat-file path.
[0023] Furthermore, the .sat file of the 3D geological entity is imported into the Revit software for BIM model construction and design, including:
[0024] Open Revit software, create a new family file, define material properties, save the file, and change the file extension from .rfa to .rft;
[0025] Use Dynamo visual programming to import the .sat file of the three-dimensional geological entity into Revit software to obtain the family file of the three-dimensional geological entity;
[0026] Create a new building template in Revit, switch to the created family file, and choose to load into the project to import the family file of the 3D geological entity into the Revit project.
[0027] Furthermore, the Dynamo visual programming is used to import the .sat file of the three-dimensional geological entity into the Revit software to obtain the family file of the three-dimensional geological entity, which specifically includes:
[0028] Select the .sat file and import it;
[0029] Obtain the geometric information of 3D geological entities based on the imported sat file;
[0030] Determine the scaling ratio around the origin based on display requirements;
[0031] Create a group model of 3D geological entities based on the created Revit family file and the scaled file.
[0032] According to the second aspect, in one embodiment, a three-dimensional geological model creation system based on Python and BIM is provided, the system comprising:
[0033] PDF parsing module, which is used to extract drilling data from geotechnical engineering survey PDF files using Python library and store them in Excel tables;
[0034] Modeling data extraction module, used to extract different stratum data required for surface modeling from Excel tables and save them as .csv files of different strata;
[0035] 3D geological entity creation module, which is used to generate 3D geological surfaces of different strata based on .csv files of different strata using Civil3d software, and generate 3D geological entities based on the 3D geological surfaces;
[0036] File conversion module, used to convert the geometric information and geometric model of three-dimensional geological entities into .sat files using Dynamo visual programming;
[0037] The model design module is used to import the .sat file of the three-dimensional geological entity into the Revit software for BIM model construction and design.
[0038] According to a third aspect, an embodiment provides an electronic device, the device comprising: a processor and a memory;
[0039] The memory is used to store one or more program instructions;
[0040] The processor is used to run one or more program instructions to execute the steps of a three-dimensional geological model creation method based on Python and BIM as described in any one of the above items.
[0041] According to the fourth aspect, an embodiment provides a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, the steps of a three-dimensional geological model creation method based on Python and BIM as described in any one of the above items are implemented.
[0042] The present application provides a method and system for creating a three-dimensional geological model based on Python and BIM. The Python library is used to extract the drilling data in the PDF file of geotechnical engineering survey data and store it in an Excel table; the different stratum data required for surface modeling are extracted from the Excel table and saved as .csv files of different strata; based on the .csv files of different strata, the three-dimensional geological surfaces of different strata are generated by Civil3d software, and three-dimensional geological entities are generated according to the three-dimensional geological surfaces; the geometric information and geometric model of the three-dimensional geological entity are converted into a .sat file by Dynamo visual programming; the .sat file of the three-dimensional geological entity is imported into Revit software for BIM model construction and design. The present invention converts the PDF file of the drilling column chart into an Excel file or a CSV file through the Python library, and can efficiently extract the corresponding data information in a large amount of drilling column charts; through Dynamo visual programming, Civil3d and Revit software are combined to produce an editable three-dimensional geological model; after the three-dimensional geological model is created, it is an editable model, which is a family file in Revit, which can provide designers with basic construction and design in the three-dimensional geological model. BRIEF DESCRIPTION OF THE DRAWINGS
[0043] Figure 1 A flowchart of a method for creating a three-dimensional geological model based on Python and BIM is provided in one embodiment of the present invention;
[0044] Figure 2 A borehole histogram in a three-dimensional geological model creation method based on Python and BIM provided by an embodiment of the present invention;
[0045] Figure 3 Excel table data extracted from a three-dimensional geological model creation method based on Python and BIM provided by an embodiment of the present invention;
[0046] Figure 4A CSV file generated in a 3D geological model creation method based on Python and BIM provided by an embodiment of the present invention;
[0047] Figure 5 A schematic diagram of generating a three-dimensional geological surface in a three-dimensional geological model creation method based on Python and BIM provided by an embodiment of the present invention;
[0048] Figure 6 A three-dimensional geological surface generated in a three-dimensional geological model creation method based on Python and BIM provided by an embodiment of the present invention;
[0049] Figure 7 A schematic diagram of generating a three-dimensional geological entity in a three-dimensional geological model creation method based on Python and BIM provided by an embodiment of the present invention;
[0050] Figure 8 A three-dimensional geological entity generated in a three-dimensional geological model creation method based on Python and BIM provided by an embodiment of the present invention;
[0051] Fig. 9 A schematic diagram of a Dynamo player in a method for creating a three-dimensional geological model based on Python and BIM provided by an embodiment of the present invention;
[0052] Fig.10 A schematic diagram of converting a three-dimensional geological entity into a .sat file in a three-dimensional geological model creation method based on Python and BIM provided by an embodiment of the present invention;
[0053] Fig.11 A schematic diagram of a process of importing a created three-dimensional entity file into Revit software in a three-dimensional geological model creation method based on Python and BIM provided by one embodiment of the present invention;
[0054] Fig.12 A schematic diagram of a process of importing a generated three-dimensional geological entity family file into a Revit project in a three-dimensional geological model creation method based on Python and BIM provided by an embodiment of the present invention;
[0055] Fig.13 A three-dimensional geological model formed by Revit in a three-dimensional geological model creation method based on Python and BIM provided in one embodiment of the present invention;
[0056] Fig.14 The invention provides a method for creating a three-dimensional geological model based on Python and BIM, and provides a method for creating a three-dimensional geological model based on Python and BIM.
[0057] Fig.15 A schematic diagram of the logical structure of a three-dimensional geological model creation system based on Python and BIM is provided for one embodiment of the present invention. DETAILED DESCRIPTION
[0058] The present invention is further described in detail below by specific embodiments in conjunction with the accompanying drawings. Wherein similar elements in different embodiments adopt associated similar element numbers. In the following embodiments, many detailed descriptions are for making the present application better understood. However, those skilled in the art can easily recognize that some features can be omitted in different situations, or can be replaced by other elements, materials, methods. In some cases, some operations related to the present application are not shown or described in the specification, this is to avoid the core part of the present application being overwhelmed by too much description, and for those skilled in the art, it is not necessary to describe these related operations in detail, and they can fully understand the related operations according to the description in the specification and the general technical knowledge in the art.
[0059] In addition, the features, operations or characteristics described in the specification can be combined in any appropriate manner to form various implementations. At the same time, the steps or actions in the method description can also be interchanged or adjusted in a manner that is obvious to those skilled in the art. Therefore, the various sequences in the specification and the drawings are only for the purpose of clearly describing a certain embodiment and are not meant to be a required sequence, unless otherwise specified that a certain sequence must be followed.
[0060] The first embodiment of the present invention provides a method for creating a three-dimensional geological model based on Python and BIM. Figure 1 Provide detailed explanation.
[0061] like Figure 1 As shown, in step S100, the drilling data in the geotechnical engineering investigation data PDF file is extracted using the python library and stored in an Excel table.
[0062] Using the python library, extract the soil layer name, soil layer number, and layer bottom elevation in the borehole histogram to provide parameters for making surfaces of different strata in Civil3d software. Extract the required data in PDF to Excel files and make .csv files of different soil layers. (PDF comes from the borehole histogram in the geotechnical engineering survey report. Generally, the results of the survey project are presented in a report. The format of the borehole histogram is as follows Figure 2 shown.
[0063] The above steps specifically include:
[0064] S110, extracting drilling data of the drilling histogram in the PDF file using the pdfplumber library, wherein the drilling data includes drilling number, soil layer name, soil layer number, and layer bottom elevation data;
[0065] S120, use the pandas library to save the extracted data as an Excel file, such as Figure 3 shown.
[0066] Specifically, the process of data extraction is implemented by Python programming:
[0067] (1) First, import the corresponding database packages: (pandas and pdfplumber) The pandas library is one of the four basic libraries for machine learning. It has powerful data analysis capabilities and processing tools. It supports data addition, deletion, modification, and query; supports time series analysis functions; supports flexible processing of missing data; has a rich set of data processing functions; and has a fast, flexible, and expressive data structure. pdfplumber is a PDF parsing library developed entirely in Python. It is based on pdfminer and can obtain specific information about each character, rectangle, line, and other objects, and can also extract text and tables.
[0068] (2) Prepare to traverse the specific information of objects such as characters, rectangles, lines, etc. in the entire PDF file.
[0069] (3) Define an open file path and a save file path.
[0070] (4) Select the text information and data information in the traversal PDF. The text to be traversed includes (drilling hole number, soil layer name, layer bottom elevation, soil layer number).
[0071] (5) Save the list formed by the traversed borehole numbers into a newly created Excel table (only one column); save the list formed by the soil layer names into a newly created Excel table (the first row); read the remaining information from the bottom elevations of different layers and place them in the positions corresponding to the borehole numbers and soil layer names.
[0072] (6) Export to Excel file.
[0073] like Figure 1 As shown, in step S200, the different stratum data required for surface modeling are extracted from the Excel table and saved as .csv files of different strata, such as Figure 4 shown.
[0074] Specifically, the content required for modeling, such as layer bottom elevation and soil layer name, in the geotechnical engineering investigation report is extracted according to the Python library. What is needed for surface modeling are the hole position coordinates, soil layer name and layer bottom elevation. In the exported Excel file, different stratigraphic information is processed (as many Excel files as there are soil layers), and the file only needs to contain XY coordinates and soil layer elevation and be saved as a .csv file.
[0075] like Figure 1 As shown, in step S300, based on the .csv files of different strata, Civil3d software is used to generate three-dimensional geological surfaces of different strata, and three-dimensional geological entities are generated according to the three-dimensional geological surfaces.
[0076] Specifically, according to the prepared .csv file, open Civil3d software and generate a three-dimensional geological surface as follows: 1. Surface - Create Surface - Modify Surface Name (Change to Soil Layer Name) - Add Point File to the Created Surface (Here the Point File is the .csv file) - Generate a three-dimensional geological surface, such as Figure 5 and Figure 6 As shown in the figure. Because there may be many strata, multiple .csv files will be required. Repeat the steps to generate multiple 3D geological surfaces.
[0077] Then, in Civil3D software, the steps to generate 3D geological entities from 3D geological surfaces are as follows: 1. Select the 3D geological surface - select "Extract from surface" - "Extract entity from surface" - modify the 3D entity color - click the "OK" button - create the 3D geological entity, such as Figure 7 and Figure 8 shown.
[0078] A three-dimensional entity requires more than two terrain surfaces to generate a three-dimensional entity, and the surface surface cannot constitute a three-dimensional entity alone. If you want to make a refined three-dimensional entity, you need multiple files (coordinate points, graphic files, DEM files, contour lines, etc.).
[0079] To create multiple 3D geological entities, you can convert 3D surfaces into 3D entities one by one, or you can use the Dynamo visual programming player, such as Fig. 9 As shown, according to the node file that has been written, you only need to select the file path and save the file path, and you can save different files multiple times, solving the trouble of exporting one file at a time.
[0080] like Figure 1 As shown, in step S400, the geometric information and geometric model of the three-dimensional geological entity are converted into a .sat file using Dynamo visual programming.
[0081] Specifically, using Dynamo visual programming: original node package Select Object (used to select the created 3D geological entity) - file path (node description: allows you to select a file on the system to return its file path) - Object.Geometry (node description: convert the geometric information and geometric form of the generated 3D geological entity into Dynamo object display) - Geometry.ExportTOSAT (node description: can import the specified geometric information into the path of a given sat file). This step is to convert the 3D geological entity into a .Sat file, such as Fig.10 shown.
[0082] The design content of this programming is mainly to convert the geometric information and geometric model of the three-dimensional entity into a .sat file for design in Revit software. Nodes come from nodes in Dynamo visual programming. Nodes are functions and objects in Dynamo. A node represents a data processing. Dynamo program scripts connect nodes according to certain logical relationships through wires to achieve program processing and geometric model creation. It is equivalent to a small piece of code in Python to solve different problems. Just use line connections in Dynamo to achieve the desired results.
[0083] like Figure 1 As shown, in step S500, the .sat file of the three-dimensional geological entity is imported into the Revit software for BIM model construction and design.
[0084] The specific operations are as follows:
[0085] S510, open Revit software, create a new family file - define material properties - save the file - change the file suffix (the original suffix of the new family file is .rfa file, change it to .rft file, which does not affect the opening of the file);
[0086] S510, using Dynamo visual programming to import the .sat file of the three-dimensional geological entity into the Revit software to obtain the family file of the three-dimensional geological entity, file path node package (used to select the generated .sat file) - file.FromPath node (used to create a file object from the path) - Geometry.ImportFromSAT node (used to import a sat file and return an array of imported geometric figures) - Geometry.Scale node (proportional scaling around the origin, this ratio can be determined according to the required three-dimensional geological display size) - Springs.FamilyInstance.ByGeometry node (create a group model of the three-dimensional geological entity through the Revit family file generated in step S510 and the proportionally scaled file. Note here: the remaining node packages are all provided by the Dynamo software, and the Springs.FamilyInstance.ByGeometry node needs to be downloaded and installed online before it can be used), such as Fig.11 As shown;
[0087] S510, the steps to import the generated 3D geological entity family file into the Revit project are as follows: Fig.12 As shown in the figure: Create a new building template in Revit - switch to the family file created in step S510 - click Load into Project (Load with Project and Close) - then the family file of the 3D geological entity can be imported into the Revit project. The 3D geological model formed by Revit is as follows Fig.13 As shown, construction and design can be added to the 3D geological model, such as Fig.14 shown.
[0088] Corresponding to the above-disclosed method for creating a three-dimensional geological model based on Python and BIM, the embodiment of the present invention also discloses a system for creating a three-dimensional geological model based on Python and BIM, such as Fig.15 As shown, it specifically includes:
[0089] PDF parsing module, which is used to extract drilling data from geotechnical engineering survey PDF files using Python library and store them in Excel tables;
[0090] Modeling data extraction module, used to extract different stratum data required for surface modeling from Excel tables and save them as .csv files of different strata;
[0091] 3D geological entity creation module, which is used to generate 3D geological surfaces of different strata based on .csv files of different strata using Civil3d software, and generate 3D geological entities based on the 3D geological surfaces;
[0092] File conversion module, used to convert the geometric information and geometric model of three-dimensional geological entities into .sat files using Dynamo visual programming;
[0093] The model design module is used to import the .sat file of the three-dimensional geological entity into the Revit software for BIM model construction and design.
[0094] It should be noted that for the detailed description of a three-dimensional geological model creation system based on Python and BIM provided in an embodiment of the present invention, reference can be made to the relevant description of a three-dimensional geological model creation method based on Python and BIM provided in an embodiment of the present application, which will not be repeated here.
[0095] In addition, an embodiment of the present invention further provides an electronic device, comprising: a processor and a memory; the memory is used to store one or more program instructions; the processor is used to run one or more program instructions to execute the steps of a three-dimensional geological model creation method based on Python and BIM as described in any of the above items.
[0096] It should be noted that, for a detailed description of an electronic device provided in an embodiment of the present invention, reference can be made to the relevant description of a three-dimensional geological model creation method based on Python and BIM provided in an embodiment of the present application, which will not be repeated here.
[0097] In addition, an embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, the steps of a method for creating a three-dimensional geological model based on Python and BIM as described in any of the above items are implemented.
[0098] It should be noted that, for a detailed description of a computer-readable storage medium provided in an embodiment of the present invention, reference can be made to the relevant description of a three-dimensional geological model creation method based on Python and BIM provided in an embodiment of the present application, which will not be repeated here.
[0099] Those skilled in the art will appreciate that all or part of the functions of the various methods in the above-mentioned embodiments can be implemented by hardware or by computer programs. When all or part of the functions in the above-mentioned embodiments are implemented by computer programs, the program can be stored in a computer-readable storage medium, and the storage medium can include: read-only memory, random access memory, disk, optical disk, hard disk, etc., and the program is executed by a computer to implement the above-mentioned functions. For example, the program is stored in the memory of the device, and when the program in the memory is executed by the processor, all or part of the above-mentioned functions can be implemented. In addition, when all or part of the functions in the above-mentioned embodiments are implemented by computer programs, the program can also be stored in a storage medium such as a server, another computer, disk, optical disk, flash disk or mobile hard disk, and can be downloaded or copied and saved in the memory of the local device, or the system of the local device is updated, and when the program in the memory is executed by the processor, all or part of the functions in the above-mentioned embodiments can be implemented.
[0100] The above specific examples are used to illustrate the present invention, which are only used to help understand the present invention and are not used to limit the present invention. For those skilled in the art to which the present invention belongs, some simple deductions, modifications or substitutions can be made according to the idea of the present invention.
Claims
1. A method for creating a three-dimensional geological model based on Python and BIM, characterized in that: The method comprises: Use the python library to extract the drilling data from the geotechnical engineering survey PDF file and store it in an Excel table; Extract different stratum data required for surface modeling from the Excel table and save them as .csv files for different strata; Based on the .csv files of different strata, Civil3d software is used to generate 3D geological surfaces of different strata, and 3D geological entities are generated based on the 3D geological surfaces; Use Dynamo visual programming to convert the geometric information and geometric models of three-dimensional geological entities into .sat files; Import the .sat file of the 3D geological entity into Revit software for BIM model construction and design.
2. A three-dimensional geological model creation method based on Python and BIM as claimed in claim 1, characterized in that: Use the python library to extract the drilling data from the geotechnical engineering survey PDF file and store it in an Excel table, including: The pdfplumber library is used to extract the drilling data of the drilling column chart in the PDF file, wherein the drilling data includes the drilling number, soil layer name, soil layer number, and layer bottom elevation data; Use the pandas library to analyze the corresponding data information and save the extracted data as an Excel file.
3. The method for creating a three-dimensional geological model based on Python and BIM according to claim 1, characterized in that: Extract the different stratum data required for surface modeling from the Excel table and save them as .csv files for different strata, including: The data required for modeling include hole position coordinates, soil layer name and layer bottom elevation. The data required for modeling are extracted from the Excel file of each soil layer and saved as a .csv file.
4. The method for creating a three-dimensional geological model based on Python and BIM according to claim 1, characterized in that: Based on the .csv files of different strata, Civil3d software is used to generate three-dimensional geological surfaces of different strata, and three-dimensional geological entities are generated based on the three-dimensional geological surfaces, including: Create a surface and change the surface name to the soil layer name, add a .csv file to the created surface, and generate a three-dimensional geological surface; Repeat the corresponding steps to generate multiple three-dimensional geological surfaces of different strata.
5. The method for creating a three-dimensional geological model based on Python and BIM according to claim 1, characterized in that: Use Dynamo visual programming to convert the geometric information and geometric model of 3D geological entities into .sat files, including: Select the created 3D geological entity; Convert the geometric information of three-dimensional entities into Dynamo objects for display; Imports the specified geometry information into the given sat-file path.
6. A three-dimensional geological model creation method based on Python and BIM as claimed in claim 1, characterized in that: Import the .sat file of the 3D geological entity into Revit software for BIM model construction and design, including: Open Revit software, create a new family file, define material properties, save the file, and change the file extension from .rfa to .rft; Use Dynamo visual programming to import the .sat file of the three-dimensional geological entity into Revit software to obtain the family file of the three-dimensional geological entity; Create a new building template in Revit, switch to the created family file, and choose to load into the project to import the family file of the 3D geological entity into the Revit project.
7. A three-dimensional geological model creation method based on Python and BIM as claimed in claim 6, characterized in that: Use Dynamo visual programming to import the .sat file of the three-dimensional geological entity into Revit software to obtain the family file of the three-dimensional geological entity, including: Select the .sat file and import it; Obtain the geometric information of 3D geological entities based on the imported sat file; Determine the scaling ratio around the origin based on display requirements; Create a group model of 3D geological entities based on the created Revit family file and the scaled file.
8. A 3D geological model creation system based on Python and BIM, characterized in that: The system comprises: PDF parsing module, which is used to extract drilling data from geotechnical engineering survey PDF files using Python library and store them in Excel tables; Modeling data extraction module, used to extract different stratum data required for surface modeling from Excel tables and save them as .csv files of different strata; 3D geological entity creation module, which is used to generate 3D geological surfaces of different strata based on .csv files of different strata using Civil3d software, and generate 3D geological entities based on the 3D geological surfaces; File conversion module, used to convert the geometric information and geometric model of three-dimensional geological entities into .sat files using Dynamo visual programming; The model design module is used to import the .sat file of the three-dimensional geological entity into the Revit software for BIM model construction and design.
9. An electronic device, characterized in that: The device comprises: a processor and a memory; The memory is used to store one or more program instructions; The processor is used to run one or more program instructions to execute the steps of a three-dimensional geological model creation method based on Python and BIM as described in any one of claims 1 to 7.
10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of a three-dimensional geological model creation method based on Python and BIM as described in any one of claims 1 to 7 are implemented.
Citation Information
Cited By
Three-dimensional interactive project display method and system
CN121188876A
A 3D interactive project display method and system
CN121188876B