Table Name | Field Name | Begin Column | Definition | Valid Values | Descriptions
millcwiwells.shp | Relateid |  | Text, 10 | e.g., 000190049, 000152240 | Unique identifiers for the wells (Relate item with millcwistrat.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 in feet the depth to the first bedrock encountered.
| doh_path |  | Text, 100 | e.g., http://mdh-agua.health.state.mn.us/cwi/well_log.asp?wellid=0000732429 | A URL hyperlink that links, using ESRI software like ArcView 3.3 or ArcGIS 9, to the associated well’s information (i.e., stratigraphy, drillers description) displayed via the county well index online web page, provided by the Minnesota Department of Health. Some wells are not available on this site. More information about this page can be found at: http://www.health.state.mn.us/divs/eh/cwi/
millcwistrat.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 millcwiwells 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.