DIC_SURFACE_TYPE
Dictionary table containing a hierarchical classification of Geological Surfaces, used in the DGSM Model database to describe surfaces which have been modelled, eg. Conformable Stratigraphic Boundary, Fault, Igneous Contact Boundary.
| No. |
Column name |
Data type |
Notes |
| 1 |
SURFACE_TYPE_CODE |
Varchar(4) |
Primary key
|
| 2 |
SURFACE_TYPE_DESCRIPTION |
Varchar(100) |
|
| 3 |
TRANSLATION |
Varchar(50) |
|
| 4 |
PARENT_SURFACE_TYPE_CODE |
Varchar(4) |
|
| 5 |
CLASSIFIABLE_IND |
Char(1) |
|
| 6 |
GIS_FEATURE_CLASS_TABLE |
Varchar(30) |
|
| 7 |
STATUS |
Char(1) |
|
| 8 |
STRUCTURAL_SURFACE_IND |
Varchar(1) |
|
| 9 |
VOLUME_BOUNDARY_IND |
Varchar(1) |
|
| 10 |
CONTOURPROPERTY_SURFACE_IND |
Varchar(1) |
|
| 11 |
ALTERNATIVE_GSD_FEATURE_DESC |
Varchar(100) |
|
| 12 |
DATE_ENTERED |
Date |
|
| 13 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 20 of 51)
| SURFACE_TYPE_CODE |
SURFACE_TYPE_DESCRIPTION |
TRANSLATION |
PARENT_SURFACE_TYPE_CODE |
CLASSIFIABLE_IND |
GIS_FEATURE_CLASS_TABLE |
STATUS |
STRUCTURAL_SURFACE_IND |
VOLUME_BOUNDARY_IND |
CONTOURPROPERTY_SURFACE_IND |
ALTERNATIVE_GSD_FEATURE_DESC |
DATE_ENTERED |
DATE_UPDATED |
| FA |
FOLD AXIS |
FOLD AXIS |
MTEC |
Y |
FOLD_AXIAL_PLANE_TRAC |
C |
Y |
|
|
FOLD AXIAL PLANE |
16-OCT-03 |
23-AUG-05 |
| SEA |
SEABED |
SEABED |
NONG |
Y |
BEDROCK_BOUNDARY |
C |
|
|
|
|
16-OCT-03 |
25-OCT-05 |
| JOTE |
TECTONIC JOINT |
TECTONIC JOINT |
JO |
Y |
|
C |
Y |
|
|
FAULT OR FRACTURE |
16-OCT-03 |
03-NOV-05 |
| FT |
FAULT OR FRACTURE |
FAULT OR FRACTURE |
MTEC |
Y |
FAULT_OR_FRACTURE_TRA |
C |
Y |
|
|
FAULT OR FRACTURE |
16-OCT-03 |
23-AUG-05 |
| SBGR |
GRADATIONAL STRATIGRAPHIC/BEDROCK BOUNDARY |
GRADATIONAL STRATIGRAPHIC/BEDROCK BOUNDARY |
SBCO |
Y |
BEDROCK_BOUNDARY |
C |
|
Y |
|
BEDROCK BOUNDARY |
16-OCT-03 |
09-MAY-05 |
| ALT |
ALTERNATION ZONE BOUNDARY |
ALTERNATION ZONE BOUNDARY |
GEOL |
Y |
ALTERATION_BOUNDARY |
C |
|
Y |
|
ALTERATION BOUNDARY |
16-OCT-03 |
09-MAY-05 |
| RH |
ROCKHEAD |
ROCKHEAD |
GEOL |
Y |
BEDROCK_BOUNDARY |
C |
|
|
|
BEDROCK BOUNDARY |
16-OCT-03 |
09-MAY-05 |
| UNC |
UNCONFORMITY |
UNCONFORMITY |
SB |
Y |
BEDROCK_BOUNDARY |
C |
Y |
Y |
|
BEDROCK BOUNDARY |
16-OCT-03 |
09-MAY-05 |
| CLEA |
CLEAVAGE PLANE |
CLEAVAGE PLANE |
MIST |
Y |
|
C |
Y |
|
|
|
16-OCT-03 |
09-MAY-05 |
| LOWW |
LOWER LIMIT OF WEATHERING |
LOWER LIMIT OF WEATHERING |
GEOL |
Y |
|
C |
|
|
|
|
16-OCT-03 |
09-MAY-05 |
| SBMK |
MARKED STRATIGRAPHIC/BEDROCK BOUNDARY |
MARKED STRATIGRAPHIC/BEDROCK BOUNDARY |
SBCO |
Y |
BEDROCK_BOUNDARY |
C |
Y |
Y |
|
BEDROCK BOUNDARY |
16-OCT-03 |
09-MAY-05 |
| SB |
STRATIGRAPHIC/BEDROCK BOUNDARY |
STRATIGRAPHIC/BEDROCK BOUNDARY |
SBU |
Y |
BEDROCK_BOUNDARY |
C |
|
Y |
|
BEDROCK BOUNDARY |
16-OCT-03 |
09-MAY-05 |
| ROOT |
ROOT |
ROOT |
|
N |
|
C |
|
|
|
|
16-OCT-03 |
09-MAY-05 |
| SBCO |
CONFORMABLE STRATIGRAPHIC BOUNDARY |
CONFORMABLE STRATIGRAPHIC BOUNDARY |
SB |
Y |
BEDROCK_BOUNDARY |
C |
|
Y |
|
BEDROCK BOUNDARY |
16-OCT-03 |
09-MAY-05 |
| MTEC |
MAJOR TECTONIC SURFACE |
MAJOR TECTONIC SURFACE |
GEOL |
Y |
FAULT_OR_FRACTURE_TRA |
C |
Y |
|
|
MAJOR PLANAR STRUCTURAL ELEMENT |
16-OCT-03 |
23-AUG-05 |
| MIST |
MINOR STRUCTURAL SURFACE |
MINOR STRUCTURAL SURFACE |
GEOL |
Y |
FAULT_OR_FRACTURE_TRA |
C |
Y |
|
|
|
16-OCT-03 |
03-NOV-05 |
| JO |
JOINT |
JOINT |
MIST |
Y |
|
C |
Y |
|
|
FAULT OR FRACTURE |
16-OCT-03 |
03-NOV-05 |
| JOCO |
COOLING JOINT |
COOLING JOINT |
JO |
Y |
|
C |
Y |
|
|
FAULT OR FRACTURE |
16-OCT-03 |
03-NOV-05 |
| IGBO |
IGNEOUS CONTACT BOUNDARY |
IGNEOUS CONTACT BOUNDARY |
GEOL |
Y |
BEDROCK_BOUNDARY |
C |
|
Y |
|
BEDROCK BOUNDARY |
16-OCT-03 |
09-MAY-05 |
| TOPO |
TOPOGRAPHIC (TERRAIN) SURFACE |
TOPOGRAPHIC (TERRAIN) SURFACE |
NONG |
Y |
|
C |
|
|
|
|
16-OCT-03 |
09-MAY-05 |
