Table Name |
Field Name |
Begin Column |
Definition |
Valid Values |
Descriptions |
cwiwells.shp |
Relateid |
|
Text, 10 |
e.g., 0000102256, 0000524753 |
These are the unique identifiers for the wells (Relate item with cwistrat.dbf). |
|
Unique_no |
|
Text,8 |
e.g.,
00102256, 00524753 |
Unique
identifier for each well |
|
Township |
|
Number,6,0 |
109 to 114 |
Public Land Survey Township Number |
|
Range |
|
Number,6,0 |
23 to 31 |
Public Land Survey Range Number |
|
Section |
|
Number,6,0 |
1 to 36 |
Public Land Survey Section number |
|
Subsection |
|
Text, 6 |
e.g., ABBCAA, CABBAB, DCCBBC, DCDDD |
Subsection. Indicates from largest to smallest, the quarter, quarter-quarter, quarter-quarter-quarter, … (A = NE, B = NW, C = SW, D = SE). |
|
Dpth_bdrk |
|
Number,6,0 |
e.g., 10, 71,
154, 510. -999 indicates no data. |
Describes the depth to the first bedrock encountered. Surface elevation minus bedrock elevation. |
|
First_bdrk |
|
Text, 4 |
e.g., OPDC, CSTL, CJDN, NRCD |
Abbreviation
of the first bedrock unit encountered while drilling.
The First letter refers to the age of the rock type. (K-Cretaceous, O-Ordovician U – undifferentiated). See MGS CWI database for more details. |
cwistrat.dbf |
|
|
|
|
Associated
table for use with cwiwells.shp. Relate
the table with the shape on the field relateid. There
is a one-to-many relationship between the shapefile and this table. This table is a subset of the data stored in
the C4ST (i.e., driller’s description, interpreted stratigraphy) of the
MGS CWI database. |
|
Relateid |
|
Text, 10 |
e.g., 0000102256, 0000524753 |
These are the
unique identifiers for the wells (Relate item with cwiwells shapefile). |
|
Depth_top |
|
Number,11,0 |
e.g., 15,
100, 260, 420 |
Depth to the
top of the bedrock. |
|
Depth_bot |
|
Number,11,0 |
e.g., 1, 38,
117, 254, 818 |
Depth to
bottom of the bedrock |
|
Drillr_desc |
|
Text, 34 |
e.g., CLAY,
LIMESTONE, SAND + CLAY + LIMESTONE, SAND, SANDY CLAY, ST. LAWRENCE |
The driller’s
description, interpreted stratigraphy. |