Skip common site navigation and headers
United States Environmental Protection Agency
Watershed Assessment Tracking & Environmental Results
Begin Hierarchical Links EPA Home > Water > WATERS > Tools > Query Tool End Hierarchical Links

 

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:

  1. First, select one view of interest from the list below.
  2. Select columns (data elements or fields) from the selected view.
  3. Enter your search criteria to target specific records from the database.
The Expert Query User Manual (PDF) is a detailed manual that explains how to use the Expert Query Tool. The Expert Query Tool User's Guide (HTML) is a less detailed guide that highlights the major features of the Expert Query tool..

You will need Adobe Acrobat Reader to view the Adobe PDF file on this page. See EPA's PDF page for more information about getting and using 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 Information

These 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:

  • False Positives occur when the locational information of one the entities is either incorrect or not of sufficient quality to determine it's exact location.
  • False Negatives occur when locational information is missing or not available for all of the entities.
In addition to the entity locational information, errors, although few, may also exist in the spatial network of rivers, streams, and other waterbodies that comprise the National Hydrography Database (NHD) jointly maintained by USGS and USEPA. Errors in the NHD may contribute both to false positive and false negative readings.
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.

 

 
Begin Site Footer

EPA Home | Privacy and Security Notice | Contact Us