SRF Data Metrics Query Help | Enforcement & Compliance History Online (ECHO)

State Review Framework - Data Metrics Query Help

SRF State Trends Report

The SRF State Trends Report allows users to view summary State Review Framework data metrics in one state, for the Clean Air Act (CAA), Clean Water Act (CWA), or Resource Conservation and Recovery Act (RCRA) over multiple fiscal years. The SRF State Trends Report allows users to graph individual metrics across multiple years, and provides users with an excellent medium to analyze metric statistics and trends.

SRF State Trends Report Query

Statute
Options include CAA, CWA, and RCRA. The CWA State Trends Report will run either a CWA PCS or ICIS-NPDES report. See the full list of PCS or ICIS-NPDES states.

Time Periods
Users can select multiple time periods. Time period options date back to federal Fiscal Year 2004 (FY04).

Exclude EPA and Combined Results
Users can check the "Exclude EPA and Combined Results" checkbox to remove all metric rows that are not applicable to a state review.

State Summary
Users can select one state.

SRF State Trends Report Output

SRF State Trends Report Output columns include, in order:

Metric Name
Metric Type
Agency
Metric Value for each selected fiscal year (Metric Value = Metric Count divided by the Metric Universe, expressed as a percentage) ²
Graph (Allows user to graph Metric Values across selected fiscal years)

SRF Multi-State Report

The SRF Multi-State Report, pulls only FY2008 Frozen data. The SRF Multi-State Report allows users to view selected CAA, CWA, or RCRA data metrics, for all US states and territories, over one fiscal year. The SRF Multi-State Report allows users to graph individual metrics across all US states and territories.

SRF Multi-State Report Query

Statute
Options include CAA, CWA, and RCRA. The CWA State Trends Report will run either a CWA PCS or ICIS-NPDES report. See the full list of PCS or ICIS-NPDES states.
Metric
The "Ctrl" key can be used to select multiple metrics for display.

Metric Report
Selecting the "Metric Report" option will produce an HTML report with results from each selected metric in separate columns.

National Download
Selecting the "National Download" link on the query page will open one of three file options (PDF, XLS, CSV) that contain Data Metrics results for every state and every metric.

Graph
Selecting the "Graph" option will produce a fusion chart graph of the selected metric. Users are allowed to graph only one metric at a time. Users can also produce a graph by clicking on the link provided in the last row of the "Metric Report."

SRF Multi-State Report Graph

Data Download Options
Users can download a comma delimited text file, or excel download by clicking on the "Download XLS" links located just above the graph. The metric numbers shown on the download are based on the Data Metrics programming structure.

The first character indicates the media (A=CAA, R=RCRA, W=CWA-PCS, P=CWA-ICIS NPDES, and C=CWA-Combined (PCS and ICP)).
The next two characters represent the metric number, with a leading zero for numbers under 10.
The next 2 characters represent The metric letter.
The last character indicates the agency (S=State, C=Combined, and E=EPA).

To print a SRF Multi-State Report graph on one page:

Left click on the chart to activate the fusion control
Right click on the chart, and select "print chart"

How to print a Data Metrics Flash Chart.

Exporting a graph to a "pdf" or "jpg":

The SRF Multi-State Report Graphing Utility now has the ability to produce 'jpgs' and 'pdfs' of the graph for export. This function is only available to users who have the latest version of Adobe Flash (version 10). Please note, users can sometimes have different versions of Flash installed across different browsers on your machine (for example, a user may have flash version 9 installed in Firefox, and flash version 10 installed in Internet Explorer). In order to export and save your chart:

Right click on the chart, and select what kind of file export you would like (options include pdf and jpg).
The SRF Multi-State Report Graphing Utility will then process your download (this can take up to 30 seconds), and enable the "Save" link below the graph.
Click on the activated "Save" link. Users may need to specify a file extension when saving their pdf or jpg.

Export and Print instructions can also be viewed by clicking the "Print" and "Export" buttons in the upper-right corner of each SRF Multi-State Report graph.

SRF Multi-State Report Output

The columns provided in the SRF Multi-State Report output include:

Region
State
One column for each selected metric (column displays "Metric Value")

The last row on the SRF Multi-State Report output provides graph links, which allow users to graph metric values across all US states and territories.

Data Download Options
Users can download a comma delimited text file, or excel download by clicking on the "Save Results" links located directly below the results table. The metric numbers shown on the download are based on the programming structure.

The first character indicates the media (A=CAA, R=RCRA, W=CWA-PCS, P=CWA-ICIS NPDES, and C=CWA-Combined (PCS and ICP)).
The next two characters represent the metric number, with a leading zero for numbers under 10.
The next 2 characters represent The metric letter.
The last character indicates the agency (S=State, C=Combined, and E=EPA).

¹Some Data Metrics display "Metric Count" in the "Metric Value" column. In this situation, metrics are not expressed as a percentage, and the "Metric Count," "Metric Universe," and "Metric Not Counted" columns are populated with a value of "N/A."

²Some Data Metrics display "Metric Count" in the "Metric Value" column. In this situation, metrics are not expressed as a percentage.

State Review Framework - Data Metrics Query Help