Multi-scene drill hole arrangement and plane modeling method based on BIM software

Abstract

The invention relates to the technical field of building information models, in particular to a multi-scene drilling arrangement and plane modeling method based on BIM software, which comprises the following steps: S1, reading a BIM model file, including importing terrain and line information, extracting node data, and rendering the terrain and line information into a 3D graph; s2, activating terrains and lines, including activating imported terrains and line information in software to ensure that subsequent operation is based on accurate data; s3, defining and arranging drill holes, including drawing and defining drill hole arrangement based on terrain and line information in the BIM model; s4, drilling data storage, including data conversion and standardization processing, and data storage to a cloud database; S5, plane modeling, including triangular mesh generation by using a TIN algorithm, geological feature visual presentation, editing and annotation updating; and S6, data updating and maintaining, including updating the drilling data in real time and maintaining the data in the database.

Description

Technical Field

[0001] The present invention relates to the technical field of building information modeling, and in particular to a multi-scenario drilling arrangement and plane modeling method based on BIM software. Background Art

[0002] Existing drilling arrangement methods are mostly targeted at specific geological conditions, such as coal mines, mountain railways, etc., lacking flexibility and difficult to adapt to diverse engineering needs. In addition, drilling arrangement in existing technologies is mostly a single function and cannot realize the function of plane modeling, resulting in low efficiency in geological data management and difficulty in realizing flexible definition and storage of multiple data types.

[0003] The information disclosed in this background technology section is only intended to deepen the understanding of the overall background technology of the present invention, and should not be regarded as acknowledging or suggesting in any form that the information constitutes the prior art already known to those skilled in the art. Summary of the invention

[0004] The purpose of the present invention is to provide a multi-scenario drilling arrangement and plane modeling method based on BIM software to solve the technical problems existing in the prior art.

[0005] In order to achieve the above object, the present invention adopts the following technical solutions: The present invention provides a multi-scenario drilling arrangement and plane modeling method based on BIM software, which comprises the following steps: S1. Reading BIM model files, including importing terrain and line information, extracting node data, and rendering terrain and line information into 3D graphics; S2. Activate terrain and lines, including activating imported terrain and line information in the software to ensure that subsequent operations are based on accurate data; S3. Define and arrange drilling holes, including drawing and defining drilling hole arrangement based on terrain and line information in the BIM model; S4. Drilling data storage, including data conversion and standardization processing, and data storage in the cloud database: S5, Plane modeling, including the use of TIN algorithms to generate triangulated meshes, visualization of geological features, editing and annotation updates; S6. Data updating and maintenance, including real-time updating of drilling data and maintenance of data in the database.

[0006] Preferably, step S1 comprises the following steps: S11. The user selects the "File Import" function in the BIMBase software, and the system displays a file selection dialog box; S12. After the user selects the file, the system starts the DOM parser and reads the file content node by node: for terrain nodes, the name, boundary, and level information attributes are extracted; for line nodes, the starting point, end point, and path information are extracted; S13, after the parsing is completed, the system stores the parsed information in the memory and manages it in a linked list structure; S14. Use the OpenGL library to render terrain and line information into 3D graphics, and users can rotate, zoom and view on the interface to provide an intuitive geological scene display.

[0007] Preferably, step S14 comprises the following steps: S141. Initialize OpenGL context: When the BIMBase software is started, the OpenGL context is initialized to prepare for graphics rendering; the rendering parameters are configured; S142, loading terrain and route data: Get terrain and line information from the parsed BIM model, including vertex coordinates, boundaries, and attributes; use the data parser to convert this information into a vertex format that can be used by OpenGL; S143. Create a vertex buffer object VBO: Create VBOs for the vertex data of the terrain and lines; generate buffer objects using the glGenBuffers() function and bind the data to the GPU using glBindBuffer(); S144. Writing and using shader programs: Use GLSL to write vertex shaders and fragment shaders to control the lighting, material, and color effects of graphics; define light sources and viewing angles in shaders to enhance the layering and depth of 3D scenes; S145. Rendering 3D graphics: Call glDrawArrays() or glDrawElements() function to render terrain and lines according to vertex data; convert 3D coordinates into screen coordinates through the model view projection matrix to complete the rendering process; S146, realize interactive function: Use Qt's event processing mechanism to monitor the user's keyboard and mouse input; Implement zoom, rotate and translate functions: respond to user interactions by modifying the view matrix; Among them, zoom: adjust the scale of the view matrix by using the mouse wheel; Among them, rotation: adjust the rotation angle of the view matrix through the mouse drag event; Among them, translation: adjust the position of the view matrix through the keyboard arrow keys; S147, real-time update display: When the user interacts, the 3D scene is redrawn instantly to ensure that the user can view the changes in the geological scene in real time on the interface; the system updates the display at a refresh rate of 60 frames per second to provide a smooth user experience.

