A method, device, equipment and medium for generating a drilling column chart

Abstract

The present invention provides a method, device, equipment and medium for generating a drilling histogram, and relates to the field of data processing technology. The method sends a first preset instruction to BIMBase to obtain a target drilling data list set corresponding to a target survey stage, and after obtaining the target drilling data list set, sends a second preset instruction to BIMBase to generate a drilling histogram corresponding to the target drilling. It can be seen that the present invention generates a drilling histogram based on BIMBase, and does not require manual drawing or entering drilling data into multiple platforms to obtain the drilling histogram, which is conducive to improving the efficiency and accuracy of generating a drilling histogram.

Description

Technical Field

[0001] The present invention relates to the technical field of data processing, and in particular to a method, device, equipment and medium for generating a drilling histogram. Background Art

[0002] In recent years, Building Information Modeling (BIM) technology has been increasingly used in the geological survey industry. Among them, BIMBase is a BIM platform and software that realizes independent research and development of key core technologies and is safe and controllable. Geological-related calculations and modeling can also gradually be realized on BIMBase.

[0003] During geological surveys and engineering construction, borehole histograms provide an intuitive view of the underground rock structure, and can show in detail the distribution of each underground stratum, lithological characteristics, hole depth and other information, which helps geologists understand the composition, age and evolution of the stratum, and is crucial for assessing geological stability, finding groundwater or mineral resources, and planning construction projects. In the existing technology, the generation of borehole histograms mainly relies on manual drawing methods and cross-platform data entry methods. The manual drawing method requires geological engineers to manually draw charts based on drilling records, and the cross-platform data entry method requires drilling data to be entered into multiple platforms and charted. Common platforms include CAD, GIS systems, etc.

[0004] However, the above method also has the following technical problems:

[0005] The above two methods do not use BIMBase to generate drilling histograms, and manual drawing of drilling histograms is inefficient and labor-intensive. The presentation effect of the drilling histogram will also be affected by the work experience of the draftsman, which is prone to errors and uneven drawing quality. The cross-platform data entry method is cumbersome and requires frequent conversion of data formats. The workflow is complicated and the data compatibility of different data platforms is poor, which is prone to data loss and data errors. Therefore, the efficiency of generating drilling histograms using the above methods is low, and the accuracy of the generated drilling histograms is low. Summary of the invention

[0006] In view of the above technical problems, the technical solution adopted by the present invention is:

[0007] According to a first aspect of the present invention, a method for generating a drilling histogram is provided, the method comprising the following steps:

[0008] A first preset instruction is sent to BIMBase to obtain a target drilling data list set corresponding to the target survey stage, wherein when BIMBase receives the first preset instruction, the target drilling data list set is obtained from the target database, the target drilling data set includes a target drilling data list corresponding to several target drillings, the data in the target drilling data list includes the hole depth corresponding to the target drilling, and the target drilling is the drilling in the target survey stage.

[0009] After obtaining the target drilling data list set, a second preset instruction is sent to BIMBase to generate a drilling histogram corresponding to the target drilling. When BIMBase receives the second preset instruction, the following steps are performed:

[0010] Based on the joint query method and the target borehole data list corresponding to the target borehole, a bar chart information list set corresponding to the target borehole is obtained from the target database. The bar chart information list set includes a stratigraphic information list of each stratigraphic layer corresponding to the target borehole. The data in the stratigraphic information list includes layer depth.

[0011] The number of target frames corresponding to the target drilling hole is determined according to the hole depth corresponding to the target drilling hole, the preset scale and the preset frame inner frame height, wherein the number of target frames is a value obtained by rounding up the quotient obtained by multiplying the hole depth corresponding to the target drilling hole and the scale divided by twice the preset frame inner frame height.

[0012] The target frame number of the stratum corresponding to the stratum information list is obtained according to the stratum depth, preset scale and preset inner frame height in the stratum information list, wherein the target frame number is a value obtained by rounding up the quotient obtained by dividing the product of the stratum depth and the scale by the preset inner frame height.

[0013] The position of the stratum information list in the target frame is determined according to the layer depth in the stratum information list, the preset scale and the target frame number of the stratum corresponding to the stratum information list.

[0014] An initial histogram corresponding to the target borehole is generated based on the target borehole data list, the preset frame size, the number of target frames corresponding to the target borehole, and the target frame number of the stratum corresponding to the target borehole.

[0015] Each data item in the stratigraphic information list corresponding to the target borehole is processed according to its corresponding preset processing method and the obtained data is filled into the position of the stratigraphic information list in the target frame to generate a borehole column chart corresponding to the target borehole.

[0016] According to a second aspect of the present invention, there is provided a device for generating a drilling histogram, the device comprising:

[0017] The target drilling data list set acquisition module is used to send a first preset instruction to BIMBase to obtain a target drilling data list set corresponding to a target survey stage, wherein when BIMBase receives the first preset instruction, the target drilling data list set is obtained from a target database, the target drilling data set includes a target drilling data list corresponding to a number of target drillings, the data in the target drilling data list includes a hole depth corresponding to the target drilling, and the target drilling is a drilling in the target survey stage.

[0018] The drilling histogram acquisition module is used to send a second preset instruction to BIMBase to generate a drilling histogram corresponding to the target drilling after acquiring the target drilling data list set. When BIMBase receives the second preset instruction, the following steps are executed:

[0019] Based on the joint query method and the target borehole data list corresponding to the target borehole, a bar chart information list set corresponding to the target borehole is obtained from the target database. The bar chart information list set includes a stratigraphic information list of each stratigraphic layer corresponding to the target borehole. The data in the stratigraphic information list includes layer depth.

