You are here: Menu Commands > Database > Extract > Drillhole layout

GEOVIA Surpac

Extract drillhole layout

This function creates a string file of the collar locations of drill holes stored in the collar table. Selection criteria can be defined to obtain a subset of the data stored in the collar table. In addition you can define which of the optional fields are to be extracted and stored in the string file.

To run this function: Choose Database > Extract > Drill hole layout, or...

In the Function Chooser, type DRILL HOLE LAYOUT, and press ENTER.

Fields on the Drill hole layout form

Field	Description
Location, ID number and String
Location	The folder location of the string file being created.
ID number	The ID number for the string being created.
String	The number that defines the string to which the extracted points will be assigned.
Define optional Collar fields
Field name	The names of optional fields from the Collar table which are to be extracted and stored in the resulting string file. You do not need to enter any field names.

Complete the DRILL HOLE LAYOUT form and choose Apply to display the DEFINE QUERY CONSTRAINTS form.

Complete the DEFINE QUERY CONSTRAINTS form and choose Apply to commence processing.

A string file is created which contains one point for each drill hole which met the selection criteria. Each point in the string file will have various items of information stored in the description fields. The table below shows which data are stored in the various description fields.

If no survey data is present for a drill hole then the dip and azimuth values will be represented as blanks.

The string file created by the DRILL HOLE LAYOUT function may be processed further by the PLOTTING module to create a hard copy plot, or by the GRAPHICS module to view hole locations on the screen or by the DTM TOOLS to create a DTM of collar elevations for subsequent contouring or sectioning.

Extract Sample Data

This function allows you to extract sample coordinate data from interval or point attribute tables and create a string file which contains the sample position (Y, X, Z coordinates) and values. The inputs and results of this function will vary depending upon whether the table being processed is a time-dependent table or not.

To run this function: Choose Database > Extract > Sample data, or...

In the Function Chooser, type EXTRACT SAMPLE DATA, and press ENTER.

For time-independent tables, the samples to be extracted may include:

all samples for each drill hole
the first sample for each drill hole
the last sample for each drill hole
the minimum sample value for each drill hole
the maximum sample value for each drill hole.

For time-dependent tables, the samples to be extracted may include:

all samples for each drill hole
the mean sample value for each drill hole
the earliest sample in time for each drill hole
the latest sample in time for each drill hole
the difference (delta) in value between the earliest and latest sample for each drill hole
the minimum sample value for each drill hole
the maximum sample value for each drill hole.

Extract Sample Data provides functionality similar to the various compositing functions available on the COMPOSITING DATA submenu. Extract Sample Data provides discrete sample locations rather than a composite sample value and location.

Negative values can be extracted to the string file if necessary by using the extract negative samples checkbox, if this is not checked the resulting string file will contain spaces in the description field instead of the negative values.

The result of this function is a string file which contains the Y, X, Z coordinate of each sample extracted from the database, the sample values from the nominated fields and in the case of processing an interval attribute table, the length of the sample extracted.

Fields on the Extract Sample Data form

Fields	Description
Define the string file to create
Location	The folder location and filename for the file being created.
ID number	The ID number of the file being created.
String	The number for the string being created in the data file.
Extract negative samples	Selected: Samples with negative values are extracted. Cleared: Samples with negative values are not extracted.
Sample coordinate point
Bottom	The Y, X, Z coordinates are at the bottom of the sample.
Collar	The Y, X, Z coordinates are at the drill hole collar location.
Middle	The Y, X, Z coordinates are at the middle of the sample
Top	The Y, X, Z coordinates are at the top of the sample

Note: This only has any significance if the samples being extract are in an interval attribute table, that is the table contains the fields depth_from and depth_to. If the table is a point attribute table then the Y, X, Z coordinates will always be at the sample position and this input is ignored.

Choose Apply to display the SELECT THE SAMPLE TABLE TO PROCESS form.

Enter the name of the table containing the sample data which will be used for defining the assay fields which are to be extracted.

