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.
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.
A problem continues 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 hopefully be reviewed and corrected by ODFW, but in the meantime, queries that include some bordering streams may return data from more states, counties, etc. than were used in the query to filter data. Please ignore those extra returned data until we can resolve the border issues and please be aware that the location of some data in Oregon near the southern border needs to be assigned new measures where the stream originates in California due to the stream's starting measure formerly beginning at the border instead of the stream mouth.