Three-dimensional modeling database service platform for important geological drilling data

Abstract

The invention relates to a three-dimensional modeling database service platform for important geological drilling data, and the platform comprises a data quality inspection module which carries out the quality inspection of converged drilling data of all regions, stores the data passing the quality inspection in a drilling database, and analyzes the data not passing the quality inspection, and stores the data in the drilling database; the data management module is used for performing level classification on the data in the drilling database for users with different permissions to retrieve and updating the data in the drilling database; the data modeling module is used for performing three-dimensional modeling on the drilling data; the data service module is used for issuing drilling data in a three-dimensional model form; the drilling data retrieval module is used for providing retrieval and display functions of published data for the user; the special product module is used for providing retrieval and display functions of special products associated with drilling for the user; and the data statistics module is used for displaying drilling data statistics results under various statistical classifications to the user. Unified storage and management of geological drilling data are realized.

Description

[0001] This application is a divisional application of a patent application entitled "A 3D Modeling Database Service Platform for Important Geological Borehole Data", the original application was filed on April 7, 2024, and the application number is 202410408392.9. Technical Field

[0002] This application relates to the field of data service platform technology, and in particular to a three-dimensional modeling database service platform for important geological borehole data. Background Technology

[0003] Geological borehole data is the most important part of original geological data. The National Geological Data Center of Natural Resources is the national repository of physical geological data. It has received and collected a massive amount of various types of physical geological data and established a comprehensive national geological data management system. However, due to the large volume of historical data and the dispersed storage locations, it is quite difficult to achieve unified storage, management, and service of geological borehole data. Summary of the Invention

[0004] To overcome, to some extent, the difficulty in achieving unified storage, management, and service of geological borehole data in related technologies, this application provides a three-dimensional modeling database service platform for important geological borehole data.

[0005] The proposed solution is as follows:

[0006] A 3D modeling database service platform for important geological borehole data includes:

[0007] The data quality inspection module is used to inspect the collected borehole data from various regions, store the data that passes the quality inspection into the borehole database, and parse and store the data that fails the quality inspection into the borehole database.

[0008] The data management module is used to classify the data in the borehole database by level so that users with different permissions can retrieve it, and also to update the data in the borehole database;

[0009] The data modeling module is used to perform three-dimensional modeling of the data in the borehole database;

[0010] The data service module is used to publish the data in the borehole database in the form of a three-dimensional model;

[0011] The borehole data retrieval module is used to provide users with the functions of retrieving and displaying published data;

[0012] The topic product module is used to provide users with the ability to search and display topic products related to boreholes;

[0013] The data statistics module is used to display borehole data statistics results under various statistical categories to users.

[0014] Preferably, the borehole data retrieval module includes: a map retrieval module for displaying an electronic map and a list of retrieval results;

[0015] The map search module provides the following search functions based on the electronic map:

[0016] Map keyword search displays boreholes that meet the user's entered keywords on the electronic map in pages, and shows the boreholes on the current page in the search results list;

[0017] Advanced map search displays matching boreholes on an electronic map in pages based on user-entered combined search criteria, and shows the boreholes on the current page in the search results list. Combined search criteria for advanced map search include at least: keywords, borehole number, borehole location, borehole type, work area name, completion date, completion depth, project name, project end time, work progress, scale, and main mineral type.

[0018] Rectangular search: Based on the rectangular area selected by the user on the electronic map, the drill holes within the rectangular area are displayed on the electronic map and in the search results list.

[0019] Coordinate point retrieval: Based on the latitude and longitude coordinates entered by the user, an envelope area is generated on the electronic map, and the boreholes within the envelope area are displayed on the electronic map and in the search results list.

[0020] Polygon search: Based on the polygon area selected by the user on the electronic map, the drill holes within the polygon area are displayed on the electronic map and in the search results list.

[0021] The system allows users to search around a point. Based on the marker point selected by the user on the electronic map and the entered query radius, the system displays the boreholes that meet the criteria in pages on the electronic map, and displays the boreholes of the current page in the search results list.

[0022] The search function around the line displays matching boreholes in pages on the electronic map based on the polyline drawn by the user and the entered query radius. The search results list shows the boreholes on the current page.

[0023] The search function for complete exploration areas displays matching boreholes on a paginated electronic map based on the user's selected complete exploration area, and shows the boreholes on the current page in the search results list.

[0024] The 10,000-map-size search displays the boreholes that meet the criteria in pages on the electronic map based on the 10,000-map-size selected by the user, and displays the boreholes of the current page in the search results list;

[0025] Mineral type search: Based on the mineral type selected by the user, the system displays the boreholes that meet the criteria in pages on the electronic map, and displays the boreholes on the current page in the search results list;

