A method, device, computer equipment and storage medium for stratum sequencing

Abstract

The present application provides a stratigraphic sorting method, device, computer equipment and storage medium, which relate to the field of engineering geology and are used to quickly analyze and judge underground unknown rock and soil layer information. The stratigraphic sorting method includes: obtaining a stratigraphic data set of a target geological area, wherein the stratigraphic data set includes multiple stratigraphic set data, each of which includes at least one rock and soil layer and data of each rock and soil layer; sorting the rock and soil layers of the target geological area according to the stratigraphic data set of the target geological area, and obtaining the sorting results of the rock and soil layers of the target geological area as a basis for subsequent design and production. By replacing the traditional manual analysis and sorting method, the sorting efficiency and accuracy are greatly improved.

Description

Technical Field

[0001] The present application relates to the field of engineering geology, and more specifically, to a stratum sequencing method, apparatus, computer equipment and storage medium. Background Art

[0002] Today, a large number of engineering projects are being carried out around the world every day, such as municipal engineering, civil engineering, bridges, roads, tunnels, etc. Before engineering design and construction, it is necessary to conduct a drilling survey of the work site, obtain a number of drilling data of the work site, integrate the stratigraphic data set of the work area, and perform stratigraphic sorting on the stratigraphic data set to obtain the stratigraphic sorting result of the work site. The existing stratigraphic sorting is mainly done manually, which is inefficient. Summary of the invention

[0003] Based on this, it is necessary to propose a stratigraphic sorting method, device, computer equipment and storage medium to address the above problems.

[0004] To achieve the above objectives, the technical solutions adopted in this application are as follows:

[0005] In a first aspect, the present application provides a stratigraphic sequencing method, comprising:

[0006] Acquire a stratigraphic data set of a target geological area, wherein the stratigraphic data set includes a plurality of stratigraphic data sets, each of which includes at least one rock and soil layer and data of each rock and soil layer;

[0007] According to the stratigraphic data set of the target geological area, the rock and soil layers of the target geological area are sorted to obtain the sorting result of the rock and soil layers of the target geological area.

[0008] The stratigraphic sorting method first obtains a stratigraphic data set of a target geological area, wherein the stratigraphic data set includes multiple stratigraphic set data, and each stratigraphic set data includes at least one rock and soil layer and data of each rock and soil layer, and then, based on the stratigraphic data set of the target geological area, the rock and soil layer data of the target geological area can be obtained, so as to sort the rock and soil layers of the target geological area and obtain the sorting result of the rock and soil layers of the target geological area. This implementation method does not need to rely on manual sorting, which improves the sorting efficiency to a certain extent.

[0009] Optionally, the step of sorting the rock and soil layers of the target geological area according to the stratigraphic data set of the target geological area to obtain the sorting result of the rock and soil layers of the target geological area includes:

[0010] According to the stratigraphic data set of the target geological area, sequential anomaly detection and streamlining processing are performed on the rock and soil layers of the target geological area to obtain a normal stratigraphic data set of the target geological area;

[0011] According to the normal stratigraphic data set of the target geological area, the secondary rock and soil layers in the normal stratigraphic data set of the target geological area are removed to obtain the sorted stratigraphic data set of the target geological area;

[0012] According to the sorted stratigraphic data set of the target geological area, a rock and soil layer sorting result of the target geological area is obtained.

[0013] In the above implementation process, it is necessary to perform anomaly detection and processing on the stratigraphic data set of the target geological area to obtain a normal stratigraphic data set of the target geological area, and then remove the secondary rock and soil layers in the normal stratigraphic data of the target geological area to obtain a sorted stratigraphic data set of the target geological area, and sort the rock and soil layers according to the sorted stratigraphic data set of the target geological area to obtain the rock and soil layer sorting result of the target geological area. In this implementation process, the sequential abnormal rock and soil layers will be detected and processed, and the secondary rock and soil layers will be removed. Only through anomaly detection and secondary rock and soil layer processing can the correct rock and soil layer sorting result be finally obtained, reducing the error rate of rock and soil layer sorting.

[0014] Optionally, the step of performing sequential anomaly detection and streamlining processing on the rock and soil layers of the target geological area according to the stratigraphic dataset of the target geological area to obtain a normal stratigraphic dataset of the target geological area includes:

[0015] Determine, based on the stratigraphic set data, whether there are continuous interlaced rock and soil layers in the stratigraphic set data corresponding to the stratigraphic set data, wherein the continuous interlaced rock and soil layers include two rock and soil layers, and the rock and soil layers of the two rock and soil layers are interlaced;

[0016] If there are continuous interlaced rock and soil layers in the stratum corresponding to the stratum set data, then determining the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers, and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated;

[0017] The rock and soil layer to be assimilated is assimilated into an assimilated rock and soil layer corresponding to the rock and soil layer to be assimilated, so as to obtain a normal stratigraphic data set of the target geological area.

[0018] In the above implementation process, it is determined whether there are continuous interlaced rock and soil layers in the stratum corresponding to the stratigraphic set data. If there are continuous interlaced rock and soil layers, it is necessary to determine the rock and soil layers to be assimilated, as well as the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated, and assimilate the rock and soil layers to be assimilated into the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated, and finally obtain a normal stratigraphic data set of the target geological area. In this implementation process, abnormal rock and soil layer detection is performed, and the detected abnormal rock and soil layers are assimilated to obtain a normal stratigraphic data set; the stratigraphic data set is an important basis for the sorting of rock and soil layers. Whether the data of the stratigraphic data set is abnormal is an important factor affecting the sorting results of the rock and soil layers. Detecting abnormal rock and soil layers is not only conducive to subsequent sorting operations, but also can improve the accuracy of sorting.

