Many to one relationship with the MitProject table via ProjID.
| 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. | tinyint | 1 | WorkTypeID | Code for general work category | tinyint | 1 | SiteTypeID | General classification of project site | tinyint | 1 | SpatialTypeID | Code describing the spatial type of the site, and hence, the table that will be used for specific location data | tinyint | 1 | SiteName | Name used by project to identify the site | varchar | 255 | LandCoverID | Dominant land cover of the stream work location before the project began - might want to allow multiple answers. | tinyint | 1 | LandUseID | Dominant land use of the stream work location before the project began- might want to allow multiple answers. | tinyint | 1 | Comments | Additional information or comments. | text | 16 | 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 Query System Identifier for internal SN use | int | 4 | EndFt | Ending foot of Query System Identifier for internal SN use | int | 4 | QID | QueryID - Location Code formerly used by online query system (use LocationID) | varchar | 13 |
*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.