[0026] Geological work type search: Based on the user's selected mineral geological work type, the electronic map displays the boreholes that meet the criteria in pages, and the current page's boreholes are displayed in the search results list;

[0027] The administrative region search function displays the boreholes that meet the criteria in pages on the electronic map based on the administrative region selected by the user, and shows the boreholes of the current page in the search results list.

[0028] Thematic map retrieval displays the distribution of selected thematic maps on an electronic map based on the user's chosen thematic map.

[0029] Searching the search results, based on the secondary search criteria entered by the user and the primary search results, the drill holes that meet the criteria are displayed in pages on the electronic map, and the drill holes of the current page are displayed in the search results list;

[0030] Among them, the boreholes displayed on the electronic map and in the search results list show borehole information when clicked.

[0031] Preferably, the borehole data retrieval module further includes: a catalog retrieval module for displaying a borehole catalog retrieval interface;

[0032] The directory retrieval module provides the following retrieval functions based on the borehole directory retrieval interface:

[0033] Directory keyword search: Displays boreholes that meet the user's entered keywords on the borehole directory search interface;

[0034] Advanced catalog search displays boreholes that meet the user's combined search criteria on the borehole catalog search interface. The combined search criteria used for advanced catalog search include at least: borehole number, borehole location, borehole type, work area name, completion date, completion depth, project name, project end time, work progress, scale, and main mineral type.

[0035] Search the search results and display the boreholes that meet the user's sub-search criteria and the results of the previous search on the borehole catalog search interface.

[0036] The borehole information displayed on the borehole catalog search interface is shown when a borehole is clicked.

[0037] Preferably, the topic product module displays the topic name, topic description, related images, related files and associated boreholes in the corresponding topic products to the user based on the topic search conditions entered by the user, and provides the function of downloading related files.

[0038] Preferably, the statistical categories displayed by the data statistics module include at least:

[0039] Statistics on administrative divisions, industry sectors, borehole types, work progress, completion dates, and final depths;

[0040] The administrative division statistics are compiled according to multiple pre-divided administrative divisions;

[0041] The statistics on the final hole dates are divided into nine time periods, including: before 1949, 1949-1960, 1960-1970, 1970-1980, 1980-1995, 1995-2000, 2000-2005, 2005-2010, 2010-2015, and after 2015.

[0042] The final hole depth is statistically divided into seven depth segments, including: below 100 meters, 100-200 meters, 200-500 meters, 500-1000 meters, 1000-1500 meters, 1500-2000 meters, and above 2000 meters.

[0043] Preferably, it further includes:

[0044] The real-time data module is used to display the latest published list of borehole data to users; when a borehole in the latest published list of borehole data is clicked, the borehole information is displayed.

[0045] Preferably, it further includes: a user operation module;

[0046] The user operation module is used to provide the following functions:

[0047] User registration involves sending a registration request to the administrator based on the personal information entered by the user, and registering the user account after the review is approved.

[0048] User login: Log in to the user account based on the username, password and verification code entered by the user;

[0049] User feedback: Send user feedback to the administrator based on the personal information and feedback content entered by the user;

[0050] A user personal database used to store users' favorite drilling data;

[0051] Drilling customization: Send a drilling customization request to the administrator based on the drilling customization title and content entered by the user.

[0052] Preferably, it further includes: an administrator operation module;

[0053] The administrator operation module provides the following functions:

[0054] Topic management allows administrators to add, modify, and edit topic products based on their instructions. Topic products include topic name, topic description, related images, related files, and associated boreholes.

[0055] User management involves adding or deleting user accounts based on the administrator's instructions and approving registration applications sent from the user operation module.

[0056] Log management allows adding and deleting user logs based on administrator commands;

[0057] User feedback processing involves handling feedback information based on the review comments entered by the administrator.

[0058] Customized information management allows for the approval of customized drilling requests sent by user operation modules;

[0059] Personal database management displays the personal database information of all users.

[0060] The technical solution provided in this application can include the following beneficial effects: The 3D modeling database service platform for important geological borehole data in this application includes: a data quality inspection module, used to inspect the collected borehole data from various regions, store the quality-passing data in the borehole database, and parse and store the quality-failing data in the borehole database; a data management module, used to classify the data in the borehole database by level for users with different permissions to retrieve, and also to update the data in the borehole database; a data modeling module, used to perform 3D modeling on the data in the borehole database; a data service module, used to publish the data in the borehole database in the form of 3D models; a borehole data retrieval module, used to provide users with retrieval and display functions for published data; a thematic product module, used to provide users with retrieval and display functions for borehole-related thematic products; and a data statistics module, used to display the statistical results of borehole data under various statistical classifications to users. The database service platform in this application will uniformly store and manage geological borehole data across the country, effectively solving problems such as the standardization and integration, unified management, spatial data analysis, visualization of results, and convenient and widespread use of massive, diverse, and heterogeneous borehole data. It will digitize, three-dimensionalize, and visualize the borehole data, thereby improving the ability to share and utilize borehole data.

