Name: River E. coli Monitoring Sites

Display Field: SiteID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

Description: <p>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.</p><div>&nbsp;</div><div><figure><figure><figure><figure><figure><figure><figure><figure><figure><figure><figure><figure><figure><figure><figure><figure><figure><figure><figure><figure><figure><figure><figure><table style="border-collapse:collapse;" cellpadding="0" cellspacing="0" border="1"><tbody><tr><td style="border:1.0pt solid windowtext; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;"><strong>Field Name</strong></p></td><td style="border-bottom-style:solid; border-color:windowtext; border-left-style:none; border-right-style:solid; border-top-style:solid; border-width:1.0pt; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;"><strong>Description</strong></p></td></tr><tr><td style="border-bottom-style:solid; border-color:windowtext; border-left-style:solid; border-right-style:solid; border-top-style:none; border-width:1.0pt; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">SiteID</p></td><td style="border-bottom:1.0pt solid windowtext; border-left-style:none; border-right:1.0pt solid windowtext; border-top-style:none; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">Site Identification Number</p></td></tr><tr><td style="border-bottom-style:solid; border-color:windowtext; border-left-style:solid; border-right-style:solid; border-top-style:none; border-width:1.0pt; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">SiteDescription</p></td><td style="border-bottom:1.0pt solid windowtext; border-left-style:none; border-right:1.0pt solid windowtext; border-top-style:none; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">Description of site</p></td></tr><tr><td style="border-bottom-style:solid; border-color:windowtext; border-left-style:solid; border-right-style:solid; border-top-style:none; border-width:1.0pt; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">DataCollector</p></td><td style="border-bottom:1.0pt solid windowtext; border-left-style:none; border-right:1.0pt solid windowtext; border-top-style:none; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">Organization that collected data including state agencies, local health departments and other organizations</p></td></tr><tr><td style="border-bottom-style:solid; border-color:windowtext; border-left-style:solid; border-right-style:solid; border-top-style:none; border-width:1.0pt; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">NumberOfSamples</p></td><td style="border-bottom:1.0pt solid windowtext; border-left-style:none; border-right:1.0pt solid windowtext; border-top-style:none; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">Number of samples collected at a site</p></td></tr><tr><td style="border-bottom-style:solid; border-color:windowtext; border-left-style:solid; border-right-style:solid; border-top-style:none; border-width:1.0pt; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">PBCExceedances</p></td><td style="border-bottom:1.0pt solid windowtext; border-left-style:none; border-right:1.0pt solid windowtext; border-top-style:none; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">Number of partial body contact (PBC) water quality standard exceedances</p></td></tr><tr><td style="border-bottom-style:solid; border-color:windowtext; border-left-style:solid; border-right-style:solid; border-top-style:none; border-width:1.0pt; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">NumberOfSamplesMeetingDailyWQS</p></td><td style="border-bottom:1.0pt solid windowtext; border-left-style:none; border-right:1.0pt solid windowtext; border-top-style:none; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">Number of samples collected that meet daily E. Coli water quality standards</p></td></tr><tr><td style="border-bottom-style:solid; border-color:windowtext; border-left-style:solid; border-right-style:solid; border-top-style:none; border-width:1.0pt; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">NumberOfTotalBodyContactExceeda</p></td><td style="border-bottom:1.0pt solid windowtext; border-left-style:none; border-right:1.0pt solid windowtext; border-top-style:none; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">Number of total body contact (TBC) water quality standard exceedances</p></td></tr><tr><td style="border-bottom-style:solid; border-color:windowtext; border-left-style:solid; border-right-style:solid; border-top-style:none; border-width:1.0pt; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">NumberOf30DayExceedances</p></td><td style="border-bottom:1.0pt solid windowtext; border-left-style:none; border-right:1.0pt solid windowtext; border-top-style:none; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">Number of samples that exceeded the geometric mean of E. coli samples collected over a 30-day period</p></td></tr><tr><td style="border-bottom-style:solid; border-color:windowtext; border-left-style:solid; border-right-style:solid; border-top-style:none; border-width:1.0pt; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">YearMonitored</p></td><td style="border-bottom:1.0pt solid windowtext; border-left-style:none; border-right:1.0pt solid windowtext; border-top-style:none; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">The year samples were collected</p></td></tr><tr><td style="border-bottom-style:solid; border-color:windowtext; border-left-style:solid; border-right-style:solid; border-top-style:none; border-width:1.0pt; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">ReportUrl</p></td><td style="border-bottom:1.0pt solid windowtext; border-left-style:none; border-right:1.0pt solid windowtext; border-top-style:none; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">URL for report containing site information (if available)</p></td></tr><tr><td style="border-bottom-style:solid; border-color:windowtext; border-left-style:solid; border-right-style:solid; border-top-style:none; border-width:1.0pt; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">EPAHowsMyWaterwayLink</p></td><td style="border-bottom:1.0pt solid windowtext; border-left-style:none; border-right:1.0pt solid windowtext; border-top-style:none; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">URL for corresponding How’s My Waterway Water Quality report&nbsp;</p></td></tr><tr><td style="border-bottom-style:solid; border-color:windowtext; border-left-style:solid; border-right-style:solid; border-top-style:none; border-width:1.0pt; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">EPADataDownload</p></td><td style="border-bottom:1.0pt solid windowtext; border-left-style:none; border-right:1.0pt solid windowtext; border-top-style:none; padding:0in 5.4pt; width:233.75pt;" width="312"><p style="line-height:normal; margin-bottom:0in;">URL to download data from a particular site</p></td></tr><tr><td>ExceedanceClass</td><td><p><span style="font-size:14px;">A qualitative classification assigned to help illustrate E. Coli Water Quality Attainment at individual sites.&nbsp;</span></p><p><span style="font-size:14px;">Meets all E. coli standards = less than 10% of samples exceed PBC AND Less than 10% exceed TBC AND <span>no </span>30-day standard exceedances.</span></p><p><span>Exceeds TBC Standard, meeting PBC Standard&nbsp;</span><span style="font-size:14px;"> = more than 10% of samples exceed TBC </span><span>OR there is a 30-day Standard Exceedance</span></p><p><span>Exceeds TBC Standard, occasionally exceeds PBC Standard&nbsp; </span><span style="font-size:14px;">= Between 10 and 70% of samples collected exceeded the PBC standard.</span></p><p><span>Exceeds TBC Standard, frequently exceeds PBC Standard</span><span style="font-size:14px;">= Greater than 70% of samples collected exceeded the PBC standard.</span></p></td></tr></tbody></table></figure></figure></figure></figure></figure></figure></figure></figure></figure></figure></figure></figure></figure></figure></figure></figure></figure></figure></figure></figure></figure></figure></figure></div><div>&nbsp;</div>

