CN116188627A

CN116188627A - Logging curve digitizing method and device

Info

Publication number: CN116188627A
Application number: CN202310457433.9A
Authority: CN
Inventors: 刘鹏奇; 张伟; 毛爽; 辛福兵; 王力峰; 王飞飞; 苏丕波; 鄢伟; 尚久靖; 季春生; 袁胜; 程怀; 张国庆; 吕瑶瑶; 朱作飞; 陆天启
Original assignee: China Petroleum Liaohe Oilfield Economic And Technological Research Institute; Guangzhou Marine Geological Survey Sanya Institute Of South China Sea Geology; Guangzhou Marine Geological Survey
Current assignee: China Petroleum Liaohe Oilfield Economic And Technological Research Institute; Guangzhou Marine Geological Survey Sanya Institute Of South China Sea Geology; Guangzhou Marine Geological Survey
Priority date: 2023-04-26
Filing date: 2023-04-26
Publication date: 2023-05-30
Anticipated expiration: 2043-04-26
Also published as: CN116188627B

Abstract

The invention discloses a log digitizing method and device, the method includes: and reading the color of the pixel point of the corresponding picture of the logging curve, and calculating the logging curve with the corresponding color according to the preset abscissa and ordinate to finally obtain the value of the logging curve. The algorithm is realized through the program, so that the curve digitizing efficiency is greatly improved; the digital accuracy is greatly improved, almost the same as the actual data, and the manual pick-up cost is greatly saved.

Description

Logging curve digitizing method and device

Technical Field

The invention relates to a picture conversion technology, in particular to a log digitizing method and device.

Background

When downloading the literature on the internet, the logging data in the literature are in a picture format and are not actual data, and if calculation is to be performed by using the data, the traditional method is to use a Plot Digitizer to perform points on manual pictures, and finally output the points into data. The method has the defects that the error of manually picked data is large, the time consumption is long, only 100 points can be picked at a time, and the scientific research production requirement cannot be met.

The traditional method for outputting the final data by using the Plot Digitizer to carry out the points on the manual picture mainly comprises the following steps:

1. opening software, importing pictures corresponding to logging curves, and determining three-point coordinates, for example: the first point is the starting depth and the corresponding curve minimum scale value, the second point is the starting depth and the corresponding curve maximum scale value, and the third point is the ending depth and the corresponding curve minimum scale value.

2. If a curve is picked up, clicking on the curve from bottom to top in turn, the software will automatically calculate the corresponding logging data and display it in the left table (see fig. 1), where the Y column corresponds to the depth of the logging curve and the X corresponds to the value of the logging curve.

3. Copying the corresponding values of X and Y.

Three disadvantages of the above conventional curve digitizing method are addressed: (1) manually picking up data points, not accurate enough; (2) Data are exported every 100 data points picked up, then pictures are reloaded, and the operation is complicated; (3) time consuming.

Therefore, how to find an accurate and efficient digitizing method is a technical problem to be solved in the prior art.

Disclosure of Invention

The invention aims to overcome the defects of the prior art and provide a method and a device for digitizing a logging curve so as to improve the digitizing efficiency of the curve.

In order to achieve the above purpose, the technical scheme of the invention is as follows:

in a first aspect, the present invention provides a method of digitizing a log, comprising:

and reading the color of the pixel point of the corresponding picture of the logging curve, and calculating the logging curve with the corresponding color according to the preset abscissa and ordinate to finally obtain the value of the logging curve.

Further, according to the preset abscissa and ordinate, the well logging curve with the corresponding color is calculated, and finally the well logging curve value is obtained, which comprises the following algorithm:

setting the total number of transverse pixels of a picture corresponding to a logging curve to be digitalized as W, the total number of longitudinal pixels as H, the point A in the picture represents a depth minimum value and a pixel corresponding to the logging curve minimum value, the point B represents a depth minimum value and a pixel corresponding to the logging curve maximum value, the point C represents a depth maximum value and a pixel corresponding to the logging curve minimum value, the depth value corresponding to the point A is DA, the depth value corresponding to the logging curve is VA, the depth value corresponding to the point B is DB, the depth value corresponding to the logging curve is VB, the depth value corresponding to the point C is DC, and the depth value corresponding to the logging curve is VC;

