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.