Data Dump Version: StreamNet20020703Acc97

Data Holdings

This version still contains very few changes to HatchRelData, Reference and Habitat Restoration tables. This edition does include many updates to Trend and count data, Dam and Hatchery facilities, and includes additional georeferencing codes for Provinces and new Subbasins recently adopted 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.


Revised Wednesday July 03 2002