Grade Control Design

The following tables are optional.

Table Synonym Composition

Synonym

Description

grade_block_solid_points
grade_block_solid_tris

Grade block triangulation data.

string_header

Grade block boundary polygon data.

string_points

Grade block boundary string data.

poly_points

Grade block polygon string data.

grade_blocks

Grade block data.

block_model_grades
block_model_grade_blocks

Reconciliation data.

hole_collars

Blast hole data.

face_points

Face point data (for display purposes only).

Field Synonym Composition
Synonym Type Compulsory

Header table
Easting
Northing
Elevation
report_existing_easting
report_existing_northing
report_existing_elevation
report_holes_easting
report_holes_northing
report_holes_elevation
report_bmodel_easting
report_bmodel_northing
report_bmodel_elevation
report_gen_bmodel_easting
report_gen_bmodel_northing
report_gen_bmodel_elevation

The Easting, Northing and Elevation fields are responsible for storing the blast solid centroid information which is required for blast selection by polygon. The remaining report fields under the Header table, for example report_existing_easting, report_holes_easting etc., are used to store the position of the onscreen blast report.


Number
Number
Number
Number
Number
Number
Number
Number
Number
Number
Number
Number
Number
Number
Number


False
False
False
False
False
False
False
False
False
False
False
False
False
False
False

blast_solid_points
point_no
Easting
Northing
Elevation


Integer
Number
Number
Number


True
True
True
True

blast_solid_tris
tri_no
point1
point2
point3


Integer
Integer
Integer
Integer


True
True
True
True

grade_block_solid_points
point_no
Easting
Northing
Elevation


Integer
Number
Number
Number


True
True
True
True

grade_block_solid_tris
tri_no
point1
point2
point3


Integer
Integer
Integer
Integer


True
True
True
True

string_header

string_no
string_type


Integer
Integer


True
True

string_points
string_no
point_no
Easting
Northing
Elevation


Integer
Integer
Number
Number
Number


True
True
True
True
True

poly_points
point_no
Easting
Northing
Elevation


Integer
Number
Number
Number


True
True
True
True

grade_blocks
volume
Easting
Northing
Elevation
Easting_user
Northing_user
Elevation_user
report_existing_easting
report_existing_northing
report_existing_elevation
report_holes_easting
report_holes_northing
report_holes_elevation
report_bmodel_easting
report_bmodel_northing
report_bmodel_elevation
report_gen_bmodel_easting
report_gen_bmodel_northing
report_gen_bmodel_elevation

The volume field is used for optional volume storage. The Easting, Northing and Elevation fields are used for grade block centroids, while the Easting_user, Northing_user and Elevation_user fields are used for user-defined centroids (label positions) The remaining report fields under the Header table, for example report_existing_easting, report_holes_easting etc., are used to store the position of the onscreen blast report.


Number
Number
Number
Number
Number
Number
Number
Number
Number
Number
Number
Number
Number
Number
Number
Number
Number
Number
Number


False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False

face_points
point_no
Easting
Northing
Elevation


Integer
Number
Number
Number


True
True
True
True

hole_collars
hole_no
Easting
Northing
Elevation
InterceptDepth
Bearing
Inclination

If the InterceptDepth field is not provided, then all depths will default to zero. If a Bearing field is not provided, then all hole bearings will default to zero (north). The Bearing field is not required for vertical holes. If an Inclination field is not provided, then all holes will default to vertical (pointing down).


Integer
Number
Number
Number
Number
Number
Number


True
True
True
True
False
False
False

block_model_grades
block_model
volume

The volume field is used for optional volume storage.


Integer
Number


True
False

block_model_grade_blocks
block_model
volume

The volume field is used for optional volume storage.


Integer
Number


True
False

Notes

  • Additional sample fields can be specified through using the Edit Configuration option.
  • Table and field names are arbitrary - only synonyms are used.
  • Not all tables are compulsory for a blockout estimation method to be valid.
  • In order to store triangulations, _points and _tris tables must both be present.
  • In the block_model_grade_blocks, block_model_grades and grade_blocks tables the volume variable, although not compulsory, will store volume when specified. Therefore, do not use volume to represent a different variable. Similarly depth, bearing and dip all represent depth, bearing and dip. You can, however, use rules to specify the values.
  • The string_header table must be present in order to use a polygon with the Create Grade Blocks option. If the table is not present, then there is no way for Grade Control to designate a string as a line or a polygon.