[0020] The number of target frames corresponding to the target drilling hole is determined according to the hole depth corresponding to the target drilling hole, the preset scale and the preset frame inner frame height, wherein the number of target frames is a value obtained by rounding up the quotient obtained by multiplying the hole depth corresponding to the target drilling hole and the scale divided by twice the preset frame inner frame height.

[0021] The target frame number of the stratum corresponding to the stratum information list is obtained according to the stratum depth, preset scale and preset inner frame height in the stratum information list, wherein the target frame number is a value obtained by rounding up the quotient obtained by dividing the product of the stratum depth and the scale by the preset inner frame height.

[0022] The position of the stratum information list in the target frame is determined according to the layer depth in the stratum information list, the preset scale and the target frame number of the target frame of the stratum corresponding to the stratum information list.

[0023] An initial histogram corresponding to the target borehole is generated based on the target borehole data list, the preset frame size, the number of target frames corresponding to the target borehole, and the target frame number of the target frame of the stratum corresponding to the target borehole.

[0024] Each data item in the stratigraphic information list corresponding to the target borehole is processed according to its corresponding preset processing method and the obtained data is filled into the position of the stratigraphic information list in the target frame to generate a borehole column chart corresponding to the target borehole.

[0025] According to a third aspect of the present invention, there is provided a non-transitory computer-readable storage medium, in which a computer program is stored. The computer program is loaded and executed by a processor to implement the aforementioned method.

[0026] According to a fourth aspect of the present invention, there is provided an electronic device, comprising: a processor, a memory, and a computer program stored in the memory and executable on the processor, wherein the processor implements the aforementioned method when executing the computer program.

[0027] The present invention has at least the following beneficial effects:

[0028] The present invention provides a method, device, equipment and medium for generating a borehole histogram. The method sends a first preset instruction to BIMBase to obtain a target borehole data list set corresponding to a target survey stage. After obtaining the target borehole data list set, a second preset instruction is sent to BIMBase to generate a borehole histogram corresponding to the target borehole. When BIMBase receives the second preset instruction, a histogram information list set corresponding to the target borehole is obtained from a target database. The histogram information list set includes a stratigraphic information list of each stratigraphic layer corresponding to the target borehole. The number of target frames corresponding to the target borehole is determined according to the hole depth, preset scale and preset inner frame height corresponding to the target borehole. The target depth of the stratigraphic layer corresponding to the stratigraphic layer information list is obtained according to the layer depth, preset scale and preset inner frame height in the stratigraphic layer information list. The frame number is used to determine the position of the stratum information list in the target frame according to the layer depth in the stratum information list, the preset scale and the target frame number of the stratum corresponding to the stratum information list. An initial bar graph corresponding to the target borehole is generated based on the target drilling data list, the preset frame size, the number of target frames corresponding to the target borehole and the target frame number of the stratum corresponding to the target borehole. Each data item in the stratum information list of the stratum corresponding to the target borehole is processed according to its corresponding preset processing method and the data obtained is filled into the position of the stratum information list in the target frame to generate a drilling bar graph corresponding to the target borehole. It can be seen that the present invention generates a drilling bar graph based on BIMBase, and there is no need for manual drawing or entering drilling data into multiple platforms to obtain the drilling bar graph, which is conducive to improving the efficiency and accuracy of generating drilling bar graphs. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0030] Figure 1A flowchart of a method for generating a drilling histogram provided in Embodiment 1 of the present invention;

[0031] Figure 2 A schematic structural diagram of a device for generating a drilling histogram provided in Embodiment 2 of the present invention. DETAILED DESCRIPTION

[0032] 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 those skilled in the art without creative work are within the scope of protection of the present invention.

[0033] It should be noted that the terms "first", "second", etc. in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar tasks, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product, or server that includes a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products, or devices.

[0034] Embodiment 1,

[0035] Embodiment 1 of the present invention provides a method for generating a drilling histogram, the method comprising the following steps: Figure 1 As shown:

[0036] S1. Send a first preset instruction to BIMBase to obtain a target drilling data list set corresponding to a target survey stage, wherein the target survey stage is a survey stage predetermined by a user. When BIMBase receives the first preset instruction, it obtains the target drilling data list set from a target database. The target drilling data set includes a target drilling data list corresponding to several target drillings. The data in the target drilling data list includes the drilling number of the target drilling, the mileage pile number corresponding to the target drilling, and the hole depth corresponding to the target drilling. The target drilling is a drilling under the target survey stage, such as Table 1.

[0037] Table 1:

[0038]

[0039] Specifically, the first preset instruction is an instruction for obtaining a target drilling data list set corresponding to the target exploration stage.

[0040] Specifically, before step S1, the following steps are also included to obtain the target database:

[0041] S10. Input all data related to the geological body core sample obtained by the user through layered analysis of the geological body core sample into the initial database corresponding to BIMBase and send a first intermediate instruction to BIMBase to obtain a geological drilling data table, wherein the geological body core sample is a core sample obtained by the user through exploration and coring of the geological body using exploration equipment.

[0042] Specifically, the initial database corresponding to BIMBase is initially NULL.

[0043] Specifically, the initial database corresponding to BIMBase is a relational database.

[0044] Specifically, the first intermediate instruction is an instruction for generating a geological drilling data table.

