PSMFC Homepage
HOME
StreamNet's home page StreamNet's mission, services, and participants Locate fish-related data StreamNet's largest data resource, regularly updated ("integrated" interface). StreamNet's largest data resource, regularly updated (traditional interface). Locate data from a map interface. Obtain maps and GIS layers. Locate static data sets. Also, add your data sets to the archive. A full service library containing fish and wildlife literature and reports. Various other useful materials Links to other fisheries related resources on the Web 2004 U.S. District Court ruling on pesticides near salmon streams Stream reaches where hydroelectric development is discouraged Information and data in support of the NPCC Fish and Wildlife program Documents, reports, and newsletters produced by the StreamNet project Recommendations on how to cite data and information obtained from StreamNet Various other useful materials The latest data, but in the old look.









ONLINE QUERY INTRODUCTION

You can obtain data from StreamNet using the following resources.

Query Main Database Using the Integrated Query System  —  This is our newest system for obtaining data from the main StreamNet database.  It integrates spreadsheet-style and map-based approaches to help you easily find data.  As you browse data in a table, the location where the data were collected is shown, and for time series data the results are graphed.  As in the Classic Query System, you can select geographic and non-geographic criteria to limit the data shown to you.  This new system, though, lets you filter on any field, and it allows you to specify multiple values for a single field (such as Chinook and coho and chum).  You can also create your own ways to identify and group data, and use your groups as filters.  The "Quick Start Guide" will help you learn the capabilities of this newest system.


Query Main Database Using the Classic Query System  —  This is the primary means of locating information contained in the main StreamNet database.  It queries the database at each step to ensure you don't run into dead ends.  It is not necessary to use all of the available criteria in building a query.  For example, if you are interested in data for a particular subbasin and know its name, it is not necessary to select a State - just begin with Subbasin.  However, if you are not certain of the name of the subbasin, you can start by selecting a State (or other geographic criterion) and then click Subbasin to see a list of all subbasins at least partially in that state.  The only required criterion is Data Category.  Begin your query with the criterion you are most interested in, such as a species, a location, or a specific kind of data.  For help in using the query system, please consult the user's guide.


Interactive Map Query Method  —  This query method provides a visual, interactive approach to locating information from the StreamNet database.  Data layers may be overlaid in a map window and tools allow you to navigate and zoom to the area of your interest and then obtain data from the StreamNet database for that location.  Geographic features including subbasins, counties, hatcheries, and streams may be queried from the map with a hyperlink tool to access data associated with them.  This method may also be used to create your own custom maps and to perform basic geospatial analysis.


Data Store  —  The Data Store is an archive of stand-alone data sets that are not integrated into the main StreamNet data system.  These data sets contain a variety of data types.


Download the Entire Main Database  —  To perform more sophisticated queries of the data, you can download the entire database in a Microsoft Access 2000 file.  To make use of this file, you must know how to work with relational databases and understand the structure of the StreamNet database.  For almost everybody the online query system is the preferred method for obtaining StreamNet data.


Data Updates

Data in StreamNet are updated at various intervals, depending on the type of data. Monitoring data sets such as redd counts and dam counts are generally updated annually while GIS layers and data sets of a more static nature are updated at irregular intervals as information becomes available. Because the Data Store is a data set archive, data sets housed there are generally not updated.

Due to current (fiscal years 2013 and 2014) efforts to expand StreamNet to include new data types, adjust project priorities, and automate data capture, routine annual updates of some data types are being temporarily delayed.

Data updates submitted to StreamNet follow the StreamNet Data Exchange Standard (DES). The DES can be found here.

Did you know our StreamNet Mapper lets you obtain data directly from the map? First navigate to the specific stream, 4th-field HUC, Columbia River subbasin, county, dam, or hatchery of interest and make sure it is selected as the active layer. Then, select the "Get Data" tool in the toolbox, and click on the feature of interest. This takes you into the StreamNet data query system, listing all data categories available for that feature. Searching by 4th-field HUC also includes a link to EPA data. Give it a try!