One to one relationship with the MitLocation table (using the SpatialType value in the Location table to direct to this table).
| Field Name | Field Description | Data Type | Field Size* | ProjID | StreamNet project ID. Cross reference to MitProject table | int | 4 | WLID | ID code unique to each work type by location, within a project. Cross reference to MitLocation 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 | The distance in feet from the mouth of the stream to the downstream end of the work site | int | 4 | EndFt | The distance in feet from the mouth of the stream to the upstream end of the work site | int | 4 | Comments | Additional information or comments. | text | 16 | StreamID | Unique stream identifier once used by NPCC. | varchar | 13 |
*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.