Resources available here include the spreadsheets, maps, GIS layers, subbasin planning modeling input and results, tools, and databases developed for subbasin planning.
The Northwest Power and Conservation Council (NPCC; formerly the Northwest Power Planning Council) led the 2001-2004 effort to develop comprehensive subbasin plans throughout the Columbia River basin. StreamNet both provided data to support subbasin planning and also received and distributes compilations of the data used in the plans.
At the beginning of the subbasin planning effort StreamNet created spreadsheets of pre-existing data for each subbasin, GIS layers, and maps. (The spreadsheets, originally done in 2001, were updated in February 2003 and are available below.)
After the plans were completed, StreamNet, the Technical Outreach and Assistance to Subbasins Team (TOAST), the Columbia River InterTribal Fish Commission (CRITFC), and the Northwest Habitat Institute captured new data that were developed for use in the aquatic portion of each subbasin plan. Resources available here include the spreadsheets, maps, GIS layers, subbasin planning modeling input and results, tools, and databases developed for subbasin planning. Included is a large majority of the EDT and QHA modeling information used in subbasin planning. Also provided here are GIS layers that define the EDT/QHA reach codes.
Before using the subbasin plan and archived data sets listed below, we recommend reviewing the README file for a summary of the data that are available, a description of the StreamNet Data Types, and a Watersheds Modeled Spreadsheet detailing the modeling products that are available for each subbasin.
Data Available on this Page
StreamNet data and other archived datasets:
Each subbasin spreadsheet contains 16 separate pages, including introductory explanations, data of many types, and a table of literature relevant to the subbasin. Not all data types are available for every subbasin. For a quick overview of the types of StreamNet data available for each subbasin, download the data inventory by subbasin spreadsheet.
Products prepared by TOAST/CRITFC:
Data available for a subbasin can vary because planners were given a choice of models and not all used EDT or QHA. Also, some data were not available from the subbasin planning process when this archive was created. In addition to subbasin-specific products, TOAST/CRITFC also constructed databases of fish populations from the EDT information provided by Mobrand Biometrics, Inc.
Northwest Habitat Institute:
Collected from subbasin planners wildlife data, upland habitat data, and GIS layers used to produce maps for the plans.
Electronic copies of the 2004 subbasin plans
Electronic copies of the 1990 subbasin plans
Subbasin Planning Data:
Data are presented by subbasin. Select a subbasin from the list below or the subbasins map. Materials provided to subbasin planners are found under “StreamNet_Info”, while materials produced during or after subbasin planning are found under “SubPlanning_Info.” In addition to the subbasin-specific data sets, several basin-wide datasets are also available:
Master spreadsheet created June 25, 2001 contains data for all subbasins combined.
Master spreadsheet – updated February 8, 2003 contains data for all subbasins combined.
Water temperature data Compilation of water temperature information across the Basin.
Protected Areas Waters protected from further hydropower development by the NPPC.
Smolt Density Model From 1995 publication of calculated smolt densities.
Tools for Viewing Subbasin Planning Data:
Fish Model Tools Instructions and Microsoft Access database ‘templates’ that can be downloaded for viewing EDT Stream Reach Editor (SRE) data and reports, and TOAST’s version of an unpopulated QHA spreadsheet tool.
Terraserver Instructions on how to use the TerraServer Map Service with GIS software to view USGS 1:24,000 quadrangle maps in combination with subbasin data.
Planning Data by Subbasin, Organized by Columbia Basin Province