Automatic calculation method for sand-to-ground ratio of drilling sequence

Abstract

The invention relates to the technical field of petroleum and natural gas geophysics, and particularly discloses a drilling sequence sand-to-ground ratio automatic calculation method, which comprises the following steps of: 1, constructing a drilling record data table and a drilling sequence division table according to exploration data; 2, on the basis of the drilling catalog data table and the drilling sequence division table, common fields of drilling names of the two tables are connected and subjected to grouping query, the sequence sand-to-ground ratio of each drilling hole is obtained, and a drilling sequence sand-to-ground ratio total table is formed; 3, in the drilling sequence sand-to-ground ratio general table, displaying each drilling sand-to-ground ratio in the sequence in the geographic space; and 4, drawing a sequence sedimentary microfacies plane graph by referring to the sand-to-ground ratio trend of each drilling well. According to the calculation method, the drilling sequence sand-to-ground ratio can be automatically calculated, the drilling sequence sand-to-ground ratio general table is automatically formed, the production efficiency is greatly improved, and repeated labor is relieved. The problems that an existing method is large in statistical calculation workload and low in working efficiency are solved.

Description

Technical Field

[0001] This invention belongs to the field of petroleum and natural gas geophysics, specifically relating to an automatic calculation method for the sequence sand-soil ratio in drilling. Background Technology

[0002] In coalfield geology and petroleum research, sequence stratigraphy and sedimentary microfacies are important sedimentological research tasks. For many years, quantitative sequence sand-to-soil ratio has been the most direct basis. The traditional statistical method is to use an Excel spreadsheet to calculate the total thickness of sandstone and the total thickness of the formation in each sequence according to the top and bottom depths of the logging data of each well in the sequence stratigraphy division. The sequence sand-to-soil ratio is obtained by dividing the total sandstone thickness of each well by the total formation thickness, and then the sand-to-soil ratios of each well are combined into a single spreadsheet.

[0003] In scientific research, it is often necessary to statistically analyze the sand-soil ratio of hundreds or even thousands of wells in a research area, a massive workload that leaves technical personnel overwhelmed. Therefore, how to utilize information technology to quickly calculate and statistically analyze the sand-soil ratio of a research area is an innovative technological approach that can fundamentally improve work efficiency and liberate geologists from the tedious labor—a problem that has remained unsolved in the industry for many years.

[0004] Based on this, the present invention proposes an automatic calculation method for the sequence sand-to-soil ratio in drilling to solve the above-mentioned problems existing in the existing methods. Summary of the Invention

[0005] To address the aforementioned technical problems, this invention provides an automatic calculation method for the sequence sand-soil ratio in drilling, which solves the problems of large statistical calculation workload and low efficiency in existing methods.

[0006] To achieve the above objectives, the present invention provides the following technical solution:

[0007] An automatic calculation method for the sequence sand-to-soil ratio in drilling includes:

[0008] Step 1: Based on the exploration data, construct a drilling logging data table and a drilling sequence classification table;

[0009] Step 2: Based on the drilling logging data table and the drilling sequence division table, connect the common field "bore name" of the drilling logging data table and the drilling sequence division table and perform group queries to obtain the sequence sand-to-soil ratio value of each borehole, forming a total drilling sequence sand-to-soil ratio table.

[0010] Step 3: In the sequence sand-soil ratio table, use ArcGIS to import the sand-soil ratio values ​​of each well in the sequence according to coordinates and display them in geospatial space.

[0011] Step 4: In the ArcGIS system, refer to the sand-soil ratio trend of each well and draw a sequence sedimentary microfacies planar map.

[0012] In a preferred embodiment of the present invention, the drilling logging data table includes drilling number, top depth, bottom depth, color, lithology, thickness, and lithological description parameters; the drilling sequence division table includes drilling numbers SQ1, ..., SQi, and corresponding drilling top depth parameters SQ1 top depth, ..., SQi top depth and SQ1 top depth, ..., SQi bottom depth.

[0013] In a preferred embodiment of the present invention, before performing the connection and grouping query of the common field "bore name" of the two tables based on the drilling logging data table and the drilling sequence table in step 2, a query program needs to be written in the SQL Server Query Analyzer panel using SQL statements.

[0014] In a preferred embodiment of the present invention, the query procedure is:

