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

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

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

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

overlapping
EPA 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.