Graphics edit table row
With this function you can use the mouse to select a point from a drill hole trace and display the data from a table of the Geological Database which represents the sample point which you have selected.
Function Name:
You must be connected to a Geological database before invoking this function and you must also have displayed drill hole data by using the DRILL HOLES, GRAPHICS EXTRACT PLANS FOR PLOT or GRAPHICS EXTRACT SECTIONS FOR PLOT functions. No other data is in a format suitable for this function.
In addition to displaying data for the point which you select with the mouse it is possible to display other samples in the drill hole which are above and below the selected sample by defining a window or depth above and below the sample of interest.
Select table name
Enter the name of the table from which the data is to be extracted for editing.
It is important that you have the relevant data drawn on the screen before invoking this function. To edit data in the sample table you must first use the DRAW DRILL HOLE ASSAYS so that the sample points have been drawn in such a manner that they can be selected for editing. Similarly, you must use the DRAW DRILL HOLE SURVEYS or DRAW DRILL HOLE GEOLOGY to be able to edit the survey or geology data respectively.
Above and Below
Enter the heights above and below the selected sample to define the window within which data is to be extracted from the nominated table.
Complete the SELECT TABLE form and choose Apply to display the DEFINE VIEW/EDIT ROWS TEMPLATE form.
All rows from the table which comply with the query constraints, up to a maximum of 200 rows, are displayed on the VIEW/EDIT TABLE ROWS form. You may visit any of the fields displayed on the form to modify the values which are displayed.
When you have completed making changes to the data on the form you must press Apply to have your changes saved to the table. If you press Cancel any changes which you have made will be lost.
Data Validation:
Various validation tests are applied to the data to ensure that the integrity of the data are maintained. These tests vary depending on the type of the table which you are editing.
All tables:
- Any attempt to create rows which have duplicate indexes will be rejected. For example 2 rows in the collar table with the same hole ID.
Interval, Point and Survey tables:
- Any attempt to change the hole ID to a hole ID which does not exist in the collar or survey tables will be rejected.
- Any attempt to change a depth, depth_from or depth_to so that it exceeds the max_depth in the collar table for the hole will be rejected.
Time independent Interval tables only:
- Any attempt to create overlapping sample intervals will be rejected.
If any of these data validation criteria are not complied with then the update operation on the table will be terminated and the row which is causing the problem is displayed as the first row on the form. All rows prior to this row on the form will have been successfully saved to the table when this occurs. This gives you the opportunity to correct the offending data or to abort the remainder of the edit operation.
Complete the DEFINE VIEW/EDIT TABLE ROWS TEMPLATE form and choose Apply to display the prompt:
Select the point of interest
Using the mouse select the point for which the data is to be extracted and displayed for editing on a data entry form. After selecting the point of interest, the database table is queried and the relevant rows of data are displayed in a scrolling region on the VIEW/EDIT TABLE ROWS form.
Complete the VIEW/EDIT TABLE ROWS form and choose Apply to save the data to the database table. If you don't wish to save the data to the database table choose Cancel.
After choosing either Apply of Cancel, the prompt:
Select the point of interest
is displayed to permit you to select another point for editing. If you have finished editing data and do not wish to select any more points, press Escape to return to the "Function:" prompt.
Int grade
This function enables you to calculate the average grade and distance between two points along a drill hole trace. The samples must be consecutive in order to get a result.
Function:
Fields on the DISPLAY FIELD RANGE form.
Table number
You must enter the number of the table from which the sample data is required to calculate the average grade down the drill hole trace. Table 1 is the first table name which was entered when extracting the section from the database, table 2 was the second table, etc. Generally you will only be dealing with 1 table.
Field Range
You must enter the range of sample fields for which the interval grade is to be calculated. For example, if you extract three sample fields from the database, you may only wish to calculate the grade for the first field. If this is the case, you enter a range of 1.
Dilute blank or negative samples
Some times gaps in sampling exist along the drill hole trace. Generally these gaps in sampling are represented either no sample value at all or by negative values for the sample grade. The gaps in sampling may be treated in one of two ways when calculating the average sample grade. These methods are:
- The missing samples are ignored completely and the average grade does not include the missing samples.
- The average grade is diluted by assuming a value of ZERO for the value of the Blank or Negative samples.
Enter "Y" to assume a value of ZERO for any blank or negative samples. Enter "N" to completely ignore blank or negative samples in the calculation of average grades.
Choose Apply from the DISPLAY FIELD RANGE form to display the prompt:
Select the start point
Position the pointer and select the start point for the interval.
At the prompt:
Select the end point
Position the pointer and select the end point of the interval.
The INTERVAL Grade function continues until the Cancel button is pressed when the select point prompt is displayed.
The average grade of the selected interval is displayed in the message window along with the distance.
As with the Segment Grade function, any samples whose value are either blank, non-numeric or negative are excluded from the averaging function.
Note: The sample values are weighted by the sample length.
Seg grade
This function enables you to calculate the average grade and area of one closed segment.
Function:
Fields on the DISPLAY FIELD RANGE form.
Table number
You must enter the number of the table from which the sample data is required to calculate the average grade of the segments of interest. Table 1 is the first table name which was entered when extracting the section from the database, table 2 was the second table, etc. Generally you will only be dealing with 1 table.
Field Range
You must enter the range of assay fields for which the average grade is to be calculated. For example, if you extract three sample fields from the database, you may only wish to calculate the grade for the first field. If this is the case, you enter a range of 1.
Dilute blank or negative samples
Some times gaps in sampling exist along the drill hole trace. Generally these gaps in sampling are represented either no sample value at all or by negative values for the sample grade. The gaps in sampling may be treated in one of two ways when calculating the average sample grade. These methods are:
- The missing samples are ignored completely and the average grade does not include the missing samples.
- The average grade is diluted by assuming a value of ZERO for the value of the Blank or Negative samples.
Enter "Y" to assume a value of ZERO for any blank or negative samples. Enter "N" to completely ignore blank or negative samples in the calculation of average grades.
Choose Apply from the DISPLAY FIELD RANGE form to display the prompt:
Select the point of interest
Position the pointer on the closed segment that you want to calculate the average grade, and select a point.
The SEGMENT Grade function continues until the Cancel button is pressed when the select point prompt is displayed.
The average grade for selected sample fields of the selected outline are displayed in the message window with the area of the outline.
Str grade
This function enables you to calculate the average grade for all segments of a string. Anti-clockwise segments are treated as areas of exclusion by this function.
For example, if you had 3 closed outlines all with a string number of 1, this function would give you the average grade for all 3 outlines by weighting the grade of each outline by its area.
Function:
Table number
You must enter the number of the table from which the sample data is required to calculate the average grade of the strings of interest. Table 1 is the first table name which was entered when extracting the section from the database, table 2 was the second table, etc. Generally you will only be dealing with 1 table.
Field Range
You must enter the range of sample fields for which the average grade is to be calculated. For example, if you extract three sample fields from the database, you may only wish to calculate the grade for the first field. If this is the case, you enter a range of 1.
Dilute blank or negative samples
Some times gaps in sampling exist along the drill hole trace. Generally these gaps in sampling are represented either no sample value at all or by negative values for the sample grade. The gaps in sampling may be treated in one of two ways when calculating the average sample grade. These methods are:
- The missing samples are ignored completely and the average grade does not include the missing samples.
- The average grade is diluted by assuming a value of ZERO for the value of the Blank or Negative samples.
Enter "Y" to assume a value of ZERO for any blank or negative samples. Enter "N" to completely ignore blank or negative samples in the calculation of average grades.
Choose Apply from the DISPLAY FIELD RANGE form to display the prompt:
Select the point of interest
Position the pointer on a segment of the string that you want to calculate the average grade for and select a point.
The STRING Grade function continues until the Cancel button is pressed when the select point prompt is displayed.
The average grade for selected sample fields of all of the segments of the selected string are displayed in the message window along with the total area.
Note: If the bulk density is consistent within the string, the average grade will be a constant ratio.
View Table
With this function you can use the mouse to select a point from a drill hole trace and display the data from a table of the Geological Database which represents the sample point which you have selected.
Function:
You must be connected to a Geological database before invoking this function and you must also have displayed drill hole data by using the DRILL HOLES, GRAPHICS EXTRACT PLANS FOR PLOT or GRAPHICS EXTRACT SECTIONS FOR PLOT functions. No other data is in a format suitable for this function.
In addition to displaying data for the point which you select with the mouse it is possible to display other samples in the drill hole which are above and below the selected sample by defining a window or depth above and below the sample of interest.
Select table name
Enter the name of the table from which the data is to be extracted for viewing.
It is important that you have the relevant data drawn on the screen before invoking this function. To view data in the sample table you must first use the DRAW DRILL HOLE ASSAYS so that the sample points have been drawn in such a manner that they can be selected for editing. Similarly, you must use the DRAW DRILL HOLE SURVEYS or DRAW DRILL HOLE GEOLOGY to be able to view the survey or geology data respectively.
Above and Below
Enter the heights above and below the selected sample to define the window within which data is to be extracted from the nominated table.
Complete the SELECT THE DATABASE TABLE TO VIEW/EDIT form and choose Apply to display the DEFINE VIEW/EDIT ROWS TEMPLATE form.
All rows from the table which comply with the query constraints, up to a maximum of 200 rows, are displayed on the VIEW/EDIT TABLE ROWS form. You may view any of the fields displayed on the form by using the vertical and horizontal scrollbars positioned to the right and bottom of the data viewing form.
When you have completed viewing the data choose either Apply or Cancel to terminate the View Table Row function.
Complete the DEFINE VIEW/EDIT TABLE ROWS TEMPLATE form and choose Apply to display the prompt:
Select the point of interest
Using the mouse select the point for which the data is to be extracted and displayed for viewing on a data entry form. After selecting the point of interest, the database table is queried and the relevant rows of data are displayed in a scrolling region on the VIEW/EDIT TABLE ROWS form.
Complete the VIEW/EDIT TABLE ROWS form and choose Apply or Cancel to display the prompt
Select the point of interest
Select another point if you wish to continue viewing data from the table. If you have finished viewing data and do not wish to select any more points, press Escape to return to the "Function:" prompt.
Layer
This function is useful when multiple sections have been loaded and displayed in the Drill Hole Display module. It provides you with control over the visibility and selectability of the various sections which have been displayed so that you can easily make sections which may be cluttering the screen temporarily invisible. This function also permits you to change at will the active section for interpretation and drawing/erasing purposes.
Function:
It is important that you realise that the grade calculation functions and the drawing functions which are provided in the Drill Hole Display module only operate on the active layer or section. The ID number of the active layer is always displayed in the lower right corner of the dialog region as
"section=(section id)"
where (section id) is replaced by the actual ID number of the active section.
Fields on the SELECT DRILL HOLE LAYER form.
Available layers
The range of layers which were loaded into the Drill Hole Display module are displayed for reference.
Active layer
Enter the ID number of the section which is to become the active layer. The ID number of the current active layer is displayed as the default value. The ID number which you enter must be in the range shown for the available layers.
The active layer is always visible and always selectable.
Visible layers
Enter the range of layers which are to be made visible. The default value for visible layers is always the range of available layers. Thus, using this function with default values will ensure that all layers will be displayed, unless some of the layers have been erased by using either the CLEAR SCREEN or erase functions.
If you require the active layer to be the only visible layer then leave this input field blank and choose Apply.
Selectable layers
Enter the range of layers which are to be made selectable. The default value for selectable layers is always the range of available layers. Thus, using this function with default values will ensure that all layers will be selectable unless some of the layers have been erased by using either the CLEAR SCREEN or erase functions.
If you require the active layer to be the only selectable layer then leave this input field blank and choose Apply.
Any layer which is not visible is automatically unselectable.
Complete the SELECT DRILL HOLE LAYER form and choose Apply to change the active layer and to apply the visibility and selectability settings.
View Next Section
This function provides and alternate method to the DRILL HOLE LAYER function for changing the active layer. This function is considerably simpler as it makes the next layer in the range of available layers the active layer and makes the current layer invisible, and therefore unselectable.
This function, and the PREVIOUS DRILL HOLE LAYER function are extremely useful to quickly step through a large number of sections to gain an appreciation of the variation in geology and grade distribution in a region of interest.
Function:
This function activates the next layer in the range of available layers. If you are already at the last layer, this function will "wrap around" the end and go back to the first layer in the range of available layers.
View Previous Section
This function provides an alternate method to the DRILL HOLE LAYER function for changing the active layer. This function is considerably simpler as it makes the previous layer in the range of available layers the active layer and makes the current layer invisible, and therefore unselectable.
This function, and the NEXT DRILL HOLE LAYER function are extremely useful to quickly step through a large number of sections to gain an appreciation of the variation in geology and grade distribution in a region of interest.
Function:
This function activates the previous layer in the range of available layers. If you are already at the first layer, this function will "wrap around" the start and go to the last layer in the range of available layers.
Text size
This function allows you to change the size of the text drawn on the screen. The size that you enter will be relative to the actual data displayed.
Function:
Fields on the SELECT DISPLAY TEXT SIZE form.
Text size in object relative units
You must enter the size of the text in actual data units. e.g. If your samples are taken every 1 meter down the hole trace, it may be best to set the text size to default before drawing the assays.
Any text that is currently displayed on the screen will have to be erased and then redrawn to take into account the new text size.
If you leave the text size as zero, then all text will be plotted in units relative to the screen. This means that if you zoom in or out the text will remain at the same size. This is the default setting.
Draw All
Function:
This function displays the drill hole traces as a solid line, sample bar graphs or line graphs and symbolic geology traces if these were extracted from the database.
Draw Hole trace
Function:
This function will display the drill hole traces as a solid line. The colours of the lines will be dependent on what has been set up in the styles.ssi file in the share/etc directory for strings 1 to 4. See the documentation on Plan Sections for Plotting or Vertical Sections for Plotting for an explanation of the different string numbers.
Draw Label
Function:
This function displays the drill hole identifiers at the start of each drill hole.
Draw Hole survey
Function:
This function draws a small circle and the depth at each survey point down a hole trace, the collar, and end of hole.
The drill hole survey depths are drawn perpendicular to the drill hole trace at the depths down the hole. Small circular markers are also drawn along the drill hole trace. Use the circular marks to select these points for digitising or editing the database.
Draw Depths
Function:
This function draws the tick marks and depth values along the drill hole trace at the depth intervals specified when extracting the strings.
If a down hole depth value of 0 was enforced when extracting the strings then the depths will not be drawn.
Draw Graphs
Function:
Fields on the DISPLAY FIELD RANGE form.
Table number
You must enter the number of the table from which the sample data is required to draw the graphs. Table 1 is the first table name which was entered when extracting the section from the database, table 2 was the second table, etc. Generally you will only be dealing with 1 table.
Field Range
You must enter the range of sample fields for which graphs are to be displayed. For example, if you extract three sample fields from the database and elect to create graphs for all three, then you may only wish to display the first graph on the screen. If this is the case, you would enter a range of 1.
Coloured bar graphs
The bar graphs which are drawn may be drawn as outlines only or as colour filled polygons. Enter "N" to draw the graphs as outlines only. Enter "Y" to draw the graphs as colour filled polygons.
Note: If the points in the segments which represent the graphs are not co-planar then it will not be possible to draw them as colour filled outlines. If this situation occurs the message "Points for the Polygon are not coplanar" will be displayed. You will have to draw the graphs as outlines instead. Generally this problem will occur on significantly curved holes.
The graphs are drawn parallel to the drill hole trace for the fields selected. None of the points on the graphs are selectable. You must draw the sample values in order to select points for digitising or editing the database.
Draw Assays
Function:
Fields on the DISPLAY FIELD RANGE form.
Table number
You must enter the number of the table from which the sample data is to be drawn. Table 1 is the first table name which was entered when extracting the section from the database, table 2 was the second table, etc. Generally you will only be dealing with 1 table.
Field Range
You must enter the range of sample fields for which values are to be displayed. For example, if you extract three sample fields from the database, you may wish to display the first sample field on the screen. If this is the case, you enter a range of 1. The sample value colours are dependent on what has been set up in the styles.ssi file in the SSI_STYLES: directory for strings 1 to 9. See the documentation on Plan Sections for Plotting or Vertical Sections for Plotting for an explanation of these string numbers.
The drill hole sample values are drawn perpendicular to the drill hole trace for the fields selected. Markers are also drawn along the drill hole trace at the start and end of each interval. This allows you to select these points for digitising or editing the database.
Draw Boxes
Function:
Fields on the DISPLAY FIELD RANGE form.
Table number
You must enter the number of the table from which the geology data is to be drawn. Table 1 is the first table name which was entered when extracting the section from the database, table 2 was the second table, etc. Generally you will only be dealing with 1 table.
Field Range
You must enter the range of geology fields for which symbolic boxes are to be displayed. For example, if you extract three geology fields from the database and elected to create boxes for all three, you may only wish to display the first box on the screen. In this case, you enter a range of 1. If you want to have colour pattern filled boxes, you must add the various geological codes and the colours and patterns you want for each code, to the dholes.ssi file in the share/etc directory. These colours and patterns can only be applied if the points defining the boxes are co-planar. The format to set the colours in this file are:
default=HGS_color=faces=grey,HGS_face_pattern=solid OVB=HGS_color=faces=yellow,HGS_face_pattern=solid
In this example, any geology codes that are not specified in the dholes.ssi file are coloured grey as this is set as the default colour. Those intervals with a geology code of "OVB" are coloured yellow.
The symbolic geology boxes are drawn parallel to the drill hole trace for the fields selected. Very small markers are also drawn along the drill hole trace at the start and end of each box. This allows you to select these points for digitising or editing the database.
Hint: You may wish to create a standard dholes.ssi file for each project or for use throughout your company. Keep a back up of your dholes.ssi file in the SSI_STYLES: directory.
Draw Geol Labels
Function:
Fields on the DISPLAY FIELD RANGE form.
Table number
You must enter the number of the table from which the geology data is to be drawn. Table 1 is the first table name which was entered when extracting the section from the database, table 2 was the second table, etc. Generally you will only be dealing with 1 table.
Field Range
You must enter the range of literal geology fields for which literal geology codes are to be displayed. For example, if you extract three fields from the database, you may wish to display the first field on the screen. In this case, you enter a range of 1.
The drill hole geology codes are drawn perpendicular to the drill hole trace for the fields selected. Markers are also drawn along the drill hole trace at the start and end of each geological interval. This allows you to select these points for digitising or editing the database.
Draw Geol Trace
Function:
This function will draw the geology as different coloured line segments along or parallel to the drill hole trace. The different colours represent the different geological units. In addition to colour, the thickness of the line can also be altered thus making the geology more obvious. This function will only produce a result if the geology was extracted from the database as "literal" geology.
Fields on the DEFINE THE DATA TO BE DISPLAYED form.
Table number
You must enter the number of the table from which the geology data is to be drawn. Table 1 is the first table name which was entered when extracting the section from the database, table 2 was the second table, etc. Generally you will only be dealing with 1 table.
Field range
You must enter the range of geology fields for which the geology traces are to be drawn. For example, if you extract three geology fields from the database and elected to extract the geology as "literal" geology, you may wish to display the trace for the first field. In this case you enter a range of 1.
The geology traces for the specified fields are drawn. The colours and line thicknesses used to represent the geology are taken from the SSI_STYLES:dholes.ssi file. No data will be drawn if the geology was not extracted as "literal" geology.
The first geology trace will be coincident with the drill hole trace. Subsequent geology traces will be drawn parallel to the drill hole trace but offset to the left by 3 units for each field.
Erase All
Function:
This function erases all of the drill hole data from the screen for the "active" section.
Erase Hole trace
Function:
This function erases all of the drill hole traces from the screen for the "active" section.
Erase Label
Function:
This function erases all of the drill hole labels from the screen for the "active" section.
Erase Depths
Function:
This function erases all of the down hole depth tick marks and values from the screen for the "active" section.
Erase Hole survey
Function:
This function erases all of the drill hole survey points and depths from the screen for the "active" section.
Erase Graphs
Function:
This function erases all of the assay bar graphs and line graphs from the screen for the "active" section.
Erase Boxes
Function:
This function erases all of the symbolic geology boxes from the screen for the "active" section.
Erase Assays
Function:
This function erases all of the sample values from the screen for the "active" section.
Erase Geology
Function:
This function erases all of the literal geology codes from the screen for the "active" section.
Erase geology trace
Function:
This function erases the coloured geology trace from the screen for the "active" section.