the number of columns and rows of the pixel points corresponding to a certain pixel point M in the picture are XM and YM respectively, and then the depth value expression corresponding to the M point is as follows:

DM=DA+(DC-DA)*YM/H

the log value expression corresponding to the M point is as follows:

VM=VA+(VB-VA)*XM/W

if a certain row has a plurality of pixel points, the logging curve value corresponding to each pixel point is obtained, then the average is taken, and the average is used as the logging curve value corresponding to the pixel points of the row.

Further, before reading the color of the pixel point of the picture corresponding to the log, the method further comprises the step of picture processing:

and cutting the picture corresponding to the logging curve, removing the abscissa and ordinate areas, only reserving the inner effective area, and recording the depth range of the effective area and the value range of the logging curve to obtain the cut picture.

Further, the algorithm is written in an office excel script, and exists in the form of a button.

Further, the buttons comprise an import and analysis chart button, and when the import and analysis chart button is clicked, the cut picture is automatically imported into an excel working interface, and the colors and the corresponding numbers of all pixel points in the picture are counted.

Further, the buttons further comprise a color filling button, and clicking the color filling button fills colors corresponding to the color values of all the pixel points into an excel table.

Further, the buttons further comprise a numerical button, the numerical button is generated, all points representing the colors of the well logging curves in the pictures are read out, the corresponding well logging curve values are obtained through calculation of pixel points corresponding to all the density curves according to an algorithm, and the well logging curve values are automatically drawn into a scatter diagram.

Further, the log digitizing method further comprises a depth resampling step, wherein the data are resampled, resampling is carried out according to a set sampling interval, and finally corresponding values and images are formed.

In a second aspect, the present invention provides a log digitizing apparatus comprising a memory, a processor and a computer program stored in the memory and executable on the processor, the processor implementing the method steps as described in any one of the preceding claims when executing the computer program.

In a third aspect, the present invention provides a computer-readable storage medium storing a computer program which, when executed by a processor, performs the method steps as described in any one of the above.

Compared with the prior art, the invention has the beneficial effects that:

(1) The algorithm is realized through a program, so that the curve digitizing efficiency is greatly improved;

(2) The digitization accuracy of the method is greatly improved, and almost the same as the actual data;

(3) The manual pick-up cost is greatly saved.

Drawings

FIG. 1 is a working interface of a conventional Plot Digitizer software;

FIG. 2 is a log;

FIG. 3 is a graphical representation of the interface of the method for digitizing a log provided in embodiment 1 of the present invention;

fig. 4 is a schematic diagram of the log digitizing apparatus according to embodiment 2 of the present invention.

Detailed Description

The technical scheme of the invention is further described below with reference to the accompanying drawings and examples.

Example 1:

aiming at the defects of the traditional curve digitizing method, the invention provides a log curve digitizing method, which is characterized in that the colors of pixels of corresponding pictures of log curves are read, and the log curves with corresponding colors are calculated according to the preset abscissa and ordinate, so that the log curve values are finally obtained.

In a specific embodiment, according to the preset abscissa and ordinate, the calculation of the log curves with corresponding colors to obtain the log curve values finally includes the following algorithm:

taking fig. 2 as an example to illustrate the principle of the algorithm, the x-direction and the y-direction in the figure have 21 pixels respectively, that is, the whole picture has 441 pixels. The curve formed by all the filled pixels in the figure represents the log. Let the width of the picture to be digitized (the total number of picture horizontal pixels) be W and the height of the picture (the total number of picture vertical pixels) be H. In the figure, the point A represents a pixel point corresponding to the minimum depth value and the minimum logging curve value; the point B in the graph represents a pixel point corresponding to the minimum depth value and the maximum value of the logging curve; in the figure, the point C represents the pixel point corresponding to the maximum depth value and the minimum logging curve value. The depth value corresponding to the point A is DA, the corresponding logging curve value is VA, the depth value corresponding to the point B is DB, the corresponding logging curve value is VB, the corresponding depth value corresponding to the point C is DC, and the corresponding logging curve value is VC.