[0015] select a.bore name, sum(iif(a.bottom depth>=b.TSQ1 top depth and a.bottom depth<=b.TSQ1 bottom depth,iif(a.lithology='medium sandstone' or a.lithology='gravelly sandstone' or a.lithology='coarse sandstone' or a.lithology='quartz sandstone' or a.lithology='fine conglomerate' or a.lithology='gravelly coarse sandstone' or a.lithology='gravelly medium sandstone' or a.lithology='fine sandstone', layer thickness, 0), 0)) / (sum(b.TSQ1 bottom depth-b.TSQ1 top depth) / count(*)) as SQ1 sand-to-soil ratio, sum(iif(a.bottom depth>=b.TSQ2 top depth and a.bottom depth<=b.TSQ2 bottom depth,iif(a.lithology='medium sandstone' or a.lithology='gravelly sandstone' or a.lithology='coarse sandstone' or a.lithology='quartz sandstone' or a.lithology='fine conglomerate' or a.lithology='gravelly coarse sandstone' or a.lithology='gravelly medium sandstone' or a.lithology='fine sandstone', layer thickness, 0), 0)) / (sum(b.TSQ2 bottom depth - b.TSQ2 top depth) / count(*)) as SQ2 sand-to-soil ratio, sum(iif(a.bottom depth >= b.TSQ3 top depth and a.bottom depth <= b.TSQ3 bottom depth, iif(a.lithology='medium sandstone' or a.lithology='gravelly sandstone' or a.lithology='coarse sandstone' or a.lithology='quartz sandstone' or a.lithology='fine conglomerate' or a.lithology='gravelly coarse sandstone' or a.lithology='gravelly medium sandstone' or a. Lithology = 'Fine Sandstone', Layer Thickness, 0), 0)) / (sum(b.TSQ3 bottom depth - b.TSQ3 top depth) / count(*)) as SQ3 sand-to-soil ratio, sum(layer thickness) as total formation thickness from Maiduoshan Drilling Logging Data Table ainner join Maiduoshan Drilling Sequence Stratigraphy Table b on a. Borehole Name = b. Borehole Name group by a. Borehole Name.

[0016] In a preferred embodiment of the present invention, step 2, which involves concatenating and grouping the common field "bore name" of the two tables to obtain the sequence sand-soil ratio of each borehole and forming a total table of borehole sequence sand-soil ratios, includes the following specific process:

[0017] Step 2.1: Compare the “top depth” and “bottom depth” of each data entry with the same borehole name in the drilling sequence classification table (SQ1, ..., SQi) for each borehole. Iterate through each data entry in each borehole. If the depth matches the sequence SQ1, ..., SQi, group the data for statistical analysis. For example, if the lithology of the data entry in the drilling sequence classification table is medium sandstone, gravelly sandstone, coarse sandstone, quartz sandstone, fine conglomerate, gravelly coarse sandstone, gravelly medium sandstone, or fine sandstone, record its actual thickness and sum it. Otherwise, record it as 0 and sum it. Continue this process until the bottom depth of all data entries for each borehole exceeds the range of the sequence top depth and bottom depth, at which point no further statistics are collected.

[0018] Step 2.2: Divide the sequence thickness after statistical summation by its total thickness to obtain the sand-land ratio.

[0019] In a preferred embodiment of the present invention, in step 2.2, since the sequence depth is summed once for each data in a drilling logging data table that conforms to the depth of the layer, the final sequence depth needs to be uniformly divided by the number of times it is traversed to obtain the drilling sequence sand-soil ratio table.

[0020] Compared with the prior art, the present invention provides an automatic calculation method for the sequence sand-soil ratio in drilling, which has the following beneficial effects:

[0021] This automated method for calculating the sequence sand-soil ratio in drilling can automatically calculate the sequence sand-soil ratio and automatically generate a summary table of borehole sequence sand-soil ratios, greatly improving production efficiency and reducing repetitive labor. It solves the problems of large statistical calculation workload and low efficiency in existing methods. Attached Figure Description

[0022] Figure 1 This is a flowchart of the automatic calculation method for the sequence sand-soil ratio in drilling according to the present invention;

[0023] Figure 2 This is a map showing the distribution of drilling wells at Maiduoshan Coal Mine, Example 1 of the present invention.

[0024] Figure 3 This is a sequence stratigraphic and sedimentary microfacies composite columnar section of the BK1001 well at the Maiduoshan Coal Mine, Embodiment 1 of the present invention.

