You are here
Water Dashboard Data Sources and Formulas
This document provides information on the data sources and metrics used to derive the reports for the CWA Dashboard. The CWA Dashboard will have two views ("Activity" and "Performance") with each view separated into six boxes. The tables below show details for each dashboard report currently available for review. This document may be particularly useful for staff in authorized state NPDES programs and other technical users.
ECHO Clean Water Act (CWA) Dashboard Activity View Layout
| Box 1 — Facilities | Box 2 — Inspections | Box 3 — Violations |
| Box 4 — Serious Violations | Box 5 — Enforcement Actions | Box 6 — Penalties |
ECHO Clean Water Act (CWA) Dashboard Performance View Layout
| Box 1 — Facilities | Box 2 — Inspections | Box 3 — Violations |
| Box 4 — Serious Violations | Box 5 — Enforcement Actions | Box 6 — Penalties |
| Dashboard Box | View | Report Title | Data Source | Data Label/Data Source Metrics |
|---|---|---|---|---|
| 1 | Default | NPDES Permits by Type - 2013 (All) | SRF | Major (1.a.1+ 1.a.2) Non-Major Individual Permit (1.a.3) Non-Major General Permit (1.a.4) |
| Dropdown Option 1 | NPDES Permits by Issuing Agency - 2013 (Majors, All) | SRF | State, EPA (1.a.1+ 1.a.2) | |
| Dropdown Option 2 | NPDES Permits by Issuing Agency - 2013 (Non-Majors, All) | SRF | State, EPA (1.a.3 + 1.a.4) | |
| Dropdown Option 3 | NPDES Permits by Issuing Agency (Non-Majors, Individual) Source: ANCR Data |
ANCR | State, EPA (1) 1 | |
| Dropdown Option 4 | Number of Expired Permits - 2013 | EPA/OW | 1 | |
| Dropdown Option 5 | Percentage of Active Individual NPDES Permits with Limits in EPA's Data System - ICIS-NPDES (Majors) | SRF | Major Permits w/ Limits in ICIS-NPDES (%) (1.b.1) National Average Goal (Majors Only) at 95% |
|
| Dropdown Option 6 | Percentage of Active Individual NPDES Permits with Limits in EPA's Data System - ICIS-NPDES (Non-Majors) | SRF | Non-Major Permits w/ Limits in ICIS-NPDES (%) (1.c.1) National Average |
|
| Dropdown Option 7 | Percentage of Active Individual NPDES Permits with DMRs in EPA's Data System - ICIS-NPDES (Majors) | SRF | Major Permits w/ Limits & DMRs in ICIS-NPDES (%) (1.b.2) National Average Goal (Majors Only) at 95% |
|
| Dropdown Option 8 | Percentage of Active Individual NPDES Permits with DMRs in EPA's Data System - ICIS-NPDES (Non-Majors) | SRF | Non-Major Permits w/ Limits & DMRs in ICIS-NPDES (%) (1.c.2) National Average |
|
| Dropdown Option 9 | Number of Active Individual NPDES Permits with Limits and DMRs in EPA's Data System - ICIS-NPDES (Majors) | SRF | Active, Ind. Permits (1.a.1) Active, Ind. Permits (Limits in ICIS-NPDES) (1.b.1) Active, Ind. Permits (Limits and DMRs in ICIS-NPDES) (1.b.2) |
|
| Dropdown Option 10 | Number of Active Individual NPDES Permits with Limits and DMRs in EPA's Data System - ICIS-NPDES (Non-Majors) | SRF | Active, Ind. Permits (1.a.3) Active, Ind. Permits (Limits in ICIS-NPDES) (1.c.1) Active, Ind. Permits (Limits and DMRs in ICIS-NPDES) (1.c.2) |
|
| Dropdown Option 11 | Major Facilities with Manual Override of RNC/SNC to Compliant Status (Percentage) | SRF | Major [1.b.3/(1.a.1+1.a.2)] National Average |
|
| 2 | Default | Facilities Inspected by State or EPA (Majors, %) | SRF | Major [5.a.1/(1.a.1+1.a.2) with metrics filtered on "State" and separately by "EPA")] Goal (Majors Only) at 50% National Average (State led, Majors only) National Average (EPA led, Majors only) |
| Dropdown Option 1 | Facilities Inspected by State or EPA (Non-Majors Ind., %) | SRF | Non-Major Ind. [5.b.1/1.a.3 with metrics filtered on "State" and separately by "EPA"] National Average (State led, Non-Major Ind.) National Average (EPA led, Non-Major Ind.) |
|
| Dropdown Option 2 | Facilities Inspected by State or EPA (Non-Majors Gen. Permit, %) | SRF | Non-Major General Permit [5.b.2/1.a.4 with metrics filtered on "State" and separately by "EPA"] National Average (State led, Non-Major Gen. Permit) National Average (EPA led, Non-Major Gen. Permit) 1 |
|
| Dropdown Option 3 | Facilities Reviewed by State or EPA (Non-Major, Ind.) (%) | ANCR | Non-Major Ind. (2/1) National Averages (Non-Major Ind.) by State and EPA |
|
| 3 | Default | Facilities in Non-Compliance (%) | SRF & ANCR | Major (7.d.1/1.a.1) Non-Major, Ind (ANCR 10/1) |
| Dropdown Option 1 | Facilities in Non-Compliance (Majors, %) | SRF | Non-Compliance SNC (8.a.2) with National Average Non-Compliance (Not SNC) [(7.d.1-8.a.1)/1.a.1] with National Average |
|
| Dropdown Option 2 | Facilities in Non-Compliance (Non-Majors, %) | ANCR | Non-Major Ind. (10/1) with National Average | |
| Dropdown Option 3 | Percentage of Inspected Facilities with Single Event Violation by State or EPA | SRF | (7.a.1+7.a.2)/(5.a.1+5.b.1+5.b.2) with National Averages by State and EPA | |
| 4 | Default | Major Facilities in Significant Non-Compliance (%) | SRF | Major (8.a.2) with National Average |
| Dropdown Option 1 | Non-Major Facilities in Category 1 Non-Compliance (Ind. %) | ANCR | Non-Major Ind. (3/1) with National Average | |
| Dropdown Option 2 | Facilities One or More Years Behind Construction Schedule Deadlines (%, Non-Major Ind.) | ANCR | Non-Major Ind. (7/1) with National Average | |
| 5 | Default | Major Facilities in Non-Compliance with Formal Enforcement Actions (%) | SRF | Major [1.f.1/7.d.1 with metrics filtered on "Major"] (bar) 2 National Averages of Major Facilities in NC w/ Formal Action (line) 2 Major Facilities in Significant Non-Compliance (8.a.2) (line) |
| Dropdown Option 1 | Non-Major Facilities in Non-Compliance with Formal Enforcement Actions (%) (ANCR Data) | ANCR | Non-Major Ind. (5/10) with National Average Non-Major Ind. In Category 1 Non-Compliance (3/1) [For these states the line showing Category 1 non-compliance is shown at 0% on this chart.] |
|
| Dropdown Option 2 | Facilities with Timely Enforcement Action as Appropriate (Majors, Individual, %) | SRF | Major (10.a.1) National Average Goal (Majors Only) at 98% |
|
| Dropdown Option 3 | Non-Compliance & Enforcement Actions Comparison - Majors | SRF | Major Facilities in Non-Compliance (7.d.1) Enforcement Actions (All) (1.e.1 + 1.f.1, filtered on "Major") Major Facilities in Significant Non-Compliance (8.a.1) Enforcement Actions (Formal Only) (1.f.1, filtered on "Major") |
|
| Dropdown Option 4 | Non-Compliance & Enforcement Actions Comparison - Non-Majors (ANCR Data) | ANCR | Non-Major Facilities in Non-Compliance (10) Enforcement Actions (All) (5 + 8) Non-Major Facilities in Cat. 1 Non-Compliance (3) Enforcement Actions (Formal Only) (5) |
|
| 6 | Default | Median Monetary Penalty (All) | SRF | State, EPA (1.g.1 - median) |
| Dropdown Option 1 | Number of Enforcement Actions with Monetary Penalties (All) | SRF | State, EPA (1.g.1) | |
| Dropdown Option 2 | Total Monetary Penalties Assessed (All) | SRF | State, EPA (1.g.2) | |
| Dropdown Option 3 | Total Monetary Penalties Assessed (Non-Major, Individual) Source: ANCR Data | ANCR | State, EPA (5.a) |
2 - This metric will be changed to Major Facilities in Significant Non-Compliance with Formal Enforcement Actions (%) (1.f.1/8.a.1) at next update of the dashboard.