Table Name

Field Name

Begin Column

Definition

Valid Values

Descriptions

carlcwiwells0607.shp

RELATEID

Text, 10

e.g., 000190049, 000152240

Unique identifiers for the wells (Relate item with carlcwistrat.dbf).

UNIQUE_NO

Text,8

e.g., 00190049, 00152240

Unique identifier for each well

TOWNSHIP

Number,9,0

117 to 121

Public Land Survey Township Number

RANGE

Number,9,0

29 to 31

Public Land Survey Range Number

SECTION

Number,9,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,19,11

e.g., 10, 71, 154, 510. 

-999 indicates no data.

Describes in feet the depth to the first bedrock encountered.

DOH_PATH

Text, 125

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/

carlcwistrat0607.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 carlcwiwells shapefile).

DEPTH_TOP

Number,19,5

e.g., 15, 100, 260, 420

Depth to the top of the bedrock.

DEPTH_BOT

Number,19,5

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.