[0008] Preferably, step S2 comprises the following steps: S21. The user clicks the "Activate Terrain" button in the "Exploration Test" module, and the system enters the terrain selection mode; S22. The system monitors mouse click events through the Qt signal and slot mechanism: when the user clicks on the terrain boundary, the event processing function is triggered to obtain the element at the click position; the color attribute of the selected terrain is updated using OpenGL VBO, and the highlight effect is rendered in real time; S23. After the user confirms the activation, the system pops up a prompt box to display the currently activated terrain information; S24. Users can activate line elements, and the system selects and highlights the lines through event monitoring and efficient rendering technology.

[0009] Preferably, step S3 comprises the following steps: S31. The user clicks the "Drilling Definition" button in the "Exploration and Testing" module, and the system enters the definition mode; S32. Use the mouse to select the polyline, and the system pops up a drilling definition window: the user enters the drilling number and type, and selects the drilling location; the system uses SQL statements to insert the drilling information into the database; transactions are used to ensure the atomicity of each operation to prevent data inconsistency caused by failures in the middle; S33. The user enters the "Drilling Arrangement" window, enters the work point name, estimated hole depth, color parameters, and clicks OK; S34. The system automatically generates a drilling layout model and marks the location on the map, supporting integrated display with other geological data: using GeoJSON format to generate a drilling location information file; loading the GeoJSON file through QGIS to display the drilling location on the map; overlaying the drilling model with the surrounding geological information, and users can view and adjust the details through the map interface.

[0010] Preferably, step S4 comprises the following steps: S41. The user selects the drilling number to be stored and clicks the "Store" button; S42. The system converts data through Kafka and uploads it to the RDS database: converts the data into a standardized format and uses Kafka for data stream processing; uses HTTP POST requests to transfer data to the RDS database, and the server parses and stores the data; S43. After the data is stored in the database, the system generates an operation log to record the storage status and detailed information; S44. Run ETL jobs regularly to ensure data synchronization and consistency between different storage layers.

[0011] Preferably, step S5 comprises the following steps: S51. Enter the plane modeling module and select Generate Plan: The user starts the BIMBase software and enters the "Plane Modeling" module; Click the "Generate Plan" button, and the system will automatically load the drilling data of the current project, including the coordinates, depth and geological properties of the drilling holes; The interface adopts the GUI design of Qt framework, and users can operate through the intuitive option interface to ensure the convenience and efficiency of the process; S52, generating a triangle network, comprising the following steps: S521, reading drilling coordinates; S522, constructing an initial point set and a triangle network; S53 optimizes and subdivides the triangle network, including the following steps: S531, high-precision regional segmentation: S532, Laplace smoothing: S54. Visualize TIN using matplotlib, including the following steps: S541. Draw a triangular mesh: S542, Geological attribute color coding: S55, graphic editing and real-time updating, including the following steps: S551. The system uses Qt's event processing mechanism to capture the user's editing operations on the visual interface; S552, the user can add annotations or modify the path in the diagram, and the system will update the TIN network in real time and regenerate the visualization results; S553, through the signal and slot mechanism to achieve dynamic linkage between graphics editing and visualization, to ensure the synchronization of user operations and model updates; S56, storing the graphic data into the project database, including the following steps: S561. After the plan is generated, the system stores the TIN model and related data in the project database to ensure data security and persistence; S562. Use the transaction mechanism to ensure atomicity during data storage and prevent inconsistencies caused by partial data writing; S563, recording the graphic data and its version information through SQL statements to support version control and history query; S564. Users can view, edit or go back to historical versions in subsequent visits to facilitate project management and analysis.

[0012] Preferably, step S6 comprises the following steps: S61. Set triggers in PostgreSQL to monitor insert, update, and delete operations on the drilling data table; S62. Run Python scripts regularly to perform data maintenance tasks: clean up redundant data in the database, update indexes, and improve query performance; use SQL statements to generate data reports and provide them to administrators for review; S63. After the data is changed, the system notifies the administrator via email, providing change details and recommended actions.

[0013] By adopting the above technical solution, the present invention has the following beneficial effects: The present invention can realize multi-scenario drilling arrangement and plane modeling, flexibly adapt to different geological conditions and engineering requirements, and improve the efficiency and accuracy of geological data management. BRIEF DESCRIPTION OF THE DRAWINGS

[0014] In order to more clearly illustrate the specific implementation methods of the present invention or the technical solutions in the prior art, the drawings required for use in the specific implementation methods or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are some implementation methods of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0015] Figure 1 A workflow diagram of a multi-scenario drilling arrangement and plane modeling method based on BIM software provided in an embodiment of the present invention; Figure 2 A schematic diagram of the operation of activating terrain provided by an embodiment of the present invention; Figure 3 The operation intention of activating line information provided by the embodiment of the present invention is shown; Figure 4 A schematic diagram of drilling hole definition and arrangement provided in an embodiment of the present invention; Figure 5 A schematic diagram of drilling storage provided by an embodiment of the present invention; Figure 6 A schematic diagram of plane modeling generation provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0016] The technical solution of the present invention will be described clearly and completely below in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0017] The specific implementation of the present invention is described in detail below in conjunction with the accompanying drawings. It should be understood that the specific implementation described here is only used to illustrate and explain the present invention, and is not used to limit the present invention. Embodiment 1