In the figure, the column number and the row number of a pixel point corresponding to a pixel point M are XM and YM respectively. The depth value expression corresponding to the M point is as follows:

DM=DA+(DC-DA)*YM/H

the log value expression corresponding to the M point is as follows:

VM=VA+(VB-VA)*XM/W

Therefore, the algorithm can greatly improve the digitizing efficiency of the curve, greatly improve the digitizing accuracy, almost have the same difference with the actual data, and greatly save the manual pick-up cost.

In a specific embodiment, the algorithm is written in an office excel script, and the excel is copied to a computer in the form of a button. That is, any computer capable of running office software can implement the method.

The method is further described in connection with an application scenario:

the device comprises: any computer capable of running office software

And (2) mounting: the algorithm is written in an office excel script, in the form of a button. Copying excel into computer.

The operation method comprises the following steps:

1. image processing

And cutting the picture corresponding to the logging curve, removing the abscissa and ordinate areas, only reserving the inner effective area, and recording the depth range of the effective area and the logging curve value range. The picture is saved in BMP format for further reading of the data.

2. Importing and parsing pictures

Clicking the "import and parse map" button (as shown in fig. 3), the cut picture will be automatically imported into the excel work interface (see columns I-K of the map). The program will count the colors and the corresponding numbers of all the pixels in the picture. The corresponding numerical value of the color is shown in the data after 6 rows of A columns, and the corresponding numerical value is shown in the data after 6 rows of B columns.

3. Color filling

Clicking the fill color button fills the color corresponding to each color value after the 6 rows of column C. In the present case, there are 4 colors, white (background color), gray (scale mark color), blue (longitudinal wave velocity curve) and red (density curve), respectively. The red curve represents the density curve (see fig. 2). If the density curve is digitized, the color value corresponding to red is 262908 as seen by the fill color, and this value is copied to the 8 th row cell of the F column.

4. Filling depth and logging curve parameters

As can be seen from FIG. 2, the depth ranges from 130m to 600m, and the density curve ranges from 1.2g/cm ³ -2.7g/cm ³ The set of values is correspondingly filled in the F columns of the 2 nd-5 th rows of cells.

5. Reading the picture and calculating the log value

Clicking the "generate value" button, the program reads all the red (262908) points in the picture, and calculates the corresponding pixel points of all the density curves according to the algorithm in the principle to obtain the corresponding log curve values (see the T-U column in fig. 3). The log values are automatically plotted as scatter plots (see columns M-N of fig. 3).

6. Depth resampling

The loading work of the subsequent logging curves is affected due to the inconsistent sampling intervals of the calculated data points. The data is resampled (linear difference) at 1 meter intervals to form corresponding values (see fig. 3, W-X) and images (see fig. 3, P-R). The resampled logging curve is consistent with the original logging curve in form and has small error, so that the subsequent scientific research and production requirements can be met.

Compared with the traditional curve digitizing method, the method has the following advantages: (1) The algorithm is realized through a program, so that the curve digitizing efficiency is greatly improved; (2) The digitization accuracy of the method is greatly improved, and almost the same as the actual data; and (3) the manual pick-up cost is greatly saved.

Example 2:

referring to fig. 4, the log digitizing apparatus provided in this embodiment includes a processor 41, a memory 42, and a computer program 43, such as a log digitizing method program, stored in the memory 42 and executable on the processor 41. The processor 41 implements the steps of embodiment 1 described above when executing the computer program 43.

