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 2004/2006 Integrated Report Database

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

 The 2004/2006 Integrated Report assessment database contains information on:

  • Water quality status for water bodies in Oregon.
  • Category 5 Water Quality Limited Waters needing a TMDL (2004/2006 Section 303(d) list.)
  • Water bodies that were removed from prior year 303(d) lists (De-listed.)

 About the Database

The report database updates the 1998 and 2002 databases and 303(d) lists.  The listing status from prior assessments may be carried forward if no new or insufficient new information was available for a water body.

 Information in the assessment database is organized by:

  • Record ID - A unique combination of water body location, pollutant parameter, and season.
  • Location - A stream, lake, or reservoir identified by an LLID number (derived from the latitude/longitude at the mouth of the water body) and the starting and ending river miles for the water body or segment of the water body.  RM 0 is the mouth of the stream or center of a lake/reservoir.
  • Parameter - A pollutant 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 may be present.

 Each unique record will have other information including:

  • Criteria - Summary of Oregon water quality criteria for the pollutant.
  • Beneficial Use - Beneficial use protected by the pollutant 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 - Some of the pollutant 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.
    • 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.
  • Assessment Year and Action - Year the assessment was done and what action was taken.
  • Supporting Data - Summary of the monitoring site data or other information that was evaluated.

 Instructions to Review the 2004/2006 Integrated Report Database

 Search criteria options:

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

NOTE: Large rivers (Willamette River, Columbia River, Deschutes River, etc.) may be in more than one watershed. Select "CROSSES SUBBASINS" for the Watershed name, or search by Water body name.

 Review the 2004/2006 Integrated Report Database

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

Watershed (USGS 4th Field HUC):
Water body (Stream/Lake):
Stream or Lake LLID value: Enter LLID numeric value

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

Water bodies de-listed in 2004 with associated records:

(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: 700 NE Multnomah Street, Suite 600, Portland, OR 97232
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