Public Water Supply Sampling Results [Michigan] Full Details

Full Details

Title:

Public Water Supply Sampling Results [Michigan]

Description:

Hexbin data (PFAS test results) for public water supplies come from two different sources: 1) EGLE's statewide PFAS survey, which tested supplies between 2018 and 2020, prior to Michigan's PFAS maximum contaminant levels (MCLs), and 2) PFAS MCL compliance monitoring results under Michigan's Safe Drinking Water Act. (2020 - present). Use theTaskType field to differentiate the Statewide Surveillance PFAS data (StateSurv) versus the PFAS Compliance Monitoring data (ComplMon).The locations that have been sampled in this effort include Community Water Supplies (including regional and municipal water supplies, manufactured housing communities, residential apartment buildings, etc.), Nontransient Noncommunity Water Supplies (including schools, businesses, childcare providers, Michigan Head Start locations, motels, resorts, etc.), and Transient Noncommunity Water Supplies (children's camps and medical care providers).*Results are provided in parts per trillion. A part per trillion (ppt) is the equivalent of 1 drop of water in 20 Olympic-size swimming poolsDefinitions of the information provided in the sampling results table:WSSN: Water Supply Serial Number; unique identifier for each public water supplyCollection Date: The date samples were taken at the water supply.The System Type column lists the type of public water supplyCWS: Community Water Supply (Type I)NCWS: Noncommunity Water Supply (Type II)Non-transient: Non-transient noncommunity water supplies (Type II) are monitored for compliance under Michigan's SDWA.ADFSTC:Non-Community Water Supply (Adult Foster Care Provider)CHLCMP:Non-Community Water Supply (Children's Camp)DAYCARE:Non-Community Water Supply (Child Care Provider)INDUS:Non-Community Water Supply (Industry)MEDCAR:Non-Community Water Supply (Medical Care Provider)MOTEL:Non-Community Water Supply (Hotel or Motel)MUN:Community Water Supply (for example Municipal Supply, Apartment, Nursing Home, Prison, etc.)PFAS analytes are listed in individual columns (ppt). These include the 18 PFAS compounds tested under EPA method 537.1. If the result listed is "ND" the lab did not detect, or find, that PFAS was in the water sample above the method reporting limit.HFPO-DA (Hexafluoropropylene oxide-dimer acid, also referred to as "GenX") is a regulated analyte in Michigan with an MCL = 370 pptPFBS (Perfluorobutane sulfonic acid) is a regulated analyte in Michigan with an MCL = 420 pptPFHxA (perfluorohexanoic acid) is a regulated analyte in Michigan with an MCL = 400,000 pptPFHxS (perfluorohexane sulfonic acid) is a regulated analyte in Michigan with an MCL = 51 pptPFNA (perfluorononanoic acid) is a regulated analyte in Michigan with an MCL = 6 pptPFOA (perfluorooctanoic acid) is a regulated analyte in Michigan with an MCL = 8 pptPFOS (perfluorooctane sulfonic acid) is a regulated analyte in Michigan with an MCL = 16 ppt11Cl-PF3OUdS (11-chloroeicosafluoro-3-oxaundecane-1-sulfonic Acid) is currently a non-regulated analyte in Michigan9Cl-PF3ONS (9-chlorohexadecafluoro-3-oxanone-1-sulfonic acid) is currently a non-regulated analyte in MichiganADONA (4,8-dioxa-3H-perfluorononanoic acid) is currently a non-regulated analyte in MichiganNEtFOSAA (2-(N-ethylperfluorooctanesulfonamido) acetic acid) is currently a non-regulated analyte in MichiganNMeFOSAA (2-(N-methylperfluorooctanesulfonamido) acetic acid) is currently a non-regulated analyte in MichiganPFDA (perfluorodecanoic acid) is currently a non-regulated analyte in MichiganPFDoA (perfluorododecanoic acid) is currently a non-regulated analyte in MichiganPFHpA (perfluoroheptanoic acid) is currently a non-regulated analyte in MichiganPFTA (perfluorotetradecanoic acid) is currently a non-regulated analyte in MichiganPFTrDA (perfluorotridecanoic acid) is currently a non-regulated analyte in MichiganPFUnA (perfluoroundecanoic acid) is currently a non-regulated analyte in MichiganSample Number: The identification number that corresponds to the sample taken.Lab Name: Laboratory providing PFAS analysis via EPA method 537.1.Site Code: Specific sample location, when applicable.na: not applicableTaskType: To be used as a way to differentiate the Statewide Surveillance PFAS data (StateSurv) versus the PFAS Compliance Monitoring data (ComplMon).LabNumber: The certified lab code number to help clarify when the LabNameCode values vary, but are actually the same lab (issue with data coming from two different databases). Statewide Surveillance data has null values for this.TreatmentStatus:MP = The midpoint of the influent and effluent points,Raw = The water was not treated for any analytes or compounds,Treated = The water was treated, but not necessarily for PFAS.The data represents the PFAS sample locations, with each location having multiple samples taken, dates for each sample, and the analytical results for each sample. These analytical results include detections for 14 - 28 PFAS analytes, depending on the analytical method used. Each result has a "flags" column that corresponds to important data qualifiers.Understanding the flags: Contaminant data often include flags, also known as qualifiers, which are notes attached to data that gives detailed information about that particular result. In the drinking water PFAS data layer, PFAS analytes associated with a "U" flag were not detected in the sample and therefore a null value is displayed. "J" flagged results indicates an estimated concentration as the result is above the minimum detection limit (MDL) but below the laboratory reporting limit. "J-" flagged results indicates an estimated concentration as the result is above the minimum MDL, below the laboratory reporting limit, but biased low. "UJ" flagged results indicates a not detected at the value estimated reporting limit. "R" flagged results indicates a rejected sample as serious quality control issues render the result value bot usable. "*" flagged results indicates that the result values have not been verified.This contains one hexbins layer (3 miles in height) showing the general location of the water sampling. The hexbins were created by EGLE using ArcGIS Online'sAggregate Points tool. The layer contains one field called "Hexagon ID" that connects the general location with the results of samples found within the hexbin area. The results are found in a related table "Statewide Testing Initiative of Public Water SuppliesSampling Results". There is no precise location attached to the results for security. However, the table does contain a field "Hexagon ID" that connects the the result with the general location symbolized by the hexagon layer.The units for all drinking water PFAS results are measured in PPT (parts per trillion).This data is used intheMPART: PFAS Geographic Information System(item details). For more information about Michigan's PFAS response, please visit ourState of Michigan PFAS Response website.Call 800-662-9278 for assistance with reading or interpreting this data. Questions regarding the drinking water sampling PFAS data can be directed toLisa Dygert (DygertL@Michigan.gov).To submit feedback on the data, please reach out toEGLE-Maps@Michigan.gov.Update Information: This data is static and was last pulled 1/31/23.

Creator:

Michigan Dept. of Environment, Great Lakes, and Energy

Provider:

State of Michigan Open Data Portal

Resource Class:

Web services

Temporal Coverage:

Last modified 2023-04-14

Date Issued:

2021-12-02

Place:

Michigan

Rights:

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

Access Rights:

Public

Format:

File

Language:

English

Date Added:

2024-11-21