[0025] Figure 4 This is a spatial diagram illustrating the drilling sand-soil ratio in Embodiment 1 of the present invention;

[0026] Figure 5 This is a planar view of the sequence deposition microfacies of Embodiment 1SQ1 of the present invention. Detailed Implementation

[0027] The present invention will be further described below with reference to the accompanying drawings and specific embodiments.

[0028] Please see Figures 1-5 As shown, this embodiment provides an automatic calculation method for borehole sequence sand-to-soil ratios. This method is used in coalfield and petroleum geological exploration practices to provide a technical means for the automatic calculation of massive borehole sequence sand-to-soil ratios. This method employs relational database technology (such as SQL Server) to structurally store and manage borehole logging geological data and borehole sequence stratigraphic division geological data according to a common field, "borehole number," ensuring data structure standardization and query efficiency. Then, by writing a SQL Server database query program language and running it in the query analyzer, the method completes the calculation of sequence sand-to-soil ratios for all borehole logging geological data in the study area in one go, and automatically generates a structured borehole sequence sand-to-soil ratio table. Finally, the calculated borehole sand-to-soil ratio data is projected onto the ArcGIS geographic information system desktop according to the borehole coordinates, achieving an intuitive spatial display of the results and providing a visual basis for the accurate division of sequence sedimentary microfacies. The specific process includes:

[0029] Step 1: Construct drilling logging data tables and drilling sequence classification tables;

[0030] Based on the exploration data, create well logging data tables to manage geological data in a structured manner, including parameters such as well number, top depth, bottom depth, color, lithology, thickness, and lithology description.

[0031] The sequence division scheme for each well was studied to obtain the top and bottom depths of the sequence. A drilling sequence division table was created, with fields including well number, top depth of SQ1, bottom depth of SQ1, top depth of SQ2, bottom depth of SQ2, top depth of SQ3, bottom depth of SQ3, ... top depth of SQi, bottom depth of SQi, etc. The top and bottom depths of the sequence for each well were recorded.

[0032] Step 2: In the SQL Server Query Analyzer panel, write a query program using SQL statements. Based on the well logging data table and the well sequence division table, join and group the common field "well name" of the two tables to obtain the sequence sand-soil ratio values ​​of each well and form a total well sequence sand-soil ratio table.

