HUC Table

Lookup table for hydrologic unit code (HUC) names.

Field Name Field Description Data Type Field Size*
HucID HUC identifier. Primary key for the HUC table.(no longer used - to be removed) int 4
HUC Hydrologic Unit Code (4th field HUC). char 8
StreamNetName The StreamNet-assigned name for the HUC varchar 200
USGSName The USGS assigned name for the HUC varchar 200
ANADROMOUS A logical flag describing whether the HUC contains anadromous fish or not char 1
PNW A logical flag (T/F) describing whether or not the HUC is within the Pacific Northwest Reach file boundary varchar 1
AREA The area of the HUC in square miles real 4
NumStreams The number of streams in the HUC smallint 2
NumNamedStreams The number of named streams in the HUC smallint 2
MilesStreams The miles of perennial streams in the HUC smallint 2
MilesInterStreams The miles of intermittent streams in the HUC smallint 2

*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.


Revised Wednesday September 28 2005