LocxSubbasin2001 Table

LocationID to Subbasin2001ID cross-reference table.

Field Name Field Description Data Type Field Size*
Subbasin2001ID Subbasin code defined in 2001 by StreamNet for Subbasins defined by NPCC. smallint 2
LocationID Unique identifier categorizing a line, point or polygon in either 1:100,000 or 1:24,000 scale GIS coverage. varchar 13
BegFt Beginning foot of this reach that falls within this particular Subbasin2001. int 4
EndFt Ending foot of reach that falls within this subbasin2001. int 4
QCount No longer used internally as count of Subbasin2001s associated with this LocationID. tinyint 1
InBasin A logical flag describing whether the subbasin1990 is within the Coulbia Basin char 1

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


Revised Wednesday September 28 2005