[0045] Specifically, each row of data in the geological drilling data table corresponds to a borehole, including: work site name, borehole number, mileage pile number, hole depth, hole mouth elevation, drilling coordinate x, drilling coordinate y and hole opening date. The work site name indicates the working point where the borehole is located, and the mileage pile number indicates the specific pile number of the borehole in the highway route.

[0046] S20, analyzing the borehole segments corresponding to each row of data in the geological drilling data table to obtain all data related to the borehole segments into the initial database corresponding to BIMBase, and sending a second intermediate instruction to BIMBase to obtain a drilling stratum information table.

[0047] Specifically, the second intermediate instruction is an instruction for generating a drilling formation information table.

[0048] Specifically, each row of data in the borehole stratigraphic information table corresponds to a borehole, including: borehole number, stratigraphic number, stratigraphic name, age and origin, layer bottom depth, bearing capacity characteristic value, side friction resistance standard value, rock and soil sampling information and core sampling rate, wherein the stratigraphic name and layer bottom depth represent the stratigraphic distribution within the depth range corresponding to the layer depth, and the stratigraphic distribution includes the color information, state information, humidity information and composition information of the stratigraphic layer. For example, if the stratigraphic name is topsoil layer and the stratigraphic depth is 2 meters, then the composition information of the soil layer from the ground to 2 meters deep is: composed of organic matter and sandy soil, the color information is brown, the state information is loose, and the humidity information is high humidity.

[0049] Furthermore, the characteristic value of bearing capacity indicates the maximum pressure value that the stratum can withstand, and the standard value of side friction resistance indicates the friction resistance between the stratum and the surrounding area of ​​the pile.

[0050] Furthermore, the core recovery rate indicates the percentage of the length of the core recovered from a section of the borehole to the actual footage of the section. For example, if a 9-meter-long core is recovered from a section of the borehole with a depth of 90 to 100 meters, the core recovery rate is 90%.

[0051] Furthermore, the rock and soil sampling information is the information obtained by statistically analyzing the sample information taken from the current stratum, which includes the sampling type, sampling number, and sampling depth. There are currently four sampling types: original sample, disturbed sample, point load sample, and rock sample. For example, if the current stratum type is soil layer, then after a sampling test on the stratum at a depth of 2 meters, the statistical information is: original sample, sampling depth of 2 meters, sampling number 1, then the rock and soil sampling information is: original sample, sampling depth of 2 meters, sampling number 1.

[0052] Specifically, the boreholes corresponding to two different rows of data in the borehole formation information table may be the same borehole.

[0053] S30. Input the drawing information and the preset stratigraphic lithology pattern style mapping table into the initial database corresponding to BIMBase, wherein the drawing information includes the project name, survey stage, survey unit, preparer, reviewer and auditor, and the preset stratigraphic lithology pattern style mapping table includes several rows of data, each row of data includes a stratigraphic name, a legend number corresponding to the stratigraphic name and a legend style corresponding to the legend number. Those skilled in the art know that each row of data in the preset stratigraphic lithology pattern style mapping table is pre-set by those skilled in the art according to actual needs and will not be elaborated here.

[0054] S40, taking an initial database storing a geological drilling data table, a drilling stratum information table, map output information and a preset stratum lithology pattern mapping table as a target database.

[0055] Through the above steps, all data related to the geological body core sample obtained by the user through layered analysis of the geological body core sample is input into the initial database corresponding to BIMBase, and a first intermediate instruction is sent to BIMBase to obtain a geological drilling data table, and all data related to the hole section obtained by analyzing the hole section corresponding to each row of data in the geological drilling data table is input into the initial database corresponding to BIMBase, and a second intermediate instruction is sent to BIMBase to obtain a drilling stratum information table, and the output information and the preset stratum lithology pattern style mapping table are input into the initial database corresponding to BIMBase. The initial database storing geological drilling data tables, drilling stratum information tables, drawing information and preset stratum lithology pattern style mapping tables is used as the target database, and a drilling column chart is generated based on the target database. BIMBase automatically processes data and generates drilling column charts, which greatly reduces the time and workload of manual operations and the errors caused by manual operations. Data entry and processing are completed in BIMBase, avoiding data loss and error risks caused by cross-platform operations, improving the quality and reliability of drawings, and helping to improve the overall drawing efficiency. Users can generate and modify drawings anytime, anywhere, which is convenient and fast.

[0056] S2. After obtaining the target drilling data list set, a second preset instruction is sent to BIMBase to generate a drilling histogram corresponding to the target drilling, wherein the second preset instruction is an instruction for generating a drilling histogram. When BIMBase receives the second preset instruction, the following steps are executed:

[0057] S21. Based on the joint query method and the target borehole data list corresponding to the target borehole, a bar chart information list set corresponding to the target borehole is obtained from the target database. The bar chart information list set includes a stratigraphic information list of each stratum corresponding to the target borehole. The data in the stratigraphic information list include stratigraphic number, age and origin, layer bottom depth, stratification depth, lithological pattern name, core sampling rate, stratigraphic name, stratigraphic description, rock sampling depth, in-situ test, bearing capacity characteristic value, side friction resistance standard value and rock and soil sampling information.

[0058] S22. Determine the number of target frames corresponding to the target drilling hole according to the hole depth corresponding to the target drilling hole, the preset scale and the preset inner frame height of the frame, wherein the number of target frames is a value obtained by rounding up the quotient obtained by multiplying the hole depth corresponding to the target drilling hole and the scale divided by twice the preset inner frame height of the frame, wherein the preset inner frame height of the frame is the height of the inner frame of the frame corresponding to the A3 drawing. Those skilled in the art know that the preset scale is a scale set by those skilled in the art according to actual needs, which will not be described in detail herein.

