WATERS Expert Query Tool
This query allows you select key data elements to build a tabular report or a Comma Separated Value (CSV) file for downloading.
There are 3 steps to follow to generate a query:
- First, select one view of interest from the list below.
- Select columns (data elements or fields) from the selected view.
- Enter your search criteria to target specific records from the database.
You will need Adobe Acrobat Reader to view
the Adobe PDF files on this page.
See EPA's PDF page
to learn more about PDF, and for a link to the free Acrobat Reader.
Step 1: Start by selecting one view to be the focus of your query.
303(d) Listing & TMDL Information |
||
Current 303(d) Listed Impaired Waters | Waters identified as impaired from the current approved 303(d) lists submitted by states. | |
Current 303(d) Listed Impaired Waters and their Causes of Impairment | Waters identified as impaired as well as their associated causes of impairment from the current approved 303(d) lists submitted by states. | |
303(d) Listed Impaired Waters and their Causes of Impairment from All Years | Waters identified as impaired as well as their associated causes of impairment from all approved 303(d) lists submitted by the states. Includes all approved biyearly 303(d) lists starting in 1998. | |
Detailed information from Approved TMDL Documents | Information from Approved and Established TMDL Documents as well as TMDLs that have been Withdrawn. This includes the pollutants identified in the TMDL Document, the 303(d) Listed Water(s) that the TMDL Document addresses and the associated Cause(s) of Impairment. | |
Information from Approved TMDL Documents | Information from Approved and Established TMDL Documents as well as TMDLs that have been Withdrawn. This includes the pollutants identified in the TMDL Document and the 303(d) Listed Water(s) that the TMDL Document addresses. This view generates TMDL "counts" according to the new algorithm put in place in August 2007. | |
Detailed Information from All TMDL Documents including Draft TMDLs | Information from Approved, Established, Proposed, Submitted, Withdrawn, and Draft TMDL documents. This includes the pollutants identified in the TMDL Document, the 303(d) Listed Water(s) that the TMDL Document addresses and the associated Cause(s) of Impairment. | |
Approved TMDL Documents with linked PCS NPDES Permits. | Information from Approved and Established TMDL Documents. This includes detailed information in the TMDL Document including a link from the Waste Load Allocations to the associated PCS NPDES permits and other point sources. | |
Sources of Pollution for 303(d) Listed Waters | Identifies the pollution sources of the listed waters as reported by 1996/1998/2000 305(b) reports. Because this data is not required, pollution sources may not be identified. | |
2002 305(b) Water Assessments |
||
Assessed 305(b) Waters | Records of electronic submissions of waters assessed by the states for the 305(b) program. | |
Assessed 305(b) Water Causes of Impairment | Identification of Causes of Impairment to waters assessed under the 305(b) program. | |
Assessed 305(b) Water Designated Use Attainments | Identification of state and EPA water designated use information, and the use attainment status of waters assessed under the 305(b) program. | |
Clean Watersheds Needs Survey (CWNS) Information for 2004 |
||
Needs | Reports containing data relating to federally recognized and state-determined needs. | |
Flow | Reports containing data relating to flow measures. | |
Population | Reports containing data relating to population. | |
Additional Technical Data | Reports containing additional technical data relating to CWNS programs and measures. | |
Clean Watersheds Needs Survey (CWNS) Information |
||
Needs | Reports containing data relating to federally recognized and state-determined needs. | |
Flow | Reports containing data relating to flow measures. | |
Population | Reports containing data relating to population. | |
Additional Technical Data | Reports containing additional technical data relating to CWNS programs and measures. | |
Clean Water State Revolving Fund (CWSRF) Benefits Reporting |
||
CWSRF Projects and Loans | Information about CWSRF projects, loans, and borrowers. | |
CWSRF Projects, Project locations and Loans | Information about CWSRF projects, project locations and loans. | |
CWSRF Projects and NPDES information | Information about CWSRF projects and associated NPDES facilities. | |
CWSRF Projects and Water uses | Information about CWSRF projects and water uses. | |
Cross Program InformationThese database views show the results of spatial queries that determine if a spatial overlap exists between entities of two different water programs. Like any spatial query, errors in determining the overlap can occur and they can be grouped as follows:
|
||
CWNS Facilities overlapping with 303(d) Impaired Waters | Overlaps between CWNS Facilities and a state listed 303(d) Impaired Water. | |
CWNS Facilities overlapping with 303(d) Impaired Water Impairment Causes | Overlaps between CWNS Facilities and a state listed 303(d) Impaired Water Impairment Causes. | |
CWNS Facilities overlapping with 303(d) Impaired Water Impairment Causes based on Likely TPC Discharges. | Overlaps between CWNS Facilities and a state listed 303(d) Impaired Water Impairment causes based on likely TPC Discharges. | |
CWNS Facilities overlapping with 303(d) Impaired Waters where a TMDL has been established. | Overlaps between CWNS Facilities and a state listed 303(d) Impaired Waters where a TMDL has been established. | |
CWNS Facilities overlapping with 303(d) Impaired Water Impairment Causes where a TMDL has been established. | Overlaps between CWNS Facilities and a state listed 303(d) Impaired Water Impairment Causes where a TMDL has been established. |