[0019] Optionally, if there are continuous interlaced rock and soil layers in the stratum corresponding to the stratum set data, determining the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers, and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated, comprises:

[0020] If there are continuous interlaced rock and soil layers in the stratum corresponding to the stratum set data, the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated are determined according to the thickness of the rock and soil layers.

[0021] In the above implementation process, if there are continuous interlaced rock and soil layers in the stratum corresponding to the stratum set data, the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated can be determined according to the thickness of the rock and soil layers. By judging the thickness of the rock and soil layers, the rock and soil layers to be assimilated and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated can be quickly determined, and subsequent sorting operations are also facilitated.

[0022] Optionally, if there are continuous interlaced rock and soil layers in the stratum corresponding to the stratum set data, determining the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers, and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated, comprises:

[0023] If there are continuous interlaced rock and soil layers in the strata corresponding to the stratum set data, the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated are determined according to the distribution area of ​​the rock and soil layers.

[0024] In the above implementation process, if there are continuous interlaced rock and soil layers in the stratum corresponding to the stratum set data, the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated can be determined according to the distribution area of ​​the rock and soil layers. By judging the distribution area of ​​the rock and soil layers, the rock and soil layers to be assimilated and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated can be quickly determined, and the subsequent sorting operation is also facilitated.

[0025] Optionally, removing the secondary rock and soil layers in the normal stratigraphic dataset of the target geological area according to the normal stratigraphic dataset of the target geological area to obtain the sorted stratigraphic dataset of the target geological area includes:

[0026] Determine the target rock and soil layers included in the target geological area according to the normal stratigraphic data set of the target geological area; the target rock and soil layers are two rock and soil layers that appear simultaneously in two or more stratigraphic data sets, and the positions of the two rock and soil layers in different stratigraphic data sets are interlaced in sequence;

[0027] Comparing the occurrence frequencies of two rock and soil layers in the target rock and soil layer, the rock and soil layer with a lower occurrence frequency is a secondary rock and soil layer, and removing the secondary rock and soil layer to obtain a sorted stratigraphic data set of the target geological area;

[0028] If the occurrence frequencies of two rock and soil layers in the target rock and soil layers are the same, the thicknesses of the two rock and soil layers in the target rock and soil layers are compared, and the rock and soil layer with smaller thickness is the secondary rock and soil layer. The secondary rock and soil layer is removed to obtain the sorted stratigraphic data set of the target geological area.

[0029] In the above implementation process, according to the normal stratigraphic dataset of the target geological area, the secondary rock and soil layers in the normal stratigraphic dataset of the target geological area are removed to obtain the sorted stratigraphic dataset of the target geological area, providing support for subsequent sorting operations.

[0030] Optionally, obtaining the rock and soil layer sorting result of the target geological area according to the sorted stratigraphic dataset of the target geological area includes:

[0031] According to the sorted stratigraphic data set of the target geological area, the position of the rock and soil layers of the target geological area is determined, and the sorting result of the rock and soil layers of the target geological area is obtained.

[0032] In the above implementation process, the position and rock layers of the target geological area are determined according to the sorted stratigraphic data set of the target geological area, and the sorting result of the rock and soil layers of the target geological area can be obtained. The operation of sorting the rock and soil layers of the target geological area is realized, and data support is provided for subsequent geological engineering operations.

[0033] In a second aspect, a stratum sequencing device is provided, comprising:

[0034] An acquisition module, used for acquiring a stratigraphic data set of a target geological area, wherein the stratigraphic data set includes a plurality of stratigraphic data sets, each of which includes at least one rock and soil layer and data of each rock and soil layer;

[0035] The sorting module is used to sort the rock and soil layers of the target geological area according to the stratigraphic data set of the target geological area to obtain the sorting result of the rock and soil layers of the target geological area.

[0036] In a third aspect, a computer device is provided, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the stratigraphic sorting method as described in the first aspect when executing the computer program.

[0037] In a fourth aspect, a computer-readable storage medium is provided, wherein the computer-readable storage medium stores computer program instructions, and when the computer program instructions are read and executed by a processor, the steps of the stratigraphic sorting method described in the first aspect are executed. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for use in the embodiments of the present application will be briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present application and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without paying creative work.

[0039] Figure 1 A flow chart of the stratigraphic sorting method provided in an embodiment of the present application;

[0040] Figure 2 for Figure 1 The schematic diagram of the process of step S200 in the stratigraphic sorting method shown;

[0041] Figure 3 for Figure 2 The schematic diagram of the process of step S210 in the stratigraphic sorting method shown;

[0042] Figure 4 for Figure 2 The schematic diagram of the process of step S220 in the stratigraphic sorting method shown;

[0043] Figure 5 A schematic diagram of a stratum sequencing device provided in an embodiment of the present application;

[0044] Figure 6 A device schematic diagram of a computer device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0045] 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.

[0046] Please see Figure 1 , Figure 1 This is a flow chart of a stratum sorting method disclosed in an embodiment of the present application. Figure 1 The specific process and steps of a stratigraphic sorting method provided in an embodiment of the present application are described.

