How to use the Litho table - Revision history

Alex Doll: /* The Sample Definition & Litho database table */

2015-05-19T16:45:11Z

The Sample Definition & Litho database table

Alex Doll: /* The Sample Definition & Litho database table */

2015-05-19T16:44:46Z

The Sample Definition & Litho database table

Alex Doll: /* The Sample Definition & Litho database table */

2015-05-19T16:39:54Z

The Sample Definition & Litho database table

Alex Doll: /* The Litho database table */

2013-12-08T20:38:00Z

The Litho database table

Alex Doll: Created page with "==The Litho database table== The 'Litho' table is used to partition other test results into groups. Those groups are commonly lithology (hence the table name), alteration, an..."

2012-12-26T18:01:12Z

Created page with "==The Litho database table== The 'Litho' table is used to partition other test results into groups. Those groups are commonly lithology (hence the table name), alteration, an..."

New page

==The Litho database table==
The 'Litho' table is used to partition other test results into groups. Those groups are commonly lithology (hence the table name), alteration, and zone. The Litho table also contains drill hole information, for those samples derived from drill holes, that allow geologists to relate the spatial positions of grindability samples within geological models.

The mandatory fields are:
* '''Sample''': the sample name, and must be entered exactly as it appears in the other testwork tables in order for the grouping functions to work properly.
* '''Program''': the sampling program that this sample belongs to. Must be entered exactly as it appears in the other testwork tables in order for the grouping functions to work properly.

The automatically generated fields are:
* '''#''': the position in the current table. This value varies whenever the table sorting changes or when new data is entered.
* '''id''': the unique row ID number of this database record.
* '''ProjNum''': the project number that this record belongs to.

An optional '''comment''' field is available for assigning other information to a record. Examples of 'comment' information includes references to publications or drill hole dimensions (PQ, HQ).

===Grouping of samples===
[[file:LithoTable1.png|thumb|alt=Screenshot of litho table|Example data entered into the Litho table]]
Three special fields in the Litho table can be used for grouping samples. The names of these fields describe how they are typically used, but users are free to substitute other uses and are not restricted to entering the data described.
* '''litho''' is usually the dominant lithology of a sample. Examples are 'breccia', 'volcanic' or 'End member 1'.
* '''alteration''' is usually the dominate type of alteration of a sample. Examples are 'secondary enrichment', 'argillic' or 'quartz-sericite'.
* '''zone''' is usually a geographical or stratigraphic description of a sample. Examples are 'East zone', 'secondary enrichment' or 'main pit'.

In these examples, the term 'secondary enrichment' can go in any of the fields — how the fields are used should vary from deposit to deposit depending on what factors the geologists and metallurgists have determined are controlling the ore hardness and mineralization. The field names are only guidelines and the use of the fields can be tailored to suit a project's particular needs.

===Drill hole identification===
[[file:LithoTable2.png|thumb|alt=Screenshot of an example Litho table|Example Litho table with drill hole information]]
Four optional special fields applicable to samples derived from drill core are:
* '''drillhole''': the name or number of the drill hole that a sample was derived from.
* '''from''' and '''to''': the down-hole positions where the sample starts and ends. This value can be in the customary units of the project (metres, feet or other units).
* '''length''' the overall length of the interval tested within the sample. This is usually ''to'' minus ''from'', but could be smaller if, for example, only every second metre was sampled for grinding.

