bcfishpass via pg-featureserv pg_featureserv - Version 1.3
Home / Collections / bcfishpass.crossings_vw JSON

Feature Collection: bcfishpass.crossings_vw

Data for table bcfishpass.crossings_vw

Items: View JSON

Metadata

ID column
Geometry columngeom
Geometry typePointZM
SRID3005
Extent Lon/Lat Min: -137.84196740286458, 47.703346351200096 Max: -110.51980714601422, 59.93613186950755
Properties
NameTypeDescription
aggregated_crossings_id string unique identifier for crossing, generated from stream_crossing_id, modelled_crossing_id + 1000000000, user_barrier_anthropogenic_id + 1200000000, cabd_id
stream_crossing_id number PSCIS stream crossing unique identifier
dam_id string BC Dams unique identifier
user_barrier_anthropogenic_id number User added misc anthropogenic barriers unique identifier
modelled_crossing_id number Modelled crossing unique identifier
crossing_source string Data source for the crossing, one of: {PSCIS,MODELLED CROSSINGS,CABD,MISC BARRIERS}
crossing_feature_type string
pscis_status string From PSCIS, the current_pscis_status of the crossing, one of: {ASSESSED,HABITAT CONFIRMATION,DESIGN,REMEDIATED}
crossing_type_code string 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 string Further definition of the type of crossing, one of {BRIDGE,CRTBOX,DAM,FORD,OVAL,PIPEARCH,ROUND,WEIR,WOODBOX,NULL}
modelled_crossing_type_source string 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}
modelled_crossing_office_review_date string Date of most recent office review (satellite imagery, etc) at site of modelled crossing. NULL if crossing has not been reviewed
barrier_status string 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 string PSCIS road name, taken from the PSCIS assessment data submission
pscis_stream_name string PSCIS stream name, taken from the PSCIS assessment data submission
pscis_assessment_comment string PSCIS assessment_comment, taken from the PSCIS assessment data submission
pscis_assessment_date string PSCIS assessment_date, taken from the PSCIS assessment data submission
pscis_final_score number PSCIS final_score, taken from the PSCIS assessment data submission
transport_line_structured_name_1 string DRA road name, taken from the nearest DRA road (within 30m)
transport_line_type_description string DRA road type, taken from the nearest DRA road (within 30m)
transport_line_surface_description string DRA road surface, taken from the nearest DRA road (within 30m)
ften_forest_file_id string FTEN road forest_file_id value, taken from the nearest FTEN road (within 30m)
ften_road_section_id string FTEN road road_section_id value, taken from the nearest FTEN road (within 30m)
ften_file_type_description string FTEN road tenure type (Forest Service Road, Road Permit, etc), taken from the nearest FTEN road (within 30m)
ften_client_number string FTEN road client number, taken from the nearest FTEN road (within 30m)
ften_client_name string FTEN road client name, taken from the nearest FTEN road (within 30m)
ften_life_cycle_status_code string FTEN road life_cycle_status_code (active or retired, pending roads are not included), taken from the nearest FTEN road (within 30m)
ften_map_label string FTEN road map_label value, taken from the nearest FTEN road (within 30m)
rail_track_name string Railway name, taken from nearest railway (within 25m)
rail_owner_name string Railway owner name, taken from nearest railway (within 25m)
rail_operator_english_name string Railway operator name, taken from nearest railway (within 25m)
ogc_proponent string OGC road tenure proponent (currently modelled crossings only, taken from OGC road that crosses the stream)
dam_name string See CABD dams column: dam_name_en
dam_height number See CABD dams column: dam_height
dam_owner string See CABD dams column: owner
dam_use string See CABD table dam_use_codes
dam_operating_status string See CABD dams column dam_operating_status
utm_zone number 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 number 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 number UTM NORTHING is the distance in meters northward from the equator. e.g., 6197826
dbm_mof_50k_grid string
linear_feature_id number From BC FWA, the unique identifier for a stream segment (flow network arc)
blue_line_key number 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 number 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 number The distance, in meters, along the blue_line_key from the mouth of the stream/blue_line_key to the feature.
wscode string A truncated version of the BC FWA fwa_watershed_code (trailing zeros removed and "-" replaced with ".", stored as postgres type ltree for fast tree based queries
localcode string A truncated version of the BC FWA local_watershed_code (trailing zeros removed and "-" replaced with ".", stored as postgres type ltree for fast tree based queries
watershed_group_code string The watershed group code associated with the feature.
gnis_stream_name string The BCGNIS (BC Geographical Names Information System) name associated with the FWA stream
stream_order number Order of FWA stream at point
stream_magnitude number Magnitude of FWA stream at point
upstream_area_ha number
stream_order_parent number
stream_order_max number
map_upstream number
channel_width number
mad_m3s number
observedspp_dnstr string
observedspp_upstr string
crossings_dnstr string
barriers_anthropogenic_dnstr string
barriers_anthropogenic_dnstr_count number
barriers_anthropogenic_upstr string
barriers_anthropogenic_upstr_count number
barriers_anthropogenic_bt_upstr string
barriers_anthropogenic_upstr_bt_count number
barriers_anthropogenic_ch_cm_co_pk_sk_upstr string
barriers_anthropogenic_ch_cm_co_pk_sk_upstr_count number
barriers_anthropogenic_st_upstr string
barriers_anthropogenic_st_upstr_count number
barriers_anthropogenic_wct_upstr string
barriers_anthropogenic_wct_upstr_count number
gradient number
total_network_km number
total_stream_km number
total_lakereservoir_ha number
total_wetland_ha number
total_slopeclass03_waterbodies_km number
total_slopeclass03_km number
total_slopeclass05_km number
total_slopeclass08_km number
total_slopeclass15_km number
total_slopeclass22_km number
total_slopeclass30_km number
total_belowupstrbarriers_network_km number
total_belowupstrbarriers_stream_km number
total_belowupstrbarriers_lakereservoir_ha number
total_belowupstrbarriers_wetland_ha number
total_belowupstrbarriers_slopeclass03_waterbodies_km number
total_belowupstrbarriers_slopeclass03_km number
total_belowupstrbarriers_slopeclass05_km number
total_belowupstrbarriers_slopeclass08_km number
total_belowupstrbarriers_slopeclass15_km number
total_belowupstrbarriers_slopeclass22_km number
total_belowupstrbarriers_slopeclass30_km number
barriers_bt_dnstr string
bt_network_km number
bt_stream_km number
bt_lakereservoir_ha number
bt_wetland_ha number
bt_slopeclass03_waterbodies_km number
bt_slopeclass03_km number
bt_slopeclass05_km number
bt_slopeclass08_km number
bt_slopeclass15_km number
bt_slopeclass22_km number
bt_slopeclass30_km number
bt_belowupstrbarriers_network_km number
bt_belowupstrbarriers_stream_km number
bt_belowupstrbarriers_lakereservoir_ha number
bt_belowupstrbarriers_wetland_ha number
bt_belowupstrbarriers_slopeclass03_waterbodies_km number
bt_belowupstrbarriers_slopeclass03_km number
bt_belowupstrbarriers_slopeclass05_km number
bt_belowupstrbarriers_slopeclass08_km number
bt_belowupstrbarriers_slopeclass15_km number
bt_belowupstrbarriers_slopeclass22_km number
bt_belowupstrbarriers_slopeclass30_km number
barriers_ch_cm_co_pk_sk_dnstr string
ch_cm_co_pk_sk_network_km number
ch_cm_co_pk_sk_stream_km number
ch_cm_co_pk_sk_lakereservoir_ha number
ch_cm_co_pk_sk_wetland_ha number
ch_cm_co_pk_sk_slopeclass03_waterbodies_km number
ch_cm_co_pk_sk_slopeclass03_km number
ch_cm_co_pk_sk_slopeclass05_km number
ch_cm_co_pk_sk_slopeclass08_km number
ch_cm_co_pk_sk_slopeclass15_km number
ch_cm_co_pk_sk_slopeclass22_km number
ch_cm_co_pk_sk_slopeclass30_km number
ch_cm_co_pk_sk_belowupstrbarriers_network_km number
ch_cm_co_pk_sk_belowupstrbarriers_stream_km number
ch_cm_co_pk_sk_belowupstrbarriers_lakereservoir_ha number
ch_cm_co_pk_sk_belowupstrbarriers_wetland_ha number
ch_cm_co_pk_sk_belowupstrbarriers_slopeclass03_waterbodies_km number
ch_cm_co_pk_sk_belowupstrbarriers_slopeclass03_km number
ch_cm_co_pk_sk_belowupstrbarriers_slopeclass05_km number
ch_cm_co_pk_sk_belowupstrbarriers_slopeclass08_km number
ch_cm_co_pk_sk_belowupstrbarriers_slopeclass15_km number
ch_cm_co_pk_sk_belowupstrbarriers_slopeclass22_km number
ch_cm_co_pk_sk_belowupstrbarriers_slopeclass30_km number
barriers_st_dnstr string
st_network_km number
st_stream_km number
st_lakereservoir_ha number
st_wetland_ha number
st_slopeclass03_waterbodies_km number
st_slopeclass03_km number
st_slopeclass05_km number
st_slopeclass08_km number
st_slopeclass15_km number
st_slopeclass22_km number
st_slopeclass30_km number
st_belowupstrbarriers_network_km number
st_belowupstrbarriers_stream_km number
st_belowupstrbarriers_lakereservoir_ha number
st_belowupstrbarriers_wetland_ha number
st_belowupstrbarriers_slopeclass03_waterbodies_km number
st_belowupstrbarriers_slopeclass03_km number
st_belowupstrbarriers_slopeclass05_km number
st_belowupstrbarriers_slopeclass08_km number
st_belowupstrbarriers_slopeclass15_km number
st_belowupstrbarriers_slopeclass22_km number
st_belowupstrbarriers_slopeclass30_km number
barriers_wct_dnstr string
wct_network_km number
wct_stream_km number
wct_lakereservoir_ha number
wct_wetland_ha number
wct_slopeclass03_waterbodies_km number
wct_slopeclass03_km number
wct_slopeclass05_km number
wct_slopeclass08_km number
wct_slopeclass15_km number
wct_slopeclass22_km number
wct_slopeclass30_km number
wct_belowupstrbarriers_network_km number
wct_belowupstrbarriers_stream_km number
wct_belowupstrbarriers_lakereservoir_ha number
wct_belowupstrbarriers_wetland_ha number
wct_belowupstrbarriers_slopeclass03_waterbodies_km number
wct_belowupstrbarriers_slopeclass03_km number
wct_belowupstrbarriers_slopeclass05_km number
wct_belowupstrbarriers_slopeclass08_km number
wct_belowupstrbarriers_slopeclass15_km number
wct_belowupstrbarriers_slopeclass22_km number
wct_belowupstrbarriers_slopeclass30_km number
bt_spawning_km number
bt_rearing_km number
bt_spawning_belowupstrbarriers_km number
bt_rearing_belowupstrbarriers_km number
ch_spawning_km number
ch_rearing_km number
ch_spawning_belowupstrbarriers_km number
ch_rearing_belowupstrbarriers_km number
cm_spawning_km number
cm_spawning_belowupstrbarriers_km number
co_spawning_km number
co_rearing_km number
co_rearing_ha number
co_spawning_belowupstrbarriers_km number
co_rearing_belowupstrbarriers_km number
co_rearing_belowupstrbarriers_ha number
pk_spawning_km number
pk_spawning_belowupstrbarriers_km number
sk_spawning_km number
sk_rearing_km number
sk_rearing_ha number
sk_spawning_belowupstrbarriers_km number
sk_rearing_belowupstrbarriers_km number
sk_rearing_belowupstrbarriers_ha number
st_spawning_km number
st_rearing_km number
st_spawning_belowupstrbarriers_km number
st_rearing_belowupstrbarriers_km number
wct_spawning_km number
wct_rearing_km number
wct_spawning_belowupstrbarriers_km number
wct_rearing_belowupstrbarriers_km number