[0061] It should be understood that the above general description and the following detailed description are exemplary and explanatory only, and do not limit this application. Attached Figure Description

[0062] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0063] Figure 1 This is a schematic diagram of the structure of a three-dimensional modeling database service platform for important geological borehole data provided in one embodiment of this application;

[0064] Figure 2 This is an implementation flowchart of a three-dimensional modeling database service platform for important geological borehole data provided in one embodiment of this application;

[0065] Figure 3 This is a functional diagram of the map retrieval module in a three-dimensional modeling database service platform for important geological borehole data provided in one embodiment of this application;

[0066] Figure 4 This is a functional diagram of the catalog retrieval module in a three-dimensional modeling database service platform for important geological borehole data provided in one embodiment of this application;

[0067] Figure 5 This is a schematic diagram of the structure of another three-dimensional modeling database service platform for important geological borehole data provided in one embodiment of this application. Detailed Implementation

[0068] Figure 1 This is a schematic diagram of the structure of a three-dimensional modeling database service platform for important geological borehole data provided in one embodiment of this application, with reference to... Figure 1 A 3D modeling database service platform for important geological borehole data includes:

[0069] The data quality inspection module is used to inspect the collected borehole data from various regions, store the data that passes the quality inspection into the borehole database, and parse and store the data that fails the quality inspection into the borehole database.

[0070] The data management module is used to classify the data in the borehole database by level so that users with different permissions can retrieve it, and also to update the data in the borehole database;

[0071] The data modeling module is used to perform 3D modeling of data in the borehole database;

[0072] The data service module is used to publish data from the borehole database in the form of 3D models;

[0073] The borehole data retrieval module is used to provide users with the functions of retrieving and displaying published data;

[0074] The topic product module is used to provide users with the ability to search and display topic products related to boreholes;

[0075] The data statistics module is used to display borehole data statistics results under various statistical categories to users.

[0076] It should be noted that, referring to Figure 2 In this embodiment, the database service platform first performs quality inspection on the collected borehole data from various regions (provinces) provided by the data management personnel. After the quality inspection, the data is stored in the database, and then the data can be managed and published.

[0077] Data can be classified into basic data and specialized data.

[0078] It should be noted that the borehole data retrieval module includes: a map retrieval module, which displays electronic maps and a list of retrieval results;

[0079] Reference Figure 3 The map search module provides the following search functions based on electronic maps:

[0080] Map keyword search displays boreholes that meet the user's entered keywords on the electronic map in pages, and shows the boreholes on the current page in the search results list;

[0081] Advanced map search displays matching boreholes on an electronic map in pages based on user-entered combined search criteria, and shows the boreholes on the current page in the search results list. Combined search criteria for advanced map search include at least: keywords, borehole number, borehole location, borehole type, work area name, completion date, completion depth, project name, project end time, work progress, scale, and main mineral type.

[0082] Rectangular search: Based on the rectangular area selected by the user on the electronic map, the drill holes within the rectangular area are displayed on the electronic map and in the search results list.

[0083] Coordinate point retrieval: Based on the latitude and longitude coordinates entered by the user, an envelope area is generated on the electronic map, and the boreholes within the envelope area are displayed on the electronic map and in the search results list.

[0084] Polygon search: Based on the polygon area selected by the user on the electronic map, the drill holes within the polygon area are displayed on the electronic map and in the search results list.

[0085] The system allows users to search around a point. Based on the marker point selected by the user on the electronic map and the entered query radius, the system displays the boreholes that meet the criteria in pages on the electronic map, and displays the boreholes of the current page in the search results list.

[0086] The search function around the line displays matching boreholes in pages on the electronic map based on the polyline drawn by the user and the entered query radius. The search results list shows the boreholes on the current page.

[0087] The search function for complete exploration areas displays matching boreholes on a paginated electronic map based on the user's selected complete exploration area, and shows the boreholes on the current page in the search results list.

[0088] The 10,000-map-size search displays the boreholes that meet the criteria in pages on the electronic map based on the 10,000-map-size selected by the user, and displays the boreholes of the current page in the search results list;

[0089] Mineral type search: Based on the mineral type selected by the user, the system displays the boreholes that meet the criteria in pages on the electronic map, and displays the boreholes on the current page in the search results list;

