Data Distribution

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://nrs.objectstore.gov.bc.ca/bchamp/freshwater_fish_habitat_accessibility_MODEL.gpkg.zip.

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

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 line 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