[0033] Step 2.1: For each borehole (borehole name), compare the "top depth" and "bottom depth" in the drilling sequence division table (SQ1, SQ2, SQ3..., SQi) with the "bottom depth" of each record with the same borehole name in the drilling logging data table. Iterate through each record in each borehole. If the depth matches the sequence depth (from the beginning to the end of the sequence), group and count the data, such as by iterating through the lithology of the record in the drilling logging data table using an IF statement. For medium sandstone, gravelly sandstone, coarse sandstone, quartz sandstone, fine conglomerate, gravelly coarse sandstone, gravelly medium sandstone, and fine sandstone, record their actual layer thickness (because the top and bottom depths of SQ1 are used to determine the sequence position of each well, each data point must be traversed. When the data range exceeds the top and bottom depth range, the traversal stops. The summation is calculated using the system's summation formula), and used for summation. Otherwise, record it as 0, and sum it as well, until the bottom depth of all recorded data for each well exceeds the sequence top and bottom depth range, at which point it is no longer counted.

[0034] Step 2.2: Divide the statistically summed sequence thickness (layer thickness) by its total thickness (bottom depth - top depth of each sequence) to obtain the sequence sand-soil ratio. Since the sequence depth is statistically summed once for each well logging data table that meets the sequence depth, the final sequence depth needs to be uniformly divided by the number of traversals, i.e., count(*), to obtain the total table of well sequence sand-soil ratios.

[0035] Step 3: In the sequence sand-soil ratio table, use ArcGIS to import the sand-soil ratio values ​​of each well in the sequence according to coordinates and display them in geospatial space.

[0036] Step 4: Refer to the sand-soil ratio trend of each well and draw a sequence sedimentary microfacies planar map.

[0037] Example 1:

[0038] To verify the feasibility of the automatic calculation method for sequence sand-soil ratio in drilling described in this invention, a specific embodiment is used for verification in this example. This embodiment selects the Maiduoshan Coal Mine in the western Ordos Basin of Shenhua Group as an example. A total of 55 wells were drilled in the study area ( Figure 2 A comprehensive study of sequence stratigraphy and sedimentary microfacies division was conducted for each well, and a comprehensive columnar section of each well was generated. Figure 3 ), and statistically analyze the sand-to-soil ratio of each well sequence.

[0039] Step 1: Constructing Structured Geological Data

[0040] Step 1.1: Create the Maiduoshan drilling logging data table to structure and store the formation logging data of 55 wells (Table 1).

[0041] Table 1: Drilling Logging Data for Maiduoshan Well

[0042] Drill hole name Stratigraphic numbering color Bottom depth (m) Layer thickness (m) coal seam Lithology BK1001 1 gray-black 735.4 2.1 siltstone BK1001 2 grayish white 757.76 22.36 coarse sandstone BK1001 3 gray-black 758.16 0.399 Sandy mudstone BK1001 4 black 761.9 3.74 18-2 Coal coal seam BK1001 5 gray-black 763 1.1 siltstone BK1001 6 gray-black 766 3 Sandy mudstone BK1001 7 gray-black 770.2 4.2 siltstone BK1001 8 black 770.75 0.549 coal seam BK1001 9 gray-black 779.3 8.549 Sandy mudstone BK1001 10 black 785.92 6.62 18 Coal Mine coal seam BK1001 11 gray-black 787 1.08 Sandy mudstone BK1001 12 grayish white 790.5 3.5 medium sandstone BK1001 13 gray-black 793.2 2.7 Sandy mudstone BK1001 14 grayish white 802.6 9.399 fine sandstone BK1001 15 grayish white 810.47 7.87 coarse sandstone BK1001 16 grayish white 814.59 4.12 medium sandstone BK1002 1 grayish-yellow 5.00 5.00 sandy soil BK1002 2 grayish white 15.75 10.75 medium sandstone BK1002 3 grayish white 19.35 3.6 fine sandstone BK1002 4 grayish white 62.75 43.4 coarse sandstone BK1002 5 black 63.95 1.2 1 Coal coal BK1002 6 grayish white 74.549 10.599 fine sandstone BK1002 7 Dark gray 77.749 3.2 Sandy mudstone BK1002 8 black 82.249 4.5 2 Coal coal BK1002 9 Dark gray 83.148 0.899 Sandy mudstone BK1002 10 black 84.047 0.899 coal BK1002 11 Dark gray 88.047 4 Sandy mudstone BK1002 12 grey 94.347 6.3 siltstone BK1002 13 black 96.046 1.699 3-1 Coal coal BK1002 14 Dark gray 109.246 13.2 Sandy mudstone BK1002 15 black 112.045 2.799 3-2 Coal coal BK1002 16 Dark gray 116.245 4.2 Sandy mudstone BK1002 17 Light gray 120.945 4.7 fine sandstone BK1002 18 grayish white 123.044 2.099 siltstone BK1002 19 grayish white 125.744 2.7 fine sandstone BK1002 20 Black and gray 127.643 1.899 mudstone BK1002 21 grayish-yellow 129.152 1.509 medium sandstone BK1002 22 Dark gray 133.152 4 Sandy mudstone BK1002 23 grayish white 138.142 4.99 fine sandstone BK1002 24 Dark gray 141.442 3.3 Sandy mudstone BK1002 25 black 142.541 1.099 4-1 Coal coal

[0043] Step 1.2: Through sequence stratigraphy, three sequences (SQ1, SQ2, SQ3) are identified in each well. The top, bottom and depth of each sequence are identified. A sequence division table for the Maiduoshan well is created. A structured depth table of 55 sequence divisions is stored, and the top and bottom depths of each sequence are recorded (Table 2).

[0044] Table 2: Sequence Drilling Layer Classification Table for Maiduoshan

[0045] Drill hole name TSQ1 bottom depth TSQ1 top depth TSQ2 bottom depth TSQ2 top depth TSQ3 bottom depth TSQ3 top depth BK1001 814.59 658.16 658.16 546.48 546.48 355.5 BK1002 1294.14 1139.40 1139.40 1032.60 1032.60 879.25 BK1003 1172.59 948.50 948.50 835.80 835.80 577.5 BK1102 1145.56 983.30 983.30 855.40 855.40 581.5 BK1103 1256.80 1094.00 1094.00 990.60 990.60 818.8 BK1202 1196.88 1062.00 1062.00 964.50 964.50 813.4 BK1301 694.20 548.40 548.40 440.95 440.95 247.2 BK1302 988.80 853.50 853.50 743.60 743.60 532.02 BK1303 1177.97 1056.45 945.05 945.05 945.05 712.5 BK1304 863.85 703.59 703.59 528.12 528.12 315.95 BK1401 686.19 570.50 570.50 431.22 431.22 213.4 BK1402 1164.55 1037.50 1037.50 935.55 935.55 732.2 BK1501 680.18 559.55 559.55 416.25 416.25 152.4 BK1502 999.21 859.00 859.00 745.50 745.50 539.5 BK1503 1139.83 1002.70 1002.70 901.60 901.60 709.5 BK1504 1208.10 1082.04 1082.04 966.26 966.26 737.52 BK1505 737.15 598.25 598.25 474.20 474.20 190 BK1601 820.13 619.36 619.36 453.00 453.00 222.35 BK1602 1088.57 961.70 961.70 860.85 860.85 674.46 BK1603 1170.13 1046.10 1046.10 951.15 951.15 724.8 BK1701 911.30 715.25 715.25 495.57 495.57 284 BK1702 991.21 842.00 842.00 716.50 716.50 378.91 BK1703 1057.08 928.10 928.10 824.50 824.50 622.5 BK1704 1151.76 1013.25 1013.25 894.70 894.70 700.05 BK1801 892.00 652.05 652.05 494.40 494.40 208 BK1802 1025.10 929.14 929.14 797.00 797.00 604.28 BK1901 897.51 567.55 567.55 383.90 383.90 133 BK1902 906.05 766.71 766.71 642.18 642.18 340.2 BK1903 1020.36 887.50 887.50 786.60 786.60 565.76 BK2001 1038.68 894.70 894.70 789.40 789.40 600 BK2101 637.33 450.20 450.20 263.75 263.75 57.25 BK2102 906.59 749.56 749.56 640.20 640.20 436.48 BK2103 1055.67 891.75 891.75 788.85 788.85 585.25 BK2201 616.66 455.50 455.50 251.45 251.45 30 BK2202 1045.80 902.70 902.70 793.50 793.50 594.5

[0046] Step 2: Automatic formation of sequence sand-land ratio

[0047] A program was written using SQL Server and run in Query Analyzer to generate a drilling sequence sand-soil ratio table (Table 3).

[0048] Table 3: Sequence Sandstone Ratio Table for Drilling Stratification

[0049] Drill hole name SQ1 sandstone ratio SQ2 sandstone ratio SQ3 sandstone ratio BK1001 0.41 0.20 0.68 BK1002 0.24 0.54 0.60 BK1003 0.42 0.42 0.68 BK1103 0.49 0.20 0.58 BK1202 0.59 0.43 0.41 BK1301 0.31 0.25 0.59 BK1303 0.45 0.35 0.73 BK1401 0.33 0.37 0.64 BK1402 0.27 0.30 0.56 BK1903 0.46 0.39 0.54 BK2201 0.47 0.44 0.59 BK2202 0.31 0.47 0.71 BK1703 0.30 0.45 0.74 BK1304 0.25 0.30 0.49 BK1501 0.37 0.48 0.61 BK1504 0.68 0.83 0.91 BK1505 0.37 0.49 0.69

[0050] Objective: To obtain the sequence sand-to-soil ratio of each borehole by connecting and grouping the common field "Borehole Name" of two tables (Maiduoshan Drilling Logging Data Table and Maiduoshan Drilling Sequence Sequence Classification Table).

[0051] The specific programming language implementation is as follows: For each borehole (borehole name), compare the "top depth" and "bottom depth" in the SQ1, SQ2, and SQ3 sequences of the Maiduoshan drilling sequence table with the "bottom depth" of each record for the same borehole name in the Maiduoshan drilling logging data table. Iterate through each logging record in each borehole; if the depth matches the SQ1, SQ2, or SQ3 sequence (from the beginning to the end of the sequence), group them for statistical analysis. For example, the Maiduoshan drilling logging data... If the lithology of a data entry in the data table is medium sandstone, gravelly sandstone, coarse sandstone, quartz sandstone, fine conglomerate, gravelly coarse sandstone, gravelly medium sandstone, or fine sandstone, then its actual layer thickness is recorded and used for summation. Otherwise, it is recorded as 0, and summation is also performed, until the bottom depth of all logged data for each well exceeds the range of the sequence top and bottom depths, at which point it is no longer counted. The sequence thickness (layer thickness) after statistical summation is divided by its total thickness (bottom depth of each sequence - top depth) to obtain the sequence sand-to-soil ratio. Since the sequence depth is statistically summed once for each data entry in the Maiduoshan well logging data table that meets the sequence depth requirement, the final sequence depth needs to be uniformly divided by the number of traversals, i.e., count(*).

[0052] The programming language is as follows:

[0053] select a.bore name, sum(iif(a.bottom depth>=b.TSQ1 top depth and a.bottom depth<=b.TSQ1 bottom depth,iif(a.lithology='medium sandstone' or a.lithology='gravelly sandstone' or a.lithology='coarse sandstone' or a.lithology='quartz sandstone' or a.lithology='fine conglomerate' or a.lithology='gravelly coarse sandstone' or a.lithology='gravelly medium sandstone' or a.lithology='fine sandstone', layer thickness, 0), 0)) / (sum(b.TSQ1 bottom depth-b.TSQ1 top depth) / count(*)) as SQ1 sand-to-soil ratio, sum(iif(a.bottom depth>=b.TSQ2 top depth and a.bottom depth<=b.TSQ2 bottom depth,iif(a.lithology='medium sandstone' or a.lithology='gravelly sandstone' or a.lithology='coarse sandstone' or a.lithology='quartz sandstone' or a.lithology='fine conglomerate' or a.lithology='gravelly coarse sandstone' or a.lithology='gravelly medium sandstone' or a.lithology='fine sandstone', layer thickness, 0), 0)) / (sum(b.TSQ2 bottom depth - b.TSQ2 top depth) / count(*)) as SQ2 sand-to-soil ratio, sum(iif(a.bottom depth >= b.TSQ3 top depth and a.bottom depth <= b.TSQ3 bottom depth, iif(a.lithology='medium sandstone' or a.lithology='gravelly sandstone' or a.lithology='coarse sandstone' or a.lithology='quartz sandstone' or a.lithology='fine conglomerate' or a.lithology='gravelly coarse sandstone' or a.lithology='gravelly medium sandstone' or a. Lithology = 'Fine Sandstone', Layer Thickness, 0), 0)) / (sum(b.TSQ3 bottom depth - b.TSQ3 top depth) / count(*)) as SQ3 sand-to-soil ratio, sum(layer thickness) as total formation thickness from Maiduoshan Drilling Logging Data Table ainner join Maiduoshan Drilling Sequence Stratigraphy Table b on a. Borehole Name = b. Borehole Name group by a. Borehole Name.

[0054] Step 3: Spatial display of sequence sand-land ratio;

[0055] The sequence sand-soil ratio of the drilling strata is visually displayed on the ArcGIS platform to showcase its spatial characteristics for spatial analysis. Figure 4 ).