Copyright Text: Molly Rippke, Water Resources Division, Michigan Department of Environment, Great Lakes and Energy (EGLE). WQX derived data is attributed to the data collector as indicated in the "Collector" field. Please direct question or corrections to: Rippkem@michigan.gov. Original data may also be requested via email (please request by watershed, county or site ID).

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10048626.5528104
YMin: 5108908.20888905
XMax: -9142478.10945838
YMax: 6020632.32713023
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"color":[255,255,255,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[92,92,92,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}}},"transparency":0}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• SiteID (type: esriFieldTypeString, alias: Site ID/Storet, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SiteDescription (type: esriFieldTypeString, alias: Site Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DataCollector (type: esriFieldTypeString, alias: Data Collector, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NumberOfSamples (type: esriFieldTypeDouble, alias: Number Of Samples, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PBCExceedances (type: esriFieldTypeDouble, alias: Number Of Partial Body Contact Exceedances, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NumberOfSamplesMeetingDailyWQS (type: esriFieldTypeDouble, alias: Number of Samples Meeting Daily Water Quality Standards, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NumberOfTotalBodyContactExceeda (type: esriFieldTypeDouble, alias: Number Of Total Body Contact Exceedances, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NumberOf30DayExceedances (type: esriFieldTypeString, alias: 30-Day Standard Exceedanced?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• YearMonitored (type: esriFieldTypeString, alias: Year Monitored, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreatedUser (type: esriFieldTypeString, alias: Created User, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CreatedDate (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LastEditedUser (type: esriFieldTypeString, alias: Last Edited User, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LastEditedDate (type: esriFieldTypeDate, alias: Last Edited Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ReportUrl (type: esriFieldTypeString, alias: Report Url, SQL Type: sqlTypeOther, length: 350, nullable: true, editable: true)
• EPAHowsMyWaterwayLink (type: esriFieldTypeString, alias: EPA How’s My Waterway Link, SQL Type: sqlTypeOther, length: 350, nullable: true, editable: true)
• EPADataDownload (type: esriFieldTypeString, alias: EPA Data Download, SQL Type: sqlTypeOther, length: 350, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/3/2026 3:17:39 PM

Schema Last Edit Date: 2/20/2026 2:01:02 PM

Data Last Edit Date: 4/3/2026 3:17:39 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat