Stream Inventory Sample Sites

648 views (4 recent)

Published by the Ministry of Environment and Climate Change Strategy - Knowledge Management
Licensed under Open Government Licence - British Columbia

This spatial layer displays stream inventory sample sites that have had full or partial surveys, and contains measurements or indicator information of the data collected at each survey site on each date.

Data and Resources

Dataset Extent

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

Additional Information

Contact Information

NameGordon Oliphant (businessExpert)
EmailGord.Oliphant@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationKnowledge Management
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 2014-11-14
Record Last Modified 2019-09-05
Resource Status completed

Object Description

Object Name: WHSE_FISH.FISS_STREAM_SAMPLE_SITES_SP

Short Name: STRMSPLSTE
Comments: FISS_STREAM_SAMPLE_SITES_SP is a survey of fish habitat information in a stream. This object contains all the columns from the table FISS_STREAM_SAMPLE_SITES, plus additional columns from WDIC_WATERSHEDS and WDIC_WATERBODIES.

Column Name Short Name Data Type Data Precision Comments
STREAM_SAMPLE_SITE_ID STRM_SM_ID NUMBER 9 SAMPLE SITE ID is the unique identifier for a STREAM SAMPLE SITE. The value is sourced from the FISS operational database.
WBODY_ID WBODY_ID NUMBER 12 WBODY_ID is a foreign key to WDIC_WATERBODIES.
DATA_SOURCE DATA_SRCE VARCHAR2 1000 DATA SOURCE is the abbreviation, and if appropriate, the primary key, of the dataset(s) from which the data were obtained.
SOURCE_REF SOURCE_REF VARCHAR2 4000 SOURCE REF is the concatenation of all biographical references for the source data. This may include citations to reports that published the surveys or the name of a project under which the surveys were conducted.
REACH_NUMBER REACH_NMBR NUMBER 4 REACH NUMBER is an agency-assigned number for the reach in which the survey occurred.
SITE_NUMBER SITE_NMBR NUMBER 5 SITE NUMBER is an agency-assigned number for the site at which the survey occurred.
FIELD_UTM_ZONE F_UTM_ZONE NUMBER 2 FIELD UTM ZONE is the zone of the site's UTM location obtained in the field.
FIELD_UTM_EASTING F_UTM_EAST NUMBER 6 FIELD UTM EASTING is the easting coordinate of the site's UTM location obtained in the field.
FIELD_UTM_NORTHING F_UTM_NRTH NUMBER 7 FIELD UTM NORTHING is the northing coordinate of the site's UTM location obtained in the field.
GIS_UTM_ZONE G_UTM_ZONE NUMBER 2 GIS UTM ZONE is the zone of the site's UTM location obtained in the field, then updated such that points are within 10 m of source line work on 1:20,000 scale maps.
GIS_UTM_EASTING G_UTM_EAST NUMBER 6 GIS UTM EASTING is the easting coordinate of the site's UTM location obtained in the field, then updated such that points are within 10 m of source line work on 1:20,000 scale maps.
GIS_UTM_NORTHING G_UTM_NRTH NUMBER 7 GIS UTM NORTHING is the northing coordinate of the site's UTM location obtained in the field, then updated such that points are within 10 m of source line work on 1:20,000 scale maps.
SURVEY_DATE SRVY_DTE DATE 7 SURVEY DATE is the date that the stream site was surveyed.
AGENCY_NAME AGENCY_NM VARCHAR2 60 AGENCY NAME is the name of the agency that conducted the stream survey.
SURVEYED_LENGTH SRVYD_LNGH NUMBER 8 SURVEYED LENGTH is the measured length of the site, in meters.
CHANNEL_WIDTH CHNL_WDTH NUMBER 7 CHANNEL WIDTH is the width of the stream channel, in metres.
CHANNEL_WIDTH_COMMENT CHNL_W_COM VARCHAR2 2000 CHANNEL WIDTH COMMENT is additional information about the method in which the channel width was estimated or pertaining to the accuracy of the channel width estimate.
WETTED_WIDTH WETD_WDTH NUMBER 7 WETTED WIDTH is the width of the stream measured at the water surface, in metres.
WETTED_WIDTH_COMMENT WETD_W_COM VARCHAR2 2000 WETTED WIDTH COMMENT is additional information about the method in which the wetted channel width was estimated or pertaining to the accuracy of the estimate.
POOL_DEPTH POOL_DEPTH NUMBER 7 POOL DEPTH is the depth of stream pools, in meters.
POOL_DEPTH_COMMENT PL_DEP_COM VARCHAR2 2000 POOL DEPTH COMMENT is additional information about the method in which the pool depth was estimated or pertaining to the accuracy of the estimate.
GRADIENT GRADIENT NUMBER 7 GRADIENT is the ratio of change in elevation to length of the stream segment, as a percentage.
GRADIENT_COMMENT GRDNT_COM VARCHAR2 2000 GRADIENT COMMENT is additional information about the method in which the stream gradient was estimated or pertaining to the accuracy of the estimate.
AVERAGE_DEPTH AVRG_DPTH VARCHAR2 7 AVERAGE DEPTH is the average depth of the channel, in centimetres.
DOMINANT_BED_MATERIAL DM_BD_MAT VARCHAR2 150 DOMINANT BED MATERIAL is the dominant stream bed material such as 'Boulders', 'Cobble', 'Gravels', or 'Rock'.
SUB_DOMINANT_BED_MATERIAL SDM_BD_MAT VARCHAR2 150 SUB DOMINANT BED MATERIAL is the subdominant stream bed material such as 'Boulders', 'Cobble', 'Gravels', or 'Rock'.
OTHER_BED_MATERIAL_COMMENT OTHR_BD_MT VARCHAR2 2000 OTHER BED MATERIAL COMMENT is a description of the stream bed material.
DOMINANT_SIZE DMNNT_SZE NUMBER 7 DOMINANT SIZE is the size of bed material larger than 95% of total substrate, in centimeters.
BED_MORPHOLOGY BD_MRPHLGY VARCHAR2 50 BED MORPHOLOGY is a description of the stream bed morphology. For example, 'Cascade Pool', 'Large Channel' or 'Riffle Pool'.
FISHERIES_SENSITIVE_ZONE_IND F_SEN_ZN_I VARCHAR2 3 FISHERIES SENSITIVE ZONE IND indicates whether the site provides a valuable fish spawning or fry rearing habitat. Possible values are Yes or No.
CROWN_COVER CR_CLS VARCHAR2 20 CROWN COVER is the total cover over of any structure in the wetted channel or within 1 m above the water surface that provides hiding, resting, or feeding places for fish. Stream cover estimates are obtained from a visual assessment of the type and amount of in-channel covers available for fish.Values are either given as percentages or as categorical data types, such as 'Abundant', 'Moderate' or 'None'.
CROWN_CLOSURE_PERCENT CR_CLS_PER VARCHAR2 5 CROWN CLOSURE PERCENT is the approximate percentage of stream area with crown cover.
CROWN_CLOSURE_COMMENT CR_CLS_CMT VARCHAR2 2000 CROWN CLOSURE COMMENT is a description of the crown cover.
CHANNEL_PATTERN CHNL_PTTN VARCHAR2 30 CHANNEL PATTERN is a description of the channel pattern. For example, 'Irregular Meanders', 'Sinuous' or 'Straight'.
VISIBLE_CHANNEL_IND VIS_CHAN_I VARCHAR2 3 VISIBLE CHANNEL IND indicates whether or not a channel is visible. Possible values are Yes or No.
STREAM_COUPLING_CODE STM_CP_CD VARCHAR2 30 STREAM COUPLING CODE is a description of the linkage between the hillslope and the channel. Possible values are: 'Coupled', 'Decoupled', 'Partially Coupled' and 'Not Specified'.
STREAM_CONFINEMENT_CODE STM_CON_CD VARCHAR2 30 STREAM CONFINEMENT CODE specifies the stream confinement morphology. Possible values are: Entrenched, Unconfined, Occasionally Confined, Confined, Frequently Confined, Not Applicable, Not Specified.
CONFINEMENT_COMMENT CON_CMT VARCHAR2 2000 CONFINEMENT COMMENT is a descrition of the stream confinement morphology.
DEWATERING_IND DWTRNG_IND VARCHAR2 3 DEWATERING IND indicates whether or not dewatering was present. Possible values are Yes or No.
INTERMITTENT_IND INTRMT_IND VARCHAR2 3 INTERMITTENT IND indicates whether or not water flow is seasonal. Possible values are Yes or No.
SITE_ACCESS_CODE ST_ACSS_CD VARCHAR2 30 SITE ACCESS CODE is a description of the type of access available to the site. Possible values are: Helicopter, Vehicle (4WD), All Terrain Vehicle, Float Plane, Horseback, Quad, Vehicle (2WD), Fixed Wing, Horse, Motorcycle, Boat, 2 Wheel Drive, Not Applicable, Fixed Wing Plane, Foot, 4 Wheel Drive.
DEBRIS_AREA DEBRS_AREA VARCHAR2 40 DEBRIS AREA is the amount of channel area covered by debris. Values are given as percentages or as categorical data types such as 'Isolated Bits', 'Few Clumps' or 'Greater than 25% of Channel Area'.
LARGE_WOODY_DEBRIS_COVER LWD_CVR VARCHAR2 30 LARGE WOODY DEBRIS COVER is the amount of large woody debris at the site. Values are given either as percentages, or as categorical data types such as 'Dominant', 'Sub-Dominant' or 'None'.
LARGE_WOODY_DEBRIS_AMOUNT LWD_AMNT VARCHAR2 30 LARGE WOODY DEBRIS AMOUNT is a description of the amount of large woody debris. For example, 'Abundant', 'Few' or 'None'.
LARGE_WOODY_DEBRIS_DSTRBTN LWD_DISTN VARCHAR2 30 LARGE WOODY DEBRIS DSTRBTN is a description of the distribution of large woody debris. For example, 'Evenly Distributed' or 'Clumped'.
SMALL_WOODY_DEBRIS_COVER SWD_CVR VARCHAR2 30 SMALL WOODY DEBRIS COVER is the amount of small woody debris at the site. Values are given either as percentages, or as categorical data types such as 'Dominant', 'Sub-Dominant' or 'None'.
BOULDER_COVER BLDR_CVR VARCHAR2 30 BOULDER COVER is the amount of boulder cover, specified either as a percentage or as a categorical data type (such as 'Abundant', 'Moderate', etc.).
UNDERCUT_COVER UNDRCT_CVR VARCHAR2 30 UNDERCUT COVER is the amount of the stream covered by a bank that has had its base cut away by the water or has been man-made and overhangs part of the stream. The value is specified either as a percentage or as a categorical data type (such as 'Abundant', 'Moderate', etc.).
DEEP_POOL_COVER DP_PL_CVR VARCHAR2 30 DEEP POOL COVER is the amount of the stream with reduced current velocity at low flow that is deeper than the surrounding area, and usable by fish for resting or cover (therefore containing some surface cover of flow turbulence). The value is specified either as a percentage or as a categorical data type (such as 'Abundant', 'Moderate', etc.).
OVERHANGING_VEGETATION_COVER OVRHNG_VEG VARCHAR2 30 OVERHANGING VEGETATION COVER is the amount of the stream covered by overhanging vegetation. The value is specified either as a percentage or as a categorical data type (such as 'Abundant', 'Moderate', etc.).
INSTREAM_VEGETATION_COVER ISTR_VEG VARCHAR2 30 INSTREAM VEGETATION COVER is the amount of the stream in which vegetative materials such as attached, filamentous algae or other aquatic plants provide protection for fish. The value is specified either as a percentage or as a categorical data type (such as 'Abundant', 'Moderate', etc.).
INSTREAM_VEGETATION_CODE ISTR_VEG_C VARCHAR2 30 INSTREAM VEGETATION CODE is the type of vegetative materials that provide protection for fish. Possible values are Algaea, Moss, None and Other. A list of multiple types may be specified, separated by commas.
EMS_NUMBER EMS_NUMBER VARCHAR2 15 EMS NUMBER is the number assigned by the Environment Monitoring System (EMS). For example, E236773.
WATER_TEMPERATURE WTRTMP NUMBER 4 WATER TEMPERATURE is the temperature of the water in degrees Celsius.
WATER_TEMPERATURE_COMMENT WTRTMP_CMT VARCHAR2 2000 WATER TEMPERATURE COMMENT provides information about water temperature. In some cases this field also provides information about alkalinity, turbidity, air temperature or other measurables.
WATER_PH WATER_PH NUMBER 3 WATER PH is a measure of water pH. The pH scale ranges from 0 to 14. A pH of 7 is neutral. A pH less than 7 is acidic. A pH greater than 7 is basic.
WATER_CONDUCTIVITY WTR_CNDCTY NUMBER 6 WATER CONDUCTIVITY is a measure of electrical current flow through a solution, expressed in units of microSiemens (uS). Conductivity is the reciprocal of electrical resistance (ohms).
FLOOD_SIGNS FLD_SGNS VARCHAR2 30 FLOOD SIGNS is a description of signs of flooding in the local area.
FLOOD_SIGNS_COMMENT FLD_SGNS_C VARCHAR2 2000 FLOOD SIGNS COMMENT is an additional comment about signs of flooding in the area.
LARGEST_MOVEABLE_PARTICLE_SIZE LRG_M_P_SZ NUMBER 7 LARGEST MOVEABLE PARTICLE SIZE is the size of the largest movable particle in the bed, in centimeters.
DISCHARGE_STAGE DSCHRG_STE VARCHAR2 30 DISCHARGE STAGE is the stage of discharge compared to the bankful depth - Low, Medium, or High.
DISCHARGE_COMMENT DSCHRG_CMT VARCHAR2 2000 DISCHARGE COMMENT is additional information about the stream discharge, such as how it was estimated or why it was not possible to estimate the discharge.
TURBIDITY TURBIDITY VARCHAR2 30 TURBIDITY is a description of the turbidity of the water. The value is specified either as a number (in units of cm) or as a categorical data type ('Clear', 'Lightly Turbid', 'Moderately Turbid' or 'Turbid'.).
ISLANDS_CODE ISLANDS_CD VARCHAR2 20 ISLANDS CODE describes the presence of islands. Possible values are: Occasional, Split, None, No, Frequent, Anastomosing, Yes, Irregular, Not Specified.
RIGHT_BANK_RIPARIAN_VGTN_CODE RB_RV_CD VARCHAR2 40 RIGHT BANK RIPARIAN VEGETATION CODE is the type of riparian vegetation on the right bank. Possible values are: Grass, Deciduous, Coniferous, Mixed C/D, None, Shrubs, Wetland, Not Specified.
RIGHT_BANK_SHAPE_CODE RB_SHP_CD VARCHAR2 40 RIGHT BANK SHAPE CODE is the shape of the right channel bank. Possible values are: Sloping (gradual or shallow sloping), Undercut, Overhanging bank, V - shaped (steep sloping or vertical).
RIGHT_BANK_VGTN_STAGE_CODE RBV_STG_CD VARCHAR2 60 RIGHT BANK VEGETATION STAGE CODE is the stage of vegetation development on the right bank. Possible values are: Non-vegetated or initial stage following disturbance, Mature forest, Shrub/herb stage, Pole-sapling stage, Young forest, Not Applicable, Not Specified.
RIGHT_BANK_TEXTURE RB_TEXTR VARCHAR2 120 RIGHT BANK TEXTURE is the texture of the right channel bank. For example, 'Anthropogenic (rip-rap, dikes, etc.)', 'Boulders', 'Bedrock', or 'Gravels'.
LEFT_BANK_RIPARIAN_VGTN_CODE LB_RV_CD VARCHAR2 40 LEFT BANK RIPARIAN VEGETATION CODE is the type of riparian vegetation on the leftbank. Possible values are: Grass, Deciduous, Coniferous, Mixed C/D, None, Shrubs, Wetland, Not Specified.
LEFT_BANK_SHAPE_CODE LFLB_SHP_C VARCHAR2 40 LEFT BANK SHAPE CODE is the shape of the left channel bank. Possible values are: Sloping (gradual or shallow sloping), Undercut, Overhanging bank, V - shaped (steep sloping or vertical).
LEFT_BANK_VGTN_STAGE_CODE LBV_STG_CD VARCHAR2 60 LEFT BANK VEGETATION STAGE CODE is the stage of vegetation development on the left bank. Possible values are: Non-vegetated or initial stage following disturbance, Mature forest, Shrub/herb stage, Pole-sapling stage, Young forest, Not Applicable, Not Specified.
LEFT_BANK_TEXTURE LB_TEXTR VARCHAR2 120 LEFT BANK TEXTURE the texture of the left channel bank. For example, 'Anthropogenic (rip-rap, dikes, etc.)', 'Boulders', 'Bedrock', or 'Gravels'.
SITE_COMMENTS SITE_CMT VARCHAR2 4000 SITE COMMENTS is an additional comment about stream site.
GAZETTED_NAME GAZTD_NAME VARCHAR2 100 GAZETTED NAME is the gazetted name of the waterbody in which the obstacle was recorded.
NEW_WATERSHED_CODE NEW_WS_CD VARCHAR2 56 NEW WATERSHED CODE is a watershed code, formatted with dashes, as assigned in the Watershed Atlas. For example: 900-569800-08600-00000-0000-0000-000-000-000-000-000-000.
TRIMMED_WATERSHED_CODE TRM_WS CD VARCHAR2 56 TRIMMED WATERSHED CODE is the NEW WATERSHED CODE, but with trailing zeros removed. For example, if the NEW WATERSHED CODE is 100-005200-43400-50000-0000-0000-000-000-000-000-000-000, then the TRIMMED WATERSHED CODE will be 100-005200-43400-50000.
ACAT_REPORT_URL ACT_R_URL VARCHAR2 254 ACAT REPORT URL is a URL to the ACAT REPORT which provides additional information about the STREAM SAMPLE SITE SP.
FEATURE_CODE FCODE 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 1 GEOMETRY is the column used to reference the spatial coordinates defining the feature.
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.