[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
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
- 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
- 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
- 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
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"
- Water quality limited water bodies (Appendix A) - Select
the Listing Status: "Water Quality Limited - All". Includes Categories 4 and 5. (NOTE: Does NOT contain EPA’s December 2012 additions.)
- 2010 303(d) list - Select Listing Status: "Water
Quality Limited TMDL needed - 303(d)". Includes only Category 5, 303(d). (NOTE: Does NOT contain EPA’s December 2012 additions.)
- 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.
For more information about DEQ's Integrated Report and 303(d) list contact Karla Urbanowicz by phone at (503) 229-6099