StreamNet

Barrier Table

This table contains barrier attribute, location, and owner information.

Field Name Field Description Data Type Field Size*

BarrierID This field uniquely identifies a barrier identified by a particular agency 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

BegFt The beginning measure, in FEET, of the barrier. int 4

EndFt The ending measure of the barrier in feet int 4

Latitude Latitude of the barrier in decimal degrees using the 1983 North American Datum (NAD83). decimal 9

Longitude Longitude of the barrier 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

BarrierOwner The barrier owner varchar 100

AgencyTypeID Management agency type code. tinyint 1

Year_Comp The year the barrier was completed smallint 2

Year_Removed The year the barrier was removed (if applicable) smallint 2

GenPassStatID General status of severity of the barrier in terms of blocking fish movement. tinyint 1

BarrierTypeID Code describing type of barrier tinyint 1

DamID The DamID number for the dam. int 4

HatchID The hatchery ID code for Hatchery records with BarrierCategory = 5 smallint 2

FishWayTypeID Code describing the type of fishway tinyint 1

FishWayStatusID Code for the presence of fish passge facilities. tinyint 1

RefID The primary reference number describing the source of the Barrier information int 4

BarrierName Name of barrier, if applicable varchar 100

Height Height of barrier in feet smallint 2

Comments Special purposes, special conditions, etc. varchar 8000

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

StateID The identifier code for the state. Cross reference to State table. tinyint 1

*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.

Field Name	Field Description	Data Type	Field Size*
BarrierID	This field uniquely identifies a barrier identified by a particular agency	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
BegFt	The beginning measure, in FEET, of the barrier.	int	4
EndFt	The ending measure of the barrier in feet	int	4
Latitude	Latitude of the barrier in decimal degrees using the 1983 North American Datum (NAD83).	decimal	9
Longitude	Longitude of the barrier 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
BarrierOwner	The barrier owner	varchar	100
AgencyTypeID	Management agency type code.	tinyint	1
Year_Comp	The year the barrier was completed	smallint	2
Year_Removed	The year the barrier was removed (if applicable)	smallint	2
GenPassStatID	General status of severity of the barrier in terms of blocking fish movement.	tinyint	1
BarrierTypeID	Code describing type of barrier	tinyint	1
DamID	The DamID number for the dam.	int	4
HatchID	The hatchery ID code for Hatchery records with BarrierCategory = 5	smallint	2
FishWayTypeID	Code describing the type of fishway	tinyint	1
FishWayStatusID	Code for the presence of fish passge facilities.	tinyint	1
RefID	The primary reference number describing the source of the Barrier information	int	4
BarrierName	Name of barrier, if applicable	varchar	100
Height	Height of barrier in feet	smallint	2
Comments	Special purposes, special conditions, etc.	varchar	8000
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
StateID	The identifier code for the state. Cross reference to State table.	tinyint	1

Barrier Table

Revised Wednesday September 28 2005