You a re here : EPA Hom e W a ter WATERS Tools Que ry Tool



# Watershed Assessment, Tracking & Environmental ResultS

Re cent Additions | Conta ct Us Search: All EPA This Area 

### Go



# WATERS Expert Query Tool

Please note: EPA is currently updating the software used for the Simple and Expert Queries. At the end of 2011, EPA will discontinue this version of Expert Query and will only support the new Expert Query. For user support, please contact Waters_Support@epa.gov

. 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 .1. Select columns (data elements or fields) from the selected view .2. Enter your search criteria to target specific records from the database.3.

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

The 303(d) and TMDL Expert Query views have recently been updated to draw data from the ATTAINS database. This update aligns the views with the ATTAINS web reports located at http://www .epa.gov/waters/ir/. Please note, cause of impairment information may differ slightly from the data entry system used to input TMDLs. Users requiring help with this About Waters
Overview Geography Architecture Tools
Data
Documents Reportingtransition may email Waters Support at waters_support@epa.gov for assistance. Regional and state users requiring help with this transition may email Reems.Shera@epamail.epa.gov for assistance.

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 fromAll 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 fromAll 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 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 pointPerm its

.



## 305(b) Water Assessments

Assessed 305 (b) Waters This view identifies assessed waters under the 305(b) program. This view

can be used to obtain summary information for waterbody types (e.g., rivers and streams) in ATTAINS and details at the assessment unit level. Please note, some waters may be assessed for more than one water type.

Assessed 305 (b) Water Causes of Impairment This view identifies the causes of impairment for assessed waters under

the 305(b) program. This view can be used for viewing the details at the assessment unit level. It should not be used to recreate summary numbers at the national or regional level available in the ATTAINS web reports. These summary numbers can not be recreated because some waters may be assessed for more than one cause of impairment and and/or a cause of impairment may have more than one designated use.

Assessed 305 (b) Water Designated Use Attainments This view identifies the state and EPA water designated use information

and the use attainment status for assessed waters under the 305(b) program. This view can be used for viewing the details at the assessment unit level. It should not be used to recreate summary numbers at the national or regional level available in the ATTAINS web reports. These summary numbers can not be recreated because some waters may be assessed for more than one designated use.

Assessed 305 (b) Water Sources of Impairment This view identifies the sources of impairment for assessed waters under

the 305(b) program. This view can be used for viewing the details at the assessment unit level. It should not be used to recreate summary numbers at the national or regional level available in the ATTAINS web reports. These summary numbers can not be recreated because some waters may be assessed for more than one source of impairment and and/or a source of impairment may have one or more associated causes of impairment.

Integrated Report (Water Quality Assessment Report) For states that submit integrated report data, identifies the TMDL

development status for 303(d) waters assessed as impaired under the 305(b) program. To determine if the state of interest is integrated, please visit http://iaspub.epa.gov/waters10/attains_status.state_status. To learn more about Integrated Reporting, please visit http://www .epa.gov/owow/tmdl/guidance.html#2



## Clean Watersheds Needs Survey (CWNS) Information for 2004Needs Reports containing data relating to federally recognized and statedetermined 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 statedetermined 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 overlappingEPA Hom e Privacy and Se curity No tice Conta ct Us 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.