[0059] Specifically, the unit of measurement of the hole depth corresponding to the target drilling hole is meter.

[0060] S23. Obtain a target frame number of a stratum corresponding to the stratum information list according to the stratum depth, preset scale and preset inner frame height in the stratum information list, wherein the target frame number is a value obtained by rounding up the quotient obtained by multiplying the stratum depth and the scale by the preset inner frame height, and the target frame number can be understood as the order of a single target frame among several target frames. For example, if the target frame number corresponding to a stratum is 5, then the target frame corresponding to the stratum is ranked 5 among several target frames, that is, the target frame corresponding to the stratum is the 5th target frame.

[0061] Specifically, the unit of measurement for layer depth is meter.

[0062] S24. Determine the position of the stratigraphic information list in the target frame according to the stratum depth in the stratigraphic information list, the preset scale and the target frame number of the stratum corresponding to the stratigraphic information list, wherein the position of the stratigraphic information list in the stratum is a value obtained by multiplying the stratum depth in the stratigraphic information list and the scale divided by the difference between the target frame number of the target frame corresponding to the stratum corresponding to the stratigraphic information list and 1.

[0063] S25. Generate an initial bar chart corresponding to the target drilling hole based on the target drilling hole data list, the preset frame size, the number of target frames corresponding to the target drilling hole, and the target frame number of the stratum corresponding to the target drilling hole, wherein the preset frame size is the frame size input by the user, including a preset frame outer frame size and a preset frame inner frame size, the preset frame outer frame size is the size of the outer frame of the frame corresponding to the A3 drawing, and the preset frame inner frame size is the size of the inner frame of the frame corresponding to the A3 drawing.

[0064] S26, filling the position of the stratigraphic information list in the target frame with the data obtained after processing each item of data in the stratigraphic information list corresponding to the target borehole according to its corresponding preset processing method to generate a borehole bar graph corresponding to the target borehole.

[0065] Specifically, the preset processing method corresponding to the stratum number in the stratum information list includes the following steps:

[0066] Step 1: Parse the character string representing the stratigraphic number to obtain the parsed number corresponding to the stratigraphic number, the parsed number including the main layer number, the sublayer number and the sub-sublayer number, wherein the main layer number and the sublayer number are connected with preset characters, and the sublayer number and the sub-sublayer number are connected with preset characters.

[0067] Specifically, the default character is "-".

[0068] Specifically, the connection order of the main layer number, sub-layer number and sub-sub-layer number is: main layer number first, sub-layer number in the middle, sub-sub-layer number at the end; for example: the parsed number is FM1-MB2-LB3, where the main layer number is FM1, the sub-layer number is MB2, and the sub-sub-layer number is LB3.

[0069] Step 2: If the analysis number corresponding to the stratum and the main layer number, sublayer number, and sub-sublayer number in the analysis numbers corresponding to other strata adjacent to the stratum are all the same, the stratum number will not be filled in the drill column chart corresponding to the stratum; otherwise, the stratum number will be filled in the drill column chart corresponding to the stratum.

[0070] Furthermore, when generating a borehole histogram corresponding to a target borehole, if the stratum depth is greater than a preset inner frame height, the stratum number corresponding to the stratum is filled in each borehole histogram where a stratum corresponding to the stratum depth appears.

[0071] Specifically, the preset processing method corresponding to the age cause in the stratigraphic information list is:

[0072] Parse the string representing the era and cause and split it into two parts: era and cause, with the era as the main text and the cause as the superscript.

[0073] Furthermore, when generating a borehole column chart corresponding to a target borehole, if the stratum depth is greater than a preset inner frame height, the age and genesis corresponding to the stratum are filled in each borehole column chart where a stratum corresponding to the stratum depth appears.

[0074] Specifically, the preset processing method corresponding to the core sampling rate in the formation information list is:

[0075] The core recovery rate is converted from numbers to graphs so that the core recovery rate is constructed into a line segment, where the core recovery rate is the average value within a certain formation range, and the values ​​at the endpoints are taken according to the bottom values ​​of the previous segment. For example: if the core recovery rate of 0-4 meters is 60%, and the core recovery rate of 4-10 meters is 65%, then the core recovery rate at 4 meters is calculated as 60%.

[0076] Specifically, the preset processing method corresponding to the lithology pattern name in the stratum information list is:

[0077] The length of the character string representing the lithology pattern name is counted and the number of rows required for filling is calculated. If the required number of rows is greater than the layer row height corresponding to the stratum corresponding to the stratum in the stratum information list, the height of the layer is adjusted to accommodate the lithology pattern name.

[0078] Through the above steps, when generating a borehole column chart, the outer frame and inner frame of the drawing frame can be automatically drawn, and the column headers and column names can be filled in according to the content to ensure the integrity and accuracy of the information display. A unified A3 format is used to comply with industry standards, ensuring the standardization and consistency of the drawings. In the process of dividing the sections, no matter how many sections are divided, it is ensured that the lithology, bearing capacity characteristic value and friction resistance standard value are marked in each section to ensure the integrity and accuracy of the drawing information. The generated borehole column chart has clear markings and layered information, which is convenient for engineers and technicians to read and understand. The interactive interface provided by BIMBase is simple and intuitive, and users can easily query and edit drilling information, which improves the convenience of operation and user experience. BIMBase also supports the entry and display of a variety of geological information, including core sampling rate, rock and soil sample testing, in-situ testing, etc., which can meet different projects and needs.