[0047] Step S100: Acquire a stratigraphic data set of a target geological area, wherein the stratigraphic data set includes a plurality of stratigraphic data sets, each of which includes at least one rock and soil layer and data of each rock and soil layer.

[0048] In the embodiment of the present application, the target geological area is a selected soil sample extraction area; the stratigraphic data set of the target geological area includes multiple stratigraphic data sets; the stratigraphic data sets are obtained by selecting multiple points in the target geological area and drilling holes at a certain depth at each point to obtain soil samples. One stratigraphic data set is obtained by drilling holes to obtain soil samples. Since the stratigraphic data set is obtained by drilling, it can be understood that the stratigraphic data set includes at least one rock and soil layer; the rock and soil layer data is data related to the rock and soil layer, for example, the stratigraphic data set includes rock and soil layer k, the rock and soil layer k data includes the color of rock and soil layer k, the thickness of rock and soil layer k, and the rock and soil layer k data may also include but are not limited to the regional distribution range of the rock and soil layer, the rock and soil layer k The main layer code of the rock and soil layer, the sub-layer code of the rock and soil layer and the sub-layer code of the rock and soil hierarchy, etc. The regional distribution range of the rock and soil layer refers to the distribution range of the rock and soil layer in the plane formed by the x-axis and the y-axis in the spatial rectangular coordinate system formed by the x-axis, the y-axis and the z-axis. The main layer code of the rock and soil layer indicates the age of the rock and soil layer, usually expressed in numbers. For example, the main layer code of the rock and soil layer is 6, which means that the age of the rock and soil layer is Jurassic. The sub-layer code of the rock and soil layer indicates the rock and soil structural properties of the rock and soil layer of the same geological age. For example, the sub-layer code of the rock and soil layer is 7, which means that the rock and soil layer structure is a clay layer. The sub-layer code of the rock and soil hierarchy indicates the lithology and physical properties of the rock and soil layer with the same rock and soil structural properties. For example, the sub-layer code of the rock and soil hierarchy is 1, which means that the lithology and physical properties of the rock and soil layer are residual soil.

[0049] Step S200: Sort the rock and soil layers of the target geological area according to the stratigraphic data set of the target geological area to obtain a sorting result of the rock and soil layers of the target geological area.

[0050] In an embodiment of the present application, step S200 sorts the rock and soil layers of the target geological area according to the stratigraphic set data obtained by multiple drilling and soil sampling. The sorting is generally to sort the physical positions of the rock and soil layers in the stratigraphic data set of the target geological area, that is, to sort the positions of each rock and soil layer in the stratigraphic layer, so as to determine the depth of each rock and soil layer in the stratigraphic layer, that is, to determine the depth of each rock and soil layer in the stratigraphic layer. For example, the stratigraphic data set includes rock and soil layers A to D, and the rock and soil layer sorting results are: rock and soil layer A is in the first layer, rock and soil layer B is in the second layer, rock and soil layer C is in the third layer, and rock and soil layer D is in the fourth layer. It can be seen that rock and soil layer A is close to the ground, and rock and soil layer D is close to the center of the earth.

[0051] In the stratigraphic sorting method, step S100 first obtains a stratigraphic data set of a target geological area, wherein the stratigraphic data set includes multiple stratigraphic set data, and each stratigraphic set data includes at least one rock and soil layer and data of each rock and soil layer, and then step S200 obtains rock and soil layer data of the target geological area based on the stratigraphic data set of the target geological area, so as to sort the rock and soil layers of the target geological area and obtain the sorting result of the rock and soil layers of the target geological area. This implementation method does not need to rely on manual sorting.

[0052] In the embodiment of the present application, the rock and soil layers of the target geological area are sorted to obtain the rock and soil layer sorting result of the target geological area, that is, the stratigraphic sorting result of the target geological area. In addition, in the embodiment of the present application, as an optional implementation, step S200 may include step S210, step S220 and step S230. For specific step contents, please refer to Figure 2 .

[0053] Step S210, based on the stratigraphic dataset of the target geological area, sequential anomaly detection and streamlining processing are performed on the rock and soil layers of the target geological area to obtain a normal stratigraphic dataset of the target geological area.

[0054] In the embodiment of the present application, step 210 simplifies the rock and soil layers that may have abnormal sequence in the stratigraphic data set of the target geological area to obtain a normal stratigraphic data set of the target geological area.

[0055] For example, when the ABA situation appears in the stratigraphic data, it means that rock layer A and rock layer B are abnormal rock layers, and it is difficult to determine the relative position relationship between rock layer A and rock layer B in the stratigraphic data. It is necessary to correct rock layer A and rock layer B. For example, assimilate rock layer B into rock layer A to obtain AAA rock layer, and merge the three rock layers into one rock layer A to obtain a normal stratigraphic data set.

[0056] Step S220, according to the normal stratigraphic data set of the target geological area, the secondary rock and soil layers in the normal stratigraphic data set of the target geological area are removed to obtain the sorted stratigraphic data set of the target geological area.

[0057] In the embodiment of the present application, the secondary rock and soil layers in the normal stratigraphic data set of the target geological area do not participate in the rock and soil layer sorting and need to be removed in advance.

[0058] Step S230, obtaining a rock and soil layer sorting result of the target geological area according to the sorted stratigraphic dataset of the target geological area.

[0059] In the embodiment of the present application, step S230 sorts the rock and soil layers of the target geological area according to the sorted stratigraphic dataset of the target geological area, so as to obtain the sorting result of the rock and soil layers of the target geological area.

