Intelligent visual arrangement method and system for drill hole spacing

Abstract

The invention discloses an intelligent visual arrangement method for drill hole spacing. The method comprises the following steps: S100, constructing a universal geological survey resource library by adopting a relational database; s200, a three-dimensional visual environment is built; s300, intelligent recommendation of the distance between adjacent drill holes in the drill hole arrangement process is carried out; and S400, drill hole arrangement is carried out. The system comprises a geological survey resource library module, a three-dimensional visual environment module, an intelligent distance recommendation module, a drill hole arrangement and adjustment module and a framework supporting module. The problems that the query specification is low in efficiency and easy to omit are solved; the problem that it is difficult to summarize various data to conduct three-dimensional visual refined arrangement through an existing arrangement means is solved. The problems that traditional manual drilling arrangement is low in efficiency, and repeated inspection and multiple times of correction iteration are needed in the arrangement process are solved. The problems of data islands, disordered standard reference, difficulty in cross-scene adaptation and the like in a traditional investigation system are solved.

Description

Technical Field

[0001] This invention relates to the field of geotechnical engineering investigation technology, specifically to an intelligent and visual arrangement method and system for borehole spacing. Background Technology

[0002] As a core component of engineering geological exploration, the current methods for exploration and layout still rely on manual labor using two-dimensional CAD drawings. This involves manually compiling various formats of geological data, surface environmental data, and project design data, and then consulting relevant standards to select and arrange borehole locations. There is a lack of a unified platform for compiling, displaying, and analyzing data in three dimensions, facilitating intuitive and comprehensive consideration of multiple factors for 3D visualization and layout. Furthermore, given the diverse types of engineering projects and the numerous and detailed standards, manual searching is required for each one. There is a lack of a readily accessible data rule base that can quickly retrieve standard requirements such as borehole spacing relevant to the current project, enabling rapid and compliant layout.

[0003] Chinese patent CN117272826A describes an automatic exploration layout method based on knowledge engineering. It involves classifying several engineering areas and buildings on an existing engineering geological planar model and extracting key exploration borehole point data to create a network model, forming a knowledge base. When laying boreholes in a selected new planar model, similarity calculations are used to find similar engineering areas or building structures in the knowledge base, which are then imported into the selected planar model to complete the exploration borehole layout. However, the knowledge engineering base in this patent is a network model of exploration borehole point layouts for similar projects, not relevant standard exploration layout regulations. In this patent, regulations are only used as an auxiliary means to extract key exploration borehole point data to build the network model knowledge base and as a reference for subsequent layout adjustments; they cannot be directly used for borehole layout. Furthermore, the patent does not explain how to handle differences in exploration regulations across different industries and regions, making the method lack universality across different industries and regions. The method described in this patent is insufficient for "automatic exploration layout": Firstly, exploration includes drilling / hole drilling, tunneling, and trenching, and some industry standards also include geophysical exploration. Different exploration methods follow different layout rules, which are not uniform, and the layout of these explorations must be completed in a three-dimensional scene rather than based on an engineering geological planar model. Secondly, some new projects do not have geological data or engineering geological planar models when conducting exploration layout, and the exploration layout is often based on building layout requirements or professional knowledge. Thirdly, the exploration specifications only stipulate the principles of exploration layout, and the level of detail does not meet the requirements of "automatic layout." For example, the borehole spacing requirements in the specifications are upper and lower limit values, not fixed values. In specific engineering applications, the specific spacing values ​​cannot be directly obtained based on the specification range values, and automatic exploration layout cannot be completed.

[0004] Chinese patent CN116304152A proposes an intelligent display system for exploration results based on GIS+BIM, covering the field of exploration results display. It includes modules for borehole data acquisition, engineering location display, exploration point and status display, exploration point borehole details display, 2D / 3D geological display, and bedrock contour line display. This patent focuses on end-to-end data management and 3D visualization. While it mentions borehole layout, it does not address the borehole layout process, nor does it cover intelligent spacing recommendations.

[0005] Chinese patent CN202411874299.3 proposes an intelligent visualization processing method and system for geological data. Its core is to generate geological profile maps by estimating secondary borehole coordinates from original boreholes. This belongs to a different technical direction than "intelligent recommendation and three-dimensional layout of borehole spacing," lacking a standardized resource library and spacing adjustment mechanism. In summary, existing technologies lack a solution that simultaneously supports multiple standards, three-dimensional visualization layout, and intelligently recommends borehole spacing, requiring urgent breakthroughs. Summary of the Invention

