PSCIS Assessments

535 views (8 recent)

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

Points where a fish passage assessment has been performed on a stream crossing structure. These includes culverts, bridges, fords, etc. The assessments are carried out to determine whether fish are able to migrate through the structure.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

The Provincial Stream Crossing Information System (PSCIS) is the provinicial repository for all culvert fish passage data. The PSCIS Assessment layer shows all points where an assessment has been completed on a crossing structure. The purpose of this layer is show the fish passage status (passable, potential barrier, barrier) of all assessed sites so that remediation efforts can be targeted at the sites which will regain the most valuable fish habitat. As the central repository, the layer will also show where work has already been done and allow future assessment works to be directed accordingly.

Contact Information

NameCraig Mount (pointOfContact)
EmailCraig.Mount@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationKnowledge Management
NameRichard Thompson (pointOfContact)
EmailRichard.Thompson@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationEcosystems
NameRobin Munro (pointOfContact)
EmailRobin.Munro@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationKnowledge Management

Access & Security

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

Metadata Information

Record Published 2013-04-15
Record Last Modified 2019-09-05
Resource Status onGoing

Object Description

Object Name: WHSE_FISH.PSCIS_ASSESSMENT_SVW

Short Name: PSCIS_ASSM
Comments: This view defines the most current assessment for a stream crossing location. An assessment provides the field survey data required to determine whether a stream crossing requires remediation efforts in order to make it passable to fish habitat.

