A Newsletter from StreamNet
The Fish Data Delivery Project for the Pacific Northwest
Issue #2 - May 23, 2003
Go to: Previous newsletter. Next newsletter.
Welcome to the second StreamNet News!
StreamNet is more than just the main StreamNet web site (old.streamnet.org) and database. In this edition we'll tell you about two StreamNet features many people may not know about. Two of the agencies that participate in the StreamNet project have their own web sites where additional information and data are available. Also, the StreamNet Library is a great resource that is underused. In this edition of the Newsletter we describe the StreamNet Library and the ODFW web site, as well as reporting news and updates.
Table of Contents
- New Data
- Downloadable Access database updated
- Plans for anadromous release data
- Spreadsheets of StreamNet data updated for subbasin planners
- Two new resident trout resources available
- Improvements made to the on-line data query system
- Real-time XML output available
- Updated data structure
- ODFW's Natural Resources Information Management Program
- The StreamNet Library
1. NEW DATA
Since the last StreamNet Newsletter in July 2002, significant additions and improvements have been made in the StreamNet database. These break down as follows.
Hatchery facilities: Many records were updated, and 13 new records were added, bringing the total to 511 (a 3% increase)
Current fish distribution: A new data structure was created to better provide this information to you. In addition, 19,625 new records were added (an 82% increase).
Time series data:
The number of unique time series ('trends') increased 6% from 35,961 to 38,169, despite some time series being removed after errors were found or records were merged. The individual time series records, grouped by data category, increased as follows (numbers represent records in the database).
- Dam/Weir count:
- Increase of 241 (2%) brought total to 11,410.
- Freshwater harvest:
- Increase of 2,148 (6%) brought total to 35,205.
- Hatchery returns:
- Increase of 712 (4%) brought total to 19,274.
- Peak/Other spawner counts:
- Increase of 2,622 (12%) brought total to 25,178.
- Redd counts:
- Increase of 18,205 (185%) brought total to 28,061.
- Spawning pop. estimates:
- Increase of 4,609 (29%) brought total to 20,393.
2. DOWNLOADABLE ACCESS DATABASE UPDATED
The Microsoft Access version of the StreamNet database was updated on March 13, 2003. You can download it at http://old.streamnet.org/online-data/downloaddatabase.html. Additions and changes to the StreamNet database as of that date are available in this downloadable version. Though this newest database is smaller than the previous version, it contains more useful data. The smaller size is due to removing tables that were not of use to data users. Note that earlier versions of the database are still available. If you need a copy of an earlier version, send us an email at email@example.com.
3. PLANS FOR ANADROMOUS RELEASE DATA
One of the frustrations StreamNet staff and StreamNet users have had over the past several years has been our inability to update the hatchery releases data for anadromous fishes. In the past we obtained anadromous fish release data from the Regional Mark Information System (http://www.rmpc.org), and added stream location coding so the hatchery release data could be obtained via the StreamNet query system.
About 3 years ago we updated our stream location coding from the 1:250,000 scale EPA River Reach Number (RRN) system to a more detailed and accurate 1:100,000 scale (LLID) stream coding system. This new system, while providing more detail and important technical enhancements, requires us to add new data to the database using the new location coding system. The release data we currently have in the database are still linked to RRNs and cannot be cross-referenced with other data types in the StreamNet database. Unfortunately, cross-referencing the location information in RMIS to specific 1:100,000 scale stream codes is difficult due to ambiguities resulting from pooling records of coded-wire tagged fish releases into a single record for the RMIS database. Often, multiple releases in multiple locations are reported to RMIS as a single record with a single Pacific Salmon Commission location code, and they currently can not be parsed into the individual release information. StreamNet is working with agency data compilers to obtain these data prior to records being pooled for RMIS. We will post these data as soon as reasonably possible.
Three decisions have recently been made regarding anadromous fish hatchery release data. First, because we are currently unable to update these data and most users need up-to-date data, we have decided to remove the anadromous fish hatchery releases data from the query system. Users will instead be directed to the RMIS web site. Second, RMIS will explore possibilities for adding more modern location coding alongside their PSC codes. This effort will take a year or more. The third decision made was that StreamNet and RMIS will explore ways to improve data collection efficiency for both systems. We will examine data flow patterns (where data come from, how they are entered, how they end up in agency databases, RMIS, and StreamNet), location codes, and how and when data are grouped. We hope to find a strategy for updating location codes, providing more detailed information, and making data transfer to RMIS and StreamNet more timely than they currently are. This joint effort should benefit RMIS, StreamNet, and the many people who look to these two systems for hatchery release data.
4. SPREADSHEETS OF STREAMNET DATA UPDATED FOR SUBBASIN PLANNERS
In 2001, we provided all StreamNet tabular data in a spreadsheet for people doing Subbasin Summaries as part of Subbasin Planning. In February 2003 we updated these spreadsheets. Both the old and new spreadsheets can be obtained at http://old.streamnet.org/subbasin/2001-subbasin-data.html.
5. TWO NEW RESIDENT TROUT RESOURCES AVAILABLE
Two new resident trout data resources are available on StreamNet's "Independent Data Sets" page, http://old.streamnet.org/online-data/OutSideDataSets.html. The first is a spreadsheet showing genetic makeup proportions for hundreds of trout populations in Montana. We expect this spreadsheet to be periodically updated as Montana Fish, Wildlife, and Parks gathers additional data. The second item is the Shepard et al. (2003) status review of westslope cutthroat trout throughout their U.S. indigenous range as of 2002. Included are the 2003 report, and the data and GIS layers used in creating the report. This status review was conducted by state, federal, and tribal agencies in Montana, Idaho, Oregon, and Washington.
6. IMPROVEMENTS MADE TO THE ON-LINE DATA QUERY SYSTEM
a) "On-Line Data Query User's Guide" Updated: The User's Guide for the on-line query system was updated in April 2003. This guide can be quite helpful to those people learning to use the query system. You can download the user's guide from http://old.streamnet.org/online_data.html.
b) New Help File For Habitat Restoration/Improvement Projects: A new help file was created to help users understand the information available in the Habitat Restoration/Improvement Projects data category. To see this help file within the query system, click the question mark next to "Data Categories," then click on "Habitat Restoration/Improvement Projects," and then click on the "full description" link.
This data category has not been in existence long, and the data resources are limited compared to what could be developed. We are actively seeking funds to add additional data.
c) New Means Of Obtaining References Via The Query System: When you use the StreamNet query system to find information of interest, you also get reference information so you can identify the publications the data come from. In May of 2003 we added a wonderful capability to the query system. In the list of references at the bottom of a data page, you may see a link for "View this document." Clicking this link will let you download an Adobe Acrobat (pdf) copy of the reference document, thus saving you a trip to a library. Here's an example (look at the first reference at the bottom of the page): http://query.streamnet.org/Request.cfm?Cmd=BuildQuery&ID=50991&DataCategory=4&NewQuery=BuildCriteria
Right now the list of publications available in this manner is very small, but it will grow as we scan documents or acquire them from other sources. We hope that over time this capability will be of great usefulness to many people. (If you have electronic public-domain documents you can share, we would love to receive them. You can email the StreamNet Library at firstname.lastname@example.org.)
d) Non-Obvious Changes Implemented In The Query System: Two small changes, but potentially meaningful to some users, were implemented in the on-line query system. First, when viewing a list of time series ("trends") after clicking on "View Available Data" in the query system, the number of observations shown no longer includes null counts. Null counts happen when on-the-ground data collection did not occur during the period indicated. For example, high, turbid water can preclude counting redds -- this results in a record with a null count when we record that event. We have accordingly changed the column heading from "# Obs" to "# Records." The second change is in the way the "Mean Value" is calculated on the same page. For most time series, there is no change. However, for time series where the original data are expressed as redds per mile, fish per mile, carcasses per mile, or peak per mile, the means now represent the mean number per mile rather than the mean of the counts. This was implemented because often, especially for older data, the actual counts are not known and were either null in the data available to StreamNet or were calculated values. We made this change in order to more accurately reflect the original data. Neither of these changes affects the raw data viewed or downloaded -- only the "Trend List" page is affected.
7. REAL-TIME XML OUTPUT AVAILABLE
The StreamNet query system now has the ability to serve data in real time in XML format. Although the technical ability is available, we have not yet developed data redistribution policies for governing this ability. If you are interested in linking into the StreamNet query system via real-time XML, please contact us at email@example.com.
8. UPDATED DATA STRUCTURE
On July 7, 2002 the StreamNet data exchange format document was updated. This document describes the table structures and definitions for data submitted to the StreamNet database. The new document can be found at http://old.streamnet.org/online-data/data_exch_form.html. People who download the entire database will find this useful when interpreting the table structures.
9. ODFW'S NATURAL RESOURCES INFORMATION MANAGEMENT PROGRAM
Oregon Department of Fish and Wildlife's Natural Resources Information Management Program (NRIMP) provides information and services that are essential for accomplishing ODFW's mission - to protect and enhance Oregon's fish and wildlife and their habitats for enjoyment by present and future generations. The information provided by NRIMP is available via their web site, and includes GIS data, maps, reports, data standards and protocols, 1:24,000 scale fish habitat distribution data, a monthly web feature, unit conversion tools, tips for the field/office/home, links to other sources of related information, and more. You can visit the web site at http://oregonstate.edu/dept/nrimp. The Oregon StreamNet project is currently the primary component of NRIMP, and this ODFW web site is a way in which the StreamNet project provides services through more than just the main StreamNet web site.
Montana Fish, Wildlife, and Parks also has a web site for delivering fisheries data. We'll talk about that in a future Newsletter.
10. THE STREAMNET LIBRARY
Some users of the StreamNet web site and the StreamNet database may not know about the StreamNet Library. The StreamNet Library contains the source documents for all the data in the StreamNet database, plus a wide variety of other materials. The Library specializes in collecting and making available gray literature related to fisheries and wildlife management in the Columbia Basin. Other items of interest for fisheries research and management are also collected. You can visit the StreamNet Library in Portland, Oregon, or obtain materials from the Library via interlibrary loan. Also, many items can be converted to .pdf format and sent to you electronically.
Below is a brief list of some of the new materials available at the StreamNet Library. Hundreds of items are added to the collection every month. We have recently doubled our space in order to house the collection. Contact the Library (firstname.lastname@example.org or 503-736-3581 or http://www.streamnetlibrary.org) for availability. If you have rare items or new reports you would like to donate to the StreamNet Library, please contact us at email@example.com. Moving offices or retiring? Don't throw away those old books, journals, and reports! The StreamNet Library would love to mine through your collection to see what may be of value to others in the region.
Selected titles recently added:
- Responsible Fisheries Management Into the 21st Century. North Pacific Fisheries Management Council. 2002.
- Restoring Salmon Runs--Natures Way. Washington Sea Grant. 2001.
- Salmon Recovery in the Twenty-First Century: Breaching the Basic Barriers. R.T. Lackey, EPA. 2002.
- Sourcebook for Investigation and Valuation of Fish kills. American Fisheries Society. 1993.
- Thermal Effects Upon Fish. A.H. Houston. 1982.
- Toward a Watershed Approach: A Framework for Aquatic Ecosystem Restoration, Protection, and Management. Coastal America. 1994.
- Biology, Management, and Protection of North American Sturgeon: Proceedings of the Symposium (August 23-24, 2000: St. Louis, Missouri). Van Winkle, Webster; Anders, Paul J.; Secor, David H.; Dixon, Douglas A. American Fisheries Society.
- The Mitigation Symposium: A National Workshop on Mitigation Losses of Fish and Wildlife Habits. Swanson, Gustav A.
- Columbia River Basin Fish Contaminant Survey 1996-1998. United States Environmental Protection Agency Region X. 2002.
- Genetic Diversity Units and Major Ancestral Lineages of Salmonid Fishes in Washington. WDFW. 1995.
- Generating Electric Power in the Pacific Northwest: Implications of Alternative Technologies. RAND. 2002.
- Pathways of Human Influence on Water Temperature Dynamics in Stream Channels. Poole, G.C. & Cara H. Berman. 2000.
- Fish Behavior: Why Fishes Do What They Do. Adler, H.E. 1975.
- Key to the Fishes of Washington and Oregon. University of Washington. 1931.
- Fisheries Management for Fisherman: A Manual for Helping Fishermen Understand the Federal Management Process. Auburn University. 1994.
- The Politics and Economics of Columbia River Water. Washington Sea Grant. 1984.
- Dissolved Oxygen Requirements of Freshwater Fishes.
- Supplementation of Wild Salmonids: Management Practices in British Columbia. Winton, John N. 1991.
- Watershed: The Undamming of America. Grossman, Elizabeth. 2002.
- Redfish Bluefish. (Video). 2001.
- Principles of Salmonid Culture. Pennell, W. Elsevier. 1996.
If this newsletter was forwarded to you and you want to be added to the list of 936 people who receive occasional email notices of new features and developments at the StreamNet Project, click: http://query.streamnet.org/newsletter.cfm.
COMMENTS on the StreamNet project, its web site, its data products, or your data needs are encouraged and appreciated. Email us at firstname.lastname@example.org, or click FEEDBACK on any page of the StreamNet web site, http://old.streamnet.org.
ABOUT THE STREAMNET PROJECT
StreamNet is a cooperative, multi-agency effort among the Columbia River Basin's state, tribal and federal fisheries agencies, the Northwest Power Planning Council (NWPPC), the Bonneville Power Administration, and the Pacific States Marine Fisheries Commission to compile fish-related data. We compile and make available on our web site information intended to be useful to fisheries managers and researchers, land managers, planners, and others. We acquire, regionally standardize, and georeference data from multiple sources on a number of topics, including: fish distribution, fish abundance trends, hatchery releases and returns, harvest levels, migration barriers, hatcheries, and dams. We provide a catalog of photographs relevant to fish species and facilities in the region. We have begun developing information on habitat restoration projects and some limited information on water temperatures and macroinvertebrates. We maintain the official list of stream reaches the NWPPC has recommended be protected from dam construction, and we are the official keepers of the Pacific Northwest's 1:100,000 scale GIS streams layer. We provide pre-made maps and let you make maps interactively from data in the StreamNet database to meet your needs. We continually work to update these resources, so new information becomes available several times each year. We also provide customized data related services for participants in the NWPPC's Fish and Wildlife Program. When significant changes are made at StreamNet (new data or new ways to display them), we will email another short StreamNet News to those on the mailing list.
You can learn more about StreamNet at http://old.streamnet.org/about-sn.html. We exist in order to bring useful information to people such as you, and we welcome your questions and feedback. We also hope you will inform your colleagues about the resources available at StreamNet (http://old.streamnet.org).
Signed up for StreamNet News but no longer want to be? We hope you won't, but you can take your name off the list by clicking here -- http://query.streamnet.org/newsletter.cfm?Action=Remove.