Table Name |
Field Name |
Begin Column |
Definition |
Valid Values |
Descriptions |
mcwiwells.shp |
Relateid |
|
Text, 10 |
e.g., 000190049, 000152240 |
These are the unique identifiers for the wells (Relate item with mcwistrat.dbf). |
|
Unique_no |
|
Text,8 |
e.g., 00190049, 00152240 |
Unique identifier for each
well |
|
Township |
|
Number,6,0 |
117 to 121 |
Public Land Survey Township Number |
|
Range |
|
Number,6,0 |
29 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). |
|
Depth2bdrk |
|
Number,9,2 |
e.g., 10, 71, 154,
510. -999 indicates no data. |
Describes the depth to the first bedrock encountered. Surface elevation minus bedrock elevation. |
mcwistrat.dbf |
|
|
|
|
Associated table for use
with mcwiwells.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 mcwiwells 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, SAND + CLAY +
GRAVEL, BOULDER |
The driller’s description,
interpreted stratigraphy. |