[0060] For example, the rock and soil layers in the target geological area include rock and soil layers A to E, among which the secondary rock and soil layers include rock and soil layers D and rock and soil layers E. Rock and soil layers D and rock and soil layers E do not participate in the sorting. Therefore, the rock and soil layers A to C are sorted, and the rock and soil layer sorting result may be: rock and soil layer A is in the first layer, rock and soil layer C is in the second layer, and rock and soil layer B is in the third layer.

[0061] In the embodiment of the present application, step S210 performs sequential anomaly detection and simplification processing on the stratigraphic data set of the target geological area to obtain a normal stratigraphic data set of the target geological area, and step S220 removes the secondary rock and soil layers in the normal stratigraphic data set of the target geological area to obtain a sorted stratigraphic data set of the target geological area, and step S230 sorts the sorted stratigraphic data set of the target geological area to obtain a rock and soil layer sorting result of the target geological area. In this implementation process, the sequential abnormal rock and soil layers will be detected and processed, and the secondary rock and soil layers will be removed. Only by detecting anomalies and screening out the secondary rock and soil layers can the correct rock and soil layer sorting result be finally obtained, thereby reducing the error rate of rock and soil layer sorting.

[0062] In the embodiment of the present application, there may be rock and soil layers with abnormal sequence in the stratigraphic data set of the target geological area, and the rock and soil layers with abnormal sequence need to be processed to obtain a normal stratigraphic data set of the target geological area. In this embodiment, as an optional implementation, step S210 may include steps S211, S212 and S213, and the specific contents may be as follows: Figure 3 .

[0063] Step S211, determining whether there are continuous interlaced rock and soil layers in the stratum corresponding to the stratum set data according to the stratum set data, wherein the continuous interlaced rock and soil layers include two rock and soil layers, and the rock and soil layer positions of the two rock and soil layers are interlaced.

[0064] In the embodiment of the present application, step S211 is to determine whether there are sequential abnormal rock and soil layers in the stratigraphic set data. Sequential abnormal rock and soil layers include the situation where continuous interlaced rock and soil layers appear. When continuous interlaced rock and soil layers appear, it is impossible to determine the relative positions of the two rock and soil layers in the interlaced rock and soil layers, and at this time, it is impossible to sort the rock and soil layers in the stratigraphic data set. For example, taking rock and soil layers A and B as an example, the abnormal rock and soil layers are explained; when the situation of ABABAB appears in the stratigraphic set data, it means that rock and soil layers A and B appear continuously and interlaced with each other. At this time, it is difficult to determine the relative position relationship between rock and soil layers A and B in the stratigraphic set data, and rock and soil layers A and B need to be corrected.

[0065] Step S212: If there are continuous interlaced rock and soil layers in the stratum corresponding to the stratum set data, determine the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers, and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated.

[0066] In an embodiment of the present application, for example, taking rock layer A and rock layer B as an example, when continuous interlaced rock layers A1B1A2B2 appear in the stratigraphic data, B1 can be determined as the rock layer to be assimilated, and rock layer A2 can be determined as the assimilated rock layer corresponding to the rock layer to be assimilated.

[0067] Step S213, assimilating the rock and soil layer to be assimilated into an assimilated rock and soil layer corresponding to the rock and soil layer to be assimilated, to obtain a normal stratigraphic data set of the target geological area.

[0068] In an embodiment of the present application, for example, taking rock layer A and rock layer B as an example, when continuous interlaced rock layers A1B1A2B2 appear in the stratigraphic data set, B1 has been determined as the rock layer to be assimilated, and rock layer A2 has been determined as the assimilated rock layer corresponding to the rock layer to be assimilated, rock layer B is assimilated into A to obtain A1A2A3B1, and A1A2A3 is merged into A, so that a normal stratigraphic data set is obtained based on AB.

[0069] It should be noted that the rock and soil layers A1, A2 and A3 are of the same type, and the subscripts only indicate the order of the rock and soil layers for easy distinction. The same is true for the rock and soil layers B1 and B2.

[0070] In the embodiment of the present application, step S211 determines whether there are continuous interlaced rock and soil layers in the stratum corresponding to the stratigraphic set data, and step S212 determines the rock and soil layers to be assimilated and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated when there are continuous interlaced rock and soil layers. Step S213 assimilates the rock and soil layers to be assimilated into the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated, and finally obtains a normal stratigraphic data set of the target geological area. In this implementation process, sequential abnormal rock and soil layer detection is performed, and the detected sequential abnormal rock and soil layers are assimilated to obtain a normal stratigraphic data set; the stratigraphic data set is an important basis for the sorting of rock and soil layers. Whether there are sequential abnormal rock and soil layers in the data of the stratigraphic data set is an important factor affecting the sorting results of the rock and soil layers. Detecting abnormal rock and soil layers is beneficial to the subsequent sorting operations and can also improve the accuracy of sorting.

[0071] It should be noted that, in this embodiment, for step S212, if there are continuous interlaced rock and soil layers in the stratum corresponding to the stratum set data, determining the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers, and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated includes:

[0072] If there are continuous interlaced rock and soil layers in the stratum corresponding to the stratum set data, the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated are determined according to the thickness of the rock and soil layers.

[0073] In the embodiment of the present application, step S212 processes the continuous interlaced rock and soil layers existing in the stratigraphic set data, and determines the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated according to the thickness of the rock and soil layers.