[0090] Geological work type search: Based on the user's selected mineral geological work type, the electronic map displays the boreholes that meet the criteria in pages, and the current page's boreholes are displayed in the search results list;

[0091] The administrative region search function displays the boreholes that meet the criteria in pages on the electronic map based on the administrative region selected by the user, and shows the boreholes of the current page in the search results list.

[0092] Thematic map retrieval displays the distribution of selected thematic maps on an electronic map based on the user's chosen thematic map.

[0093] Searching the search results, based on the secondary search criteria entered by the user and the primary search results, the drill holes that meet the criteria are displayed in pages on the electronic map, and the drill holes of the current page are displayed in the search results list;

[0094] Among them, the boreholes displayed on the electronic map and in the search results list show borehole information when clicked.

[0095] In practice, map keyword search provides users with a keyword search input box and performs searches based on the keywords entered by the user. Multiple keywords are separated by spaces or commas, such as "xx province, xx city, xx county".

[0096] Advanced map search allows users to perform searches based on combined search criteria, making it suitable for high-precision, customized borehole searches.

[0097] Rectangular search: This function searches based on a rectangular area selected by the user on an electronic map. The user can select a specific rectangular area on the electronic map, and the system will automatically retrieve borehole data within that area.

[0098] Coordinate point retrieval: This function searches for borehole data within a specified area based on user-entered latitude and longitude coordinates. The input format is: longitude of the first coordinate point, latitude of the first coordinate point, longitude of the second coordinate point, latitude of the second coordinate point, ..., longitude of the Nth coordinate point, latitude of the first coordinate point, longitude of the Nth coordinate point. The system automatically retrieves borehole data within that area. This is suitable for users who only possess latitude and longitude coordinate data and need to determine the borehole data within that area.

[0099] Polygon search searches based on polygonal areas selected by the user on an electronic map. Its mechanism is the same as that of rectangular search, but the difference is that polygon search can draw irregular polygonal areas for searching.

[0100] The search function around a point is based on the marker point selected by the user on the electronic map and the entered search radius. For example, if the user selects point A on the electronic map and enters a search radius of 500m, then the search will be performed on a circular area with a radius of 500m centered on point A.

[0101] Similar to the search around a point, the search around a line is performed based on the polyline drawn by the user on the electronic map and the entered search radius.

[0102] The search for complete exploration areas is based on the complete exploration areas selected by the user. A complete exploration area refers to a specific area with a concentration of established exploration rights.

[0103] The search methods for searching by map sheet size, mineral type, and geological work type are the same as those for searching the entire exploration area.

[0104] Administrative region search is performed based on the actual geographical boundaries of the administrative region selected by the user.

[0105] Thematic map retrieval displays the distribution of selected thematic maps on an electronic map, with different areas represented by dots of different colors.

[0106] Searching within the search results: After using search terms such as "map keyword search," "advanced map search," and "rectangle search," users can click the "Search within search results" link to bring up a search criteria page. This page will load the criteria information from the previous search. For the next search, simply enter new search criteria and click the "Search" button to perform a second search for results.

[0107] When a borehole is clicked on in the electronic map and search results list, borehole information is displayed, including: borehole number, borehole columnar section, original data file number, exploration line number, borehole name, borehole type, work area name, borehole location, borehole elevation, final depth, final date, construction unit, well logging report, original geological record table, and borehole core.

[0108] Preferably, project information and custodian information are also displayed.

[0109] It should be noted that the borehole data retrieval module also includes a catalog retrieval module, which is used to display the borehole catalog retrieval interface;

[0110] The directory search module, based on the borehole directory search interface, provides the following search functions:

[0111] Directory keyword search: Displays boreholes that meet the user's entered keywords on the borehole directory search interface;

[0112] Advanced catalog search displays boreholes that meet the user's combined search criteria on the borehole catalog search interface. The combined search criteria used for advanced catalog search include at least: borehole number, borehole location, borehole type, work area name, completion date, completion depth, project name, project end time, work progress, scale, and main mineral type.

[0113] Search the search results and display the boreholes that meet the user's sub-search criteria and the results of the previous search on the borehole catalog search interface.

[0114] The borehole information displayed on the borehole catalog search interface is shown when a borehole is clicked.

[0115] In practice, the retrieval method for directory keyword search is the same as that for map keyword search, and the retrieval method for advanced directory search is the same as that for advanced map search.

[0116] Both the directory search module and the map search module support the search function within the search results.

[0117] It should be noted that the topic product module displays the topic name, topic description, related images, related files and associated boreholes in the corresponding topic products to the user based on the topic search conditions entered by the user, and provides the function of downloading related files.

