Grade Control Design

The following tables are optional.

Table Synonym Composition
Synonym Description

blast_solid_points

blast_solid_tris

Blast solid triangulation data.

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

Number

False

Northing

Number

False

Elevation

Number

False

report_existing_easting

Number

False

report_existing_northing

Number

False

report_existing_elevation

Number

False

report_holes_easting

Number

False

report_holes_northing

Number

False

report_holes_elevation

Number

False

report_bmodel_easting

Number

False

report_bmodel_northing

Number

False

report_bmodel_elevation

Number

False

report_gen_bmodel_easting

Number

False

report_gen_bmodel_northing

Number

False

report_gen_bmodel_elevation

Number

False

Note:  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.

blast_solid_points

point_no

Integer

True

Easting

Number

True

Northing

Number

True

Elevation

Number

True

blast_solid_tris

tri_no

Integer

True

point1

Integer

True

point2

Integer

True

point3

Integer

True

grade_block_solid_points

point_no

Integer

True

Easting

Number

 True

Northing

Number

 True

Elevation

Number

True

grade_block_solid_tris

tri_no

Integer

True

point1

Integer

True

point2

Integer

True

point3

Integer

True

string_header

string_no

Integer

True

string_type

Integer

True

string_points

string_no

Integer

True

point_no

Integer

True

Easting

Number

True

Northing

Number

True

Elevation

Number

True

poly_points

point_no

Integer

True

Easting

Number

True

Northing

Number

True

Elevation

Number

True

polygon_type

Integer

True

polygon_author

Text

True

grade_blocks

volume

Number

False

Easting

Number

False

Northing

Number

False

Elevation

Number

False

Easting_user

Number

False

Northing_user

Number

False

Elevation_user

Number

False

report_existing_easting

Number

False

report_existing_northing

Number

False

report_existing_elevation

Number

False

report_holes_easting

Number

False

report_holes_northing

Number

False

report_holes_elevation

Number

False

report_bmodel_easting

Number

False

report_bmodel_northing

Number

False

report_bmodel_elevation

Number

False

report_gen_bmodel_easting

Number

False

report_gen_bmodel_northing

Number

False

report_gen_bmodel_elevation

Number

False

Note:  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.

face_points

point_no

Integer

True

Easting

Number

True
Northing

Number

True

Elevation

Number

True

hole_collars

    

hole_no

Integer

True

Easting

Number

True

Northing

Number

True

Elevation

Number

True

InterceptDepth

Number

False

Bearing

Number

False

Inclination

Number

False

Note:  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).

block_model_grades

block_model

Integer

True

volume

Number

False

Note:  The volume field is used for optional volume storage.

block_model_grade_blocks

block_model

Integer

True

volume

Number

False

Note:  The volume field is used for optional volume storage.
Note

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 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.