Data Dictionary

Freshwater Fish Habitat Accessibility MODEL - Pacific Salmon and Steelhead

A weekly bcfishpass data extract of Pacific Salmon (Chinook, Chum, Coho, Pink, Sockeye) and Steelhead access models (and associated data) is available for download as a zipped geopackage:

https://bcfishpass.s3.us-west-2.amazonaws.com/freshwater_fish_habitat_accessibility_MODEL.gpkg.zip.

The models included in this distribution are generated as described in the access model section, 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

Tables/layers included in the distribution are:

barriers_salmon

Locations of natural barriers to salmon (Chinook, Chum, Coho, Pink, Sockeye) migration with no other natural barriers downstream, and less than 5 observations of salmon or steelhead upstream since January 01, 1990.

Includes waterfalls, subsurface flow, gradient barriers of 15% and greater, and misc user supplied barriers.

column

description

barriers_ch_cm_co_pk_sk_id

Unique identifier

barrier_type

Barrier type description

barrier_name

Name of barrier (where applicable)

linear_feature_id

From BC FWA,the unique identifier for a stream segment (flow network arc)

blue_line_key

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)

watershed_key

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.

downstream_route_measure

The distance, in meters, along the blue_line_key from the mouth of the stream/blue_line_key to the feature

wscode