[0018] Combination Figures 1 to 6 As shown, the present invention provides a multi-scenario drilling arrangement and plane modeling method based on BIM software, which comprises the following steps: S1. Reading BIM model files, including importing terrain and line information, extracting node data, and rendering terrain and line information into 3D graphics; Among them, the technical solution: File parsing algorithm: Use DOM (Document Object Model) parser to parse BIM model files in IFC format. DOM parser loads the entire file into memory to build a tree structure, which facilitates random access and operation of model data.

[0019] Data storage structure: A linked list structure is used to store the parsed terrain and route information. Each node represents a building or geological element, including attributes such as name, type, and location coordinates.

[0020] Specifically, step S1 includes the following steps: S11. The user selects the "File Import" function in the BIMBase software, and the system displays a file selection dialog box; S12. After the user selects the file, the system starts the DOM parser and reads the file content node by node: for terrain nodes, the name, boundary, and level information attributes are extracted; for line nodes, the starting point, end point, and path information are extracted; S13, after the parsing is completed, the system stores the parsed information in the memory and manages it in a linked list structure; S14. Use the OpenGL library to render terrain and line information into 3D graphics, and users can rotate, zoom and view on the interface to provide an intuitive geological scene display.

[0021] Specifically, step S14 includes the following steps: S141. Initialize OpenGL context: When the BIMBase software is started, the OpenGL context is initialized to prepare for graphics rendering; the rendering parameters are configured, such as background color, lighting settings, etc., to ensure the correctness of the rendering environment.

[0022] S142, loading terrain and route data: Get terrain and line information from the parsed BIM model, including vertex coordinates, boundaries, and attributes; use the data parser to convert this information into a vertex format that can be used by OpenGL; S143. Create a vertex buffer object VBO: Create VBOs for the vertex data of the terrain and lines; Generate a buffer object using the glGenBuffers() function and bind the data to the GPU using glBindBuffer(). S144. Writing and using shader programs: Use GLSL to write vertex shaders and fragment shaders to control the lighting, material, and color effects of graphics; define light sources and viewing angles in shaders to enhance the layering and depth of 3D scenes; S145. Rendering 3D graphics: Call glDrawArrays() or glDrawElements() function to render terrain and lines according to vertex data; convert 3D coordinates into screen coordinates through the model view projection matrix to complete the rendering process; S146, realize interactive function: Use Qt's event processing mechanism to monitor the user's keyboard and mouse input; Implement zoom, rotate and translate functions: respond to user interactions by modifying the view matrix; Among them, zoom: adjust the scale of the view matrix by using the mouse wheel; Among them, rotation: adjust the rotation angle of the view matrix through the mouse drag event; Among them, translation: adjust the position of the view matrix through the keyboard arrow keys; S147, real-time update display: When the user interacts, the 3D scene is redrawn instantly to ensure that the user can view the changes in the geological scene in real time on the interface; the system updates the display at a refresh rate of 60 frames per second to provide a smooth user experience.

[0023] S2, activate terrain and lines;

[0024] Event monitoring and rendering technology: Use Qt's signal and slot mechanism to monitor the user's mouse click events. Combined with OpenGL for real-time rendering, highlight the selected elements.

[0025] Efficient rendering technology: Use OpenGL's vertex buffer object (VBO) and shader program for rendering to accelerate graphics drawing and updating.

[0026] Specifically, step S2 includes the following steps: S21. The user clicks the "Activate Terrain" button in the "Exploration Test" module, and the system enters the terrain selection mode; S22. The system monitors mouse click events through the Qt signal and slot mechanism: when the user clicks on the terrain boundary, the event processing function is triggered to obtain the element at the click position; the color attribute of the selected terrain is updated using OpenGL VBO, and the highlight effect is rendered in real time; S23. After the user confirms the activation, the system pops up a prompt box to display the currently activated terrain information; S24. Users can activate line elements, and the system selects and highlights the lines through event monitoring and efficient rendering technology.

[0027] S3, define and arrange drilling holes;

[0028] Interactive user interface and data storage: The interactive interface is designed based on the Qt framework, and QGIS is used for geographic information processing. The drilling data is stored in the PostgreSQL database, and transaction processing and index optimization are used to ensure data integrity and query efficiency.

[0029] Location identification and data integration: Use GeoJSON format to store drilling location information and integrate it with other geological data for display, ensuring the compatibility of drilling models with mapping systems.

