Mineral product data analysis method based on software and platform and related equipment

Abstract

The invention discloses a mineral data analysis method based on software and a platform and related equipment. In the method, attribute information in a geological database map set is transferred into QGIS software through a hyperlink to perform data cleaning on the geological database map set; accessing a map page in the first map processing platform, searching a mineral point distribution map layer file, and displaying mineral point attribute information; if screening of the attribute information of the mineral production points is wrong, the attribute information of the mineral production points is transferred into a second map processing platform, and a matched file is obtained; and loading the mineral point distribution map layer file in the second map processing platform by using the matching file, and carrying out matching analysis on the mineral point distribution map layer file to obtain a first result database. In the process, the condition of attribute messy code characters is avoided through the hyperlink, and analysis processing can be performed in the second map processing platform under the condition that files in other formats except the shp format do not need to be loaded, so that the working efficiency is improved.

Description

Technical Field

[0001] The present application relates to the technical field of data analysis, and in particular to a mineral data analysis method and related equipment based on software and platform. Background Art

[0002] At present, in the field of geology, geological database atlases use CAD, mapgis, arcgis, QGIS, Leapfrog and other software and corresponding computer system tools to realize various maps of regional and mining area geology.

[0003] However, when using the above-mentioned geological software / platforms, since the software / platforms do not support certain specific data formats, such as data involving attribute tables, it is necessary to re-import and export data through a lot of intermediate software when inputting data, resulting in the entire data analysis workflow being multi-step and cumbersome, and sometimes the software / platform cannot load files in shp format, thus affecting work efficiency. Summary of the invention

[0004] The present application provides a mineral data analysis method and related equipment based on software and platform. Through hyperlinks, the software / platform can directly obtain data with attribute tables, and can also convert shp format files into a loadable state through file conversion, and then perform analysis and processing, thereby improving work efficiency.

[0005] In a first aspect, the present application provides a method for analyzing mineral data based on software and platform, the method comprising:

[0006] Transfer the attribute information in the geological database atlas into QGIS software through hyperlinks;

[0007] Using QGIS software to clean the geological database atlas and export geological data, the geological data includes mineral information and geological information other than mineral information;

[0008] Accessing the map page in the first map processing platform, and finding the mineral point distribution layer file according to the mineral point location information in the mineral information, and displaying the mineral point attribute information in the mineral information;

[0009] If the mineral point attribute information is screened incorrectly, the mineral point attribute information is transferred to the second map processing platform for file conversion to obtain supporting files;

[0010] The supporting files are used to load the mineral point distribution layer file in the second map processing platform, and the mineral point distribution layer file and the geological information other than the mineral information are matched and analyzed to obtain the first achievement database.

[0011] Optionally, use QGIS software to clean the geological database atlas and export geological data, including:

[0012] Identify and detect the data of the geological database atlas to obtain problematic data, wherein the problematic data includes data format errors, invalid values, null values ​​and abnormal values;

[0013] Clean the problematic data in the geological database atlas to obtain cleaned data;

[0014] The cleaned data are integrated and standardized to obtain geological data.

[0015] Optionally, if the mineral point attribute information is screened incorrectly, the mineral point attribute information is transferred to the second map processing platform for file conversion to obtain supporting files, including:

[0016] If the mineral point attribute information does not include the supporting file of the mineral point attribute information corresponding format file, the mineral point attribute information screening error;

[0017] The mineral point attribute information is transferred to the second map processing platform, and the mineral point attribute information is converted into a file to obtain the supporting file.

[0018] Optionally, the mineral point distribution layer file and the geological information other than the mineral information are matched and analyzed to obtain a first achievement database, including:

[0019] Matching the mineral point distribution layer file, the geological information other than the mineral information, and the Google map in the second map processing platform to obtain the first data to be analyzed;

[0020] According to the actual geological needs, the first data to be analyzed is analyzed and studied to obtain the first results database.

[0021] Optionally, the method further comprises:

[0022] If the mineral point attribute information is screened normally, load the mineral point distribution layer file in the QGIS software;

[0023] Match the mineral point distribution layer file, geological information other than mineral information and Google map in QGIS software to obtain the second data to be analyzed;

[0024] According to the actual geological needs, the second data to be analyzed is analyzed and studied to obtain the second results database.

[0025] Optionally, when the first achievement database or the second achievement database includes a planar integrated achievement database, the process of obtaining the first achievement database or the second achievement database includes:

[0026] If the actual geological demand is a greenfield project, the first data to be analyzed is integrated into the second map processing platform to form a plane comprehensive results database;

[0027] Alternatively, the second data to be analyzed is integrated into QGIS software to form a plane comprehensive results database.

[0028] Optionally, when the first achievement database or the second achievement database includes a dynamic achievement database, the process of obtaining the first achievement database or the second achievement database includes:

[0029] If the actual geological requirement is deep engineering, the first data to be analyzed or the second data to be analyzed is integrated into the LeapFrog software;

[0030] By using the spatial depth information in the LeapFrog software, the first data to be analyzed or the second data to be analyzed is transformed into a dynamic result database combining two-dimensional geographic information and a three-dimensional geological model.

[0031] In a second aspect, the present application provides a mineral data analysis device based on software and platform, the device comprising:

[0032] A processing unit for transferring the attribute information in the geological database atlas into the QGIS software through hyperlinks;

[0033] A data cleaning unit, used for cleaning the geological database atlas using QGIS software and exporting geological data, wherein the geological data includes mineral information and geological information other than mineral information;

