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.