Choose Apply to display the DEFINE THE COMPOSITE GRADES form.

Field name

Enter up to 32 field names from the nominated sample table for which values are to be extracted. The sample values will be placed in the description fields of the string file which is created.

The hole id is stored in D1 and the sample values are stored in D2, D3 etc. Therefore, the first sample value will be found in D2, the second sample will be found in D3, etc.

Complete the DEFINE COMPOSITE GRADES form to display the next form. The form which is displayed next is dependent upon the type of sample table which is being processed.

If the sample table being processed is a time-independent table then the Process existing map definitions form is displayed.

Method

Enter the method which you wish to use to process the data in the sample table. The possible alternatives and their consequences are:

all samples

All samples for each drill hole which meet the query constraints are extracted from the table and saved to the resultant string file.

first sample

The query constraints which are applied to the sample table will define a subset of the samples in each drill hole. From this subset of samples (which may in fact include all samples in the hole) the first sample is obtained and saved to the resultant string file. An example of the use of this feature is to obtain the first sample in each drill hole below some constant depth from the ground surface.

last sample

The query constraints which are applied to the sample table will define a subset of the samples in each drill hole. From this subset of samples (which may in fact include all samples in the hole) the last sample is obtained and saved to the resultant string file. An example of the use of this feature is to obtain the first sample in each drill hole above some constant depth from the ground surface.

minimum sample

This feature permits you to obtain the sample which has the minimum value from the subset of samples, defined by the query constraints, for the drill hole. The field which is used for determining the minimum value is the first field entered on the DEFINE COMPOSITE GRADES form.

maximum sample

This feature permits you to obtain the sample which has the maximum value from the subset of samples, defined by the query constraints, for the drill hole. The field which is used for determining the maximum value is the first field entered on the DEFINE COMPOSITE GRADES form.

If the sample table being processed is a time-dependent table then the DEFINE THE METHOD FOR PROCESSING TIME DEPENDENT SAMPLES form is displayed.

The best example for using time dependent tables and this function is when the data to be recorded and stored in the database is for monitoring water bores in a well field over a period of time.

Method

Enter a number between 1 and 7 to define how this function is to create its results. With a time dependent table it is possible and indeed permissible that overlapping samples may exist for a particular drill hole. Given this fact it therefore entirely possible that within the data selection constraints defined, numerous samples may be extracted from the table. The samples which are to be saved in the result file, if any at all, are dictated by the input made here. See the table below to understand the results which will be created for the different methods available.

Input		Result
1	All	All samples are saved to the result file. Therefore it is possible that you may get many samples for each drill hole.
2	Mean	The mean value of all the samples which are extracted for each drill hole is saved to the result file. Therefore you will get only one sample value for each drill hole in the result file. The X, Y and Z values in this case are the mean of the X, Y and Z values of all of the down hole sample points which were used to calculate the mean. This is useful if you wish to obtain the average elevation of the water table over a time period of interest.
3	Earliest	The earliest sample in time for each drill hole is saved to the result file. This is useful if the earliest recording of the elevation of the water table is required for each monitoring bore in a well field over a time period of interest.
4	Latest	The latest sample in time for each drill hole is saved to the result file. This is useful if the latest recording of the elevation of the water table is required for each monitoring bore in a well field over a time period of interest.
5	Delta	The difference in sample value between the earliest and latest recorded for each drill hole is saved to the result file. This is useful if the difference in elevation of the water table between the earliest and latest recording is required for each monitoring bore in a well field over a time period of interest.
6	Minimum	The minimum sample value for each drill hole is saved to the result file. Note that the sample which is selected is done by finding the minimum value of the first sample field which is named on the previous form. All other values reported are those for the selected sample.
7	Maximum	The maximum sample value for each drill hole is saved to the result file. Note that the sample which is selected is done by finding the maximum value of the first sample field which is named on the previous form. All other values reported are those for the selected sample.

