Physical exploration workload statistical method and system

By dividing depth intervals and automated data traversal in the exploration physical workload statistics, the problems of cumbersome and error-prone artificial statistics in the existing technology are solved, and efficient and accurate exploration physical workload statistics are achieved.

CN119886899AActive Publication Date: 2025-04-25CHANGJIANG SURVEY PLANNING DESIGN & RES CO LTD
View PDF 8 Cites 0 Cited by

Patent Information

Application Number
CN202411649128.0
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-11-19
Publication Date
2025-04-25
Estimated Expiration
2044-11-19

AI Technical Summary

Technical Problem

In the prior art, the statistics of physical exploration workloads rely on manual judgment and manual calculations, resulting in a lot of data processing, large repetitive workload, error-prone, time-consuming and labor-intensive, and low work efficiency.

Method used

By dividing the depth intervals of each type of total exploration project, data are extracted from the exploration chart, and circulating traversal is performed using project numbers and depth intervals to automatically count the physical exploration workload, reduce duplicate work and improve efficiency.

Benefits of technology

Automatic exploration physical workload statistics are realized, reducing manual errors and repeated work, and significantly improving work efficiency.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119886899A_ABST
    Figure CN119886899A_ABST
Patent Text Reader

Abstract

The invention discloses an exploration real object workload statistical method and system, and the method comprises the steps: dividing a depth interval of each type of total exploration project, extracting exploration data from an exploration chart, the exploration data comprising a plurality of sub-exploration projects, and each sub-exploration project comprising a project number, a stratum code, a stratum depth, and a rock-soil type to which a stratum belongs; traversing each sub-exploration project according to the project numbers from small to large; for each sub-exploration item, traversing each depth interval from shallow to deep; for each depth interval, finding a stratum code falling in the corresponding depth interval, and determining a rock-soil category and a stratum depth corresponding to the stratum code; and accumulating the stratum depths of the stratum codes of the same rock and soil category to obtain the total accumulated depth corresponding to each rock and soil category of the corresponding depth interval. According to the method, mistakes and omissions during manual calculation can be avoided, repeated work can be greatly reduced, and the working efficiency is greatly improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The invention belongs to the technical field of engineering exploration data processing, and in particular relates to a method and system for statistically analyzing the physical exploration workload. Background Art

[0002] In the process of calculating the engineering survey fee, it is necessary to complete the statistics of the physical exploration workload according to relevant regulations. The statistics of the physical exploration workload is a statistical work based on the classification of rock and soil categories and the different exploration depths of the strata according to the exploration results data. At present, it is basically completed through manual judgment and manual calculation. The main difficulties in manually handling this work are numerous data processing, large repetitive workload, easy to make mistakes and difficult to find, time-consuming and labor-intensive, and low work efficiency. Summary of the invention

[0003] The purpose of the present invention is to solve the shortcomings of the above-mentioned background technology and provide a method and system for statistically analyzing the physical exploration workload, which can greatly reduce duplication of work, avoid errors, and greatly improve work efficiency.

[0004] The technical solution adopted by the present invention is: a method for statistically analyzing the physical exploration workload, dividing the depth interval of each type of total exploration project, extracting exploration data from the exploration chart, wherein the exploration data includes a plurality of sub-exploration projects, and each sub-exploration project includes a project number, a formation code, a formation depth, and a rock and soil category to which the formation belongs;

[0005] Traverse each sub-exploration project in ascending order of project number;

[0006] For each sub-exploration project, each depth interval is traversed from shallow to deep;

[0007] For each depth interval, search for the formation code that falls within the corresponding depth interval, and determine the rock and soil type and formation depth corresponding to the formation code;

[0008] The stratigraphic depths of the stratigraphic codes of the same rock and soil category are accumulated to obtain the total cumulative depth corresponding to each rock and soil category in the corresponding depth interval.

[0009] Furthermore, the general exploration project is divided into four categories: drilling, exploration wells, exploration trenches, and adit.

