ICBEMP Habitat data (Interior Columbia Basin Ecosystem Management Project).
| Field Name | Field Description | Data Type | Field Size* | StreamID | Unique stream identifier once used by NPCC. | varchar | 13 | GroupID | Null | char | 6 | BegFt | Beginning point of LLID applicable. | real | 4 | EndFt | Ending point of LLID applicable. | real | 4 | Date | Null | datetime | 8 | Section | Null | smallint | 2 | Length | Null | real | 4 | Gradient | Null | real | 4 | Width | An estimate of the mean summer low flow width of the reach in feet | real | 4 | Pools | Null | real | 4 | PoolFreq | Null | real | 4 | BankErosion | Null | real | 4 | LWD | Large Woody Debris | real | 4 | LWDFreq | Large Woody Debris frequency | real | 4 | KeyLWD | Null | real | 4 | KeyLWDFreq | Null | real | 4 | MaxTemp | Maximum temperature | real | 4 | ResidPD | Null | real | 4 | WDRatio | Width to Depth ratio. | real | 4 | RefID | Unique StreamNet reference ID number for the data source. Cross reference to the Reference table. | int | 4 | LocationID | Unique identifier categorizing a line, point or polygon in either 1:100,000 or 1:24,000 scale GIS coverage. | varchar | 13 |
*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.