[0079] Embodiment 2:

[0080] A second embodiment of the present invention provides a device for generating a drilling histogram, such as Figure 2 As shown, the device comprises:

[0081] The target drilling data list set acquisition module 1 is used to send a first preset instruction to BIMBase to obtain a target drilling data list set corresponding to a target survey stage, wherein the target survey stage is a survey stage predetermined by a user. When BIMBase receives the first preset instruction, it obtains the target drilling data list set from a target database. The target drilling data set includes a target drilling data list corresponding to several target drillings. The data in the target drilling data list includes the drilling number of the target drilling hole, the mileage pile number corresponding to the target drilling hole, and the hole depth corresponding to the target drilling hole. The target drilling hole is a drilling hole under the target survey stage.

[0082] Specifically, the first preset instruction is an instruction for obtaining a target drilling data list set corresponding to the target exploration stage.

[0083] Specifically, the device also includes a target database acquisition module, which is used to acquire the target database before sending a first preset instruction to BIMBase to acquire a target drilling data list set corresponding to the target survey stage.

[0084] Furthermore, the target database acquisition module includes:

[0085] The geological drilling data table acquisition unit is used to input all data related to the geological body core sample obtained by the user through layered analysis of the geological body core sample into the initial database corresponding to BIMBase and send a first intermediate instruction to BIMBase to obtain the geological drilling data table, wherein the geological body core sample is a core sample obtained by the user through exploration and coring of the geological body using exploration equipment.

[0086] Specifically, the initial database corresponding to BIMBase is initially NULL.

[0087] Specifically, the initial database corresponding to BIMBase is a relational database.

[0088] Specifically, the first intermediate instruction is an instruction for generating a geological drilling data table.

[0089] Specifically, each row of data in the geological drilling data table corresponds to a borehole, including: work site name, borehole number, mileage pile number, hole depth, hole mouth elevation, drilling coordinate x, drilling coordinate y and hole opening date. The work site name indicates the working point where the borehole is located, and the mileage pile number indicates the specific pile number of the borehole in the highway route.

[0090] The drilling stratigraphic information table acquisition unit is used to input all data related to the hole segment obtained by analyzing the hole segment included in the drilling corresponding to each row of data in the geological drilling data table into the initial database corresponding to BIMBase and send a second intermediate instruction to BIMBase to obtain the drilling stratigraphic information table.

[0091] Specifically, the second intermediate instruction is an instruction for generating a drilling formation information table.

[0092] Specifically, each row of data in the borehole stratigraphic information table corresponds to a borehole, including: borehole number, stratigraphic number, stratigraphic name, age and origin, layer bottom depth, bearing capacity characteristic value, side friction resistance standard value, rock and soil sampling information and core sampling rate, wherein the stratigraphic name and layer bottom depth represent the stratigraphic distribution within the depth range corresponding to the layer depth, and the stratigraphic distribution includes the color information, state information, humidity information and composition information of the stratigraphic layer. For example, if the stratigraphic name is topsoil layer and the stratigraphic depth is 2 meters, then the composition information of the soil layer from the ground to 2 meters deep is: composed of organic matter and sandy soil, the color information is brown, the state information is loose, and the humidity information is high humidity.

[0093] Furthermore, the characteristic value of bearing capacity indicates the maximum pressure value that the stratum can withstand, and the standard value of side friction resistance indicates the friction resistance between the stratum and the surrounding area of ​​the pile.

[0094] Furthermore, the core recovery rate indicates the percentage of the length of the core recovered from a section of the borehole to the actual footage of the section. For example, if a 9-meter-long core is recovered from a section of the borehole with a depth of 90 to 100 meters, the core recovery rate is 90%.

[0095] Furthermore, the rock and soil sampling information is the information obtained by statistically analyzing the sample information taken from the current stratum, which includes the sampling type, sampling number, and sampling depth. There are currently four sampling types: original sample, disturbed sample, point load sample, and rock sample. For example, if the current stratum type is soil layer, then after a sampling test on the stratum at a depth of 2 meters, the statistical information is: original sample, sampling depth of 2 meters, sampling number 1, then the rock and soil sampling information is: original sample, sampling depth of 2 meters, sampling number 1.

[0096] Specifically, the boreholes corresponding to two different rows of data in the borehole formation information table may be the same borehole.

[0097] A data input unit is used to input drawing information and a preset stratigraphic lithology pattern style mapping table into an initial database corresponding to BIMBase, wherein the drawing information includes the project name, survey stage, survey unit, preparer, reviewer and auditor, and the preset stratigraphic lithology pattern style mapping table includes several rows of data, each row of data includes a stratigraphic name, a legend number corresponding to the stratigraphic name and a legend style corresponding to the legend number. Those skilled in the art know that each row of data in the preset stratigraphic lithology pattern style mapping table is pre-set by those skilled in the art according to actual needs and will not be elaborated here.

[0098] The target database acquisition unit is used to use the initial database storing the geological drilling data table, the drilling stratum information table, the map output information and the preset stratum lithology pattern style mapping table as the target database.

[0099] The drilling histogram acquisition module 2 is used to send a second preset instruction to BIMBase to generate a drilling histogram corresponding to the target drilling after acquiring the target drilling data list set, wherein the second preset instruction is an instruction to generate a drilling histogram. When BIMBase receives the second preset instruction, it executes the following steps:

[0100] S21. Based on the joint query method and the target borehole data list corresponding to the target borehole, a bar chart information list set corresponding to the target borehole is obtained from the target database. The bar chart information list set includes a stratigraphic information list of each stratum corresponding to the target borehole. The data in the stratigraphic information list include stratigraphic number, age and origin, layer bottom depth, stratification depth, lithological pattern name, core sampling rate, stratigraphic name, stratigraphic description, rock sampling depth, in-situ test, bearing capacity characteristic value, side friction resistance standard value and rock and soil sampling information.

[0101] S22. Determine the number of target frames corresponding to the target drilling hole according to the hole depth corresponding to the target drilling hole, the preset scale and the preset inner frame height of the frame, wherein the number of target frames is a value obtained by rounding up the quotient obtained by multiplying the hole depth corresponding to the target drilling hole and the scale divided by twice the preset inner frame height of the frame, wherein the preset inner frame height of the frame is the height of the inner frame of the frame corresponding to the A3 drawing. Those skilled in the art know that the preset scale is a scale set by those skilled in the art according to actual needs, which will not be described in detail herein.

[0102] Specifically, the unit of measurement of the hole depth corresponding to the target drilling hole is meter.

[0103] S23. Obtain a target frame number of a stratum corresponding to the stratum information list according to the stratum depth, preset scale and preset inner frame height in the stratum information list, wherein the target frame number is a value obtained by rounding up the quotient obtained by multiplying the stratum depth and the scale by the preset inner frame height, and the target frame number can be understood as the order of a single target frame among several target frames. For example, if the target frame number corresponding to a stratum is 5, then the target frame corresponding to the stratum is ranked 5 among several target frames, that is, the target frame corresponding to the stratum is the 5th target frame.

[0104] Specifically, the unit of measurement for layer depth is meter.

[0105] S24. Determine the position of the stratigraphic information list in the target frame according to the stratum depth in the stratigraphic information list, the preset scale and the target frame number of the stratum corresponding to the stratigraphic information list, wherein the position of the stratigraphic information list in the stratum is a value obtained by multiplying the stratum depth in the stratigraphic information list and the scale divided by the difference between the target frame number of the target frame corresponding to the stratum corresponding to the stratigraphic information list and 1.

[0106] S25. Generate an initial bar chart corresponding to the target drilling hole based on the target drilling hole data list, the preset frame size, the number of target frames corresponding to the target drilling hole, and the target frame number of the stratum corresponding to the target drilling hole, wherein the preset frame size is the frame size input by the user, including a preset frame outer frame size and a preset frame inner frame size, the preset frame outer frame size is the size of the outer frame of the frame corresponding to the A3 drawing, and the preset frame inner frame size is the size of the inner frame of the frame corresponding to the A3 drawing.

[0107] S26, filling the position of the stratigraphic information list in the target frame with the data obtained after processing each item of data in the stratigraphic information list corresponding to the stratigraphic layer of the target borehole according to its corresponding preset processing method to generate a borehole bar graph corresponding to the target borehole.

[0108] Specifically, the preset processing method corresponding to the stratum number in the stratum information list includes the following steps:

[0109] Step 1: Parse the character string representing the stratigraphic number to obtain the parsed number corresponding to the stratigraphic number, the parsed number including the main layer number, the sublayer number and the sub-sublayer number, wherein the main layer number and the sublayer number are connected with preset characters, and the sublayer number and the sub-sublayer number are connected with preset characters.

[0110] Specifically, the default character is "-".

[0111] Specifically, the connection order of the main layer number, sub-layer number and sub-sub-layer number is: main layer number first, sub-layer number in the middle, sub-sub-layer number at the end; for example: the parsed number is FM1-MB2-LB3, where the main layer number is FM1, the sub-layer number is MB2, and the sub-sub-layer number is LB3.

[0112] Step 2: If the analysis number corresponding to the stratum and the main layer number, sublayer number, and sub-sublayer number in the analysis numbers corresponding to other strata adjacent to the stratum are all the same, the stratum number will not be filled in the drill column chart corresponding to the stratum; otherwise, the stratum number will be filled in the drill column chart corresponding to the stratum.

[0113] Furthermore, when generating a borehole histogram corresponding to a target borehole, if the stratum depth is greater than a preset inner frame height, the stratum number corresponding to the stratum is filled in each borehole histogram where a stratum corresponding to the stratum depth appears.

[0114] Specifically, the preset processing method corresponding to the age cause in the stratigraphic information list is:

[0115] Parse the string representing the era and cause and split it into two parts: era and cause, with the era as the main text and the cause as the superscript.

[0116] Furthermore, when generating a borehole column chart corresponding to a target borehole, if the stratum depth is greater than a preset inner frame height, the age and genesis corresponding to the stratum are filled in each borehole column chart where a stratum corresponding to the stratum depth appears.

[0117] Specifically, the preset processing method corresponding to the core sampling rate in the formation information list is:

[0118] The core recovery rate is converted from numbers to graphs so that the core recovery rate is constructed into a line segment, where the core recovery rate is the average value within a certain formation range, and the values ​​at the endpoints are taken according to the bottom values ​​of the previous segment. For example: if the core recovery rate of 0-4 meters is 60%, and the core recovery rate of 4-10 meters is 65%, then the core recovery rate at 4 meters is calculated as 60%.

[0119] Specifically, the preset processing method corresponding to the lithology pattern name in the stratum information list is:

[0120] The length of the character string representing the lithology pattern name is counted and the number of rows required for filling is calculated. If the required number of rows is greater than the layer row height corresponding to the stratum corresponding to the stratum in the stratum information list, the height of the layer is adjusted to accommodate the lithology pattern name.

