WELLOGIC Download Tool (version 3.1.1, July 2012) Field Definitions WELLOGIC 2.0 FIELDS (as downloaded from the Michigan Geographic Data Library) • WELLID : Wellogic ID number (unique identifying number, first 2 digits represent county number) * COUNTY • PERMIT_NUM : Well permit number as assigned by local health department * TOWNSHIP * TOWN * RANGE * SECTION * OWNER_NAME * WELL_ADDR * WELL_CITY * WELL_ZIP * WELL_DEPTH (in feet below land surface) • WELL_TYPE : Type of well *OTH = Other TESTW = Test well HEATP = Heat pump TY1PU = Type I public HOSHLD = Household TY2PU = Type II public INDUS = Industrial TY3PU = Type III public IRRI = Irrigation • WEL_STATUS : Status of well *OTH = Other ACT = Active INACT = Inactive PLU = Plugged / Abandoned • WSSN : Water Supply Serial Number, only if public well • WELL_NUM : Individual well number/name, only if public well • DRILLER_ID : Water Well Drilling Contractor Registration Number as assigned by State of Michigan • DRILL_METH : Method used to drill the well borehole *OTH = Other HOLROD = Hollow Rod AUGBOR = Auger/Bored JETTIN = Jetted CABTOO = Cable Tool ROTARY = Rotary CASHAM = Casing Hammer UNK = Unknown DRIVEN = Driven Hand * CONST_DATE : Construction date of well installation • CASE_TYPE : Well Casing Type *OTH = Other STEBLA = Steel-black CLTC = Clay Tile Crock STEGAL = Steel-Galvanized NONE = No casing STEUNK = Steel-Unknown PVCPLA = PVC Plastic UNK = Unknown • CASE_DIA : Well Casing Diameter (in inches) • CASE_DEPTH : Depth of Casing (in feet) • SCREEN_TOP : Depth where the screen starts (in feet) • SCREEN_BOT : Depth where the screen ends – screen bottom (in feet) • SWL : Static Water Level (in feet, below the ground surface) • FLOWING : Description of SWL in relation to ground surface Y = Flowing well (i.e., SWL above land surface) N = Not a flowing well (i.e., SWL blow land surface) *U = Unknown • AQ_TYPE : Aquifer type (Unreliable – see AQ_CODE) DRIFT = Well draws water from the glacial drift ROCK = Well draws water from the bedrock *UNK = Unknown • TEST_DEPTH : Depth of drawdown when the well was developed (in feet) • TEST_HOURS : Duration of pumping when the well was developed (in hours) • TEST_RATE : Rate of water flow when the well was developed (in Gallons per Minute) • TEST_METHD : Method used to develop the well *U = Unknown BAIL = Bailer *OTH = Other PLUGR = Plunger AIR = Air TSTPUM = Test Pump • GROUT : Whether the well was grouted or not 0 = No 1 = Yes * PMP_CPCITY : Capacity of the pump installed in the well (in Gallons per Minute) * LATITUDE (in decimal degrees; positive values used for northern hemisphere) * LONGITUDE (in decimal degrees; negative values used for western hemisphere) • METHD_COLL : Method of collection of the latitude/longitude coordinates 001 = Address Matching-House Number 002 = Address Matching-Street Centerline 004 = Address Matching-Nearest Intersection 012 = GPS Carrier Phase Static Relative Position Tech. 014 = GPS Code Measurement Differential (DGPS) 015 = GPS Precise Positioning Service 016 = GPS Code Meas. Std. Positioning Svc. SA Off 018 = Interpolation-Map 019 = Interpolation-Aerial Photo 025 = Classical Surveying Techniques • ELEVATION (in feet, above mean sea level) * ELEV_METHD : Method of collection of the elevation 003 = GPS Code Measurement Differential (DGPS) 005 = GPS Code Meas. Std. Positioning Svc. SA Off 007 = Classical Surveying Techniques 014 = Topographic Map Interpolation OTH = Other UNK = Unknown NEW FIELDS ADDED BY THE RS&GIS DOWNLOAD TOOL See Appendix A - Landsystem Groups See Appendix B - Hydraulic Conductivity Assignments to all Lithologies See Appendix C - Hydraulic Conductivity Modifier Factors See Appendix D - Calculation of the Equivalent Horizontal and Vertical Hydraulic Conductivities Style legend [SCREEN_BOT]: Enhanced database field name layerbottom: internal code variable name AND: boolean logic function * WITHIN_SEC Y Yes, well point is within the stated land survey section N No, well is not within buffer for the stated land survey section * LOC_MATCH Y Yes, well point is within the stated Tier/Range N No * SEC_DIST 200-NO (the well point is more than 200 ft outside of the stated land survey section) 200-YES (the well point is within 200 ft of the stated land survey section) * ELEV_DEM (in feet, above mean sea level; from USGS NED – 10 m cell version December, 2009) * ELEV_DIF Absolute difference in feet between ELEVATION and ELEV_DEM] * LANDSYS : The Landsystem Group polygon that the well falls within Group 1: Lacustrine Fine Group 2: Ice-Marginal Till, Lacustrine Coarse and Lodgement Till or Fine Supraglacial Drift Group 3: Coastal Dunes, Ice-Contact Outwash and Proglacial Outwash * DEPTH_FLAG 1 [WELL_DEPTH] = 0 2 [WELL_DEPTH] <25 ft OR [WELL_DEPTH] > 1000 ft * ELEV_FLAG 1 [Elevation] (Wellogic field) = 0 2 [Elevation] (Wellogic field) < 507 ft OR >1980 ft 3 [Elevation] (Wellogic field) < DEMmin OR >DEMmax (USGS NED – 10 m cell version December, 2009) 4 [ELEV_DIF] > 20 ft * SWL_FLAG 1          [SWL] = 0 2          [SWL] >= [WELL_DEPTH] in a Bedrock well OR [SWL] >= [SCREEN_BOT] in a Glacial well 3          [SWL] > 900’ * SPC_CPCITY Specific Capacity = ([TEST_RATE] / [TEST_DEPTH]) Only calculated if [TEST_METHD] = BAIL, PLUGR or TSTPUM * AQ_CODE N         No Lithology Record associated with the well record B         Blank (null [AQTYPE]) noted among the strata D         Drift (Glacial) Well R         Rock Well U         Unknown Lithology noted among the strata * PROCESSING NOTE – This evaluation reads the [AQTYPE] field for each stratum from the LITHOLOGY table, beginning at the top and looping down to each subjacent stratum. If the previous stratum = ‘R’ AND the bottommost stratum = ‘R’, then [AQ_CODE] is set to ‘R’. If the previous stratum = ‘R’ AND the next stratum = ‘D’, then [AQ_CODE] is set to ‘D’ and [AQ_FLAG] is set to ‘L’. If aType = ‘R’ AND screendepth > 0 R’ AND screendepth <= welldepth, then [AQ_CODE] is set to ‘D’ and [AQ_FLAG] is set to ‘S’. If aType = ‘R’ AND welldepth <= topofrock, then [AQ_CODE] is set to ‘D’ and [AQ_FLAG] is set to ‘D’. * ROCK_TOP (in feet, depth below land surface, derived from LITH table analysis) FOR GLACIAL WELLS ONLY * AQ_THK_1 Summed thickness of all drift strata (i.e., AQ, MAQ, PCM and CM) from [SCREEN_BOT] upward to: A) the bottom of a qualifying confining unit (>= 5 feet CM or >= 10 feet PCM); else B) the SWL (if [SWL] > 0 AND [SWL] < [SCREEN_BOT] AND [SWL] <= 999); else C)    the ground surface * PROCESSING NOTE – If [SCREEN_BOT] <= layerbottom for seqnum1 (the bottommost layer), AND seqnum1 = PCM OR seqnum1 = CM (i.e., the screen bottoms out in a PCM or CM unit), the analysis for a qualifying confining unit moves up to the next strata in order to prevent this circumstance from generating an [AQ_THK_1] = 0. The code performs a “layer-clip” function in the case where [SCREEN_BOT] is within a PCM or CM strata, but the [SCREEN_TOP] is in an AQ or MAQ strata, counting upward from layerbottom of bottommost AQ or MAQ strata in the screened interval, rather than counting upward from [SCREEN_BOT], which is the normal logic. * AQ_THK_2 Summed thickness of all drift strata (i.e., AQ, MAQ, PCM and CM) from [SCREEN_BOT] upward to: A) the SWL (if [SWL] > 0 AND [SWL] < [SCREEN_BOT] AND [SWL] <= 900); else B)    the ground surface * H_COND_1 “Confined” equivalent horizontal hydraulic conductivity for sediments in a glacial well. [H_COND_1] uses [AQ_THK_1] for B (see Appendix D) * H_COND_2 “Unconfined” equivalent horizontal hydraulic conductivity for sediments in a glacial well. [H_COND_2] uses [AQ_THK_2] for B (see Appendix D) * V_COND_1 “Confined” equivalent vertical hydraulic conductivity for sediments in a glacial well. [V_COND_1] uses [AQ_THK_1] for B (see Appendix D) * V_COND_2 “Unconfined” equivalent vertical hydraulic conductivity for sediments in a glacial well. [V_COND_2] uses [AQ_THK_2] for B (see Appendix D) * TRANSMSV_1 “Confined” equivalent transmissivity for sediments in a glacial well. [H_COND_1] * [AQ_THK_1] * TRANSMSV_2 “Unconfined” equivalent transmissivity for sediments in a glacial well. [H_COND_2] * [AQ_THK_2] FOR GLACIAL PORTION OF BEDROCK WELLS * AQ_THK_D Summed thickness of all drift strata (i.e., AQ, MAQ, PCM and CM) from [ROCK_TOP] to the ground surface. * H_COND_D Equivalent horizontal hydraulic conductivity for glacial sediments in a bedrock well. [H_COND_D] uses [AQ_THK_D] for B (see Appendix D) * V_COND_D Equivalent vertical hydraulic conductivity for glacial sediments in a bedrock well. [V_COND_D] uses [AQ_THK_D] for B (see Appendix D) * TRANS_D Equivalent transmissivity for glacial sediments in a bedrock well. [H_COND_D] * [AQ_THK_D] FOR BEDROCK PORTION OF BEDROCK WELLS * B_AQ_THK Summed thickness of all bedrock strata (i.e., AQ, MAQ, PCM and CM) from [WELL_DEPTH] upward to [ROCK_TOP]. * B_H_COND Equivalent horizontal hydraulic conductivity for Bedrock Units. [B_H_COND] uses [B_AQ_THK] for B (see Appendix D) * B_V_COND Equivalent vertical hydraulic conductivity for Bedrock Units. [B_V_COND] uses [B_AQ_THK] for B (see Appendix D) * B_TRANS Equivalent transmissivity for Bedrock Units. [B_H_COND] * [B_AQ_THK] Additional Data quality flags * AQ_FLAG                          U         Unknown lithologies (i.e, Hyd. Cond. = 999999, so no values are calculated for [B_H_COND], [B_V_COND] or [B_TRANS]) D         Depth Condition: [WELL_DEPTH] <= [ROCK_TOP] so [AQ_CODE] was set to “D”        L          Lithology Problem (a Glacial stratum was encountered below a Rock stratum) S          Bottommost stratum is ‘R’ AND [SCREEN_TO] > 0 AND [SCREEN_TO] <= [WELL_DEPTH], so [AQ_CODE] was set to “D” (this traps for Glacial wells that were “over-bored” into the rock, but a screen was set in the glacial package) * SCRN_FLAG 1 [SCREEN_TOP] < 1 OR [SCREEN_BOT] <1 2 [SCREEN_BOT] <= layerbottom AND (lithmaq = PCM OR lithmaq = CM) 3 [SCREEN_TOP] >= layerbottom * NOTES “0 thickness in well lithology file” Appendix A. Landsystem Groups Hydraulic conductivity groups for each landsystem (Group 1 = low transmissivity; Group 2 = intermediate transmissivity; Group 3 = high transmissivity). LANDSYSTEM GROUP LACUSTRINE FINE 1 ICE-MARGINAL TILL 2 LACUSTRINE COARSE 2 LODGE TILL OR FINE SUPRAGLACIAL DRIFT 2 COASTAL DUNES 3 ICE-CONTACT OUTWASH 3 PROGLACIAL OUTWASH 3 Appendix B. (Updated values for bedrock units from Brant Fisher (Jul 7, 2011) Hydraulic Conductivity by Landsystem Group (feet per day) LITHOLOGY HYDRAULIC CONDUCTIVITY GROUP 1 HYDRAULIC CONDUCTIVITY GROUP 2 HYDRAULIC CONDUCTIVITY GROUP 3 BASALT 0.033 0.033 0.033 BOULDERS 100 100 300 CLAY 0.0001 0.0001 0.0001 CLAY&BOULDERS 0.0001 0.0001 0.01 CLAY&COBBLES 0.0001 0.0001 0.0001 CLAY&GRAVEL 0.00032 0.001 0.01 CLAY&SAND 0.00032 0.01 0.01 CLAY&SILT 0.0001 0.0001 0.0001 CLAY&STONES 0.0001 0.001 0.01 CLAYGRAVELSAND 0.001 0.01 0.01 CLAYGRAVELSILT 0.001 0.01 0.01 CLAYGRAVELSTONES 0.001 0.01 0.01 CLAYSANDGRAVEL 0.001 0.01 0.01 CLAYSANDSILT 0.001 0.01 0.01 CLAYSILTGRAVEL 0.001 0.01 0.01 CLAYSILTSAND 0.001 0.01 0.01 COAL 0.12 0.12 0.12 COBBLES 50 100 300 CONGLOMERATE 0.001 0.001 0.001 DEBRIS 1 1 1 DOLOMITE 0.0033 0.0033 0.0033 DOLOMITE&LIMESTONE 1.0 1.0 1.0 DOLOMITE&SANDSTONE 2.0 2.0 2.0 DOLOMITE&SHALE 0.0015 0.0015 0.0015 DRYHOLE 999999 999999 999999 GRANITE 0.001 0.001 0.001 GRAVEL 50 100 300 GRAVEL&BOULDERS 50 100 300 GRAVEL&CLAY 0.01 0.01 0.01 GRAVEL&COBBLES 50 100 300 GRAVEL&SAND 1 50 100 GRAVEL&SILT 1 1 1 GRAVEL&STONES 50 100 300 GRAVELCLAYSAND 0.01 0.01 0.01 GRAVELCLAYSILT 0.01 0.01 0.01 GRAVELSANDCLAY 0.01 0.01 0.01 GRAVELSANDSILT 1 1 1 GRAVELSILTCLAY 0.01 0.01 0.01 GRAVELSILTSAND 0.01 0.01 0.01 GREENSTONE 0.0001 0.0001 0.0001 GYPSUM 0.001 0.001 0.001 HARDPAN 0.001 0.001 0.001 INTERVALNOTSAMPLED 999999 999999 999999 LITHOLOGY HYDRAULIC CONDUCTIVITY GROUP 1 HYDRAULIC CONDUCTIVITY GROUP 2 HYDRAULIC CONDUCTIVITY GROUP 3 IRONFORMATION 0.0001 0.0001 0.0001 LIMESTONE 3.0 3.0 3.0 LIMESTONE&DOLOMITE 1.0 1.0 1.0 LIMESTONE&SANDSTONE 4.0 4.0 4.0 LIMESTONE&SHALE 0.5 0.5 0.5 LITHOLOGYUNKNOWN 999999 999999 999999 LOAM 0.1 0.1 0.1 MARL 0.1 0.1 0.1 MUCK 0.1 0.1 0.1 MUD 0.1 0.1 0.1 NOLITHOLOGYINFORMATION 999999 999999 999999 NOLOG 999999 999999 999999 PEAT 0.1 0.1 0.1 QUARTZ 0.0001 0.0001 0.0001 QUARTZITE 0.0001 0.0001 0.0001 SAND 1 50 100 SAND&BOULDERS 1 50 100 SAND&CLAY 0.0001 0.1 1 SAND&COBBLES 1 50 100 SAND&GRAVEL 1 50 100 SAND&SILT 1 1 10 SAND&STONES 1 50 100 SANDCLAYGRAVEL 0.1 0.1 1 SANDCLAYSILT 0.1 0.1 1 SANDGRAVELCLAY 0.1 0.1 10 SANDGRAVELSILT 0.1 0.1 10 SANDSILTCLAY 0.1 0.1 1 SANDSILTGRAVEL 0.1 0.1 1 SANDSTONE 5.0 5.0 5.0 SANDSTONE&LIMESTONE 3.0 3.0 3.0 SANDSTONE&SHALE 2.0 2.0 2.0 SCHIST 0.66 0.66 0.66 SEECOMMENTS 999999 999999 999999 SHALE 0.0001 0.0001 0.0001 SHALE&COAL 0.001 0.001 0.001 SHALE&LIMESTONE 0.5 0.5 0.5 SHALE&SANDSTONE 2.0 2.0 2.0 SHALESANDSTONELIMESTONE 1.0 1.0 1.0 SILT 0.1 1 1 SILT&BOULDERS 0.1 1 1 SILT&CLAY 0.0001 0.001 0.01 SILT&COBBLES 0.1 1 1 SILT&GRAVEL 0.1 1 1 SILT&SAND 0.1 1 1 SILT&STONES 0.1 1 1 SILTCLAYGRAVEL 0.1 1 1 SILTCLAYSAND 0.1 1 1 LITHOLOGY HYDRAULIC CONDUCTIVITY GROUP 1 HYDRAULIC CONDUCTIVITY GROUP 2 HYDRAULIC CONDUCTIVITY GROUP 3 SILTGRAVELCLAY 0.1 1 1 SILTGRAVELSAND 0.1 1 1 SILTSANDCLAY 0.1 1 1 SILTSANDGRAVEL 0.1 1 1 SLATE 0.00026 0.00026 0.00026 SOAPSTONE 0.00026 0.00026 0.00026 SOAPSTONE[TALC] 0.00026 0.00026 0.00026 STONES 1 10 100 TALC 0.00026 0.00026 0.00026 TOPSOIL 0.1 1 1 UNIDENTIFIEDCONSOLIDATEDFM 999999 999999 999999 VOID 999999 999999 999999 Appendix C. Hydraulic Conductivity Modifier Factors Glacial Aquifers AFTER the Hydraulic Conductivity “root value” by Landsystem Group has been determined (Appendix B), that K is multiplied by the following factors: If lithClass = "AQ" AND lithMAQ = "MAQ" Then factor = 0.1 (i.e., reduce K to 1/10th its root value) If lithClass = "MAQ" AND lithMAQ = "AQ" Then factor = 10 (i.e., increase the root value of K by10x)                                          If lithClass = "MAQ" AND lithMAQ = "PCM" Then factor = 0.1                                          If lithClass = "PCM" AND lithMAQ = "MAQ" Then factor = 10                                          If lithClass = "PCM" AND lithMAQ = "CM" Then factor = 0.1                                          If lithClass = "CM" AND lithMAQ = "PCM" Then factor = 10                                          Note: each of the following secondary descriptors was classed as “No Effect” in the SWAP protocol, so the “MAQTYPE” field in the LITH file will equal the “AQTYPE” field. These factors change that. If PRIM_LITH = "SAND" AND                                              LITH_MOD = "VERY FINE" Then factor = 0.25 LITH_MOD = "FINE" Then factor = 0.5 LITH_MOD = "FINE TO MEDIUM" Then factor = 0.5                                              LITH_MOD = "COARSE" Then factor = 2                                              LITH_MOD = "MEDIUM TO COARSE" Then factor = 2 If “PRIM_LITH” = "SAND & GRAVEL" AND "LITH_MOD" = "COARSE" Then factor = 2                                              Bedrock Aquifers (Updated values for bedrock units from Brant Fisher (Jul 7, 2011) If PRIM_LITH = BASALT OR CONGLOMERATE OR DOLOMITE OR DOLOMITE&LIMESTONE OR DOLOMITE&SANDSTONE OR DOLOMITE&SHALE OR GRANITE OR GREENSTONE OR GYPSUM OR IRONFORMATION OR LIMESTONE OR LIMESTONE&DOLOMITE OR LIMESTONE&SANDSTONE OR LIMESTONE&SHALE OR QUARTZ OR QUARTZITE OR SANDSTONE OR SANDSTONE&LIMESTONE OR SANDSTONE&SHALE OR SCHIST OR SHALE OR SHALE&COAL OR SHALE&LIMESTONE OR SHALE&SANDSTONE OR SHALESANDSTONELIMESTONE OR SLATE OR SOAPSTONE OR SOAPSTONE[TALC] OR TALC AND LITH_MOD = "CEMENTED" Then factor = 0.5 “DIRTY” “FINE” “MUDDY” “W/SHALE” LITH_MOD = "BROKEN" Then factor = 100 “FRACTURED” “KARST” “POROUS” “WEATHERED” Appendix D. Calculation of the Equivalent Horizontal and Vertical Hydraulic Conductivities * [H_COND_1] and [V_COND_1] use [AQ_THK_1] for B * [H_COND_2] and [V_COND_2] use [AQ_THK_2] for B * [H_COND_D] and [V_COND_D] use [AQ_THK_D] for B * [B_H_COND] and [B_V_COND] use [B_AQ_THK] for B 1 Field Definitions: Wellogic Download Tool (version 3.1.1 - July 2012)