[0034] A search and display unit is used to access the map page in the first map processing platform, and to find the mineral point distribution layer file according to the mineral point location information in the mineral information, and to display the mineral point attribute information in the mineral information;

[0035] A file conversion unit is used to transfer the mineral point attribute information to the second map processing platform for file conversion to obtain a supporting file if the mineral point attribute information is screened incorrectly;

[0036] The matching analysis unit is used to load the mineral point distribution layer file in the second map processing platform using the supporting file, and match and analyze the mineral point distribution layer file with the geological information other than the mineral information to obtain the first results database.

[0037] Optionally, the data cleaning unit is specifically used for:

[0038] Identify and detect the data of the geological database atlas to obtain problematic data, wherein the problematic data includes data format errors, invalid values, null values ​​and abnormal values;

[0039] Clean the problematic data in the geological database atlas to obtain cleaned data;

[0040] The cleaned data are integrated and standardized to obtain geological data.

[0041] Optionally, the file conversion unit is specifically used for:

[0042] If the mineral point attribute information does not include the supporting file of the format file corresponding to the mineral point attribute information, the mineral point attribute information screening error;

[0043] The mineral point attribute information is transferred to the second map processing platform, and the mineral point attribute information is converted into a file to obtain a supporting file.

[0044] Optionally, the matching analysis unit includes:

[0045] A matching subunit is used to match the mineral point distribution layer file, the geological information other than the mineral information, and the Google map in the second map processing platform to obtain the first data to be analyzed;

[0046] The analysis subunit is used to analyze and study the first data to be analyzed according to actual geological needs to obtain a first results database.

[0047] Optionally, the device further comprises:

[0048] Loading subunit, used to load the mineral point distribution layer file in QGIS software if the mineral point attribute information is screened normally;

[0049] The matching subunit is used to match the mineral point distribution layer file, the geological information other than the mineral information and the Google map in the QGIS software to obtain the second data to be analyzed;

[0050] The analysis subunit is used to analyze and study the second data to be analyzed according to actual geological needs to obtain a second results database.

[0051] Optionally, when the first achievement database or the second achievement database includes a planar comprehensive achievement database, the analysis subunit is specifically used for:

[0052] If the actual geological demand is a greenfield project, the first data to be analyzed is integrated into the second map processing platform to form a plane comprehensive results database;

[0053] Alternatively, the second data to be analyzed is integrated into QGIS software to form a plane comprehensive results database.

[0054] Optionally, when the first achievement database or the second achievement database includes a dynamic achievement database, the analyzing subunit is specifically used for:

[0055] If the actual geological requirement is deep engineering, the first data to be analyzed or the second data to be analyzed is integrated into the LeapFrog software;

[0056] By using the spatial depth information in the LeapFrog software, the first data to be analyzed or the second data to be analyzed is transformed into a dynamic result database combining two-dimensional geographic information and a three-dimensional geological model.

[0057] In a third aspect, the present application provides an electronic device, the electronic device comprising a memory and a processor:

[0058] The memory is used to store computer programs;

[0059] The processor is used to execute the method provided by the first aspect according to the computer program.

[0060] In a fourth aspect, the present application further provides a computer-readable storage medium, which is used to store a computer program, and the computer program is used to execute the method provided in the first aspect above.

[0061] It can be seen that this application has the following beneficial effects:

[0062] The present application provides a method for analyzing mineral data based on software and platform, firstly, the attribute information in the geological database atlas is transferred into QGIS software through a hyperlink; the QGIS software is used to clean the geological database atlas and derive geological data, wherein the geological data includes mineral information and geological information other than mineral information; the map page in the first map processing platform is accessed, and the mineral point distribution layer file is found according to the mineral point location information in the mineral information, and the mineral point attribute information in the mineral information is displayed; if the mineral point attribute information screening error occurs, the mineral point attribute information is transferred into the second map processing platform for file conversion to obtain a supporting file; the supporting file is used to load the mineral point distribution layer file in the second map processing platform, and the mineral point distribution layer file is matched and analyzed with the geological information other than the mineral information to obtain a first achievement database. In this process, the attribute information in the geological database atlas is transferred into the QGIS software through a hyperlink, which can avoid multiple input checks and conversion processing of attribute garbled text and other operation steps, thereby improving work efficiency. And without having to load files in formats other than shp, the mineral point distribution layer file can be directly loaded in the second map processing platform for analysis and processing, which can also improve work efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0063] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings required for use in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in the present application. For ordinary technicians in this field, other drawings can also be obtained based on these drawings.

[0064] Figure 1 A flowchart of an embodiment of a method for analyzing mineral data based on software and platform in an embodiment of the present application;

[0065] Figure 2 This is a flow chart of another embodiment of a method for analyzing mineral data based on software and platform in the embodiments of the present application;

[0066] Figure 3 This is a schematic diagram of a user using the S&P website to quickly access and locate a mineral point distribution map in an embodiment of the present application;

[0067] Figure 4 This is a schematic diagram of a user using the MapJS webpage platform to open a file in an embodiment of the present application;

[0068] Figure 5 This is a schematic diagram of a user using LeapFrog software to query data information related to a positioning geological survey database in an embodiment of the present application;

[0069] Figure 6 This is a schematic diagram of the structure of a mineral data analysis device based on software and platform in an embodiment of the present application;

[0070] Figure 7 This is a schematic diagram of the structure of an electronic device in an embodiment of the present application. DETAILED DESCRIPTION

[0071] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0072] The "first" in the names of "first map processing platform" and "first achievement database" mentioned in the embodiments of the present application is only used as a name identifier and does not mean the first in order. The same rule applies to "second", "third", etc.