[0118] It should be noted that the special products in the special product module are created by the administrator.

[0119] When using the special product module, users need to click "Special Products" in the navigation bar to open the special product page.

[0120] View featured products:

[0121] Step 1: Click on the desired product to enter the product details page.

[0122] Step 2: View the product details, download the relevant files, and view the related drilling.

[0123] It should be noted that the statistical categories displayed in the data statistics module include at least:

[0124] Statistics on administrative divisions, industry sectors, borehole types, work progress, completion dates, and final depths;

[0125] Administrative division statistics are compiled according to multiple pre-defined administrative divisions;

[0126] The statistics on the final hole dates are divided into nine time periods, including: before 1949, 1949-1960, 1960-1970, 1970-1980, 1980-1995, 1995-2000, 2000-2005, 2005-2010, 2010-2015, and after 2015.

[0127] The final hole depth is statistically divided into seven depth segments, including: below 100 meters, 100-200 meters, 200-500 meters, 500-1000 meters, 1000-1500 meters, 1500-2000 meters, and above 2000 meters.

[0128] In practice, users can click on the corresponding tabs for different statistical types in the data statistics module to view the statistical results as needed. This system divides the statistical results into seven categories: administrative division statistics, industry / department statistics, borehole type statistics, work progress statistics, completion date statistics, and completion depth statistics. Among them, the administrative division statistics are based on 34 provinces and autonomous regions, the completion date statistics are divided into nine time periods, and the completion depth statistics are divided into seven depth segments.

[0129] It should be noted that, referring to Figure 5The 3D modeling database service platform for important geological borehole data also includes:

[0130] The real-time data module is used to display the latest published list of borehole data to users; when a borehole in the latest published list of borehole data is clicked, the borehole information is displayed.

[0131] It should be noted that users can click the "Recent Data" button in the platform navigation bar to enter the recent data page of the real-time data module. The information displayed on the recent data page is all the latest drilling data, which allows users to intuitively understand the latest information.

[0132] It should be noted that the 3D modeling database service platform for important geological borehole data also includes: a user operation module;

[0133] The user operation module provides the following functions:

[0134] User registration involves sending a registration request to the administrator based on the personal information entered by the user, and registering the user account after the review is approved.

[0135] User login: Log in to the user account based on the username, password and verification code entered by the user;

[0136] User feedback: Send user feedback to the administrator based on the personal information and feedback content entered by the user;

[0137] A user personal database used to store users' favorite drilling data;

[0138] Drilling customization: Send a drilling customization request to the administrator based on the drilling customization title and content entered by the user.

[0139] It should be noted that the user registration process is as follows:

[0140] Step 1: Go to the registration page.

[0141] Step 2: Fill in your personal identification information. All fields must be filled in completely and correctly.

[0142] Step 3: Click the register button.

[0143] Step 4: Wait for the administrator to verify your identity. Accounts that have not been verified by the administrator cannot log in to the system.

[0144] The user login process is as follows:

[0145] Step 1: Click the "Login" button to enter the login page. Step 2: Enter your username, password, and verification code. If you do not have a username and password, please register.

[0146] Step 3: Click the login button. Unregistered accounts and accounts that have not passed the review will not be able to log in.

[0147] Users can access the user feedback page by clicking the "User Feedback" button on the platform. They can then fill in their name, phone number, email address, feedback title, and feedback content, and click submit to send their feedback to the administrator.

[0148] Users can save drilling data to their personal database, or delete the drilling data saved in their personal database.

[0149] Preferably, the platform also provides the address information of the management unit, so that users can contact the management unit where the platform is located based on this information.

[0150] It should be noted that the 3D modeling database service platform for important geological borehole data also includes: an administrator operation module;

[0151] The administrator operation module provides the following functions:

[0152] Topic management allows administrators to add, modify, and edit topic products based on their instructions. Topic products include topic name, topic description, related images, related files, and associated boreholes.

[0153] User management involves adding or deleting user accounts based on the administrator's instructions and approving registration applications sent from the user operation module.

[0154] Log management allows adding and deleting user logs based on administrator commands;

[0155] User feedback processing involves handling feedback information based on the review comments entered by the administrator.

[0156] Customized information management allows for the approval of customized drilling requests sent by user operation modules;

[0157] Personal database management displays the personal database information of all users.

[0158] In practice, the topic management process is as follows:

[0159] Step 1: Click "Topic Management" in the platform tab to enter the topic management page.

[0160] Step 2: Select a topic and click the "Edit (Page)" button to enter the editing page.

[0161] Step 3: Modify the topic name and topic description, then click save.

[0162] Step 4: Click the thumbnail button to bring up the thumbnail upload dialog box.