[0006] The purpose of this invention is to provide an intelligent and visual arrangement method and system for borehole spacing, addressing the aforementioned technical problems.

[0007] The technical solution of the present invention: A method for intelligent and visually-based borehole spacing arrangement includes the following steps: S100: A universal geological exploration resource database is constructed using a relational database, and forms are used to record the borehole spacing requirements under different engineering conditions in exploration specifications of different industries; S200: Builds a 3D visualization environment, enabling drilling layout in different scenarios to be completed in a visual way, and intuitively displays the layout results; S300: Intelligent recommendation of the spacing between adjacent boreholes during the borehole layout process. Based on the exploration specifications to be implemented in the specific project, the corresponding borehole spacing is retrieved from the resource library, and the range of borehole spacing is intelligently recommended according to the recorded values ​​in the resource library. S400: Drilling layout. Based on the recommended spacing values ​​and the actual engineering conditions, the specific spacing values ​​are determined, and the drilling positions are displayed graphically in the constructed 3D visualization environment. In step S200, the 3D visualization environment is built using a graphics rendering engine based on WebGL or OpenGL.

[0008] In step S200, the three-dimensional visualization environment consists of a three-dimensional window and general controls, which are used to support adjusting and locking the viewpoint of the three-dimensional window. When locked, it is equivalent to a two-dimensional window and supports two-dimensional visualization layout. The general controls include zoom, coordinate ruler, query and measurement functions to assist in completing the drilling layout.

[0009] In step S200, the scenario includes importing basic data and using the basic data as a background for drilling layout and free layout.

[0010] A system for intelligent and visually arranged borehole spacing includes a geological exploration resource database module, a three-dimensional visualization environment module, an intelligent spacing recommendation module, a borehole arrangement and adjustment module, and an architecture support module. The geological exploration resource database module is deployed on the S end and is used to store borehole spacing data corresponding to exploration specifications of different industries and regions, supporting data addition, editing and retrieval; The 3D visualization environment module is deployed on the B-end or C-end to build a visualization interface for multi-source model integration, providing viewpoint adjustment, general control operation and 3D capture functions; The spacing intelligent recommendation module is deployed on the application server and is used to receive engineering information, calculate and retrieve resource library and generate candidate spacing values ​​through calculation; The drilling layout and adjustment module is deployed at end B or end C and is used to realize batch layout, area selection adjustment and single-point editing. The architecture support module is used to realize communication between the S-end, application server and B-end / C-end, and supports B / S and C / S dual architecture operation.

[0011] The geological exploration resource database module uses a MySQL relational database, is hosted on a database server running Windows or Linux, and connects to the application server via TCP / IP protocol.

[0012] The 3D visualization environment is implemented through a graphics rendering engine based on WebGL or OpenGL, supporting the rendering of 3D models on a Canvas. When importing a model, a coordinate transformation subroutine is used to convert between the spherical coordinate system and the local Cartesian coordinate system of the project, with a conversion error of ≤0.5m.

[0013] The architecture support module supports multi-device access: devices with Windows and Linux operating systems can access via B / C terminals, while Android devices can access via B terminals; it also supports permission management, with three levels of permissions: administrator, editor, and viewer.

[0014] The C-end has offline storage capabilities, allowing the download of geological exploration resource databases to the local machine and the completion of borehole layout even when offline; it also has version management capabilities, supporting the saving of 3-5 historical layout versions; the B-end supports multi-user online collaborative editing, allowing access only from internal network IP addresses to ensure data security.