[0121] An embodiment of the present invention also provides a non-transitory computer-readable storage medium, which can be set in an electronic device to store a computer program related to a method in a method embodiment, and the computer program is loaded and executed by the processor to implement the method provided in the above embodiment.

[0122] An embodiment of the present invention further provides an electronic device, comprising: a processor, a memory, and a computer program stored in the memory and executable on the processor, wherein the processor implements the method provided in the above embodiment when executing the computer program.

[0123] An embodiment of the present invention further provides a computer program product, which includes program code. When the program product is run on an electronic device, the program code is used to enable the electronic device to execute the steps of the method according to various exemplary embodiments of the present invention described above in this specification.

[0124] The present invention provides a method, device, equipment and medium for generating a borehole histogram. The method sends a first preset instruction to BIMBase to obtain a target borehole data list set corresponding to a target survey stage. After obtaining the target borehole data list set, a second preset instruction is sent to BIMBase to generate a borehole histogram corresponding to the target borehole. When BIMBase receives the second preset instruction, a histogram information list set corresponding to the target borehole is obtained from a target database. The histogram information list set includes a stratigraphic information list of each stratigraphic layer corresponding to the target borehole. The number of target frames corresponding to the target borehole is determined according to the hole depth, preset scale and preset inner frame height corresponding to the target borehole. The target depth of the stratigraphic layer corresponding to the stratigraphic layer information list is obtained according to the layer depth, preset scale and preset inner frame height in the stratigraphic layer information list. The frame number is used to determine the position of the stratum information list in the target frame according to the layer depth in the stratum information list, the preset scale and the target frame number of the stratum corresponding to the stratum information list. An initial bar graph corresponding to the target borehole is generated based on the target drilling data list, the preset frame size, the number of target frames corresponding to the target borehole and the target frame number of the stratum corresponding to the target borehole. Each data item in the stratum information list of the stratum corresponding to the target borehole is processed according to its corresponding preset processing method and the data obtained is filled into the position of the stratum information list in the target frame to generate a drilling bar graph corresponding to the target borehole. It can be seen that the present invention generates a drilling bar graph based on BIMBase, and there is no need for manual drawing or entering drilling data into multiple platforms to obtain the drilling bar graph, which is conducive to improving the efficiency and accuracy of generating drilling bar graphs.

[0125] Although some specific embodiments of the present invention have been described in detail by way of example, it should be understood by those skilled in the art that the above examples are only for illustration, not for limiting the scope of the present invention. It should also be understood by those skilled in the art that various modifications may be made to the embodiments without departing from the scope and spirit of the present invention.

Claims

1. A method for generating a drilling histogram, characterized in that: The method comprises the following steps: Sending a first preset instruction to BIMBase to obtain a target drilling data list set corresponding to the target survey stage, wherein when BIMBase receives the first preset instruction, the target drilling data list set is obtained from the target database, the target drilling data set includes a target drilling data list corresponding to a plurality of target drillings, the data in the target drilling data list includes a hole depth corresponding to the target drilling, and the target drilling is a drilling in the target survey stage; After obtaining the target drilling data list set, a second preset instruction is sent to BIMBase to generate a drilling histogram corresponding to the target drilling. When BIMBase receives the second preset instruction, the following steps are performed: Based on the joint query method and the target borehole data list corresponding to the target borehole, a column chart information list set corresponding to the target borehole is obtained from the target database, wherein the column chart information list set includes a stratigraphic information list of each stratigraphic layer corresponding to the target borehole, and the data in the stratigraphic information list includes a layer depth; Determine the number of target drawing frames corresponding to the target drilling hole according to the hole depth corresponding to the target drilling hole, the preset scale and the preset inner frame height of the drawing frame, wherein the number of target drawing frames is a value obtained by rounding up the quotient obtained by multiplying the hole depth corresponding to the target drilling hole and the scale divided by twice the preset inner frame height of the drawing frame, and the preset inner frame height of the drawing frame is the height of the inner frame of the drawing frame corresponding to the A3 drawing; According to the layer depth, the preset scale and the preset inner frame height in the layer information list, a target frame number of the layer corresponding to the layer information list is obtained, wherein the target frame number is a value obtained by rounding up the quotient obtained by dividing the product of the layer depth and the scale by the preset inner frame height; Determine the position of the stratigraphic information list in the target frame according to the layer depth in the stratigraphic information list, the preset scale and the target frame number of the stratigraphic layer corresponding to the stratigraphic information list; Generate an initial histogram corresponding to the target borehole based on the target borehole data list, the preset frame size, the number of target frames corresponding to the target borehole, and the target frame number of the stratum corresponding to the target borehole; Each item of data in the stratigraphic information list corresponding to the target borehole is processed according to its corresponding preset processing method and the obtained data is filled into the position of the stratigraphic information list in the target frame to generate a borehole column chart corresponding to the target borehole.

2. The method for generating a drilling histogram according to claim 1, characterized in that: The data in the target drilling data list also includes the drilling number of the target drilling hole and the mileage pile number corresponding to the target drilling hole.

3. The method for generating a drilling histogram according to claim 1, characterized in that: The data in the stratigraphic information list also includes stratigraphic number, age and origin, layer bottom depth, lithology pattern name, core sampling rate, stratigraphic name, stratigraphic description, rock sampling depth, in-situ test, bearing capacity characteristic value and lateral friction resistance standard value.

