StreamNet

Dam Table

Dams in the Pacific Northwest, originally derived from the National Inventory of Dams but being updated by state agencies.

Field Name Field Description Data Type Field Size*

DamID The DamID number for the dam. int 4

Dam_Name The name of the dam varchar 65

NID_# The National Inventory of Dams ID number char 7

FERC_SiteID Federal Energy Regulatory Commission Site Location Code char 12

Provisional If yes, indicates the reach number assgned may not be the exact location of the dam bit 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 beginning (downstream) measure, in feet from the mouth of the stream, of the location of the dam. int 4

FishwayTypeID Code describing the type of fishway tinyint 1

FishwayStatusID Code describing presence or status of fish passage facilities at the dam. tinyint 1

Owner The dam owner varchar 100

AgencyTypeID Management agency type code. tinyint 1

Year_Compl The year the dam was completed smallint 2

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

Dam_Length Dam crest length in feet real 4

NID_Height The maximum of dam, structure, or hydraulic height in feet real 4

Height Height of dam in feet from a source other than the National Inventory of Dams. smallint 2

Norm_Stor The normal storage capacity of the reservoir in acre feet real 4

Max_Stor The maximum storage capacity of the reservoir in acre feet real 4

Longitude Longitude of the dam in decimal degrees using the 1983 North American Datum (NAD83). decimal 9

Latitude Latitude of the dam 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 Comments related to the dam text 16

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

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

EndFt The ending (upstream) measure, in feet from the mouth of the stream, of the location of the dam (not in DEF). int 4

StateID The identifier code for the state. Cross reference to State table. (not in DEF) tinyint 1

QID QueryID - Location Code formerly used by online query system (use LocationID) varchar 13

LLID Unique stream identifier determined on a 1:100,000 scale GIS coverage. varchar 13

RRN The 1:250,000 scale EPA River Reach number, cross reference to Reach table. Obsolete field. varchar 16

Prop real 4

Year_Initiated The year the dam construction was initiated smallint 2

DamOwnerTypeID Code for the institutional status of the dam owner (Private, Federal or State, etc.) tinyint 1

OwnerTypeID Institutional status code for land owner tinyint 1

FishwayID Code describing presence of fish passage facilities 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*
DamID	The DamID number for the dam.	int	4
Dam_Name	The name of the dam	varchar	65
NID_#	The National Inventory of Dams ID number	char	7
FERC_SiteID	Federal Energy Regulatory Commission Site Location Code	char	12
Provisional	If yes, indicates the reach number assgned may not be the exact location of the dam	bit	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 beginning (downstream) measure, in feet from the mouth of the stream, of the location of the dam.	int	4
FishwayTypeID	Code describing the type of fishway	tinyint	1
FishwayStatusID	Code describing presence or status of fish passage facilities at the dam.	tinyint	1
Owner	The dam owner	varchar	100
AgencyTypeID	Management agency type code.	tinyint	1
Year_Compl	The year the dam was completed	smallint	2
Year_Removed	The year the dam was removed (if applicable)	smallint	2
Dam_Length	Dam crest length in feet	real	4
NID_Height	The maximum of dam, structure, or hydraulic height in feet	real	4
Height	Height of dam in feet from a source other than the National Inventory of Dams.	smallint	2
Norm_Stor	The normal storage capacity of the reservoir in acre feet	real	4
Max_Stor	The maximum storage capacity of the reservoir in acre feet	real	4
Longitude	Longitude of the dam in decimal degrees using the 1983 North American Datum (NAD83).	decimal	9
Latitude	Latitude of the dam 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	Comments related to the dam	text	16
RefID	The primary reference number describing the source of the Dam information	int	4
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
EndFt	The ending (upstream) measure, in feet from the mouth of the stream, of the location of the dam (not in DEF).	int	4
StateID	The identifier code for the state. Cross reference to State table. (not in DEF)	tinyint	1
QID	QueryID - Location Code formerly used by online query system (use LocationID)	varchar	13
LLID	Unique stream identifier determined on a 1:100,000 scale GIS coverage.	varchar	13
RRN	The 1:250,000 scale EPA River Reach number, cross reference to Reach table. Obsolete field.	varchar	16
Prop		real	4
Year_Initiated	The year the dam construction was initiated	smallint	2
DamOwnerTypeID	Code for the institutional status of the dam owner (Private, Federal or State, etc.)	tinyint	1
OwnerTypeID	Institutional status code for land owner	tinyint	1
FishwayID	Code describing presence of fish passage facilities	tinyint	1

Dam Table

Revised Wednesday September 28 2005