[0015] The beneficial effects of this invention are: This invention uses a relational database to construct a universal geological exploration resource database. It uses forms to record the borehole spacing requirements under different engineering conditions in exploration specifications of different industries. This can be directly used for subsequent borehole layout, solving the problems of low efficiency and easy omission in traditional manual specification queries. The dynamic configuration significantly improves the flexibility and maintainability of the geological exploration resource database, adapting to different engineering needs. This invention establishes a three-dimensional visualization interface based on a WebGL or OpenGL graphics rendering engine, which can integrate preliminary geological information, surface environment information, and project architectural design information. It performs three-dimensional fine-grained layout of boreholes based on comprehensive consideration of multiple factors, solving the problem that existing layout methods are difficult to collect multiple data for three-dimensional visualization and fine-grained layout. It significantly improves the accuracy of borehole layout under complex surrounding environment, geology, design and other conditions. This invention provides intelligent recommendations for the spacing between adjacent boreholes during the borehole layout process. Based on the exploration specifications to be followed in the specific project, it retrieves the corresponding borehole spacing from the geological exploration resource database, intelligently recommends a range of borehole spacing based on the recorded values ​​in the database, and determines the specific spacing value in combination with the actual project situation. It adopts multiple layout methods to complete and quickly lay out the boreholes, achieving rapid layout while ensuring compliance with the requirements of the borehole layout. This solves the problems of low efficiency and the need for repeated checks and multiple corrections and iterations in traditional manual borehole layout. This application employs a multi-architecture software system. The geological exploration resource database is deployed on the server side, facilitating sharing among multiple members. Member permissions are configured, ensuring version consistency by granting specific deployment personnel configuration permissions. Other deployment members only need to master query and access functions, lowering the learning curve. The B / S architecture enables collaborative editing by multiple members and intranet security control, while the C / S architecture supports offline access to the geological exploration resource database and local deployment. This multi-architecture software system addresses the pain points of traditional exploration systems, such as data silos, chaotic specification references, and difficulties in cross-scenario adaptation. It is particularly suitable for complex geological conditions, multi-team collaboration, and highly confidential engineering scenarios. Attached Figure Description

[0016] Figure 1 This is a flowchart of the steps provided by the present invention; Figure 2 This is a schematic diagram of the three-dimensional visualization environment provided by the present invention; Figure 3 This invention provides a schematic diagram of the application of geological exploration resource database and the intelligent arrangement of borehole spacing in a three-dimensional visualization environment that comprehensively considers other information. Figure 4 This is a schematic diagram of the software system architecture provided by the present invention. Detailed Implementation

[0017] Example 1: refer to Figure 1 - Figure 3 A method for intelligent and visually arranged borehole spacing includes the following steps: S100: A universal geological exploration resource database is constructed using a relational database, and forms are used to record the borehole spacing requirements under different engineering conditions in exploration specifications of different industries; Specifically, the geological exploration resource database consists of multiple forms that record the values ​​of geological exploration terms in geological exploration specifications across different industries and regions. Drill spacing is one of these terms, and the drill spacing form records the requirements for the range of drill spacing values ​​in different exploration specifications for different types and levels of projects at various exploration stages.

[0018] In this application, the survey specifications include national general specifications, such as the "Code for Geotechnical Engineering Survey" (GB 50021), industry-specific specifications for various sectors, such as the "Code for Geological Survey of Highway Engineering" (JTG C20), the "Code for Geological Survey of Railway Engineering" (TB 10012), the "Code for Geological Survey of Water Conservancy and Hydropower Engineering" (GB 50487), the "Code for Geotechnical Engineering Survey of Thermal Power Plants" (GB / T 51031), and local specifications, such as the "Code for Geotechnical Engineering Survey of Urban Rail Transit in Zhejiang Province" (DB33 / T 1126) and the "Code for Survey of Expressways in Loess Areas" (DB62 / T 2993).

[0019] Referring to Table 1, the geological exploration resource database contains some form fields. The standard selected is the "Code for Geotechnical Engineering Investigation" (GB50021). The extracted fields include project type, exploration stage, project grade, and corresponding combinations of borehole spacing ranges, borehole depths, and borehole quantity requirements. Among them, the project type values ​​include slopes, caverns, buildings and structures, and foundation treatment; the exploration stage values ​​are preliminary exploration, detailed exploration, and construction exploration; other fields such as karst development areas, fault fracture zones, soft soil or liquefiable strata, landslides, and weak interlayers are supplementary fields; and the recommended ranges of borehole spacing for various combinations of these fields are obtained from the standard; the project grade values ​​are Level 1, Level 2, and Level 3, with special supplementary requirements for pile foundation engineering, karst development areas, and areas with high earthquake intensity. Table 1: Some Form Fields in the Geological Exploration Resource Database Furthermore, the geological exploration resource database supports dynamic configuration. Personnel with configuration permissions can customize and add new specifications and information fields such as borehole spacing, and combine them. They can also assign range values ​​to fields such as borehole spacing, and freely combine, delete, and adjust configured items.