[0073] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant laws, regulations and standards of relevant countries and regions.

[0074] First, the technical terms in the embodiments of the present application are explained as follows:

[0075] (1) MapGIS: is a geographic information system (GIS) software platform. It has a complete secondary development product system, opens up GIS platform capabilities to partners, and continuously launches innovative application products that meet the needs of industry users through a series of cooperation policies such as technology empowerment, training support, solution integration, and joint marketing.

[0076] (2) ArcGIS: is a comprehensive geographic information system (GIS) platform for collecting, organizing, managing, analyzing, communicating, and publishing geographic information. It supports cloud architecture, enables 3D modeling, editing, and analysis, and can share geographic information within organizations and communities or make it public on the Web.

[0077] (3) QGIS (Quantum GIS): is an open source geographic information system (GIS) software that provides a comprehensive set of data visualization, management and analysis tools. Since its creation by Gary Sherman in 2002, QGIS has grown into a platform widely used by professionals, researchers and students around the world. The software supports a variety of vector and raster data formats, including Shapefile, GeoTIFF, NetCDF, HDF5, etc., and can also directly connect to databases such as PostgreSQL / PostGIS and MySQL. It has advanced spatial analysis capabilities, customizable visualization options, and direct data editing functions. In addition, an active plugin ecosystem and Python scripting support enable users to extend the functionality of the software and automate complex GIS workflows.

[0078] (4) S&P website: Standard & Poor's, a website that provides global economic information.

[0079] (5) Leapfrog software: A 3D modeling tool designed specifically for geological sciences, widely used in industries such as mining and oil exploration.

[0080] (6) MapJS web platform: A JavaScript library for building web map applications.

[0081] At present, the traditional workflow is to enter each attribute information into the layer attribute information one by one in software platforms such as mapgis, and transfer the atlas with attribute information table into QGIS. However, due to the local incompatibility between software during the transfer process, the Chinese attribute information in the attribute tables of mapgis, arcgis, etc. will be garbled, which requires the addition of a lot of intermediate software, re-import and export the garbled text, or re-enter the Chinese attribute information in Qgis, etc., resulting in this cumbersome process with many steps and cumbersome. And sometimes the obtained shp format file does not carry other format files, such as cpg, dbf, qmd, shx and other supporting format files, then the shp format file cannot be loaded in the software platform, so the operation process cannot be completed.

[0082] In the embodiment of the present application, the software / platform can directly obtain data with attribute tables through hyperlinks, and the files in shp format can also be converted into a loadable state through file conversion, thereby improving work efficiency. In specific implementation, the method may include, for example: first, transferring the attribute information in the geological database atlas into the QGIS software through a hyperlink; using the QGIS software to clean the geological database atlas and export geological data, wherein the geological data includes mineral information and geological information other than mineral information; accessing the map page in the first map processing platform, and finding the mineral point distribution layer file according to the mineral point location information in the mineral information, and displaying the mineral point attribute information in the mineral information; if the mineral point attribute information is screened incorrectly, the mineral point attribute information is transferred to the second map processing platform for file conversion to obtain a matching file; using the matching file to load the mineral point distribution layer file in the second map processing platform, and matching and analyzing the mineral point distribution layer file and the geological information other than the mineral information to obtain the first achievement database.

[0083] It can be seen that the method provided by the implementation of this application can transfer the attribute information in the geological database atlas into the QGIS software through hyperlinks, which can avoid multiple input checks and conversion processing of attribute garbled text and other operation steps, thereby improving work efficiency. In addition, without the need to load files in other formats other than shp format, the mineral point distribution layer file can be directly loaded in the second map processing platform for analysis and processing, which can also improve work efficiency.

[0084] To facilitate understanding of the specific implementation of a software and platform-based mineral data analysis method provided in an embodiment of the present application, it will be described below with reference to the accompanying drawings.

[0085] It should be noted that the subject implementing the software and platform-based mineral data analysis method may be a software and platform-based mineral data analysis device provided in the embodiment of the present application, and the software and platform-based mineral data analysis device may be carried in an electronic device or a functional module of an electronic device. The electronic device in the embodiment of the present application may be any device capable of implementing the software and platform-based mineral data analysis method in the embodiment of the present application, such as an Internet of Things (IoT) device.

[0086] Figure 1 A flowchart of a method for analyzing mineral data based on software and platform provided in an embodiment of the present application is provided. The method can be applied to a mineral data analysis device based on software and platform, and the mineral data analysis device based on software and platform can be, for example, Figure 6 The mineral data analysis device 600 based on software and platform is shown, or the mineral data analysis device based on software and platform can also be integrated in Figure 7 Functional modules in the electronic device 700 are shown.

[0087] like Figure 1 As shown, the method includes the following S101 to S105:

[0088] S101: Transfer the attribute information in the geological database atlas into the QGIS software through hyperlinks.

[0089] In order to analyze the mineral data, the embodiment of the present application first transfers the attribute information in the geological database atlas into the QGIS software through a hyperlink; uses the QGIS software to clean the geological database atlas and derive geological data, wherein the geological data includes mineral information and geological information other than mineral information; accesses the map page in the first map processing platform, and finds the mineral point distribution layer file according to the mineral point location information in the mineral information, and displays the mineral point attribute information in the mineral information; if the mineral point attribute information is screened incorrectly, the mineral point attribute information is transferred to the second map processing platform for file conversion to obtain a matching file; loads the mineral point distribution layer file in the second map processing platform, and matches and analyzes the mineral point distribution layer file with the geological information other than the mineral information to obtain the first achievement database. Therefore, in the embodiment of the present application, the attribute information in the geological database atlas is transferred to the QGIS software through S101 so that the geological data can be obtained later.