[0010] Furthermore, after obtaining the total cumulative depth of each rock and soil category in the corresponding depth interval, it is determined whether the exploration data is accurate based on the total cumulative depth.

[0011] Furthermore, the process of judging whether the exploration data is correct according to the total cumulative depth is as follows:

[0012] The total accumulated depth is compared with the difference between the upper and lower limits of the corresponding depth interval. If the total accumulated depth is equal to the difference between the upper and lower limits, the exploration data is judged to be accurate; otherwise, the exploration physical workload statistics are exited.

[0013] Furthermore, the steps of traversing each sub-exploration project are:

[0014] Step 1, set the initial cumulative depth corresponding to each geotechnical category of the i-th sub-exploration project, and proceed to step 2;

[0015] Step 2, determine the jth depth interval and proceed to step 3;

[0016] Step 3, determine the mth formation code, determine whether the formation depth H corresponding to the mth formation code is within the jth depth interval, and proceed to step 4;

[0017] Step 4, if yes, determine the geotechnical category Km of the mth stratigraphic code, add the stratigraphic depth H of the mth stratigraphic code to the cumulative depth corresponding to the geotechnical category Km, and proceed to step 5; if no, proceed to step 5;

[0018] Step 5, determine whether the traversal of the formation code is completed. If completed, calculate the total cumulative depth of each rock and soil category in the jth depth interval and proceed to step 6; if not completed, determine m=m+1 and return to step 3;

[0019] Step 6, determine whether the total cumulative depth is equal to the difference between the upper and lower limits of the j-th depth interval. If so, obtain the total cumulative depth of each rock and soil category in the j-th depth interval and proceed to step 7; if not, proceed to step 9;

[0020] Step 7, determine whether the depth interval traversal is completed, if completed, proceed to step 8; if not completed, determine j=j+1, and return to step 2;

[0021] Step 8, determine whether the traversal of the sub-exploration items is completed, if completed, proceed to step 9; if not completed, determine i=i+1, and return to step 1;

[0022] Step 9, end the statistical work.

[0023] A system for statistically analyzing physical exploration workload, comprising:

[0024] The depth interval division module is used to divide the depth interval of each type of general exploration project;

[0025] A data extraction module is used to extract exploration data from the exploration chart, wherein the exploration data includes a plurality of sub-exploration projects, each of which includes a project number, a formation code, a formation depth, and a rock and soil category to which the formation belongs;

[0026] The data traversal module is used to traverse each sub-exploration project in the order of project number from small to large; for each sub-exploration project, traverse each depth interval in the order from shallow to deep; for each depth interval, find the formation code falling in the corresponding depth interval, determine the rock and soil category and formation depth corresponding to the formation code; accumulate the formation depths of the formation codes of the same rock and soil category to obtain the total cumulative depth corresponding to each rock and soil category in the corresponding depth interval.

[0027] Furthermore, the general exploration projects are divided into four categories: drilling holes, exploration wells, exploration trenches, and adit tunnels. The division ranges, i.e. the number of depth intervals of different general exploration projects are different.

[0028] Furthermore, the depth interval of the borehole is [0, 10, 20, 30, 40, 50, 60, 80, 100], the depth interval of the exploration well is [0, 2, 5, 10, 20], the depth interval of the exploration trench is [0, 2], and the depth interval of the adit is [0, 50, 100, 150, 200, 250, 300].

[0029] Furthermore, after obtaining the total cumulative depth of each rock and soil category in the corresponding depth interval, it is determined whether the exploration data is accurate based on the total cumulative depth.

[0030] Furthermore, the process of judging whether the exploration data is correct based on the total cumulative depth is as follows:

[0031] The total accumulated depth is compared with the difference between the upper and lower limits of the corresponding depth interval. If the total accumulated depth is equal to the difference between the upper and lower limits, the exploration data is judged to be accurate; otherwise, the exploration physical workload statistics are exited.