[0020] S200: Builds a 3D visualization environment, enabling drilling layout in different scenarios to be completed in a visual way, and intuitively displays the layout results; The 3D visualization environment is built using a WebGL or OpenGL-based graphics rendering engine. This environment allows for the import of engineering layout plans or 3D models. The 3D visualization environment includes a 3D surface model, architectural design base maps, and the approximate vertical projection area of ​​the 3D model of the karst development region onto the surface, obtained through geophysical methods. The 3D models of the surface and karst caves are .iobj format files created using CnGIM_ma software, while the architectural design base maps are .dwg format 2D model CAD files. These 2D and 3D model files are preprocessed and transformed into a unified visualization model within the engineering local coordinate system.

[0021] The 3D visualization environment consists of a 3D viewport and general controls, used to support adjusting and locking the viewport's perspective. The perspective includes six fixed options: top view, bottom view, south view, north view, west view, and east view. Manual adjustment is also supported. Generally, the top viewport is selected and locked during borehole layout. Once locked, it functions like a 2D viewport, supporting 2D visualization. After layout, other fixed views can be switched or manually adjusted, facilitating inspection and adjustment of the borehole layout from a 3D perspective. General controls can be used to assist in borehole layout. These controls include zoom, coordinate ruler, query, and measurement functions. The coordinate ruler and query functions help accurately locate borehole layout points. Measurement can be used to obtain borehole spacing and distances between boreholes and objects such as building outlines to determine if the relative positions of the boreholes are appropriate. Zoom can be used for overall preview and detailed viewing when the layout area is large, assisting in completing the borehole layout.

[0022] The scenario includes importing basic data and using that data as a background for drilling layout and free layout.

[0023] The 3D viewport environment supports importing basic data and using it as a background for borehole layout. Basic data includes topographic maps, building layout designs, or 3D geological models. Topographic maps can include surface GIS models obtained from aerial photography, satellite remote sensing, and contour CAD files; building layout designs can include 2D CAD files and 3D BIM models from various mainstream BIM software; and 3D geological models can include model file formats from various mainstream 3D geological software. The process of importing into a 3D visualization environment involves preprocessing the acquired basic data and converting it into a unified visualization model under a local engineering coordinate system. For example, multiple control point coordinates can be extracted from a 2D CAD file for coordinate transformation, and surface GIS models obtained from aerial photography and satellite remote sensing can be converted into corresponding model files based on the relationship between the spherical coordinate system and the local engineering Cartesian coordinate system. It supports model file formats of various mainstream BIM software, such as .rvt, .dgn, .pln, etc.; model file formats of various mainstream 3D geological software, such as .dm, .str, .ts, .obj, .iobj, .stl, etc.; and model file formats of various 2D electronic drawings, such as .dwg, .dxf, etc. It supports precise drilling and layout along any specified line in the imported basic data in a 3D visualization environment using functions such as 3D snapping. 3D snapping means that when the layout personnel select the vicinity of the line, it automatically and accurately moves to the nearest node on the line.

[0024] Free layout allows for the creation of boreholes within a 3D visualization environment, based on the professional knowledge and requirements of the personnel. This includes circular, rectangular, and random layouts. Rectangular layouts are achieved by setting the borehole spacing along the length and width of a rectangle, suitable for foundation surveys of ordinary buildings. Circular layouts are achieved by setting the borehole spacing along an arc, suitable for surveys of circular above-ground or underground structures such as towers and underground gas / oil storage tanks. Random layouts allow for the arbitrary selection of borehole locations for supplementary arrangements based on rectangular or circular layouts.

