PSMFC Homepage
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.


Purpose of the StreamNet DES  —  The StreamNet DES is the database structure template used when new data are added to the main StreamNet database.  (The Data Store is separate from the main database and does not use the DES.)  Although not identical in every way, the DES closely resembles the database structure used to store data for data management purposes.

Intended Audience  —  The StreamNet DES is meant for internal use by StreamNet personnel.  However, we occasionally receive requests to share our DES — thus the existence of this web page.

The DES is very complex, is meant as a guide for those who already understand it, and in general cannot be well understood without interacting with StreamNet personnel and without a significant time investment.  If you wish to use or examine the StreamNet DES, please download the file (use the link below) and then contact us to set up a discussion.  We are happy to assist you.

StreamNet's current 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!