[0090] In the prior art, each attribute information is entered into the layer attribute information one by one, and the atlas with the attribute information table is transferred to QGIS. However, due to the local incompatibility between software, the Chinese information in the attribute information table will be garbled. In this regard, in the embodiment of the present application, the attribute tables in mapgis and arcgis are first exported in batches, and then the attribute information can be directly transferred to QGIS in batches through hyperlinks, avoiding multiple entry checks and conversion processing of garbled attribute text, thereby improving work efficiency.

[0091] S102: Using QGIS software to clean the geological database atlas and export geological data, where the geological data includes mineral information and geological information other than mineral information.

[0092] As an example, S102 may include: S1021, identifying and detecting data in a geological database atlas to obtain problem data, wherein the problem data includes data format errors, invalid values, null values, and abnormal values; S1022, cleaning the problem data in the geological database atlas to obtain cleaned data; S1023, integrating and standardizing the cleaned data to obtain geological data.

[0093] Geological database atlases usually contain a large amount of spatial information, which is used to study the surface characteristics of the earth, the distribution of underground mineral resources, and the prediction of geological disasters. Since there may be multiple sources and technical means in the data collection process, the data quality of geological database atlases may be uneven, including but not limited to data missing, duplicate records, and redundant information, so data cleaning is required. In order to facilitate the understanding of data cleaning, the attribute data of the geological database atlas can be briefly explained, where the attribute data is displayed in the form of an attribute table, in which the header represents the various attribute information contents that need to be matched with each geological database atlas, that is, the content of data information interpretation of the geological database atlas content, such as the header in the geological area attribute table contains strata, lithology, age, etc., and the attribute information table of the mineral point contains the mining status of the mineral point, the coordinates of the mineral point, the mining right holder, the type of mineral, etc. There may be problems such as data format errors, invalid values, null values, and abnormal values ​​in these attribute tables, which require data cleaning.

[0094] First, in S1021, the data of the geological database atlas is identified for problems, such as data format errors, invalid values, null values, and abnormal values. The tools provided by QGIS are then used to help detect data quality. For example, the attribute table is used to view the attribute values ​​of each feature, or spatial queries are used to find features under specific conditions. After the problem data is identified, the data is cleaned up in S1022. The specific process may include: (1) Deleting duplicate records: Duplicate data not only takes up unnecessary storage space, but may also cause deviations in statistical analysis results. Duplicate records can be identified and deleted by comparing attribute fields or using spatial indexes. (2) Handling missing values: Decide how to handle missing values ​​based on the specific situation. You can choose to delete records with missing values, or try to use interpolation or other statistical methods to fill in missing values. (3) Eliminating redundant data: Redundant data refers to information that is not completely repeated but can be derived from other data. The existence of such data increases the complexity of the data set and should be minimized. Finally, the data is integrated and standardized through S1023. The specific process may include: (1) Data conversion: In order to make data from different sources compatible with each other, it may be necessary to perform data type conversion, coordinate system transformation, etc. (2) Standardized data format: Ensure that all data follow the same format standard, so as to avoid errors caused by format problems in subsequent analysis.

[0095] In addition, the embodiments of the present application may also include: setting rules to continuously monitor the quality of geological data and regularly performing data cleaning tasks on geological data; and retaining historical records in the process data of data cleaning, wherein the historical records are modification records of geological data, wherein retaining historical records is very important for tracking data sources, understanding reasons for data changes, and reproducing analysis processes.

[0096] In this process, by cleaning the geological database atlas and exporting the geological data, the data quality of the geological database atlas can be improved, making it more suitable for further analysis or display.

[0097] S103: Accessing the map page in the first map processing platform, and finding the mineral point distribution layer file according to the mineral point location information in the mineral information, and displaying the mineral point attribute information in the mineral information.

[0098] As an example, S103 may include: accessing the first map processing platform is to access the S&P website and enter the map page. In the map page, the mineral point distribution layer file can be found according to the mineral point location information in the mineral information. This operation not only optimizes the user's operation process, making the mineral point distribution information easy to find and locate, but also lays the foundation for further data analysis and spatial analysis using QGIS. In the S&P website, users can also directly open the mineral point attribute information in the mineral information corresponding to the QGIS format file. This operation not only facilitates users to view the specific data of the mineral point, but also allows further in-depth analysis of these data. Users can use the powerful spatial analysis function of QGIS to conduct in-depth research on the distribution law of mineral points, the correlation of geological structures, etc., so as to provide a scientific basis for the fields of mineral resource management, environmental protection and urban planning.

[0099] In this process, the integration of the S&P website and QGIS enables users to obtain and analyze mineral point data on a unified platform, improving work efficiency. For geologists, mineral resource managers and other professionals who need to use mineral point data, the combination of the S&P website and QGIS provides them with a convenient and efficient data analysis tool.

[0100] S104: If the mineral point attribute information is screened incorrectly, the mineral point attribute information is transferred to the second map processing platform for file conversion to obtain a supporting file.

[0101] As an example, S104 may include: S1041, if the mineral point attribute information does not include a supporting file of the format file corresponding to the mineral point attribute information, the mineral point attribute information screening error; S1042, transferring the mineral point attribute information to the second map processing platform, and converting the mineral point attribute information to a file to obtain a supporting file.