[0030] Step S3 includes the following steps: S31. The user clicks the "Drilling Definition" button in the "Exploration and Testing" module, and the system enters the definition mode; S32. Select the polyline with the mouse, and the system pops up a drilling definition window: the user enters the drilling number and type, and selects the drilling location; the system uses SQL statements to insert the drilling information into the database; BEGIN; INSERT INTO DrillHoles (BoreholeID, Type, Coordinates) VALUES ($1, $2, $3); COMMIT; Use transactions to ensure the atomicity of each operation and prevent data inconsistency caused by failures in the middle; S33. The user enters the "Drilling Arrangement" window, enters the work point name, estimated hole depth, color parameters, and clicks OK; S34. The system automatically generates a drilling layout model and marks the location on the map, supporting integrated display with other geological data: using GeoJSON format to generate a drilling location information file; loading the GeoJSON file through QGIS to display the drilling location on the map; overlaying the drilling model with the surrounding geological information, and users can view and adjust the details through the map interface.

[0031] S4. Drilling data storage, including data conversion and standardization processing, and data storage in the cloud database: Technical solution: Cloud database management and ETL processing: Use AWS RDS and Apache Kafka to achieve remote storage and processing of drilling data, and combine ETL (Extract, Transform, Load) tools to extract, transform and load data to ensure data consistency and accessibility.

[0032] Step S4 includes the following steps: S41. The user selects the drilling number to be stored and clicks the "Store" button; S42. The system converts data through Kafka and uploads it to the RDS database: converts the data into a standardized format and uses Kafka for data stream processing; uses HTTP POST requests to transfer data to the RDS database, and the server parses and stores the data; S43. After the data is stored in the database, the system generates an operation log to record the storage status and detailed information; S44. Run ETL jobs regularly to ensure data synchronization and consistency between different storage layers.

[0033] S5, Plane modeling, including the use of TIN algorithms to generate triangulated meshes, visualization of geological features, editing and annotation updates; Technical solution: TIN algorithm and visualization: The triangulated plan view of the borehole is generated using the TIN (Triangulated Irregular Network) algorithm, and two-dimensional visualization is performed using Python's matplotlib library. The TIN algorithm forms a triangulated network by connecting irregular discrete points, which can accurately represent the spatial distribution of geological data and is suitable for terrain modeling and geological analysis.

[0034] Step S5 includes the following steps: S51. Enter the plane modeling module and select Generate Plan: The user starts the BIMBase software and enters the "Plane Modeling" module; Click the "Generate Plan" button, and the system will automatically load the drilling data of the current project, including the coordinates, depth and geological properties of the drilling holes; The interface adopts the GUI design of Qt framework, and users can operate through the intuitive option interface to ensure the convenience and efficiency of the process; S52. Generate triangle network: S521, read drilling coordinates: The system executes SQL queries (such as SELECT x, y, z FROM borehole_data WHERE project_id = ?) through the relational database PostgreSQL to extract the spatial coordinates and geological properties of all boreholes in the current project.

[0035] The data is formatted as a list containing all the drill point information as input for triangulation.

[0036] S522, constructing an initial point set and a triangle network;

[0037] Among them, the Delaunay triangulation algorithm is based on: The Delaunay triangulation algorithm is used to generate the optimal initial triangular mesh to ensure that the minimum angle of each triangle is maximized. Its characteristic is that the circumscribed circle of any triangle does not contain other data points.

[0038] Among them, C++ and CGAL libraries are used: CGAL (Computational Geometry Algorithms Library) provides efficient and stable geometric calculation algorithms suitable for processing geological data. Implemented in the C++ programming language, it can significantly improve the performance of triangulation processing of large data.

[0039] Specific steps: S5221. Generation of initial point set: Among them, data preparation: Extract the spatial coordinates (x,y,z) of the boreholes and their geological properties from the PostgreSQL database; Execute a SQL query (e.g. `SELECT x,y,z FROM borehole_data WHERE project_id = ?`) to get the data and format the result as a list of points. The coordinates are normalized: The drilling coordinates are projected and standardized to meet the requirements of plane triangulation; Use the geographic coordinate conversion tool Proj4 to ensure that the point set is in the same coordinate system; S5222, Implementation of Delaunay triangulation: Among them, triangulation calculation: Use the Delaunay triangulation function in CGAL, call the `CGAL::Delaunay_triangulation_2` function, and input the standardized point set for triangulation.

[0040] The algorithm automatically identifies and builds the optimal initial triangle mesh, ensuring that there are no other points within the circumscribed circles of all triangles.

[0041] Among them, incremental insertion and edge flipping: An incremental algorithm is used to process the dynamic addition of new data points, inserting them point by point and adjusting the existing triangle structure in real time.

[0042] After each insertion, an edge flipping operation is performed to check and optimize the triangle shape to keep the Delaunay condition satisfied.

[0043] The optimization tools provided by CGAL are used to automate the edge flipping process to ensure computational accuracy and efficiency.

[0044] S53 optimizes and subdivides triangle networks; S531, high-precision regional segmentation: Among them, the subdivision algorithm: The local segmentation strategy accurately identifies the triangular areas that need to be refined and uses appropriate methods for local optimization. Areas that require higher accuracy are identified by shape factors (such as aspect ratio) and geological features (such as abnormal rock formations).

[0045] Specific steps: S5311, Regional Identification: Calculate area and shape factor: For each triangle, calculate the area and interior angle and compare them to a preset threshold (such as triangles smaller than a certain area).