[0056] Step 4: Draw a planar diagram of the sedimentary microfacies;

[0057] Based on the spatial distribution characteristics of the sand-soil ratio in the drilling sequence and referring to the core description, a sequence sedimentary microfacies diagram was drawn. Figure 5 ).

[0058] Although embodiments of the invention have been shown and described, it will be understood by those skilled in the art that various changes, modifications, substitutions and alterations can be made to these embodiments without departing from the principles and spirit of the invention, the scope of which is defined by the appended claims and their equivalents.

Claims

1. An automatic calculation method for the sequence sand-to-soil ratio in drilling, characterized in that, include: Step 1: Based on the exploration data, construct a drilling logging data table and a drilling sequence classification table; Step 2: Based on the drilling logging data table and the drilling sequence division table, connect the common field "bore name" of the drilling logging data table and the drilling sequence division table and perform grouped queries to obtain the sequence sand-to-soil ratio value of each borehole, forming a total drilling sequence sand-to-soil ratio table. Step 3: In the sequence sand-soil ratio table, use ArcGIS to import the sand-soil ratio values ​​of each well in the sequence according to coordinates and display them in geospatial space. Step 4: In the ArcGIS system, refer to the sand-soil ratio trend of each well and draw a sequence sedimentary microfacies planar map.

2. The automatic calculation method for drilling sequence sand-to-soil ratio as described in claim 1, characterized in that, The well logging data table includes well number, top depth, bottom depth, color, lithology, thickness, and lithological description parameters; the well sequence division table includes well numbers SQ1, ..., SQi, and the corresponding top depth parameters SQ1 top depth, ..., SQi top depth and bottom depth parameters SQ1 top depth, ..., SQi bottom depth for each well number SQ1, ..., SQi.

