June 2002

This zip file contains the protected/unprotected area information for reaches
that could not be resolved to the mappable 1:100,000 scale hydrography.  Typically
reaches were not resolved for one of three reasons:

(a) The reach depicted does not exist on a 1:100,000 scale map.

(b) There was not sufficient information with the Protected Areas database
to confidently place the location of the reach on a 1:100,000 scale map.

(c) The database depicted this location inconsistently (ie. it overlapped
with other information, or was otherwise not logical).

This table should be used in conjunction with the mapped protected areas data to
assess areas that are or are not protected.  In the meantime, we will continue
to work on resolving these locations to locations that can be mapped.

The table is included in this zip file in two formats:

Unresolved_ProtAreas.mdb - MS Access database
Unresolved_ProtAreas.txt - comma-delimited text files

Both formats contain the same attributes and information.

Please contact the StreamNet GIS Staff at (503) 595-3155
if you have any questions.



Attribute list for Unresolved Protected Areas Data Set:


RRN		The primary key for table Reach: 1:250,000 scale EPA River Reach number 
HUC		The USGS hydrologic unit code.
HUC_Name	The StreamNet-assigned name for the HUC
County		The county name 
Stream		The stream name
Trib_To		The name of the stream that the reach is a tributary of
Loboundary	The name of the complementary reach that defines the lower boundary of the immediate reach 
Upboundary	The name of the reach(s) that defines the upper boundary of the immediate reach, if different from the immediate reach name
OWName		The name of the open water, if applicable (e.g., a lake or reservoir)
Protected_Stat	The final protected areas category
Length		The length of the reach in miles
Beg_Loc		The reach location, in miles from the lower end of the reach, that describes the lower boundary of the reach associated with the particular protected category 
End_Loc		The ending point, in miles from the lower end of the reach, that describes the portion of the reach with the particular protected category 
Affected_Length	The end_length minus the beg_length
Protected_Lengt	For protected reaches, the end_length minus the beg_length
Date_Of_Change	Date of last change to this record
Species		Species protected (anadromous only)
Run		Fish run, where applicable
Species_%_Pres	The lineal percentage of the reach occupied by the species from the base of the reach upstream. This data item was from the original Hydro Assessment Study and was subsequently updated for areas inside the Columbia Basin during subbasin planning (1990)
		  