Protecting Oregon's Environment
Oregon State Seal
Oregon Department of Environmental Quality

Water Quality

Water Quality Assessment Database

 WQ Info Guides:
by alphabet
by category

Water Quality Assessment - Oregon's 2010 Integrated Report Assessment Database and 303(d) List

[About the Database]  [Instructions]  [Review the Database]

The 2010 Integrated Report Assessment Database contains information on water quality in Oregon’s surface waters and includes waters identified as water quality limited that need TMDLs (Category 5: Section 303(d) list).

The assessment database contains information and 303(d) listings and de-listings approved by EPA on March 15, 2012. EPA also disapproved DEQ’s submittal for not including other waters on the 303(d) list and on Dec. 14, 2012 added 870 waters to Oregon’s 2010 303(d) list.

With EPA’s action, Oregon’s 2010 303(d) list is final and includes the listings approved in March 2012 along with listings added in December 2012.

You can review the 2010 Integrated Report using default or customized settings (See Review the Database), or review these pre-selected lists:

  • All Category 5 Water Quality Limited Waters needing a TMDL (303(d) list) (As approved by EPA Mar. 15, 2012 with EPA final additions from Dec. 14, 2012)
  • Water bodies added to the Category 5 303(d) list in 2010 (303(d) Added 2010)
  • Water bodies removed from the 303(d) lists in 2010 (De-listed 2010) (Approved by EPA Mar. 15, 2012)

 About the Database

The 2010 Integrated Report Assessment Database contains new assessment information and updates to assessments from 1998, 2002, and 2004. (See 2004/2006 Integrated Report Database).The updates made in 2010 are described in the “2010 Assessment Action” report field. If no new data evaluations or assessments are done in 2010, the assessment information and the status assigned in previous assessments are carried forward into the 2010 Integrated Report and noted as “No 2010 action”. 

Information for each record in the assessment database includes:

  • Basin Name - Name of USGS 3rd level hydrologic unit.
  • Subbasin, 4th Field HUC - Name and Hydrologic Unit Codes (HUC 8-digit code) of USGS 4th level hydrologic unit.
  • Record ID - An identifier for a unique combination of water body location, pollutant parameter, and season.
  • Waterbody Information -
    • Name - Name of water body from Geographic Information System if available
    • LLID - Georeferenced identifier derived from the latitude/longitude at the mouth of the stream line or center of river or lake.
    • River Miles - Starting and ending point of assessment unit in river miles from georeferenced location information. RM 0 is at the mouth of the stream, or center of a lake/reservoir.
    • Segment Miles - Total miles in the assessment unit that represents a segment on a stream.
    • Beach Name - Beach name used for reporting to EPA.
    • Beach ID - Beach identifier used for reporting to EPA.
  • Pollutant - A pollutant or condition that may impair water quality and has an Oregon water quality standard.
  • Season - The season, such as Summer or Fall Winter Spring, or a time period when the pollutant or impairment may be present.
  • Criteria - Summary of Oregon water quality criteria for the pollutant.
  • Beneficial Use - Beneficial use protected by the water quality standard.
  • Status - An assessment category assigned to each record based on evaluating water quality information using the assessment methodology decision rules.
    • Category 1: All standards are met. (This category is not used.)
    • Category 2: Attaining - Specific water quality standards are met.
    • Category 3: Insufficient data to determine whether a standard is met.
      • 3B: Potential concern - Some data indicate non-attainment of a criterion, but data are insufficient to assign another category.
      • 3C: Impairing pollutant unknown.
    • Category 4: Water is water quality limited but a TMDL is not needed. This includes:
      • 4A: TMDL approved - TMDLs needed to attain applicable water quality standards have been approved.
      • 4B: Other pollution control requirements are expected to address all pollutants and will attain water quality standards.
      • 4C: Impairment is not caused by a pollutant (e.g., flow or lack of flow is not considered a pollutant.)
    • Category 5: Water is water quality limited and a TMDL is needed, Section 303(d) list.
  • 2010 Assessment Action - Any new assessment action taken in 2010 after evaluating new data or information.
  • Supporting Data - Summary of data and/or information evaluated for the assessment.

 Instructions to Review the 2010 Integrated Report Database

 Search criteria options:

  • Full report - Use the default "All" selections. (The report may take a while to load as there are over 18,000 records.)
  • Limited report - Select by Subbasin (4th Field Hydrologic Unit Code HUC), Water body (Stream/Lake), LLID, pollutant, and/or Listing Status from the dropdown lists, or use the default "All" selection.
  • Water quality limited water bodies (Appendix A) - Select the Listing Status: "Water Quality Limited - All". Includes Categories 4 and 5.
  • 2010 303(d) list - Select Listing Status: "Water Quality Limited TMDL needed - 303(d)". Includes only Category 5, 303(d).
  • De-listed waters - Click the checkbox for "Water bodies de-listed in 2010". Search may be for all de-listed water bodies, or be limited by Subbasin, Water body, and/or Pollutant Parameter.

NOTE: Large rivers (Willamette River, Columbia River, Deschutes River, etc.) and large assessment units may be in more than one subbasin (4th Field HUC). Search by water body name to find ALL the assessments on large waters. Searching by subbasin names will return any assessment unit contained in or crossing that 4th field HUC. (Example: "Alsea" returns 412 records.) Searching by combined subbasin names will return only the assessment segments that are in all those 4th field HUCs. (Example: "Alsea; Siuslaw" returns 2 records.)

Sorting and counting options:

Click on the active headings (Subbasin, Water Body, Pollutant, Season, Criteria) to re-sort the search results in alpha-numeric order.
Click on "Show All Records" to show the count of records in the search in the "Records per page" box.

Searching result options:

Click "Search" button to view results on screen.
Type "Ctrl+F" to find specific text in results.
Click box for "Create a Spreadsheet (.csv) File" to create a Comma Separated Values (.csv) file of search results that can be viewed using Microsoft Excel or saved.

View sampling data:

Click on "Lookup LASAR Station data" button and follow instructions.
Click on "Link to LASAR Web" button to enter and search DEQ’s analytical data storage and retrieval database system.

 Review the 2010 Integrated Report Database

 Select search criteria and then click the Search button to begin searching the database.



Subbasin (USGS 4th Field HUC):
Water body (Stream/Lake):

Stream or Lake LLID value:

Enter LLID numeric value
Pollutant:

(Hold down the Ctrl key to select multiple parameters)
Listing Status:

Water bodies de-listed in 2010:

(Other listing status selections will be disregarded)

Create a Spreadsheet (.csv) File: Select this option if you want to create a .csv (Comma Separated Values) file of the search results generated by the search criteria you select on this form. Microsoft Excel can be used to view this file.


[print version]

For more information about DEQ's Integrated Report and 303(d) list contact Karla Urbanowicz by phone at (503) 229-6099 or by e-mail.

Oregon Department of Environmental Quality
Headquarters: 811 SW Sixth Ave., Portland, OR 97204-1390
Phone: 503-229-5696 or toll free in Oregon 1-800-452-4011
Oregon Telecommunications Relay Service: 1-800-735-2900  FAX: 503-229-6124

The Oregon Department of Environmental Quality is a regulatory agency authorized to protect Oregon's environment by
the State of Oregon and the Environmental Protection Agency.

DEQ Web site privacy notice