A method for constructing and calculating three-dimensional stratigraphic model based on ArcGIS
Through ArcGIS software and exploratory interpolation tool, the best interpolation method was selected and a three-dimensional stratigraphic model was constructed, which solved the problem of low calculation accuracy in shallow strata exploration, and achieved efficient and low-cost 3-dimensional strata modeling and volume calculation.
Patent Information
- Application Number
- CN202311530923.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2023-11-16
- Publication Date
- 2024-11-19
- Estimated Expiration
- 2043-11-16
AI Technical Summary
In the exploration of shallow strata, the calculation accuracy is low and it is difficult to form visual results, or professional software with high cost and high learning difficulty is required to perform three-dimensional strata modeling.
ArcGIS software is used to collect drilling data, use exploratory interpolation tools to select the best interpolation method, convert it into triangular irregular surface data, and use the polyhedral data format to build a three-dimensional stratigraphic model and calculate the volume.
It improves the accuracy and efficiency of the three-dimensional model, reduces the modeling cost, and realizes automated construction and functional scalability.
Smart Images

Figure CN117351165B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of geological three-dimensional modeling, and in particular to a method for constructing and calculating a three-dimensional stratum model based on ArcGIS. Background Art
[0002] In the field of geological exploration, especially in the exploration of shallow strata, it is usually necessary to understand the spatial distribution of strata and evaluate the volume of specific strata in order to complete the feasibility study and construction design of engineering projects. For a long time, there are two methods in the industry to solve the above needs. One is to use the spatial position point information of the top and bottom of the strata revealed by the boreholes in the study area to interpolate into surface information, and calculate the volume by evaluating the average distance between the two surface elements. This method is simple and easy to use, but the measurement accuracy is low and it is difficult to form visual results; the other is to use professional geological modeling or mapping software, such as GOCAD and Petrel. Professional software has high learning costs, long modeling time, high requirements for data accuracy of exploration data, and large geological exploration projects. ArcGIS software, as a professional software in the field of surveying and mapping geographic information, is usually used for surveying and mapping data processing above the surface. Summary of the invention
[0003] The purpose of the present invention is to provide a method for constructing and calculating a three-dimensional stratigraphic model based on ArcGIS in view of the above deficiencies in the prior art.
[0004] The technical solution adopted by the present invention is: a method for constructing and calculating a three-dimensional stratigraphic model based on ArcGIS, comprising the following steps:
[0005] Step 1: Collect and organize the stratigraphic layer information reflected in the drilling data of the study area for constructing a three-dimensional stratigraphic model, and record the bottom elevation data information layer by layer in a table form from top to bottom in the vertical space;
[0006] Step 2: The data table obtained in step 1 is converted into vector point feature class data with spatial location attributes through the ArcGIS software's "MakeXYEventLayer" event layer creation tool, and the layered information in the data table and the Z coordinate data of the bottom elevation of the stratum in the borehole are synchronously transmitted;
[0007] Step 3: Based on the vector point feature class data obtained in step 2, use the ArcGIS software exploratory interpolation tool layer by layer to obtain the interpolation results of each layer using multiple interpolation methods and the cross-validation results corresponding to each interpolation result. Use "prediction accuracy" as the evaluation index and select the interpolation method with the highest "prediction accuracy" value in the cross-validation result as the interpolation method used in this layer;
[0008] Step 4: For each layer, the interpolation method selected in step 3 is used to select the interpolation tool corresponding to the ArcGIS software layer by layer, and the study area is used as the control range of the output raster data to obtain the elevation raster data of the bottom of each stratum through interpolation operation;
[0009] Step 5: Based on the spatial distribution order of the geological survey data of the strata from top to bottom in the vertical direction, starting from the bottom elevation raster data of the first layer, the "conditional function" tool in the platform map algebra function of ArcGIS software is used to process the "abnormal pixel value" layer by layer;
[0010] Step 6: Convert the stratum bottom elevation raster data corrected in step 5 into a TIN dataset, i.e., triangulated irregular surface data, using the “RasterTin” tool in ArcGIS software;
[0011] Step 7: According to the spatial distribution order of the stratigraphic survey data from top to bottom in the vertical direction, select the top and bottom TIN datasets layer by layer, and use the "Extrude Between Two TINs" tool in ArcGIS software to convert them into polyhedral three-dimensional vector data (MultiPatch), that is, a three-dimensional stratigraphic model;
[0012] Step 8: Use the “Surface Difference” tool in ArcGIS software to calculate the volume of each layer using the top and bottom TIN data sets corresponding to each layer; add the volume value of each layer to the attributes of the corresponding layer polyhedron data in the three-dimensional stratigraphic model generated in step 7 to obtain a three-dimensional stratigraphic model containing volume attribute information.
[0013] Furthermore, in step 2, the vector point feature class data is a data type in ArcGIS software that independently records the location and attribute information of spatial points in two-dimensional or three-dimensional coordinate information.
[0014] Furthermore, in step 3, multiple interpolation methods are used layer by layer, including: simple kriging, ordinary kriging, universal kriging, empirical Bayesian kriging, local polynomial kernel interpolation, inverse distance weighted method, radial basis function method, radial basis function interpolation, and global polynomial interpolation; each layer shall adopt the cross-validation results obtained by the above-mentioned different interpolation methods, take "prediction accuracy" as the evaluation index, and select the interpolation method with the highest "prediction accuracy" value as the interpolation method used in this layer.
[0015] Furthermore, in step 5, the "abnormal pixel value" is processed by the following specific steps: taking the "bottom surface elevation grid of the low-level stratum" as the data to be modified, setting the judgment condition as "the bottom surface elevation value of the low-level stratum is greater than the bottom surface elevation value of the high-level stratum", and modifying the pixel value that meets the condition to the bottom surface elevation value of the high-level stratum at the same position.
[0016] Furthermore, in step 8, the “Extrude Between Two TINs” tool of ArcGIS software can be used to fill the polyhedron data between the surfaces represented by the two TINs, that is, the conversion from two-dimensional to three-dimensional is realized, and the “Surface Difference” tool of ArcGIS software can be used to calculate the surface difference between the two TINs. ” The tool can calculate the displacement between two surfaces to determine the upper and lower positions of the surfaces or the upper and lower positions of the two surfaces, and can also obtain the volume of the formation contained between the two surfaces.
[0017] The beneficial effect of the present invention is that the present invention selects a suitable interpolation method to complete the conversion of data information from "point" to "surface" according to the data characteristics of each stratum in the geological exploration drilling information, thereby improving the accuracy of the three-dimensional model and volume evaluation. This technical effect comes from step 3 of the technical solution of the present invention, using the "Exploratory Interpolation" tool, which can simultaneously use a variety of mainstream interpolation algorithms, including: simple kriging, ordinary kriging, universal kriging, empirical Bayesian kriging, local polynomial kernel interpolation, inverse distance weighted method, radial basis function, radial basis function interpolation, global polynomial interpolation, carry out interpolation operations, and cross-validate the interpolation results, and then sort the various interpolation effects based on the "highest prediction accuracy" as a condition, and select the optimal interpolation method corresponding to the current data, which significantly improves the accuracy of three-dimensional modeling.
[0018] By using various automation technologies of the ArcGIS platform, the three-dimensional stratigraphic model can be automatically constructed using this method, which greatly improves the efficiency of model tuning. This advantage comes from the fact that the entire technical method is built on the ArcGIS platform. The tools, methods and process control used can all use the "ModelBuilder", "ArcPy" site package or other secondary development methods supported by other platforms to achieve "scripting" of the technical process and improve the efficiency of three-dimensional modeling.
[0019] The three-dimensional stratigraphic model constructed by the present invention adopts a universal data format, namely, a multipatch data format. This advantage comes from step 7, in which the polyhedron data of each stratigraphic layer is generated based on the TIN data set. Multipatch is a data format for storing three-dimensional geometric bodies, mainly used for building modeling. It can support rendering material and texture information, and also supports attribute data, such as the volume attributes used in the present invention. It is a data format that is convenient for spatial analysis and can also achieve complex visualization effects, which can greatly improve the functional extensibility of three-dimensional stratigraphic model construction. The present invention can significantly improve the efficiency and accuracy of three-dimensional stratigraphic modeling, reduce modeling costs, and has good functional extensibility. BRIEF DESCRIPTION OF THE DRAWINGS
[0020] Figure 1 This is a schematic diagram of the implementation of step 1 in the implementation process of the present invention;
[0021] Figure 2 This is a schematic diagram of the implementation of step 2 in the implementation process of the present invention;
[0022] Figure 3 This is a schematic diagram of the implementation of step 4 in the implementation process of the present invention;
[0023] Figure 4 This is a schematic diagram of the implementation of step 8 in the implementation process of the present invention. DETAILED DESCRIPTION
[0024] The present invention will be further described below in conjunction with the accompanying drawings and embodiments.
[0025] like Figures 1 to 4 As shown, a method for constructing and calculating a three-dimensional stratigraphic model based on ArcGIS includes the following steps:
[0026] Step 1: Figure 1 As shown, the stratigraphic stratification information reflected in the drilling data of the study area for constructing the three-dimensional stratigraphic model is collected and sorted, and the bottom elevation data information is recorded layer by layer in a tabular form from top to bottom in the vertical space.
[0027] Step 2: The data table obtained in step 1 is converted into vector point feature class data with spatial location attributes through the ArcGIS software's "MakeXYEventLayer" event layer creation tool, and the layered information in the data table and the Z coordinate data of the bottom elevation of the stratum in the borehole are synchronously transmitted; Figure 2 The schematic diagram of the vector point feature class and drilling line feature class data is shown. Figure 2 The vertical lines in the figure are the projections of the borehole in the vertical direction, and the point symbols of different styles represent the bottom positions of different strata in the borehole.
[0028] Step 3: Based on the vector point feature class data obtained in step 2, use the ArcGIS software exploratory interpolation tool layer by layer to obtain the interpolation results of each layer using multiple interpolation methods and the cross-validation results corresponding to each interpolation result. Use "prediction accuracy" as the evaluation indicator and select the interpolation method with the highest "prediction accuracy" value in the cross-validation result as the interpolation method used in this layer.
[0029] Step 4: For each layer, select the interpolation tool corresponding to the ArcGIS software layer by layer according to the interpolation method selected in step 3, and use the study area as the control range of the output raster data to obtain the elevation raster data of the bottom of each stratum through interpolation operation; Figure 3 The elevation grid diagram of the bottom of the stratum is shown. Figure 3 There are four study areas: A, B, C, and D.
[0030] Step 5: According to the spatial distribution order of the geological survey data of the strata from top to bottom in the vertical direction, starting from the bottom elevation grid data of the first layer, the "conditional function" tool in the platform map algebra function of ArcGIS software is used to process the "abnormal pixel value" layer by layer; the specific steps are: take the "bottom elevation grid of the low-level stratum" as the data to be modified, set the judgment condition as "the bottom elevation value of the low-level stratum is greater than the bottom elevation value of the high-level stratum", and modify the pixel value that meets the condition to the bottom elevation value of the high-level stratum at the same position.
[0031] Step 6: Convert the stratum bottom elevation raster data corrected in step 5 into a TIN dataset, i.e., triangulated irregular surface data, using the “RasterTin” tool in ArcGIS software.
[0032] Step 7: According to the spatial distribution order of the stratigraphic survey data from top to bottom in the vertical direction, select the top and bottom TIN datasets layer by layer, and use the "Extrude Between Two TINs" tool in ArcGIS software to convert them into polyhedral three-dimensional vector data (MultiPatch), that is, a three-dimensional stratigraphic model.
[0033] Step 8: Figure 4 As shown in FIG. 1 , the “Surface Difference” tool of ArcGIS software is used to calculate the volume layer by layer using the top and bottom TIN data sets corresponding to each layer; the volume value of each layer is added to the attributes of the corresponding layer polyhedron data in the three-dimensional stratigraphic model generated in step 7 to obtain a three-dimensional stratigraphic model containing volume attribute information, that is, Figure 4 The three-dimensional stratigraphic model and its stratigraphic volume annotation data are shown.
[0034] Wherein, in step 2, the vector point feature class data is a data type in ArcGIS software that independently records the location and attribute information of spatial points in two-dimensional or three-dimensional coordinate information.
[0035] In step 3, multiple interpolation methods are used layer by layer, including: simple kriging, ordinary kriging, universal kriging, empirical Bayesian kriging, local polynomial kernel interpolation, inverse distance weighted method, radial basis function method, radial basis function interpolation, and global polynomial interpolation. Each layer uses the cross-validation results obtained by the above-mentioned different interpolation methods, takes "prediction accuracy" as the evaluation index, and selects the interpolation method with the highest "prediction accuracy" value as the interpolation method used in this layer.
[0036] In step 8, the ArcGIS software "Extrude Between Two TINs" tool can be used to fill the polyhedron data between the surfaces represented by the two TINs, that is, the conversion from two-dimensional to three-dimensional is realized. The ArcGIS software "Surface Difference" ” The tool can calculate the displacement between two surfaces to determine the upper and lower positions of the surfaces or the upper and lower positions of the two surfaces, and can also obtain the volume of the formation contained between the two surfaces.
Claims
1. A method for constructing and calculating a three-dimensional stratigraphic model based on ArcGIS, characterized in that: The following steps are involved: Step 1: Collect and organize the stratigraphic layer information reflected in the drilling data of the study area for constructing a three-dimensional stratigraphic model, and record the bottom elevation data information layer by layer in a table form from top to bottom in the vertical space; Step 2: The data table obtained in step 1 is converted into vector point feature class data with spatial location attributes through the MakeXYEventLayer tool of ArcGIS software, and the layering information in the data table and the Z coordinate data of the bottom elevation of the stratum in the borehole are synchronously transmitted; Step 3: Based on the vector point feature class data obtained in step 2, the ArcGIS software exploratory interpolation tool is used layer by layer to obtain the interpolation results of each layer using multiple interpolation methods and the cross-validation results corresponding to each interpolation result. The prediction accuracy is used as the evaluation index, and the interpolation method with the highest prediction accuracy value in the cross-validation result is selected as the interpolation method used in this layer; Step 4: For each layer, the interpolation method selected in step 3 is used to select the interpolation tool corresponding to the ArcGIS software layer by layer, and the study area is used as the control range of the output raster data to obtain the elevation raster data of the bottom of each stratum through interpolation operation; Step 5: Based on the spatial distribution order of the geological survey data of the strata from top to bottom in the vertical direction, starting from the bottom elevation raster data of the first layer, the conditional function tool in the platform map algebra function of ArcGIS software is used to process the abnormal pixel values layer by layer; Step 6: Convert the stratum bottom elevation raster data corrected in step 5 into a TIN dataset, i.e., triangulated irregular surface data, using the RasterTin tool of ArcGIS software; Step 7: According to the spatial distribution order of the stratigraphic survey data from top to bottom in the vertical direction, select the top and bottom TIN datasets layer by layer, and use the Extrude Between TIN tool in ArcGIS software to convert them into polyhedral three-dimensional vector data (MultiPatch), that is, a three-dimensional stratigraphic model; Step 8, using the ArcGIS software surface difference (SurfaceDifference) tool, using the top and bottom TIN data sets corresponding to each layer to calculate the volume of each layer; the volume value of each layer is added to the attributes of the corresponding layer polyhedron data in the three-dimensional stratigraphic model generated in step 7 to obtain a three-dimensional stratigraphic model containing volume attribute information; In step 2, the vector point feature class data is a data type in ArcGIS software that independently records the location and attribute information of spatial points in two-dimensional or three-dimensional coordinate information; In step 3, multiple interpolation methods are used layer by layer, including simple kriging, ordinary kriging, universal kriging, empirical Bayesian kriging, local polynomial kernel interpolation, inverse distance weighted method, radial basis function method, radial basis function interpolation, and global polynomial interpolation; each layer uses the cross-validation results obtained by the above different interpolation methods, takes prediction accuracy as the evaluation index, and selects the interpolation method with the highest prediction accuracy value as the interpolation method used in this layer; The abnormal pixel value is processed in step 5, specifically, the steps are: taking the bottom elevation grid of the low-level stratum as the data to be modified, setting the judgment condition that the bottom elevation value of the low-level stratum is greater than the bottom elevation value of the high-level stratum, and modifying the pixel value that meets the condition to the bottom elevation value of the high-level stratum at the same position; In step 8, the Extrude Between TINs tool in ArcGIS software is used to fill the polyhedron data between the surfaces represented by the two TINs, thereby realizing the conversion from two-dimensional to three-dimensional. The Surface Difference tool in ArcGIS software is used to calculate the displacement between the two surfaces to determine the upper and lower positions of the surfaces or whether the upper and lower positions of the two surfaces are the same, and the stratigraphic volume contained between the two surfaces is obtained.
Citation Information
Patent Citations
Drilling data-based quick modeling method
CN107944086A
Three-dimensional modeling method of hyperspectral information of deep rock and mineral
CN110702632A
Generation of three dimensional geological model of geographic site
US20230343029A1
