StreamNet

Hatchery Table

This table contains information about hatchery facilities. "Facility" is defined as an immobile, permanent or semi-permanent fish culture station.

Field Name Field Description Data Type Field Size*

HatchID The unique hatchery ID number for the facility smallint 2

Hatch_Name The name of the hatchery varchar 100

OutflowTypeID Code for Type of Waterbody Hatchery discharges water into tinyint 1

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

SiteLong Longitude 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

LocationID Unique identifier categorizing a line, point or polygon in either 1:100,000 or 1:24,000 scale GIS coverage. varchar 13

BegFt Measure in feet from the mouth of the stream that defines the location of the hatchery (if located on a stream) int 4

AgencyTypeID Management agency type code. tinyint 1

Address Address of the hatchery varchar 50

City City or town the hatchery is in. varchar 20

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

Zip The zip code of the hatchery varchar 10

AgencyID Code for the management agency responsible for the hatchery. Cross reference to Agency lookup table. smallint 2

AdultCap Does this facility have the infrastructure for capturing adults? tinyint 1

Spawn Does this facility have the infrastructure for adult spawning (egg collection)? tinyint 1

Hatch Does this facility have the infrastructure for holding eggs until hatching? tinyint 1

Rear Does this facility have the infrastructure for rearing fish? tinyint 1

Acclimate Does this facility have the infrastructure for prerelease acclimation? tinyint 1

Release Does this facility have the infrastructure for directly releasing fish to a natural water body? tinyint 1

Manager The name of the hatchery manager. varchar 30

Telephone Phone number for hatchery varchar 14

CountyID The county ID, foreign key to table County smallint 2

Elevation Elevation of the hatchery in feet. smallint 2

AuthorizedID Code for the legislation or program that authorized the hatchery construction tinyint 1

FTEStaff The number of Full Time Equivalent (FTE) staff on location real 4

InitYear The year the hatchery went into operation smallint 2

LastYear If not currently in operation, the last year the hatchery operated. smallint 2

AcresLand The acreage covered by the hatchery real 4

LandUse Percentage of acres actually in use by the hatchery real 4

LandOwner Who owns the land the hatchery is on varchar 100

FishWayTypeID Code describing type of fishway. tinyint 1

Comments Comments related to the hatchery text 16

HatchType AF = anadromous fish, RF = resident fish, BO = both - values preliminary at this time tinyint 1

CompilerID Code for Agency that compiled this record tinyint 1

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

UpdDate The date and time the record was created or updated by agency compiler. smalldatetime 4

DataEntry Compiler's name and/or other data entry source information. varchar 50

EndFt The ending measure of the stream section that defines the boundary of this facility, in feet. int 4

LastModifiedOn Date regional staff or compiler last updated record datetime 8

LastModifiedBy Network ID of regional staff or compiler that last updated record. varchar 50

ManagementTypeID Code for management agency type. Links to AgencyType table. tinyint 1

PSCcode Pacific Salmon Commission Hatchery Location Code varchar 19

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

WaterBodyID Identifier for a flat body of water such as a lake or reservoir or bay varchar 13

ProvinceID NWPPC Province Code (defined 2001) tinyint 1

Region2001ID Region Code (code defined in 2001 by StreamNet) tinyint 1

Subbasin2001ID Subbasin code defined in 2001 by StreamNet for Subbasins defined by NPCC. smallint 2

RegionID Region Code (used by StreamNet prior to 2001) tinyint 1

SubbasinID Subbasin code defined in 1990 by NPCC, but now named Subbasin1990ID. smallint 2

HucID Hydrologic Unit Code (4th field HUC)(no longer used - to be removed) char 8

Authorized The legislation or program that authorized the hatchery construction (no longer used - to be removed). varchar 30

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

Prop Distance of hatchery from the base of the EPA reach, measured a percentage of the total real 4

