Data Dictionary
Weekly bcfishpass data extracts are available for download as zipped geopackages.
Access and linear habitat models included in this distribution are generated as described in the previous sections, with the following parameters:
for salmon, potential gradient barriers are considered passable up to 15%
for steelhead, potential gradient barriers are considered passable up to 20%
for both salmon and steelhead, potential natural barriers with 5 or more upstream observations of any of the target species (
CH, CM, CO, PK, SK, ST) since January 01, 1990 are presumed to be passable
Draft Bull Trout and Westslope Cutthroat Trout models are also included:
for Bull Trout, potential gradient barriers are considered passable up to 25%
for Westslope Cutthroat Trout, potential gradient barriers are considered passable up to 20%
for both Bull Trout and Westslope Cutthroat Trout, potential natural barriers are presumed to be passable if any observation(s) of the target species are found upstream
Linear spawning/rearing habitat (intrinsic potential) parameters/methods are as specified by the Canadian Wildlife Federation:
Note that while stream discharge (m3/s) is used to model habitat in the Bulkley, Horsefly and Elk River watershed groups, proprietary data discharge was used. Discharge data is not provided in these files for those watershed groups.
Files included in this data distribution are:
Note that draft lateral habitat modelling is not included - this is available on request.
crossings (points)
Road-stream crossings (and dams), including: tenure information; barrier status; upstream/downstream habitat lengths
column |
type |
description |
|---|---|---|
|
text |
unique identifier for crossing, taken from one of PSCIS stream_crossing_id / cabd_id / modelled_crossing_id + 1000000000 / user_barrier_anthropogenic_id + 1200000000 |
|
integer |
PSCIS stream crossing unique identifier |
|
text |
BC Dams unique identifier |
|
bigint |
User added misc anthropogenic barriers unique identifier |
|
integer |
Modelled crossing unique identifier |
|
text |
Data source for the crossing, one of: {PSCIS; MODELLED CROSSINGS; CABD; MISC BARRIERS} |
|
text |
Type of feature that crosses the stream one of {DAM; RAIL; ROAD, DEMOGRAPHIC; ROAD, RESOURCE/OTHER; TRAIL; WEIR} |
|
text |
From PSCIS, the current_pscis_status of the crossing, one of: {ASSESSED; HABITAT CONFIRMATION; DESIGN; REMEDIATED} |
|
text |
Defines the type of crossing present at the location of the stream crossing. One of: {OBS=Open Bottom Structure CBS=Closed Bottom Structure OTHER=Crossing structure does not fit into the above categories (ford/wier)} |
|
text |
Further definition of the type of crossing. One of {BRIDGE; CRTBOX; DAM; FORD; OVAL; PIPEARCH; ROUND; WEIR; WOODBOX; NULL} |
|
text |
List of sources that indicate if a modelled crossing is open bottom, one of: {FWA_EDGE_TYPE=double line river, FWA_STREAM_ORDER=stream order>=6, GBA_RAILWAY_STRUCTURE_LINES_SP=railway structure, MANUAL FIX=manually identified OBS, MOT_ROAD_STRUCTURE_SP=MoT structure, TRANSPORT_LINE_STRUCTURE_CODE=DRA structure} |
|
text |
The evaluation of the crossing as a barrier to the fish passage. From PSCIS, this is based on the FINAL SCORE value. For other data sources this varies. One of: {PASSABLE - Passable; POTENTIAL - Potential or partial barrier; BARRIER - Barrier; UNKNOWN - Other} |
|
text |
PSCIS road name, taken from the PSCIS assessment data submission |
|
text |
PSCIS stream name, taken from the PSCIS assessment data submission |
|
text |
PSCIS assessment_comment, taken from the PSCIS assessment data submission |
|
date |
PSCIS assessment_date, taken from the PSCIS assessment data submission |
|
integer |
PSCIS final_score, taken from the PSCIS assessment data submission |
|
text |
DRA road name, taken from the nearest DRA road (within 30m) |
|
text |
DRA road type, taken from the nearest DRA road (within 30m) |
|
text |
DRA road surface, taken from the nearest DRA road (within 30m) |
|
text |
FTEN road forest_file_id value, taken from the nearest FTEN road (within 30m) |
|
text |
FTEN road road_section_id value, taken from the nearest FTEN road (within 30m) |
|
text |
FTEN road tenure type (Forest Service Road, Road Permit, etc), taken from the nearest FTEN road (within 30m) |
|
text |
FTEN road client number, taken from the nearest FTEN road (within 30m) |
|
text |
FTEN road client name, taken from the nearest FTEN road (within 30m) |
|
text |
FTEN road life_cycle_status_code (active or retired, pending roads are not included), taken from the nearest FTEN road (within 30m) |
|
text |
FTEN road map_label value, taken from the nearest FTEN road (within 30m) |
|
text |
Railway name, taken from nearest railway (within 25m) |
|
text |
Railway owner name, taken from nearest railway (within 25m) |
|
text |
Railway operator name, taken from nearest railway (within 25m) |
|
text |
OGC road tenure proponent (currently modelled crossings only, taken from OGC road that crosses the stream) |
|
text |
See CABD dams column: dam_name_en |
|
double precision |
See CABD dams column: dam_height |
|
text |
See CABD dams column: owner |
|
text |
See CABD table dam_use_codes |
|
text |
See CABD dams column dam_operating_status |
|
integer |
UTM ZONE is a segment of the Earths surface 6 degrees of longitude in width. The zones are numbered eastward starting at the meridian 180 degrees from the prime meridian at Greenwich. There are five zones numbered 7 through 11 that cover British Columbia, e.g., Zone 10 with a central meridian at -123 degrees. |
|
integer |
UTM EASTING is the distance in meters eastward to or from the central meridian of a UTM zone with a false easting of 500000 meters. e.g., 440698 |
|
integer |
UTM NORTHING is the distance in meters northward from the equator. e.g., 6197826 |
|
character varying(32) |
Map index for field pdfs |
|
integer |
From BC FWA, the unique identifier for a stream segment (flow network arc) |
|
integer |
From BC FWA, uniquely identifies a single flow line such that a main channel and a secondary channel with the same watershed code would have different blue line keys (the Fraser River and all side channels have different blue line keys). |
|
integer |
From BC FWA, a key that identifies a stream system. There is a 1:1 match between a watershed key and watershed code. The watershed key will match the blue line key for the mainstem. |
|
double precision |
The distance, in meters, along the blue_line_key from the mouth of the stream/blue_line_key to the feature. |
|
ltree/text |
A truncated version of the BC FWA fwa_watershed_code (trailing zeros removed and - replaced with .) |
|
ltree/text |
A truncated version of the BC FWA local_watershed_code (trailing zeros removed and - replaced with .) |
|
text |
The watershed group code associated with the feature. |
|
text |
The BCGNIS (BC Geographical Names Information System) name associated with the FWA stream |
|
integer |
Order of FWA stream at point |
|
integer |
Magnitude of FWA stream at point |
|
double precision |
Cumulative area upstream of the end of the stream (as defined by linear_feature_id) |
|
integer |
Stream order of the stream into which the stream drains |
|
integer |
Maximum stream order associated with the stream (as defined by blue_line_key) |
|
integer |
Mean annual precipitation for the watershed upstream of the stream segment (as defined by linear_feature_id) |
|
double precision |
Modelled channel width of the stream (m) |
|
double precision |
Modelled mean annual discharge of the stream (m3/s) |
|
text |
Species codes of downstream fish observations |
|
text |
Species codes of upstream fish observations |
|
text |
aggregated_crossings_id value for all downstream crossings |
|
text |
aggregated_crossings_id value for all downstream anthropogenic barriers |
|
integer |
Count of anthropogenic downstream barriers |
|
text |
aggregated_crossings_id value for all upstream anthropogenic barriers |
|
integer |
Count of all upstream anthropogenic barriers |
|
text |
aggregated_crossings_id value for upstream anthropogenic barriers on streams accessible to Bull Trout |
|
integer |
Count of upstream anthropogenic barriers on streams accessible to Bull Trout |
|
text |
aggregated_crossings_id value for upstream anthropogenic barriers on streams accessible to Pacific Salmon |
|
integer |
Count of upstream anthropogenic barriers on streams accessible to Pacific Salmon |
|
text |
aggregated_crossings_id value for upstream anthropogenic barriers on streams accessible to Steelhead |
|
integer |
Count of upstream anthropogenic barriers on streams accessible to Steelhead |
|
text |
aggregated_crossings_id value for upstream anthropogenic barriers on streams accessible to West Slope Cutthroat Trout |
|
integer |
Count of upstream anthropogenic barriers on streams accessible to Bull Trout |
|
double precision |
Gradient of stream segment at crossing (defined by stream_segment_id) |
|
double precision |
Total upstream length of FWA stream network (km) |
|
double precision |
Total upstream length of FWA streams (single and double line, km) |
|
double precision |
Total upstream area of lakes and reservoirs (ha) |
|
double precision |
Total upstream area of wetlands (ha) |
|
double precision |
Total upstream length of stream < 3% gradient and connected waterbodies (km) |
|
double precision |
Total upstream length of stream < 3% gradient (km) |
|
double precision |
Total upstream length of stream < 5% gradient (km) |
|
double precision |
Total upstream length of stream < 8% gradient (km) |
|
double precision |
Total upstream length of stream < 15% gradient (km) |
|
double precision |
Total upstream length of stream < 22% gradient (km) |
|
double precision |
Total upstream length of stream < 30% gradient (km) |
|
double precision |
Total upstream length of FWA stream network, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of FWA streams, downstream of any anthropogenic barrier (single and double line, km) |
|
double precision |
Total upstream area of lakes and reservoirs, downstream of any anthropogenic barrier (ha) |
|
double precision |
Total upstream area of wetlands, downstream of any anthropogenic barrier (ha) |
|
double precision |
Total upstream length of stream < 3% gradient and connected waterbodies, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 3% gradient, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 5% gradient, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 8% gradient, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 15% gradient, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 22% gradient, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 30% gradient, downstream of any anthropogenic barrier (km) |
|
text |
aggregated_crossings_id value for downstream anthropogenic barriers on streams accessible to Bull Trout |
|
double precision |
Total upstream length of FWA stream network accessible to Bull Trout (km) |
|
double precision |
Total upstream length of FWA streams accessible to Bull Trout (single and double line, km) |
|
double precision |
Total upstream area of lakes and reservoirs accessible to Bull Trout (ha) |
|
double precision |
Total upstream area of wetlands accessible to Bull Trout (ha) |
|
double precision |
Total upstream length of stream < 3% gradient and connected waterbodies accessible to Bull Trout (km) |
|
double precision |
Total upstream length of stream < 3% gradient accessible to Bull Trout (km) |
|
double precision |
Total upstream length of stream < 5% gradient accessible to Bull Trout (km) |
|
double precision |
Total upstream length of stream < 8% gradient accessible to Bull Trout (km) |
|
double precision |
Total upstream length of stream < 15% gradient accessible to Bull Trout (km) |
|
double precision |
Total upstream length of stream < 22% gradient accessible to Bull Trout (km) |
|
double precision |
Total upstream length of stream < 30% gradient accessible to Bull Trout (km) |
|
double precision |
Total upstream length of FWA stream network accessible to Bull Trout, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of FWA streams accessible to Bull Trout, downstream of any anthropogenic barrier (single and double line, km) |
|
double precision |
Total upstream area of lakes and reservoirs accessible to Bull Trout, downstream of any anthropogenic barrier (ha) |
|
double precision |
Total upstream area of wetlands accessible to Bull Trout, downstream of any anthropogenic barrier (ha) |
|
double precision |
Total upstream length of stream < 3% gradient and connected waterbodies accessible to Bull Trout, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 3% gradient accessible to Bull Trout, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 5% gradient accessible to Bull Trout, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 8% gradient accessible to Bull Trout, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 15% gradient accessible to Bull Trout, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 22% gradient accessible to Bull Trout, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 30% gradient accessible to Bull Trout, downstream of any anthropogenic barrier (km) |
|
text |
aggregated_crossings_id value for downstream anthropogenic barriers on streams accessible to Pacific Salmon |
|
double precision |
Total upstream length of FWA stream network accessible to Pacific Salmon (km) |
|
double precision |
Total upstream length of FWA streams accessible to Pacific Salmon (single and double line, km) |
|
double precision |
Total upstream area of lakes and reservoirs accessible to Pacific Salmon (ha) |
|
double precision |
Total upstream area of wetlands accessible to Pacific Salmon (ha) |
|
double precision |
Total upstream length of stream < 3% gradient and connected waterbodies accessible to Pacific Salmon (km) |
|
double precision |
Total upstream length of stream < 3% gradient accessible to Pacific Salmon (km) |
|
double precision |
Total upstream length of stream < 5% gradient accessible to Pacific Salmon (km) |
|
double precision |
Total upstream length of stream < 8% gradient accessible to Pacific Salmon (km) |
|
double precision |
Total upstream length of stream < 15% gradient accessible to Pacific Salmon (km) |
|
double precision |
Total upstream length of stream < 22% gradient accessible to Pacific Salmon (km) |
|
double precision |
Total upstream length of stream < 30% gradient accessible to Pacific Salmon (km) |
|
double precision |
Total upstream length of FWA stream network accessible to Pacific Salmon, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of FWA streams accessible to Pacific Salmon, downstream of any anthropogenic barrier (single and double line, km) |
|
double precision |
Total upstream area of lakes and reservoirs accessible to Pacific Salmon, downstream of any anthropogenic barrier (ha) |
|
double precision |
Total upstream area of wetlands accessible to Pacific Salmon, downstream of any anthropogenic barrier (ha) |
|
double precision |
Total upstream length of stream < 3% gradient and connected waterbodies accessible to Pacific Salmon, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 3% gradient accessible to Pacific Salmon, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 5% gradient accessible to Pacific Salmon, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 8% gradient accessible to Pacific Salmon, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 15% gradient accessible to Pacific Salmon, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 22% gradient accessible to Pacific Salmon, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 30% gradient accessible to Pacific Salmon, downstream of any anthropogenic barrier (km) |
|
text |
aggregated_crossings_id value for downstream anthropogenic barriers on streams accessible to Steelhead |
|
double precision |
Total upstream length of FWA stream network accessible to Steelhead (km) |
|
double precision |
Total upstream length of FWA streams accessible to Steelhead (single and double line, km) |
|
double precision |
Total upstream area of lakes and reservoirs accessible to Steelhead (ha) |
|
double precision |
Total upstream area of wetlands accessible to Steelhead (ha) |
|
double precision |
Total upstream length of stream < 3% gradient and connected waterbodies accessible to Steelhead (km) |
|
double precision |
Total upstream length of stream < 3% gradient accessible to Steelhead (km) |
|
double precision |
Total upstream length of stream < 5% gradient accessible to Steelhead (km) |
|
double precision |
Total upstream length of stream < 8% gradient accessible to Steelhead (km) |
|
double precision |
Total upstream length of stream < 15% gradient accessible to Steelhead (km) |
|
double precision |
Total upstream length of stream < 22% gradient accessible to Steelhead (km) |
|
double precision |
Total upstream length of stream < 30% gradient accessible to Steelhead (km) |
|
double precision |
Total upstream length of FWA stream network accessible to Steelhead, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of FWA streams accessible to Steelhead, downstream of any anthropogenic barrier (single and double line, km) |
|
double precision |
Total upstream area of lakes and reservoirs accessible to Steelhead, downstream of any anthropogenic barrier (ha) |
|
double precision |
Total upstream area of wetlands accessible to Steelhead, downstream of any anthropogenic barrier (ha) |
|
double precision |
Total upstream length of stream < 3% gradient and connected waterbodies accessible to Steelhead, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 3% gradient accessible to Steelhead, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 5% gradient accessible to Steelhead, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 8% gradient accessible to Steelhead, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 15% gradient accessible to Steelhead, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 22% gradient accessible to Steelhead, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 30% gradient accessible to Steelhead, downstream of any anthropogenic barrier (km) |
|
text |
aggregated_crossings_id value for downstream anthropogenic barriers on streams accessible to West Slope Cutthroat Trout |
|
double precision |
Total upstream length of FWA stream network accessible to West Slope Cutthroat Trout (km) |
|
double precision |
Total upstream length of FWA streams accessible to West Slope Cutthroat Trout (single and double line, km) |
|
double precision |
Total upstream area of lakes and reservoirs accessible to West Slope Cutthroat Trout (ha) |
|
double precision |
Total upstream area of wetlands accessible to West Slope Cutthroat Trout (ha) |
|
double precision |
Total upstream length of stream < 3% gradient and connected waterbodies accessible to West Slope Cutthroat Trout (km) |
|
double precision |
Total upstream length of stream < 3% gradient accessible to West Slope Cutthroat Trout (km) |
|
double precision |
Total upstream length of stream < 5% gradient accessible to West Slope Cutthroat Trout (km) |
|
double precision |
Total upstream length of stream < 8% gradient accessible to West Slope Cutthroat Trout (km) |
|
double precision |
Total upstream length of stream < 15% gradient accessible to West Slope Cutthroat Trout (km) |
|
double precision |
Total upstream length of stream < 22% gradient accessible to West Slope Cutthroat Trout (km) |
|
double precision |
Total upstream length of stream < 30% gradient accessible to West Slope Cutthroat Trout (km) |
|
double precision |
Total upstream length of FWA stream network accessible to West Slope Cutthroat Trout, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of FWA streams accessible to West Slope Cutthroat Trout, downstream of any anthropogenic barrier (single and double line, km) |
|
double precision |
Total upstream area of lakes and reservoirs accessible to West Slope Cutthroat Trout, downstream of any anthropogenic barrier (ha) |
|
double precision |
Total upstream area of wetlands accessible to West Slope Cutthroat Trout, downstream of any anthropogenic barrier (ha) |
|
double precision |
Total upstream length of stream < 3% gradient and connected waterbodies accessible to West Slope Cutthroat Trout, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 3% gradient accessible to West Slope Cutthroat Trout, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 5% gradient accessible to West Slope Cutthroat Trout, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 8% gradient accessible to West Slope Cutthroat Trout, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 15% gradient accessible to West Slope Cutthroat Trout, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 22% gradient accessible to West Slope Cutthroat Trout, downstream of any anthropogenic barrier (km) |
|
double precision |
Total upstream length of stream < 30% gradient accessible to West Slope Cutthroat Trout, downstream of any anthropogenic barrier (km) |
|
double precision |
Upstream length of modelled/observed Bull Trout spawning |
|
double precision |
Upstream length of modelled/observed Bull Trout Rearing |
|
double precision |
Upstream length of modelled/observed Bull Trout spawning, downstream of any anthropogenic barriers |
|
double precision |
Upstream length of modelled/observed Bull Trout rearing, downstream of any anthropogenic barriers |
|
double precision |
Upstream length of modelled/observed Chinook spawning |
|
double precision |
Upstream length of modelled/observed Chinook Rearing |
|
double precision |
Upstream length of modelled/observed Chinook spawning, downstream of any anthropogenic barriers |
|
double precision |
Upstream length of modelled/observed Chinook rearing, downstream of any anthropogenic barriers |
|
double precision |
Upstream length of modelled/observed Chum spawning |
|
double precision |
Upstream length of modelled/observed Chum spawning, downstream of any anthropogenic barriers |
|
double precision |
Upstream length of modelled/observed Coho spawning |
|
double precision |
Upstream length of modelled/observed Coho rearing |
|
double precision |
Upstream area (wetlands) of modelled/observed Coho rearing |
|
double precision |
Upstream length of modelled/observed Coho spawning, downstream of any anthropogenic barriers |
|
double precision |
Upstream length of modelled/observed Coho rearing, downstream of any anthropogenic barriers |
|
double precision |
Upstream area (wetlands) of modelled/observed Coho rearing, downstream of any anthropogenic barriers |
|
double precision |
Upstream length of modelled/observed Pink spawning |
|
double precision |
Upstream length of modelled/observed Pink spawning, downstream of any anthropogenic barriers |
|
double precision |
Upstream length of modelled/observed Sockeye spawning |
|
double precision |
Upstream length of modelled/observed Sockeye rearing |
|
double precision |
Upstream area (lakes) of modelled/observed Sockeye rearing |
|
double precision |
Upstream length of modelled/observed Sockeye spawning |
|
double precision |
Upstream length of modelled/observed Sockeye rearing |
|
double precision |
Upstream area (lakes) of modelled/observed Sockeye rearing |
|
double precision |
Upstream length of modelled/observed Steelhead spawning |
|
double precision |
Upstream length of modelled/observed Steelhead Rearing |
|
double precision |
Upstream length of modelled/observed Steelhead spawning, downstream of any anthropogenic barriers |
|
double precision |
Upstream length of modelled/observed Steelhead rearing, downstream of any anthropogenic barriers |
|
double precision |
Upstream length of modelled/observed West Slope Cutthroat Trout spawning |
|
double precision |
Upstream length of modelled/observed West Slope Cutthroat Trout Rearing |
|
double precision |
Upstream length of modelled/observed West Slope Cutthroat Trout spawning, downstream of any anthropogenic barriers |
|
double precision |
Upstream length of modelled/observed West Slope Cutthroat Trout rearing, downstream of any anthropogenic barriers |
|
geometry(PointZM,3005) |
The point geometry associated with the feature |
streams (lines)
BC FWA stream network, with bcfishpass model classifications.
column |
type |
description |
|---|---|---|
|
text |
Unique id for the stream segment based on existing segmentation. Value is concatenation of blue_line_key.downstream_route_measure |
|
bigint |
FWA stream segment unique identifier |
|
integer |
From BC FWA: the unique identifier for a stream segment (flow network arc) |
|
integer |
From BC FWA: uniquely identifies a single flow line such that a main channel and a secondary channel with the same watershed code would have different blue line keys (the Fraser River and all side channels have different blue line keys). |
|
integer |
From BC FWA: a key that identifies a stream system. There is a 1:1 match between a watershed key and watershed code. The watershed key will match the blue line key for the mainstem. |
|
character varying(4) |
The watershed group code associated with the feature. |
|
double precision |
The distance (meters) along the blue_line_key from the mouth of the stream/blue_line_key to the feature. |
|
double precision |
The watershed group code associated with the feature. |
|
integer |
The waterbody key of the waterbody the edge is contained within. |
|
ltree/text |
A truncated version of the BC FWA fwa_watershed_code (trailing zeros removed and ‘-’ replaced with ‘.’) |
|
ltree/text |
A truncated version of the BC FWA local_watershed_code (trailing zeros removed and ‘-’ replaced with ‘.’) |
|
character varying(80) |
The BCGNIS (BC Geographical Names Information System) name associated with the FWA stream |
|
integer |
Order of FWA stream |
|
integer |
Magnitude of FWA stream |
|
double precision |
Gradient of the stream segment |
|
character varying(10) |
A value based on the Canadian Council of Surveys and Mapping’s (CCSM) system for classification of geographic features. |
|
double precision |
The distance (meters) along the blue_line_key from the mouth of the stream/blue_line_key to the upstream end of the feature. |
|
double precision |
Cumulative area upstream of the end of the stream (as defined by linear_feature_id) |
|
integer |
Stream order of the stream into which the stream drains |
|
integer |
Maximum stream order associated with the stream (as defined by blue_line_key) |
|
integer |
Mean annual precipitation for the watershed upstream of the stream segment (as defined by linear_feature_id) |
|
double precision |
Modelled channel width of the stream (m) |
|
double precision |
Modelled mean annual discharge of the stream (m3/s) |
|
text |
aggregated_crossings_id value for all downstream anthropogenic barriers |
|
text |
aggregated_crossings_id value for all downstream PSCIS assessed barriers |
|
text |
aggregated_crossings_id value for all downstream dams that are barriers |
|
text |
aggregated_crossings_id value for all downstream hydroelectricity dam that are barriers |
|
text |
aggregated_crossings_id value for downstream natural barriers to Bull Trout |
|
text |
aggregated_crossings_id value for downstream natural barriers to Pacific Salmon |
|
text |
aggregated_crossings_id value for downstream natural barriers to Cutthroat Trout/Dolly Varden/Rainbow Trout |
|
text |
aggregated_crossings_id value for downstream natural barriers to Steelhead |
|
text |
aggregated_crossings_id value for downstream natural barriers to West Slope Cutthroat Trout |
|
text |
aggregated_crossings_id value for all crossings downstream |
|
boolean |
Indicates if the next anthropogenic barrier downstream is a dam |
|
boolean |
Indicates if the next anthropogenic barrier downstream is a hydroelectric dam |
|
boolean |
Indicates if the next crossing downstream is a remediated PSCIS site |
|
text |
id value for all upstream target species fish observations |
|
text |
Unique species codes for all upstream target species observations (in watershed group) |
|
text |
Unique species codes for all downstream target species observations |
|
integer |
Bull Trout accessibility model: -9=not modelled; 0=natural barrier downstream; 1=modelled accessible; 2=observed accessible |
|
integer |
Chinook accessibility model: -9=not modelled; 0=natural barrier downstream; 1=modelled accessible; 2=observed accessible |
|
integer |
Chum accessibility model: -9=not modelled; 0=natural barrier downstream; 1=modelled accessible; 2=observed accessible |
|
integer |
Coho accessibility model: -9=not modelled; 0=natural barrier downstream; 1=modelled accessible; 2=observed accessible |
|
integer |
Pink accessibility model: -9=not modelled; 0=natural barrier downstream; 1=modelled accessible; 2=observed accessible |
|
integer |
Sockeye accessibility model: -9=not modelled; 0=natural barrier downstream; 1=modelled accessible; 2=observed accessible |
|
integer |
Steelhead accessibility model: -9=not modelled; 0=natural barrier downstream; 1=modelled accessible; 2=observed accessible |
|
integer |
West Slope Cutthroat Trout accessibility model: -9=not modelled; 0=natural barrier downstream; 1=modelled accessible; 2=observed accessible |
|
integer |
Pacific Salmon (all): accessibility model: -9=not modelled; 0=natural barrier downstream; 1=modelled accessible; 2=observed accessible |
|
integer |
Bull Trout spawning model: -9=not modelled; -1=known non spawning; 0=non spawning; 1=modelled spawning; 2=modelled and observed spawning; 3=observed spawning (not modelled) |
|
integer |
Chinook spawning model: -9=not modelled; -1=known non spawning; 0=non spawning; 1=modelled spawning; 2=modelled and observed spawning; 3=observed spawning (not modelled) |
|
integer |
Chum spawning model: -9=not modelled; -1=known non spawning; 0=non spawning; 1=modelled spawning; 2=modelled and observed spawning; 3=observed spawning (not modelled) |
|
integer |
Coho spawning model: -9=not modelled; -1=known non spawning; 0=non spawning; 1=modelled spawning; 2=modelled and observed spawning; 3=observed spawning (not modelled) |
|
integer |
Pink spawning model: -9=not modelled; -1=known non spawning; 0=non spawning; 1=modelled spawning; 2=modelled and observed spawning; 3=observed spawning (not modelled) |
|
integer |
Sockeye spawning model: -9=not modelled; -1=known non spawning; 0=non spawning; 1=modelled spawning; 2=modelled and observed spawning; 3=observed spawning (not modelled) |
|
integer |
Steelhead spawning model: -9=not modelled; -1=known non spawning; 0=non spawning; 1=modelled spawning; 2=modelled and observed spawning; 3=observed spawning (not modelled) |
|
integer |
West Slope Cutthroat Trout spawning model: -9=not modelled; -1=known non spawning; 0=non spawning; 1=modelled spawning; 2=modelled and observed spawning; 3=observed spawning (not modelled) |
|
integer |
Bull Trout rearing model: -9=not modelled; -1=known non rearing; 0=non rearing; 1=modelled rearing; 2=modelled and observed rearing; 3=observed rearing (not modelled) |
|
integer |
Chinook rearing model: -9=not modelled; -1=known non rearing; 0=non rearing; 1=modelled rearing; 2=modelled and observed rearing; 3=observed rearing (not modelled) |
|
integer |
Coho rearing model: -9=not modelled; -1=known non rearing; 0=non rearing; 1=modelled rearing; 2=modelled and observed rearing; 3=observed rearing (not modelled) |
|
integer |
Sockeye rearing model: -9=not modelled; -1=known non rearing; 0=non rearing; 1=modelled rearing; 2=modelled and observed rearing; 3=observed rearing (not modelled) |
|
integer |
Steelhead rearing model: -9=not modelled; -1=known non rearing; 0=non rearing; 1=modelled rearing; 2=modelled and observed rearing; 3=observed rearing (not modelled) |
|
integer |
West Slope Cutthroat rearing model: -9=not modelled; -1=known non rearing; 0=non rearing; 1=modelled rearing; 2=modelled and observed rearing; 3=observed rearing (not modelled) |
|
text |
Stream mapping code for Bull Trout: a string indicating: model output/downstream barrier status/stream type |
|
text |
Stream mapping code for Chinook: a string indicating: model output/downstream barrier status/stream type |
|
text |
Stream mapping code for Chum: a string indicating: model output/downstream barrier status/stream type |
|
text |
Stream mapping code for Coho: a string indicating: model output/downstream barrier status/stream type |
|
text |
Stream mapping code for Pink: a string indicating: model output/downstream barrier status/stream type |
|
text |
Stream mapping code for Sockeye: a string indicating: model output/downstream barrier status/stream type |
|
text |
Stream mapping code for Steelhead: a string indicating: model output/downstream barrier status/stream type |
|
text |
Stream mapping code for West Slope Cutthroat Trout: a string indicating: model output/downstream barrier status/stream type |
|
text |
Stream mapping code for Pacific Salmon (all): a string indicating: model output/downstream barrier status/stream type |
|
geometry(LineStringZM, 3005) |
Feature geometry |
summary_aw_linear (non-spatial)
A FWA Assessment Watershed level summary report of habitat and connectivity status for Pacific Salmon (Chinook, Chum, Coho, Pink, Sockeye), Steelhead, Bull Trout and Westslope Cutthroat Trout. The report summarizes total modelled naturally accessible length per species, and total modelled spawning/rearing accessible length per species.
column |
description |
|---|---|
|
Assessment watershed polygon identifier (watershed_feature_id) |
|
Total length of the stream network in the watershed (includes network connectors within waterbodies) |
|
Stream network observed as accessible to Bull Trout (km) |
|
Observed accessible Bull Trout stream downstream of known anthropogenic barriers (km) |
|
Observed accessible Bull Trout stream downstream of known anthropogenic barriers and modelled culverts (km) |
|
Stream network modelled as accessible to Bull Trout (km) |
|
Modelled accessible Bull Trout stream downstream of known anthropogenic barriers (km) |
|
Modelled accessible Bull Trout stream downstream of known anthropogenic barriers and modelled culverts (km) |
|
Stream network observed as accessible to Pacific Salmon (km) |
|
Observed accessible Pacific Salmon stream downstream of known anthropogenic barriers (km) |
|
Observed accessible Pacific Salmon stream downstream of known anthropogenic barriers and modelled culverts (km) |
|
Stream network modelled as accessible to Pacific Salmon (km) |
|
Modelled accessible Pacific Salmon stream downstream of known anthropogenic barriers (km) |
|
Modelled accessible Pacific Salmon stream downstream of known anthropogenic barriers and modelled culverts (km) |
|
Stream network observed as accessible to Steelhead (km) |
|
Observed accessible Steelhead stream downstream of known anthropogenic barriers (km) |
|
Observed accessible Steelhead stream downstream of known anthropogenic barriers and modelled culverts (km) |
|
Stream network modelled as accessible to Steelhead (km) |
|
Modelled accessible Steelhead stream downstream of known anthropogenic barriers (km) |
|
Modelled accessible Steelhead stream downstream of known anthropogenic barriers and modelled culverts (km) |
|
Stream network observed as accessible to West Slope Cutthroat Trout (km) |
|
Observed accessible West Slope Cutthroat Trout stream downstream of known anthropogenic barriers (km) |
|
Observed accessible West Slope Cutthroat Trout stream downstream of known anthropogenic barriers and modelled culverts (km) |
|
Stream network modelled as accessible to West Slope Cutthroat Trout (km) |
|
Modelled accessible West Slope Cutthroat Trout stream downstream of known anthropogenic barriers (km) |
|
Modelled accessible West Slope Cutthroat Trout stream downstream of known anthropogenic barriers and modelled culverts (km) |
|
Known/observed spawning and rearing, Bull Trout (km) |
|
Known/observed spawning and rearing downstream of known anthropogenic barriers, Bull Trout (km) |
|
Known/observed spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Bull Trout (km) |
|
Modelled spawning and rearing, Bull Trout (km) |
|
Modelled spawning and rearing downstream of known anthropogenic barriers, Bull Trout (km) |
|
Modelled spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Bull Trout (km) |
|
Known/observed spawning and rearing, Chinook (km) |
|
Known/observed spawning and rearing downstream of known anthropogenic barriers, Chinook (km) |
|
Known/observed spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Chinook (km) |
|
Modelled spawning and rearing, Chinook (km) |
|
Modelled spawning and rearing downstream of known anthropogenic barriers, Chinook (km) |
|
Modelled spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Chinook (km) |
|
Known/observed spawning, Chum (km) |
|
Known/observed spawning downstream of known anthropogenic barriers, Chum (km) |
|
Known/observed spawning downstream of known anthropogenic barriers and modelled culverts, Chum (km) |
|
Modelled spawning, Chum (km) |
|
Modelled spawning downstream of known anthropogenic barriers, Chum (km) |
|
Modelled spawning downstream of known anthropogenic barriers and modelled culverts, Chum (km) |
|
Known/observed spawning and rearing, Coho (km) |
|
Known/observed spawning and rearing downstream of known anthropogenic barriers, Coho (km) |
|
Known/observed spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Coho (km) |
|
Modelled spawning and rearing, Coho (km) |
|
Modelled spawning and rearing downstream of known anthropogenic barriers, Coho (km) |
|
Modelled spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Coho (km) |
|
Known/observed spawning, Pink (km) |
|
Known/observed spawning downstream of known anthropogenic barriers, Pink (km) |
|
Known/observed spawning downstream of known anthropogenic barriers and modelled culverts, Pink (km) |
|
Modelled spawning, Pink (km) |
|
Modelled spawning downstream of known anthropogenic barriers, Pink (km) |
|
Modelled spawning downstream of known anthropogenic barriers and modelled culverts, Pink (km) |
|
Known/observed spawning and rearing, Sockeye (km) |
|
Known/observed spawning and rearing downstream of known anthropogenic barriers, Sockeye (km) |
|
Known/observed spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Sockeye (km) |
|
Modelled spawning and rearing, Sockeye (km) |
|
Modelled spawning and rearing downstream of known anthropogenic barriers, Sockeye (km) |
|
Modelled spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Sockeye (km) |
|
Known/observed spawning and rearing, Steelhead (km) |
|
Known/observed spawning and rearing downstream of known anthropogenic barriers, Steelhead (km) |
|
Known/observed spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Steelhead (km) |
|
Modelled spawning and rearing, Steelhead (km) |
|
Modelled spawning and rearing downstream of known anthropogenic barriers, Steelhead (km) |
|
Modelled spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Steelhead (km) |
|
Known/observed spawning and rearing, West Slope Cutthroat Trout (km) |
|
Known/observed spawning and rearing downstream of known anthropogenic barriers, West Slope Cutthroat Trout (km) |
|
Known/observed spawning and rearing downstream of known anthropogenic barriers and modelled culverts, West Slope Cutthroat Trout (km) |
|
Modelled spawning and rearing, West Slope Cutthroat Trout (km) |
|
Modelled spawning and rearing downstream of known anthropogenic barriers, West Slope Cutthroat Trout (km) |
|
Modelled spawning and rearing downstream of known anthropogenic barriers and modelled culverts, West Slope Cutthroat Trout (km) |
|
Known/observed spawning and rearing, Pacific Salmon (km) |
|
Known/observed spawning and rearing downstream of known anthropogenic barriers, Pacific Salmon (km) |
|
Known/observed spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Pacific Salmon (km) |
|
Modelled spawning and rearing, Pacific Salmon (km) |
|
Modelled spawning and rearing downstream of known anthropogenic barriers, Pacific Salmon (km) |
|
Modelled spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Pacific Salmon (km) |
|
Known/observed spawning and rearing, Pacific Salmon and Steelhead (km) |
|
Known/observed spawning and rearing downstream of known anthropogenic barriers, Pacific Salmon and Steelhead (km) |
|
Known/observed spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Pacific Salmon and Steelhead (km) |
|
Modelled spawning and rearing, Pacific Salmon and Steelhead (km) |
|
Modelled spawning and rearing downstream of known anthropogenic barriers, Pacific Salmon and Steelhead (km) |
|
Modelled spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Pacific Salmon and Steelhead (km) |
|
Percentage of total potentially accessible stream network downstream of known anthropogenic barriers and modelled culverts, Bull Trout |
|
Percentage of total potentially accessible stream network downstream of known anthropogenic barriers and modelled culverts, Pacific Salmon |
|
Percentage of total potentially accessible stream network downstream of known anthropogenic barriers and modelled culverts, Steelhead |
|
Percentage of total potentially accessible stream network downstream of known anthropogenic barriers and modelled culverts, West Slope Cutthroat Trout |
|
Percentage of all spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Bull Trout |
|
Percentage of all spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Chinook |
|
Percentage of all spawning downstream of known anthropogenic barriers and modelled culverts, Chum |
|
Percentage of all spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Coho |
|
Percentage of all spawning downstream of known anthropogenic barriers and modelled culverts, Pink |
|
Percentage of all spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Sockeye |
|
Percentage of all spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Steelhead |
|
Percentage of all spawning and rearing downstream of known anthropogenic barriers and modelled culverts, West Slope Cutthroat Trout |
|
Percentage of all spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Pacific Salmon |
|
Percentage of all spawning and rearing downstream of known anthropogenic barriers and modelled culverts, Pacific Salmon and Steelhead |