CN114331301A - Sandstone-type uranium ore drilling geological record electronic compilation method - Google Patents
Sandstone-type uranium ore drilling geological record electronic compilation method Download PDFInfo
- Publication number
- CN114331301A CN114331301A CN202011046258.7A CN202011046258A CN114331301A CN 114331301 A CN114331301 A CN 114331301A CN 202011046258 A CN202011046258 A CN 202011046258A CN 114331301 A CN114331301 A CN 114331301A
- Authority
- CN
- China
- Prior art keywords
- lithology
- depth
- drilling
- column
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Investigation Of Foundation Soil And Reinforcement Of Foundation Soil By Compacting Or Drainage (AREA)
Abstract
The invention belongs to a compiling method, and particularly relates to an electronic compiling method for sandstone-type uranium ore drilling geological record books. It includes: 1, establishing a drilling database structure; 2, collecting drilling data; 3, designing a drawing frame; 4, calling and processing database data, and drawing the picture content; and 5, editing the book and outputting the page. The invention has the following remarkable effects: 1. the operation is simple and convenient; 2. automatic drawing is realized, and the working efficiency is improved; 3. the computer projection drawing precision is high; 4. the data is digitized, the modification is convenient, and the storage and the query are convenient; 5. the pictures are neat and beautiful, and the styles are uniform and standard.
Description
Technical Field
The invention belongs to a compiling method, and particularly relates to an electronic compiling method for sandstone-type uranium ore drilling geological record books.
Background
The drilling geological record book is a paper medium for geological record personnel to record core geological data. In the past, the drill holes in sandstone-type uranium mine geological exploration in China are recorded and drawn in a traditional mode, the traditional method is recorded in an outdoor environment, the handwriting varies from person to person, and contents such as the number of times of hand drawing, grain size (hard rock), patterns, colors, alterations, fossil, cracks, sample rails, geophysical prospecting curves and the like need to be drawn on recording paper. The method has the following disadvantages: 1. the manual drawing process is complicated, time-consuming and labor-consuming; 2. the geological record book under the outdoor condition is easy to be polluted, the writing and the drawing power are different from person to person, and the drawing is not tidy and beautiful enough, even can not be recognized due to pollution; 3. the manual projection drawing errors of the record book, the core, the sample and the position of the geophysical prospecting curve are large and not accurate enough; 4. the contents of the common graph need to be drawn repeatedly, and the repetitive work is more; 5. the drawings are all in paper form, so that the drawings are inconvenient to modify and difficult to store; 6. later-period searching and comprehensive utilization are difficult.
With the trend of informatization development, some software and applications supporting electronization of drilling record information appear at present. The geological record book output based on AutoCAD and EXCEL technologies, the drill geological record sketch drawing in DGSS software and the like are provided. Most of the technologies and methods cannot adapt to the characteristics of sandstone-type uranium deposit exploration, such as incapability of drawing a rock core geophysical gamma curve, incapability of automatically drawing sandstone grain size by software, manual modification, incapability of calling a database and the like.
Disclosure of Invention
The invention provides an electronic compiling method for sandstone-type uranium ore drilling geological catalogues, aiming at the defects of the prior art.
The invention is realized by the following steps: an electronic compilation method for sandstone-type uranium ore drilling geological records comprises the following steps:
The electronic compiling method for the sandstone-type uranium ore drilling geological record is characterized in that the step 3 specifically comprises the following steps:
step 3.1, designing positions and font sizes of top graph names, scale scales and the like of the geological record on the geological record;
step 3.2, designing the positions, the widths, the heights and the like of the columns expressed on the upper part of the geological record book, wherein the columns expressed comprise the times of return, the accumulated depth, the footage, the core length, the residual core, the times of return sampling rate, the hole depth, the grain grade histogram, the color, the carbonate content, the rock consolidation degree, the rock core measurement curve, the lithology description, the sampling position and the serial number, and the column widths of the columns are drawn according to drawing specifications and executed;
wherein, the width W (mm) of the expression column is determined by each column width, and the drawing starting point of the expression column is determined by the starting point h of the recording times1(m) determining that the size of the lower left corner of the expression column when the origin is the hole depth of 0m is in millimeters, and specifically calculating the method as follows:
W＝w1+w2+w3+……
H0＝1000*k*h1
w represents the column width (mm); w is a1、w2、w3Column width (mm) of each column specified by the style specification; h0Rendering starting point depth (m) of the expression column; h is1Compiling the starting point depth (m) of the second time; k scale
3.3, designing a hole depth scale, drawing according to the height of the recorded content, and marking the corresponding hole depth at a fixed interval;
wherein the height H (mm) of the contents is drawn from the starting point h of the recording1(m) and hole depth h0(m) determining the lower left corner of the presentation column with the origin at 0m hole depth, the dimensions in millimeters. The specific calculation method is as follows:
H＝1000*k*(h0-h1)
h, height (mm) of drawing content of the drawing; h is0A drilling depth (m); h is1Compiling the starting point depth (m) of the second time; k scale bar.
And 3.4, designing a curve bottom grid, and drawing in a centimeter grid mode according to the column width of the rock core measurement curve and the column width of the column of the particle size histogram and the height of the drawn contents.
The sandstone-type uranium ore drilling geological record electronic compiling method comprises the following specific steps of:
step 4.1, setting a drawn scale k;
step 4.2, data required by the drilling non-lithologic description column are synchronously called and processed, and the content of the non-lithologic description column list of the sandstone-type uranium ore drilling geological catalog is drawn;
the specific steps of the step 4.2 are as follows:
step 4.2.1, calling the drilling hole number in the drilling hole basic information table in the database, drawing the name of the top graph of the catalogued book and presenting the content in characters;
step 4.2.2, calling information such as the number of times of return, accumulated depth, footage, residual rock core and the number of times of return taking in a drilling class report record table, and drawing and recording the number of times of return information in a corresponding expression column;
step 4.2.3 calculating lithology delamination start-stop depth Ha(m)、HbAnd (m) automatically writing the calculation result into the database. Calling data to obtain a recurrent depth stop (m), a recurrent core length (m), a recurrent lithology start (m) and a recurrent lithology stop (m) in a geological record table of the drill holes in the library, wherein the cores are arranged according to the sequence of upper part defects, and the specific calculation method is as follows:
Ha＝d-l+Pa
Hb＝d-l+Pb
Halithology delamination (m); hbLithologic stratification stop (m); d, a second depth stop (m); l times core length (m);
Pabeginning with the second lithology (m); pbEnding with recurrent lithology (m).
And 4.2.4, calling the lithology layering starting and stopping depth calculated in the step 4.2.3 and lithology, size fraction, color, carbonate content, rock consolidation degree and other data in a drilling geological record table, and drawing a size fraction histogram, color, carbonate content and rock consolidation degree and other information in a corresponding performance column. Wherein, other information such as carbonate content, rock consolidation degree and the like is presented in characters, and a particle size histogram and color drawing are presented in a drawing form. Calling lithology symbols in a symbol library during lithology filling, calling a color library during color filling, and referring to corresponding grain size width in EJT 1159-2002 ground sandstone-type uranium ore drilling original cataloguing specifications;
step 4.2.5, calling a rock and mineral core geophysical prospecting record table in a database, coordinating data, converting a logging numerical value into a horizontal coordinate X (mm), converting a measuring point position into a vertical coordinate Y (mm), taking the lower left corner of a performance column when the hole depth is 0m as an original point, projecting independent data points in a rock and mineral core measuring curve column according to coordinates, connecting the data points of the same time to form a measuring curve, and taking the size in millimeters as a unit, wherein the specific conversion method for coordinating data is as follows:
X＝w12*(C-Cmin)/(Cmax-Cmin)+w1+w2+w3+……w11
Y＝(d-l+Pc)*1000*k
x abscissa (mm); c, recording numerical values; cminScale minimum; cmaxMaximum value of the scale;
w12the width (mm) of a rock core measurement curve;
w1、w2、w3the column width (mm) of each column on the left side; k scale bar;
y ordinate (mm); d, a second depth stop (m); l times core length (m); p is a radical ofcThe relative position (m) of the test point is measured again.
Step 4.2.6, calling a drilling sampling record table in the database, drawing the sample section primitive at the depth corresponding to the corresponding presentation column according to the sampling position, and marking the sample number on the right side of the primitive.
And 4.3, calculating lithology description column drawing related parameters, and automatically writing the calculation result into a database.
The sandstone-type uranium ore drilling geological record electronic compiling method comprises the following specific steps of 4.3:
and 4.3.1, calculating the length L (mm) of the lithologic pattern, and automatically writing the calculation result into a database. L is the length of the lithology of the first layer of each turn, the length of the core needs to be added, and the lithology of other layers does not need to be changed. Calling the starting and stopping depth of the lithological layering of the step 4.2.3 in the database, replacing the layering starting with the recurrent lithological sequence number of 1 in the data with the recurrent depth starting with the recurrent lithological sequence number of 1 in the drilling geological record table, and modifying and unmodified Ha(m) integration into Ha' (m) lithology layering, the calculation method is as follows:
L＝(Hb-Ha′)*k*1000
Ha' lithologic stratifications contain a defect (m); hbLithologic stratification stop (m); l lithology pattern height (mm)
And 4.3.2, calculating the height T (mm) of the lithology description text, and automatically writing the calculation result into a database. It is related to the total width of characters, the total number of characters, the space between characters, the width of text and the number of lines, and the specific relationship is as follows:
t is the number of rows, the word high + (number of rows-1) the line spacing
Row number ═ total width of characters/width of text ] +1
Total width of character 2 x (width of character + space of characters) + total number of characters + space of characters
T text height (mm); [] The middle brackets indicating integers
Step 4.3.3 setting the paging interval D (mm), calculating the bottom depth H of the last pagingm(m), m is the total paging number calculated as follows:
m＝[1000*k*(h0-h1)/D]+1
Hm＝m*D/(1000*k)+h1
Hmthe mth paging line depth (m); d paging pitch (mm); m total number of pages;
h0a drilling depth (m); h is1Compiling the starting point depth (m) of the second time; k scale bar; []The middle brackets indicating integers
Step 4.3.4, calculating the coordinates of the bottom boundary of each layer of lithology description, and automatically writing the calculation result into the database.
The electronic compiling method for sandstone-type uranium ore drilling geological records is characterized in that L, T and H calculated in the steps 4.3.1, 4.3.2 and 4.3.3 are calledmCalculated by the following relationship:
Pithe ith lithology describes the lower boundary (mm); l isiThe ith layer lithologic pattern height (mm); h is1Compiling the starting point depth (m) of the second time;
Tilayer i lithology describes text height (mm); riThe ith lithology describes the longitudinal centerline position (mm); k scale bar; i the ith layer;
wherein R isiThe optimal lithology description longitudinal center line positions of the lithology description mathematical programming model can be calculated according to a simplex method. Lithology description mathematical programming model Q min Ri-Mi, wherein the position M of the longitudinal center line of the ith lithology patterniThe relationship is as follows:
the lithology description mathematical programming model meets the following constraint conditions:
Liis the ith layer lithologic pattern height (mm); t isiDescribe the text height (mm) for the ith lithology; n total number of layers;
Mithe longitudinal center line position (mm) of the ith layer of lithologic pattern; riDescribe the longitudinal centerline position (mm) for the ith lithology;
Hmthe mth paging line depth (m); m total number of pages; k scale bar;
wherein, the condition (1) is that two adjacent lithologic character descriptions cannot be overlapped; condition (2) is that the first layer of lithological descriptions cannot exceed the cataloged lithological pattern top boundary; condition (3) is that the last layer of lithology description cannot exceed the last page fault line; condition (4) is that the lithology describes that the longitudinal centerline position cannot be above the start of the recording.
And 4.4, calling the lithology description column calculated in the step 4.3 to draw related parameters and lithology description data in the drilling geological record table, drawing a lithology boundary and lithology description according to the lithology description column and drawing the related parameters, wherein the lithology description is presented in a text form.
The sandstone-type uranium ore drilling geological record electronic compiling method comprises the following specific steps of:
step 5.1 with the starting depth h of the recording pass1(m) the depth is the starting point, the paging space is D (mm), parallel lines are drawn as paging lines, and the paging lines are drawn until the hole depth is finished.
Step 5.2 referring to the page line, extracting the text starting depth T across the page linea(mm) and the depth T of page line crossed by page-crossing bookb(mm), automatically segmenting the lithology description text, and computing the segmented s-th line text as follows:
s＝[1000*k*(Tb-Ta)/(a+b)]+1
Tbdepth of intersection (m) of text with a paging line; t isaText start depth (m); a font size (mm); b line spacing (mm);
s dividing the text according to the s line; k scale bar; brackets in the text indicate integers
And 5.3, locally finely adjusting the divided text to enable lithologic description contents to be on the same page as much as possible, performing paging output according to paging lines, reserving contents between the paging lines, calling information such as the hole number, the scale and the aperture in the database and the number of pages calculated in the step 4.3.3, respectively drawing contents such as a picture name, an expression column, a page number, an aperture and the like on the upper part and the lower part of each page, presenting the contents in a character form, forming a separate file for each page, and merging, printing and outputting or exporting the contents to be a single PDF file.
The electronic compiling method for the sandstone-type uranium ore drilling geological record is characterized in that the software used in the step is a digital uranium ore exploration system.
The electronic compiling method for the sandstone-type uranium ore drilling geological record is characterized in that in the step 1, a sandstone-type uranium ore drilling data table and a sandstone-type uranium ore drilling data structure are established on the basis of an Access database.
The sandstone-type uranium ore drilling geological record electronic compiling method comprises the steps that in the step 2, a digital uranium ore exploration system can be installed at the end of a movable flat plate, drilling data are collected by the flat plate, digitalization of original data is achieved through real-time voice or dictionary entry, and the data are automatically classified and stored in corresponding data tables when being imported into a computer.
The invention has the following remarkable effects: 1. the operation is simple and convenient; 2. automatic drawing is realized, and the working efficiency is improved; 3. the computer projection drawing precision is high; 4. the data is digitized, the modification is convenient, and the storage and the query are convenient; 5. the pictures are neat and beautiful, and the styles are uniform and standard. Compared with geological record book output based on AutoCAD and EXCEL technologies, drilling geological record sketch drawing in DGSS software and the like, the method is suitable for the characteristics of sandstone-type uranium mine exploration, can be used for drawing a rock core geophysical prospecting gamma curve, can be used for automatically drawing sandstone grain grades, and can realize paging output and calling, database management and the like. The method is suitable for drawing various drilling geological record books, and the working efficiency is greatly improved by establishing a drilling database and utilizing a computer to form a picture.
Drawings
FIG. 1 is an electronic compilation process of sandstone-type uranium ore drilling geological record book
FIG. 2 Access database architecture
FIG. 3 geological transcript map surface frame pattern
FIG. 4 depicts a completed paginated geological record
Detailed Description
The invention is described in further detail below with reference to the figures and examples.
The technical scheme of the invention is as follows: an electronic compilation method for sandstone-type uranium ore drilling geological records specifically comprises the following steps (figure 1):
step 3.1, designing the top graph name and the position of a scale (shown in figure 3A) of the geological record book, wherein the graph name is 10mm in bold font, and the scale is 3mm in bold font;
step 3.2, designing the position of a column (figure 3B) of the upper part of the geological record, wherein the height of the column is 20mm, the width of each column is 8mm in the second time, 10mm in the accumulated depth, 10mm in the footage, 10mm in the core length, 12mm in the residual core, 12mm in the second time sampling rate, 12mm in the hole depth, 24mm in the grain size histogram, 5mm in color, 8mm in carbonate content, 8mm in the rock consolidation degree, 40mm in the rock core measurement curve, 80mm in lithology description, and 12mm in sampling position and number, and the column width of each column is executed according to drawing specifications;
wherein, the width W (mm) of the expression column is determined by each column width, and the drawing starting point of the expression column is determined by the starting point h of the recording times1(m) determination of h167.35m, the origin is the lower left corner of the presentation column at a hole depth of 0m, and the dimension is in millimeters, and the specific calculation method is as follows:
W＝w1+w2+w3+……
H0＝1000*k*h1
w represents the column width (mm); w is a1、w2、w3Column width (mm) of each column specified by the style specification; h0Rendering starting point depth (m) of the expression column; h is1Compiling the starting point depth (m) of the second time; k scale
Step 3.3, designing a hole depth scale (shown in figure 3D), drawing according to the height of the recorded content, and marking the corresponding hole depth at a fixed interval;
wherein the height H (mm) of the frame of the contents of the compilation (FIG. 3C) is drawn from the starting point h of the compilation pass167.35m and hole depth h0The origin is the lower left corner of the presentation column at a hole depth of 0m, and the dimensions are in millimeters. The specific calculation method is as follows:
H＝1000*k*(h0-h1)
h, height (mm) of drawing content of the drawing; h is0A drilling depth (m); h is1Compiling the starting point depth (m) of the second time; k scale bar.
And 3.4, designing a curve bottom grid (figure 3E), and drawing in a centimeter grid mode according to the column width of the columns of the core measurement curve and the grain size histogram and the height of the drawn contents.
step 4.1, setting the drawn scale k to be 1: 100;
step 4.2, data required by the drilling non-lithologic description column are synchronously called and processed, and the content of the non-lithologic description column list of the sandstone-type uranium ore drilling geological catalog is drawn;
the specific steps of the step 4.2 are as follows:
step 4.2.1, calling the drilling hole number in the drilling hole basic information table in the database, drawing the name of the top graph of the catalogued book and presenting the content in characters;
step 4.2.2, calling information such as the number of times of return, accumulated depth, footage, residual rock core and the number of times of return taking in a drilling class report record table, and drawing and recording the number of times of return information in a corresponding expression column;
step 4.2.3 calculating lithology delamination start-stop depth Ha(m)、HbAnd (m) automatically writing the calculation result into the database. Calling data to obtain a recurrent depth stop (m), a recurrent core length (m), a recurrent lithology start (m) and a recurrent lithology stop (m) in a geological record table of the drill holes in the library, wherein the cores are arranged according to the sequence of upper part defects, and the specific calculation method is as follows:
Ha＝d-l+Pa
Hb＝d-l+Pb
Halithology delamination (m); hbLithologic stratification stop (m); d, a second depth stop (m); l times core length (m);
Pabeginning with the second lithology (m); pbEnding with recurrent lithology (m).
And 4.2.4, calling the lithology layering starting and stopping depth calculated in the step 4.2.3 and lithology, size fraction, color, carbonate content, rock consolidation degree and other data in a drilling geological record table, and drawing a size fraction histogram, color, carbonate content and rock consolidation degree and other information in a corresponding performance column. Wherein, other information such as carbonate content, rock consolidation degree and the like is presented in characters, and a particle size histogram and color drawing are presented in a drawing form. Calling lithology symbols in a symbol library during lithology filling, calling a color library during color filling, and referring to corresponding grain size width in EJT 1159-2002 ground sandstone-type uranium ore drilling original cataloguing specifications;
step 4.2.5, calling a rock and mineral core geophysical prospecting record table in a database, coordinating data, converting a logging numerical value into a horizontal coordinate X (mm), converting a measuring point position into a vertical coordinate Y (mm), taking the lower left corner of a performance column when the hole depth is 0m as an original point, projecting independent data points in a rock and mineral core measuring curve column according to coordinates, connecting the data points of the same time to form a measuring curve, and taking the size in millimeters as a unit, wherein the specific conversion method for coordinating data is as follows:
X＝w12*(C-Cmin)/(Cmax-Cmin)+w1+w2+w3+……w11
Y＝(d-l+Pc)*1000*k
x abscissa (mm); c, recording numerical values; cminScale minimum; cmaxMaximum value of the scale; w is a12The width (mm) of a rock core measurement curve;
w1、w2、w3the column width (mm) of each column on the left side; k scale bar;
y ordinate (mm); d, a second depth stop (m); l times core length (m); p is a radical ofcThe relative position (m) of the test point is measured again.
Step 4.2.6, calling a drilling sampling record table in the database, drawing the sample section primitive at the depth corresponding to the corresponding presentation column according to the sampling position, and marking the sample number on the right side of the primitive.
4.3, calculating lithology description column drawing related parameters, and automatically writing calculation results into a database;
the specific steps of the step 4.3 are as follows:
and 4.3.1, calculating the length L (mm) of the lithologic pattern (including the center of weakness), and automatically writing the calculation result into a database. L is the length of the lithology of the first layer of each turn, the length of the core needs to be added, and the lithology of other layers does not need to be changed. Calling the lithologic layering starting and stopping depth of the step 4.2.3 in the database, and replacing the layering starting with the recurrent lithologic sequence number of 1 in the data with the recurrent lithologic in the drilling geological record tableFrom the round depth with the sequence number 1, modified and unmodified Ha(m) integration into Ha' (m) lithology delamination (including the defect) and the calculation method is as follows:
L＝(Hb-Ha′)*k*1000
Ha' lithologic stratifications contain a defect (m); hbLithologic stratification stop (m); l lithologic pattern height (with core) (mm)
And 4.3.2, calculating the height T (mm) of the lithology description text, and automatically writing the calculation result into a database. It is related to the total width of characters, the total number of characters, the space between characters, the width of text and the number of lines, and the specific relationship is as follows:
t is the number of rows, the word high + (number of rows-1) the line spacing
Row number ═ total width of characters/width of text ] +1
Total width of characters 2 (word width + inter-character distance) + total number of characters wide + total number of characters spaced + total number of characters ttext height (mm); [] The middle brackets represent integers; the height and width of the character are 3 mm; the line spacing is 0 mm;
the width of the text is 75 mm; character spacing of 0mm
Step 4.3.3 setting the page pitch D to 140mm, calculating the depth H of the last page of page bottomm(m), m is the total paging number calculated as follows:
m＝[1000*k*(h0-h1)/D]+1
Hm＝m*D/(1000*k)+h1
Hmthe mth paging line depth (m); d paging pitch (mm); m total number of pages;
h0a drilling depth (m); h is1Compiling the starting point depth (m) of the second time; k scale bar; []The middle brackets indicating integers
Step 4.3.4, calculating the coordinates of the bottom boundary of each layer of lithology description, and automatically writing the calculation result into the database. L, T and H calculated by step 4.3.1, step 4.3.2 and step 4.3.3 are invokedmCalculated by the following relationship:
Pithe ith lithology describes the lower boundary (mm); l isiThe ith layer lithologic pattern height (including the core) (mm);
h1compiling the starting point depth (m) of the second time;
Tilayer i lithology describes text height (mm); riThe ith lithology describes the longitudinal centerline position (mm); k scale bar; i the ith layer;
wherein R isiThe optimal lithology description longitudinal center line positions of the lithology description mathematical programming model can be calculated according to a simplex method. Lithology description mathematical programming model Q min Ri-Mi, wherein the position M of the longitudinal center line of the ith lithology patterniThe relationship is as follows:
the lithology description mathematical programming model meets the following constraint conditions:
Lithe ith layer lithologic pattern height (including the core) (mm); t isiDescribe the text height (mm) for the ith lithology; n total number of layers;
Mithe longitudinal center line position (mm) of the ith layer of lithologic pattern; riDescribe the longitudinal centerline position (mm) for the ith lithology;
Hmthe mth paging line depth (m); m total number of pages; k scale bar;
wherein, the condition (1) is that two adjacent lithologic character descriptions cannot be overlapped; condition (2) is that the first layer of lithological descriptions cannot exceed the cataloged lithological pattern top boundary; condition (3) is that the last layer of lithology description cannot exceed the last page fault line; condition (4) is that the lithology describes that the longitudinal centerline position cannot be above the start of the recording.
And 4.4, calling the lithology description column calculated in the step 4.3 to draw related parameters and lithology description data in the drilling geological record table, drawing a lithology boundary and lithology description according to the lithology description column and drawing the lithology boundary and lithology description (figure 4F), wherein the lithology description is presented in a text form.
step 5.1 with the starting depth h of the recording pass1(m) the depth is the starting point, the paging space is D (mm), parallel lines are drawn as paging lines, and the paging lines are drawn until the hole depth is finished.
Step 5.2 referring to the page line, extracting the text starting depth T across the page linea(mm) and the depth T of page line crossed by page-crossing bookb(mm), automatically segmenting the lithology description text, and computing the segmented s-th line text as follows:
s＝[1000*k*(Tb-Ta)/(a+b)]+1
Tbdepth of intersection (m) of text with a paging line; t isaText start depth (m); a font size (mm);
b line spacing (mm);
s dividing the text according to the s line; k scale bar; brackets in the text indicate integers
And 5.3, locally finely adjusting the divided texts to enable lithologic description contents to be on the same page as much as possible, performing paging output according to paging lines, reserving contents between the paging lines, simultaneously calling information such as the hole number, the scale and the aperture in the database, and the number of pages calculated in the step 4.3.3, respectively drawing contents such as a picture name, an expression column, a page number, an aperture and the like (figure 4G) on the upper part and the lower part of each page, presenting the contents in a character form, forming a separate file for each page, and merging, printing and outputting or exporting the contents to be a single PDF file.
Wherein, the depth of the last paging line is referred to when the upper part label is drawn, the depth of the paging line of the page is referred to when the lower part label is drawn, and the depth relation of the paging lines is detailed in the reference step 4.3.3.
The present invention has been described in detail with reference to the drawings and examples, but the present invention is not limited to the examples described above, and various changes can be made within the knowledge of those skilled in the art without departing from the spirit of the present invention. The present invention may be practiced without these particulars.
Claims (9)
1. An electronic compilation method for sandstone-type uranium ore drilling geological record books is characterized by comprising the following steps: the method comprises the following steps:
step 1, establishing a drilling database structure: according to the characteristics of sandstone-type uranium ore drilling data, on the basis of an Access database, setting different types of information data tables as basic units, mainly comprising a drilling basic information table, a drilling work and report record table, a drilling geological record table, a rock core geophysical prospecting record table and a drilling sampling record table, and dividing single items to establish a data structure;
step 2, collecting drilling data: drilling data required for drawing a sandstone-type uranium ore drilling geological record book are obtained through geological and geophysical prospecting core records, and the collected data are classified and input into corresponding data tables for storage;
step 3, designing a drawing frame: designing a drawing frame pattern according to drawing specifications of a sandstone-type uranium ore drilling record book;
step 4, calling and processing database data, and drawing the picture content: setting parameters of a drawing, synchronously calling various data in a database and calculating related parameters to finish drawing the sandstone-type uranium ore drilling geological record;
step 5, editing and outputting the book page: drawing a paging line, segmenting a page-crossing text, locally fine-tuning the segmented text to enable lithologic description contents to be on the same page as much as possible, and finally merging, printing and completing page output of the cataloguing book.
2. The electronic compilation method for sandstone-type uranium ore drilling geological records according to claim 1, wherein the method comprises the following steps: the specific steps of the step 3 are as follows:
step 3.1, designing positions and font sizes of top graph names, scale scales and the like of the geological record on the geological record;
step 3.2, designing the positions, the widths, the heights and the like of the columns expressed on the upper part of the geological record book, wherein the columns expressed comprise the times of return, the accumulated depth, the footage, the core length, the residual core, the times of return sampling rate, the hole depth, the grain grade histogram, the color, the carbonate content, the rock consolidation degree, the rock core measurement curve, the lithology description, the sampling position and the serial number, and the column widths of the columns are drawn according to drawing specifications and executed;
wherein, the width W (mm) of the expression column is determined by each column width, and the drawing starting point of the expression column is determined by the starting point h of the recording times1(m) determining that the size of the lower left corner of the expression column when the origin is the hole depth of 0m is in millimeters, and specifically calculating the method as follows:
W＝w1+w2+w3+……
H0＝1000*k*h1
w represents the column width (mm); w is a1、w2、w3Column width (mm) of each column specified by the style specification; h0Rendering starting point depth (m) of the expression column; h is1Compiling the starting point depth (m) of the second time; k scale
3.3, designing a hole depth scale, drawing according to the height of the recorded content, and marking the corresponding hole depth at a fixed interval;
wherein the height H (mm) of the contents is drawn from the starting point h of the recording1(m) and hole depth h0(m) determining the lower left corner of the presentation column with the origin at 0m hole depth, the dimensions in millimeters. The specific calculation method is as follows:
H＝1000*k*(h0-h1)
h, height (mm) of drawing content of the drawing; h is0A drilling depth (m); h is1Compiling the starting point depth (m) of the second time; k scale bar.
And 3.4, designing a curve bottom grid, and drawing in a centimeter grid mode according to the column width of the rock core measurement curve and the column width of the column of the particle size histogram and the height of the drawn contents.
3. The electronic compilation method for sandstone-type uranium ore drilling geological records according to claim 2, wherein the method comprises the following steps: the specific steps of the step 4 are as follows:
step 4.1, setting a drawn scale k;
step 4.2, data required by the drilling non-lithologic description column are synchronously called and processed, and the content of the non-lithologic description column list of the sandstone-type uranium ore drilling geological catalog is drawn;
the specific steps of the step 4.2 are as follows:
step 4.2.1, calling the drilling hole number in the drilling hole basic information table in the database, drawing the name of the top graph of the catalogued book and presenting the content in characters;
step 4.2.2, calling information such as the number of times of return, accumulated depth, footage, residual rock core and the number of times of return taking in a drilling class report record table, and drawing and recording the number of times of return information in a corresponding expression column;
step 4.2.3 calculating lithology delamination start-stop depth Ha(m)、HbAnd (m) automatically writing the calculation result into the database. Calling data to obtain a recurrent depth stop (m), a recurrent core length (m), a recurrent lithology start (m) and a recurrent lithology stop (m) in a geological record table of the drill holes in the library, wherein the cores are arranged according to the sequence of upper part defects, and the specific calculation method is as follows:
Ha＝d-l+Pa
Hb＝d-l+Pb
Halithology delamination (m); hbLithologic stratification stop (m); d, a second depth stop (m); l times core length (m);
Pabeginning with the second lithology (m); pbEnding with recurrent lithology (m).
And 4.2.4, calling the lithology layering starting and stopping depth calculated in the step 4.2.3 and lithology, size fraction, color, carbonate content, rock consolidation degree and other data in a drilling geological record table, and drawing a size fraction histogram, color, carbonate content and rock consolidation degree and other information in a corresponding performance column. Wherein, other information such as carbonate content, rock consolidation degree and the like is presented in characters, and a particle size histogram and color drawing are presented in a drawing form. Calling lithology symbols in a symbol library during lithology filling, calling a color library during color filling, and referring to corresponding grain size width in EJT 1159-2002 ground sandstone-type uranium ore drilling original cataloguing specifications;
step 4.2.5, calling a rock and mineral core geophysical prospecting record table in a database, coordinating data, converting a logging numerical value into a horizontal coordinate X (mm), converting a measuring point position into a vertical coordinate Y (mm), taking the lower left corner of a performance column when the hole depth is 0m as an original point, projecting independent data points in a rock and mineral core measuring curve column according to coordinates, connecting the data points of the same time to form a measuring curve, and taking the size in millimeters as a unit, wherein the specific conversion method for coordinating data is as follows:
X＝w12*(C-Cmin)/(Cmax-Cmin)+w1+w2+w3+……w11
Y＝(d-l+Pc)*1000*k
x abscissa (mm); c, recording numerical values; cminScale minimum; cmaxMaximum value of the scale;
w12the width (mm) of a rock core measurement curve;
w1、w2、w3the column width (mm) of each column on the left side; k scale bar;
y ordinate (mm); d, a second depth stop (m); l times core length (m); p is a radical ofcThe relative position (m) of the test point is measured again.
Step 4.2.6, calling a drilling sampling record table in the database, drawing the sample section primitive at the depth corresponding to the corresponding presentation column according to the sampling position, and marking the sample number on the right side of the primitive.
And 4.3, calculating lithology description column drawing related parameters, and automatically writing the calculation result into a database.
4. The electronic compilation method for sandstone-type uranium ore drilling geological records according to claim 3, wherein the method comprises the following steps: the specific steps of the step 4.3 are as follows:
and 4.3.1, calculating the length L (mm) of the lithologic pattern, and automatically writing the calculation result into a database. L is the length of the lithology of the first layer of each turn, the length of the core needs to be added, and the lithology of other layers does not need to be changed. Calling the lithologic layering starting and stopping depth of the step 4.2.3 in the database, and replacing the layering starting with the recurrent lithologic sequence number of 1 in the data with the recurrent lithologic sequence number in the drilling geological record tableFrom the depth of the second run with the subthreshold number 1, H will be modified and unmodifieda(m) integration into Ha' (m) lithology layering, the calculation method is as follows:
L＝(Hb-Ha′)*k*1000
Ha' lithologic stratifications contain a defect (m); hbLithologic stratification stop (m); l lithology pattern height (mm)
And 4.3.2, calculating the height T (mm) of the lithology description text, and automatically writing the calculation result into a database. It is related to the total width of characters, the total number of characters, the space between characters, the width of text and the number of lines, and the specific relationship is as follows:
t is the number of rows, the word high + (number of rows-1) the line spacing
Row number ═ total width of characters/width of text ] +1
Total width of character 2 x (width of character + space of characters) + total number of characters + space of characters
T text height (mm); [] The middle brackets indicating integers
Step 4.3.3 setting the paging interval D (mm), calculating the bottom depth H of the last pagingm(m), m is the total paging number calculated as follows:
m＝[1000*k*(h0-h1)/D]+1
Hm＝m*D/(1000*k)+h1
Hmthe mth paging line depth (m); d paging pitch (mm); m total number of pages;
h0a drilling depth (m); h is1Compiling the starting point depth (m) of the second time; k scale bar; []The middle brackets indicating integers
Step 4.3.4, calculating the coordinates of the bottom boundary of each layer of lithology description, and automatically writing the calculation result into the database.
5. The electronic compilation method of sandstone-type uranium ore drilling geological records according to claim 4, wherein the method comprises the following steps: l, T and H calculated by step 4.3.1, step 4.3.2 and step 4.3.3 are invokedmCalculated by the following relationship:
Pithe ith lithology describes the lower boundary (mm); l isiThe ith layer lithologic pattern height (mm); h is1Compiling the starting point depth (m) of the second time;
Tilayer i lithology describes text height (mm); riThe ith lithology describes the longitudinal centerline position (mm); k scale bar; i the ith layer;
wherein R isiThe optimal lithology description longitudinal center line positions of the lithology description mathematical programming model can be calculated according to a simplex method. Lithology description mathematical programming model Q min Ri-Mi, wherein the position M of the longitudinal center line of the ith lithology patterniThe relationship is as follows:
the lithology description mathematical programming model meets the following constraint conditions:
Liis the ith layer lithologic pattern height (mm); t isiDescribe the text height (mm) for the ith lithology; n total number of layers;
Mithe longitudinal center line position (mm) of the ith layer of lithologic pattern; riDescribe the longitudinal centerline position (mm) for the ith lithology;
Hmthe mth paging line depth (m); m total number of pages; k scale bar;
wherein, the condition (1) is that two adjacent lithologic character descriptions cannot be overlapped; condition (2) is that the first layer of lithological descriptions cannot exceed the cataloged lithological pattern top boundary; condition (3) is that the last layer of lithology description cannot exceed the last page fault line; condition (4) is that the lithology describes that the longitudinal centerline position cannot be above the start of the recording.
And 4.4, calling the lithology description column calculated in the step 4.3 to draw related parameters and lithology description data in the drilling geological record table, drawing a lithology boundary and lithology description according to the lithology description column and drawing the related parameters, wherein the lithology description is presented in a text form.
6. The electronic compilation method for sandstone-type uranium ore drilling geological records according to claim 5, wherein the method comprises the following steps: the specific steps of the step 5 are as follows:
step 5.1 with the starting depth h of the recording pass1(m) the depth is the starting point, the paging space is D (mm), parallel lines are drawn as paging lines, and the paging lines are drawn until the hole depth is finished.
Step 5.2 referring to the page line, extracting the text starting depth T across the page linea(mm) and the depth T of page line crossed by page-crossing bookb(mm), automatically segmenting the lithology description text, and computing the segmented s-th line text as follows:
s＝[1000*k*(Tb-Ta)/(a+b)]+1
Tbdepth of intersection (m) of text with a paging line; t isaText start depth (m); a font size (mm); b line spacing (mm);
s dividing the text according to the s line; k scale bar; brackets in the text indicate integers
And 5.3, locally finely adjusting the divided text to enable lithologic description contents to be on the same page as much as possible, performing paging output according to paging lines, reserving contents between the paging lines, calling information such as the hole number, the scale and the aperture in the database and the number of pages calculated in the step 4.3.3, respectively drawing contents such as a picture name, an expression column, a page number, an aperture and the like on the upper part and the lower part of each page, presenting the contents in a character form, forming a separate file for each page, and merging, printing and outputting or exporting the contents to be a single PDF file.
7. The electronic compilation method of sandstone-type uranium ore drilling geological records according to claim 6, wherein the method comprises the following steps: the software used in the steps is a digital uranium mine exploration system.
8. The electronic compilation method of sandstone-type uranium ore drilling geological records according to claim 7, wherein the method comprises the following steps: and in the step 1, a sandstone-type uranium ore drilling data table and a data structure are established on the basis of the Access database.
9. The electronic compilation method of sandstone-type uranium ore drilling geological records according to claim 8, wherein the method comprises the following steps: in the step 2, a digital uranium mine exploration system can be installed at the mobile flat plate end, the flat plate is used for collecting drilling data, digitization of original data is achieved through real-time voice or dictionary entry, and the data of the flat plate computer is automatically classified and stored in a corresponding data table when being imported into a computer.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011046258.7A CN114331301A (en) | 2020-09-29 | 2020-09-29 | Sandstone-type uranium ore drilling geological record electronic compilation method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011046258.7A CN114331301A (en) | 2020-09-29 | 2020-09-29 | Sandstone-type uranium ore drilling geological record electronic compilation method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114331301A true CN114331301A (en) | 2022-04-12 |
Family
ID=81011301
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011046258.7A Pending CN114331301A (en) | 2020-09-29 | 2020-09-29 | Sandstone-type uranium ore drilling geological record electronic compilation method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114331301A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115147518A (en) * | 2022-09-01 | 2022-10-04 | 中国科学院地理科学与资源研究所 | Sedimentary rock lithology symbol generation method and device |
-
2020
- 2020-09-29 CN CN202011046258.7A patent/CN114331301A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115147518A (en) * | 2022-09-01 | 2022-10-04 | 中国科学院地理科学与资源研究所 | Sedimentary rock lithology symbol generation method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104915521B (en) | Log sheet compilation method based on field catalog data and automated cartographic generalization | |
| CN102360404B (en) | Method for compiling geological display map of chamber | |
| CN106951400A (en) | The information extraction method and device of a kind of pdf document | |
| CN109933796B (en) | Method and device for extracting key information of bulletin text | |
| CN106991258B (en) | Method for establishing tunnel engineering geological longitudinal section map | |
| CN110765739B (en) | Method for extracting form data and chapter structure from PDF document | |
| CN101206639A (en) | Method for indexing complex impression based on PDF | |
| CN103412967A (en) | Geologic field information collection system, geologic field information collection method and application method of collection system | |
| CN112784980B (en) | Intelligent logging horizon dividing method | |
| CN103714203B (en) | Log sheet automatic mapping method based on CAD template binding technology | |
| CN116311259B (en) | Information extraction method for PDF business document | |
| CN103020388A (en) | Method for making section boards in river model tests | |
| CN103544185A (en) | Well-logging data file storage method | |
| CN114331301A (en) | Sandstone-type uranium ore drilling geological record electronic compilation method | |
| CN105069162A (en) | Informatized exploratory adit catalog data acquisition system and method | |
| CN111160853A (en) | Electronic compilation method for uranium ore drilling comprehensive histogram | |
| AU2020103315A4 (en) | A method for digitizing writings in antiquity | |
| Asi et al. | User-assisted alignment of arabic historical manuscripts | |
| CN114937279A (en) | BOM recognition method and device for realizing IA based on RPA and AI | |
| CN113673306A (en) | Method and system for extracting form information from PDF document | |
| CN107240150A (en) | A kind of three-dimensional tube numeral dissolves drawing method | |
| CN113435449A (en) | OCR image character recognition and paragraph output method based on deep learning | |
| CN113947664A (en) | Automatic mapping method for sandstone-type uranium ore geological histogram | |
| CN113012257B (en) | Variable scale drilling histogram drawing method for manganese ore | |
| CN106777155B (en) | Geological logging method based on electronic centimeter paper |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |