tmdl_reaches: Oregon TMDL database by NHD reach
In DEQcdonald/odeqtmdl: Oregon TMDL database

tmdl_reaches

R Documentation

Oregon TMDL database by NHD reach

Description

Inventory of where Oregon TMDLs have been developed based on the high resolution National Hydrography Dataset (NHD) version NHDH_OR_931v220. The tmdl_reaches data table is very large so it may take a minute to load.

Usage

tmdl_reaches()

Details

Note the TMDL information is still being assembled and is undergoing review. Some information may not be accurate. See each relevant TMDL document for the official record and more information. TMDLs developed by tribal governments are not included at this time. The inventory is still being developed and some information may not be accurate. A full listing of all non-tribal TMDL actions in Oregon can be viewed using tmdl_actions.

Database fields include:

action_id: EPA ATTAINS Action ID assigned to each TMDL document.
TMDL_wq_limited_parameter: Name of the water quality limited 303(d) parameter that the TMDL addresses.
TMDL_pollutant: Name of TMDL pollutant causing the water quality impairment.
TMDL_scope: Provides information about how the TMDL applies.
- TMDL: The TMDL was developed to address a 303(d) listing or future listing in this reach.
- Allocation only: A TMDL allocation applies in this reach but the TMDL does not address a 303(d) listing or future listing. Typically this situation is applicable for tributaries or canals that are upstream of the reach where the "TMDL" applies. The pollutant reduction in the upstream reach is needed to achieve the TMDL loading capacity of the downstream reach.
- Advisory allocation: A TMDL allocation may apply based on assessment of source loads and if pollutant reduction is needed to achieve a TMDL allocation or loading capacity downstream. See TMDL document for details and requirements. The TMDL does not address a 303(d) listing or future listing in this reach.
Period: Identifies the fish use period that the TMDL addresses. Only used for TMDLs that address temperature or dissolved oxygen.
- year_round: TMDL addresses only non spawning (year round) uses for temperature or dissolved oxygen water quality standards.
- spawning: TMDL addresses only spawning uses for the temperature or dissolved oxygen water quality standards.
- Both: TMDL addresses both spawning and non spawning (year round) uses for temperature or dissolved oxygen water quality standards.
Source:
- Point source: Identifies reaches where pollutant loading is from point sources only.
- Nonpoint source: Identifies reaches where pollutant loading is from nonpoint sources only.
- Both: Identifies reaches where pollutant loading is from point sources and nonpoint sources.
Pollu_ID: DEQ water quality parameter ID. ID is for the parameter in 'TMDL_wq_limited_parameter'.
geo_id: Unique ID assigned to the NHD reaches codes where a TMDL target applies. ID is structured as YearTMDLissued_ShortTMDLdocName_TargetGeoArea.
HUC6: Basin six digit USGS hydrological unit code.
HUC6_Name: USGS Basin name.
HUC6_full: Concatenation of the HUC6 and HUC6_Name fields.
HUC8: Subbasin eight digit USGS hydrological unit code.
HUC8_Name: USGS Subbasin name.
HUC8_full: Concatenation of the HUC8 and HUC8_Name fields.
HUC10: Watershed ten digit USGS hydrological unit code.
HUC10_Name: USGS Watershed name.
HUC10_full: Concatenation of the HUC10 and HUC10_Name fields.
GLOBALID: Unique ID for every NHD reach record. Used for joins with TMDL GIS features.
Permanent_Identifier: NHD Permanent Identifier.
ReachCode: NHD reach code.
GNIS_Name: Proper name, specific term, or expression by which a particular geographic entity is known
GNIS_ID: Unique identifier assigned by GNIS, length 10.
AU_ID: Assessment Unit ID.
AU_Name: Name of the assessment unit.
AU_Description: Assessment unit descriptions.
AU_GNIS_Name: Assessment unit and GNIS name concatenation.
AU_GNIS: Same as GNIS name but with a few additional names not in NHD.
LengthKM: Length of linear feature based on Albers Equal Area.