DIC_VERTICAL_SCOPE
Dictionary of qualitative vertical extents, used to describe the vertical extent of geological information in a map, section, dataset, model etc.
| No. |
Column name |
Data type |
Notes |
| 1 |
CODE |
Varchar(5) |
Primary key
|
| 2 |
NAME |
Varchar(30) |
|
| 3 |
DESCRIPTION |
Varchar(500) |
|
| 4 |
TRANSLATION |
Varchar(50) |
|
| 5 |
STATUS |
Char(1) |
|
| 6 |
DATE_ENTERED |
Date |
|
| 7 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 8 of 8)
| CODE |
NAME |
DESCRIPTION |
TRANSLATION |
STATUS |
DATE_ENTERED |
DATE_UPDATED |
| 001 |
Superficial |
Deposits above Rockhead |
Superficial |
C |
09-JAN-04 |
|
| 002 |
DeepGeology |
Deposits at depth with little or no surface representation/outcrop |
DeepGeology |
C |
09-JAN-04 |
|
| 003 |
Moderate |
Solid Geology at Moderate depths - outcropping over large areas |
Moderate |
C |
09-JAN-04 |
|
| ? |
notEntered |
we have not assigned a value yet (and it might not be applicable) |
not entered |
C |
13-MAY-04 |
|
| ! |
notAvailable |
applicable, but try as we might, we cannot find a value |
not available |
C |
13-MAY-04 |
|
| - |
notApplicable |
not applicable |
not applicable |
C |
13-MAY-04 |
|
| 10096 |
Solid |
Deposits below rockhead |
Bedrock |
C |
05-OCT-04 |
10-APR-06 |
| 10095 |
Composite |
Deposits both above and below rockhead |
Composite |
C |
05-OCT-04 |
|