It is customary to make each sample a single interval of a single drill hole. Mixing material from different drill holes or from non-adjoining intervals is not recommended as geologists and geostatisticians will not be able to relate the grindability samples back into the geological models (for performing geometallurgical modelling). See the [[Testwork#Planning a feasibility test program|commentary on test programs]] for more.

===Sorting samples by groups===
A set of sorting options will appear at the top of a testwork table after information has been entered in the Litho table. In the example screenshot, the ''litho'' and ''alteration'' fields have been used to distinguish between different types of lithology (carbonates, andesite, steely hematite and hematite breccia) and ore/waste zones (CCBM - an ore type, and waste).

The drop-down menus above the table can be used to isolate only samples that correspond to a particular category. In this example, selecting the "waste" alteration type would cause the table to show only the 'Prefeas 6' and 'Prefeas 7' samples (the display of all the other samples would be suppressed). Similarly, selecting the "Carbonates" lithology will show only the 'Prefeas 5' sample.

The drop-down groupings are cumulative, so (in the example) setting the lithology to 'Andesite' and the alteration to 'Waste' would show only sample 'Prefeas 6'. Setting the lithology to 'Carbonates' and the alteration to 'Waste' would show no results (there are no samples that are simultaneously Carbonate and waste).

@@ Line 7: / Line 7: @@
 The mandatory field is:
 * '''Name''': the sample name, and must be entered exactly as it appears in the other testwork tables in order for the grouping functions to work properly.
 Automatically generated fields are:
 * '''#''': the position in the current table.  This value varies whenever the table sorting changes or when new data is entered.
 * '''Program''': the test program that this sample belongs to.
 An optional '''comment''' field is available for assigning other information to a record.  Examples of 'comment' information includes references to publications or drill hole dimensions (PQ, HQ).

@@ Line 5: / Line 5: @@
 [[file:LithoTable1.png|thumb|alt=Screenshot of sample table|Example data entry screen for the Sample definition table]]
-The mandatory fields are:
+The mandatory field is:
 * '''Name''': the sample name, and must be entered exactly as it appears in the other testwork tables in order for the grouping functions to work properly.
-The automatically generated fields are:
+Automatically generated fields are:
 * '''#''': the position in the current table.  This value varies whenever the table sorting changes or when new data is entered.
-* '''ProjNum''': the project number that this record belongs to.
+* '''Program''': the test program that this sample belongs to.
 An optional '''comment''' field is available for assigning other information to a record.  Examples of 'comment' information includes references to publications or drill hole dimensions (PQ, HQ).

@@ Line 1: / Line 1: @@
 ==The Sample Definition &amp; Litho database table==
-Sample names must be declared before test data may be attached to those samples.  The 'Sample' database table contains these sample name definitions and additional information about the sample, such as its geology or its locations within a section of drill core.
+Sample names must be declared before test data may be attached to those samples.  The 'Sample name' is declared in the database "Litho" table which contains these sample name definitions and additional information about the sample, such as its geology or its locations within a section of drill core.
 The optional geologic information is used to partition other test results into groups.  Those groups are commonly lithology, alteration, and zone.  The Litho table also cab contain optional drill hole information, for those samples derived from drill holes, that allow geologists to relate the spatial positions of grindability samples within geological models.

@@ Line 1: / Line 1: @@
-==The Litho database table==
+==The Sample Definition &amp; Litho database table==
 The mandatory fields are:
-* '''Sample''': the sample name, and must be entered exactly as it appears in the other testwork tables in order for the grouping functions to work properly.
+* '''Name''': the sample name, and must be entered exactly as it appears in the other testwork tables in order for the grouping functions to work properly.
 The automatically generated fields are:
 * '''#''': the position in the current table.  This value varies whenever the table sorting changes or when new data is entered.
 * '''ProjNum''': the project number that this record belongs to.
@@ Line 14: / Line 15: @@
 ===Grouping of samples===
 Three special fields in the Litho table can be used for grouping samples.  The names of these fields describe how they are typically used, but users are free to substitute other uses and are not restricted to entering the data described.
 * '''litho''' is usually the dominant lithology of a sample.  Examples are 'breccia', 'volcanic' or 'End member 1'.
@@ Line 23: / Line 23: @@
 ===Drill hole identification===
-[[file:LithoTable2.png|thumb|alt=Screenshot of an example Litho table|Example Litho table with drill hole information]]
+[[file:LithoTable_DDH.png|thumb|alt=Screenshot of sample table|Example drill hole data entered into the Sample definiton table]]
 Four optional special fields applicable to samples derived from drill core are:
 * '''drillhole''': the name or number of the drill hole that a sample was derived from.
-* '''from''' and '''to''': the down-hole positions where the sample starts and ends.  This value can be in the customary units of the project (metres, feet or other units).
+* '''dist_from''' and '''dist_to''': the down-hole positions where the sample starts and ends.  This value can be in the customary units of the project (metres, feet or other units).
 * '''length''' the overall length of the interval tested within the sample.  This is usually ''to'' minus ''from'', but could be smaller if, for example, only every second metre was sampled for grinding.
 It is customary to make each sample a single interval of a single drill hole.  Mixing material from different drill holes or from non-adjoining intervals is not recommended as geologists and geostatisticians will not be able to relate the grindability samples back into the geological models (for performing geometallurgical modelling).  See the [[Testwork#Planning a feasibility test program|commentary on test programs]] for more.