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’.

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).

This Regional Water Table Surface Contours Upper Glacial Drift Lower Peninsula is a generalized water table surface created by using the existing Wellogic water well database as of March 2021 and using just wells screened in the upper portion of the glacial drift. The elevation of the reported static water level (SWL field) reported on the well logs was calculated by subtracting it from the elevation at each well which was based on a 10-meter DEM. The data also incorporated the elevations of the Great Lakes Shorelines and the elevation of hydraulically appropriate surface water bodies (NHD Plus) that appear to be connected to the regional aquifer system and not perched above the regional water table surface. Contours were derived at a 10 feet contour interval. The original data was mapped for the entire lower peninsula. This Kent County data was clipped out of the peninsula data.The fields found in this dataset are:Field NameDescriptionIdUnique integer in long integer formatContourGroundwater elevation value (feet above mean sea level) in double precision formatContour1Groundwater elevation value (feet above mean sea level) in long integer formatINDEXValues in long integer format that allow different index contours to be flagged, labeled, queried, and/or symbolized.INDEX10Values in long integer format that allow different index contours to be flagged, labeled, queried, and/or symbolized.INDEX5Values in long integer format that allow different index contours to be flagged, labeled, queried, and/or symbolized.Shape_LengthLength of line in feet in double precision formatThis data is used in the North Kent Study Area Data Summary Web App (Item Details). 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.

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

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 ...

In order to better represent the configuration of the stream network and simulate local groundwater-surface water interactions, a version of MODFLOW with refined spacing in the topmost layer was applied to a Lake Michigan Basin (LMB) regional groundwaterflow model developed by the U. S. Geological. Regional MODFLOW models commonly use coarse grids over large areas; this coarse spacing precludes model application to local management issues (e. g., surface-water depletion by wells) without recourse to labor-intensive inset models. Implementation of an unstructured formulation within the MODFLOW framework (MODFLOW-USG) allows application of regional models to address local problems. A "semi-structured" approach (uniform lateral spacing within layers, different lateral spacing among layers) was tested using the LMB regional model. The parent 20-layer model with uniform 5000-foot (1524-m) lateral spacing was converted to 4 layers with 500-foot (152-m) spacing in the top glacial (Quaternary) layer, where surface water features are located, overlying coarser resolution layers representing deeper deposits. This semi-structured version of the LMB model reproduces regional flow conditions, whereas the finer resolution in the top layer improves the accuracy of the simulated response of surface water to shallow wells. One application of the semi-structured LMB model is to provide statistical measures of the correlation between modeled inputs and the simulated amount of water that wells derive from local surface water. The relations identified in this paper serve as the basis for metamodels to predict (with uncertainty) surface-water depletion in response to shallow pumping within and potentially beyond the modeled area, see Fienen et al. (2015a).

A source water assessment identifies the vulnerability of the drinking water supply to contamination from typical human activities. The assessments are intended to facilitate and provide the basic information necessary for a local community to develop a program to protect the drinking water supply.

A source water assessment identifies the vulnerability of the drinking water supply to contamination from typical human activities. The assessments are intended to facilitate and provide the basic information necessary for a local community to develop a program to protect the drinking water supply.

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’.

A source water assessment identifies the vulnerability of the drinking water supply to contamination from typical human activities. The assessments are intended to facilitate and provide the basic information necessary for a local community to develop a program to protect the drinking water supply.

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

A source water assessment identifies the vulnerability of the drinking water supply to contamination from typical human activities. The assessments are intended to facilitate and provide the basic information necessary for a local community to develop a program to protect the drinking water supply.

A source water assessment identifies the vulnerability of the drinking water supply to contamination from typical human activities. The assessments are intended to facilitate and provide the basic information necessary for a local community to develop a program to protect the drinking water supply.

Dataset Abstract Water chemistry is measured in diverse surface waters and in two water supply wells in the vicinity of the KBS LTER. This dataset includes sites sampled over time (streams, wells, some wetlands) as well as wetland sites sampled once or a few times. A separate dataset includes soil water chemistry sampled from the LTER treatments. original data source http://lter.kbs.msu.edu/datasets/50

A source water assessment identifies the vulnerability of the drinking water supply to contamination from typical human activities. The assessments are intended to facilitate and provide the basic information necessary for a local community to develop a program to protect the drinking water supply.

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’.

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’.