[0074] For example, when continuous interlaced rock and soil layers A1B1A2B2 appear in the stratigraphic data, the thicknesses of the B1 rock and soil layers and the A2 rock and soil layers are compared. When the thickness of the A2 rock and soil layer is greater than that of the B1 rock and soil layer, B1 is determined as the rock and soil layer to be assimilated, and the rock and soil layer A2 is determined as the assimilated rock and soil layer corresponding to the rock and soil layer to be assimilated.

[0075] In the embodiment of the present application, if there are continuous interlaced rock and soil layers in the stratum corresponding to the stratum set data, the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated can be determined according to the thickness of the rock and soil layers. By judging the thickness of the rock and soil layers, the rock and soil layers to be assimilated and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated can be quickly determined, and subsequent sorting operations are also facilitated.

[0076] It should be noted that, in this embodiment, for step S212, if there are continuous interlaced rock and soil layers in the stratum corresponding to the stratum set data, determining the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers, and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated includes:

[0077] If there are continuous interlaced rock and soil layers in the strata corresponding to the stratum set data, the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated are determined according to the distribution area of ​​the rock and soil layers.

[0078] In the embodiment of the present application, step S212 processes the continuous interlaced rock and soil layers existing in the stratigraphic set data, and determines the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers according to the distribution area of ​​the rock and soil layers, as well as the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated.

[0079] For example, when continuous interlaced rock and soil layers A1B1A2B2 appear in the stratum data, the distribution areas of the B1 rock and soil layers and the A2 rock and soil layers are compared. When the distribution area of ​​the A2 rock and soil layer is wider than that of the B1 rock and soil layer, B1 is determined as the rock and soil layer to be assimilated, and the rock and soil layer A2 is determined as the assimilated rock and soil layer corresponding to the rock and soil layer to be assimilated. In other words, when continuous interlaced rock and soil layers appear, the rock and soil layer with a smaller distribution area in the middle rock and soil layer is set as the rock and soil layer to be assimilated, and another rock and soil layer different from the rock and soil layer to be assimilated is set as the assimilated rock and soil layer corresponding to the rock and soil layer to be assimilated.

[0080] In the embodiment of the present application, if there are continuous interlaced rock and soil layers in the stratum corresponding to the stratum set data, the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated can also be determined according to the distribution area of ​​the rock and soil layers. By judging the distribution area of ​​the rock and soil layers, the rock and soil layers to be assimilated and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated can be quickly determined, and subsequent sorting operations are also facilitated.

[0081] It should be noted that the difference between the judgment of rock and soil layer thickness and the judgment of rock and soil layer regional distribution is that the judgment of rock and soil layer thickness is judged along the z-axis, while the judgment of rock and soil layer regional distribution is judged along the plane formed by the x-axis and the y-axis; the x-axis is the horizontal axis, the y-axis is the longitudinal axis, and the z-axis is the vertical axis. The x-axis, y-axis and z-axis are perpendicular to each other, forming a spatial rectangular coordinate system. For example, to compare the thickness of rock and soil layer A and rock and soil layer B, it is only necessary to judge the length of rock and soil layer A and rock and soil layer B along the z-axis; while to compare the distribution area of ​​rock and soil layer A and rock and soil layer B, it is necessary to judge the size of the distribution area of ​​rock and soil layer A and rock and soil layer B in the area of ​​the plane formed by the x-axis and the y-axis.

[0082] In addition, in the embodiment of the present application, as an optional implementation, step S220 may include step S221 and step S222. For specific steps, see Figure 4 .

[0083] Step S221:

[0084] According to the normal stratigraphic data set of the target geological area, the target rock and soil layers included in the target geological area are determined; the target rock and soil layers are two rock and soil layers that appear simultaneously in two or more stratigraphic data sets, and the positions of the two rock and soil layers in different stratigraphic data sets are interlaced in sequence.

[0085] In an embodiment of the present application, step S221 determines the target rock and soil layers based on the normal stratigraphic data set of the target geological area; the target rock and soil layers are two rock and soil layers that appear simultaneously in two or more stratigraphic set data, and the positions of the two rock and soil layers in different stratigraphic set data are staggered in sequence. For example, a normal stratigraphic data set includes 5 stratigraphic data sets, and all of the 5 stratigraphic data sets include rock and soil layers A, B, C, D, and E; however, the position order of rock and soil layers A and C in the stratigraphic data sets is different, and rock and soil layers A and C are target rock and soil layers; for example, in the first stratigraphic data set, the position order of rock and soil layers A and C is AC, and in the second stratigraphic data set, the position order of rock and soil layers A and C is CA. Since the position order of rock and soil layers A and C is staggered, one rock and soil layer must be simplified and removed as a secondary rock and soil layer, and the secondary rock and soil layer does not participate in the sorting, for example, rock and soil layer C is a secondary rock and soil layer; the remaining rock and soil layers A, B, D, and E are sorted. It should be noted that there can be multiple target rock and soil layers, and each target rock and soil layer includes two rock and soil layers.

[0086] Step S222: comparing the occurrence frequencies of two rock and soil layers in the target rock and soil layer, the rock and soil layer with a lower occurrence frequency is a secondary rock and soil layer, and removing the secondary rock and soil layer to obtain a sorted stratigraphic data set of the target geological area;

