MSU Remote Sensing & GIS

FIELD DEFINITION LIST FOR Wells_ Hydraulic_ Properties shape file

May 25, 2005

WELLOGIC FIELDS

FIELD Description

ESRI

WELLID Wellogic ID number (unique identifying number, first 2 digits represent county number)

Alias: WELLID
Data type: String
Width: 11

IMPORT_ID Former Wellkey number

Alias: IMPORT_ID
Data type: String
Width: 11

COUNTY

Alias: COUNTY
Data type: String
Width: 30

TOWNSHIP

Alias: TOWNSHIP
Data type: String
Width: 30

TOWN_RANGE

Alias: TOWN_RANGE
Data type: String
Width: 30

SECTION

Alias: SECTION
Data type: Number
Width: 4

OWNER_NAME

Alias: OWNER_NAME
Data type: String
Width: 30

WELL_ADDR

Alias: WELL_ADDR
Data type: String
Width: 50

WELL_DEPTH

Alias: WELL_DEPTH
Data type: Number
Width: 9
Number of decimals: 2

WELL_TYPE Type of well

*OTH = Other

HEATP = Heat pump

HOSHLD = Household

INDUS = Industrial

IRRI = Irrigation

TESTW = Test well

TY1PU = Type I public

TY2PU = Type II public

TY3PU = Type III public

Alias: WELL_TYPE
Data type: String
Width: 6

WSSN Water Supply Serial Number, only if public well

Alias: WSSN
Data type: Number
Width: 10

WELL_NUM Individual well number/name, only if public well

Alias: WELL_NUM
Data type: String
Width: 30

DRILLER_ID State of Michigan Water Well Drilling Contractor Registration Number

Alias: DRILLER_ID
Data type: Number
Width: 6

CONST_DATE

Alias: CONST_DATE
Data type: String
Width: 23

CASE_TYPE Well Casing Type

*OTH = Other

*U = Unknown

CLTC = Clay Tile Crock

PVCPLA = PVC Plastic

STEBLA = Steel-black

STEGAL = Steel-Galvanized

Alias: CASE_TYPE
Data type: String
Width: 6

CASE_DIA Well Casing Diameter (in inches)

Alias: CASE_DIA
Data type: Number
Width: 9
Number of decimals: 2

CASE_DEPTH Depth of Casing (in feet)

Alias: CASE_DEPTH
Data type: Number
Width: 9
Number of decimals: 2

SCREEN_FRM Depth where the screen starts (in feet)

Alias: SCREEN_FRM
Data type: Number
Width: 9
Number of decimals: 2

SCREEN_TO Depth where the screen ends (in feet)

Alias: SCREEN_TO
Data type: Number
Width: 9
Number of decimals: 2

SWL Static Water Level (in feet)

Alias: SWL
Data type: Number
Width: 9
Number of decimals: 2

TEST_DEPTH Depth of drawdown when the well was developed (in feet)

Alias: TEST_DEPTH
Data type: Number
Width: 9
Number of decimals: 2

TEST_HOURS Duration of pumping when the well was developed (in hours)

Alias: TEST_HOURS
Data type: Number
Width: 8
Number of decimals: 2

TEST_RATE Rate of water flow when the well was developed (in Gallons per Minute)

Alias: TEST_RATE
Data type: Number
Width: 6

TEST_METHD Method used to develop the well

*U = Unknown

*OTH = Other

AIR = Air

BAIL = Bailer

PLUGR = Plunger

TSTPUM = Test Pump

Alias: TEST_METHD
Data type: String
Width: 6

Alias: GROUT
Data type: String
Width: 1

PMP_CPCITY Capacity of the pump installed in the well (in Gallons per Minute)

Alias: PMP_CPCITY
Data type: Number
Width: 6

Alias: LONGITUDE
Data type: Number
Width: 20
Number of decimals: 10

ADD DEM ELEVATION FIELDS

FIELD Description

DEPTH_FLAG [Data Problem Flag]

1 Well Depth = 0

2 Well_Depth < 25’ or Well_Depth > 1000’

ELEV_DEM Surface Elevation (in feet) from the MapImage USGS 30-meter DEM file

SWL_FLAG [Data Problem Flag]

1 SWL = 0

2 SWL > Well_Depth

3 SWL > 900’

CREATE ROCK & DRIFT WELL FIELDS

FIELD Description

AQ_CODE [Data Problem Flag]

N No Lithology Record

