Extract sections
This function is almost identical to the EXTRACT SECTIONS FOR PLOT function. The significant difference is that GRAPHICS EXTRACT SECTIONS FOR PLOT, in addition to extracting sections from the geological database and saving them to string files, draws the resultant sections in Graphics immediately after the data has been extracted.
Function Name:
Click and drag to define the section lineUse the mouse to define the orientation of the section line of interest. When you release the mouse button the GRAPHICS EXTRACT SECTIONS FOR PLOTTING form is displayed.
Graphics extract sections for plotting form
Location of string files
Enter the location name for the string files that will be generated. The ID number of each string file will be set to each section number in the section range that is specified.
Section Range
Enter the range of sections that you wish to extract. The values that you enter for the section range depend upon the orientation of the section line. There are three distinct cases which must be
considered when defining the section orientation and the associated section range. These are:
- The section orientation is east-west and you are looking to the north. This is arranged by the left end of the section line being the western most of the section line endpoints. In this case the values entered for the section range must be northing values.
- The section orientation is north-south and you are looking to the west. This is arranged by the left end of the section line being the southern most of the section line endpoints. In this case the values entered for the section range must be easting values.
- The section orientation is something other than the two cases described above. That is, oblique to the principal axes, or east-west in orientation and looking south, or north-south in orientation and looking east.
In each of these cases the values entered for the section range must be perpendicular distances from the line defined by the section endpoints to each of the subsequent section lines required. Therefore to obtain a section centred about the line defined by the section endpoints, a value of 0 (zero) must be included in the section range.
If five sections are required at intervals of 50 metres from the section line then a range of '0,200,50' must be used.
The range will control the ID numbers assigned to the output string files, with the first section generated having an ID number taken from the " From " part of the range statement, with subsequent sections having an ID number taken from the " From " part of the range statement plus the " Increment " of the range statement. The " Increment " will also control the distance at which subsequent sections are offset from the initial section end-points.
Define the section orientation
Left end
Enter the coordinates of the left end of the section line. The co-ordinates of the point where you pressed the mouse button are displayed as default values.
Right end
Enter the coordinates of the right end of the section line. The co-ordinates of the point where you released the mouse button are displayed as default values.
Define the section extents
Widths
Enter the projection distance either side of the section plane. The first distance is the distance extending back from the section plane, i.e. extending south for an east-west section, or east from a north-south section. The second distance is the distance extending forward from the section plane.
Z extents
Enter the minimum and maximum elevations for the volume in space in which the drill holes are to be extracted.
Real world coords for oblique sections
If oblique sections are defined, then the output strings can be stored in real world coordinates or coordinates relative to the defined oblique section. In the latter case the eastings in the string file will be relative to the most westerly or southerly point on the section which will have an easting of zero. The northing will be the distance from the first defined section as in the diagram above. The z coordinate will have the correct elevations.
|
1. y1, x1 2. length 3. view if relative to section 4. view if real world coordinates specified 5. section 0 6. y2, x2 |
Downhole datapoint interval
Enter the interval at which points will be generated for plotting of the drill hole trace. The default value is one point every metre.
Interval for plotting depths
If you wish to plot down hole depths on the drill hole plans, enter the interval at which these are to be extracted. This interval must be a multiple of the downhole data point interval entered in the previous prompt. The resulting down hole depths will be stored in the first description field of the drill hole trace string. If down hole depths are not required for plotting then enter a zero, which is the default.
Define the sample tables
Enter the names of up to 5 tables from which sample data is to be extracted and included in the string files created by this function. It is useful to be able to extract data from more than one sample table at a time when samples have been recorded at different intervals down the drill hole.
Define the geology tables
Enter the names of up to 5 tables from which geology data is to be extracted and included in the string files created by this function. It is useful to be able to extract data from more than one geology table at a time when samples have been recorded at different intervals down the drill hole.
Define the diplog table
Enter the name of the table from which the diplog information is to be extracted. This table should be a point table and have optional fields to store the dip, azimuth and quality of the dipmeter readings down the hole.
Select drill holes graphically
The drill holes which are to be included in the plan may either be defined using the standard DEFINE QUERY CONSTRAINTS form or by selecting the drill holes graphically by using the mouse.
Note:To select the drill holes graphically you must first have used the GRAPHICS DRILL LAYOUT function to extract and display drill hole collar data in the appropriate fashion.
Enter "Y" to select the drill holes for inclusion on the plan graphically using the mouse. Enter "N" to use the standard DEFINE QUERY CONSTRAINTS form to define the drills holes which are to included in the plan.
Complete the GRAPHICS EXTRACT PLANS FOR PLOT form and choose Apply to display the DEFINE SAMPLE FIELDS FOR PLOTTING form.
Table
The name of the table from which the sample fields are to be selected is displayed here.
Process each element separately
If more than one sample field is to be extracted, you can choose whether to control the colour coding of each field separately or by using the colour coding base on the range defined for the first sample field.
Enter "Y" to have each sample field classified independently using its own class range. Enter "N" to have all sample fields classified into the same class as the values from the first sample field.
Combine adjacent samples
Adjacent samples which have the same value can be combined and plotted as a single value over a longer sample interval by entering "Y" for this input. Enter "N" to have all sample intervals reported individually.
There are some conditions associated with combining adjacent samples into a single interval. These conditions apply when more than one field is being extracted for plotting. Adjacent samples will only be combined into a longer interval if the following conditions apply:
1) To determine if adjacent samples are to be combined the values if the first sample field of the adjacent samples must be equal.
2) If condition (1) is true, then the values from all other fields which are being extracted must either be numeric, thus permitting length weighted averaging of the adjacent samples, or if some or all of the values from the other sample fields are character values, then the values must be identical.
If either of the conditions described above are false, then adjacent samples will not be combined and they will be reported individually.
Define the sample fields and their plotting characteristics
Field Name
Enter the name of the sample field which is to be extracted for plotting.
Class Range
Enter a range (i.e. 0,10,2;999) to classify the values from the sample field into different classes for subsequent plotting. This is particularly useful when you wish to plot values in different colours depending on the magnitude of the value.
To define the class range you must enter a conventional range specification which is interpreted as successive pairs of from and to values. See the example below:
Class range = 0,10,2;999
Translates to
From >= To < 0 2 2 4 4 6 6 8 8 10 10 999
A maximum of 10 class can be created for plotting even though you can enter a range which defines many more values.
Any sample values which are greater or less than the range of from and to values defined by the range will be assigned to the first class. In the example above, this means that negative values and values above 999 would be assigned to the same class as the 0 to 2 range.
Treat negatives
This can be set to as nulls or as negatives. If this field is set to as nulls , negative values are plotted as blanks. If this field is set to as negatives, values below zero are saved as negative values and are plotted in the same way as positive values.
Bulking Threshold
The bulking threshold will control the bulking of consecutive samples that are above or below the threshold. A bulking threshold of zero indicates that bulking is not required. A negative value will generate a bulked value of consecutive samples below the threshold. A positive value will generate a bulked value of consecutive samples above the threshold. The output will report the number of metres of consecutive samples above or below the threshold along with the bulked value.
| bulking threshold = 3 | bulking threshold = -2 | |
|
|
1. 3 m @ 4 2. 2 m @ 3.5 3. 2 m @ 1.5 4. 3 m @ 1 |
No of Decimals
Enter the number of decimal places which are to be used for formatting the sample values for plotting.
Graphs
It is possible to create a line or bar (histogram) graph for plotting. These graphs are useful as a visual means of inspecting the results on a hardcopy plot and making high grade values stand out significantly. If you choose to create graphs this function will create various strings in the resultant string file which can be used to plot the graphs in the PLOTTING module. Valid entries here are:
- none - no graphs will be created.
- line - A string will be created which represents the sample values as a line graph. It is most appropriate to use line graphs when the table from which data is being extracted is a point table.
- bar - A string will be created which represents the sample values as a bar graph or histogram. It is most appropriate to use bar graphs when the table from which data is being extracted is an interval table.
An important feature of bar graphs, with respect to plotting, is that the bar graph is comprised of a number of closed segments. This is significant when you consider the further processing of this data by the PLOTTING module. The D1 field of the closed segments of the bar graph will have the class number, i.e. 1 or 2 or 3, etc. stored in it. This is particularly useful as it makes it possible to then use the pattern fill or colour fill capabilities of the PLOTTING module and the pattern selection method using a lookup file to use different patterns or colours for different class ranges when plotting the final results.
See the diagram below for examples of typical graphs.
| bar graph | line graph |
|
|
Graph Location
If graphs have been selected you can choose whether to plot the graphs on the left hand side or right hand side of the drill hole trace. To choose which side of the hole trace the graphs are required simply enter "left" or "right".
Length per Unit
If graphs have been selected then you can control the size of the graphs by entering the length per sample value unit here.
Maximum Value
If graphs have been selected then you can limit the maximum size of the graph, that is, the maximum offset from the drill hole trace, by entering a maximum graph value here. Any sample values which exceed this value will be graphed as though they were equal to the maximum graph value.
Complete the DEFINE SAMPLE FIELDS FOR PLOTTING form and choose Apply to display the DEFINE GEOLOGY FIELDS form. This form will be displayed for each of the sample table names which are entered above.
Table
The name of the geology table is displayed here.
Geology type to plot
Geology will be extracted to the string file as 'symbolic' geology and 'literal' geology.
- literal - Literal geology will extract geology data and save it in the string file in different description fields. This is intended for plotting the geology data as textual information on the plot.
- symbolic - Symbolic geology is extracted as a closed string segment along with the geology code in the D1 field. This ensures that fill entities and lookup tables for pattern selection based on the geology code can be used when processing with the Plotting module.
For example,
| Depth_from | Depth_to | ROCK |
|---|---|---|
| 0 | 5 | And |
| 5 | 7 | BRC |
| 7 | 10 | And |
| literal geology | symbolic geology | |
|
|
1. And 2. BRC |
Combine adjacent samples
If adjacent geology samples have identical sample values then the samples can be combined and reported as a single longer interval. Enter "Y" to combine adjacent samples otherwise enter "N".
Define the geology fields and their plotting characteristics
Field Name
Enter the name of the field in the geology table which is to be included in the plot.
Geology Location
You must indicate the location of the graph by entering `left' or `right'.
Box Size
You must enter the width, in real world units, for the size of the box which will be created.
Complete the DEFINE QUERY CONSTRAINTS form and choose Apply to commence extracting the data from the Geological Database.
When extraction and processing of the data is completed each of the plans are displayed in the graphics module.
Complete the DEFINE GEOLOGY FIELDS form and choose Apply to proceed to the next step of defining the drill holes which are to be included in the plan.
If you chose to select the drill holes graphically then the following prompt will be displayed:
Select a drill hole. Press ESC when selection is complete
Using the mouse, select each of the drill holes which are to be included in the plan. It is only valid to select points which have been displayed by using the GRAPHICS DRILL HOLE LAYOUT function. Continue selecting drill holes with the mouse until all required drill holes have been selected. When you have completed the graphical selection of drill holes, press Escape to display the DEFINE THE REQUIRED DRILL HOLES form.
The drill hole identifiers of all the holes which were selected using the mouse are displayed on a scrolling region on this form. You may edit this list, delete hole IDs from or add more holes IDs to the list.
Complete the DEFINE THE REQUIRED DRILL HOLES form and choose Apply to display the DEFINE DIPMETER DATA form. This form will only be displayed if a diplog table name was entered.
Define dipmeter form
Table
Display only. The name of diplog table is displayed here.
Dip field name
Enter the name of the field in the diplog table containing the dip value.
Azimuth field name
Enter the name of the field in the diplog table containing the azimuth value.
Quality field name
Enter the name of the field in the diplog table containing the quality value of the dip and azimuth reading. This must have been entered as a value between `a' and `e' where `a' indicates a good reading and `e' indicates a poor reading. Case (i.e. upper or lower) of the quality values is irrelevant.
Dip segment position
Indicate whether you want the dip meters to be plotted on the left or right of the drill hole trace.
Dip segment length
Enter the length in real world units of the size of the dip meter segment lengths to be plotted.
Dip segment offset
Enter the offset from the drill hole trace in real world units that the centre of the dip meter segments are to be plotted.
Tadpole location
Enter the location name of the string file which will contain the tadpole grid and point values. The ID will be taken from the section ID. If this field is left blank, then a tadpole string file will not be created.
Tadpole tail length
Enter the length in real world units of the length of the tadpole line segment to be plotted.
Elevation grid interval
Enter the interval of the elevation grid lines on the y-axis of the tadpole grid.
Dip scale (deg/plot unit)
Enter the number of degrees per plot unit for the dipmeter plot dip axis.
Dip grid interval
Enter the interval of the dip grid lines on the x-axis of the tadpole grid.
Dip scale (deg/plot unit)
Enter the number of degrees per plot unit for the dipmeter plot dip axis.
Number of dip grid intervals
Enter the number of grid intervals to define the maximum grid value on the x-axis of the tadpole grid. For example, if 5 was entered above for the Dip grid interval and 6 entered here for the Number of dip grid intervals, then the maximum x-axis grid value will be 30.
Complete the DEFINE DIPMETER DATA form and choose Apply to commence extracting the data from the Geological Database.
If you did not choose to select the drill holes graphically then the standard DEFINE QUERY CONSTRAINTS form will be displayed to permit you to limit the data to be processed by using normal query constraints.