[0025] S300: Intelligent recommendation of the spacing between adjacent boreholes during the borehole layout process. Based on the exploration specifications to be implemented in the specific project, the corresponding borehole spacing is retrieved from the resource library, and the range of borehole spacing is intelligently recommended according to the recorded values ​​in the resource library. Specifically, in specific engineering applications, the required range of borehole spacing values ​​are retrieved from the geological exploration resource database based on information such as the exploration specifications, engineering grade, and stage that the project should follow, and these values ​​are used as recommended values ​​for borehole layout. In this embodiment, the project type is residential buildings and structures, the exploration stage is detailed exploration, the project level is level two, and the location is a low-intensity seismic area. The geological exploration resource database is automatically queried to obtain a recommended borehole spacing range of 15-30m. The boreholes are arranged in a rectangular layout in a 3D environment using a locked top view, with the same spacing in both length and width directions. The default spacing is a multiple of 0.5. Based on the overall layout area, the borehole spacing is automatically calculated to be 20m, and this is used for the overall area layout. After the overall area layout is completed, boreholes in the circular tower, the central high-rise building, and the karst development area are batch-selected and deleted. The circular tower pile foundation area is supplemented according to the special information in the geological exploration resource database. Based on the requirements and the overall layout rules, the boreholes are arranged in a circular pattern with a spacing of 10m and 8m, gradually transitioning from the outside to the inside. The center of each circle is randomly selected for supplementary arrangement. In the central high-rise building pile foundation area, based on the special supplementary requirements in the geological exploration resource database and the overall layout rules, a rectangular pattern with a borehole spacing of 10m is used. Boreholes in karst development areas are batch-selected and deleted. In karst development areas, a rectangular pattern with a borehole spacing of 5m is used, based on the special supplementary requirements in the geological exploration resource database and the overall layout rules. After completing the planar layout, the planar borehole layout points can be vertically projected onto the three-dimensional ground surface to obtain the actual three-dimensional coordinates of the borehole layout points.

[0026] When performing borehole layout operations, the software system uses the built-in computer code to index the specific engineering exploration specifications, engineering type, engineering level, and exploration stage, and links to the borehole spacing form in the geological exploration resource database to retrieve the required range of drilling rig spacing, which serves as the intelligent recommended spacing value range.

[0027] S400: Drilling layout. Based on the recommended spacing values ​​and the actual engineering conditions, the specific spacing values ​​are determined, and the drilling positions are displayed graphically in the constructed 3D visualization environment. Specifically, based on the range values, and according to the actual engineering conditions, following general principles such as the number of boreholes being an integer, uniform arrangement, and the spacing between boreholes being an integer multiple of the set increment, the specific borehole spacing is intelligently determined within the recommended range for borehole arrangement. Based on the layout area and method, and following general principles such as the number of boreholes being an integer, equal spacing between boreholes, and the layout spacing being an integer multiple of the set increment, a recommended value is obtained by comprehensively judging within the recommended range. If the layout area is rectangular, the default length and width spacing are the same, and the layout spacing is an integer multiple of the set increment. The layout personnel can adjust the increment value themselves. According to these setting principles, the background automatically matches and calculates the layout area to obtain a comprehensive value. If there are multiple comprehensive values, the middle larger value is taken by default. The layout personnel can also freely select from multiple comprehensive values.

[0028] After the overall batch layout is completed, the boreholes in the area can be selected and adjusted in batches according to the characteristics of the local area in the 3D visualization environment. For example, if the area contains unfavorable geological bodies such as faults and karst caves, the range needs to be narrowed; the borehole spacing requirements will also be different when the underground design of the selected area is a pile foundation. After the overall batch layout is completed, the position of any drill hole in the batch layout can be adjusted in a 3D visualization environment to meet specific layout requirements. For example, if a drill hole exceeds the layout area after uniformly arranging the layout according to a rectangle, the drill hole needs to be deleted or moved to the layout area. Example 2: refer to Figure 4 A system for intelligent and visually arranged borehole spacing includes a geological exploration resource database module, a three-dimensional visualization environment module, an intelligent spacing recommendation module, a borehole arrangement and adjustment module, and an architecture support module. The geological exploration resource database module is deployed on the S end and is used to store borehole spacing data corresponding to exploration specifications of different industries and regions, supporting data addition, editing and retrieval; The 3D visualization environment module is deployed on the B-end or C-end to build a visualization interface for multi-source model integration, providing viewpoint adjustment, general control operation and 3D capture functions; In this application, S-end is the database server, B-end is the browser, and C-end is the client; The geological exploration resource database module uses a MySQL relational database, hosted on a Windows or Linux system database server, and connects to the application server via TCP / IP protocol, with a data read / write response time of ≤2s.

[0029] Specifically, the geological exploration resource database is deployed on the S-end, supporting access and editing via B-end or C-end for devices with operating systems such as Windows and Linux, and access and editing via B-end for mobile devices with operating systems such as Android, facilitating multi-member sharing of the geological exploration resource database. It supports setting member permissions, where deployment personnel with configuration permissions can dynamically configure the geological exploration resource database as described in step S100, while other deployment members without configuration permissions can only view it. This avoids data pollution caused by unprofessional personnel accidentally deleting or modifying standardized data (such as borehole spacing intervals and engineering grade classifications) in the geological exploration resource database, ensuring consistency of the applicable version for all members. It also reduces training costs: ordinary members do not need to learn the complex configuration logic of the geological exploration resource database, only needing to master the query and call functions, lowering the learning curve.

[0030] The spacing intelligent recommendation module is deployed on the application server and is used to receive engineering information, search the resource library, and generate candidate spacing values ​​through calculation. The intelligent recommended borehole spacing visualization layout can be completed on either the B-end or the C-end, both through web or client-side operation commands. Commands include rectangular layout, circular layout, along-line layout, and single-point layout mentioned in previous steps, allowing for local adjustments via selection to delete or modify. The two architectures cater to specific application requirements. Layout on the B-end requires an internet connection but supports multi-member online collaborative work and intranet security control. Layout on the C-end supports both online and offline environments. In offline environments, the downloaded offline geological exploration resource library can be queried for offline layout operations. Client-side operation allows for local saving of multiple versions and more refined operations compared to the B-end.

[0031] The drilling layout and adjustment module is deployed at end B or end C and is used to realize batch layout, area selection adjustment and single-point editing. The architecture support module is used to enable communication between the S-end, application server and B-end or C-end, and supports B / S and C / S dual architecture operation.

[0032] The 3D visualization environment is implemented through a graphics rendering engine based on WebGL or OpenGL, supporting the rendering of 3D models on a Canvas. When importing a model, a coordinate transformation subroutine is used to convert between the spherical coordinate system and the local Cartesian coordinate system of the project, with a conversion error of ≤0.5m.

[0033] The Cartesian coordinate system is a mathematical coordinate system that describes geometric figures using algebraic methods. It was created by the French mathematician René Descartes. Its core is to determine the position of a point in a plane or space using numerical coordinates. It is a fundamental tool for describing position, motion, and shape in modern mathematics, physics, engineering, and other fields. In this patented technical solution, the role of the Cartesian coordinate system is to unify the spatial reference of multi-source models: after converting the surface GIS model (usually based on a spherical coordinate system) obtained by aerial photography and satellite remote sensing into a local Cartesian coordinate system specific to the project, it can be aligned with the coordinate system of two-dimensional CAD architectural drawings and three-dimensional geological models, so that the position of the borehole layout (such as x=1000m, y=500m, z=0m, where the z-axis represents the ground elevation) remains consistent in all models, ultimately achieving the core requirement of "precisely placing boreholes in a three-dimensional visualization environment".

[0034] Canvas rendering of 3D models refers to using HTML5... <canvas>Elements, acting as drawing containers, are a technology that uses JavaScript programming to visualize 3D models on web pages or client interfaces. The core principle is to simulate 3D spatial effects on a 2D Canvas through mathematical calculations (such as matrix transformations and perspective projection), converting the vertices, textures, and colors of the 3D model into 2D pixels, ultimately presenting a three-dimensional graphic on the screen.

[0035] In this patented technical solution, the specific applications of Canvas rendering of 3D models include: Model data parsing: The imported 3D geological models (such as .obj and .stl formats) and building BIM models (such as .rvt format) are parsed into basic data such as vertex coordinates, face indices, and texture coordinates.

[0036] 3D spatial calculation: Using JavaScript to implement transformations such as perspective projection matrix and model-view matrix, the vertex coordinates of the 3D model are converted into 2D coordinates on the Canvas, simulating the effect of the human eye observing 3D objects as larger when closer and smaller when farther away.

[0037] Rendering: Based on the parsed model data, the model is drawn point by point and surface by surface on the Canvas, including filling colors, overlaying textures, and handling lighting effects (such as simulating the changes in light and shadow caused by sunlight) to make the 3D model look realistic.

[0038] Interactive response: Listen for mouse and keyboard events, and update the rendering results on the Canvas in real time by modifying the matrix parameters of the model's rotation angle, scaling ratio, or translation position, so as to realize interactive operations such as rotation, scaling, and translation of the 3D model.