Complete the DEFINE THE METHOD FOR PROCESSING TIME INDEPENDENT SAMPLES or the DEFINE THE METHOD FOR PROCESSING TIME DEPENDENT SAMPLES form and choose Apply to display the DEFINE QUERY CONSTRAINTS form. Constraints may be defined independently for both the sample table being processed and also for the collar table. The constraints which are applied to the collar table are typically used to limit the data processed by hole ID, coordinate extents or hole type, while the constraints which are applied to the sample table can be used to limit the data processed by depth, elevation or sample value.

Complete the DEFINE QUERY CONSTRAINTS forms and choose Apply to commence processing.

The drill holes defined by the selection criteria are now processed and a string is created. A typical string file created using this function is shown below.

When processing an interval attribute table the third last description field contains the length of the sample which is inside the zone of interest and the second last description field contains the fraction of the original sample which is inside the zone of interest while the last description field contains the depth_from of the sample (for interval tables) or the depth_to (for point tables). Thus, any samples which have a value of '1' in the last description field are wholly within the zone of interest and a value less than 1 indicates that a sample has been truncated.

samp   , 31-Mar-93 ,Sample data XYZ at sample Middle,
0,  0.000,    0.000,    0.000,     0.000,     0.000,     0.000
1, 1906.500, 9607.000, 59.360, RC001, 0.01, 2, 1, 0
1, 2108.000, 9498.700, 59.950, RC001, 0.01, 2, 1, 2
1, 2284.500, 9694.000, 61.250, RC001, 0.02, 2, 1, 4
1, 2284.500, 9694.000, 59.950, RC001, 0.04, 2, 1, 6
1, 2284.500, 9694.000, 55.550, RC001, 0.07, 2, 1, 8
1, 2248.500, 9685.500, 61.250, RC001, 0.05, 2, 1, 10
1, 2248.500, 9685.500, 58.050, RC001, 0.06, 2, 1, 12
1, 2210.000, 9582.500, 62.650, RC001, 0.09, 2, 1, 14
1, 2172.500, 9789.000, 62.350, RC001, áááá, 2, 1, 16

Note: The D1 field contains the hole_id. In the above example the D2 field of the last point is blank. This indicates that no assay was present for that sample. D3 contains the sample length of the portion of the sample which is inside the zone of interest. D4 contains the fraction of the sample which is inside the zone of interest. D5 contains the depth_from for the sample.

If the sample table which is used is a point attribute table, i.e. it only has a depth_to field then the sample length and fraction of original sample length fields are not included.

Extract Sample Data Within Geology

This function allows you to extract sample coordinate data from the drill hole database interval or point attribute tables and create a string file which contains the sample position (Y, X, Z coordinates) and values.

To run this function: Choose Database > Extract > Sample data within geology, or...

In the Function Chooser, type EXTRACT SAMPLE DATA WITHIN GEOLOGY, and press ENTER.

For time-independent tables, the samples to be extracted may include:

all samples for each drill hole
the first sample for each drill hole
the last sample for each drill hole
the minimum sample value for each drill hole
the maximum sample value for each drill hole.

For time-dependent tables, the samples to be extracted may include:

all samples for each drill hole
the mean sample value for each drill hole
the earliest sample in time for each drill hole
the latest sample in time for each drill hole
the difference (delta) in value between the earliest and latest sample for each drill hole
the minimum sample value for each drill hole
the maximum sample value for each drill hole.

Extract Sample Data Within Geology provides functionality similar to the various compositing functions available on the COMPOSITING DATA submenu. Extract Sample Data Within Geology provides discrete sample locations rather than a composite sample value and location.

The result of this function is a string file which contains the Y, X, Z coordinate of each sample extracted from the database, the sample values from the nominated fields and in the case of processing an interval attribute table, the length of the sample extracted and the fraction of the full sample which is inside the zone of interest