[0046] Threshold selection: Based on engineering requirements or geological complexity, set thresholds for shape factor and area (such as too small internal angle or too large aspect ratio) to identify areas that require high-precision processing.

[0047] S5312, Grid Subdivision: Midpoint subdivision method: For the identified triangles that need to be subdivided, the midpoints are inserted and divided into smaller triangles.

[0048] Update the adjacency table to ensure that new triangles connect seamlessly to the existing mesh.

[0049] Vertex Insertion: For areas with specific geological anomalies, additional data points are inserted to improve local grid accuracy.

[0050] After applying the interpolation, use edge flipping to adjust adjacent triangles and optimize the mesh quality.

[0051] S532, Laplace smoothing: Smoothing algorithm: The Laplace smoothing algorithm reduces irregular changes and improves the overall smoothness of the model by moving vertices to the average position of the neighborhood.

[0052] Specific steps: S5321. Neighborhood average calculation: For each vertex, identify the set of its immediate neighboring vertices.

[0053] Calculate the geometric center of the vertex neighborhood as the target position after smoothing.

[0054] S5322.Vertex movement: Translate the vertex along the vector direction to the calculated center of the geometry.

[0055] Keep key geological features intact and ensure the integrity of geological information by limiting the movement distance.

[0056] S5323. Iterative processing: Iteratively applies the smoothing operation until the set smoothness criterion is met or the maximum number of iterations is reached.

[0057] The mesh deformation is evaluated after each iteration and smoothing parameters are adjusted if necessary.

[0058] S54. Visualization of TIN using matplotlib: S541. Draw a triangular mesh: Technical solution: Use Python script to call matplotlib's `plot_trisurf()` function to draw a three-dimensional surface mesh and intuitively display the geological features.

[0059] Specific steps: S5411. Data preparation: The triangulated mesh data is exported to Python format, and the spatial coordinates and geological attributes of each triangle vertex are extracted.

[0060] S5412, Visual script execution: Write a Python script to generate 3D graphics using matplotlib.

[0061] Call `plot_trisurf(x,y,z,triangles=triangles,cmap='terrain')` to draw a grid with geological features labeled.

[0062] S542, Geological attribute color coding: Technical solution: Encode geological attributes (such as soil type and lithology) into triangular meshes through color mapping, and use different tones to distinguish them; Specific steps: S5421, attribute mapping: Attribute categories are mapped to preset colors based on geological attribute values.

[0063] Use the `cmap` parameter to set the color mapping scheme, such as `cmap='viridis'`.

[0064] S5422, Color Rendering: Apply color mapping to your drawings to create clearly identified graphics of geological features.

[0065] Implement legend functionality to provide users with an explanation of the color coding via plt.colorbar().

[0066] S5423, Visualization Result Optimization: Supports users to interactively adjust the color range to suit different analysis needs.

[0067] A graphical export function is provided, allowing the user to save the analysis results as a report or for further processing in other software.

[0068] S55, Graphics editing and real-time updating: S551. The system uses Qt's event processing mechanism to capture the user's editing operations on the visual interface; S552, the user can add annotations or modify the path in the diagram, and the system will update the TIN network in real time and regenerate the visualization results; S553, through the signal and slot mechanism to achieve dynamic linkage between graphics editing and visualization, to ensure the synchronization of user operations and model updates; S56. Store graphic data to the project database: S561. After the plan is generated, the system stores the TIN model and related data in the project database to ensure data security and persistence; S562. Use transactions to ensure atomicity during data storage and prevent inconsistencies caused by partial data writing.

[0069] S563. Record graphic data and its version information through SQL statements, such as INSERT INTOmodel_data(tin_data,version) VALUES(?,?) to support version control and history query.

[0070] S564. Users can view, edit or go back to historical versions in subsequent visits to facilitate project management and analysis.

[0071] S6. Data update and maintenance.

[0072] Automatic monitoring and triggers: Use PostgreSQL triggers to monitor data changes and combine Python scripts for data management and monitoring.

[0073] S61. Set triggers in PostgreSQL to monitor insert, update, and delete operations on the drilling data table: CREATE TRIGGER data_change_trigger AFTER INSERT OR UPDATE OR DELETE ON DrillData FOR EACH ROW EXECUTE PROCEDURE data_change_handler(); The data_change_handler() stored procedure is responsible for recording change logs and performing necessary data updates and maintenance.

[0074] S62. Run Python scripts regularly to perform data maintenance tasks: clean up redundant data in the database, update indexes, and improve query performance; use SQL statements to generate data reports and provide them to administrators for review; S63. After the data is changed, the system notifies the administrator via email, providing change details and recommended actions.

[0075] In summary, the innovations and advantages of the present invention are as follows: ①Flexible adaptability of multi-scenario geological drilling data: The present invention realizes flexible adaptability in a variety of complex geological scenarios, breaking through the limitation that traditional technologies are only applicable to specific geological conditions. By importing and parsing terrain and line information in BIM software, users can dynamically define and arrange boreholes according to actual geological conditions. Using advanced OpenGL rendering and Qt event processing technology, the system can highlight and activate specific terrain and lines in real time, making drilling design more interactive and flexible. This method not only improves the applicability and exploration efficiency of the system, but also effectively reduces the complexity and uncertainty caused by the diversity of geological conditions.