[0032] The beneficial effects of the present invention are:

[0033] The present invention extracts exploration chart data and stores it in a set format, and then performs a loop traversal based on the stored project number, formation code, and divided depth interval, so as to automatically realize the statistics of the physical exploration workload. This method can not only avoid errors and omissions in manual calculations, but also greatly reduce duplication of work and greatly improve work efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0034] Figure 1 It is a flow chart of the present invention.

[0035] Figure 2 A flow chart of traversing sub-exploration data according to the present invention.

[0036] Figure 3 This is a schematic diagram of the file format of part of the exploration data of the present invention.

[0037] Figure 4This is a schematic diagram of the file format of the geotechnical category of the present invention.

[0038] Figure 5 This is a schematic diagram of the statistical result file format of the present invention. DETAILED DESCRIPTION

[0039] The specific embodiments of the present invention are further described below in conjunction with the accompanying drawings. It should be noted that the description of these embodiments is used to help understand the present invention, but does not constitute a limitation of the present invention. In addition, the technical features involved in the various embodiments of the present invention described below can be combined with each other as long as they do not conflict with each other.

[0040] like Figure 1 As shown, the present invention provides a method for statistically analyzing physical exploration workload, comprising the following steps:

[0041] Step 1: Depth interval division: Divide the depth intervals for each type of total exploration project.

[0042] Step 2, data extraction: extract exploration data from the exploration chart, the exploration data includes several sub-exploration projects, each sub-exploration project includes a project number, a formation code, a formation depth, and the rock and soil category to which the formation belongs.

[0043] Step 3, data traversal: traverse each sub-exploration project in order from small to large project numbers; for each sub-exploration project, traverse each depth interval in order from shallow to deep;

[0044] For each depth interval, search for the formation code that falls within the corresponding depth interval, and determine the rock and soil type and formation depth corresponding to the formation code;

[0045] The stratigraphic depths of the stratigraphic codes of the same rock and soil category are accumulated to obtain the total cumulative depth corresponding to each rock and soil category in the corresponding depth interval.

[0046] The present invention extracts exploration chart data and stores it in a set format, and then performs a loop traversal based on the stored project number, formation code, and divided depth interval, so as to automatically realize the statistics of the physical exploration workload. This method can not only avoid errors and omissions in manual calculations, but also greatly reduce duplication of work and greatly improve work efficiency.

[0047] Taking the statistics of the actual workload of drilling as an example, it takes about 3 to 5 minutes per person to count a borehole with a length of about 50 meters and a depth. If the geological conditions are complex and the strata are undulating and changeable, it will take more time, and it is easy to make mistakes and difficult to check. The number of holes drilled in small and medium-sized water conservancy projects is often more than 100, and the staff needs to devote themselves to one working day or more. With the method of the present invention, it can basically be completed in 2 to 3 minutes.

[0048] It is understandable that according to the prescribed engineering survey standards, the general exploration projects are divided into four categories: drilling, exploration wells, exploration trenches, and adit. Each general project may contain several sub-projects. For example, if a certain exploration is mainly drilling, there are several completed drillings, and each drilling is a sub-exploration project. The depth intervals of each general exploration project are divided separately. The depth intervals divided for different general exploration projects can be the same or different. According to the engineering survey standards, each general exploration project can be divided into one or more depth intervals. For example, the depth interval of the drilling project is [0,10,20,30,40,50,60,80,100], which means that the drilling project is divided into 8 depth intervals; the depth interval of the exploration well project is [0,2,5,10,20], which means that the exploration well project is divided into 4 depth intervals; the depth interval of the trench project is [0,2], which means that the trench project is divided into 1 depth interval; the depth interval of the adit project is [0,50,100,150,200,250,300], which means that the adit project is divided into 6 depth intervals.

[0049] It should be noted that the above-mentioned depth interval division is not fixed and can be changed arbitrarily according to different regions, different strata and exploration conditions.