[0102] In the above S1041, for example, on the S&P website, data can be filtered by setting different constraints in the attribute information table. If the attribute information does not meet the requirements and filtering cannot be performed, the main reason is that the supporting file corresponding to the shp format file of the attribute information is missing, such as cpg, dbf, qmd, shx, etc. If one of these supporting format files is missing, the mineral point distribution layer file cannot be opened through QGIS, ArcGIS and other software subsequently, so the supporting file needs to be obtained again.

[0103] In this regard, the above S1042 and S1043 obtain supporting files by transferring the mineral point attribute information to the second map processing platform for folder conversion. When the second map processing platform is the MapJS web platform, the specific process may include: when accessing the MapJS web platform, you can directly open the QGIS .shp format file, that is, the mineral point attribute information, convert the mineral point attribute information through files, and retrieve the missing supporting files, so that you can obtain the supporting files, so that you can directly open the mineral point distribution layer file in the MapJS web platform.

[0104] During this process, the corresponding supporting files of the mineral point distribution layer file that cannot be opened normally can be retrieved through the second map processing platform, so that the mineral point distribution layer file can be opened directly in the MapJS web platform.

[0105] S105: Using the supporting files, the mineral point distribution layer file is loaded in the second map processing platform, and the mineral point distribution layer file is matched and analyzed with the geological information other than the mineral information to obtain the first achievement database.

[0106] As an example, S105 may include: S1051, matching the mineral point distribution layer file, geological information other than mineral information and Google Maps in the second map processing platform to obtain first data to be analyzed; S1052, analyzing and studying the first data to be analyzed according to actual geological needs to obtain a first results database.

[0107] Since the above S1051 has supporting files, data analysis and processing can be performed directly on the second map processing platform, that is, S1052 can be executed, which may specifically include: if the actual geological demand is a greenfield project, the first data to be analyzed is integrated into the second map processing platform to form a plane comprehensive results database. In this process, the MapJS web platform can efficiently perform spatial relationship analysis, and by directly opening the .shp format file corresponding to the QGIS software, it helps geologists quickly identify the distribution pattern of mineral points and the correlation of geological structures, providing a scientific basis for prospecting; at the same time, it also provides geologists and mineral resource managers with accurate decision support information, helping them make more informed decisions, thereby achieving the goal of quickly guiding prospecting.

[0108] It should be noted that S1052 may also include: if the actual geological demand is a deep project, the first data to be analyzed is integrated into the LeapFrog software; using the spatial depth information in the LeapFrog software, the first data to be analyzed is formed into a dynamic result database combining two-dimensional geographic information and three-dimensional geological models. In this process, the .shp format file in QGIS is imported into the LeapFrog software, and the user can integrate the two-dimensional geographic information and the three-dimensional geological model in a single working environment to achieve efficient docking of multi-source data. This integrated processing method eliminates the tediousness of switching between different software, optimizes the workflow, and improves work efficiency. And the efficient docking of multi-source data can enable data from different sources to be seamlessly docked in Leapfrog, which is of great significance for resource assessment, risk analysis, and providing comprehensive information support for decision makers. For example, this integration method can provide significant help in assessing the location, scale and grade of mineral resources, or in analyzing geological risks, providing a basis for engineering design and environmental protection.

[0109] As an example, for the case where the mineral point attribute information is normally screened, the embodiment of the present application may also include: if the mineral point attribute information is normally screened, loading the mineral point distribution layer file in the QGIS software; matching the mineral point distribution layer file, geological information other than the mineral information, and Google Maps in the QGIS software to obtain second data to be analyzed; analyzing and studying the second data to be analyzed according to actual geological needs to obtain a second results database.

[0110] Since the mineral point attribute information is normally screened, it indicates that the mineral point distribution layer file has a supporting file, so the mineral point distribution layer file can be loaded in the QGIS software. The follow-up can also include: matching the mineral point distribution layer file, geological information other than mineral information and Google Maps in the QGIS software to obtain the second data to be analyzed; according to the actual geological needs, the second data to be analyzed is analyzed and studied to obtain the second results database.

[0111] Consistent with the above, if the actual geological demand is a greenfield project, the second data to be analyzed will be integrated into the QGIS software to form a plane comprehensive results database. If the actual geological demand is a deep project, the second data to be analyzed will be integrated into the LeapFrog software; using the spatial depth information in the LeapFrog software, the second data to be analyzed will be formed into a dynamic results database combining two-dimensional geographic information and three-dimensional geological models.

[0112] In this process, the data to be analyzed can be integrated into the corresponding software or platform for analysis according to the characteristics of different software or platforms and user needs, so that the corresponding results database can be obtained.

[0113] It can be seen that the embodiment of the present application transfers the attribute information in the geological database atlas into the QGIS software through a hyperlink, which can avoid multiple input checks and conversion processing of attribute garbled text and other operation steps, thereby improving work efficiency. In addition, when there is no need to load other format files other than shp format, such as cpg, dbf, qmd, shx and other supporting format files, the mineral point distribution layer file can be directly loaded in the MapJS web page platform to quickly and efficiently open the shp file for review and conversion.

[0114] In order to make the method provided in the embodiment of the present application clearer and easier to understand, Figure 2 A specific example of this method is described.

[0115] like Figure 2 As shown, the implementation may include:

[0116] S201: Transfer the attribute information in the geological database atlas into the QGIS software through hyperlinks.

[0117] In order to avoid the occurrence of garbled attribute information, the embodiment of the present application exports the attribute tables in mapgis and arcgis in batches, and then directly transfers them to the QGIS software in batches through hyperlinks, avoiding multiple input checks and conversion processing of garbled attribute text, thereby improving work efficiency.

