Water Wells - South Central & Southeastern Michigan [Michigan] Full Details

Full Details

Title:

Water Wells - South Central & Southeastern Michigan [Michigan]

Description:

The data inthese six filesis derived from Wellogic, the EGLE statewide ground water database. The six files combined contain information on over 575,000 spatially verified water well records. The six files are intended to provide water well information for wells in counties clustered by geographic region: Upper Peninsula, Northern Lower Peninsula, East Central Lower Peninsula, West Central Lower Peninsula, Southwest Lower Peninsula and the South Central - Southeastern Lower Peninsula. The files are constructed to be easily merged, containing the same number and type of attribute fields.Although the derived data in these files represents the best readily available data, the six files do not represent a complete database of all wells or well records in existence. Beginning January 1, 2000 virtually 100% of new wells constructed are accounted for in Wellogic, however for wells older than 2000 the rate of inclusion varies from county to county, and may be considerably lower.Further, there is a quality control check on location that may exclude a limited number of wells from Wellogic from the six files made available on this site. The locational data also has varying degrees of accuracy; ranging from precise GPS point collection to address geocoding, but there may also be erroneous locations regardless of collection method that have not been corrected as of yet. Refer to the METHD_COLLfieldto determine each individual record's potential locational accuracy. Field codes described below.------------------------------------------------------------------------------------------Field Definitions:WELLID : Wellogic ID number (unique identifying number, first 2 digits represent county number)PERMIT_NUM : Well permit number as assigned by local health departmentWELL_TYPE : Type of wellOTH = OtherHEATP = Heat pumpHOSHLD = HouseholdINDUS = IndustrialIRRI = IrrigationTESTW = Test wellTY1PU = Type I publicTY2PU = Type II publicTY3PU = Type III publicTYPE_OTHER : Type of well if WELL_TYPE is 'OTH'WEL_STATUS : Status of wellOTH = OtherACT = ActiveINACT = InactivePLU = Plugged/AbandonedSTATUS_OTH : Status of well if WEL_STATUS is 'OTH'WSSN : Water Supply Serial Number, only if public wellWELL_NUM : Individual well number/name, only if public wellDRILLER_ID : Water Well Drilling Contractor Registration Number as assigned by State of MichiganDRILL_METH : Method used to drill the well boreholeOTH = OtherAUGBOR = Auger/BoredCABTOO = Cable ToolCASHAM = Casing HammerDRIVEN = Driven HandHOLROD = Hollow RodJETTIN = JettedMETH_OTHER : Method used to drill if DRILL_METH is 'OTH'CASE_TYPE : Well casing typeOTH = OtherUNK = UnknownPVCPLA = PVC PlasticSTEBLA = Steel-blackSTEGAL = Steel-GalvanizedCASE_OTHER : Well casing type is CASE_TYPE is 'OTH'CASE_DIA : Well Casing Diameter (in inches)CASE_DEPTH : Depth of Casing (in feet)SCREEN_FRM : Depth of top of screen (in feet)SCREEN_TO : Depth of bottom of screen (in feet)SWL : Depth of Static Water Level (in feet)FLOWING : Naturally flowing well (Y or N)AQ_TYPE : Aquifer typeDRIFT = Well draws water from the glacial driftROCK = Well draws water from the bedrockDRYHOL = Dry hole, well did not produce waterUNK = UnknownTEST_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 wellUNK = UnknownOTH = OtherAIR = AirBAIL = BailerPLUGR = PlungerTSTPUM = Test PumpTEST_OTHER : Method used to develop the well if TEST_METHD is 'OTH'GROUT : Whether the well was grouted or notPMP_CPCITY : Capacity of the pump installed in the well (in Gallons per minute)METHD_COLL : Method of collection of the latitude/longitude coordinates001 = Address Matching-House Number002 = Address Matching-Street Centerline004 = Address Matching-Nearest Intersection012 = GPS Carrier Phase Static Relative Position Tech.013 = GPS Carrier Phase Kinematic Relative Position Tech.014 = GPS Code Measurement Differential (DGPS)015 = GPS Precise Positioning Service016 = GPS Code Meas. Std. Positioning Service SA Off017 = GPS Std. Positioning Service SA On018 = Interpolation-Map019 = Interpolation-Aerial Photo020 = Interpolation-Satellite Photo025 = Classical Surveying Techniques027 = Section centroid028 = TownRange centroid036 = Quarter-Quarter-Quarter centroidELEV_METHD : Method of collection of the elevation003 = GPS Code Measurement Differential (DGPS)005 = GPS Code Meas. Std. Positioning Svc. SA Off007 = Classical Surveying Techniques014 = Topographic Map InterpolationOTH = OtherUNK = UnknownWITHIN_CO: Whether the well is within the stated countyWITHIN_SEC: Whether the well is within the stated land survey sectionLOC_MATCH: Whether the well is within the stated Tier/RangeSEC_DIST: Whether the well point is within 200 feet of the stated land survey sectionELEV_DEM: Elevation in feet above mean sea levelELEV_DIF: Absolute difference, in feet, between ELEVATION and ELEV_DEMLANDSYS: The Land System Group polygon that the well falls withinDEPTH_FLAG:1: WELL_DEPTH = 02: WELL_DEPTH < 25ft or WELL_DEPTH > 1000ftELEV_FLAG:1: ELEVATION (Wellogic Field) =02: ELEVATION (Wellogic Field) < 507ft OR > 1980ft3: ELEVATION (Wellogic Field) < DEM min OR > DEM max4: ELEV_DIF > 20 ftSWL_FLAG:1: SWL = 02: SWL >= WELL_DEPTH in a Bedrock well OR SWL >= SCREEN_BOT in a Glacial well3: SWL > 900ftSPC_CPCITY: Specific Capacity = (TEST_RATE / TEST_DEPTH). Only calculated if TEST_METHD = BAIL, PLUGR or TSTPUMAQ_CODE:N: No Lithology Record associated with the well recordB: Blank (AQTYPE = null) noted among the strataD: Drift (Glacial) WellR: Rock WellU: 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'ANDthe bottommost stratum = ‘R', then [AQ_CODE] is set to ‘R'. If the previous stratum = ‘R'ANDthe next stratum = ‘D', then [AQ_CODE] is set to ‘D' and [AQ_FLAG] is set to ‘L'. IfaType= ‘R'ANDscreendepth> 0 R'AND screendepth<=welldepth, then [AQ_CODE] is set to ‘D' and [AQ_FLAG] is set to ‘S'. IfaType= ‘R'ANDwelldepth <= topofrock,then [AQ_CODE] is set to ‘D' and [AQ_FLAG] is set to ‘D'.<o:p></o:p>ROCK_TOP: Depth below land surface in ftAQ_THK_1: Glacial Wells only; Summed thickness of all drift strata from SCREEN_BOT upward to:A) the bottom of a qualifying confining unit (>= 5ft CM or >= 10ft PCM)elseB) the SWL (if SWL >0 and SWL < SCREEN_BOT and SWL <= 99elseC) the ground surface*PROCESSING NOTE- If [SCREEN_BOT] <=layerbottomforseqnum1(the bottommost layer),ANDseqnum1= PCMORseqnum1 =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 fromlayerbottomof bottommost AQ or MAQ strata in the screened interval, rather than counting upward from [SCREEN_BOT], which is the normal logic.<o:p></o:p>TOPAQ: Top of AquiferBOTAQ: Bottom of AquiferWWAT_ID: The number assigned to a well that is a large quantity withdrawalAQ_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)FOR GLACIAL WELLS ONLYAQ_THK_1: Glacial Wells only; 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)elseB) the ground surfaceH_COND_1: "Confined" equivalent horizontal hydraulic conductivity for sediments in a glacial well (uses AQ_THK_1)H_COND_2: "Unconfined" equivalent horizontal hydraulic conductivity for sediments in a glacial well (uses AQ_THK_2)V_COND_1: "Confined" equivalent vertical hydraulic conductivity for sediments in a glacial well (uses AQ_THK_1)V_COND_2: "Unconfined" equivalent vertical hydraulic conductivity for sediments in a glacial well (uses AQ_THK_2)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 WELLSAQ_THK_D: The summed thickness of a drift aquifer from bedrock to ground surfaceH_COND_D: Equivalent horizontal hydraulic conductivity for glacial sediments in a bedrock well (uses AQ_THK_D)V_COND_D: Equivalent vertical hydraulic conductivity for glacial sediments in a bedrock well (uses AQ_THK_D)TRANS_D: Equivalent transmissivity for glacial sediments in a bedrock well (H_COND_D * AQ_THK_D)FOR BEDROCK PORTION OF BEDROCK WELLSB_AQ_THK: Summed thickness of all bedrock strata (i.e. AQ, MAQ, PCM, and CM) from WELL_DEPTH upward to ROCK_TOPB_H_COND: Equivalent horizontal hydraulic conductivity for Bedrock Units (uses B_AQ_THK)B_V_COND: Equivalent vertical hydraulic conductivity for Bedrock Units (uses B_AQ_THK)B_TRANS: Equivalent transmissivity for Bedrock Units (B_H_COND * B_AQ_THK)------------------------------------------------------------------------------------------NOTE:This data download does not contain the associated lithology files. Download this data on ourWellogic Water Wells by County website. If you have questions concerning this data, please contact: Wellogic@Michigan.gov

