The Minnesota County Well Index
Database Dictionary

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


Table: C5WL
Historic static water level readings.

 

Column Name

Type

Length

Precision

Scale

Null

Default

Code Table

Data Range

Description

C5WL_SEQ_NO

NUMBER

12

0

 

N

       

     

Primary Key

RELATEID

CHAR

10

       

       

N

       

       

Minnesota Unique Well Number    

MEAS_TYPE

CHAR

2

       

       

Y

       

MEASTYPE

What the SWL reading was taken for.

MEAS_DATE

NUMBER

8

0

 

Y

       

       

Date the static water level was taken. Year/Month/Day - YYYYMMDD

MEAS_TIME

NUMBER

8

0

 

Y

       

       

Time the static water level reading was taken. Hour:Minute:Second

M_PT_CODE

CHAR

1

       

       

Y

       

MEASPNT

Location the reading was taken.

MEAS_POINT

NUMBER

8

2

 

Y

       

       

Measuring point

MEASUREMT

NUMBER

8

2

 

Y

       

       

Depth in feet from the land surface to the water level.

MEAS_ELEV

NUMBER

8

2

 

Y

       

       

Static water level elevation. This is a calculated field (c5ix.elevation – c5wl.measurement).

DATA_SRC

 CHAR 5     Y   DATA_SRC Source providing the data.
PROGRAM CHAR 7     Y   PROGRAM Program the reading was taken for.
ENTRY_DATE NUMBER 8 0 0 Y     Date reading was entered. Year/Month/Day - YYYYMMDD
UPDT_DATE NUMBER 8 0 0 Y     Date reading was revised. Year/Month/Day - YYYYMMDD
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 and Foreign Key


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