[0039] The architecture support module supports multi-device access: devices with Windows and Linux operating systems can access via B / C terminals, while Android devices can access via B terminals; it also supports permission management, divided into three levels of permissions: administrator, editor, and viewer; administrators can modify the resource library, editors can place drills, and viewers can only browse.

[0040] The C-end has offline storage capabilities, allowing the download of geological exploration resource databases to the local machine and the completion of borehole layout even when offline; it also has version management capabilities, supporting the saving of 3-5 historical layout versions; the B-end supports multi-user online collaborative editing, allowing access only from internal network IP addresses to ensure data security.

[0041] Specifically, the implementation process of this application method is as follows: Taking the borehole layout in the detailed survey stage of a certain secondary housing construction project as an example, the implementation steps of the method are as follows: Geological exploration resource database construction (S100): The resource database is constructed using a MySQL database. Standard information forms are entered with the "Code for Geotechnical Engineering Investigation" GB 50021, and engineering attribute forms are entered with "Buildings and Structures - Level II - Detailed Investigation". The borehole spacing form is entered with the spacing range of 15-30m for "Low Seismic Intensity Areas" and the adjustment range of 5-10m for "Karst Development Areas". The administrator adds the "Code for Geological Investigation of Highway Engineering" JTG C20 through the C-end editing interface and supplements the spacing range of 20-40m for "Highway Subgrade - Level III - Preliminary Investigation".

[0042] 3D visualization environment setup (S200): The environment is set up in the Chrome browser using WebGL. Import the project's .dwg format architectural base map (control point coordinates X=1000m, Y=500m; X=1200m, Y=500m; X=1000m, Y=700m), .iobj format surface model, and .stl format karst model. The spherical coordinate system of the surface model is converted to the local coordinate system of the project through a coordinate transformation subroutine to achieve the overlay of the three models with an overlay error of 0.3m. Select the top view and lock it, and call the scaling control to enlarge the layout area (200m×200m) to full screen.

[0043] Intelligent Spacing Recommendation (S300-S400): In the engineering information input module, enter "GB 50021 - Buildings and Structures - Level II - Detailed Investigation - Low Seismic Intensity Areas", and click search. The system will return a spacing range of 15-30m within 2 seconds. In the trial calculation module, enter the area of ​​the layout area and the rectangular layout method, set the increment to 0.5m, and the trial calculation will yield candidate values ​​of 18m, 20m, and 22m. The default selection is 20m.

[0044] Drilling layout and adjustment (S500): Click the "Rectangular layout" button to select the area, and the system will automatically generate 11×11=121 boreholes (red dots, 5mm in diameter); select the karst development area (30m×30m) by selecting the area, and the system will adjust the spacing of the area to 8m and add 15 boreholes; drag 3 boreholes that exceed the building outline into the area by single-point editing, delete 2 boreholes located above underground pipelines, and complete the layout.

[0045] Specifically, the system components and their connections in this application Geological exploration resource database module: Deployed on a Dell PowerEdge R750 database server (Windows Server 2019 system), it stores three types of form data; it connects to the application server (Dell PowerEdge R650) via TCP / IP protocol. The application server runs a retrieval program written in Java. When it receives a spacing query request, it retrieves the resource database data through SQL statements and returns it.

[0046] 3D visualization environment module: On the B-end, a Canvas is used as the rendering medium, integrating a model import subroutine (handling multi-format models), a view control subroutine (implementing switching between 6 fixed viewpoints), and a general control subroutine (responding to scaling, measurement, and other operations); the 3D capture function is implemented by JavaScript listening to the mouse position, and when the distance between the mouse and the model lines is ≤0.3m, the coordinate snapping algorithm is triggered.

[0047] The spacing intelligent recommendation module is deployed on the application server and includes an information receiving subroutine (receiving engineering information), a resource library interaction subroutine (calling resource library data), and a trial calculation subroutine (generating candidate values ​​according to rules). During the trial calculation, the number of boreholes corresponding to different spacings is calculated in a loop, and candidate values ​​that meet the criteria of "integer number and integer multiple of increment" are selected. The calculation time is ≤1 second.

[0048] Drilling layout and adjustment module: Operations are implemented on the B-side via mouse event listening. Batch layout generates drill coordinates through a grid algorithm, area selection selects drill holes by judging the coordinate range, and single-point editing modifies drill coordinates through drag events. All operations are synchronized to the application server in real time to ensure data consistency.