[0118] S202: Using QGIS software to clean the geological database atlas and export geological data, where the geological data includes mineral information and geological information other than mineral information.

[0119] In order to improve the quality of the data, it is necessary to use QGIS software to clean the geological database atlas and export the geological data.

[0120] Rules can also be set to continuously monitor the quality of geological data and regularly perform data cleaning tasks on geological data; and retain historical records in the data cleaning process data, which are modification records of geological data, so that data sources can be tracked later, reasons for data changes can be understood, and the analysis process can be reproduced.

[0121] S203: Visit the map page on the S&P website and find the mineral point distribution layer file based on the mineral point location information in the mineral information.

[0122] In the embodiment of the present application, after visiting the S&P website, find and click the "Map" option on the S&P webpage to enter the map page. And you can click "Add content" on the map page and select "Mineral Occurrences", and the user can quickly access and locate the mineral point distribution map, such as Figure 3 This function not only optimizes the user's operating process, making it easy to find and locate mineral point distribution information, but also lays the foundation for further data analysis and spatial analysis using QGIS.

[0123] S204: Display the mineral point attribute information in the mineral information on the S&P website, and set filtering conditions to filter the mineral point attribute information.

[0124] On the S&P website, users can directly right-click "View Data Grid" to open the attribute information table corresponding to the QGIS format file, that is, to display the mineral point attribute information in the mineral information. This operation not only allows users to view the specific data of the mineral points, but also allows further in-depth analysis of these data. Users can use QGIS's powerful spatial analysis function to conduct in-depth research on the distribution patterns of mineral points, the correlation of geological structures, etc., thereby providing a scientific basis for the fields of mineral resource management, environmental protection, and urban planning.

[0125] On the S&P website, users can use QGIS to import, integrate and perform spatial analysis on data, such as combining demographic data and economic indicators to analyze the economic development potential of a specific area. In addition, QGIS also has powerful visualization capabilities that can help users convert complex data into intuitive maps to better understand economic trends and patterns.

[0126] In addition, by clicking the setting icon in the attribute information table on the S&P website and selecting "AdvancedFilter", users can set different constraints to filter data. For example, by setting the mineral type constraint to "Gold", the gold mineral point distribution map can be displayed. After the filtering is completed, the filtered data can be exported to a format file supported by QGIS, that is, a Shapefile format file with the suffix .shp, by clicking "Export to Shapefile".

[0127] S205: Determine whether the mineral point attribute information can be screened.

[0128] In the prior art, Shapefile format files may not have supporting files, which may result in the subsequent inability to be loaded into the QGIS software for analysis, i.e., the workflow cannot be completed. In this regard, in the embodiment of the present application, the mineral point attribute information is screened by setting screening conditions to determine whether the mineral point attribute information can be screened. If the mineral point attribute information cannot be screened, it indicates that the mineral point distribution layer file does not have supporting files, and the supporting files need to be retrieved, i.e., S206 is executed; if the mineral point attribute information can be screened normally, it indicates that the mineral point distribution layer file has supporting files, and the subsequent process can continue to be executed normally, i.e., S208 is executed.

[0129] S206: If the mineral point attribute information is incorrectly screened, the mineral point attribute information is transferred to the MapJS web platform for file conversion to obtain supporting files.

[0130] If the mineral point attribute information is incorrectly screened, the QGIS .shp format file can be directly opened in the MapJS web platform, such as loading the mineral point distribution layer file. Users can easily access and view geological data without installing any professional software. This convenient online operation method greatly reduces the technical threshold through simple file addition or drag and drop, making mineral prospecting easier. Figure 4 As shown, you can open it by simply adding files or dragging them to the web page.

[0131] S207: Using the supporting files, the mineral point distribution layer file is loaded in the MapJS web page platform, and the mineral point distribution layer file, the geological information other than the mineral information and the Google map are matched to obtain the first data to be analyzed.

[0132] In order to obtain the file to be analyzed, the mineral point distribution layer file can be directly loaded in the MapJS web platform, that is, Google image matching can be directly performed in the MapJS web platform to obtain the first data to be analyzed.

[0133] S208: If the mineral point attribute information is screened normally, the mineral point distribution layer file is loaded into the QGIS software.

[0134] S209: Load the mineral point distribution layer file in the QGIS software, and match the mineral point distribution layer file, the geological information other than the mineral information, and the Google map to obtain the second data to be analyzed.

[0135] In order to obtain the file to be analyzed, the mineral point distribution layer file can be loaded into the QGIS software, that is, Google image matching can be performed directly in the QGIS software to obtain the second data to be analyzed.

[0136] S210: If the actual geological demand is a greenfield project, the first data to be analyzed is integrated into the MapJS web platform or the second data to be analyzed is integrated into the QGIS software to form a plane comprehensive results database.

[0137] The real-time update and cross-platform features of the MapJS web platform ensure that exploration data is instantly accessible, improving the response speed and flexibility in the field of geological exploration. Users can view and update data in real time on any device, and can highlight key geological information by adjusting the background layer to support efficient decision-making. Data processing can also be performed directly in the QGIS software to achieve various data analysis functions such as spatial analysis.

[0138] S211: If the actual geological requirement is a deep engineering project, the first data to be analyzed or the second data to be analyzed is integrated into the LeapFrog software to form a dynamic results database combining two-dimensional geographic information and three-dimensional geological models.

