This file can be found at ftp://ftp.streamnet.org/pub/streamnet/SubPlanning . Welcome to the StreamNet Subbasin Planning ftp site, where you can download StreamNet data and other materials related to your subbasin. At this time, StreamNet data (all subbasins) and TOAST/CRITFC materials (most subbasins) are available for download. (TOAST = Technical Outreach and Assistance to Subbasins Team; sponsored by the Columbia River Inter Tribal Fish Commission (CRITFC)). The Northwest Habitat Institute also collected and archived wildlife data and map layers used in subbasin plans. These may be accessed on a separate site: (http://www.nwhi.org/index/ibis) Below is a brief summary of the data and other materials available here. We hope you find it useful. If you have questions about StreamNet materials, contact StreamNet Program Manager Bruce Schmidt at 503-595-3100. Questions about other materials are best directed to contacts listed in the metadata available for most TOAST/CRITFC files. ============================================================================================= MATERIALS PROVIDED FOR SUBBASIN PLANNERS BY STREAMNET README.txt This file. Some of the folders listed below also contain individual ReadMe files that outline specific details about the data they contain. StreamNet_Info (folder) Holds files created by StreamNet for subbasin planners' use. Each subbasin folder has a StreamNet_Info folder. In turn, each StreamNet_Info folder contains folders named GISLayers, MapImages, and Spreadsheets (explained below). GISLayers (folder) StreamNet GIS layers and metadata (documentation) are stored here and may be used directly in GIS/mapping applications. GIS layers are stored in shape file format (zipped). The metadata (in most cases) are in FGDC format and include projection and attribute information for the GIS files. GIS data may also be downloaded from the StreamNet site at http://www.streamnet.org/gisdata.html MapImages (folder) StreamNet custom maps for each subbasin are included here. Maps detail fish distribution, hatchery facilities, and other spatial features. These maps are intended to assist subbasin planners with building reports, presentations, or other uses where visualization of information about the subbasin is important. Maps are provided in both medium and high resolution .jpeg format, which is suitable for pasting into documents and presentations, and a low resolution .gif format, which is ideal for web sites and quick viewing. StreamNet can also assist subbasin planners with specific map requests for their subbasins. Spreadsheets (folder) Data available in the StreamNet database have been queried and provided for you here in Microsoft Excel spreadsheets. There are three files in each subbasin's "Spreadsheets" directory. "DataTypeExplanations.xls", as you would expect, is an explanation of the data sets which we have provided for you. The actual data are provided in a spreadsheet named after the subbasin. For example, the Grande Ronde subbasin data are held in a file named "StreamNetDataGrandeRonde.xls". (The second page of this spreadsheet is the same as the "DataTypeExplanations.xls".) The third file in each directory is simply a copy of the data spreadsheet zipped up for faster download. StreamNetDataInventory-7-25-01.xls This file contains a summary of the data available in the spreadsheets. Looking through this file, you can quickly determine if the type of data you are looking for is available for the subbasin and species of interest. AllTemperatureData.mdb.zip Annual summary, daily summary, and instantaneous stream temperature data from all USGS gauging stations in Oregon, Washington, and Idaho. Also includes data from the Wallowa-Whitman, Nez Perce, and Payette National Forests. These data are in a Microsoft Access 97 database. Please contact Michael Banach with StreamNet (503-595-3100) if you would like help with using this database. These data were collected while creating a template for a region-wide water temperature database -- no attempt was made to create a comprehensive database, but you may find useful data. ProtectedAreas.xls.zip The list of stream reaches which the NWPPC recommended be off-limits to dam construction. StreamNetData-AllSubbasins.xls.zip This large spreadsheet contains all the StreamNet data which were provided for the subbasin planners in 2001. These data are broken up into separate spreadsheets for each subbasin. To find just the data in a subbasin of interest to you, from this ftp address choose the province of interest, then the subbasin of interest, and then the "Spreadsheets" directory. For example, to find the spreadsheet which contains only the Willamette data, go to ftp://ftp.streamnet.org/pub/streamnet/SubPlanning/LowerColumbia/Willamette/Spreadsheets. In addition to spreadsheets containing various data, we have provided you with GIS layers that we hope will be helpful to you. These can be found "next to" the spread sheets. For example, the Willamette layers are at ftp://ftp.streamnet.org/pub/streamnet/SubPlanning/LowerColumbia/Willamette/GISLayers. We have also made maps that we hope you find useful. Again, they are "next to" the spreadsheets. For the Willamette, go to ftp://ftp.streamnet.org/pub/streamnet/SubPlanning/LowerColumbia/Willamette/MapImages. SubbasinPlans.txt This file tells where to find electonic copies of the 1990 and 2004 subbasin plans. Let me spare you the effort of reading the file -- here's what it says: "The Subbasin Plans from 1990 can be downloaded at http://www.fishlib.org/Subbasins/index.htm. The 2004 Subbasin Plans can be found at http://www.nwppc.org/fw/subbasinplanning/Default.htm" ============================================================================================= MATERIALS PROVIDED FOR SUBBASIN PLANNERS BY TOAST/CRITFC, OR PRODUCED BY THE SUBBASIN PLANNERS drg (folder) Digital Raster Graphic (DRG) images at the 1:24,000 scale published by the US Geological Survey made available here in the Oregon Lambert (NAD83) projection for use with GIS/mapping applications. This folder may contain several zipped files of DRG images, organized by OHIOCODE. In general, DRGs were not collected for most subbasins because they take up a large storage space, and may be downloaded elsewhere. SubPlanning_Info (folder) This folder contains a variety of subbasin planning information. Various files are available in this folder, as described below: Contacts (MS Excel List(s) of contact information for individuals who were and/or Word) part of the subbasin technical teams or are interested participants in the subbasin planning process. Available for Oregon subbasins only. For other subbasins, see the metadata for the GIS reaches and/or QHA spreadsheet for the subbasin contact(s). toast_db Database and corresponding documents that represent data (MS Access database) collected and used during the subbasin planning process. Raw data are interactively related to individual reaches delineated for subbasin modeling. Available for Oregon subbasins only. inventory_db This database lists an inventory of water quality data (MS Access database) and information available for each subbasin as required by the Management Plan. Available for most Oregon subbasins only. qha_spreadsheets Qualitative Habitat Assessment (QHA) ratings for focal (MS Excel) species. More details can be found in the ReadMe file located inside the QHA spreadsheets folder. Available for all subbasins where QHA analysis was completed. maps (image files in One or more .jpg map images custom-created by the Oregon jpeg format) TOAST. Several of the Oregon subbasin planners used these maps in their DRAFT Plans, but these images may not represent all of the maps or images published with the Plans. Images may be 8.5 x 11 or 11 x 17. All images are available at 250 dpi resolution for maximum detail and minimum file size. Additional map used in subbasin planning may be found on the Northwest Habitat Institute web site (http://www.nwhi.org/index/ibis) gis_data Geographic Information Systems (GIS) shapefiles and metadata (documentation) are stored here and may be used directly in GIS/mapping applications. Shapefiles are available together in .zip format. The metadata (in most cases) are in an FGDC format and include projection and attribute information for each shapefile. Metadata are either embedded directly with the ArcGIS shape files (as xml documents), contained separately in a metadata folder (as text or html documents), or available from other sites via links described in README files. GIS data includes the reaches used in subbasin modeling (typically named reaches_edt.shp or reaches_qha.shp). These reach locations were created, modified, or simply verified by the TOAST/CRITFC efforts, depending on whether they were already present in a spatial format from subbasin planning, or needed to be created from text descriptions. These reaches link directly with the reachname attribute to the habitat ratings from the EDT and QHA modeling, which are stored in .dbf files as well as their native spreadsheet formats. The reaches also contain several standardized attributes gathered from the modelling efforts and added during the TOAST/CRITFC effort. The GIS data archive also contains a complete set of spatial data from other sources that was compiled and clipped to the subbasin by TOAST/CRITFC. edt_data Data derived from the Ecosystem Diagnosis and Treatment (EDT) modeling process during Subbasin Planning. This may include several subfolders (listed below). edt_reports Data for use with the EDT Viewer tools for focal species (Txt files and MS Word) by population. More details can be found in the ReadMe file located inside the EDT Reports folder. edt_populations EDT info about fish populations including juvenile and adult migration and spawning patterns. This data is stored here in an excel format developed at CRITFC, but is also available for all populations in a relational database from the streamnet subbasin page. edt_sre (text files) Data in text file format for importation into the Stream Reach Editor (SRE) tool. More details can be found in the ReadMe file located inside the SRE Data folder. edt_scenario (text files) Data in text file format for importation into the Scenario Editor tool. More details can be found in the ReadMe file located inside the Scenario Data folder. edt_spreadsheets A standardized spreadsheet created at CRITFC to show the EDT information, including reaches, habitat, and obstruction data.