HabQual Table

The lookup table containing habitat quality descriptions from Subbasin Planning.

Field Name Field Description Data Type Field Size*
HabQualID The primary key for table HabQual smallint 2
HabitatQuality A subjective estimate of habitat quality for the given species/run for the reach, based on comparisons of the present fish producing potential of habitat within the subbasin that contains the reach. Excellent habitat was described as that which would supp varchar 50

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


Revised Wednesday September 28 2005