The data in these six files is 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_COLL field to 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 Michigan DRILL_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 Pump TEST_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’ 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’.
The data in these six files is 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_COLL field to 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 Michigan DRILL_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 Pump TEST_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’ 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’.
The data in this layer is is updated weekly from Wellogic, the Michigan Department of Environment, Great Lakes, and Energy statewide groundwater database. This layer is filtered to only show Type I public wells. Type I wells provide year-round service to 15 or more living units or 25 or more residents. Examples include municipalities, subdivisions, apartments, condominiums, manufactured housing communities, and nursing homes.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. Until January 1, 2000 not all water well records for new wells in Michigan were entered into Wellogic. For wells drilled before 2000 the rate of inclusion is highly variable from one county to another. Further, there is a quality control check on location that may exclude a limited number of wells from Wellogic from this complete layer. NOTE: This data download does not contain the associated lithology files. Download this data on our Wellogic Water Wells by County website. If you have questions concerning this data, please contact:Wellogic@Michigan.gov------------------------------------------------------------------------------------------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 Michigan DRILL_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 Pump TEST_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’ 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’.
As of March 2021, a PFAS site is defined as a property where EGLE has a valid groundwater monitoring well sample result that exceeds one or more of Michigan's seven PFAS groundwater cleanup criteria, and based on data, EGLE has determined the property is the location of the source of PFAS contamination (e.g., fire training area where PFAS-containing foam was used).An area of interest is a general location identified where PFAS contamination is potentially in groundwater and may be impacting private drinking water wells. Areas of interest are evolving investigations with potentially expanding boundaries. Data is gathered and boundaries are expanded as necessary. This map represents areas of interest using point locations to approximate general areas. These points do not indicate precise locations and are meant for reference purposes only. Users should not assume that the point location fully represents the extent or specific limits of the area it symbolizes. For detailed spatial information, please contact the Area of Interest lead listed in the dataset.This data is live and updated as new PFAS sites or areas of interest are encountered.This data is used in the MPART: PFAS Geographic Information System (item details). For more information, please visit our State of Michigan PFAS Response website. For content related questions reach out to the site lead contact listed in the dataset. Submit feedback please reach out to EGLE-Maps@Michigan.gov.Field NameField DescriptionSiteOrAoiIf the record is considered a site or an area of interestNameName of the site or area of interestAddressPhysical address of the project siteCityCity where the project is physically locatedZipCodeZip code where the project is physically locatedCountyCounty where the site is physically locatedTypeDescribes the kind of site by typeResidentialWellsSampledIndicates whether residential wells have, or will be sampled (Domains = Yes, No, TBD, N/A)SiteLeadName of contact personSiteLeadEmailContact person emailSiteLeadPhoneContact person phone numberWebpageSiteURL to the site investigation summaryWebpageAdditionalFilesURL to additional files related to the siteLongitudeX coordinate of the locationLatitudeY coordinate of the locationFacilityDateDate the site was published on the MPART website
The data in these six files is 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_COLL field to 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 Michigan DRILL_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 Pump TEST_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’ 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’.
The data in this layer is updated weekly from Wellogic, the Michigan Department of Environment, Great Lakes, and Energy statewide groundwater database. This layer contains information on over 575,000 spatially verified water well records across Michigan. This layer contains those water wells in Wellogic with latitude and longitude coordinates.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. Until January 1, 2000 not all water well records for new wells in Michigan were entered into Wellogic. For wells drilled before 2000 the rate of inclusion is highly variable from one county to another. Further, there is a quality control check on location that may exclude a limited number of wells from Wellogic from this complete layer.NOTE: This data download does not contain the associated lithology files. Download this data on our Wellogic Water Wells by County website. If you have questions concerning this data, please contact:Wellogic@Michigan.gov------------------------------------------------------------------------------------------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’.
The data in these six files is 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_COLL field to 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 Michigan DRILL_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 Pump TEST_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’ 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’.
The data in this layer is is updated weekly from Wellogic, the Michigan Department of Environment, Great Lakes, and Energy statewide groundwater database. This layer is filtered to only show Type II public wells. Type II wells are noncommunity wells and serve 25 or more individuals or 15 or more service connections on an average daily basis for 60 or more days per year. Examples include restaurants, schools, hotels, campgrounds, churches, and day care centers.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. Until January 1, 2000 not all water well records for new wells in Michigan were entered into Wellogic. For wells drilled before 2000 the rate of inclusion is highly variable from one county to another. Further, there is a quality control check on location that may exclude a limited number of wells from Wellogic from this complete layer.NOTE: This data download does not contain the associated lithology files. Download this data on our Wellogic Water Wells by County website. If you have questions concerning this data, please contact:Wellogic@Michigan.gov------------------------------------------------------------------------------------------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’.
This layer displays the results for groundwater samples collected by Wolverine World Wide, Inc. compared to Michigan Part 201 Residential and Nonresidential Drinking Water Criteria. Coordinates were collected via professional survey or GPS. Samples were collected from August 2017 through present. Results are updated quarterly. This data is used in the North Kent Disposal Area PFAS web map. The pop-up in that map displays:Location IDSample DateSample IDSampling interval (feet below ground surface)Sample Type (Permanent Monitoring Well, Piezometer, Temporary Monitoring Well, VAS)Result in ng/L or ppt for the seven PFAS analytes with Michigan Part 201 Residential and Nonresidential Drinking Water Criteria (DWC) and for Total PFAS, which is sum of all PFAS analyzed.Well Depth (feet below ground surface)Top of casing elevation (feet above mean sea level)Ground elevation (feet above mean sea level)Water elevation (feet above mean sea level) measured in August 2019Water elevation (feet above mean sea level) measured in November 2019Water elevation (feet above mean sea level) measured in October 2022Water elevation (feet above mean sea level) measured in February 2023Water elevation (feet above mean sea level) measured in April 2023Water elevation (feet above mean sea level) measured in July 2023Water elevation (feet above mean sea level) measured in October 2023Water elevation (feet above mean sea level) measured in January 2024The fields found in this dataset are: Field Name Description
sys_sample_code Sample ID
sys_loc_code Location ID
Type2 Sample Type: Wolverine Permanent Monitoring Well, Wolverine Piezometer, Wolverine Temporary Monitoring Well, Wolverine Vertical Aquifer Sample
SAMPDATE Sample Date
TOC_Elev Top of Casing Elevation (feet above mean sea level)
GS_Elev Ground Surface Elevation (feet above mean sea level)
Well_Depth Depth of well in feet
Sampling_Interval Depth of sample in feet
T_TotalPFAS Total PFAS result in text format
T_PFOA PFOA result in text format
T_PFOS PFOS result in text format
T_PFNA PFNA result in text format
T_PFHxS PFHxS result in text format
T_PFHxA PFHxA result in text format
T_PFBS PFBS result in text format
T_HFPODA HFPO-DA result in text format
All7PFAS Non-Detect (No Detections of PFNA, PFOA, PFHxA, PFOS, PFHxS, PFBS, or HFPO-DA), Detection (One or more PFAS Analytes Detected Below Michigan Part 201 Drinking Water Criteria), or Exceeds (One or more PFAS Analytes Detected Above Michigan Part 201 Drinking Water Criteria)
WaterElev_Aug_2019 Groundwater elevation measured on August 22 and 23, 2019 (feet above mean sea level)
WaterElev_Nov_2019 Groundwater elevation measured on November 4, 2019 (feet above mean sea level)
WaterElev_Oct_2022 Groundwater elevation measured on October 3, 2022 (feet above mean sea level) WaterElev_Feb_2023Groundwater elevation measured on February 6-7, 2023 (feet above mean sea level)WaterElev_April_2023Groundwater elevation measured on April 10-11, 2023 (feet above mean sea level)
WaterElev_July_2023
Groundwater elevation measured on July 10 and July 25, 2023 (feet above mean sea level)
WaterElev_Oct_2023
Groundwater elevation measured on October 2-3, 2023 (feet above mean sea level)
WaterELev_Jan_2024
Groundwater elevation measured on January 8, 2024 (feet above mean sea level)
WaterELev_April_2024
Groundwater elevation measured at Tannery monitoring wells on April 30, 2024 and May 1, 2024 (feet above mean sea level)
You can find more information about the North Kent Study Area by visiting the House Street Disposal Area webpage or the Rockford Tannery webpage on the Michigan PFAS Action Response Team (MPART) website. For questions about this content, reach out to Leah Gies, GiesL1@Michigan.gov. This data was provided to the Michigan Department of Environment, Great Lakes, and Energy (EGLE) by the consulting firm AECOM.
This layer displays results for groundwater samples collected by EGLE compared to Michigan Part 201 Residential and Nonresidential Drinking Water Criteria. Coordinates were collected via professional survey or GPS. Samples were collected from December 2017 through present. Results are updated quarterly. This data is used in the North Kent Disposal Area PFAS web map. The pop-up in that map displays: Location IDSample DateSample IDSampling interval (feet below ground surface)Sample Type (Permanent Monitoring Well, Temporary Monitoring Well, VAS)Result in ng//L or ppt for the seven PFAS analytes with Michigan Part 201 Residential and Nonresidential Drinking Water Criteria (DWC) and for Total PFAS, which is sum of all PFAS analyzed.Well Depth (feet below ground surface)Top of casing elevation (feet above mean sea level)Ground surface elevation (feet above mean sea level)Well screen elevation (feet above mean sea level)Water elevation (feet above mean sea level) measured in August 2019Water elevation (feet above mean sea level) measured in November 2019Water elevation (feet above mean sea level) measured in November 2020Water elevation (feet above mean sea level) measured in October 2022The fields found in this dataset are: Field Name Description
sys_sample_code Sample ID
LABEL2 Location ID
Type Sample Type: EGLE Permanent Monitoring Well, EGLE Temporary Monitoring Well, EGLE Vertical Aquifer Sample, North East Gravel Permanent Monitoring Well, North Kent Landfill Permanent Monitoring Well, Rockford Permanent Monitoring Well, Temporary Monitoring Well
SAMPLEDATE Sample Date
TOC_Elev Top of Casing Elevation (feet above mean sea level)
Ground_Elev Ground Surface Elevation (feet above mean sea level)
WELL_DEPTH Depth of well in feet
Screen_Elev Elevation of well screen (feet above mean sea level)
SamplingInterval Depth of sample in feet
T_TotalPFAS Total PFAS result in text format
T_PFOA PFOA result in text format
T_PFOS PFOS result in text format
T_PFNA PFNA result in text format
T_PFHxS PFHxS result in text format
T_PFHxA PFHxA result in text format
T_PFBS PFBS result in text format
T_HFPODA HFPO-DA result in text format
All7PFAS Non-Detect (No Detections of PFNA, PFOA, PFHxA, PFOS, PFHxS, PFBS, or HFPO-DA), Detection (One or more PFAS Analytes Detected Below Michigan Part 201 Drinking Water Criteria), or Exceeds (One or more PFAS Analytes Detected Above Michigan Part 201 Drinking Water Criteria)
WaterElev_Aug_2019 Groundwater elevation measured on August 22 and 23, 2019 (feet above mean sea level)
WaterElev_Nov_2019 Groundwater elevation measured on November 4, 2019 (feet above mean sea level)
WaterElev_Nov_2020 Groundwater elevation measured on November 4, 2020 (feet above mean sea level)
WaterElev_Oct_2022 Groundwater elevation measured on October 3, 2022 (feet above mean sea level) You can find more information about the North Kent Study Area by visiting the House Street Disposal Area webpage or the Rockford Tannery webpage on the Michigan PFAS Action Response Team (MPART) website. For questions about this content, reach out to Leah Gies, GiesL1@Michigan.gov. This data was provided to the Michigan Department of Environment, Great Lakes, and Energy (EGLE) by the consulting firm AECOM.
A series of annual geochemical models were created by RockWare utilizing RockWorks v2021 which were interpolated based on the 1,4-dioxane levels that were measured during 1986 through 2020. In cases where the same intervals were samples on more than one occasion during a given year, the highest 1,4-dioxane values were used. The extent of each annual model were limited to polygons based on only the wells that were sampled during the associated year to eliminate interpolating in areas where data is not present. The annual geochemical models were then filtered based on lithology to eliminate any voxels within the areas deemed impermeable based on lithology. The models were further constrained by utilizing the maximum historical water level surface (MHWLS) grid model to further restrict the interpolation from areas lacking measured data. Finally, the voxel models were converted to annual grid models, in which the cell values are based on the highest value within the corresponding column of voxels.The 2020 plume presented here was created from the RockWorks project database files on June 09, 2021 (Gelman3.sqlite v2021-04-29). The grid file titled 2020-01-01_to_2020-12-31.RwGrd (v20210710) was converted by The Mannik and Smith Group (MSG) to a raster file compatible in ArcGIS and a custom color scheme was applied with the shades becoming darker as concentrations increase. Iso-concentration lines were then generated at the following concentrations: 4 ppb, 7.2 ppb, 85 ppb, 150 ppb, 280 ppb, 500 ppb, 1000 ppb, 1900 ppb, 3000 ppb, and 5000 ppb. The 7.2 ppb lines were created because it represents the current EGLE Part 201 generic residential cleanup criterion (GRCC). The 85 ppb lines were created to represent the Consent Judgement 3 (CJ3) drinking water criteria. The 280 ppb lines were created because that is the new EGLE groundwater-surface water interface (GSI) criterion, and 1900 ppb is the Vapor Intrusion criteria. EGLE is contouring the 4 ppb level because that could become a new trigger for response if detected in sentinel wells if the proposed 4th Consent Judgment is approved.To host the plume files on EGLE's ArcGIS Online, MSG prepared the raster file, contour layer, and the input points used as the input for the specified year model in ArcGIS Pro. The points were labeled using three levels of detail. When zoomed out beyond 1:5000 no labels appear at the points because it would be too dense to read and cover the underlying plume. When zoomed in between 1:5000 and 1:1200, the bore name and maximum 1,4-dioxane at that well in 2020 appear. When zoomed in closer than 1:1200, the labels show the boring name, sample depth interval, and maximum 1,4-dioxane at that interval for 2020. The plume layer was set to 7.5% transparency (this can be adjusted later) and shared as a web tile layer using the ArcGIS Online / Bing Maps / Google Maps tiling scheme for levels of detail 12 – 19.This is a previous version of the data. The newest vintage is available at: Gelman Site of 1,4-Dioxane Contamination - Dioxane Plume (2023 Data).This data is used in the Gelman Site of 1,4-Dioxane Contamination web map (item details). If you have questions regarding the Gelman Sciences, Inc site of contamination contact Chris Svoboda at 517-256-2849 or svobodac@michigan.gov. Report problems or data functionality suggestions to EGLE-Maps@Michigan.gov.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Data pertaining to groundwater nitrate concentrations accompanying "Examining Relationships Between Groundwater Nitrate Concentrations in Drinking Water and Landscape Characteristics to Understand Health Risks". Contents include interpolated raster of groundwater nitrate concentration, probability of exceeding certain limits, and group assigned to watershed by classification and regression tree (CART) analysis.
Nitrate well chemistry data obtained via FOIA from Michigan Department of Environment, Great Lakes, and Energy.
Corresponding manuscript: Hamlin, QF, Martin, SL, Hyndman, DW. "Examining Relationships Between Groundwater Nitrate Concentrations in Drinking Water and Landscape Characteristics to Understand Health Risks". Geohealth. https://doi.org/10.1029/2021GH000524
A regional groundwater flow model (https://pubs.usgs.gov/sir/2009/5244/) was updated to reflect 2017 pumping conditions in the Tri-County Region covering most of Clinton, Eaton, and Ingham Counties, Michigan. This model was developed to simulate the regional hydrologic system in Tri-County area and continues to be used for planning and protection of area water supplies. Revised contributing area delineations in response to recent pumping conditions were needed for local wellhead protection area programs. The model was calibrated to water level observations for 2017 from well driller logs, average water levels for 2012-17 from active USGS observation wells, and estimated baseflow for 2012-16 from USGS streamgaging station measurements. The model was used to delineate 10- and 40-year contributing areas to selected wells in Lansing and East Lansing, Michigan. This USGS data release contains all of the input and output files for the MODFLOW and MODPATH simulations described in the associated model documentation report (https://doi.org/10.3133/ofr20181133).
To improve EGLE's data visualizations of the Gelman Site project data and to develop an interactive 3D virtual conceptual site model (VCSM), EGLE utilizes RockWorks, an integrated geological database, analysis, and visualization software developed by RockWare, Inc. The locations included in this feature layer include all bore and sample locations that are in the current RockWorks project database (Gelman3.sqlite v20210429). Data tied to each location includes lithological information, 1,4-dioxane sample results, and groundwater level measurements.
The custom pop-up displays the standardized bore location name and the following information:
To improve EGLE's data visualizations of the Gelman Site project data and to develop an interactive 3D virtual conceptual site model (VCSM), EGLE utilizes RockWorks, an integrated geological database, analysis, and visualization software developed by RockWare, Inc. The locations included in this feature layer include all bore and sample locations that are in the current RockWorks project database (Gelman5_v2023.sqlite dated 02/27/2024). Data tied to each location includes lithological information, 1,4-dioxane sample results, and groundwater level measurements. The custom pop-up displays the standardized bore location name and the following information: Well Type: includes one of the following: Monitoring Well, Residential Well, Extraction Well, Injection Well, Horizontal Well, Test Boring, Seismic Interpolation Point, Surface Water, or other. Ground Elevation: elevation in feet at the point extracted from the March 2019 LiDAR digital elevation model from Southeast Michigan Council of Governments (SEMCOG). Units are in feet referenced to the North American Vertical Datum 1988 (Geoid12B).Collar Elevation: the top of well casing elevation used for reference when collecting groundwater level measurements. Source of information includes the EGLE Access database and supplemented with boring log or well construction records if available. Total Depth: feet below ground surface to the well or boring terminus. Source of information includes the EGLE Access database and supplemented with boring log or well construction records if available. Screen Interval: depth below ground surface to the top and bottom of the well screen. Source of information includes the EGLE Access database and supplemented with boring log or well construction records if available. Used for Lithology Model: yes/no field indicating if the location has associated lithological information that was used for input into the RockWorks lithology 3d solid voxel model.Used for Max Groundwater Elevation Model: yes/no field indicating if the location has associated groundwater level measurements that were was used as input for the Maximum Groundwater Elevation Model.Used for Geochem Models: yes/no field indicating the location has associated 1,4-dioxane results used as input to create the annual (1986 - 2023) 3d solid voxel models and 2d grid surface files. Additional fields specifying source of information, such as source of northing and eastings, can be viewed within the attribute table. Boring logs and well construction documents, if available, are stored as attachments and can be viewed by clicking on the hyperlink.At the bottom of the pop-up, the "Show Related Records" link will open up separate windows showing the lithology, water level measurements, or 1,4-dioxane results that are associated with the selected location. This is the latest version of the bore locations data. An earlier vintage is available at: Gelman Site of 1,4-Dioxane Contamination - All Bore Locations Layer Group (2020 Data).This data is used in the Gelman Site of 1,4-Dioxane Contamination web map (item details). If you have questions regarding the Gelman Sciences, Inc site of contamination contact Chris Svoboda at 517-256-2849 or svobodac@michigan.gov. Report problems or data functionality suggestions to EGLE-Maps@Michigan.gov.
Link to the ScienceBase Item Summary page for the item described by this metadata record. Service Protocol: Link to the ScienceBase Item Summary page for the item described by this metadata record. Application Profile: Web Browser. Link Function: information
Surface locations (wellhead) of all oil and gas wells whether directionally drilled or straight (vertical) holes. This data is updated on a weekly basis from the GRMD RBDMS database.For more information, visit Michigan.gov/EGLE/Maps-Data/GeoWebFace or contact EGLE-GeoWebFace@michigan.gov.
Field Name
Field Description
Api_num
14 digit API Number for well
PermitNumber
Permit Number for Well
WellNameFull
Combined well name and number
WellType
Type of Well Description
WellStatus
Status of Well Description
TopWellType
Type of Well Description from 10 digit API Level
TopWellStatus
Status of Well Description from 10 digit API
Slant
Slant of Borehole- See codes below
H: HorizontalV: VerticalD: Directional
WellboreType
Type of Borehole
CompanyName
Operator Name
CompanyNo
Operator Number
CountyName
County Name
TownshipName
Township Name
TRS
Township Range Section
QS
Quarter
QQS
QuarterQuarter
QQQS
QuarterQuarterQuarter
StateLand
On State Land (Yes/No)
FederalLand
On Federal Land (Yes/No)
Y
Latitude
X
Longitude
Mgr_x
Michigan GeoRef X
Mgr_y
Michigan GeoRef Y
ReferenceTops
Reference Top Type -- see codes below
C: Casing HeadD: Derrick Floor G: Ground LevelK: Kelly Bushing
ReferenceElevation
Reference Elevation (ft)
DTD
Drillers Total Depth (ft)
TVD
Total Vertical Depth (ft)
KOTVD
Kick Off Total Vertical Depth (ft)
FieldName
Field Name
FieldType
Type of field- see codes below
OG: Oil and GasG: GasO: OilGS: Gas StorageGC: Gas CondensateUNK: Unknown
ProdFormationCode
Producing Formation Code (see table at the bottom of this page)
ProducingFormation
Producing Formation Name
PRUNumber
Production Unit Number
PRUName
Production Unit Name
PermitDate
Date Well Permitted
PluggingDate
Date Well Plugged
Concentration_H2S
Most recent H2S concentration (parts per million by volume)
LogsAvailable
Logs available for well (yes/no)
WellName
Well Name
WellNumber
Well Number
Sidetrack
Part of API Number
Completion
Part of API Number
County_fips
County FIPS code
Well_type
Type of Well Code- See codes below
OIL Oil Well GAS Natural Gas Well BDW Brine Disposal Well COI CO2 Injection Well DH Dry Hole GC Gas Condensate Well GIW Gas Injection Well GBD Gas Production and Brine Disposal GS Gas Storage GSO Gas Storage Observation Well LPG Liquified Petroleum Gas Storage LOC Location LHL Lost Hole OBS Observation Well OTH Other Well MDW Part 625 Disposal Well MNB Part 625 Natural Brine MSM Part 625 Solution Mining MSW Part 625 Storage Well MTW Part 625 Test Well WIW Water Injection Well NA Not Available
WellID
10 digit API Number for well
Pkey
Key for DataMiner
constructkey
Key for DataMiner
ProdFormationCode DescriptionsFormation CodeFormation NameADRDANDERDONALPNALPENAAMBGAMHERSTBURGANRMANTRIMANRM1ANTRIM DARKANRM2ANTRIM LIGHTAONE1A-1 ANHYDRITEAONE2A-1 CARBONATEAONE3A-1 DOLOMITEAONE4A-1 EVAPORITEAONE5A-1 SALTATWO1A-2 ANHYDRITEATWO2A-2 CARBONATEATWO3A-2 DOLOMITEATWO4A-2 EVAPORITEATWO5A-2 LIMESTONEATWO6A-2 SALTBBLCBOIS BLANCBBLFBURNT BLUFFBDFDBEDFORD SHALEBELL1BELL SHALEBEREBEREA SANDSTONEBIGBIG ANHYDRITEBILDBASS ISLANDSBKRVBLACK RIVERBKRV1BLACK RIVER SHALEBKRV2BLACK RIVER VAN WERT ZONEBPRTBAYPORT LIMESTONEBRBDBEREA-BEDFORDBRWNBROWN LIMESTONEBYRNBYRONCBHDCABOT HEADCLCCCLINTON-CATARACTCLDR1COLDWATER LIMESTONECLDR2COLDWATER RED ROCKCLDR3COLDWATER SHALECLGDCOLLINGWOODCLNNCLINTONCMBRCAMBRIANCNCNCINCINNATIANCTRCCATARACTDRBCDRESBACHDRRVDETROIT RIVERDRRV1DETROIT RIVER ANHYDRRV2DETROIT RIVER DOLOMITEDRRV3DETROIT RIVER GROUPDRRV4DETROIT RIVER SALTDRRV5DETROIT RIVER Sour ZoneDRRV6DETROIT RIVER EVAPDUNDDUNDEEDVNNDEVONIANECLREAU CLAIREELSRELLSWORTHELSR1ELLSWORTH SHALEFILRFILER SANDSTONEFRNCFRANCONIAGCDFGLACIAL DRIFTGDIDGARDEN ISLANDGDRPGRAND RAPIDSGDRVGRAND RIVERGLNDGLENWOODGLPHGUELPHGPLKGUELPH-LOCKPORTGRWSGRANITE WASHHKFBHENDRICKS-FIBORNIONIIONIA SANDSTONEJBVLJACOBSVILLEJRDNJORDANLACLACHINELCKPLOCKPORTLKSPLAKE SUPERIORLMIDLIME ISLANDLUCSLUCASMCGNMICHIGAN FORMATIONMCGN1MICHIGAN STRAYMCGN2MICHIGAN STRAY SANDSTONEMCGN3MICHIGAN STRAY DOLOMITEMNLNMANITOULINMNSGMUNISINGMNSMMOUNT SIMONMNSQMANISTIQUEMONRMONROEMONRUMONROE UPPERMRSLMARSHALLMRSL1MARSHALL SANDSTONEMRSLLMARSHALL LOWERMRSLUMARSHALL UPPERMSSPMISSISSIPPIANMSSVMASSIVE ANHYDRITEMSSV1MASSIVE SALTMVLLMAYVILLENGRNNIAGARANNGRN1NIAGARAN BROWNNGRN2NIAGARAN GRAYNGRN3NIAGARAN WHITENORNORWOODNPLNNAPOLEON SANDSTONENRCMNEW RICHMONDONOTONEOTAPARMPARMA SANDSTONEPAXPAXTONPCMBPRECAMBRIANPCMB3PRECAMBRIAN GRANITEPRDCPRAIRIE DU CHIENPSALTPOTASSIUM SALTPSLVPENNSYLVANIANRCFDRICHFIELDRDBDRED BEDSRDCTREED CITYRDCT1REED CITY ANHYDRITERDCT2REED CITY DOLOMITERGRCROGERS CITYRRCKREDROCKSCRXST CROIXANSGNWSAGINAWSHKPSHAKOPEESLINSALINASLIN1SALINA BSLIN2SALINA B ANHYDRITESLIN3SALINA B SALTSLIN4SALINA C SHALESLIN5SALINA D SALTSLIN6SALINA ESLIN7SALINA FSLIN8SALINA F SALTSLIN9SALINA GSLRCST LAWRENCESLRNSILURIANSLVNSYLVANIASLVN1SYLVANIA SANDSTONESNBR1SUNBURY SHALESQBYSQUAW BAYSRSRSTRAY-STRAY SANDSTONESTPRST PETERTBRVTRENTON-BLACK RIVERTMPLTREMPEALEAUTRNNTRENTONTRPLTRIPLE GYPSUMTRVRTRAVERSETRVR2TRAVERSE FORMATIONTRVR3TRAVERSE GROUPTRVR4TRAVERSE LIMESTONEUTCLDUTICA-COLLINGWOODUTICUTICAVERNVERNE LIMESTONEWDVLWOODVILLE SANDSTONE
To improve EGLE's data visualizations of the Gelman Site project data and to develop an interactive 3D virtual conceptual site model (VCSM), EGLE utilizes RockWorks, an integrated geological database, analysis, and visualization software developed by RockWare, Inc. The locations included in this feature layer include all bore and sample locations that are in the current RockWorks project database (Gelman5_v2023.sqlite dated 02/27/2024). Data tied to each location includes lithological information, 1,4-dioxane sample results, and groundwater level measurements. The custom pop-up displays the standardized bore location name and the following information: Well Type: includes one of the following: Monitoring Well, Residential Well, Extraction Well, Injection Well, Horizontal Well, Test Boring, Seismic Interpolation Point, Surface Water, or other. Ground Elevation: elevation in feet at the point extracted from the March 2019 LiDAR digital elevation model from Southeast Michigan Council of Governments (SEMCOG). Units are in feet referenced to the North American Vertical Datum 1988 (Geoid12B).Collar Elevation: the top of well casing elevation used for reference when collecting groundwater level measurements. Source of information includes the EGLE Access database and supplemented with boring log or well construction records if available. Total Depth: feet below ground surface to the well or boring terminus. Source of information includes the EGLE Access database and supplemented with boring log or well construction records if available. Screen Interval: depth below ground surface to the top and bottom of the well screen. Source of information includes the EGLE Access database and supplemented with boring log or well construction records if available. Used for Lithology Model: yes/no field indicating if the location has associated lithological information that was used for input into the RockWorks lithology 3d solid voxel model.Used for Max Groundwater Elevation Model: yes/no field indicating if the location has associated groundwater level measurements that were was used as input for the Maximum Groundwater Elevation Model.Used for Geochem Models: yes/no field indicating the location has associated 1,4-dioxane results used as input to create the annual (1986 - 2023) 3d solid voxel models and 2d grid surface files. Additional fields specifying source of information, such as source of northing and eastings, can be viewed within the attribute table. Boring logs and well construction documents, if available, are stored as attachments and can be viewed by clicking on the hyperlink.At the bottom of the pop-up, the "Show Related Records" link will open up separate windows showing the lithology, water level measurements, or 1,4-dioxane results that are associated with the selected location. This is the latest version of the bore locations data. An earlier vintage is available at: Gelman Site of 1,4-Dioxane Contamination - All Bore Locations Layer Group (2020 Data).This data is used in the Gelman Site of 1,4-Dioxane Contamination web map (item details). If you have questions regarding the Gelman Sciences, Inc site of contamination contact Chris Svoboda at 517-256-2849 or svobodac@michigan.gov. Report problems or data functionality suggestions to EGLE-Maps@Michigan.gov.
U.S. Government Workshttps://www.usa.gov/government-works
License information was derived automatically
In 1954 researchers at the USGS Great Lakes Science Center conducted 11 research cruises on Lake Michigan during which 779 bathythermographs were cast to collect temperature profile data (temperature at depth). Bathythermographs of that era recorded water pressure and temperature data by mechanically etching them as a curve on a glass slide. Data was collected from the glass slide by projecting the image of the curve, superimposing a grid, and taking a photo of it, thereby creating a bathythermogram. Data collection personnel could then read the data from the curve. This USGS data release is a digitized set of those original bathythermogram print photos and the temperature and depth data the project team collected from them using the open-source software, Web Plot Digitizer, as well as metadata describing each. In addition, because of their historical value as well as potential future use, this data release includes the cruise logs, which include nautical and research notes beyo ...
This web map for the Digital Atlas of the proposed Wisconsin-Lake Michigan National Marine Sanctuary contains layers to visualize data on the region's lake bed bathymetry and habitats including sonar, lidar, and other sounding datasets as well as related water quality and human use information.For more information on the proposed sanctuary, please visit the sanctuary website.For more information on the broader investigation of Lake Michigan adjacent to Wisconsin, please visit the project website.
The data in these six files is 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_COLL field to 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 Michigan DRILL_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 Pump TEST_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’ 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’.