3. The automatic calculation method for drilling sequence sand-to-soil ratio as described in claim 1, characterized in that, Before performing the query in step 2, which involves connecting and grouping the common field "bore name" of the two tables based on the well logging data table and the well sequence table, a query program needs to be written using SQL statements in the SQL Server Query Analyzer panel.

4. The automatic calculation method for drilling sequence sand-soil ratio as described in claim 3, characterized in that, The query procedure is as follows: select a. borehole name, sum(iif(a.bottom depth>=b.TSQ1 top depth and a.bottom depth<=b.TSQ1 bottom depth, iif(a.lithology='medium sandstone' or a.lithology='gravelly sandstone' or a.lithology='coarse sandstone' or a.lithology='quartz sandstone' or a.lithology='fine conglomerate' or a.lithology='gravelly coarse sandstone' or a.lithology='gravelly medium sandstone' ora.lithology='fine sandstone', layer thickness, 0), 0)) / (sum(b.TSQ1 bottom depth-b.TSQ1 top depth) / count(*)) as SQ1 sand-to-soil ratio, sum(iif(a.bottom depth>=b.TSQ2 top depth and a.bottom depth<=b.TSQ2 bottom depth, iif(a.lithology='medium sandstone' ora.lithology='gravelly sandstone' or a.lithology='coarse sandstone' or a.lithology='quartz sandstone' or a.lithology='fine conglomerate' or a.lithology='gravelly coarse sandstone' or a.lithology='gravelly medium sandstone' or a.lithology='fine sandstone', layer thickness, 0), 0)) / (sum(b.TSQ2 bottom depth - b.TSQ2 top depth) / count(*)) as SQ2 sand-to-soil ratio, sum(iif(a.bottom depth >= b.TSQ3 top depth and a.bottom depth <= b.TSQ3 bottom depth, iif(a.lithology='medium sandstone' or a.lithology='gravelly sandstone' or a.lithology='coarse sandstone' or a.lithology='quartz sandstone' or a.lithology='fine conglomerate' or a.lithology='gravelly coarse sandstone' or a.lithology='gravelly medium sandstone' or a. Lithology='Fine Sandstone', Layer Thickness,0),0)) / (sum(b.TSQ3 Bottom Depth-b.TSQ3 Top Depth) / count(*)) as SQ3 Sand-to-Soil Ratio,sum(Layer Thickness) as Total Formation Thickness from Maiduoshan Drilling Logging Data Table a inner join Maiduoshan Drilling Sequence Stratigraphy Table b on a.Break Name=b.Break Name groupby a.Break Name.

5. The automatic calculation method for drilling sequence sand-to-soil ratio as described in claim 1, characterized in that, Step 2, which involves concatenating and grouping the common field "bore name" of the two tables to obtain the sequence sand-soil ratio for each borehole and forming a total table of borehole sequence sand-soil ratios, includes the following specific steps: Step 2.1: Compare the "top depth" and "bottom depth" of each data entry with the same borehole name in the drilling sequence classification table (SQ1, ..., SQi) for each borehole. Iterate through each data entry in each borehole. If the depth matches the sequence (SQ1, ..., SQi), group the data for statistical analysis. For example, if the lithology of the data entry in the drilling sequence classification table is medium sandstone, gravelly sandstone, coarse sandstone, quartz sandstone, fine conglomerate, gravelly coarse sandstone, gravelly medium sandstone, or fine sandstone, record its actual thickness and sum it. Otherwise, record it as 0 and sum it. Continue this process until the bottom depth of all data entries for each borehole exceeds the range of the sequence top and bottom depths, at which point no further statistical analysis is performed. Step 2.2: Divide the sequence thickness after statistical summation by its total thickness to obtain the sand-land ratio.

6. The automatic calculation method for the sequence sand-to-soil ratio in drilling as described in claim 5, characterized in that, In step 2.2, since the sequence depth is summed once for each data in the drilling logging data table that meets the depth requirement, the final sequence depth needs to be divided by the number of times it is traversed to obtain the drilling sequence sand-soil ratio table.

Images