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.