LocxSubbasin1990 Table

LocationID to Subbasin1990ID cross-reference table.

Field Name Field Description Data Type Field Size*
Subbasin1990ID Subbasin code defined in 1990 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 Subbasin1990. int 4
EndFt Ending foot of reach that falls within this subbasin1990. int 4
Qcount No longer used internally as count of Subbasin1990s 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