[0087] If the occurrence frequencies of two rock and soil layers in the target rock and soil layers are the same, the thicknesses of the two rock and soil layers in the target rock and soil layers are compared, and the rock and soil layer with the smaller thickness is the secondary rock and soil layer; the secondary rock and soil layer is removed to obtain the sorted stratigraphic data set of the target geological area. It should be noted that when the occurrence frequencies of two rock and soil layers in the target rock and soil layers are the same or similar, it is necessary to judge the secondary rock and soil layer by comparing the thicknesses.

[0088] In the embodiment of the present application, the occurrence frequencies of two rock and soil layers in the target rock and soil layer are compared, and the rock and soil layer removes the secondary rock and soil layer. For example, the two rock and soil layers in the target rock and soil layer are rock and soil layer A and rock and soil layer C. The occurrence frequencies of rock and soil layer A and rock and soil layer C are compared. If the occurrence frequency of rock and soil layer A is greater than the occurrence frequency of rock and soil layer C, rock and soil layer C is the secondary rock and soil layer, and rock and soil layer C is removed to obtain the sorted stratigraphic data set of the target geological area; if the occurrence frequencies of rock and soil layer A and rock and soil layer C are similar, the thicknesses of rock and soil layer A and rock and soil layer C are compared. If the thickness of rock and soil layer A is greater than the occurrence frequency of rock and soil layer C, rock and soil layer C is the secondary rock and soil layer, and rock and soil layer C is removed to obtain the sorted stratigraphic data set of the target geological area.

[0089] In the embodiment of the present application, step S221 determines the target rock and soil layer included in the target geological region according to the normal stratigraphic data set of the target geological region, and step S222 determines the secondary rock and soil layer in the target rock and soil layer, removes the secondary rock and soil layer, and obtains the sorted stratigraphic data set of the target geological region. By screening the secondary rock and soil layer in the normal stratigraphic data set of the target geological region, the sorted stratigraphic data set of the target geological region can be quickly obtained by the rock and soil layer, and support is provided for subsequent sorting operations.

[0090] In an embodiment of the present application, obtaining the rock and soil layer sorting result of the target geological area according to the sorted stratigraphic data set of the target geological area includes:

[0091] According to the sorted stratigraphic data set of the target geological area, the position of the rock and soil layers of the target geological area is determined, and the sorting result of the rock and soil layers of the target geological area is obtained.

[0092] For example, the rock and soil layer positions of the rock and soil layers in the target geological area are analyzed. If the rock and soil layers in the target geological area include rock and soil layer A, rock and soil layer B, rock and soil layer C, rock and soil layer D, rock and soil layer E and rock and soil layer F, the above rock and soil layers are sorted by physical positions. Assuming that the physical positions of the rock and soil layers are rock and soil layer A, rock and soil layer B, rock and soil layer C, rock and soil layer D, rock and soil layer E and rock and soil layer F from top to bottom, then rock and soil layer A is the first layer, represented by the number 1; rock and soil layer B is the second layer, represented by the number 2; rock and soil layer C is the third layer, represented by the number 3; rock and soil layer D is the fourth layer, represented by the number 4; rock and soil layer E is the fifth layer, represented by the number 5; and rock and soil layer F is the sixth layer, represented by the number 6.

[0093] In the embodiment of the present application, the position of the rock and soil layer of the target geological area is determined according to the sorted stratigraphic data set of the target geological area, and the sorting result of the rock and soil layer of the target geological area can be obtained. The operation of sorting the rock and soil layer of the target geological area is realized, and data support is provided for subsequent geological engineering operations.

[0094] In an embodiment of the present application, the stratigraphic data set of the target geological area is sorted, the location of the rock and soil layers of the target geological area is determined, and the rock and soil layers are sorted, and the result obtained is the sorting result of the rock and soil layers of the target geological area.

[0095] It should be noted that sorting the rock and soil layers in the target geological area means sorting the physical positions of the rock and soil layers, and using numbers to identify the layers. The number 1 represents the top layer, and the larger the number, the lower the rock and soil layer is.

[0096] It should be noted that deadlock may occur when sorting the rock and soil layers in the target geological area. For example, when the rock and soil layer sequence in a stratigraphic set data in the sorted stratigraphic data set in the target geological area is ABBA, and the rock and soil layer AB and the rock and soil layer BA are interlaced, it is considered deadlock. When deadlock occurs, return to step S220, set the rock and soil layer A or the rock and soil layer B as the secondary rock and soil layer according to the thickness of the rock and soil layer or the frequency of occurrence of the rock and soil layer, obtain the reset sorted stratigraphic data set of the target geological area, and then execute step S230 according to the reset sorted stratigraphic data set of the target geological area.

[0097] In the embodiment of the present application, there is also a situation where the rock and soil layers cannot be sorted by physical position. When the stratigraphic data set of the target geological area does not contain all types of rock and soil layers at the same time, the rock and soil layers cannot be sorted by physical position. The rock and soil layers can be sorted by the main layer code, sub-layer code and sub-layer code of the rock and soil layers to obtain the sorting result of the rock and soil layers in the target geological area.

[0098] For example, when the stratigraphic set data 1 includes four types of rock and soil layers, namely, rock and soil layer A, rock and soil layer B, rock and soil layer C and rock and soil layer D; the stratigraphic set data 2 includes five types of rock and soil layers, namely, rock and soil layer A, rock and soil layer B, rock and soil layer C, rock and soil layer D and rock and soil layer E; and the stratigraphic set data 3 includes six types of rock and soil layers, namely, rock and soil layer A, rock and soil layer B, rock and soil layer C, rock and soil layer D, rock and soil layer E and rock and soil layer F, it is impossible to sort the rock and soil layers by physical position. In this case, the rock and soil layers can also be sorted by the main layer code, sub-layer code and hierarchical sub-layer code of the rock and soil layers to obtain the rock and soil layer sorting result of the target geological area.