4. The method for generating a drilling histogram according to claim 1, characterized in that: The preset drawing frame size is the drawing frame size input by the user, including the preset drawing frame outer frame size and the preset drawing frame inner frame size. The preset drawing frame outer frame size is the size of the outer frame of the drawing frame corresponding to the A3 drawing, and the preset drawing frame inner frame size is the size of the inner frame of the drawing frame corresponding to the A3 drawing.

5. The method for generating a drilling histogram according to claim 1, characterized in that: Before the step of sending the first preset instruction to BIMBase to obtain the target drilling data list set corresponding to the target survey stage, the following step is also included to obtain the target database: Input all data related to the geological body core sample obtained by the user through layered analysis into the initial database corresponding to BIMBase and send a first intermediate instruction to BIMBase to obtain a geological drilling data table, wherein the geological body core sample is a core sample obtained by the user through exploration and coring of the geological body using exploration equipment, and each row of data in the geological drilling data table corresponds to a borehole, including: work site name, borehole number, mileage pile number, hole depth, hole mouth elevation, drilling coordinate x, drilling coordinate y and hole opening date, the work site name indicates the working point where the borehole is located, and the mileage pile number indicates the specific pile number of the borehole in the highway route; Input all data related to the borehole section obtained by analyzing the borehole section corresponding to each row of data in the geological drilling data table into the initial database corresponding to BIMBase, and send a second intermediate instruction to BIMBase to obtain a drilling stratum information table, wherein each row of data in the drilling stratum information table corresponds to a borehole, including: borehole number, stratum number, stratum name, age and origin, layer bottom depth, bearing capacity characteristic value, side friction resistance standard value, rock and soil sampling information and core sampling rate, wherein the stratum name and layer bottom depth represent the stratum distribution within the depth range corresponding to the layer bottom depth, the stratum distribution includes the color information, state information, humidity information and composition information of the stratum, the bearing capacity characteristic value represents the maximum pressure value that the stratum can withstand, the side friction resistance standard value represents the friction resistance between the stratum and the pile periphery, and the core sampling rate represents the percentage of the core length mined from the hole section in the borehole to the actual footage of the hole section; Input the output information and the preset stratigraphic lithology pattern style mapping table into the initial database corresponding to BIMBase, wherein the output information includes the project name, survey stage, survey unit, compiler, reviewer and auditor, and the preset stratigraphic lithology pattern style mapping table includes several rows of data, each row of data includes a stratigraphic name, a legend number corresponding to the stratigraphic name, and a legend style corresponding to the legend number; The initial database storing the geological drilling data table, the drilling stratum information table, the drawing information and the preset stratum lithology pattern style mapping table is used as the target database.

6. The method for generating a drilling histogram according to claim 5, characterized in that: The initial database corresponding to BIMBase is a relational database and is initially NULL.

7. A device for generating a drilling histogram, characterized in that: The device comprises: A target drilling data list set acquisition module is used to send a first preset instruction to BIMBase to acquire a target drilling data list set corresponding to a target survey stage, wherein when BIMBase receives the first preset instruction, the target drilling data list set is acquired from a target database, the target drilling data set includes a target drilling data list corresponding to a plurality of target drillings, the data in the target drilling data list includes a hole depth corresponding to the target drilling, and the target drilling is a drilling in the target survey stage; The drilling histogram acquisition module is used to send a second preset instruction to BIMBase to generate a drilling histogram corresponding to the target drilling after acquiring the target drilling data list set. When BIMBase receives the second preset instruction, the following steps are executed: Based on the joint query method and the target borehole data list corresponding to the target borehole, a column chart information list set corresponding to the target borehole is obtained from the target database, wherein the column chart information list set includes a stratigraphic information list of each stratigraphic layer corresponding to the target borehole, and the data in the stratigraphic information list includes a layer depth; Determine the number of target drawing frames corresponding to the target drilling hole according to the hole depth corresponding to the target drilling hole, the preset scale and the preset inner frame height of the drawing frame, wherein the number of target drawing frames is a value obtained by rounding up the quotient obtained by multiplying the hole depth corresponding to the target drilling hole and the scale divided by twice the preset inner frame height of the drawing frame, and the preset inner frame height of the drawing frame is the height of the inner frame of the drawing frame corresponding to the A3 drawing; According to the layer depth, the preset scale and the preset inner frame height in the layer information list, a target frame number of the layer corresponding to the layer information list is obtained, wherein the target frame number is a value obtained by rounding up the quotient obtained by dividing the product of the layer depth and the scale by the preset inner frame height; Determine the position of the stratigraphic information list in the target frame according to the layer depth in the stratigraphic information list, the preset scale and the target frame number of the stratigraphic layer corresponding to the stratigraphic information list; Generate an initial histogram corresponding to the target borehole based on the target borehole data list, the preset frame size, the number of target frames corresponding to the target borehole, and the target frame number of the stratum corresponding to the target borehole; Each item of data in the stratigraphic information list corresponding to the target borehole is processed according to its corresponding preset processing method and the obtained data is filled into the position of the stratigraphic information list in the target frame to generate a borehole column chart corresponding to the target borehole.

8. A non-transitory computer-readable storage medium, characterized in that: The storage medium stores a computer program, which is loaded and executed by a processor to implement the method for generating a drilling histogram according to any one of claims 1 to 6.

9. An electronic device, comprising: A processor, a memory, and a computer program stored in the memory and executable on the processor, wherein the processor implements the method for generating a drilling histogram as described in any one of claims 1 to 6 when executing the computer program.

Images