LocxCounty Table

LocationID to CountyID cross-reference table.

Field Name Field Description Data Type Field Size*
CountyID The county ID, foreign key to table County 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 County. int 4
EndFt Ending foot of reach that falls within this county. int 4
Qcount No longer used internally as count of Counties associated with this LocationID. tinyint 1

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


Revised Wednesday September 28 2005