[About the Database] [Instructions]
[Review the Database]
The 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 database contains assessment information submitted to EPA in November 2014.
EPA approved most of the submitted 303(d) listings and delistings in December 2016. See EPA’s website for details on what was approved and disapproved. The approved 303(d) list with EPA’s modifications is currently effective for Oregon. DEQ will update the searchable database when EPA has completed final action to add other impaired waters to Oregon’s 303(d) list.
You can review the submitted 2012 Integrated Report using default or customized settings (See
Review the Database), or review these lists pre-selected from the submitted data:
- All Category 5 Water Quality Limited Waters needing a TMDL, 303(d) list (submitted)
- Water bodies proposed to be added to the Category 5 303(d) list in 2012, 303(d) Added 2012 (submitted)
- Water bodies proposed to be removed from the 303(d) lists in 2012, De-listed 2012 (submitted)
About the Database
The 2012 Integrated Report Assessment Database contains new assessment
information and updates to assessments from 1998, 2002, 2004,and 2010. (See
2010
Integrated Report Database).The updates made in 2012 are
described in the “2012 Assessment Action” report field. If no new data
evaluations or assessments are done in 2012, the assessment information
and the status assigned in previous assessments are carried forward into
the 2012 Integrated Report and noted as “No 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. (See LLID application)
- 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.
- 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.
- 2012 Assessment Action - Any new assessment action taken in 2012 after evaluating new data or information.
- Supporting Data - Summary of data and/or information evaluated for the assessment.
Search criteria options:
- Full report - Use the default "All" selections. (The
report may take a while to load as there are almost 20,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.
- 2012 303(d) list - Select Listing Status: "Water
Quality Limited TMDL needed - 303(d)". Includes only Category 5, 303(d).
- De-listed waters - Click the check box for "Water bodies
de-listed in 2012". 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
439 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.
Select search criteria and then click the Search button to begin
searching the database.