[0163] Step 5: Click "Select File", select the thumbnail you want to upload from your local computer, and then click "OK".

[0164] Step 6: Click "File" to bring up the file upload dialog box.

[0165] Step 7: Click "Select File" to upload the file you need, fill in the file title and file description, and click "OK".

[0166] Step 8: Add Holes: Click "Drill Holes" to bring up the drill selection dialog box. Enter the keywords for the holes you want to add, click search, and get the drill list.

[0167] Step 9: Locate the hole you want to add and click the "Add" button next to it.

[0168] It should be noted that the user log records different actions taken by each user at different times, and the administrator can view or delete the log records.

[0169] After logging into the platform, the administrator can click on their profile to view the customized drilling information, select the customized drilling information, click on the new title, and enter the details page. If the processing is complete, click the "Complete Processing" button.

[0170] After logging into the platform, the administrator clicks the "User Feedback" button in the navigation bar to enter the feedback page. Clicking the title of the feedback item to be processed leads to its details. After reviewing the information, the administrator fills in their comments in the "Remarks" section and clicks the "Complete Processing" button to finish processing the feedback.

[0171] After logging into the platform, the administrator can click the "Personal Profile Library" option to enter the personal profile library management page. The administrator's personal profile library allows viewing all users' saved drill holes. Clicking the drill hole number will display the drill hole's details. Clicking "Custom Details" will display the user's customized information.

[0172] In practical application, the 3D modeling database service platform for important geological borehole data is a distributed geological borehole data publishing platform developed using a B / S (Browser / Server) model. It is based on Internet technology, employs a Service-Oriented Architecture (SOA) architecture, Web Service technology, and uses the Tianditu map developed and published by the State Bureau of Surveying and Mapping as its geographic base map. The platform mainly consists of three parts: front-end interface functions, back-end data management, and security operation and maintenance management.

[0173] This database service platform utilizes computer technology, network technology, and database technology. Following the national geological borehole data information unified map construction concept and adhering to the principles of "standardized, distributed deployment, and integrated services," it has been designed and completed as a distributed, important borehole database service platform with functions including data input, output, retrieval and query, statistical analysis, graphics creation and 3D visualization, data management, and maintenance. It collects geological borehole data and provides basic data service support for economic and social development and mineral exploration breakthrough strategies. Running in a B / S (Browser / Server) architecture on a public network environment, it is used to publish borehole data information, including graphics, images, tables, and text. Basic borehole information and spatial information are stored in a PostgreSQL database. Figure 1 The "table" data (tile data) is stored in the file system. The system uses the free Tianditu map service as its GIS map service. The development path is based on ADO.NET under the .NET Framework and C# language. The client-side development uses technologies such as HTML, CSS, JavaScript, and leaflet. The business logic layer connects to the database by calling service interfaces, and Tianditu is used as the system base map.

[0174] The basic environment required for this database service platform to run includes: one high-performance server with at least 400GB of hard disk storage; the recommended operating system is Windows Server 2008 / 2012 Enterprise Edition (64-bit), with the Web Server (IIS) role added and Microsoft .NET Framework 4.5 installed; PostgreSQL relational database management system and PostGIS spatial database engine installed; PGloonga full-text search engine; and a fixed IP address or public domain name assigned to the server. For Windows 8 and Windows Server 2012, .NET Framework 4.5 is not required. For Windows operating systems earlier than these versions, it must be installed.

[0175] This database service platform demonstrates excellent performance in terms of user-friendliness and consistency, software reliability, responsiveness, response time, security, and system maintainability. It holds significant practical and economic importance for fully utilizing existing geological borehole data, reducing geological work risks, minimizing duplication of work and financial waste, and promoting economic, social, and geological industry development. Further research into the needs analysis for building a 3D modeling database service platform for important geological borehole data, identifying existing system problems, and upgrading the platform's functionality will greatly enhance the efficiency of geological borehole data management and maintenance. By breaking down the limitations of applying only important geological borehole data and changing the traditional borehole application model with its restrictive data representation methods, this platform innovates popular science concepts and professional application service models, providing information services to the public and geological professionals through the construction of a 3D modeling database service platform for important geological borehole data.

[0176] It is understood that the same or similar parts in the above embodiments can be referred to each other, and the contents not described in detail in some embodiments can be referred to the same or similar contents in other embodiments.

[0177] It should be noted that in the description of this application, the terms "first," "second," etc., are used for descriptive purposes only and should not be construed as indicating or implying relative importance. Furthermore, in the description of this application, unless otherwise stated, "a plurality of" means at least two.

