The Minnesota County Well Index
Database Dictionary

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


Table: C5C1
This table conatains information describing the construction of the well. The c5c1 table has a one-to-one relationship to the c5ix (index) table.

 

Column Name

Type

Length

Precision

Scale

Null

Default

Code Table

Data Range

Description

RELATEID

CHAR

10

   

   

N

   

   

Primary Key and the Minnesota Unique Well Number.

DRILL_METH

CHAR

1

   

   

Y

   

DRILMETH

Drilling method.

DRILL_FLUD

CHAR

1

   

   

Y

   

DRILFLUD

Drilling fluid.

HYDROFRAC

CHAR

1

   

   

Y

   

LOGICAL

Was the well hydrofractured. The process of placing one or more packers into a bedrock formation and injecting potable water under pressures high enough to open existing fractures or create new fractures in the bedrock for the purpose of increasing the water yield

HFFROM

NUMBER

8

1

 

Y

   

   

Hydrofracture from depth in feet.

HFTO

NUMBER

8

1

 

Y

   

   

Hydrofracture to depth in feet.

CASE_MAT

CHAR

1

   

   

Y

   

CASEMTL

Casing material.

CASE_JOINT

CHAR

1

   

   

Y

   

CASEJNT

Casing jointing.  This is the method of jointing section of casing.

CASE_TOP

NUMBER

8

2

 

Y

   

   

The distance from the top of casing to the ground surface.

DRIVE_SHOE

CHAR

1

   

   

Y

   

LOGICAL

Indicates the presence (Y) or absence (N) of drive shoe.

CASE_TYPE

CHAR

1

   

   

Y

   

CASETYPE

Type of casing used.

SCREEN

CHAR

1

   

   

Y

   

LOGICAL

Indicates whether a screen is installed (Y), not installed (N) or not known (left blank).

OHTOPFEET

NUMBER

8

1

 

Y

   

   

If a well is not screened, this is the distance in feet from the ground surface to the top of the uncased interval.

OHBOTFEET

NUMBER

8

1

 

Y

   

   

If a well is not screened, this is the distance in feet from the ground surface to the bottom of the uncased interval. (usually the bottom of the hole).

SCREEN_MFG

CHAR

18

   

   

Y

   

   

The make, or manufacturer, of the screen installed in the hole.

SCREEN_TYP

CHAR

1

   

   

Y

   

SCRNTYPE

Type of screen installed in the hole.

PTLSS_MFG

CHAR

12

   

   

Y

   

   

The make, or manufacturer, of the pitless adapter.

PTLSS_MDL

CHAR

10

   

   

Y

   

   

The model name or number of the adapter.

BSMT_OFFST

CHAR

1

   

   

Y

   

LOGICAL

Indicates if the well was completed with a basement offset.

CSG_TOP_OK

CHAR

1

   

   

Y

   

LOGICAL

Indicates that the top of the well is at least 1 foot above the soil surface.

CSG_AT_GRD

CHAR

1

   

   

Y

   

LOGICAL

The well was completed at-grade (Environmental Wells and borings ONLY).

PLSTC_PROT

CHAR

1

   

   

Y

   

LOGICAL

Indicates that suitable protection has been provided for exposed casing if plastic casing has been used.

DISINFECTD

CHAR

1

   

   

Y

   

LOGICAL

Indicates if the well was disinfected (Y) or not (N) or blank is unknown.

PUMP_INST

CHAR

1

   

   

Y

   

LOGICAL

Indicates whether a pump is installed (Y ) or not (N) or information is unavailable (left

PUMP_DATE

NUMBER

8

0

 

Y

   

   

Date the pump was installed.

PUMP_MFG

CHAR

22

   

   

Y

   

   

The name of the pump manufacturer.

PUMP_MODEL

CHAR

13

   

   

Y

   

   

The model name or number of the pump installed.

PUMP_HP

NUMBER

8

2

2

Y

   

   

The horsepower rating of the pump.

PUMP_VOLTS

NUMBER

3

3

0

Y

   

   

The required voltage for the pump installed.

DROPP_LEN

NUMBER

8

1

1

Y

   

   

The length, in decimal feet, of the drop pipe.

DROPP_MAT

CHAR

1

   

   

Y

   

CASEMTL

The drop pipe material.

PUMP_CPCTY

NUMBER

6

2

 

Y

   

   

The rated capacity of the pump installed.

PUMP_TYPE

CHAR

1

   

   

Y

   

 PUMPTYPE  

Pump type used.

VARIANCE

CHAR

1

   

   

Y

   

   

Indicates if a variance was granted by MDH for the well.

DRLLR_NAME

CHAR

13

   

   

Y

   

   

The name of the person (not the company or agency) in charge of the drilling of the well.

ENTRY_DATE

NUMBER

8

0

 

Y

   

   

Date construction information was added.

UPDT_DATE

NUMBER

8

0

 

Y

   

   

Date construction information was modified.
OBJECTID NUMBER 38 0 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 0 N    
Minnesota Unique Well Number (Primary Key)


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