Type State or Federal 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*
HatchID	The unique hatchery ID number for the facility	smallint	2
Hatch_Name	The name of the hatchery	varchar	100
OutflowTypeID	Code for Type of Waterbody Hatchery discharges water into	tinyint	1
SiteLat	Latitude of the dam in decimal degrees using the 1983 North American Datum (NAD83).	decimal	9
SiteLong	Longitude 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
LocationID	Unique identifier categorizing a line, point or polygon in either 1:100,000 or 1:24,000 scale GIS coverage.	varchar	13
BegFt	Measure in feet from the mouth of the stream that defines the location of the hatchery (if located on a stream)	int	4
AgencyTypeID	Management agency type code.	tinyint	1
Address	Address of the hatchery	varchar	50
City	City or town the hatchery is in.	varchar	20
StateID	The identifier code for the state. Cross reference to State table.	tinyint	1
Zip	The zip code of the hatchery	varchar	10
AgencyID	Code for the management agency responsible for the hatchery. Cross reference to Agency lookup table.	smallint	2
AdultCap	Does this facility have the infrastructure for capturing adults?	tinyint	1
Spawn	Does this facility have the infrastructure for adult spawning (egg collection)?	tinyint	1
Hatch	Does this facility have the infrastructure for holding eggs until hatching?	tinyint	1
Rear	Does this facility have the infrastructure for rearing fish?	tinyint	1
Acclimate	Does this facility have the infrastructure for prerelease acclimation?	tinyint	1
Release	Does this facility have the infrastructure for directly releasing fish to a natural water body?	tinyint	1
Manager	The name of the hatchery manager.	varchar	30
Telephone	Phone number for hatchery	varchar	14
CountyID	The county ID, foreign key to table County	smallint	2
Elevation	Elevation of the hatchery in feet.	smallint	2
AuthorizedID	Code for the legislation or program that authorized the hatchery construction	tinyint	1
FTEStaff	The number of Full Time Equivalent (FTE) staff on location	real	4
InitYear	The year the hatchery went into operation	smallint	2
LastYear	If not currently in operation, the last year the hatchery operated.	smallint	2
AcresLand	The acreage covered by the hatchery	real	4
LandUse	Percentage of acres actually in use by the hatchery	real	4
LandOwner	Who owns the land the hatchery is on	varchar	100
FishWayTypeID	Code describing type of fishway.	tinyint	1
Comments	Comments related to the hatchery	text	16
HatchType	AF = anadromous fish, RF = resident fish, BO = both - values preliminary at this time	tinyint	1
CompilerID	Code for Agency that compiled this record	tinyint	1
RefID	The primary reference number describing the source of the hatchery information	int	4
UpdDate	The date and time the record was created or updated by agency compiler.	smalldatetime	4
DataEntry	Compiler's name and/or other data entry source information.	varchar	50
EndFt	The ending measure of the stream section that defines the boundary of this facility, in feet.	int	4
LastModifiedOn	Date regional staff or compiler last updated record	datetime	8
LastModifiedBy	Network ID of regional staff or compiler that last updated record.	varchar	50
ManagementTypeID	Code for management agency type. Links to AgencyType table.	tinyint	1
PSCcode	Pacific Salmon Commission Hatchery Location Code	varchar	19
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
WaterBodyID	Identifier for a flat body of water such as a lake or reservoir or bay	varchar	13
ProvinceID	NWPPC Province Code (defined 2001)	tinyint	1
Region2001ID	Region Code (code defined in 2001 by StreamNet)	tinyint	1
Subbasin2001ID	Subbasin code defined in 2001 by StreamNet for Subbasins defined by NPCC.	smallint	2
RegionID	Region Code (used by StreamNet prior to 2001)	tinyint	1
SubbasinID	Subbasin code defined in 1990 by NPCC, but now named Subbasin1990ID.	smallint	2
HucID	Hydrologic Unit Code (4th field HUC)(no longer used - to be removed)	char	8
Authorized	The legislation or program that authorized the hatchery construction (no longer used - to be removed).	varchar	30
RRN	The 1:250,000 scale EPA River Reach number, cross reference to Reach table. Obsolete field.	char	10
Prop	Distance of hatchery from the base of the EPA reach, measured a percentage of the total	real	4
Type	State or Federal	tinyint	1

Hatchery Table

Revised Wednesday September 28 2005