[0139] If the actual geological demand is for deep engineering, the data to be analyzed needs to be integrated into the LeapFrog software, that is, the spatial depth information in the LeapFrog software is needed to form the data to be analyzed into a dynamic results database that combines two-dimensional geographic information and three-dimensional geological models. That is, the imported plane vector diagram (data to be analyzed) can be integrated with the existing three-dimensional solid model in Leapfrog. In this way, users can combine two-dimensional geographic information with three-dimensional geological models to obtain a more comprehensive spatial view. In addition, by right-clicking on the "Attribute Table" of the layer file, you can open the data table in the layer. In the attribute table, users can use the filtering function to efficiently query data information related to the positioning geological survey database. Such as Figure 5 As shown, by setting constraints such as the mineral type as "Au" (gold) and the mineral distribution location as "Australia", a distribution map of gold mineral production points in Australia can be quickly and efficiently generated.

[0140] In this integrated environment, the seamless connection between two-dimensional geographic information and three-dimensional geological models enables users to conduct a comprehensive analysis of geological conditions from different dimensions. This not only helps to better understand the relationship between the surface and underground structures, but also ensures the consistency and accuracy of the data, because all data will be displayed and analyzed in the same coordinate system and scale. The advantage of this multi-source data integration is that it enhances data interoperability, allowing data from different sources to be seamlessly connected in Leapfrog. This is of great significance for resource assessment, risk analysis, and providing comprehensive information support to decision makers. For example, this integration method can provide significant help in evaluating the location, scale and grade of mineral resources, or in analyzing geological risks and providing a basis for engineering design and environmental protection.

[0141] This embodiment provides a mineral data analysis method based on software and platform. Through the analysis of innovative application cases of QGIS format files in the S&P website, LeapFrog software and MapJS web platform, it can be found that QGIS software can not only optimize the data processing process and improve the efficiency of data analysis and model building, but also provide accurate decision support information for geologists and mineral resource managers.

[0142] See also Figure 6 The embodiment of the present application provides a mineral data analysis device 600 based on software and platform, and the device includes:

[0143] Processing unit 601, used for transferring the attribute information in the geological database atlas into QGIS software through a hyperlink;

[0144] A data cleaning unit 602 is used to clean the geological database atlas using QGIS software and derive geological data, wherein the geological data includes mineral information and geological information other than mineral information;

[0145] The search and display unit 603 is used to access the map page in the first map processing platform, and to search for the mineral point distribution layer file according to the mineral point location information in the mineral information, and to display the mineral point attribute information in the mineral information;

[0146] The file conversion unit 604 is used to transfer the mineral point attribute information to the second map processing platform for file conversion to obtain a supporting file if the mineral point attribute information screening error occurs;

[0147] The matching analysis unit 605 is used to load the mineral point distribution layer file in the second map processing platform using the supporting files, and to match and analyze the mineral point distribution layer file with the geological information other than the mineral information to obtain the first results database.

[0148] Optionally, the data cleaning unit 602 is specifically used for:

[0149] Identify and detect the data of the geological database atlas to obtain problematic data, wherein the problematic data includes data format errors, invalid values, null values ​​and abnormal values;

[0150] Clean the problematic data in the geological database atlas to obtain cleaned data;

[0151] The cleaned data are integrated and standardized to obtain geological data.

[0152] Optionally, the file conversion unit 604 is specifically used for:

[0153] If the mineral point attribute information does not include the supporting file of the format file corresponding to the mineral point attribute information, the mineral point attribute information screening error;

[0154] The mineral point attribute information is transferred to the second map processing platform, and the mineral point attribute information is converted into a file to obtain a supporting file.

[0155] Optionally, the matching analysis unit 605 includes:

[0156] A matching subunit is used to match the mineral point distribution layer file, the geological information other than the mineral information, and the Google map in the second map processing platform to obtain the first data to be analyzed;

[0157] The analysis subunit is used to analyze and study the first data to be analyzed according to actual geological needs to obtain a first results database.

[0158] Optionally, the device 600 further includes:

[0159] Loading subunit, used to load the mineral point distribution layer file in QGIS software if the mineral point attribute information is screened normally;

[0160] The matching subunit is used to match the mineral point distribution layer file, the geological information other than the mineral information and the Google map in the QGIS software to obtain the second data to be analyzed;

[0161] The analysis subunit is used to analyze and study the second data to be analyzed according to actual geological needs to obtain a second results database.

[0162] Optionally, when the first achievement database or the second achievement database includes a planar comprehensive achievement database, the analysis subunit is specifically used for:

[0163] If the actual geological demand is a greenfield project, the first data to be analyzed is integrated into the second map processing platform to form a plane comprehensive results database;

[0164] Alternatively, the second data to be analyzed is integrated into QGIS software to form a plane comprehensive results database.

[0165] Optionally, when the first achievement database or the second achievement database includes a dynamic achievement database, the analyzing subunit is specifically used for:

[0166] If the actual geological requirement is deep engineering, the first data to be analyzed or the second data to be analyzed is integrated into the LeapFrog software;

[0167] By using the spatial depth information in the LeapFrog software, the first data to be analyzed or the second data to be analyzed is transformed into a dynamic result database combining two-dimensional geographic information and a three-dimensional geological model.

[0168] It should be noted that the specific implementation method and effect of the mineral data analysis device 600 based on software and platform can be found in the above Figure 1 or Figure 2 The relevant descriptions in the provided methods will not be repeated here.

[0169] The present application embodiment also provides an electronic device 700, such as Figure 7 As shown, the device 700 includes a memory 701 and a processor 702:

