This table contains extrapolated fish distribution information, by use type. Values in this table are based on best professional judgement and not necessarily specific observations. Formerly used FishDist table. DEF name = GeneralizedFishDistribution.
| Field Name | Field Description | Data Type | Field Size* | SpecieID | The species ID. Cross reference to the Specie table. | smallint | 2 | RunID | The run ID. Cross reference to Run table. | tinyint | 1 | SubRunID | The subrun ID, foreign key to table SubRun | 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 downstream measure in FEET of the presence of the species/run/subrun/life history in a stream. | int | 4 | EndFt | The upstream measure in FEET of the presence of the species/run/subrun/life history in a stream. | int | 4 | LifeHistoryID | Code for the life history strategy(s) of the species in the indicated reach. | tinyint | 1 | UseTypeID | Code for description of fish use | tinyint | 1 | Year | Year of compilation | smallint | 2 | RefID | Unique StreamNet reference ID number for the data source. Cross reference to the Reference table. | int | 4 | Comments | Additional information or comments. | text | 16 | CompilerID | Code for Agency that compiled this record | tinyint | 1 | UpdDate | The date and time the record was created or updated by agency compiler. | smalldatetime | 4 | LastModifiedBy | Network ID of regional staff or compiler that last updated record. | varchar | 50 | LastModifiedOn | Date regional staff or compiler last updated record | datetime | 8 | Comments255 | Additional information or comments. | varchar | 255 | Hook | Temporary field used by regional staff for record updates | varchar | 3 |
*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.