[0050] It can be understood that according to the prescribed engineering investigation standards, the geotechnical categories are divided into 6 categories, namely Ⅰ, Ⅱ, Ⅲ, Ⅳ, Ⅴ, and Ⅵ. When extracting exploration data, the stratigraphic data in the site is included, including the stratigraphic code and the geotechnical category Km (Km=1, 2, 3, 4, 5, 6), where m is the stratigraphic code.

[0051] It is understandable that when the exploration data is extracted, the data is stored according to the set format. The set format is generally: the extracted data is classified according to the general exploration project type, and all sub-exploration projects of the same type are stored in one or more tables or files. The tables or files contain all data of several sub-exploration projects corresponding to the general exploration project, including project number, formation code, formation depth, and geotechnical category to which the formation belongs. For example, all drilling data are saved in an Excel file, which contains the number of each borehole, the formation code of the corresponding borehole, the bottom layer depth and the geotechnical category to which the formation belongs. The borehole numbers are arranged in order, and each borehole may contain one or more formation codes (i.e., different depths). The formation depths of the same drilling data are arranged in order from shallow to deep. If the same type of sub-exploration projects are stored in multiple tables or files, the corresponding data in the multiple tables or files are represented in the same way, such as the formation code.

[0052] It is understandable that if Figure 2 As shown, the steps of traversing each sub-exploration project are as follows:

[0053] Step 1, set the initial cumulative depth corresponding to each geotechnical category of the i-th sub-exploration project, and proceed to step 2; the initial cumulative depth of each geotechnical category before the traversal of each sub-exploration project is 0, that is, each time a sub-exploration project is traversed, the initial cumulative depth of its soil category must be reset to zero, so as to facilitate the statistics of the geotechnical category and different exploration depths of the strata of each sub-exploration project.

[0054] Step 2: determine the jth depth interval and proceed to step 3.

[0055] Step 3, determine the mth formation code, judge whether the formation depth H corresponding to the mth formation code is within the jth depth interval, and proceed to step 4.

[0056] Step 4, if yes, determine the geotechnical category Km of the mth stratigraphic code, add the stratigraphic depth H of the mth stratigraphic code to the cumulative depth corresponding to the geotechnical category Km, and proceed to step 5; if not, proceed to step 5; if the geotechnical category Km of the mth stratigraphic code = 4, that is, the geotechnical category of the stratigraphic code is Class IV, then the stratigraphic depth H of the stratigraphic code is added to the cumulative depth of the Class IV rock and soil category.

[0057] Step 5, determine whether the traversal of the formation code is completed. If completed, calculate the total cumulative depth of each rock and soil category in the jth depth interval and proceed to step 6; if not completed, determine m=m+1 and return to step 3.

[0058] Step 6, determine whether the total cumulative depth is equal to the difference between the upper and lower limits of the jth depth interval. If equal, obtain the total cumulative depth of each rock and soil category in the jth depth interval and proceed to step 7; if not equal, proceed to step 9.

[0059] Step 7, determine whether the depth interval traversal is completed. If completed, proceed to step 8; if not completed, determine j=j+1 and return to step 2.

[0060] Step 8, determine whether the traversal of the sub-exploration items is completed. If completed, proceed to step 9; if not completed, determine i=i+1 and return to step 1.

[0061] Step 9, end the statistical work.

[0062] It should be noted that the values ​​of the above sub-exploration project i start from the smallest number in the same category, and then traverse in ascending order; the depth interval j starts from the shallowest interval, and the formation code m starts from the smallest value. When traversing, follow the order from inside to outside. After traversing a total exploration project, continue traversing the next total exploration project until all exploration data are counted.

[0063] It can be understood that when judging the total cumulative depth, if the total cumulative depth is not equal to the difference between the upper and lower limits of the jth depth interval, it means that there is a problem with the exploration data. According to the above steps, the statistical work can be terminated directly, and the initial exploration icon data can be manually calibrated to see if there is a problem.