Creator:

Michigan Dept. of Environment, Great Lakes, and Energy

Provider:

State of Michigan Open Data Portal

Resource Class:

Web services

Temporal Coverage:

Last modified 2024-08-08

Date Issued:

2020-07-31

Place:

Michigan

Rights:

This application or dataset, along with any maps, data, content and other information contained within it and all output from the application (together the “Information”), is provided as a public service, and there are no restrictions on the use, reproduction, or distribution of the Information.  It is your responsibility to use the Information for a legally permissible purpose.  This Information is provided “AS IS” and on an “AS AVAILABLE” basis. The State of Michigan (“State”) makes no warranties, express or implied, regarding the accuracy, adequacy, reliability, timeliness, or completeness of this Information. THE STATE DISCLAIMS ALL WARRANTIES WITH REGARD TO THIS INFORMATION, INCLUDING THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NONINFRINGEMENT OF PROPRIETARY RIGHTS. THE STATE WILL NOT BE LIABLE, REGARDLESS OF THE FORM OF ACTION, WHETHER IN CONTRACT, TORT, NEGLIGENCE, STRICT LIABILITY OR BY STATUTE OR OTHERWISE, FOR ANY CLAIM FOR CONSEQUENTIAL, INCIDENTAL, INDIRECT, OR SPECIAL DAMAGES, INCLUDING WITHOUT LIMITATION LOST PROFITS AND LOST BUSINESS OPPORTUNITIES, RELATED TO THE ACCESS OR USE OF THIS INFORMATION. IN NO EVENT WILL THE STATE BE LIABLE FOR ANY AMOUNTS THAT MAY RESULT FROM THE ACCESS OR USE OF THIS INFORMATION, REGARDLESS OF THE FORM OF ACTION, WHETHER IN CONTRACT, TORT, NEGLIGENCE, STRICT LIABILITY, OR BY STATUTE OR OTHERWISE. By accessing or using this Information, you agree that you will not make any claims against the State or any of its departments, divisions, officers, or employees related to your use of the Information.  These terms are governed by and interpreted under the laws of the State of Michigan without regard to conflict of laws provisions. Nothing in these terms is meant to impact or replace any existing rights or licenses, such as copyright, trademark, or patent protections, in materials or content that may be located on the site or portal containing the Information.

Access Rights:

Public

Format:

File

Language:

English

Date Added:

2023-03-08