This version contains many updates to Trend and count data, 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. Many tables in the past have included LLID or QID fields, as well as SuperCode, WaterBody and PointID. Most of those fields are no longer in use, although some remain in certain tables, and some remain in use for certain data categories. 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 QID field in the tables named QxState, QxCounty, QxHUC, QxProvince, QxSubbasin2001 or QxRegion2001, 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,Owner FROM (Dam LEFT JOIN QxCounty ON Dam.LocationID = QxCounty.QID) WHERE ((QxCounty.BegFt<=[Dam].[EndFt]) AND (QxCounty.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 each county). 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 is known to exist in this database version. New routed hydrography is being used for California that has created some issues pertaining to distance measures along streams that cross the California Oregon border. These are currently being 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 measure formerly beginning at the border instead of the stream mouth.