Provinical Fish Stocking Reports

75 views (33 recent)

Published by the Ministry of Environment and Climate Change Strategy - Knowledge Management
Licensed under Access Only

Each year, hundreds of lakes and rivers are stocked throughout BC. This data set contains both historical and current stocking record information, from 1900-present.

Data and Resources

Dataset Extent

Latitude: 48.0° to 60.0°
Longitude: -139.5° to -113.5°

Additional Information

Purpose

This data set enables users to find out what species were released, where and when.

Data Quality

Data is updated on a daily basis

Lineage Statement

The data comes from a variety of sources including the Freshwater Fisheries Society of BC, the Department of Fisheries and Ocean, and historical provincial records.

Contact Information

NameGord Oliphant (pointOfContact)
EmailGord.Oliphant@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationKnowledge Management
NameRobin Munro (businessExpert)
EmailRobin.Munro@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationKnowledge Management

Access & Security

Who can view this dataset? Public
Who can download this dataset?Public

Metadata Information

Record Published 2019-05-08
Record Last Modified 2019-05-08
Resource Status onGoing
Spatial DataSDO_GEOMETRY

Object Description

Object Name: WHSE_FISH.FISH_RELEASES_PUBLIC_VW

Short Name: FSHRLSSPBL

Column Name Short Name Data Type Data Precision Comments
CONTAINER_ID CNTNRD NUMBER 5 Is a surrogate unique key for a CONTAINER from which fish are released
RELEASE_ID RELEASE_ID NUMBER 9 Is a surrogate unique key for a single release from a specific CONTAINER
WBODY_ID WBODY_ID NUMBER 12 Is a system generated unique number used to identify a WATERBODY
WBODY_TYPE WBODY_TYPE VARCHAR2 3 Is a code used to indicate the type of WATERBODY ('S'tream,'L'ake)
NEW_WATERSHED_CODE NWWTRSHDCD VARCHAR2 168 Is the watershed code assigned in the GIS system
WATERBODY_IDENTIFIER WTRBDDNTFR VARCHAR2 27 Is the GIS Waterbody Identifier: 5-digit seqnce nmbr + 4-character water
GAZETTED_NAME GZTTDNM VARCHAR2 90 Is the Gazetted name of the WATERBODY
SPECIES_CODE SPCSCD VARCHAR2 6 Is the foreign key to the SPECIES CD table indicating the species of the fish released
SPECIES_NAME SPCSNM VARCHAR2 180 Is the common name of the fish SPECIES
BROOD_YEAR BROOD_YEAR NUMBER 4 Is the year of the broodstock (year eggs were hatched)
HATCHERY_CODE HTCHRCD VARCHAR2 4 Is a code for HATCHERY NAME
HATCHERY_NAME HTCHRNM VARCHAR2 40 Is the name of the hatchery from which the fished were released
RELEASE_DATE RLSDT DATE 7 Is the date the RELEASE was made
EGGS_IND EGGS_IND CHAR 1 Indicates whether the release was a planting of eggs as opposed to live fish
STRAIN_NAME STRNNM VARCHAR2 35 Is the name of the strain of stock released
STRAIN_WBODY_ID STRNWBDD NUMBER 12 Is the foreign key to the WDIC WATERBODIES table indicating the waterbody that determined the strain of stock released
SOURCE_NAME SRCNM VARCHAR2 35 Is the name of the source of stock released
SOURCE_WBODY_ID SRCWBDD NUMBER 12 Is the foreign key to the WDIC WATERBODIES table indicating the waterbody that was the source of the stock released
ORIGIN ORIGIN VARCHAR2 15 Indicates if the release was from the Wild, from a Hatchery, or a combination of both
LIFE_STAGE LIFE_STAGE VARCHAR2 20 Is the stage in life the fish had attained on release
LIFE_STAGE_CODE LFSTGCD VARCHAR2 3 Is a code for LIFE STAGE
MARK_DESCRIPTION MRKDSCRPTN VARCHAR2 40 If the released fish were marked, a MARK DESCRIPTION is a description of the mark
MARK_DESCRIPTION_CODE MRKDSCRPT1 VARCHAR2 6 Is a code for MARK DESCRIPTION
RELEASED_QUANTITY RLSDQNTT NUMBER 7 Specifies the number of fish released
AVERAGE_WEIGHT VRGWGHT NUMBER 6 Is the average weight, in grams, of the released fish
RELEASE_MECHANISM RLSMCHNSM VARCHAR2 20 Is the mechanism, like plane, truck, or helicopter, by which the fish were delivered for release
RELEASE_MECHANISM_CODE RLSMCHNSMC VARCHAR2 1 Is a code for RELEASE MECHANISM
RELEASE_SITE_NAME RLSSTNM VARCHAR2 40 Is the name of the site at which the fish were released
RELEASE_SITE_CODE RLSSTCD VARCHAR2 4 Is a code for RELEASE SITE NAME
GENOTYPE_NAME GNTPNM VARCHAR2 30 Is the genotype, the set of common hereditary characteristics, of the fish stock
GENOTYPE_CODE GNTPCD VARCHAR2 5 Is a code for the GENOTYPE NAME
WATER_TEMPERATURE WTRTMPRTR NUMBER 3 Is the temperature, in Celcius, of the water at time of release
PH_LEVEL PH_LEVEL NUMBER 3 Specifies the pH level of the water at time of release
COMMENTS COMMENTS VARCHAR2 256 Is miscellaneous comments about the release
WITNESSED_IND WTNSSDND VARCHAR2 1 Indicates whether or not (Y/N) Ministry of Environment staff were present during the release
AGENCY_NAME GNCNM VARCHAR2 20 Is the AGENCY NAME
AGENCY_CODE GNCCD VARCHAR2 1 Is a code for AGENCY NAME
WBODY_ALIASES WBDLSS VARCHAR2 4000 Are the alias name(s) for the waterbody
PRIMARY_REGION_CODE PRMRRGNCD VARCHAR2 18 A code which uniquely identifies the Fish and Wildlife REGION
PRIMARY_REGION_NAME PRMRRGNNM VARCHAR2 180 Is the primary region for the waterbody