B Blank (null aqtype)

D Drift Well

R Rock Well

U Unknown Lithology

AQ_FLAG [Data Problem Flag] (must contain a Rock stratum)

N No lithology record

D Depth Condition (Well Depth <= Top of Rock)

AQ_CODE is set to “D”

L Lithology Problem (Drift under Rock)

S Screen Condition (Screen Depth > 0 and Screen Depth <= Well Depth)

AQ_CODE is set to “D”

PCT_AQ Percent AQ within well log

PCT_AQ_D Percent AQ within Drift strata

PCT_AQ_R Percent AQ within Rock strata

PCT_MAQ Percent MAQ within well

PCT_MAQ_D Percent MAQ within Drift strata

PCT_MAQ_R Percent MAQ within Rock strata

PCT_FLAG ? Bad Strata Thickness (strataDepth - strataThickness) <> prevDepth

> ((aqFeet / wellDepth) * 100) + ((maqFeet / wellDepth) * 100) > 100

ROCK_TOP Elevation (in feet) of bedrock surface

D_R_TYPE AQ Type for Drift / Rock interface

AA = AQ / AQ

MA = MA / AQ

AM = AQ / MAQ

SPC_CPCITY Specific Capacity {TEST_RATE / TEST_DEPTH}

Only calculate if [TEST_METHD] = BAIL, PLUGR, or TSTPUM

DRIFT AQUIFER PERCENT FIELDS (within Analysis Zone)

Qualifying confining unit: >= 5 feet CM or >= 10 feet PCM

Analysis Zone: from [SCREEN_TO] upward to

A) the bottom of a qualifying confining unit;

B) the SWL; or

C) the ground surface

FIELD Description

A_THICKNES Aquifer Thickness within Analysis Zone

A_PCT_AQ Percent AQ within Analysis Zone

A_PCT_MAQ Percent MAQ within Analysis Zone

A_PCT_PCM Percent PCM within Analysis Zone

A_PCT_CM Percent CM within Analysis Zone

A_PCT_NA Percent NA within Analysis Zone

A_HIT_SWL T = Analysis stopped because hit SWL

F = Analysis stopped because hit a qualifying confining unit

A_HIT_TOP [Data Problem Flag]

T = Analysis stopped because hit well elevation (surface)

A_HIT_ROCK [Data Problem Flag]

T = Analysis stopped because hit an “R” in AQTYPE

A_SC_LITH1 PRIMLITH code for dominant strata within screen zone

A_SC_LMOD1 LITHMOD code for dominant strata within screen zone

A_SC_LMAQ1 MAQTYPE code for dominant strata within screen zone

A_SC_LPCT1 Percent LITH1 for dominant strata within screen zone

A_SC_LITH2 PRIMLITH code for secondary strata within screen zone

A_SC_LMOD2 LITHMOD code for secondary strata within screen zone

A_SC_LMAQ1 MAQTYPE code for secondary strata within screen zone

A_SC_LPCT12 Percent LITH2 for secondary strata within screen zone

Check if well point is within PLSS section

FIELD Description

WITHIN_SEC Y Yes within 1,000’ buffer around land survey section

N No, well is not within section buffer area

Calculated values used in GWMAP Project for glacial deposits surfaces

FIELD Description

Drift Index Layers -Those layers that are flagged as aquifer layers then have the Drift Index calculated. The drift index is equal to three times the percentage of aquifer material, added to two times the percentage of marginal aquifer material, added to percentage of partial confining material. This sum is then divided by the percentage of representative aquifer material (((PCT_AQ_* x 3) + (PCT_MAQ_* x 2) + PCT_PCM_*)/PCT_*_Rep). The index has potential values between zero and three where zero is no drift material and where three is all drift material

DID Drift Index for the entire drift

Alias: DID
Data type: Number
Width: 7
Number of decimals: 1

DI1 Drift Index for Layer 1

Alias: DI1
Data type: Number
Width: 7
Number of decimals: 1

DI2 Drift Index for Layer 2

Alias: DI2
Data type: Number
Width: 7
Number of decimals: 1

DI3 Drift Index for Layer 3

Alias: DI3
Data type: Number
Width: 7
Number of decimals: 1

DI4 Drift Index for Layer 4

Alias: DI4
Data type: Number
Width: 7
Number of decimals: 1

DI5 Drift Index for Layer 5

Alias: DI5
Data type: Number
Width: 7
Number of decimals: 1

