LocationID to Region2001ID cross-reference table.
| Field Name | Field Description | Data Type | Field Size* | Region2001ID | Region Code (code defined in 2001 by StreamNet) | 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 Region2001. | int | 4 | EndFt | Ending foot of reach that falls within this region2001. | int | 4 | Qcount | No longer used internally as count of Region2001s associated with this LocationID. | int | 4 | InBasin | A logical flag describing whether the subbasin1990 is within the Coulbia Basin | char | 1 | OldRegion | No longer used. Will be removed. | tinyint | 1 |
*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.