Illustratively, the computer program 43 may be partitioned into one or more modules/units that are stored in the memory 42 and executed by the processor 41 to complete the present invention. The one or more modules/units may be a series of computer program instruction segments capable of performing a specific function describing the execution of the computer program 43 in the log digitizing means.

The logging digitizing device can be a computing device such as a desktop computer, a notebook computer, a palm computer, a cloud server and the like. The log digitizing means may include, but is not limited to, a processor 41, a memory 42. It will be appreciated by those skilled in the art that fig. 4 is merely an example of a log digitizing apparatus and does not constitute a limitation of a log digitizing apparatus, and may include more or fewer components than shown, or may combine certain components, or different components, e.g., the log digitizing apparatus may also include input and output devices, network access devices, buses, etc.

The processor 41 may be a central processing unit (Central Processing Unit, CPU), but may also be other general purpose processors, digital signal processors (Digital Signal Processor, DSP), application specific integrated circuits (Application Specific Integrated Circuit, ASIC), off-the-shelf programmable gate arrays (FieldProgrammable Gate Array, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.

The memory 42 may be an internal storage element of the log digitizing means, such as a hard disk or a memory of the log digitizing means. The memory 42 may also be an external storage device of the log digitizing apparatus, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card) or the like. Further, the memory 42 may also include both internal and external memory devices of the log digitizing apparatus. The memory 42 is used to store the computer program and other programs and data required by the log digitizing apparatus. The memory 42 may also be used to temporarily store data that has been output or is to be output.

Example 3:

the present embodiment provides a computer readable storage medium storing a computer program which, when executed by a processor, implements the steps of the method described in embodiment 1.

The computer readable medium can be any means that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device. More specific examples (a non-exhaustive list) of the computer-readable medium would include the following: an electrical connection (electronic device) having one or more wires, a portable computer diskette (magnetic device), a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disc read-only memory (CDROM). Additionally, the computer readable medium may even be paper or another suitable medium upon which the program is printed, such as by optically scanning the paper or other medium, then editing, interpreting, or otherwise processing as necessary, and electronically obtaining the program, which is then stored in a computer memory.

The above embodiments are only for illustrating the technical concept and features of the present invention, and are intended to enable those skilled in the art to understand the content of the present invention and implement the same, and are not intended to limit the scope of the present invention. All equivalent changes or modifications made in accordance with the essence of the present invention are intended to be included within the scope of the present invention.

Claims

1. A method of digitizing a log, comprising:

reading the color of a pixel point of a picture corresponding to the logging curve, and calculating the logging curve with the corresponding color according to a preset abscissa and ordinate to finally obtain the value of the logging curve;

according to the preset abscissa and ordinate, the logging curves with corresponding colors are calculated, and finally the logging curve values are obtained, wherein the algorithm comprises the following steps:

DM=DA+(DC-DA)*YM/H

the log value expression corresponding to the M point is as follows:

VM=VA+(VB-VA)*XM/W

2. The method of digitizing a log according to claim 1, further comprising the step of processing the picture prior to reading the pixel color of the corresponding picture of the log:

3. The method of digitizing a log of claim 2, wherein the algorithm is written in an office excel script in the form of a button.

4. The method of digitizing a log of claim 3, wherein the buttons include an import and parse map button, and clicking the import and parse map button automatically imports the cut picture into an excel work interface and counts the colors and the corresponding numbers of all pixels in the picture.

5. The method of digitizing a log of claim 4, wherein the buttons further comprise a fill color button, and clicking the fill color button fills colors corresponding to the respective color values of all pixels into an excel table.

6. The method of digitizing a log of claim 5, wherein the buttons further comprise a generate value button, wherein the generate value button reads all points representing the colors of the log in the picture, and calculates the corresponding pixels of all density curves according to an algorithm to obtain corresponding log values, and the log values are automatically plotted as a scatter diagram.

7. A log digitizing apparatus comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the method steps of any of claims 1-6 when executing the computer program.

8. A computer readable storage medium storing a computer program, characterized in that the computer program when executed by a processor implements the method steps of any of claims 1-6.