DI6 Drift Index for Layer 6

Alias: DI6
Data type: Number
Width: 7
Number of decimals: 1

DI7 Drift Index for Layer 7

Alias: DI7
Data type: Number
Width: 7
Number of decimals: 1

DI8 Drift Index for Layer 8

Alias: DI8
Data type: Number
Width: 7
Number of decimals: 1

DI9 Drift Index for Layer 9

Alias: DI9
Data type: Number
Width: 7
Number of decimals: 1

DI10 Drift Index for Layer 10

Alias: DI10
Data type: Number
Width: 7
Number of decimals: 1

DI11 Drift Index for Layer 11

Alias: DI11
Data type: Number
Width: 7
Number of decimals: 1

DI12 Drift Index for Layer 12

Alias: DI12
Data type: Number
Width: 7
Number of decimals: 1

DI13 Drift Index for Layer 13

Alias: DI13
Data type: Number
Width: 7
Number of decimals: 1

DIAQ Drift Index for the aquifer

Alias: DIAQ
Data type: Number
Width: 7
Number of decimals: 1

DIAQ2

Trends in the aquifer material within the well-The layers of the well are then compared to detect any trends in the aquifer material within the well. These are reported in two fields (Trend9 and Trend14). Trend9 represents detection of a change in the Drift Index, from the surface down, of .9 or more, Trend14 represents a change in the Drift Index of 1.4 or more. The trends have six labels associated with them. An “Up” trend indicates an increase in the drift index beyond the threshold (of .9 or 1.4) in every layer as the well goes deeper, a “Down” trend is the same but with a decreasing index. An “Upward” trend indicated that there are increases in the drift index between layers that pass the threshold in some, but not all layers. A “Downward” trend is the counterpart to the “Upward” but with a decreasing drift index. The “ZigZag” label indicates that there are layers in the well between which the drift index increases by more than the threshold and other layers where it decreases by more than the threshold. The final label is “None” which indicates that the Drift Index in the well does not increase or decrease beyond the threshold between any of the layers. The counts of usable layers, along with the number of times that the well had layers that passed each of the thresholds in either direction, are also included in the dataset.

Alias: DIAQ2
Data type: Number
Width: 7
Number of decimals: 1

Trend9 General trend when looking at change of at least .9 in the Drift Index (described above)

Alias: Trend9
Data type: String
Width: 10

Trend9_Up Number of instances where an increase of at least .9 occurred in the Drift Index between layers

Alias: Trend9_Up
Data type: Number
Width: 4

Trend9_Dn Number of instances where a decrease of at least .9 occurred in the Drift Index between layers

Alias: Trend9_Dn
Data type: Number
Width: 4

Trend14 General trend when looking at change of at least 1.4 in the Drift Index (described above)

Alias: Trend14
Data type: String
Width: 10

Trend14_Up Number of instances where an increase of at least 1.4 occurred in the Drift Index between layers

Alias: Trend14_Up
Data type: Number
Width: 4

Trend14_Dn Number of instances where a decrease of at least 1.4 occurred in the Drift Index between layers

Alias: Trend14_Dn
Data type: Number
Width: 4

Trend_All Number of layers where there was a Drift Index calculated

Alias: T_Drift
Data type: Number
Width: 19
Number of decimals: 7

SW_ELEV Static Water Elevation calculated by subtracting the Static Water Level (SWL) field from the DEM Elevation (ELEV_DEM) field.

LANDSYSTEM Values

LDSYSTEM Bedrock

Costal Dunes

Ice-contact outwash

Lacustrine Fine

Lacustrine Course

Lakes

Lodge Till of Fine superaglacial drift

Proglacial outwash

Thin drift over bedrock

Ice-marginal fill

Landsys 0 = Bedrock, Lacustrine Fine, Thin drift over bedrock

1 = Lacustrine Course, Lodge Till of Fine superaglacial drift, Ice-marginal fill

2 = Costal Dunes, Ice-contact outwash, Proglacial outwash

9 = Wells that did not fall inside Landsys 0, 1, or 2

Alias: SW_ELEV
Data type: Number
Width: 15
Number of decimals: 2

________________________________________________

Justin M. Booth, GISP
Remote Sensing and GIS Research and Outreach Services
Department of Geography
Michigan State University
(517) 432-0446
boothj@msu.edu Alias: AQ_B
Data type: Number
Width: 15
Number of decimals: 2