Column Name Short Name Data Type Data Precision Comments
FUNDING_PROJECT_NUMBER FNDNGPRJCT VARCHAR2 255 The ASSMT FUNDING PROJECT NUMBER is the identifier for the project and is usually related to the funding source. For example, '9172001b' is the FUNDING PROJECT NUMBER associated with the project who's name is 'Fish Passage Culvert Inspections 2009, Kootenay Lake Forest District, Kootenay Lake TSA'.
FUNDING_PROJECT FNDNG_PRJT VARCHAR2 255 The FUNDING PROJECT is the identifier for the project and is usually related to the funding source. (e.g. 'Fish Passage Culvert Inspections 2009, Kootenay Lake Forest District, Kootenay Lake TSA')
PROJECT_ID PROJECT_ID NUMBER 10 The PROJECT ID is the system identifier for the project; this value is generated within PSCIS.
FUNDING_SOURCE FNDNG_SRCE VARCHAR2 10 FUNDING SOURCE defines the source of funding for the associated project. Eg. FIA
RESPONSIBLE_PARTY_NAME AS_RSP_NME VARCHAR2 255 The RESPONSIBLE PARTY NAME is the name of the provided responsible party.
CONSULTANT_NAME CNSLTNT_NM VARCHAR2 255 The CONSULTANT NAME is the name of the provided consultant.
ASSESSMENT_DATE ASSSSMNT_E DATE 7 The ASSESSMENT DATE is the date when the assessment was completed.
STREAM_CROSSING_ID STR_X_ID NUMBER 10 The STREAM CROSSING ID is the unique identifier for the STREAM CROSSING LOCATION POINT.
ASSESSMENT_ID ASSSSMN_ID NUMBER 10 The ASSESSMENT_ID is the unique identifier for the latest crossing assessment.
EXTERNAL_CROSSING_REFERENCE EXTRNL_CRE VARCHAR2 50 The EXTERNAL CROSSING REFERENCE identifies the submitters name used to reference a stream crossing.
CREW_MEMBERS CRW_MMBRS VARCHAR2 255 CREW MEMEBERS are the initials of the crew members taking measurements usually delimited by commas.
UTM_ZONE UTM_ZONE NUMBER 2 UTM ZONE is a segment of the Earth's 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 TMSTNG NUMBER 13 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 TMNRTHNG NUMBER 13 UTM NORTHING is the distance in meters northward from the equator. e.g., 6197826
LOCATION_CONFIDENCE_IND LCTNCNFDNC VARCHAR2 1 The LOCATION CONFIDENCE IND may indicate if this spatial point is a duplicate. Allowable values are 'Y' and 'N'
STREAM_NAME STR_NAME VARCHAR2 256 The STREAM NAME is the mapped stream name. If no name is given for the watercourse, then the parent tributary name is used (i.e. Tributary to Bear Creek)
ROAD_NAME RD_NAME VARCHAR2 256 The ROAD NAME is the name of the road at the crossing, usually a forest road.
ROAD_KM_MARK RD_KM_MK NUMBER 10 The ROAD KM MARK is the road kilometre position of the crossing to the nearest 0.01 km, matching the kilometre markers, if present.
ROAD_TENURE RD_TENURE VARCHAR2 50 The ROAD TENURE is the best available ID for the road at the time of assessment. For example, the Forest File Id of a Road Permit or Forest Service Road.
CROSSING_TYPE_CODE CRSSNG_TYD VARCHAR2 24 The CROSSING TYPE CODE is the code value defining the type of crossing present at the location of the stream crossing at the time of the assessment. Acceptable types are:OBS = Open Bottom StructureCBS = Closed Bottom StructureOTHER = Crossing structure does not fit into the above categories. Eg: ford, wier
CROSSING_TYPE_DESC CRSSNG_TYC VARCHAR2 120 CROSSING TYPE DESC describes the CROSSING TYPE CODE.
CROSSING_SUBTYPE_CODE CRSSNG_SBD VARCHAR2 24 The CROSSING SUBTYPE CODE further defines the value provided with the ASSMT CROSSING TYPE CODE. Valid subtypes depend on CROSSING TYPE CODE. Acceptable values are BRIDGE, PIPE ARCH, WOOD BOX CULVERT, ROUND CULVERT, OVAL CULVERT.
CROSSING_SUBTYPE_DESC CRSSNG_SBC VARCHAR2 120 CROSSING SUBTYPE DESC describes the CROSSING SUBTYPE CODE.
DIAMETER_OR_SPAN DMTR_R_SPN NUMBER 12 The DIAMETER OR SPAN is the measured structure diameter in metres, to the nearest 0.01m if it is a culvert. If it is an open bottomed structure, record a span value in metres to the nearest 0.01m.
LENGTH_OR_WIDTH AS_LEN_WTH NUMBER 12 The LENGTH OR WIDTH is the length of the structure in metres, to the nearest 0.01m if it is a culvert. If it is a closed bottom structure enter a width value in metres, to the nearest 0.01m.
CONTINUOUS_EMBEDDEDMENT_IND CNTNS_MBDD VARCHAR2 1 The CONTINUOUS EMBEDDEDMENT IND is an indicator value identifying if the culvert is continuously buried in the stream substrate throughout its entire length. Acceptable values are 'Y' and 'N'.
AVERAGE_DEPTH_EMBEDEDDMENT AVRG_DPTHT NUMBER 4 The AVERAGE DEPTH EMBEDDEDMENT identifies the approximate average depth of the substrate within the culvert (Metres, to the nearest 0.01m)
RESEMBLE_CHANNEL_IND RSBLE_CH VARCHAR2 1 The RESEMBLE CHANEL IND is an indicator value identifying if the bed of the culvert resembles the native streambed. Acceptable values are 'Y' and 'N'.
BACKWATERED_IND BCKWTRD_ND VARCHAR2 1 The BACKWATERED IND is an indicator value identifying if the culvert is backwatered. Acceptable values are 'Y' and 'N'. Backwatering refers to the damming of water as a result of a downstream control (weir or debris jam).
PERCENTAGE_BACKWATERED PCNT_BKWTD NUMBER 5 The PERCENTAGE BACKWATERED is the percentage of total culvert length that the outlet pool fills back into the culvert.
FILL_DEPTH FILL_DEPTH NUMBER 5 The FILL DEPTH is the avereage depth of fill over culvert in metres (to the nearest 0.01m)
OUTLET_DROP OTLT_DRP NUMBER 4 The OUTLET DROP value is a sum of two measures (metres , to nearest 0.01m) 1. The distance between the culvert invert and the top of the residual pool. 2. The height of the outlet control (The height of the top of the residual pool to the bottom of the outlet control)
OUTLET_POOL_DEPTH OTLT_PL_DP NUMBER 4 The OUTLET POOL DEPTH describes the residual pool depth in metres (To the nearest 0.01m). Subtrat water depth at the outlet control from the water depth of the pool downstream of the crossing.
INLET_DROP_IND IN_DRP_IND VARCHAR2 1 The INLET DROP IND is an indicator value identifying if there is a drop between the streambed elevation and the invert of the culvert at the inlet. Acceptable values are 'Y' and 'N'.
CULVERT_SLOPE CLVRT_SLPE NUMBER 4 The CULVERT SLOPE is the slope of the culvert. Looking upstream in the culvert, culvert slope is estimated by using a clinometer. If the inital culvert slope is 4% or greater, the estimated slope is recorded (as a percentage value). If the initial reading is less than 4%, the slop is measured using a more precise instrument such as a level.
DOWNSTREAM_CHANNEL_WIDTH DWNSTRM_CH NUMBER 4 The DOWNSTREAM CHANNEL WIDTH describes the channel width in metres (to the nearest 0.01m). Channel width is the horizontal distance between the opposite stream banks, measured at right angles to the general orientation of the banks.
STREAM_SLOPE STR_SLOPE NUMBER 5 The STREAM SLOPE describes the slope of a section of stream either upstream or downstream of the culvert, measured using a clinometer. If the stream is at the confluence of the lake, wetland, or larger river, the slope of a section of an upstream section beyond the influence of the road right-of-way is measured.
BEAVER_ACTIVITY_IND BVR_CTVTYD VARCHAR2 1 The BEAVER ACTIVITY IND indicates evidence of beaver activity. This is a maintenance issue and may influence restoration options. Allowable values are 'Y' and 'N'
FISH_OBSERVED_IND FSH_BSRVDD VARCHAR2 1 The FISH OBSERVED IND identifies if fish have been observed at the crossing. Allowable values are 'Y' and 'N'
VALLEY_FILL_CODE VLY_FIL_C VARCHAR2 2 The VALLEY FILL CODE is a code value indicating the depth of the fill on stream. Acceptable values are:DF - Deep Fill - No or little bedrock showing on stream.SF- Shallow Fill - Bedrock occasionally shows on stream.BR - Bedrock - A large area of the bedrock is evident on stream.
VALLEY_FILL_CODE_DESC VLY_FIL_D VARCHAR2 120 VALLEY FILL CODE DESC describes the VALLEY FILL CODE.
HABITAT_VALUE_CODE HBTT_VL_CD VARCHAR2 10 The HABITAT VALUE CODE is a code value describing the evaluated habitat at a crossing site. Particular emphasis is on habitat upstream of the CBS as this is the habitat that will be gained when fish passage is restored. Acceptable values are HIGH, MEDIUM and LOW.
HABITAT_VALUE_DESC AS_HB_VL_D VARCHAR2 120 HABITAT VALUE DESC describes the usage of the HABITAT VALUE CODE.
STREAM_WIDTH_RATIO STR_WT_RT NUMBER 6 The STREAM WIDTH RATIO is the value derived by dividing the DOWNSTREAM CHANNEL WIDTH by the culvert diameter.
STREAM_WIDTH_RATIO_SCORE ST_W_RT_SC NUMBER 2 The STREAM WIDTH RATIO SCORE defines the Fish Barrier Scoring value for the stream width ratio.<1.0 = 0>=1.0 & <1.3 = 3>=1.3 = 6
CULVERT_LENGTH_SCORE CLVRT_LNGE NUMBER 2 The CULVERT LENGTH SCORE defines the Fish Barrier Scoring value for the length of the culvert.<15m = 0>=15m & <30m = 3>=30m = 6
EMBED_SCORE EMBD_SCRE NUMBER 2 The EMBED SCORE defines the Fish Barrier Scoring value for the level of stream embededment. The value is defined by the Average Depth Embeddedment / Culvert Diameter, or just the Average Depth Embeddedment.A value of 0 where Average Depth Embeddedment / Culvert Diameter >= 0.2, or Average Depth Embeddedment >= 0.3mA value of 5 where Average Depth Embeddedment / Culvert Diameter < 0.2, or Average Depth Embeddedment < 0.3mA value of 10 where CONTINUOUS EMBEDDEDMENT IND = 'N'
OUTLET_DROP_SCORE OTLT_DRP_S NUMBER 2 The OUTLET DROP SCORE defines the Fish Barrier Scoring value for the outlet drop.< 0.15m = 0>=0.15m & <0.3m = 5>=0.3m = 10
CULVERT_SLOPE_SCORE CLVRT_SLPE NUMBER 2 The CULVERT SLOPE SCORE defines the Fish Barrier Scoring value for the culvert slope.<1% = 0>=1% & <3% = 5>=3% = 10
FINAL_SCORE FNL_SCRE NUMBER 2 The FINAL SCORE describes the final accumulated Fish Barrier Score. It is the sum of the other score values, CULVERT LENGTH SCORE, EMBED SCORE, OUTLET DROP SCORE, CULVERT SLOPE SCORE, STREAM WIDTH RATIO SCORE.
BARRIER_RESULT_CODE BRRR_RSLTD VARCHAR2 10 The BARRIER RESULT CODE is the evaluation of the crossing as a barrier to the fish passage, based on the FINAL SCORE value. Acceptable Values are:PASSABLE - PassablePOTENTIAL - Potential BarrierBARRIER - BarrierUNKOWN - Other
BARRIER_RESULT_DESCRIPTION BRRR_RSLTN VARCHAR2 120 BARRIER RESULT DESCRIPTION describes the usage of BARRIER RESULT CODE.
CROSSING_FIX_CODE CRSSNG_FXD VARCHAR2 10 The CROSSING FIX CODE defines the allowable culvert fix options. Acceptable values are:RM - RemovalOBS - Open Bottom StructureSS - Streambed SimulationEM - Additional substrate material and/or downstream weirsBW - Backwater.
CROSSING_FIX_DESC CRSSNG_FXC VARCHAR2 120 CROSSING FIX DESC describes the CROSSING FIX CODE.
RECOMMENDED_DIAMETER_OR_SPAN RC_DIA_SPN NUMBER 10 The RECOMMENDED DIAMETER OR SPAN is the approximate length (streambed simulation) or span (bridge) of the proposed replacement structure. The value is provided in meters.
ASSESSMENT_COMMENT ASSSSMNT_T VARCHAR2 4000 The ASSESSMENT COMMENT is an additional note or details about a crossing assessment.
ECOCAT_URL ECOCAT_URL VARCHAR2 200 A URL pointing at Ecocat for the related project.
IMAGE_VIEW_URL IMG_VW_URL VARCHAR2 200 A URL pointing at an HTML display of the attachments.
CURRENT_PSCIS_STATUS CRRNT_PSCS VARCHAR2 25 CURRENT PSCIS STATUS defines the current status of the crossing as either assessed, designed, or remediated. Defines the current status of the crossing as either assessed, designed, or remediated.
CURRENT_CROSSING_TYPE_CODE CRRNT_CRSD VARCHAR2 24 The CURRENT CROSSING TYPE CODE is the code value defining the type of crossing present at the location of the stream crossing. Acceptable types are:OBS = Open Bottom StructureCBS = Closed Bottom StructureOTHER = Crossing structure does not fit into the above categories. Eg: ford, wier
CURRENT_CROSSING_TYPE_DESC CRRNT_CRSC VARCHAR2 120 CURRENT CROSSING TYPE DESC describes the CURRENT CROSSING TYPE.
CURRENT_CROSSING_SUBTYPE_CODE CRRNT_CRSD VARCHAR2 24 The CURRENT CROSSING SUBTYPE CODE further defines the value provided with the CURRENT CROSSING TYPE CODE. Valid subtypes depend on CURRENT CROSSING TYPE CODE. Acceptable values are BRIDGE, PIPE ARCH, WOOD BOX CULVERT, ROUND CULVERT, OVAL CULVERT.
CURRENT_CROSSING_SUBTYPE_DESC CRRNT_CRSC VARCHAR2 120 CURRENT CROSSING SUBTYPE DESC describes the CUURENT CROSSING SUBTYPE.
CURRENT_BARRIER_RESULT_CODE CRRNT_BRRD VARCHAR2 10 The CURRENT BARRIER RESULT CODE is the current evaluation of the crossing as a barrier to the fish passage, based on the FINAL SCORE value. Acceptable Values are: PASSABLE - Passable POTENTIAL - Potential Barrier BARRIER - Barrier UNKOWN - Other.
CURRENT_BARRIER_DESCRIPTION CRRNT_BRRN VARCHAR2 120 CURRENT BARRIER DESCRIPTION describes the usage of the CURRENT BARRIER RESULT CODE.
FEATURE_CODE FEATURE_CD VARCHAR2 10 A feature code defines the standards for a spatial feature and is often used for defining cartography standards.
GEOMETRY GEOMETRY SDO_GEOMETRY 64 The GEOMETRY is the spatial location of the STREAM CROSSING LOCATION.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a column required by spatial layers that interact with ESRI ArcSDE. It is populated with unique values automatically by SDE.
SE_ANNO_CAD_DATA BLOB 4000 SE_ANNO_CAD_DATA is a binary column used by spatial tools to store annotation, curve features and CAD data when using the SDO_GEOMETRY storage data type.