LLIDStream Table

LLID, stream name, and length in feet of streams in the 100K coverage.

Field Name Field Description Data Type Field Size*
LocationID Unique identifier categorizing a line, point or polygon in either 1:100,000 or 1:24,000 scale GIS coverage. varchar 13
Feat_Name Name of the stream or other water body. varchar 60
SumOfLength The length of the stream in the 1:100,000 coverage, measured in feet. real 4
TribID LLID of the stream this stream flows into. varchar 13
TribMile Fraction of a river mile on the TribID stream where this Stream enters. real 4
StreamID250 StreamID which identifies all reaches on a stream at 1:250,000 scale int 4
Hook Temporary field used by regional staff for record updates tinyint 1
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.


Revised Wednesday September 28 2005