The Minnesota County Well Index
Database Dictionary

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


Table: C5IX
The C5IX table often referred as the CWI Index table or the CWI Summery table ...
 

Column Name

Type

Length

Precision

Scale

Null

Default

Code Table

Data Range

Description
OBJECTID NUMBER 38 0   N   ArcSDE Managed An ObjectID is a unique, not null integer field used to uniquely identify rows in tables in a geodatabase

RELATEID

CHAR

10

 

 

N

 

 

Primary key.  Contains the Minnesota Unique well number

COUNTY_C

CHAR

2

 

 

Y

 

COUNTY

The County  code number.

UNIQUE_NO

VARCHAR2

8

 

 

Y

 

 

The Minnesota Unique Well Number.  Assigned by the Minnesota Department of Health.

WELLNAME

VARCHAR2

50

 

 

Y

 

 

Refers to the local name of the well (i.e. Anoka well #2) or the owner’s name for domestic wells.

TOWNSHIP

NUMBER

3

0

0

Y

 

 26-71 North, 101-168 North

Township number (north-south), from the Public Land Survey  System(PLSS).

RANGE

NUMBER

2

0

0

Y

 

 1-51 West, 1-7 East

Range number (east-west), from the Public Land Survey  System(PLSS).

RANGE_DIR

CHAR

1

 

 

Y

 

E-East, W-West

Range direction, east or west of the Principal Meridian for the Public Land  Survey  System(PLSS).

SECTION

NUMBER

2

0

0

Y

 

1-36

Section number with in the township and range.

SUBSECTION

VARCHAR2

6

 

 

Y

 

ABCD

Quarter section. Up to six quarter sections.  Largest quarter to smallest quarter.

MGSQUAD_C

CHAR

4

 

 

Y

 

MGSQUAD

Minnesota Geological Surveys 7.5 minute quadrangle code

ELEVATION

NUMBER

8

 0  

Y

 

 

Well elevation in feet above sea level

ELEV_MC

CHAR

3

 

 

Y

 

ELEV_MC

Code indicating the method for determining the well’s elevation.

STATUS_C

CHAR

1

 

 

Y

 

STATUS

The status of the well.

USE_C

CHAR

2

 

 

Y

 

USE

Code indicating the use of the well

LOC_MC

CHAR

1

 

 

Y

 

LOC_MC

MN Unique Well Number verification code.

LOC_SRC

CHAR

5

 

 

Y

 

 LOC_SRC

Well location source agency or group

DATA_SRC

CHAR

5

 

 

Y

 

DATA_SRC

The data source of the well information. This is usually the driller's license number.

DEPTH_DRLL

NUMBER

 8

2

0

Y

 

 

Depth Drilled - Deepest depth drilled in feet from land surface

DEPTH_COMP

NUMBER

8

2

0

Y

 

 

Depth Completed - Finished depth of the hole in feet.  Usually the same as depth drilled but can be less if the hole was backfilled before finishing.

DATE_DRLL

NUMBER

8

2

0

Y

 

 

Date well installation was complete.

CASE_DIAM

NUMBER

8

2

0

Y

 

 

Diameter in inches of the casing or smallest casing diameter in well, if multiple diameters are present.

CASE_DEPTH

NUMBER

8

2

0

Y

 

 

Depth in feet well is cased to.

GROUT

CHAR

1

 

 

Y

 

LOGICAL

Indicates if well is grouted.

POLLUT_DST

NUMBER

4

0

0

Y

 

 

Distance in feet to nearest potential source of contamination (barnyard, feed lot…)

POLLUT_DIR

CHAR

2

 

 

Y

 

 MAP_DIR

Direction to the nearest potential source of contamination.

POLLUT_TYP

CHAR

3

 

 

Y

 

 POLL_TYP

Code indicating the potential source of contamination referred above.

STRAT_DATE

NUMBER

8

0

0

Y

 

 

Date geologic interpretation was completed.

STRAT_UPD

NUMBER

8

0

0

Y

 

 

Date geologic interpretation was last updated

STRAT_SRC

CHAR

5

 

 

Y

 

 

Source (agency) of the geologic interpretation.

STRAT_GEOL

CHAR

3

 

 

Y

 

 STR_GEOL

Geologist responsible for the geologic interpretation.

STRAT_MC

CHAR

1

 

 

Y

 

 STR_METH

Geologic interpretation method code.  Indicates the general method by which the geologic interpretation was preformed.

DEPTH2BDRK

NUMBER

8

2

0

Y

 

 

Depth to Bedrock – Depth in feet from land surface where a bedrock geologic unit was encountered.

FIRST_BDRK

CHAR

4

 

 

Y

 

 STR_CODE

First bedrock stratigraphic unit code of the first bedrock geologic unit encountered.

LAST_STRAT

CHAR

4

 

 

Y

 

 STR_CODE

The last stratigraphic unit code encountered.

OHTOPUNIT

CHAR

4

 

 

Y

 

STR_CODE

Open (non-cased) interval – top stratigraphic unit code. The uppermost geologic unit open in the well (below the casing).

OHBOTUNIT

CHAR

4

 

 

Y

 

STR_CODE

Open interval – bottom stratigraphic unit code.  The lowermost geologic unit open in the well.

AQUIFER

CHAR

4

 

 

Y

 

AQUIFER

Aquifer unit code for the water-bearing permeable rock unconsolidated materials from which the well is drawing water from.

CUTTINGS

CHAR

1

 

 

Y

 

Y - Yes,  NULL

Indicates that a cutting sample data is available for the well.

CORE

CHAR

1

 

 

Y

 

 Y - Yes,  NULL

Indicates that a core sample data is available for the well.

BHGEOPHYS

CHAR

1

 

 

Y

 

 Y - Yes,  NULL

Borehole geophysics data is available for the well.

GEOCHEM

CHAR

1

 

 

Y

 

 Y - Yes,  NULL

Geochemistry data is available for the well.

WATERCHEM

CHAR

1

 

 

Y

 

 Y - Yes,  NULL

Water chemistry data exists for the well.

OBWELL

CHAR

1

 

 

Y

 

 Y - Yes,  NULL

Indicates that the well is part of the DNR observation well network (OBWELL).

SWL

CHAR

1

 

 

Y

 

 Y - Yes,  NULL

Static water level measurements exist of the well.

DH_VIDEO

CHAR

1

 

 

Y

 

Y - Yes,  NULL

Indicates that a down hole video log exists.

INPUT_SRC

CHAR

5

 

 

Y

 

 INPT_SRC

Agency or group that entered the well into the database.

UNUSED

CHAR

1

 

 

Y

 

 

Indicator  of the existance of any not in use and not sealed well(s) on the property (Y-yes, N-no)

ENTRY_DATE

NUMBER

8

0

0

Y

 

 

Date well was entered into the database.

UPDT_DATE

NUMBER

8

0

0

Y

 

 

Date the database was updated.

GEOC_TYPE

CHAR

2

 

 

Y

 

 

NOT USED

GCM_CODE

CHAR

3

 

 

Y

 

 GCMCODE

Method for obtaining the x,y coordinate locating the well.

GEOC_SRC

CHAR

5

 

 

Y

 

 GEOCSRC

Agency or group that entered the well coordinate location data.

GEOC_PRG

CHAR

7

 

 

Y

 

 GEOCPRG

Program that entered the well coordinate location data.

UTME

NUMBER

6

6

0

Y

 

 

The x coordinate of the well in meters, rounded to the meter.

UTMN

NUMBER

7

7

0

Y

 

 

The y coordinate of the well in meters, rounded to the meter.

GEOC_ENTRY

NUMBER

11

0

0

Y

 

GEOCENTRY 

The person who entered the well coordinate location data.

GEOC_DATE

NUMBER

8

0

0

Y

 

 

Date the well coordinate data was entered.

GEOCUPD_ENTRY

NUMBER

11

0

0

Y

 

 GEOCENTRY

The person that updated well coordinate location data

GEOCUPD_DATE

NUMBER

8

0

0

Y

 

 

Date the well coordinate location was updated.

RCVD_DATE

NUMBER

8

0

0

Y

 

 

Date the well driller’s log was received by the Minnesota Department of Health.

WELL_LABEL

VARCHAR2

10

 

 

Y

 

 

Minnesota Unique well number trimmend of leading zeros for map and report display.

SHAPE

NUMBER

38

 0

0

Y

NULL

 

Feature geometry (link to the F-table in the Geodatabase)


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