[0178] Any process or method described in the flowchart or otherwise herein can be understood as representing a module, segment, or portion of code comprising one or more executable instructions for implementing a particular logical function or process, and the scope of the preferred embodiments of this application includes additional implementations in which functions may be performed not in the order shown or discussed, including substantially simultaneously or in reverse order depending on the function involved, as will be understood by those skilled in the art to which embodiments of this application pertain.

[0179] It should be understood that various parts of this application can be implemented using hardware, software, firmware, or a combination thereof. In the above embodiments, multiple steps or methods can be implemented using software or firmware stored in memory and executed by a suitable instruction execution system. For example, if implemented in hardware, as in another embodiment, it can be implemented using any one or a combination of the following techniques known in the art: discrete logic circuits having logic gates for implementing logical functions on data signals, application-specific integrated circuits (ASICs) having suitable combinational logic gates, programmable gate arrays (PGAs), field-programmable gate arrays (FPGAs), etc.

[0180] Those skilled in the art will understand that all or part of the steps of the methods described in the above embodiments can be implemented by a program instructing related hardware. The program can be stored in a computer-readable storage medium, and when executed, it includes one or a combination of the steps of the method embodiments.

[0181] Furthermore, the functional units in the various embodiments of this application can be integrated into a processing module, or each unit can exist physically separately, or two or more units can be integrated into a module. The integrated module can be implemented in hardware or as a software functional module. If the integrated module is implemented as a software functional module and sold or used as an independent product, it can also be stored in a computer-readable storage medium.

[0182] The storage media mentioned above can be read-only memory, disk, or optical disk, etc.

[0183] In the description of this specification, the references to terms such as "one embodiment," "some embodiments," "example," "specific example," or "some examples," etc., indicate that a specific feature, structure, material, or characteristic described in connection with that embodiment or example is included in at least one embodiment or example of this application. In this specification, the illustrative expressions of the above terms do not necessarily refer to the same embodiment or example. Furthermore, the specific features, structures, materials, or characteristics described may be combined in any suitable manner in one or more embodiments or examples.

[0184] Although embodiments of this application have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting this application. Those skilled in the art can make changes, modifications, substitutions and variations to the above embodiments within the scope of this application.

Claims

1. A three-dimensional modeling database service platform for important geological borehole data, characterized in that, include: The data quality inspection module is used to inspect the collected borehole data from various regions, store the data that passes the quality inspection into the borehole database, and parse and store the data that fails the quality inspection into the borehole database. The data management module is used to classify the data in the borehole database by level so that users with different permissions can retrieve it, and also to update the data in the borehole database; The data modeling module is used to perform three-dimensional modeling of the data in the borehole database; The data service module is used to publish the data in the borehole database in the form of a three-dimensional model; The borehole data retrieval module is used to provide users with the functions of retrieving and displaying published data; The topic product module is used to provide users with the ability to search and display topic products related to boreholes; The data statistics module is used to display borehole data statistics results under various statistical categories to users; The borehole data retrieval module includes: a map retrieval module for displaying electronic maps and a list of retrieval results; The map search module provides the following search functions based on the electronic map: Map keyword search displays boreholes that meet the user's entered keywords on the electronic map in pages, and shows the boreholes on the current page in the search results list; Advanced map search displays matching boreholes on an electronic map in pages based on user-entered combined search criteria, and shows the boreholes on the current page in the search results list. Combined search criteria for advanced map search include at least: keywords, borehole number, borehole location, borehole type, work area name, completion date, completion depth, project name, project end time, work progress, scale, and main mineral type. Rectangular search: Based on the rectangular area selected by the user on the electronic map, the drill holes within the rectangular area are displayed on the electronic map and in the search results list. The coordinate point retrieval function generates an envelope region on an electronic map based on the latitude and longitude coordinates entered by the user. The system then displays the boreholes within this envelope region on the map and shows them in the search results list. Specifically, the retrieval is performed based on the latitude and longitude coordinates entered by the user. The input format for these coordinates is: longitude of the first coordinate point, latitude of the first coordinate point, longitude of the second coordinate point, latitude of the second coordinate point, ..., longitude of the Nth coordinate point, latitude of the first coordinate point, longitude of the Nth coordinate point. This function automatically retrieves borehole data within the specified area. It is suitable for users who only possess latitude and longitude coordinate data and need to determine the borehole data within that area. Polygon search displays boreholes within a polygonal region selected by the user on an electronic map, and also displays the boreholes within the polygonal region in the search results list. Specifically, it searches based on a polygonal region selected by the user on an electronic map, with the same mechanism as rectangular search, except that polygon search can draw irregular polygonal regions for searching. The system allows users to search around a point. Based on the marker point selected by the user on the electronic map and the entered query radius, the system displays the boreholes that meet the criteria in pages on the electronic map, and displays the boreholes of the current page in the search results list. The search function around the line displays matching boreholes in pages on the electronic map based on the polyline drawn by the user and the entered query radius. The search results list shows the boreholes on the current page. The search function for complete exploration areas displays matching boreholes on a paginated electronic map based on the user's selected complete exploration area, and shows the boreholes on the current page in the search results list. The 10,000-map-size search displays the boreholes that meet the criteria in pages on the electronic map based on the 10,000-map-size selected by the user, and displays the boreholes of the current page in the search results list; Mineral type search: Based on the mineral type selected by the user, the system displays the boreholes that meet the criteria in pages on the electronic map, and displays the boreholes on the current page in the search results list; Geological work type search: Based on the user's selected mineral geological work type, the electronic map displays the boreholes that meet the criteria in pages, and the current page's boreholes are displayed in the search results list; The administrative region search function displays the boreholes that meet the criteria in pages on the electronic map based on the administrative region selected by the user, and shows the boreholes of the current page in the search results list. Thematic map retrieval displays the distribution of selected thematic maps on an electronic map based on the user's chosen thematic map. Searching the search results, based on the secondary search criteria entered by the user and the primary search results, the drill holes that meet the criteria are displayed in pages on the electronic map, and the drill holes of the current page are displayed in the search results list; Among them, the boreholes displayed on the electronic map and in the search results list show borehole information when clicked; The borehole data retrieval module also includes a catalog retrieval module for displaying the borehole catalog retrieval interface; The directory retrieval module provides the following retrieval functions based on the borehole directory retrieval interface: Directory keyword search: Displays boreholes that meet the user's entered keywords on the borehole directory search interface; Advanced catalog search displays boreholes that meet the user's combined search criteria on the borehole catalog search interface. The combined search criteria used for advanced catalog search include at least: borehole number, borehole location, borehole type, work area name, completion date, completion depth, project name, project end time, work progress, scale, and main mineral type. Search the search results and display the boreholes that meet the user's sub-search criteria and the results of the previous search on the borehole catalog search interface. The borehole information displayed on the borehole catalog search interface is shown when a borehole is clicked.

