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,11,0 |
109 to 114 |
Public Land Survey Township Number |
|
Range |
|
Number,11,0 |
23 to 31 |
Public Land Survey Range Number |
|
Section |
|
Number,11,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,11,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, 6,0 |
e.g., 15, 100, 260, 420 |
Depth to the top of the
bedrock. |
|
Depth_bot |
|
Number,6,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. |