[0064] In the actual process, there may be only a few original data problems. Therefore, in order to reduce the difficulty of subsequent calibration, during the statistical process, when it is determined that the total cumulative depth has a problem, the traversal of the current sub-exploration project can be directly skipped and the traversal of the next sub-exploration project can be performed. If the traversal data of the next sub-exploration project is fine, it means that only the initial exploration chart data of the current sub-exploration project has a problem. Only the initial exploration chart data of the current sub-exploration project can be calibrated, which can greatly reduce the subsequent data calibration time. The statistical work is only terminated when the total cumulative depth of two consecutive sub-exploration projects has a problem.

[0065] Example

[0066] The present invention is further described below in conjunction with specific embodiments:

[0067] During the detailed survey stage of a certain project, a total of 126 drilling explorations were completed, including 72 onshore holes and 54 above-water holes. The physical exploration workload was first counted.

[0068] (1) Extract drilling exploration data from exploration charts and save them as Excel files, such as Figure 3 The typical format is as follows:

[0069] ZK01……

[0070] 3 5.20……

[0071] 4 11.70……

[0072] 7 13.40……

[0073] 8 16.70……

[0074] 9 20.90……

[0075] Each borehole exploration data is divided into two columns, where the first row is the borehole number, and starting from the second row, the first column is the code of the actual stratum, which can be numbered by yourself, but the code is guaranteed to be unique, and the second column is the depth of the corresponding stratum.

[0076] (2) According to the geological survey of the project site, all the strata appearing in the site are counted, including the stratum code m and the rock and soil category Km (Km = 1, 2, 3, 4, 5, 6), and saved as a .dat file, such as Figure 4 The typical format is as follows: 1 1 twenty one 3 3 4 3 5 3 6 2 7 2 8 3 9 5

[0086] The stratigraphic information data is divided into two columns. The first column is the code of the actual stratigraphic layer, which corresponds to the code in step (1). The second column is the geotechnical category of the stratigraphic layer (Ⅰ, Ⅱ, Ⅲ, Ⅳ, Ⅴ, Ⅵ). For the convenience of memory and programming, Arabic numerals are used instead.

[0087] (3) This project is a drilling exploration. According to the provisions of the engineering investigation standards, the depth range limit value (i.e. the divided depth interval) is [0,10,20,30,40,50,60,80,100].

[0088] (4) For the i-th borehole, search for the stratum code that falls within the range of the depth interval one by one. Starting from the depth interval [0,10], search for the rock and soil category Km that matches it, and define 6 total cumulative depths with an initial value of 0 to store the cumulative depth of each stratum. After all strata are searched, check whether the sum of the 6 variables is equal to the difference between the upper and lower limits of the interval range. If the two are not equal, the program exits and reports an error; if the two are equal, proceed to the next step.

[0089] (5) Save the depth of each formation and the classification of geotechnical categories of the current borehole, that is, the depth values ​​corresponding to the geotechnical categories I, II, III, IV, V, and VI of the i-th sub-exploration project within this interval. Each depth interval contains six depth values ​​corresponding to the six geotechnical categories, and one depth interval saves 6 values.

[0090] (6) Each time the depth interval is changed, the six storage variables are initialized to 0. After all the depth intervals are searched, the current drilling work statistics are completed.

[0091] (7) Repeat steps (4) to (6) until all the actual drilling workload is calculated and all statistical results are saved in a file, such as Figure 5 shown.

[0092] In order to realize the above-mentioned exploration physical object workload statistics method, the present invention also provides an exploration physical object workload statistics system, comprising:

[0093] The depth interval division module is used to divide the depth interval of each type of general exploration project;

[0094] A data extraction module is used to extract exploration data from the exploration chart, wherein the exploration data includes a plurality of sub-exploration projects, each of which includes a project number, a formation code, a formation depth, and a rock and soil category to which the formation belongs;

