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.