[0170] The memory 701 is used to store computer programs;

[0171] The processor 702 is used to execute the above Figure 1 or Figure 2 The method provided.

[0172] In addition, the present application also provides a computer-readable storage medium, the computer-readable storage medium is used to store a computer program, and the computer program is used to execute Figure 1 or Figure 2 The method provided.

[0173] Through the description of the above implementation methods, it can be known that those skilled in the art can clearly understand that all or part of the steps in the above-mentioned embodiment method can be implemented by means of software plus a general hardware platform. Based on such an understanding, the technical solution of the present application can be embodied in the form of a software product, which can be stored in a storage medium, such as a read-only memory (ROM) / RAM, a magnetic disk, an optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, a server, or a network communication device such as a router) to execute the methods described in each embodiment of the present application or some parts of the embodiments.

[0174] Each embodiment in this specification is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment. The device embodiment described above is only schematic, in which the modules described as separate components may or may not be physically separated, and the components displayed as modules may or may not be physical modules, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules can be selected according to actual needs to achieve the goals of the scheme of this embodiment. Ordinary technicians in this field can understand and implement it without paying creative work.

[0175] The above description is merely an exemplary embodiment of the present application and is not intended to limit the protection scope of the present application.

Claims

1. A method for analyzing mineral data based on software and platform, characterized in that: The method comprises: Transfer the attribute information in the geological database atlas into QGIS software through hyperlinks; Using the QGIS software to clean the geological database atlas and derive geological data, the geological data including mineral information and geological information other than mineral information; Accessing a map page in the first map processing platform, and finding a mineral point distribution layer file according to the mineral point location information in the mineral information, and displaying the mineral point attribute information in the mineral information; If the mineral point attribute information is screened incorrectly, the mineral point attribute information is transferred to the second map processing platform for file conversion to obtain a supporting file; The supporting file is used to load the mineral point distribution layer file in the second map processing platform, and the mineral point distribution layer file and the geological information other than the mineral information are matched and analyzed to obtain the first results database.

2. The method according to claim 1, characterized in that The method of using the QGIS software to clean the geological database atlas and export geological data includes: Identifying and detecting the data of the geological database atlas to obtain problematic data, wherein the problematic data includes data format errors, invalid values, null values, and abnormal values; Cleaning the problematic data in the geological database atlas to obtain cleaned data; The cleaned data are integrated and standardized to obtain the geological data.

3. The method according to claim 1, characterized in that If the mineral point attribute information is screened incorrectly, the mineral point attribute information is transferred to the second map processing platform for file conversion to obtain a supporting file, including: If the mineral point attribute information does not include a supporting file of a format file corresponding to the mineral point attribute information, the mineral point attribute information is screened incorrectly; The mineral point attribute information is transferred to the second map processing platform, and the mineral point attribute information is converted into a file to obtain the supporting file.

4. The method according to claim 1, characterized in that The matching analysis of the mineral point distribution layer file and the geological information other than the mineral information to obtain a first achievement database includes: Matching the mineral point distribution layer file, the geological information other than the mineral information, and Google Maps in the second map processing platform to obtain first data to be analyzed; According to actual geological needs, the first data to be analyzed are analyzed and studied to obtain the first results database.

5. The method according to claim 1, characterized in that: The method further comprises: If the mineral point attribute information is normally screened, the mineral point distribution layer file is loaded into the QGIS software; Matching the mineral point distribution layer file, the geological information other than the mineral information, and the Google map in the QGIS software to obtain the second data to be analyzed; According to actual geological needs, the second data to be analyzed is analyzed and studied to obtain the second results database.

6. The method according to claim 1, characterized in that When the first achievement database or the second achievement database includes a planar integrated achievement database, the process of obtaining the first achievement database or the second achievement database includes: If the actual geological demand is a greenfield project, the first data to be analyzed is integrated into the second map processing platform to form the plane comprehensive results database; Alternatively, the second data to be analyzed is integrated into the QGIS software to form the plane comprehensive results database.

7. The method according to claim 1, characterized in that When the first achievement database or the second achievement database includes a dynamic achievement database, the process of obtaining the first achievement database or the second achievement database includes: If the actual geological requirement is deep engineering, integrating the first data to be analyzed or the second data to be analyzed into the LeapFrog software; The spatial depth information in the LeapFrog software is used to form the first data to be analyzed or the second data to be analyzed into the dynamic achievement database combining two-dimensional geographic information and a three-dimensional geological model.

8. A mineral data analysis device based on software and platform, characterized in that: The device comprises: A processing unit for transferring the attribute information in the geological database atlas into the QGIS software through hyperlinks; A data cleaning unit, used to clean the geological database atlas using the QGIS software and derive geological data, wherein the geological data includes mineral information and geological information other than mineral information; A search and display unit, used to access the map page in the first website, and to search for a mineral point distribution layer file according to the mineral point location information in the mineral information, and to display the mineral point attribute information in the mineral information; A file conversion unit, for transferring the mineral point attribute information to a second map processing platform for file conversion to obtain a matching file if the mineral point attribute information is screened incorrectly; A matching analysis unit is used to use the supporting file to load the mineral point distribution layer file in the second map processing platform, and match and analyze the mineral point distribution layer file with the geological information other than the mineral information to obtain a first results database.

9. An electronic device, characterized in that: The electronic device comprises a memory and a processor, wherein the processor is used to execute a program stored in the memory to run the method according to any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium is used to store a computer program, and the computer program is used to execute the method according to any one of claims 1 to 7.

Images