[0095] The data traversal module is used to traverse each sub-exploration project in the order of project number from small to large; for each sub-exploration project, traverse each depth interval in the order from shallow to deep; for each depth interval, find the formation code falling in the corresponding depth interval, determine the rock and soil category and formation depth corresponding to the formation code; accumulate the formation depths of the formation codes of the same rock and soil category to obtain the total cumulative depth corresponding to each rock and soil category in the corresponding depth interval.

[0096] It should be noted that the specific implementation process of each of the above functional modules has been described in detail in the aforementioned statistical method for physical exploration workload, and will not be repeated here. Each functional module or the above statistical method can be implemented using the Python programming language. The development speed of the Python programming language is usually faster than other languages, which is very advantageous for rapid development and iteration. It can automatically calculate the physical exploration workload, which can not only avoid errors and omissions in manual calculations, but also greatly reduce duplication of work and greatly improve work efficiency.

[0097] It should be understood that the specific order or hierarchy of steps in the disclosed process is an example of an exemplary method. Based on design preferences, it should be understood that the specific order or hierarchy of steps in the process can be rearranged without departing from the scope of protection of the present disclosure. The attached method claims present the elements of the various steps in an exemplary order and are not intended to be limited to the specific order or hierarchy described.

[0098] In order to make the description of the present disclosure more detailed and complete, the above description is provided for the implementation and specific embodiments of the present invention; however, this is not the only form of implementing or using the specific embodiments of the present invention. The implementation covers the features of multiple specific embodiments and the method steps and sequences used to construct and operate these specific embodiments. However, other specific embodiments can also be used to achieve the same or equivalent functions and step sequences.

[0099] Those skilled in the art may also appreciate that the various illustrative logic blocks, units, and steps listed in the embodiments of the present invention may be implemented by electronic hardware, computer software, or a combination of the two. To clearly demonstrate the interchangeability of hardware and software, the various illustrative components, units, and steps described above have generally described their functions. Whether such functions are implemented by hardware or software depends on the specific application and the design requirements of the entire system. Those skilled in the art may use various methods to implement the described functions for each specific application, but such implementation should not be understood as exceeding the scope of protection of the embodiments of the present invention.

[0100] The above are only specific embodiments of the present invention, but the protection scope of the present invention is not limited thereto. Any changes or substitutions that can be easily thought of by a person skilled in the art within the technical scope disclosed by the present invention should be included in the protection scope of the present invention. The contents not described in detail in this specification belong to the prior art known to professional and technical personnel in the field.

Claims

1. A method for statistically analyzing physical exploration workload, characterized in that: Divide the depth interval of each type of general exploration project, and extract exploration data from the exploration chart, wherein the exploration data includes a number of sub-exploration projects, and each sub-exploration project includes a project number, a formation code, a formation depth, and a rock and soil category to which the formation belongs; Traverse each sub-exploration project in ascending order of project number; For each sub-exploration project, each depth interval is traversed from shallow to deep; For each depth interval, search for the formation code that falls within the corresponding depth interval, and determine the rock and soil type and formation depth corresponding to the formation code; The stratigraphic depths of the stratigraphic codes of the same rock and soil category are accumulated to obtain the total cumulative depth corresponding to each rock and soil category in the corresponding depth interval.

2. The method for statistically analyzing physical exploration workload according to claim 1, characterized in that: The general exploration projects are divided into four categories: drilling, exploration wells, exploration trenches and adit.

3. The method for statistically analyzing physical exploration workload according to claim 1, characterized in that: After obtaining the total cumulative depth of each rock and soil category in the corresponding depth interval, the accuracy of the exploration data is judged based on the total cumulative depth.

4. The method for statistically analyzing physical exploration workload according to claim 3, characterized in that: The process of judging whether the exploration data is correct based on the total cumulative depth is: The total accumulated depth is compared with the difference between the upper and lower limits of the corresponding depth interval. If the total accumulated depth is equal to the difference between the upper and lower limits, the exploration data is judged to be accurate; otherwise, the exploration physical workload statistics are exited.