2. The three-dimensional modeling database service platform for important geological borehole data according to claim 1, characterized in that, The topic product module displays the topic name, topic description, related images, related files and associated boreholes in the corresponding topic products to the user based on the topic search conditions entered by the user, and provides the function of downloading related files.

3. The three-dimensional modeling database service platform for important geological borehole data according to claim 1, characterized in that, The statistical categories displayed by the data statistics module include at least: Statistics on administrative divisions, industry sectors, borehole types, work progress, completion dates, and final depths; The administrative division statistics are compiled according to multiple pre-divided administrative divisions; The statistics on the final hole dates are divided into nine time periods, including: before 1949, 1949-1960, 1960-1970, 1970-1980, 1980-1995, 1995-2000, 2000-2005, 2005-2010, 2010-2015, and after 2015. The final hole depth is statistically divided into seven depth segments, including: below 100 meters, 100-200 meters, 200-500 meters, 500-1000 meters, 1000-1500 meters, 1500-2000 meters, and above 2000 meters.

4. The three-dimensional modeling database service platform for important geological borehole data according to claim 1, characterized in that, Also includes: The real-time data module is used to display the latest published list of borehole data to users; The newly released list of borehole data displays borehole information when clicked.

5. The three-dimensional modeling database service platform for important geological borehole data according to claim 1, characterized in that, Also includes: User operation module; The user operation module is used to provide the following functions: User registration involves sending a registration request to the administrator based on the personal information entered by the user, and registering the user account after the review is approved. User login: Log in to the user account based on the username, password and verification code entered by the user; User feedback: Send user feedback to the administrator based on the personal information and feedback content entered by the user; A user personal database used to store users' favorite drilling data; Drilling customization: Send a drilling customization request to the administrator based on the drilling customization title and content entered by the user.

6. The three-dimensional modeling database service platform for important geological borehole data according to claim 1, characterized in that, Also includes: Administrator operation module; The administrator operation module provides the following functions: Topic management allows administrators to add, modify, and edit topic products based on their instructions. Topic products include topic name, topic description, related images, related files, and associated boreholes. User management involves adding or deleting user accounts based on the administrator's instructions and approving registration applications sent from the user operation module. Log management allows adding and deleting user logs based on administrator commands; User feedback processing involves handling feedback information based on the review comments entered by the administrator. Customized information management allows for the approval of customized drilling requests sent by user operation modules; Personal database management displays the personal database information of all users.

Images