The Minnesota County Well Index
Database Dictionary

Home   |   Table Relationships   |   Data Tables   |   Code Tables   |   Views   |   Data Entry


Table: C5ST
The stratigraphy table. The driller's description of geologic materials encountered while drilling the well and the geologist's corresponding geologic interpretation

 

Column Name

Type

Length

Precision

Scale

Null

Default

Code Table

Data Range

Description

C5ST_SEQ_NO

NUMBER

12

0

 

N

 

 

Primary Key

RELATEID

CHAR

10

 

 

N

 

 

Minnesota Unique Well Number.

DEPTH_TOP

NUMBER

5

0

 

Y

 

 

Depth to the top of the interval measured in feet from the land surface.

DEPTH_BOT

NUMBER

5

0

 

Y

 

 

Depth to the bottom of the interval measured in feet from the land surface.

DRLLR_DESC

VARCHAR2

34

 

 

Y

 

 

Geologic materials as described on the original well log reporting form for the interval whose top is at the DEPTH_TOP and whose bottom is at the DEPTH_BOT. Except for the correction of spelling errors, this should be the driller’s exact description for this depth interval.

COLOR

CHAR

8

 

 

Y

 

COLOR

Contains the color of the geologic materials as described by the driller.

HARDNESS

CHAR

8

 

 

Y

 

HARDNESS

Indicates the subjective hardness of the materials in the interval as reported by the driller. Occasionally the hardness is reported as range (soft to hard).

STRAT

CHAR

4

 

 

Y

 

STR_CODE

The interpreted stratigraphic unit. A 4-character code indicating the geologic unit to which the interval has been assigned by the interpreting geologist. No entry indicates that the log has not been geologically interpreted.
LITH_PRIM CHAR 4     Y   LTH_CODE

The interpreted primary lithology. A 4-character code indicating the most prevalent geologic material in the interval as assigned by the interpreting geologist.
LITH_SEC CHAR 4     Y   LTH_CODE

The secondary lithology. A 4-character code indicating the second most abundant geologic material in the interval assigned by the interpreting geologist. (see previous field).
LITH_MINOR CHAR 4     Y   LTH_CODE

The minor lithology. A 4-character code describing the third most abundant geologic material in the interval (see previous two fields).
OBJECTID NUMBER 38 0   N     An ObjectID is a unique, not null integer field used to uniquely identify rows in tables in a geodatabase
WELLID NUMBER 10 0   N     Minnesota Unique Well Number and Foreign Key


Home   |   Table Relationships   |   Data Tables   |   Code Tables   |   Views   |   Data Entry