[0099] For example, taking the main layer code, sublayer code and sublayer code of rock and soil layer A and rock and soil layer B as examples, rock and soil layer A and rock and soil layer B are sorted; assuming that the main layer code of rock and soil layer A is 5, the sublayer code of rock and soil layer A is 6, and the sublayer code of rock and soil layer A is 1; assuming that the main layer code of rock and soil layer B is 5; the rock and soil layer code of rock and soil layer B is 7, and the sublayer code of rock and soil layer B is 1; at this time, the main layer codes of rock and soil layer A and rock and soil layer B are the same, then the sublayer codes of the rock and soil layers are compared, assuming that the rock and soil layer sublayer code is larger, the position is at the bottom, that is, in this case, the position of rock and soil layer A is above rock and soil layer B.

[0100] It should be noted that the rock and soil layers are sorted according to their main layer codes, sub-layer codes and hierarchical sub-layer codes. First, the main layer codes of the rock and soil layers are compared, and the rock and soil layers with larger main layer codes are positioned at the bottom; if the main layer codes of the rock and soil layers are consistent, the sub-layer codes of the rock and soil layers are compared, and the rock and soil layers with larger sub-layer codes are positioned at the bottom; if the sub-layer codes of the rock and soil layers are consistent, the hierarchical sub-layer codes of the rock and soil layers are compared, and the rock and soil layers with larger hierarchical sub-layer codes are positioned at the bottom.

[0101] In one embodiment, step S300 is also included, which determines whether the bottom rock and soil layer is missing in the rock and soil layer sorting result of the target geological area according to a preset standard rock and soil layer sequence; if the bottom rock and soil layer is missing, the missing bottom rock and soil layer in the rock and soil layer sorting result of the target geological area is supplemented according to the preset standard rock and soil layer sequence. Supplementing the missing bottom rock and soil layer is beneficial to subsequent geological engineering operations.

[0102] For example, the standard rock and soil layer sequence of the target geological area includes 10 rock and soil layers, while the rock and soil layer ranking result obtained according to the stratigraphic ranking method in the embodiment of the present application only includes 8 rock and soil layers. The reason for this phenomenon may be that the drilling and soil sampling are too shallow, resulting in the lack of the bottom rock and soil layer in the stratigraphic set data of the target geological area. Therefore, in order to obtain the number of rock and soil layers required by the standard rock and soil layer sequence, it is necessary to fill in the two missing bottom rock and soil layers in the rock and soil layer ranking result of the target geological area according to the standard rock and soil layer sequence of the target geological area, that is, to fill in the two missing bottom rock and soil layers in the rock and soil layer ranking result of the target geological area. The missing two bottom rock and soil layers are obtained by comparing the rock and soil layer ranking result of the target geological area with the standard rock and soil layer sequence of the target geological area.

[0103] In one embodiment, Figure 5 As shown, a formation sequencing device 30 is provided, the formation sequencing device comprising:

[0104] An acquisition module 301 is used to acquire a stratigraphic data set of a target geological area, wherein the stratigraphic data set includes a plurality of stratigraphic data sets, each of which includes at least one rock and soil layer and data of each rock and soil layer;

[0105] The sorting module 302 is used to sort the rock and soil layers of the target geological area according to the stratigraphic data set of the target geological area to obtain the sorting result of the rock and soil layers of the target geological area.

[0106] The above-mentioned device is used to execute the method provided by the above-mentioned embodiment, and its implementation principle and technical effect are the same.

[0107] The stratigraphic sorting device 30 first obtains the stratigraphic data set of the target geological area through the acquisition module 301, the stratigraphic data set includes multiple stratigraphic set data, and each stratigraphic set data includes at least one rock and soil layer and data of each rock and soil layer, and then obtains the rock and soil layer data of the target geological area through the sorting module 302 according to the stratigraphic data set of the target geological area, so as to sort the rock and soil layers of the target geological area and obtain the sorting result of the rock and soil layers of the target geological area. This implementation method does not need to rely on manual sorting, which improves the sorting efficiency to a certain extent.

[0108] In one embodiment, Figure 6 As shown, a computer device 40 is provided, which includes: a memory 401 and a processor 402. The memory 401 and the processor 402 are connected via a bus 403. The memory 401 is used to store a computer program, and the processor 402 is used to call the computer program stored in the memory 401 to execute the above method embodiment. The specific implementation method and technical effect are the same, and will not be repeated here.

[0109] In an embodiment of the present application, a computer-readable storage medium is further provided, wherein the computer-readable storage medium stores computer program instructions, and the computer program instructions are read and executed by a processor to execute the above method embodiment. The specific implementation method and technical effect are the same and will not be repeated here.

[0110] The above description is only an embodiment of the present application and is not intended to limit the protection scope of the present application. For those skilled in the art, the present application may have various modifications and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application shall be included in the protection scope of the present application.

Claims