Negative values can be extracted to the string file if necessary by using the extract negative samples checkbox, if this is not checked the resulting string file will contain spaces in the description field instead of the negative values.

Fields on the Extract sample data within geology form.

Define the string file to create

Define the file to be created which will contain the sample data by entering the Location and ID number. Enter a String number to identify the data in the file.

Define the zone selection method

You can restrict the bulking of grades to be within particular geological zones by choosing one of the following:

NO SELECTION, do not select by geology.
MULTIPLE ZONES, define the zone by entering one or more geology codes.
ZONE FROM TO, define the zone as being from the top or bottom of one geology code to the top or bottom of another.

Sample coordinate point

You must define which part of the sample the coordinates are to relate to. If you enter,

top, The Y, X, Z coordinates will be at the top of the sample
middle, The Y, X, Z coordinates will be at the middle of the sample
bottom, The Y, X, Z coordinates will be at the bottom of the sample.
collar, The Y, X, Z coordinates will be at the drill hole

Complete the EXTRACT SAMPLE DATA WITHIN GEOLOGY form and choose Apply.

Depending on the zone selection method you chose at the Define the zone selection method prompt (Multiple zones or Zone from to), one of two forms is displayed to permit you to define the geological selection criteria.

Complete the zone selection forms and choose Apply to display the SELECT THE SAMPLE TABLE TO PROCESS.

Table name

Enter the name of the table containing the sample data which will be used for defining the sample fields which are to be extracted.

Note: The sample table and the geology table which was defined earlier may be the same table.

Choose Apply to display the DEFINE THE COMPOSITE GRADES form.

Field name

Enter up to 32 field names from the nominated sample table for which values are to be extracted. The sample values will be placed in the description fields of the string file which is created.

The hole id is stored in D1 and the sample values are stored in D2, D3 etc. Therefore, the first sample value will be found in D2, the second sample will be found in D3, etc.

Complete the DEFINE COMPOSITE GRADES form to display the next form. The form which is displayed next is dependent upon the type of sample table which is being processed.

If the sample table being processed is a time-independent table then the DEFINE THE METHOD FOR PROCESSING TIME INDEPENDENT SAMPLES form is displayed.

Method

Enter the method which you wish to use to process the data in the sample table. The possible alternatives and their consequences are:

all samples

All samples for each drill hole which meet the query constraints are extracted from the table and saved to the resultant string file.

first sample

The query constraints which are applied to the sample table will define a subset of the samples in each drill hole. From this subset of samples (which may in fact include all samples in the hole) the first sample is obtained and saved to the resultant string file. An example of the use of this feature is to obtain the first sample in each drill hole below some constant depth from the ground surface.

last sample

The query constraints which are applied to the sample table will define subset of the samples in each drill hole. From this subset of samples (which may in fact include all samples in the hole) the last sample is obtained and saved to the resultant string file. An example of the use of this feature is to obtain the first sample in each drill hole above some constant depth from the ground surface.

minimum sample

This feature permits you to obtain the sample which has the minimum value from the subset of samples, defined by the query constraints, for the drill hole. The field which is used for determining the minimum value is the first field entered on the DEFINE COMPOSITE GRADES form.

maximum sample

This feature permits you to obtain the sample which has the maximum value from the subset of samples, defined by the query constraints, for the drill hole. The field which is used for determining the maximum value is the first field entered on the DEFINE COMPOSITE GRADES form.

If the sample table being processed is a time-dependent table then the DEFINE THE METHOD FOR PROCESSING TIME DEPENDENT SAMPLES form is displayed.

The best example for using time dependent tables and this function is when the data to be recorded and stored in the database is for monitoring water bores in a well field over a period of time.

Method

Enter a number between 1 and 7 to define how this function is to create its results. With a time dependent table it is possible and indeed permissible that overlapping samples may exist for a particular drill hole. Given this fact it therefore entirely possible that within the data selection constraints defined, numerous samples may be extracted from the table. The samples which are to be saved in the result file, if any at all, are dictated by the input made here. See the table below to understand the results which will be created for the different methods available.