5. The method for statistically analyzing physical exploration workload according to claim 1, characterized in that: The steps to traverse each sub-exploration project are: Step 1, set the initial cumulative depth corresponding to each geotechnical category of the i-th sub-exploration project, and proceed to step 2; Step 2, determine the jth depth interval and proceed to step 3; Step 3, determine the mth formation code, determine whether the formation depth H corresponding to the mth formation code is within the jth depth interval, and proceed to step 4; Step 4, if yes, determine the geotechnical category Km of the mth stratigraphic code, add the stratigraphic depth H of the mth stratigraphic code to the cumulative depth corresponding to the geotechnical category Km, and proceed to step 5; if no, proceed to step 5; Step 5, determine whether the traversal of the formation code is completed. If completed, calculate the total cumulative depth of each rock and soil category in the jth depth interval and proceed to step 6; if not completed, determine m=m+1 and return to step 3; Step 6, determine whether the total cumulative depth is equal to the difference between the upper and lower limits of the j-th depth interval. If so, obtain the total cumulative depth of each rock and soil category in the j-th depth interval and proceed to step 7; if not, proceed to step 9; Step 7, determine whether the depth interval traversal is completed, if completed, proceed to step 8; if not completed, determine j=j+1, and return to step 2; Step 8, determine whether the traversal of the sub-exploration items is completed, if completed, proceed to step 9; if not completed, determine i=i+1, and return to step 1; Step 9, end the statistical work.

6. A system for statistically analyzing physical exploration workload, characterized in that: include The depth interval division module is used to divide the depth interval of each type of general exploration project; A data extraction module is used to extract exploration data from the exploration chart, wherein the exploration data includes a plurality of sub-exploration projects, each of which includes a project number, a formation code, a formation depth, and a rock and soil category to which the formation belongs; The data traversal module is used to traverse each sub-exploration project in the order of project number from small to large; for each sub-exploration project, traverse each depth interval in the order from shallow to deep; for each depth interval, find the formation code falling in the corresponding depth interval, determine the rock and soil category and formation depth corresponding to the formation code; accumulate the formation depths of the formation codes of the same rock and soil category to obtain the total cumulative depth corresponding to each rock and soil category in the corresponding depth interval.

7. The exploration physical object workload statistics system according to claim 6, characterized in that: The general exploration projects are divided into four categories: drilling holes, exploration wells, exploration trenches, and adit tunnels. The depth intervals of different general exploration projects have different division ranges, that is, different numbers.

8. The exploration physical object workload statistics system according to claim 7, characterized in that: The depth interval of the borehole is [0, 10, 20, 30, 40, 50, 60, 80, 100], the depth interval of the exploration well is [0, 2, 5, 10, 20], the depth interval of the exploration trench is [0, 2], and the depth interval of the adit is [0, 50, 100, 150, 200, 250, 300].

9. The exploration physical object workload statistics system according to claim 6, characterized in that: After obtaining the total cumulative depth of each rock and soil category in the corresponding depth interval, the accuracy of the exploration data is judged based on the total cumulative depth.

10. The exploration physical object workload statistics system according to claim 9, characterized in that: The process of judging whether the exploration data is correct based on the total cumulative depth is: The total accumulated depth is compared with the difference between the upper and lower limits of the corresponding depth interval. If the total accumulated depth is equal to the difference between the upper and lower limits, the exploration data is judged to be accurate; otherwise, the exploration physical workload statistics are exited.

Citation Information

Patent Citations

  • Site stratum three-dimensional geological structure model generation method for natural foundation replacement quantities calculation

    CN105184864A

  • Processing method and device of engineering investigation data, equipment and storage medium

    CN110646862A

  • Method and device for determining stratum overpressure category in while-drilling process

    CN114592859A

  • Drilling excitation method and device, storage medium and processor

    CN115788411A

  • Standardized extraction method for geotechnical engineering investigation data

    CN118966172A