1. A method for stratigraphic sequencing, characterized in that: include: Acquire a stratigraphic data set of a target geological area, wherein the stratigraphic data set includes a plurality of stratigraphic data sets, each of which includes at least one rock and soil layer and data of each rock and soil layer; Sorting the rock and soil layers of the target geological area according to the stratigraphic data set of the target geological area to obtain a result of the rock and soil layer sorting of the target geological area; The step of sorting the rock and soil layers of the target geological area according to the stratigraphic data set of the target geological area to obtain the sorting result of the rock and soil layers of the target geological area includes: According to the stratigraphic data set of the target geological area, sequential anomaly detection and streamlining processing are performed on the rock and soil layers of the target geological area to obtain a normal stratigraphic data set of the target geological area; According to the normal stratigraphic data set of the target geological area, the secondary rock and soil layers in the normal stratigraphic data set of the target geological area are removed to obtain the sorted stratigraphic data set of the target geological area; According to the sorted stratigraphic data set of the target geological area, a rock and soil layer sorting result of the target geological area is obtained.

2. The method for stratum sequencing according to claim 1, characterized in that: The step of performing sequential anomaly detection and streamlining processing on the rock and soil layers of the target geological area according to the stratigraphic dataset of the target geological area to obtain a normal stratigraphic dataset of the target geological area includes: Determine, based on the stratigraphic set data, whether there are continuous interlaced rock and soil layers in the stratigraphic set data corresponding to the stratigraphic set data, wherein the continuous interlaced rock and soil layers include two rock and soil layers, and the rock and soil layers of the two rock and soil layers are interlaced; If there are continuous interlaced rock and soil layers in the stratum corresponding to the stratum set data, then determining the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers, and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated; The rock and soil layer to be assimilated is assimilated into an assimilated rock and soil layer corresponding to the rock and soil layer to be assimilated, so as to obtain a normal stratigraphic data set of the target geological area.

3. The method for stratum sequencing according to claim 2, characterized in that: If there are continuous interlaced rock and soil layers in the stratum corresponding to the stratum set data, determining the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers, and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated, including: If there are continuous interlaced rock and soil layers in the stratum corresponding to the stratum set data, the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated are determined according to the thickness of the rock and soil layers.

4. The method for stratum sequencing according to claim 2, characterized in that: If there are continuous interlaced rock and soil layers in the stratum corresponding to the stratum set data, determining the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers, and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated, including: If there are continuous interlaced rock and soil layers in the stratum corresponding to the stratum set data, the rock and soil layers to be assimilated in the continuous interlaced rock and soil layers and the assimilated rock and soil layers corresponding to the rock and soil layers to be assimilated are determined according to the distribution area of ​​the rock and soil layers.

5. The stratum sequencing method according to claim 1, characterized in that: The step of removing the secondary rock and soil layers in the normal stratigraphic dataset of the target geological area according to the normal stratigraphic dataset of the target geological area to obtain the sorted stratigraphic dataset of the target geological area includes: Determine the target rock and soil layers included in the target geological area according to the normal stratigraphic data set of the target geological area; the target rock and soil layers are two rock and soil layers that appear simultaneously in two or more stratigraphic data sets, and the positions of the two rock and soil layers in different stratigraphic data sets are interlaced in sequence; Comparing the occurrence frequencies of two rock and soil layers in the target rock and soil layer, the rock and soil layer with a lower occurrence frequency is a secondary rock and soil layer, removing the secondary rock and soil layer, and obtaining a sorted stratigraphic data set of the target geological area; If the occurrence frequencies of two rock and soil layers in the target rock and soil layers are the same, the thicknesses of the two rock and soil layers in the target rock and soil layers are compared, and the rock and soil layer with smaller thickness is the secondary rock and soil layer; the secondary rock and soil layer is removed to obtain the sorted stratigraphic data set of the target geological area.

6. The method for stratum sequencing according to claim 1, characterized in that: The step of obtaining the rock and soil layer sorting result of the target geological area according to the sorted stratigraphic data set of the target geological area comprises: According to the sorted stratigraphic data set of the target geological area, the position of the rock and soil layers of the target geological area is determined, and the sorting result of the rock and soil layers of the target geological area is obtained.

7. A stratum sorting device, characterized in that: include: An acquisition module, used for acquiring a stratigraphic data set of a target geological area, wherein the stratigraphic data set includes a plurality of stratigraphic data sets, each of which includes at least one rock and soil layer and data of each rock and soil layer; A sorting module, used to sort the rock and soil layers of the target geological area according to the stratigraphic data set of the target geological area, and obtain a sorting result of the rock and soil layers of the target geological area; Wherein, in the process of sorting the rock and soil layers of the target geological area according to the stratigraphic data set of the target geological area to obtain the sorting result of the rock and soil layers of the target geological area, the sorting module is specifically used for: According to the stratigraphic data set of the target geological area, sequential anomaly detection and streamlining processing are performed on the rock and soil layers of the target geological area to obtain a normal stratigraphic data set of the target geological area; According to the normal stratigraphic data set of the target geological area, the secondary rock and soil layers in the normal stratigraphic data set of the target geological area are removed to obtain the sorted stratigraphic data set of the target geological area; According to the sorted stratigraphic data set of the target geological area, a rock and soil layer sorting result of the target geological area is obtained.

8. A computer device, characterized in that: The method comprises a memory, a processor and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the stratigraphic sorting method as claimed in any one of claims 1 to 6 when executing the computer program.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer program instructions, and when the computer program instructions are read and executed by a processor, the steps of the stratigraphic sequencing method according to any one of claims 1 to 6 are executed.

Images