This table includes all location codes of streams, collections of streams, flat water bodies, or pointlocations. No two location codes can be the same, even if they represent different location types.
| 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 | LocTypeID | Code identifying LocationID type, e.g. single stream, multi-stream, non-stream point, waterbody, etc. | tinyint | 1 | LocSubTypeID | Unique identifier describing the kind of a line, point or polygon represented by the LocationID. | smallint | 2 | Name | Name of the stream, lake, bay, reservoir, barrier, dam, port, etc. | varchar | 100 | LengthFt | Length of stream in feet. | int | 4 | TribID | LocationID of the waterbody this waterbody flows into. | varchar | 13 | TribFt | Point (in feet) this waterbody flows into the TribID. | int | 4 | Latitude | Latitude of point type locations in decimal degrees using 1983 North American Datum (NAD83). | decimal | 9 | Longitude | Longitude of a point type location in decimal degrees using the 1983 North American Datum (NAD83). | decimal | 9 | LLsource | Method by which the Longitude and Latitude values were determined. | varchar | 3 | Comments | Additional information or comments. | varchar | 255 | 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 | XRefName | Verbose Name used internally that includes tributary information. | varchar | 160 |
*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.