A truncated version of the BC FWA fwa_watershed_code (trailing zeros removed and ‘-’ replaced with ‘.’

localcode

A truncated version of the BC FWA local_watershed_code (trailing zeros removed and ‘-’ replaced with ‘.’

watershed_group_code

The watershed group code associated with the feature

total_network_km

Length (km) of stream upstream of the barrier (useful for identification of erroneous high-impact barriers)

geom

The point geometry associated with the feature

barriers_steelhead

Locations of natural barriers to steelhead migration with no other natural barriers downstream, and less than 5 observations of salmon or steelhead upstream since January 01, 1990. Includes waterfalls, subsurface flow, gradient barriers of 20% and greater, and user supplied misc barriers.

column

description

barriers_st_id

Unique identifier

barrier_type

Barrier type description

barrier_name

Name of barrier (where applicable)

linear_feature_id

From BC FWA,the unique identifier for a stream segment (flow network arc)

blue_line_key

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)

watershed_key

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.

downstream_route_measure

The distance, in meters, along the blue_line_key from the mouth of the stream/blue_line_key to the feature

wscode

A truncated version of the BC FWA fwa_watershed_code (trailing zeros removed and ‘-’ replaced with ‘.’

localcode

A truncated version of the BC FWA local_watershed_code (trailing zeros removed and ‘-’ replaced with ‘.’

watershed_group_code

The watershed group code associated with the feature

total_network_km

Length (km) of stream upstream of the barrier (useful for identification of erroneous high-impact barriers)

geom

The point geometry associated with the feature

crossings

Aggregated stream crossing locations. Features are aggregated from:

  • PSCIS stream crossings (where possible to match to an FWA stream)

  • CABD dams (where possible to match to an FWA stream)

  • modelled road/rail/trail stream crossings

  • misc anthropogenic barriers from expert/local input

Includes barrier status, key attributes from source datasets, and various length upstream summaries.

column

description

aggregated_crossings_id

unique identifier for crossing, generated from stream_crossing_id, modelled_crossing_id + 1000000000, user_barrier_anthropogenic_id + 1200000000, cabd_id

stream_crossing_id

PSCIS stream crossing unique identifier

dam_id

BC Dams unique identifier

user_barrier_anthropogenic_id

User added misc anthropogenic barriers unique identifier

modelled_crossing_id

Modelled crossing unique identifier

crossing_source

Data source for the crossing, one of: {PSCIS,MODELLED CROSSINGS,CABD,MISC BARRIERS}

crossing_feature_type

The general type of feature crossing the stream, valid feature types are {DAM,RAIL,’ROAD, DEMOGRAPHIC’,’ROAD, RESOURCE/OTHER’,TRAIL,WEIR}

pscis_status

From PSCIS, the current_pscis_status of the crossing, one of: {ASSESSED,HABITAT CONFIRMATION,DESIGN,REMEDIATED}

crossing_type_code

Defines the type of crossing present at the location of the stream crossing. Acceptable types are: OBS = Open Bottom Structure CBS = Closed Bottom Structure OTHER = Crossing structure does not fit into the above categories. Eg: ford, wier

crossing_subtype_code

Further definition of the type of crossing, one of {BRIDGE,CRTBOX,DAM,FORD,OVAL,PIPEARCH,ROUND,WEIR,WOODBOX,NULL}

modelled_crossing_type_source

List of sources that indicate if a modelled crossing is open bottom, Acceptable values are: 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}

barrier_status

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. Acceptable Values are: PASSABLE - Passable, POTENTIAL - Potential or partial barrier, BARRIER - Barrier, UNKNOWN - Other

pscis_road_name

PSCIS road name, taken from the PSCIS assessment data submission

pscis_stream_name

PSCIS stream name, taken from the PSCIS assessment data submission

pscis_assessment_comment

PSCIS assessment_comment, taken from the PSCIS assessment data submission

pscis_assessment_date

PSCIS assessment_date, taken from the PSCIS assessment data submission

pscis_final_score

PSCIS final_score, taken from the PSCIS assessment data submission

transport_line_structured_name_1

DRA road name, taken from the nearest DRA road (within 30m)

transport_line_type_description

DRA road type, taken from the nearest DRA road (within 30m)

transport_line_surface_description

DRA road surface, taken from the nearest DRA road (within 30m)

ften_forest_file_id

FTEN road forest_file_id value, taken from the nearest FTEN road (within 30m)

ften_file_type_description

FTEN road tenure type (Forest Service Road, Road Permit, etc), taken from the nearest FTEN road (within 30m)

ften_client_number

FTEN road client number, taken from the nearest FTEN road (within 30m)

ften_client_name

FTEN road client name, taken from the nearest FTEN road (within 30m)

ften_life_cycle_status_code

FTEN road life_cycle_status_code (active or retired, pending roads are not included), taken from the nearest FTEN road (within 30m)

rail_track_name

Railway name, taken from nearest railway (within 25m)

rail_owner_name

Railway owner name, taken from nearest railway (within 25m)

rail_operator_english_name

Railway operator name, taken from nearest railway (within 25m)

ogc_proponent

OGC road tenure proponent (currently modelled crossings only, taken from OGC road that crosses the stream)

dam_name

See CABD dams column: dam_name_en

dam_height

See CABD dams column: dam_height

dam_owner

See CABD dams column: owner

dam_use

See CABD table dam_use_codes

dam_operating_status

See CABD dams column dam_operating_status

utm_zone

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.

utm_easting

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

utm_northing

UTM NORTHING is the distance in meters northward from the equator. e.g., 6197826

dbm_mof_50k_grid

WHSE_BASEMAPPING.DBM_MOF_50K_GRID map_tile_display_name, used for generating planning map pdfs

linear_feature_id

From BC FWA, the unique identifier for a stream segment (flow network arc)

blue_line_key

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).

watershed_key

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.

downstream_route_measure

The distance, in meters, along the blue_line_key from the mouth of the stream/blue_line_key to the feature.

wscode

A truncated version of the BC FWA fwa_watershed_code (trailing zeros removed and ‘-’ replaced with ‘.’

localcode

A truncated version of the BC FWA local_watershed_code (trailing zeros removed and ‘-’ replaced with ‘.’

watershed_group_code

The watershed group code associated with the feature.

gnis_stream_name

The BCGNIS (BC Geographical Names Information System) name associated with the FWA stream

stream_order

Order of FWA stream at point

stream_magnitude

Magnitude of FWA stream at point

observedspp_dnstr

Fish species observed downstream of point within the same watershed group

observedspp_upstr

Fish species observed upstream of point

crossings_dnstr

List of aggregated_crossings_id values for all crossings downstream

barriers_anthropogenic_dnstr

List of aggregated_crossings_id values for all anthropogenic barriers downstream

barriers_anthropogenic_dnstr_count

Count of anthropogenic barriers downstream

barriers_anthropogenic_upstr

List of aggregated_crossings_id values for all anthropogenic barriers upstream

barriers_anthropogenic_upstr_count

Count of anthropogenic barriers upstream

barriers_anthropogenic_ch_cm_co_pk_sk_upstr

List of aggregated_crossings_id values for anthropogenic barriers upstream modelled as accessible to Pacific Salmon

barriers_anthropogenic_ch_cm_co_pk_sk_upstr_count

Count of aggregated_crossings_id values for anthropogenic barriers upstream modelled as accessible to Pacific Salmon

barriers_anthropogenic_st_upstr

List of aggregated_crossings_id values for all anthropogenic barriers upstream modelled as accessible to Steelhead

barriers_anthropogenic_st_upstr_count

Count of anthropogenic barriers upstream modelled as accessible to Steelhead

gradient

Stream slope at point

total_network_km

Total length of stream network upstream of point

total_stream_km

Total length of streams and rivers upstream of point (does not include network connectors in lakes etc)

total_lakereservoir_ha

Total area lakes and reservoirs upstream of point

total_wetland_ha

Total area wetlands upstream of point

total_slopeclass03_waterbodies_km

Total length of stream connectors (in waterbodies) potentially accessible upstream of point with slope 0-3%

total_slopeclass03_km

Total length of stream potentially accessible upstream of point with slope 0-3%

total_slopeclass05_km

Total length of stream potentially accessible upstream of point with slope 3-5%

total_slopeclass08_km

Total length of stream potentially accessible upstream of point with slope 5-8%

total_slopeclass15_km

Total length of stream potentially accessible upstream of point with slope 8-15%

total_slopeclass22_km

Total length of stream potentially accessible upstream of point with slope 15-22%

total_slopeclass30_km

Total length of stream potentially accessible upstream of point with slope 22-30%

total_belowupstrbarriers_network_km

Total length of stream network potentially accessible upstream of point and below any additional upstream barriers

total_belowupstrbarriers_stream_km

Total length of streams and rivers potentially accessible upstream of point and below any additional upstream barriers (does not include network connectors in lakes etc)

total_belowupstrbarriers_lakereservoir_ha

Total area lakes and reservoirs potentially accessible upstream of point and below any additional upstream barriers

total_belowupstrbarriers_wetland_ha

Total area wetlands potentially accessible upstream of point and below any additional upstream barriers

total_belowupstrbarriers_slopeclass03_waterbodies_km

Total length of stream connectors (in waterbodies) potentially accessible upstream of point and below any additional upstream barriers, with slope 0-3%

total_belowupstrbarriers_slopeclass03_km

Total length of stream potentially accessible upstream of point and below any additional upstream barriers, with slope 0-3%

total_belowupstrbarriers_slopeclass05_km

Total length of stream potentially accessible upstream of point and below any additional upstream barriers, with slope 3-5%

total_belowupstrbarriers_slopeclass08_km

Total length of stream potentially accessible upstream of point and below any additional upstream barriers, with slope 5-8%

total_belowupstrbarriers_slopeclass15_km

Total length of stream potentially accessible upstream of point and below any additional upstream barriers, with slope 8-15%

total_belowupstrbarriers_slopeclass22_km

Total length of stream potentially accessible upstream of point and below any additional upstream barriers, with slope 15-22%

total_belowupstrbarriers_slopeclass30_km

Total length of stream potentially accessible upstream of point and below any additional upstream barriers, with slope 22-30%

barriers_ch_cm_co_pk_sk_dnstr

Modelled accessibility to Pacific Salmon (CH/CM/CO/PK/SK, 15% max)

ch_cm_co_pk_sk_network_km

Pacific salmon model (CH/CM/CO/PK/SK), total length of stream network potentially accessible upstream of point

ch_cm_co_pk_sk_stream_km

Pacific salmon model (CH/CM/CO/PK/SK), total length of streams and rivers potentially accessible upstream of point (does not include network connectors in lakes etc)

ch_cm_co_pk_sk_lakereservoir_ha

Pacific salmon model (CH/CM/CO/PK/SK), total area lakes and reservoirs potentially accessible upstream of point

ch_cm_co_pk_sk_wetland_ha

Pacific salmon model (CH/CM/CO/PK/SK), total area wetlands potentially accessible upstream of point

ch_cm_co_pk_sk_slopeclass03_waterbodies_km

Pacific salmon model (CH/CM/CO/PK/SK), length of stream connectors (in waterbodies) potentially accessible upstream of point with slope 0-3%

ch_cm_co_pk_sk_slopeclass03_km

Pacific salmon model (CH/CM/CO/PK/SK), length of stream potentially accessible upstream of point with slope 0-3%

ch_cm_co_pk_sk_slopeclass05_km

Pacific salmon model (CH/CM/CO/PK/SK), length of stream potentially accessible upstream of point with slope 3-5%

ch_cm_co_pk_sk_slopeclass08_km

Pacific salmon model (CH/CM/CO/PK/SK), length of stream potentially accessible upstream of point with slope 5-8%

ch_cm_co_pk_sk_slopeclass15_km

Pacific salmon model (CH/CM/CO/PK/SK), length of stream potentially accessible upstream of point with slope 8-15%

ch_cm_co_pk_sk_slopeclass22_km

Pacific salmon model (CH/CM/CO/PK/SK), length of stream potentially accessible upstream of point with slope 15-22%

ch_cm_co_pk_sk_slopeclass30_km

Pacific salmon model (CH/CM/CO/PK/SK), length of stream potentially accessible upstream of point with slope 22-30%

ch_cm_co_pk_sk_belowupstrbarriers_network_km

Pacific salmon model (CH/CM/CO/PK/SK), total length of stream network potentially accessible upstream of point and below any additional upstream barriers

ch_cm_co_pk_sk_belowupstrbarriers_stream_km

Pacific salmon model (CH/CM/CO/PK/SK), total length of streams and rivers potentially accessible upstream of point and below any additional upstream barriers (does not include network connectors in lakes etc)

ch_cm_co_pk_sk_belowupstrbarriers_lakereservoir_ha

Pacific salmon model (CH/CM/CO/PK/SK), total area lakes and reservoirs potentially accessible upstream of point and below any additional upstream barriers

ch_cm_co_pk_sk_belowupstrbarriers_wetland_ha

Pacific salmon model (CH/CM/CO/PK/SK), total area wetlands potentially accessible upstream of point and below any additional upstream barriers

ch_cm_co_pk_sk_belowupstrbarriers_slopeclass03_waterbodies_km

Pacific salmon model (CH/CM/CO/PK/SK), length of stream connectors (in waterbodies) potentially accessible upstream of point and below any additional upstream barriers, with slope 0-3%

ch_cm_co_pk_sk_belowupstrbarriers_slopeclass03_km

Pacific salmon model (CH/CM/CO/PK/SK), length of stream potentially accessible upstream of point and below any additional upstream barriers, with slope 0-3%

ch_cm_co_pk_sk_belowupstrbarriers_slopeclass05_km

Pacific salmon model (CH/CM/CO/PK/SK), length of stream potentially accessible upstream of point and below any additional upstream barriers, with slope 3-5%

ch_cm_co_pk_sk_belowupstrbarriers_slopeclass08_km

Pacific salmon model (CH/CM/CO/PK/SK), length of stream potentially accessible upstream of point and below any additional upstream barriers, with slope 5-8%

ch_cm_co_pk_sk_belowupstrbarriers_slopeclass15_km

Pacific salmon model (CH/CM/CO/PK/SK), length of stream potentially accessible upstream of point and below any additional upstream barriers, with slope 8-15%

ch_cm_co_pk_sk_belowupstrbarriers_slopeclass22_km

Pacific salmon model (CH/CM/CO/PK/SK), length of stream potentially accessible upstream of point and below any additional upstream barriers, with slope 15-22%

ch_cm_co_pk_sk_belowupstrbarriers_slopeclass30_km

Pacific salmon model (CH/CM/CO/PK/SK), length of stream potentially accessible upstream of point and below any additional upstream barriers, with slope 22-30%

barriers_st_dnstr

Modelled accessibility to Steelhead (20% max)

st_network_km

Steelhead model, total length of stream network potentially accessible upstream of point

st_stream_km

Steelhead model, total length of streams and rivers potentially accessible upstream of point (does not include network connectors in lakes etc)

st_lakereservoir_ha

Steelhead model, total area lakes and reservoirs potentially accessible upstream of point

st_wetland_ha

Steelhead model, total area wetlands potentially accessible upstream of point

st_slopeclass03_waterbodies_km

Steelhead model, length of stream connectors (in waterbodies) potentially accessible upstream of point with slope 0-3%

st_slopeclass03_km

Steelhead model, length of stream potentially accessible upstream of point with slope 0-3%

st_slopeclass05_km

Steelhead model, length of stream potentially accessible upstream of point with slope 3-5%

st_slopeclass08_km

Steelhead model, length of stream potentially accessible upstream of point with slope 5-8%

st_slopeclass15_km

Steelhead model, length of stream potentially accessible upstream of point with slope 8-15%

st_slopeclass22_km

Steelhead model, length of stream potentially accessible upstream of point with slope 15-22%

st_slopeclass30_km

Steelhead model, length of stream potentially accessible upstream of point with slope 22-30%

st_belowupstrbarriers_network_km

Steelhead model, total length of stream network potentially accessible upstream of point and below any additional upstream barriers

st_belowupstrbarriers_stream_km

Steelhead model, total length of streams and rivers potentially accessible upstream of point and below any additional upstream barriers (does not include network connectors in lakes etc)

st_belowupstrbarriers_lakereservoir_ha

Steelhead model, total area lakes and reservoirs potentially accessible upstream of point and below any additional upstream barriers

st_belowupstrbarriers_wetland_ha

Steelhead model, total area wetlands potentially accessible upstream of point and below any additional upstream barriers

st_belowupstrbarriers_slopeclass03_waterbodies_km

Steelhead model, length of stream connectors (in waterbodies) potentially accessible upstream of point and below any additional upstream barriers, with slope 0-3%

st_belowupstrbarriers_slopeclass03_km

Steelhead model, length of stream potentially accessible upstream of point and below any additional upstream barriers, with slope 0-3%

st_belowupstrbarriers_slopeclass05_km

Steelhead model, length of stream potentially accessible upstream of point and below any additional upstream barriers, with slope 3-5%

st_belowupstrbarriers_slopeclass08_km

Steelhead model, length of stream potentially accessible upstream of point and below any additional upstream barriers, with slope 5-8%

st_belowupstrbarriers_slopeclass15_km

Steelhead model, length of stream potentially accessible upstream of point and below any additional upstream barriers, with slope 8-15%

st_belowupstrbarriers_slopeclass22_km

Steelhead model, length of stream potentially accessible upstream of point and below any additional upstream barriers, with slope 15-22%

st_belowupstrbarriers_slopeclass30_km

Steelhead model, length of stream potentially accessible upstream of point and below any additional upstream barriers, with slope 22-30%

geom

The point geometry associated with the feature

model_access_salmon

All FWA stream downstream of points included in barriers_salmon. In the absence of anthropogenic barriers, all pacific salmon could potentially access all the streams included (presuming all else is equal and adequate flow is present in the stream).

column

description

segmented_stream_id

Unique bcfishpass streams table identifier

linear_feature_id

From BC FWA,the unique identifier for a stream segment (flow network arc)

edge_type

A 4 digit numeric code used by the Freshwater Atlas to identify the various types of water network linear features. eg. 1050.

blue_line_key

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)

downstream_route_measure

The distance, in meters, along the blue_line_key from the mouth of the stream/blue_line_key to the feature

upstream_route_measure

The distance, in meters, along the blue_line_key from the mouth of the stream/blue_line_key to the upstream end of the feature

watershed_group_code

The watershed group code associated with the feature

gnis_name

The BCGNIS (BC Geographical Names Information System) name associated with the GNIS feature id (an English name was used where available, otherwise another language was selected)

stream_order

The calculated modified Strahler order

stream_magnitude

The calculated magnitude

gradient

Slope of the feature (percent)

wscode

A truncated version of the BC FWA fwa_watershed_code (trailing zeros removed and ‘-’ replaced with ‘.’

localcode

A truncated version of the BC FWA local_watershed_code (trailing zeros removed and ‘-’ replaced with ‘.’

feature_code

A value based on the Canadian Council of Surveys and Mapping’s (CCSM) system for classification of geographic features.

obsrvtn_upstr_salmon

True if known salmon observations are present upstream

barriers_anthropogenic_dnstr

IDs of anthropogenic barriers downstream

barriers_pscis_dnstr

IDs of assessed PSCIS barriers downstream

barriers_dams_dnstr

IDs of CABD dams downstream noted as barriers

dam_dnstr_ind

Indicates if a dam is the first barrier downstream of the stream

dam_hydro_dnstr_ind

Indicates if a hydro dam is the first barrier downstream of the stream

remediated_dnstr_ind

Indicates if a remediation is present downstream of the stream and before any additional barriers

geom

The point geometry associated with the feature

model_access_steelhead

All FWA stream downstream of points included in barriers_steelhead. In the absence of anthropogenic barriers, steelhead could potentially access all the streams included (presuming all else is equal and adequate flow is present in the stream).

column

description

segmented_stream_id

Unique bcfishpass streams table identifier

linear_feature_id

From BC FWA,the unique identifier for a stream segment (flow network arc)

edge_type

A 4 digit numeric code used by the Freshwater Atlas to identify the various types of water network linear features. eg. 1050.

blue_line_key

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)

downstream_route_measure

The distance, in meters, along the blue_line_key from the mouth of the stream/blue_line_key to the feature

upstream_route_measure

The distance, in meters, along the blue_line_key from the mouth of the stream/blue_line_key to the upstream end of the feature

watershed_group_code

The watershed group code associated with the feature

gnis_name

The BCGNIS (BC Geographical Names Information System) name associated with the GNIS feature id (an English name was used where available, otherwise another language was selected)

stream_order

The calculated modified Strahler order

stream_magnitude

The calculated magnitude

gradient

Slope of the feature (percent)

wscode

A truncated version of the BC FWA fwa_watershed_code (trailing zeros removed and ‘-’ replaced with ‘.’

localcode

A truncated version of the BC FWA local_watershed_code (trailing zeros removed and ‘-’ replaced with ‘.’

feature_code

A value based on the Canadian Council of Surveys and Mapping’s (CCSM) system for classification of geographic features.

obsrvtn_upstr_st

True if known steelhead observations are present upstream

barriers_anthropogenic_dnstr

IDs of anthropogenic barriers downstream

barriers_pscis_dnstr

IDs of assessed PSCIS barriers downstream

barriers_dams_dnstr

IDs of CABD dams downstream noted as barriers

dam_dnstr_ind

Indicates if a dam is the first barrier downstream of the stream

dam_hydro_dnstr_ind

Indicates if a hydro dam is the first barrier downstream of the stream

remediated_dnstr_ind

Indicates if a remediation is present downstream of the stream and before any additional barriers

geom

The point geometry associated with the feature

model_access

FWA streams and access model output for watersheds with documented salmon or steelhead presence. Access model output columns model_access_salmon and model_access_steelhead indicate the modelled status of a given stream. Values are:

OBSERVED - no known natural barriers downstream, known observation of target species present upstream. In the absence of anthropogenic barriers, target species have been observed to access this stream.

INFERRED - no known natural barriers downstream, no known observation of target species present upstream. In the absence of anthropogenic barriers, target species could potentially access this stream (presuming all else is equal and adequate flow is present in the stream).

NATURAL_BARRIER - natural barrier downstream, inaccessible to target speces.

NULL - species is not documented as present in this watershed group.

column

description

segmented_stream_id

Unique bcfishpass streams table identifier

linear_feature_id

From BC FWA,the unique identifier for a stream segment (flow network arc)

edge_type

A 4 digit numeric code used by the Freshwater Atlas to identify the various types of water network linear features. eg. 1050.

blue_line_key

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)

downstream_route_measure

The distance, in meters, along the blue_line_key from the mouth of the stream/blue_line_key to the feature

upstream_route_measure

The distance, in meters, along the blue_line_key from the mouth of the stream/blue_line_key to the upstream end of the feature

watershed_group_code

The watershed group code associated with the feature

gnis_name

The BCGNIS (BC Geographical Names Information System) name associated with the GNIS feature id (an English name was used where available, otherwise another language was selected)

stream_order

The calculated modified Strahler order

stream_magnitude

The calculated magnitude

gradient

Slope of the feature (percent)

wscode

A truncated version of the BC FWA fwa_watershed_code (trailing zeros removed and ‘-’ replaced with ‘.’

localcode

A truncated version of the BC FWA local_watershed_code (trailing zeros removed and ‘-’ replaced with ‘.’

feature_code

A value based on the Canadian Council of Surveys and Mapping’s (CCSM) system for classification of geographic features.

model_access_salmon

Salmon access model result code. Values are ‘OBSERVED’; ‘INFERRED’; ‘NATURAL_BARRIER’. NULL indicates species is not documented as present in watershed group

model_access_steelhead

Steelhead access model result code. Values are ‘OBSERVED’; ‘INFERRED’; ‘NATURAL_BARRIER’. NULL indicates species is not documented as present in watershed group

barriers_ch_cm_co_pk_sk_dnstr

IDs of downstream natural barriers to salmon (see barriers_salmon table)

barriers_st_dnstr

IDs of downstream natural barriers to steelhead (see barriers_steelhead table)

barriers_anthropogenic_dnstr

IDs of anthropogenic barriers downstream

barriers_pscis_dnstr

IDs of assessed PSCIS barriers downstream

barriers_dams_dnstr

IDs of CABD dams downstream noted as barriers

dam_dnstr_ind

Indicates if a dam is the first barrier downstream of the stream

dam_hydro_dnstr_ind

Indicates if a hydro dam is the first barrier downstream of the stream

remediated_dnstr_ind

Indicates if a remediation is present downstream of the stream and before any additional barriers

geom

The point geometry associated with the feature

observations

Locations (on the FWA stream network) of known salmon and steelhead observations used to generate the modelling. Derived from Known BC Fish Observations by bcfishobs.

column

description

fish_observation_point_id

Source unique identifier (note that this id is unstable and cannot be consistently linked back to source dataset)

fish_obsrvtn_event_id

Unique identifier generated by bcfishobs, based on point location on FWA stream (blue_line_key and downstream_route_measure)

species_code

Code corresponding to the species observed, see https://github.com/poissonconsulting/fishbc/blob/master/data-raw/whse_fish_species_cd/whse_fish_species_cd.csv for species descriptions

observation_date

The date on which the observation occurred

activity_code

The fish activity code from the source dataset, such as I for Incubating, or SPE for Spawning In Estuary

activity

A full textual description of the activity the fish was engaged in when it was observed, such as SPAWNING

life_stage_code

Life stage of the fish species for this oberservation. Each source dataset of observations uses its own set of LIFE STAGE CODES. For example, in the FDIS dataset, U means Undetermined, NS means Not Specified, M means Mature, IM means Immature, and MT means Maturing. Descriptions for each life_stage_code are given in the life_stage attribute

life_stage

Description corresponding to the life_stage_code

acat_report_url

URL to the ACAT REPORT which provides additional information about the observation

linear_feature_id

From BC FWA,the unique identifier for a stream segment (flow network arc)

blue_line_key

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)

downstream_route_measure

The distance, in meters, along the blue_line_key from the mouth of the stream/blue_line_key to the feature

wscode

A truncated version of the BC FWA fwa_watershed_code (trailing zeros removed and ‘-’ replaced with ‘.’

localcode

A truncated version of the BC FWA local_watershed_code (trailing zeros removed and ‘-’ replaced with ‘.’

watershed_group_code

The watershed group code associated with the feature

geom

The point geometry associated with the feature