LocationID to ProvinceID cross-reference table.
| Field Name | Field Description | Data Type | Field Size* | ProvinceID | Code for NWPPC Provinces | 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 Province. | int | 4 | EndFt | Ending foot of reach that falls within this province. | int | 4 | QCount | No longer used internally as count of Provinces associated with this LocationID. | int | 4 |
*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.