LocxState Table

LocationID to StateID cross-reference table.

Field Name Field Description Data Type Field Size*
StateID The identifier code for the state. Cross reference to State table. tinyint 1
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 State. int 4
EndFt Ending foot of reach that falls within this state. int 4
Qcount No longer used internally as count of States associated with this LocationID. tinyint 1
MouthStateID StateID of the state where the mouth of this stream is located. tinyint 1
Hook Temporary field used by regional staff for record updates tinyint 1
tmpNote ignore varchar 20

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


Revised Wednesday September 28 2005