PSCIS Habitat Confirmations

265 views (5 recent)

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

Points where an evaluation of the fish habitat up and downstream of a road crossing have been carried out. Phase 2 of 4 in the Fish Passage Workflow, Habitat Confirmations are done at sites where the crossing structure is known to be a failure. The Habitat Confirmation is performed to ensure that the site in question is a good candidate for moving on to the Design (Phase 3) and Remediation (Phase 4) stages of the workflow. The Habitat Confirmation confirms the crossing is a barrier, places the crossing in context with respect to other roads and crossings in the watershed and also quantifies and qualifies how much habitat will be gained if the site is fixed.

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 Habitat Confirmations layer shows all locations where a Habitat Confirmation has been performed on the stream network associated with a crossing structure. The purpose of this layer is provide the results of each Habitat Confirmation survey so that further Design (Phase 3) and Remediation (Phase 4) efforts can be targeted at the sites which will regain the most valuable fish habitat. As the central repository for PSCIS-related habitat data, the layer will also show where work has already been done and allow future Habitat Confirmation works to be directed accordingly.

Lineage Statement

Reports are submitted by contractors who have gone in the field, confirmed the crossing is a barrier and if so, walked the stream both up and downstream of the crossing site to evaluate the quality and quantity of fish habitat. The protocol also requires the contractor to perform a background data search on the site to establish relevant information about both the road and stream networks. This would include information on road status and ownership as well as fish species utilization of the aquatic system. The reports linked to these datapoints present their findings.

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_HABITAT_CONFIRMATION_SVW

Short Name: PSCIS_HAB
Comments: PSCIS_HABITAT_CONFIRMATION_SVW represents Habitat Confirmation of Stream Crossings. The Habitat Confirmation is carried out by a biologist who does an office and field review of the fish habitat to be potentially gained by remediation of an identified failed road crossing.

Column Name Short Name Data Type Data Precision Comments
ASSMT_FUNDING_PROJECT_NUMBER FNDPRJ_NM 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'.
ASSMT_FUNDING_PROJECT FNDPRJ VARCHAR2 255 The ASSMT 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')
ASSMT_PROJECT_ID ASMT_PRJID NUMBER 10 The ASSMT PROJECT ID is the system identifier for the project; this value is generated within PSCIS.
ASSMT_FUNDING_SOURCE FNDPRJ_SRC VARCHAR2 10 ASSMT FUNDING SOURCE defines the source of funding for the associated project. Eg. FIA
ASSMT_RESPONSIBLE_PARTY_NAME RSPNSBL_NM VARCHAR2 255 The ASSMT RESPONSIBLE PARTY NAME is the name of the provided responsible party.
ASSMT_CONSULTANT_NAME CNSLTNT_NM VARCHAR2 255 The ASSMT CONSULTANT NAME is the name of the provided consultant.
ASSMT_DATE ASSMT_DATE DATE 7 The ASSMT DATE is the date when the assessment was completed.
STREAM_CROSSING_ID STRM_X_ID NUMBER 10 The STREAM CROSSING ID is the unique identifier for the STREAM CROSSING LOCATION POINT.
HABCONF_ASSMT_ID HC_ASMT_ID NUMBER 10 HABCONF ASSMT ID is the HABITAT CONFIRMATION ASSESSMENT ID that is the unique identifier for the CROSSING ASSESSMENT.
HABCONF_ID HABCONF_ID NUMBER 10 HABCONF ID is the HABITAT CONFIRMATION ID that is the unique identifier for the HABITAT CONFIRMATION.
EXTERNAL_CROSSING_REFERENCE EX_X_REF VARCHAR2 50 The EXTERNAL CROSSING REFERENCE identifies the submitters name used to reference a stream crossing.
CREW_MEMBERS CREW_MMBR 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 EASTING 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 NORTHING NUMBER 13 UTM NORTHING is the distance in meters northward from the equator. e.g., 6197826
LOCATION_CONFIDENCE_IND LOC_CNFDNC VARCHAR2 1 The LOCATION CONFIDENCE IND may indicate if this spatial point is a duplicate. Allowable values are 'Y' and 'N'
STREAM_NAME STRM_NM 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 ROAD_NAME VARCHAR2 256 The ROAD NAME is the name of the road at the crossing, usually a forest road.
ROAD_KM_MARK ROAD_KM 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 ROAD_TEN 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.
HABCONF_PROCEED_IND HC_PRC_IND VARCHAR2 1 the HABCONF PROCEED IND indicator identifies if the site is suitable for proceeding to the design phase of the project, based on the habitat assessment.
HABCONF_HABITAT_VALUE_CODE HC_HV_CD VARCHAR2 10 The HABCONF 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.
HABCONF_HABITAT_VALUE_DESC HC_HV_DESC VARCHAR2 120 HABCONF HABITAT VALUE DESC describes the usage of the code value.
HABCONF_HABITAT_VALUE_RTLE HC_HV_RTLE VARCHAR2 1000 The HABCONF HABITAT VALUE RTLE is a brief description or rationale of the basic quality of the local habitat. Used for determining the importance or necessity of the remediation proposal.
HABCONF_VERIFIED_HABITAT_IND HC_VH_IND VARCHAR2 1 The HABCONF VERIFIED HABITAT IND indicator determines if there is a known downstream habitat. A value of Y indicates there is a known downstream habitat. A value of N indicates there is not.
HABCONF_VERIFIED_HABITAT_LEN HC_VH_LEN NUMBER 6 The HABCONF VERIFIED HABITAT LEN is the field verified habitat length in linear metres (to the nearest metre).
HABCONF_COMMENTS HC_COMMENT VARCHAR2 2000 The HABCONF COMMENTS attribute defines any other comments that are relative to the Habtitat Confirmation.
HABCONF_ECOCAT_URL HC_EC_URL VARCHAR2 200 HABCONF ECOCAT URL is a URL pointing at Ecocat for the related project. e.g., http://a100.gov.bc.ca/pub/acat/public/advancedSearch.do?keywords=PSCIS[ASSMT_PROJECT_ID]
HABCONF_IMAGE_VIEW_URL HC_IMG_URL VARCHAR2 200 HABCONF IMAGE VIEW URL is a URL pointing at an HTML display of the Habitat Confirmation attachments. e.g., http://a100.gov.bc.ca/pub/pscismap/imageViewer.do?habitatconfirmationid=[HABCONF_ID]
CURRENT_PSCIS_STATUS CUR_STATUS 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 CUR_X_TCD 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 CUR_X_TDS VARCHAR2 120 CURRENT CROSSING TYPE DESC describes the CURRENT CROSSING TYPE.
CURRENT_CROSSING_SUBTYPE_CODE CUR_X_STCD 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 CUR_X_STDS VARCHAR2 120 CURRENT CROSSING SUBTYPE DESC describes the CUURENT CROSSING SUBTYPE.
CURRENT_BARRIER_RESULT_CODE CUR_X_RSCD 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 CUR_BR_DSC VARCHAR2 120 CURRENT BARRIER DESCRIPTION describes the usage of the CURRENT BARRIER RESULT CODE.
FEATURE_CODE F_CODE VARCHAR2 10 FEATURE CODE contains a value based on the Canadian Council of Surveys and Mapping’s (CCSM) system for classification of geographic features.
GEOMETRY GEOMETRY SDO_GEOMETRY 64 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.