River E. coli Monitoring Sites in Michigan

Historic surface water E. coli monitoring site locations and data summaries showing estimated compliance rates with the Michigan water quality standard. Data are compiled by the State of Michigan Department of Environment, Great Lakes and Energy (EGLE) from EGLE-Water Resources Division and publicly available sources (Water Quality Exchange [WQX]). At a minimum, this dataset is updated annually in December from EGLE's own data and WQX. Please note that it is not updated immediately as new results are available. Only monitoring events with a daily geometric mean of three or more samples are included in this dataset. Fields include the site ID, site description, number of sampling events, whether there was a 30-day water quality standard exceedance, sample collector (agency), and the number of water quality standard exceedances. Total Body Contact is represented as TBC, while Partial Body Contact is represented as PBC. Note that if a monitoring event exceeds both the TBC and the PBC, it will only be counted as a PBC exceedance numerically. Field Name Description SiteID Site Identification Number SiteDescription Description of site DataCollector Organization that collected data including state agencies, local health departments and other organizations NumberOfSamples Number of samples collected at a site PBCExceedances Number of partial body contact (PBC) water quality standard exceedances NumberOfSamplesMeetingDailyWQS Number of samples collected that meet daily E. Coli water quality standards NumberOfTotalBodyContactExceeda Number of total body contact (TBC) water quality standard exceedances NumberOf30DayExceedances Number of samples that exceeded the geometric mean of E. coli samples collected over a 30-day period YearMonitored The year samples were collected ReportUrl URL for report containing site information (if available) EPAHowsMyWaterwayLink URL for corresponding How’s My Waterway Water Quality report EPADataDownload URL to download data from a particular site Learn more about Michigan's Statewide E. coli Total Maximum Daily Load. Additional questions can be directed to Molly Rippke ([e-mail]).本数据集涵盖历史地表水大肠埃希氏菌（Escherichia coli, E. coli）监测点位信息与数据汇总，展示符合密歇根州水质标准的估算达标率。数据由密歇根州环境、大湖与能源部（State of Michigan Department of Environment, Great Lakes and Energy, EGLE）从其水资源部门及公开数据源（水质交换平台[Water Quality Exchange, WQX]）汇编得到。本数据集至少每年12月基于EGLE自有数据与WQX数据完成更新。请注意，本数据集不会随新监测结果实时更新。 本数据集仅纳入单日几何平均样本量不少于3份的监测事件。数据集字段包括点位编号、点位描述、采样事件总数、是否存在30天水质标准超标情况、采样机构及水质标准超标次数。其中，全身接触（Total Body Contact, TBC）与部分身体接触（Partial Body Contact, PBC）分别以TBC与PBC代称。需注意：若某一监测事件同时超出TBC与PBC水质标准，数值统计时仅计为PBC超标。 ### 字段详细说明 - **SiteID**：点位识别编号 - **SiteDescription**：点位详细描述 - **DataCollector**：负责采集数据的机构，涵盖州级行政机构、地方卫生部门及其他社会组织 - **NumberOfSamples**：某点位采集的总样本份数 - **PBCExceedances**：部分身体接触（Partial Body Contact, PBC）水质标准超标次数 - **NumberOfSamplesMeetingDailyWQS**：符合每日大肠埃希氏菌水质标准的采集样本数 - **NumberOfTotalBodyContactExceedances**：全身接触（Total Body Contact, TBC）水质标准超标次数（注：原文字段名存在笔误，已补全后缀） - **NumberOf30DayExceedances**：30天周期内大肠埃希氏菌样本几何均值超出标准的样本总数 - **YearMonitored**：样本采集年份 - **ReportUrl**：包含点位信息的报告链接（如可获取） - **EPAHowsMyWaterwayLink**：对应美国环保署"我的水道状况"水质报告的链接 - **EPADataDownload**：特定点位数据的下载地址 可进一步了解密歇根州全州大肠埃希氏菌最大日负荷总量（Total Maximum Daily Load, TMDL）相关内容。如有额外疑问，请联系Molly Rippke（邮箱：[e-mail]）。