This version contains many updates to Trend and count data, Barrier, Dam and Hatchery facilities, and Reference information, as well as updates to georeferencing codes called LocationIDs. The LocMaster table contains location names and location type coding for LocationIDs that are used in many tables. The LocationID field is StreamNet's current location identifier code, and the LocMaster table includes all location code types.
The database does not include the Static Maps, Photographs, or Maps on the fly functionality that you get using StreamNet's online system. It also does not include a user interface at this time, but someone with a little experience with Access should be able to formulate queries to analyze and export desired datasets. None of the tables in this database are protected against change.
By relating LocMaster.LocationID to the LocationID field in the tables named LocxState, LocxCounty, LocxHUC, LocxProvince, LocxSubbasin2001 or LocxRegion2001, you will be able to select only data that pertains to the extent of your interest, as long as you include logical criteria using the BegFt and EndFt fields. E.g., "SELECT DamID, Dam_Name FROM (Dam LEFT JOIN LocxCounty ON Dam.LocationID = LocxCounty.LocationID) WHERE ((LocxCounty.BegFt <= Dam.EndFt) AND (LocxCounty.EndFt >= Dam.BegFt)) and CountyID = 126 Order by Dam_Name"; to retrieve all Dam records within Multnomah County (see County table for appropriate code for other counties). If this sort of query is scary for you, remember that the StreamNet online Fish Data query system does all of the complicated georeferencing behind the scenes, and allows you to download the final result set into applications such as Access.
Very few problems continue to exist in this database version regarding routed hydrography being used for California that has created some issues pertaining to distance measures along streams that cross the California Oregon border. These will be completely corrected in March 2008 when StreamNet will begin using an improved mixed scale hydrography that has undergone extensive review, but some queries that include cross-border streams may return data from more states, counties, etc. than were used in the query to filter data.