Input		Result
1	All	All samples are saved to the result file. Therefore it is possible that you may get many samples for each drill hole.
2	Mean	The mean value of all the samples which are extracted for each drill hole is saved to the result file. Therefore you will get only one sample value for each drill hole in the result file. The X, Y and Z values in this case are the mean of the X, Y and Z values of all of the down hole sample points which were used to calculate the mean. This is useful if you wish to obtain the average elevation of the water table over a time period of interest.
3	Earliest	The earliest sample in time for each drill hole is saved to the result file. This is useful if the earliest recording of the elevation of the water table is required for each monitoring bore in a well field over a time period of interest.
4	Latest	The latest sample in time for each drill hole is saved to the result file. This is useful if the latest recording of the elevation of the water table is required for each monitoring bore in a well field over a time period of interest.
5	Delta	The difference in sample value between the earliest and latest recorded for each drill hole is saved to the result file. This is useful if the difference in elevation of the water table between the earliest and latest recording is required for each monitoring bore in a well field over a time period of interest.
6	Minimum	The minimum sample value for each drill hole is saved to the result file. Note that the sample which is selected is done by finding the minimum value of the first sample field which is named on the previous form. All other values reported are those for the selected sample.
7	Maximum	The maximum sample value for each drill hole is saved to the result file. Note that the sample which is selected is done by finding the maximum value of the first sample field which is named on the previous form. All other values reported are those for the selected sample.

Complete the DEFINE THE METHOD FOR PROCESSING TIME INDEPENDENT SAMPLES or the DEFINE THE METHOD FOR PROCESSING TIME DEPENDENT SAMPLES form and choose Apply to display the DEFINE QUERY CONSTRAINTS form. Constraints may be defined independently for both the sample table being processed and also for the collar table. The constraints which are applied to the collar table are typically used to limit the data processed by hole ID, coordinate extents or hole type, while the constraints which are applied to the sample table can be used to limit the data processed by depth, elevation or sample value.

Complete the DEFINE QUERY CONSTRAINTS forms and choose Apply to commence processing.

The drill holes defined by the selection criteria are now processed and a string is created. A typical string file created using this function is shown below.

When processing an interval attribute table the second last description field contains the length of the sample which is inside the zone of interest and the last description field contains the fraction of the original sample which is inside the zone of interest. Thus, any samples which have a value of '1' in the last description field are wholly within the zone of interest and a value less than 1 indicates that a sample has been truncated.

samp   , 31-Mar-93 ,Sample data XYZ at sample Middle,
0,  0.000,    0.000,    0.000,     0.000,     0.000,     0.000
1, 1906.500, 9607.000, 59.360, RC001, 0.01, 2, 1, 0
1, 2108.000, 9498.700, 59.950, RC001, 0.01, 2, 1, 2
1, 2284.500, 9694.000, 61.250, RC001, 0.02, 2, 1, 4
1, 2284.500, 9694.000, 59.950, RC001, 0.04, 2, 1, 6
1, 2284.500, 9694.000, 55.550, RC001, 0.07, 2, 1, 8
1, 2248.500, 9685.500, 61.250, RC001, 0.05, 2, 1, 10
1, 2248.500, 9685.500, 58.050, RC001, 0.06, 2, 1, 12
1, 2210.000, 9582.500, 62.650, RC001, 0.09, 2, 1, 14
1, 2172.500, 9789.000, 62.350, RC001, áááá, 2, 1, 16

Note: The D1 field contains the hole_id. In the above example the D2 field of the last point is blank. This indicates that no assay was present for that sample. D3 contains the sample length of the portion of the sample which is inside the zone of interest. D4 contains the fraction of the sample which is inside the zone of interest. D5 contains the depth_from for the sample.

If the sample table which is used is a point attribute table, i.e. it only has a depth_to field then the sample length and fraction of original sample length fields are not included.