Accessing Unregulated
Contaminant Monitoring Rule (UCMR) Information
EPA uses data generated by the UCMR to evaluate and prioritize contaminants
on the Drinking Water Contaminant Candidate List, a list of contaminants
EPA is considering for possible new drinking water standards. Additional
information on the rule is available on the UCMR
main page.
The data associated with the revised UCMR (1999) is meant to assist the
Administrator in determining whether or not to regulate a certain contaminant.
It was designed as a national exposure study. Therefore, extreme caution
should be used in any interpretation of the data which contains only a
subset of the entire database. The monitoring is scheduled during the
period from 2001 until 2003. So, any interpretation of data before all
the data are collected (probably mid-2004) can lead to false conclusions.
Data you can download are available in MS Excel Pivot Tables. They will
be periodically uploaded to include the latest approved UCMR samples data.
About MS Excel PivotTables®
To use these tables you'll need MS Excel 97 or later. Detailed instructions
are available for downloading, and summary instructions are included in
each PivotTable. No prior knowledge of spreadsheets is required.
PivotTables are multidimensional databases (MDBs) that provide online
analytical processing, or OLAP. They enable you to quickly summarize,
cross-tabulate, and analyze large amounts of data. You can pivot, or rotate,
rows and columns to see different summaries of the source data, filter
the data, and drill-down to the details in the underlying source data.
Data included in UCMR PivotTable®
This PivotTable contains information on small systems sample results.
Any or all of the following facts for a contaminant-
- # non-detects
- # detects
- minimum detect
- maximum detect
- average detect
-can be categorized by any combination of the following water system
attributes:
- EPA Region
- Geography type-state, tribal, territory
- State
- Primary county served
- Water system type
- Size category
- Primary source of water
- Owner type
-or any combination of the following sample attributes:
- Minimum Reporting Level for an analytical method and contaminant
- Unit of measure
- Sample collection month and year
- Sample point type
- Sample analysis type
- Analytical method
Details on these attributes are provided in the PivotTable.
You can double-click on any data cell to obtain PWS-level information.
|