Data Dump Version: StreamNet 20030313

Data Holdings (Access 97 version)

This version still contains very few changes to HatchRelData, Reference and Habitat Restoration tables, but does include many updates to Trend and count data, Dam and Hatchery facilities, and includes updates to georeferencing codes for Provinces and Subbasins adopted in 2001 by the NWPPC for Subbasin Planning.

You won't find details about QIDs and Qx* tables in the Data Exchange Format, so here's a brief explanation. Many tables include a QID field which contains the appropriate location code identified by the LocTypeID, i.e. LLID or SuperCode or WaterBody or PointID. This QID field will link easily to the QMaster table to provide a name for any location, the QxState table to return the State, and the QxCounty, QxRegion, QxSubbasin and QxHUC tables to return those values that are appropriate for each QID. The Qx tables were created because of the need to have a single field for the Web Query System to query for these lookups. StreamNet is considering eliminating the various LLID, SuperCode, WaterBody and PointID for many tables, and renaming the QID field in these tables to LocationID, while retaining the functionality of the current QID field. There is a Sample Query in the database that demonstrates the logic of relating location codes in data to the Qx* tables; the example allows you to query the Trend table for data in any particular Subbasin.


Revised Thursday March 13 2003