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.