A hydrogeological exploration information generation system
The hydrogeological exploration information generation system converts exploration data into EXCEL spreadsheets and MAPGIS maps, solving the problem of poor data correlation with office software in the existing system and achieving seamless data integration and management.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- HYDROGEOLOGY BUREAU OF CHINA COAL GEOLOGY ADMINISTRATION
- Filing Date
- 2023-03-31
- Publication Date
- 2026-06-02
AI Technical Summary
The existing hydrogeological exploration information system has poor integration with office software, making it impossible to organically integrate exploration data with Excel spreadsheets, Word documents, and MAPGIS maps.
A hydrogeological exploration information generation system is provided, including a data management module, a document management module, a table management module, and a map management module. Through these modules, exploration data is converted into EXCEL tables, WORD documents, and MAPGIS maps, realizing the organic integration of data and office software.
It achieves seamless integration of exploration data with office software, generating Excel spreadsheets and MAPGIS maps, and using system tools to generate Word documents, thus improving the efficiency of data management and analysis.
Smart Images
Figure CN116562246B_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the field of hydrogeological exploration technology, and in particular to a hydrogeological exploration information generation system. Background Technology
[0002] Hydrogeological investigation refers to the hydrogeological survey and research conducted to ascertain the hydrogeological conditions of a region. Its aim is to understand the formation, distribution, and movement patterns of groundwater and surface water. This provides a basis for the rational exploitation and utilization of water resources and for the correct design and construction of foundation and piling projects. It includes both groundwater and surface hydrogeological investigation. Groundwater investigation mainly involves investigating and studying the changes in groundwater level, flow direction, and chemical composition at different times of the year, determining the burial conditions and corrosiveness of groundwater, assessing the potential changes and impacts of groundwater during the construction and use of buildings, and proposing prevention and control recommendations.
[0003] The existing hydrogeological exploration information system has poor integration with Office, making it impossible to organically integrate exploration data with Excel spreadsheets, Word documents, and MAPGIS maps. Summary of the Invention
[0004] To overcome the problem that existing hydrogeological exploration information systems have poor integration with Office and cannot organically integrate exploration data with Excel spreadsheets, Word documents, and MAPGIS maps, this invention provides a hydrogeological exploration information generation system.
[0005] In a first aspect, in order to solve the above-mentioned technical problems, the present invention provides a hydrogeological exploration information generation system, including a data management module, a document management module, a table management module, a map management module and a system basic data module. The data management module is connected to the table management module and the map management module respectively, and the system basic data module is connected to the document management module.
[0006] The data management module is used to acquire various exploration data from hydrogeological exploration projects;
[0007] The system's basic data module is used to store system tools;
[0008] The table management module is used to call the target table based on each exploration data, and for each exploration data, to assign the exploration data to the corresponding table cell in the target table and generate an EXCEL table. The target table is a hydrogeological exploration information table template.
[0009] The map management module is used to call the target base map based on various exploration data, convert each exploration data into a plain text file, import the plain text file into the target base map, and generate MAPGIS map. The target base map is a hydrogeological exploration information map template, and the plain text file is a format file that can be recognized by MAPGIS map.
[0010] The document management module is used to call system tools to generate Word documents from various exploration data.
[0011] The beneficial effects of the hydrogeological exploration information generation system provided by this invention are as follows: Through the data management module, various exploration data are acquired; then, through the document management module, system tools are used to convert the exploration data into Word documents; through the table management module, a target table is called, and each exploration data is assigned to the corresponding table cell in the target table to generate an Excel table; through the map management module, the exploration data is converted into plain text files, and then imported into the target base map to generate a MAPGIS map. This system links the exploration data with Office, addressing the problem that existing hydrogeological exploration information systems have poor integration with Office, failing to organically integrate exploration data with Excel tables, Word documents, and MAPGIS maps.
[0012] Based on the above technical solution, the hydrogeological exploration information generation system of the present invention can be further improved as follows.
[0013] Furthermore, the aforementioned table management module is specifically used for:
[0014] Based on the various exploration data, select at least one table from the pre-set pumping test results table, borehole basic data table, borehole results data, borehole pipe results structure, pumping test record table, and water quality analysis table as the target table;
[0015] For each exploration data point, the exploration data is assigned to the corresponding table cell in the target table, generating an Excel spreadsheet.
[0016] The beneficial effect of adopting the above-mentioned further solution is that different tables can be called through the table management module to obtain the target table, and then the exploration data can be assigned to the corresponding table cell of the target table to obtain an EXCEL table.
[0017] Furthermore, the aforementioned map management module is specifically used for:
[0018] Based on the various exploration data, at least one graph is selected from the preset borehole prospect column, borehole result column, pumping test result graph, and comparison column graph as the target base graph;
[0019] Each survey data point is converted into a plaintext file, which is then imported into the target base map to generate a MAPGIS map.
[0020] The beneficial effects of adopting the above-mentioned further solution are: through the map management module, different maps can be called to obtain the target base map, and then the exploration data can be converted into plain text files and imported into the map corresponding to the target base map to obtain the MAPGIS map.
[0021] Furthermore, the aforementioned system tools include technical design outlines, construction organization design outlines, and report outlines;
[0022] The document management module is specifically used for:
[0023] Use at least one of the following outlines—the technical design outline, the construction organization design outline, and the report outline—as a system tool to generate a Word document.
[0024] The beneficial effect of adopting the above-mentioned further solution is that: by calling different outlines in the system tools through the document management module, the system tools are determined, and then the various exploration data are generated into Word documents through the system tools.
[0025] Furthermore, the aforementioned exploration data includes at least one of the following: exploration area data, hydrogeological mapping data, geophysical exploration data, hydrogeological drilling data, and hydrogeological test data.
[0026] The beneficial effect of adopting the above-mentioned further scheme is that this application contains almost all exploration data, making the system applicable to all aspects of hydrogeological exploration.
[0027] Furthermore, the aforementioned exploration area data includes at least one of the following: basic exploration area data and basic borehole data. The hydrogeological mapping data includes at least one of the following: fault statistics, meteorological data, collapse column data, small coal mine hydrogeological survey data, river field survey data, and spring field survey data. The geophysical exploration data includes at least one of the following: electrical exploration data and seismic exploration data. The hydrogeological drilling data includes at least one of the following: borehole design data, borehole pipe design structure data, borehole result data, borehole pipe result data, and drilling hydrogeological observation data. The hydrogeological test data includes at least one of the following: single-hole pumping test record data, multi-hole pumping test record data, and group-hole pumping test record data.
[0028] The beneficial effect of adopting the above-mentioned further scheme is that by subdividing the exploration data, the hydrogeological exploration information can be managed in a more refined manner.
[0029] Furthermore, it also includes a database, which is connected to the data management module, the table management module, and the image management module respectively;
[0030] A database is used to store various exploration data.
[0031] The beneficial effects of adopting the above-mentioned further solution are: using a database to store various exploration data makes it easier for the system to call up exploration data, and also makes it easier to query, modify and maintain the exploration data.
[0032] Furthermore, it also includes a calculation and analysis module, which is connected to the database, table management module, and map management module respectively;
[0033] The calculation and analysis module is used to perform at least one of cluster analysis and factor analysis on each exploration data to obtain the corresponding analysis results.
[0034] The beneficial effect of adopting the above-mentioned further solution is that, through the calculation and analysis module, the exploration data can be analyzed to obtain the corresponding analysis results, which can then be used by users. Attached Figure Description
[0035] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the present invention will be further described below in conjunction with the accompanying drawings and embodiments.
[0036] Figure 1 This is a schematic diagram of the structure of a hydrogeological exploration information generation system according to an embodiment of the present invention;
[0037] Figure 2 This is a schematic diagram of the interface of the table management module;
[0038] Figure 3 This is a schematic diagram of the target table;
[0039] Figure 4 An Excel spreadsheet generated based on a target table;
[0040] Figure 5 This is a schematic diagram of the interface of the drawing management module;
[0041] Figure 6 A schematic diagram of the target's base map;
[0042] Figure 7 A MAPGIS map generated based on the target base map;
[0043] Figure 8 This is a schematic diagram of the document management module interface;
[0044] Figure 9 This is a schematic diagram of the interface of the calculation and analysis module;
[0045] Figure 10 This is a schematic diagram of the results corresponding to the calculation and analysis module. Detailed Implementation
[0046] The following embodiments are further explanations and supplements to the present invention and do not constitute any limitation on the present invention.
[0047] The following describes a hydrogeological exploration information generation system according to an embodiment of the present invention, with reference to the accompanying drawings.
[0048] like Figure 1 As shown, the present invention provides a hydrogeological exploration information generation system, which includes a data management module, a document management module, a table management module, a map management module, and a system basic data module. The data management module is connected to the table management module and the map management module, respectively, and the system basic data module is connected to the document management module.
[0049] The data management module is used to acquire various exploration data from hydrogeological exploration projects;
[0050] The system's basic data module is used to store system tools;
[0051] The table management module is used to call the target table based on each exploration data, and for each exploration data, to assign the exploration data to the corresponding table cell in the target table and generate an EXCEL table. The target table is a hydrogeological exploration information table template.
[0052] The map management module is used to call the target base map based on various exploration data, convert each exploration data into a plain text file, import the plain text file into the target base map, and generate MAPGIS map. The target base map is a hydrogeological exploration information map template, and the plain text file is a format file that can be recognized by MAPGIS map.
[0053] The document management module is used to call system tools to generate Word documents from various exploration data.
[0054] Optionally, the aforementioned exploration data may include at least one of the following: exploration area data, hydrogeological mapping data, geophysical exploration data, hydrogeological drilling data, and hydrogeological test data.
[0055] Optionally, the above-mentioned exploration area data includes at least one of the basic data of the exploration area and the basic data of the borehole; the hydrogeological mapping data includes at least one of the following: fault statistics, meteorological data, collapse column data, hydrogeological survey data of small coal mines, field survey data of rivers, and field survey data of springs; the geophysical exploration data includes at least one of the following: electrical exploration data and seismic exploration data; the hydrogeological drilling data includes at least one of the following: borehole design data, borehole pipe design structure data, borehole result data, borehole pipe result data, and drilling hydrogeological observation data; and the hydrogeological test data includes at least one of the following: single-hole pumping test record data, multi-hole pumping test record data, and group-hole pumping test record data.
[0056] Optionally, the above-mentioned table management module is specifically used for:
[0057] Based on the various exploration data, select at least one table from the pre-set pumping test results table, borehole basic data table, borehole results data, borehole pipe results structure, pumping test record table, and water quality analysis table as the target table;
[0058] For each exploration data point, the exploration data is assigned to the corresponding table cell in the target table, generating an Excel spreadsheet.
[0059] Optionally, if there are no duplicate tables corresponding to the target table, the file name of the table remains unchanged. For example, if there is only one pumping test result table in the target table, the file name of the target table is Pumping Test Result Table. If there are multiple identical tables in the target table, they are named in the form of file name + number, such as Pumping Test Result Table 01 and Pumping Test Result Table 02.
[0060] Optional, such as Figure 2 As shown, the table management module can manage different tables, including but not limited to... Figure 2 The users can select a water quality analysis table from the tables managed by the table management module, as shown in the examples. This means the water quality analysis table can be used as the target table. Figure 3 The table shown is an empty table (summary table of hydrogeological test results) corresponding to the water quality analysis table. The top of the target table contains various fields to be filled in. Each field corresponds to a list cell with a preset calculation formula to calculate the specific exploration data corresponding to that list cell, such as aquifer thickness and dynamic water level.
[0061] Optional, such as Figure 4As shown, the calculated exploration data includes borehole number, starting and ending depths, still water level, drawdown, inflow rate, unit inflow rate, test time, thermal coefficient, and test date. The table management module assigns each of the above exploration data to the corresponding table cell in the target table. Based on the preset calculation formula for each table cell, the final EXCEL table can be obtained.
[0062] Optionally, the above-mentioned drawing management module is specifically used for:
[0063] Based on the various exploration data, at least one graph is selected from the preset borehole prospect column, borehole result column, pumping test result graph, and comparison column graph as the target base graph;
[0064] Each survey data point is converted into a plaintext file, which is then imported into the target base map to generate a MAPGIS map.
[0065] Optional, such as Figure 5 As shown, the drawing management module can manage, for example, Figure 5 The various types of diagrams shown allow users to select a borehole pre-designed bar chart based on the diagrams managed by the diagram management module (diagram generation management). This indicates that the borehole pre-designed bar chart can be used as the target base diagram. The target base diagram is as follows: Figure 6 The image shown is an empty diagram corresponding to the borehole pre-planning bar chart.
[0066] Optional, such as Figure 7 As shown, the various exploration data are converted into plaintext files. Figure 7 The files listed below the filenames are the plaintext files. Users can select the appropriate plaintext file to import it into the target base map, forming... Figure 7 The MAPGIS map below the columnar and perforated structures will also import the text content corresponding to the MAPGIS map in the plaintext file into the corresponding position in the target base map.
[0067] Optionally, the aforementioned system tools include technical design outlines, construction organization design outlines, and report outlines;
[0068] The document management module is specifically used for:
[0069] Use at least one of the following outlines—the technical design outline, the construction organization design outline, and the report outline—as a system tool to generate a Word document.
[0070] Optionally, the system tools also include data categories, scales, and lithology codes, making it easier for users to query and quickly generate data categories, scales, and lithology codes corresponding to exploration data.
[0071] Optionally, system tools refer to preset software or preset Word documents. The preset Word documents include design outlines, construction organization design outlines, and report outlines. The preset software includes data categories, scales, and lithology codes. Users can directly call the above software or Word documents.
[0072] Optional, such as Figure 8 As shown, users can select any outline from the various system tools managed by the document management module (document management) to directly generate an empty Word document. Users can also directly use the Word document provided by this system as a template to generate various reports.
[0073] Optional, such as Figure 1 As shown, it also includes a database, which is connected to the data management module, the table management module, and the map management module respectively;
[0074] A database is used to store various exploration data.
[0075] Optionally, for the database, users can store, query, modify, and maintain exploration data.
[0076] Optional, such as Figure 1 As shown, it also includes a calculation and analysis module, which is connected to the database, table management module and map management module respectively;
[0077] The calculation and analysis module is used to perform at least one of cluster analysis and factor analysis on each exploration data to obtain the corresponding analysis results.
[0078] Optional, such as Figure 9 As shown, among the various computational analysis methods (factor analysis, cluster analysis, G(1,1) model) corresponding to the computational analysis module, cluster analysis is selected as the method for data analysis of exploration data. The computational analysis module performs cluster analysis on each exploration data point, generating data as shown below. Figure 10 The results shown include distance coefficients from the exploration data, which are obtained through cluster analysis.
[0079] Those skilled in the art will recognize that this invention can be implemented as a system, method, or computer program product. Therefore, this disclosure can be embodied in the following forms: it can be entirely hardware, entirely software (including firmware, resident software, microcode, etc.), or a combination of hardware and software, generally referred to herein as a "circuit," "module," or "system." Furthermore, in some embodiments, the invention can also be implemented as a computer program product contained in one or more computer-readable media, which contains computer-readable program code. Computer-readable storage media can be, for example, but not limited to—electrical, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatuses, or devices, or any combination thereof.
[0080] 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 the present invention. 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. Moreover, without contradiction, those skilled in the art can combine and integrate the different embodiments or examples described in this specification, as well as the features of different embodiments or examples.
[0081] Although embodiments of the present invention have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting the present invention. Those skilled in the art can make changes, modifications, substitutions and variations to the above embodiments within the scope of the present invention.
Claims
1. A hydrogeological exploration information generation system, characterized in that, It includes a data management module, a document management module, a table management module, a map management module, and a system basic data module. The data management module is connected to the table management module and the map management module, respectively, and the system basic data module is connected to the document management module. The data management module is used to acquire various exploration data from hydrogeological exploration projects; The system's basic data module is used to store system tools; The table management module is used to call the target table according to each of the exploration data, and for each of the exploration data, assign the exploration data to the table cell corresponding to the exploration data in the target table to generate an EXCEL table. The target table is a hydrogeological exploration information table template. The map management module is used to call the target base map according to each of the exploration data, convert each of the exploration data into a plaintext file, import the plaintext file into the target base map, and generate a MAPGIS map. The target base map is a hydrogeological exploration information map template, and the plaintext file is a format file that is recognized by the MAPGIS map. The document management module is used to call the system tools and generate Word documents from each of the exploration data through the system tools; The table management module is specifically used for: Based on the various exploration data, select at least one table from the preset pumping test results table, borehole basic data table, borehole results data, borehole pipe results structure, pumping test record table, and water quality analysis table as the target table; For each of the exploration data, the exploration data is assigned to the corresponding table cell in the target table to generate an EXCEL table; The image management module is specifically used for: Based on the various exploration data, at least one diagram is selected from the pre-set borehole prospect columnar diagram, borehole result columnar diagram, pumping test result diagram, and comparison columnar diagram as the target base diagram; Each of the aforementioned exploration data is converted into a plaintext file, and the plaintext file is imported into the target base map to generate a MAPGIS map; The system tools include technical design outlines, construction organization design outlines, and report outlines; The document management module is specifically used for: The system uses at least one of the technical design outline, construction organization design outline, and report outline as a tool to generate a Word document.
2. The system according to claim 1, characterized in that, The exploration data includes at least one of the following: exploration area data, hydrogeological mapping data, geophysical exploration data, hydrogeological drilling data, and hydrogeological test data.
3. The system according to claim 2, characterized in that, The exploration area data includes at least one of the following: basic exploration area data and basic borehole data. The hydrogeological mapping data includes at least one of the following: fault statistics, meteorological data, collapse column data, small coal mine hydrogeological survey data, river field survey data, and spring field survey data. The geophysical exploration data includes at least one of the following: electrical exploration data and seismic exploration data. The hydrogeological drilling data includes at least one of the following: borehole design data, borehole casing design structure data, borehole result data, borehole casing result data, and drilling hydrogeological observation data. The hydrogeological test data includes at least one of the following: single-hole pumping test record data, multi-hole pumping test record data, and group-hole pumping test record data.
4. The system according to any one of claims 1-3, characterized in that, It also includes a database, which is connected to the data management module, the table management module and the image management module respectively; The database is used to store the various exploration data.
5. The system according to claim 4, characterized in that, It also includes a calculation and analysis module, which is connected to the database, table management module and map management module respectively; The calculation and analysis module is used to perform at least one of cluster analysis and factor analysis on each of the exploration data to obtain the analysis results corresponding to the data analysis.