[0076] ② Comprehensive drilling plane modeling function: Compared with traditional methods, the present invention not only supports drilling layout, but also realizes plane modeling of drilling data by generating accurate two-dimensional plane diagrams in a BIM-based environment using the TIN algorithm. This modeling method uses the drilling information in the database for spatial triangulation and combines it with Python's matplotlib library for visualization. In this way, users can intuitively view, edit and update drilling data to ensure the dynamic integrity and accuracy of the information. In addition, the plane modeling function also supports version management and historical record query, which greatly improves the management efficiency and decision-making accuracy of geological data. This innovation significantly improves the convenience and accuracy of geological analysis and construction decision-making. Embodiment 2

[0077] This example uses the specific example of highway drilling arrangement and plane modeling. In the highway project, accurate geological analysis and drilling arrangement are performed on the complex terrain along the route (such as hills, plains and river crossing areas) to provide key data support for engineering design and construction. The following are the detailed implementation steps of this project: 1. Read BIM model file Operation process: 1.1 Import BIM model: The user selects the "File Import" function in the BIMBase software to import the BIM model file containing terrain and line information.

[0078] The system automatically starts the DOM parser, parses the file content, and extracts the terrain and route information along the highway.

[0079] 1.2 Data analysis: For terrain nodes, the system extracts information including name, boundary, level, etc.

[0080] For line nodes, the system extracts the starting point, end point, path information, etc.

[0081] 1.3 Information display: After the analysis is completed, the system renders the information into 3D graphics, and users can view the geological scenes along the highway through the interface.

[0082] 2. Activate terrain and routes Operation process: 2.1 The user clicks the "Activate Terrain" button in the "Exploration Test" module and the system enters the terrain selection mode.

[0083] 2.2 The user selects the hilly terrain with the mouse, and the system uses OpenGL to highlight it and confirm the selection.

[0084] 2.3 The system prompts "Currently activated terrain: hilly area".

[0085] 2.4 The user selects the “Activate Route” button, selects the main highway route, and the system confirms and highlights it.

[0086] 3. Define and arrange drilling holes Operation process: 3.1 In the “Exploration Test” module, the user clicks the “Drillhole Definition” button.

[0087] 3.2 The user selects the specific location where drilling is required (such as near pile number K5+300) on the interface, and the system pops up the drilling definition window.

[0088] 3.3 The user enters the drill hole number (such as G001), selects the drill hole type (such as geological drill hole), and defines the drill hole location.

[0089] 3.4 The system uses SQL statements to store drilling information in the PostgreSQL database to ensure that the data is accurate.

[0090] 3.5 The user enters the "Drilling Arrangement" window and sets the drilling point name, estimated hole depth (such as 20 meters), color and other parameters.

[0091] 3.6 The system automatically generates a drilling layout model and marks the drilling center position on the map.

[0092] 4. Drilling data storage Operation process: 4.1 The user selects the drilling number to be stored and clicks the "Store" button.

[0093] 4.2 The system standardizes the data through Kafka and transmits it to the AWS RDS database for storage.

[0094] 4.3 After the data is stored, the system generates an operation log and uses ETL tools to ensure data synchronization and consistency.

[0095] 5. Plane Modeling Operation process: 5.1 The user enters the "Plane Modeling" module and selects "Generate Plan".

[0096] 5.2 The system calls the TIN algorithm to construct a triangle mesh: All drill hole coordinates and geological properties are read from the database.

[0097] The initial mesh is generated using Delaunay triangulation and refined and optimized in high-precision areas.

[0098] 5.3 System calls Python script to use matplotlib for visualization: Draw a triangular mesh and label the geological attributes of each triangle.

[0099] Color coding helps users analyze geological features.

[0100] 5.4 Users can edit and annotate on the plan, and the system will automatically update the TIN model and display the latest visualization results.

[0101] 5.5 The system stores the generated floor plan and data in the project database and provides version management and history query functions to support engineers in subsequent decision analysis.

[0102] 6. Data Update and Maintenance Operation process: 6.1 Set up PostgreSQL triggers to monitor changes in drilling data.

[0103] 6.2 Regularly perform database maintenance tasks through Python scripts to ensure data consistency and integrity.

[0104] 6.3 After the data is changed, the system will send an email to notify the relevant engineers so that they can make timely adjustments and decisions.

[0105] In summary, the present invention has the following advantages: 1. Technical Effects: (1) Multi-scenario adaptability: This invention breaks the limitation of the existing technology that it is only applicable to a single geological scene (such as coal mines, mountain railways, etc.), and can flexibly adapt to the drilling layout requirements under various geological conditions. By importing and activating different terrain and line information in BIM software, the system can automatically adapt to different geological environments, allowing users to arrange drilling according to actual geological conditions. This multi-scenario adaptability significantly improves the flexibility and applicability of the system and reduces the complexity and uncertainty caused by the diversity of geological conditions.

[0106] (2) Efficient data processing and modeling: The present invention uses the TIN (Triangulated Irregular Network) algorithm and the incremental Delaunay triangulation algorithm to perform plane modeling of drilling data. Compared with the traditional two-dimensional layout method, triangulation can more accurately represent the spatial distribution of geological data, making the model more realistic and accurate. At the same time, through efficient data processing procedures and intelligent algorithm applications, the present invention realizes real-time data update and synchronization, improves the efficiency of model generation, and shortens the time of geological data analysis.

[0107] (3) Intuitive visualization and user interaction: Using visualization technologies such as OpenGL and matplotlib, the present invention provides efficient 3D and 2D geological model display. Users can view and analyze geological information through an intuitive graphical interface, supporting interactive operations such as zooming, rotating, and panning views. This visualization capability not only improves the display effect of geological data, but also improves the user's operating experience and decision-making ability.

[0108] (II) Economic Effects: (1) Reduce exploration costs: Through precise drilling positioning and efficient modeling process, the present invention reduces the duplication and ineffective operation of drilling operations, thereby reducing exploration costs. At the same time, the real-time data synchronization and update function reduces human intervention, reduces construction delays and rework caused by inaccurate or delayed data, and improves overall engineering efficiency.

[0109] (2) Improve resource utilization: Flexible adaptability in multiple scenarios enables more reasonable allocation and utilization of drilling resources, avoiding resource waste. Accurate geological models enable better planning and management of exploration resources and improve resource utilization efficiency.

[0110] 3. Social Effects: (1) Improve engineering safety: Through accurate geological data analysis and model prediction, the present invention can help engineers identify potential geological risks in advance, such as earthquake faults, groundwater leakage, etc., and then take effective preventive measures to improve engineering safety. (2) Promoting geological data sharing and cooperation: Through standardized data storage and management, the present invention promotes the sharing and cooperation of geological data. Engineers and project managers can access and analyze geological information through a unified platform, improving team collaboration efficiency and project management level. (3) Promoting technological progress: The multi-scenario adaptability and plane modeling technology of the present invention have promoted technological progress in the field of geological exploration and provided the industry with more efficient and advanced solutions.

[0111] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or replace some or all of the technical features therein with equivalents. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.

Claims

1. A multi-scenario drilling arrangement and plane modeling method based on BIM software, characterized in that: The steps include: S1. Reading BIM model files, including importing terrain and line information, extracting node data, and rendering terrain and line information into 3D graphics; S2. Activate terrain and lines, including activating imported terrain and line information in the software to ensure that subsequent operations are based on accurate data; S3. Define and arrange drilling holes, including drawing and defining drilling hole arrangement based on terrain and line information in the BIM model; S4. Drilling data storage, including data conversion and standardization processing, and data storage in the cloud database: S5, Plane modeling, including the use of TIN algorithms to generate triangulated meshes, visualization of geological features, editing and annotation updates; S6. Data updating and maintenance, including real-time updating of drilling data and maintenance of data in the database.

2. The multi-scenario drilling arrangement and plane modeling method based on BIM software according to claim 1 is characterized in that: Step S1 includes the following steps: S11. The user selects the "File Import" function in the BIMBase software, and the system displays a file selection dialog box; S12. After the user selects the file, the system starts the DOM parser and reads the file content node by node: for terrain nodes, the name, boundary, and level information attributes are extracted; for line nodes, the starting point, end point, and path information are extracted; S13, after the parsing is completed, the system stores the parsed information in the memory and manages it in a linked list structure; S14. Use the OpenGL library to render terrain and line information into 3D graphics, and users can rotate, zoom and view on the interface to provide an intuitive geological scene display.

3. The multi-scenario drilling arrangement and plane modeling method based on BIM software according to claim 1 is characterized in that: Step S14 includes the following steps: S141. Initialize OpenGL context: When the BIMBase software is started, the OpenGL context is initialized to prepare for graphics rendering; the rendering parameters are configured; S142, loading terrain and route data: Get terrain and line information from the parsed BIM model, including vertex coordinates, boundaries, and attributes; use the data parser to convert this information into a vertex format that can be used by OpenGL; S143. Create a vertex buffer object VBO: Create VBO for the vertex data of the terrain and lines; generate buffer objects using the glGenBuffers() function and bind the data to the GPU using glBindBuffer(); S144. Writing and using shader programs: Use GLSL to write vertex shaders and fragment shaders to control the lighting, material, and color effects of graphics; define light sources and viewing angles in shaders to enhance the layering and depth of 3D scenes; S145. Rendering 3D graphics: Call glDrawArrays() or glDrawElements() function to render terrain and lines according to vertex data; convert 3D coordinates into screen coordinates through the model view projection matrix to complete the rendering process; S146, realize interactive function: Use Qt's event processing mechanism to monitor the user's keyboard and mouse input; Implement zoom, rotate and translate functions: respond to user interactions by modifying the view matrix; Among them, zoom: adjust the scale of the view matrix by using the mouse wheel; Among them, rotation: adjust the rotation angle of the view matrix through the mouse drag event; Among them, translation: adjust the position of the view matrix through the keyboard arrow keys; S147, real-time update display: When the user interacts, the 3D scene is redrawn instantly to ensure that the user can view the changes in the geological scene in real time on the interface; the system updates the display at a refresh rate of 60 frames per second to provide a smooth user experience.

4. The multi-scenario drilling arrangement and plane modeling method based on BIM software according to claim 1 is characterized in that: Step S2 includes the following steps: S21. The user clicks the "Activate Terrain" button in the "Exploration Test" module, and the system enters the terrain selection mode; S22. The system monitors mouse click events through the Qt signal and slot mechanism: when the user clicks on the terrain boundary, the event processing function is triggered to obtain the element at the click position; the color attribute of the selected terrain is updated using OpenGL VBO, and the highlight effect is rendered in real time; S23. After the user confirms the activation, the system pops up a prompt box to display the currently activated terrain information; S24. Users can activate line elements, and the system selects and highlights the lines through event monitoring and efficient rendering technology.

5. The multi-scenario drilling arrangement and plane modeling method based on BIM software according to claim 1 is characterized in that: Step S3 includes the following steps: S31. The user clicks the "Drilling Definition" button in the "Exploration Test" module, and the system enters the definition mode; S32. Use the mouse to select the polyline, and the system pops up a drilling definition window: the user enters the drilling number and type, and selects the drilling location; the system uses SQL statements to insert the drilling information into the database; transactions are used to ensure the atomicity of each operation to prevent data inconsistency caused by failures in the middle; S33. The user enters the "Drilling Arrangement" window, enters the work point name, estimated hole depth, color parameters, and clicks OK; S34. The system automatically generates a drilling layout model and marks the location on the map, supporting integrated display with other geological data: using GeoJSON format to generate a drilling location information file; loading the GeoJSON file through QGIS to display the drilling location on the map; overlaying the drilling model with the surrounding geological information, and users can view and adjust the details through the map interface.

6. The multi-scenario drilling arrangement and plane modeling method based on BIM software according to claim 1 is characterized in that: Step S4 includes the following steps: S41. The user selects the drilling number to be stored and clicks the "Store" button; S42. The system converts data through Kafka and uploads it to the RDS database: converts the data into a standardized format and uses Kafka for data stream processing; uses HTTP POST requests to transfer data to the RDS database, and the server parses and stores the data; S43. After the data is stored in the database, the system generates an operation log to record the storage status and detailed information; S44. Run ETL jobs regularly to ensure data synchronization and consistency between different storage layers.

7. The multi-scenario drilling arrangement and plane modeling method based on BIM software according to claim 1 is characterized in that: Step S5 includes the following steps: S51. Enter the plane modeling module and select Generate Plan: The user starts the BIMBase software and enters the "Plane Modeling" module; Click the "Generate Plan" button, and the system will automatically load the drilling data of the current project, including the coordinates, depth and geological properties of the drilling holes; The interface adopts the GUI design of Qt framework, and users can operate through the intuitive option interface to ensure the convenience and efficiency of the process; S52, generating a triangle network, comprising the following steps: S521, reading drilling coordinates; S522, constructing an initial point set and a triangle network; S53 optimizes and subdivides the triangle network, including the following steps: S531, high-precision regional segmentation: S532, Laplace smoothing: S54. Visualize TIN using matplotlib, including the following steps: S541. Draw a triangular mesh: S542, Geological attribute color coding: S55, graphic editing and real-time updating, including the following steps: S551. The system uses Qt's event processing mechanism to capture the user's editing operations on the visual interface; S552, the user can add annotations or modify the path in the diagram, and the system will update the TIN network in real time and regenerate the visualization results; S553, through the signal and slot mechanism to achieve dynamic linkage between graphics editing and visualization, to ensure the synchronization of user operations and model updates; S56, storing the graphic data into the project database, including the following steps: S561. After the plan is generated, the system stores the TIN model and related data in the project database to ensure data security and persistence; S562. Use the transaction mechanism to ensure atomicity during data storage and prevent inconsistencies caused by partial data writing; S563, recording the graphic data and its version information through SQL statements to support version control and history query; S564. Users can view, edit or go back to historical versions in subsequent visits to facilitate project management and analysis.

8. The multi-scenario drilling arrangement and plane modeling method based on BIM software according to claim 1 is characterized in that: Step S6 includes the following steps: S61. Set triggers in PostgreSQL to monitor insert, update, and delete operations on the drilling data table; S62. Run Python scripts regularly to perform data maintenance tasks: clean up redundant data in the database, update indexes, and improve query performance; Use SQL statements to generate data reports and provide them to administrators for review; S63. After the data is changed, the system notifies the administrator via email, providing change details and recommended actions.

Images