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

 

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)
2 Default Facilities Inspected by State or EPA (All) SRF Major (5.a.1)
Non-Major Individual Permit (5.b.1)
Non-Major General Permit (5.b.2)
Dropdown Option 1 Facilities Inspected by State or EPA (All) — State/EPA Split SRF State, EPA (5.a.1, 5.b.1, 5.b.2)
Dropdown Option 2 Facilities Inspected by State or EPA (Majors, All) SRF State, EPA (5.a.1)
Dropdown Option 3 Facilities Inspected by State or EPA (Non-Majors, All) SRF State, EPA (5.b.1 + 5.b.2)
Dropdown Option 4 Facilities Reviewed by State or EPA (Non-Majors with Individual Permit)
Source: ANCR Data
ANCR State, EPA (2)
3 Default Facilities in Noncompliance (All) SRF Major (7.d.1) 
Non-Major (7.f.1+7.g.1)
Dropdown Option 1 Facilities in Noncompliance (Majors with Individual Permit) SRF Noncompliance (SNC) (8.a.1)
Noncompliance (Not SNC) (7.d.1 - 8.a.1)
Dropdown Option 2 Facilities in Significant Noncompliance (Majors with Individual Permit) SRF State, EPA (8.a.1)
Dropdown Option 3 Facilities in Noncompliance (Not SNC) (Majors with Individual Permit) SRF State, EPA (7.d.1 - 8.a.1)
Dropdown Option 4 Facilities in Noncompliance (Non-Majors with Individual Permit) SRF Category 1 (7.f.1)
Category 2 ( 7.g.1)
Dropdown Option 5 Facilities in Category 1 Non-
Compliance (Non-Majors with 
Individual Permit)
SRF State, EPA (7.f.1)
Dropdown Option 6 Facilities with Single Event Violations (All) SRF Major (7.a.1)
Non-Major (7.a.2)
Dropdown Option 7 Facilities with Compliance Schedule Violations (All) SRF State, EPA (7.b.1)
Dropdown Option 8 Facilities with Permit Schedule Violations (All) SRF State, EPA (7.c.1)
4 Default Facilities in Category 1 Noncompliance (All with Individual Permit) SRF Major (8.a.1)
Non-Major (7.f.1)
Dropdown Option 1 Facilities in Category 1 Noncompliance (Majors in SNC with Individual Permit) SRF State, EPA (8.a.1)
Dropdown Option 2 Facilities in Category 1 Noncompliance (Non-Majors with
Individual Permit)
SRF State, EPA (7.f.1)
Dropdown Option 3 Facilities One or More Years Behind Construction Schedule Deadlines (Non-Major, Individual)
Source: ANCR Data
ANCR State, EPA (7)
5 Default Facilities with Enforcement Actions (All) - Formal/Informal Split SRF Formal (1.e.1)
Informal (1.f.1)
Dropdown Option 1 Facilities with Enforcement Actions (All) - State/EPA Split SRF State, EPA (1.e.1 + 1.f.1)
Dropdown Option 2 Facilities with Formal Enforcement Actions (All) SRF State, EPA (1.e.1)
Dropdown Option 3 Facilities with Informal Enforcement Actions (All) SRF State, EPA (1.f.1)
Dropdown Option 4 Facilities with Enforcement Actions (Major, All) SRF State, EPA (1.e.1+1.f.1 filtered on "Major")
Dropdown Option 5 Facilities with Enforcement Actions (Non-Major, Individual)
Source: ANCR Data
ANCR Formal(5)
Informal(8)
Dropdown Option 6 Facilities that Received an Administrative Penalty Order (Non- Major, Individual)
Source: ANCR Data
ANCR State, EPA (5.b)
Dropdown Option 7 Facilities with Permit Modifications by Permitting Authority Extending Compliance Deadlines (Non-Major, Individual)
Source: ANCR Data
ANCR State, EPA (6)
6 Default Number of Enforcement Actions with Monetary Penalties (All) SRF State, EPA (1.g.1)
Dropdown Option 1 Total Monetary Penalties Assessed (All) SRF State, EPA (1.g.2)
Dropdown Option 2 Median Monetary Penalty (All) SRF State, EPA (1.g.2 - median)
Dropdown Option 3 Total Monetary Penalties Assessed 
(Non-Major, Individual)
Source:ANCR Data
ANCR State, EPA (5.a)

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 Noncompliance (%) SRF & ANCR Major (7.d.1/1.a.1) 
Non-Major, Ind (ANCR 10/1)
Dropdown Option 1 Facilities in Noncompliance (Majors, %) SRF Noncompliance SNC (8.a.2) with National Average
Noncompliance (Not SNC) [(7.d.1-8.a.1)/1.a.1] with National Average
Dropdown Option 2 Facilities in Noncompliance (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 Noncompliance (%) SRF Major (8.a.2) with National Average
Dropdown Option 1 Non-Major Facilities in Category 1 Noncompliance (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 Noncompliance 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 Noncompliance (8.a.2) (line)
Dropdown Option 1 Non-Major Facilities in Noncompliance with Formal Enforcement Actions (%) (ANCR Data) ANCR Non-Major Ind. (5/10) with National Average
Non-Major Ind. In Category 1 Noncompliance (3/1) [For these states the line showing Category 1 noncompliance 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 Noncompliance & Enforcement Actions Comparison - Majors SRF Major Facilities in Noncompliance (7.d.1)
Enforcement Actions (All) (1.e.1 + 1.f.1, filtered on "Major")
Major Facilities in Significant Noncompliance (8.a.1)
Enforcement Actions (Formal Only) (1.f.1, filtered on "Major")
Dropdown Option 4 Noncompliance & Enforcement Actions Comparison - Non-Majors (ANCR Data) ANCR Non-Major Facilities in Noncompliance (10)
Enforcement Actions (All) (5 + 8)
Non-Major Facilities in Cat. 1 Noncompliance (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)

1 - To be developed

2 - This metric will be changed to Major Facilities in Significant Noncompliance with Formal Enforcement Actions (%) (1.f.1/8.a.1) at next update of the dashboard.

Top of Page