[0049] Architecture support modules: The application server communicates with the B-end via HTTP / HTTPS protocol and with the C-end via Socket protocol; the B-end enables the internal network firewall, allowing only the 192.168.1.0 / 24 network segment to access; the C-end achieves offline storage through local caching, and version management saves historical deployment files through file naming rules (such as "date-project-stage-V1"), and updates them to the server through an incremental synchronization algorithm after connecting to the network.< / canvas>

Claims

1. A method for intelligent and visually arranged borehole spacing, characterized in that: Includes the following steps: S100: A universal geological exploration resource database is constructed using a relational database, and forms are used to record the borehole spacing requirements under different engineering conditions in exploration specifications of different industries; S200: Builds a 3D visualization environment, enabling drilling layout in different scenarios to be completed in a visual way, and intuitively displays the layout results; S300: Intelligent recommendation of the spacing between adjacent boreholes during the borehole layout process. Based on the exploration specifications to be implemented in the specific project, the corresponding borehole spacing is retrieved from the resource library, and the range of borehole spacing is intelligently recommended according to the recorded values ​​in the resource library. S400: Drilling layout. Based on the recommended spacing values ​​and the actual engineering conditions, the specific spacing values ​​are determined, and the drilling positions are displayed graphically in the constructed 3D visualization environment.

2. The intelligent visual arrangement method for borehole spacing according to claim 1, characterized in that: In step S200, the 3D visualization environment is built using a graphics rendering engine based on WebGL or OpenGL.

3. The intelligent visual arrangement method for borehole spacing according to claim 1, characterized in that: In step S200, the three-dimensional visualization environment consists of a three-dimensional window and general controls, which are used to support adjusting and locking the viewpoint of the three-dimensional window. When locked, it is equivalent to a two-dimensional window and supports two-dimensional visualization layout. The general controls include zoom, coordinate ruler, query and measurement functions to assist in completing the drilling layout.

4. The intelligent visual arrangement method for borehole spacing according to claim 3, characterized in that: In step S200, the scenario includes importing basic data and using the basic data as a background for drilling layout and free layout.

5. A system for intelligent visual arrangement of borehole spacing as described in claim 4, characterized in that: It includes a geological exploration resource database module, a 3D visualization environment module, a spacing intelligent recommendation module, a borehole layout and adjustment module, and an architecture support module; The geological exploration resource database module is deployed on the S end and is used to store borehole spacing data corresponding to exploration specifications of different industries and regions, supporting data addition, editing and retrieval; The 3D visualization environment module is deployed on the B-end or C-end to build a visualization interface for multi-source model integration, providing viewpoint adjustment, general control operation and 3D capture functions; The spacing intelligent recommendation module is deployed on the application server and is used to receive engineering information, search the resource library, and generate candidate spacing values ​​through calculation. The drilling layout and adjustment module is deployed at end B or end C and is used to realize batch layout, area selection adjustment and single-point editing. The architecture support module is used to realize communication between the S-end, application server and B-end / C-end, and supports B / S and C / S dual architecture operation.

6. The intelligent visualization layout system for borehole spacing according to claim 5, characterized in that: The geological exploration resource database module uses a MySQL relational database, is hosted on a database server running Windows or Linux, and connects to the application server via TCP / IP protocol.

7. The intelligent visualization layout system for borehole spacing according to claim 5, characterized in that: The 3D visualization environment is implemented through a graphics rendering engine based on WebGL or OpenGL, supporting the rendering of 3D models on a Canvas. When importing a model, a coordinate transformation subroutine is used to convert between the spherical coordinate system and the local Cartesian coordinate system of the project, with a conversion error of ≤0.5m.

8. The intelligent visualization layout system for borehole spacing according to claim 5, characterized in that: The architecture support module supports multi-device access: devices with Windows and Linux operating systems can access via B / C terminals, while Android devices can access via B terminals; it also supports permission management, with three levels of permissions: administrator, editor, and viewer.

9. The intelligent visualization layout system for borehole spacing according to claim 5, characterized in that: The C-end has offline storage capabilities, allowing the download of geological exploration resource databases to the local machine and the completion of borehole layout even when offline; it also has version management capabilities, supporting the saving of 3-5 historical layout versions; the B-end supports multi-user online collaborative editing, allowing access only from internal network IP addresses to ensure data security.

Images