B.C. Dams

1784 views (46 recent)

Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - Water Management
Licensed under Open Government Licence - British Columbia

Province-wide SDE spatial view displaying dam locations. The public view displays a subset of the attribute data

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Spatial view intended to display the location of dams in the province, along with the attributes deemed accessible to the public.

Lineage Statement

Spatial view created by joining selected arcs from spatial layer WHSE_WATER_MANAGEMENT.WLS_WATER_LICENCED_WRK_LINE_SP tagged with the 'D-file' number (e.g. twrk_tag lk 'D*') with attribute view WHSE_WATER_MANAGEMENT.WRIS_DAMS_BASE_VW by TWRK_TAG/DAM_FILE_NO.

Contact Information

NameScott Morgan (pointOfContact)
EmailScott.Morgan@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationWater Management

Access & Security

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

Metadata Information

Record Published 2011-03-09
Record Last Modified 2019-06-06
Resource Status onGoing

Object Description

Object Name: WHSE_WATER_MANAGEMENT.WRIS_DAMS_PUBLIC_SVW

Short Name: WRIS_DMPUB
Comments: The location of dams within BC.

Column Name Short Name Data Type Data Precision Comments
DAM_NAME DAM_NAME VARCHAR2 120 DAM NAME is the name given to a dam, e.g., WILSEY MAIN DAM.
DAM_FILE_NO DFILENUM VARCHAR2 50 DAM FILE NUMBER is also known as the D-file number. It is the unique reference number by which dams are identified, e.g., D240006-01.
ALTERNATE_DAM_NAME ALT_DAM_NM VARCHAR2 120 ALTERNATE DAM NAME is an alternative name for the dam where one exists, e.g., SHUSWAP FALLS DAM.
DAM_OWNER DAM_OWNER VARCHAR2 40 DAM OWNER is a person, including a company, organization, government unit, public utility, corporation or other entity, which either holds a water licence to operate a dam or retains the legal property title on the dam site, e.g., BC HYDRO & POWER AUTHORITY.
REGION_NAME REGION VARCHAR2 20 REGION NAME is the region in which the dam is located, e.g., OKANAGAN.
DISTRICT_PRECINCT_NAME DSTR_PRCNT VARCHAR2 30 DISTRICT PRECINCT NAME is the the short name of the water district and the precinct in which the dam is located, e.g., VER - LUMBY.
DAM_TYPE DAM_TYPE VARCHAR2 25 DAM TYPE is the type of dam construction, e.g., Concrete Arch.
SPILLWAY_TYPE SPLLWY_TYP VARCHAR2 6 SPILLWAY TYPE is the type of spillway at the dam, i.e., CL (Culvert), CO (Concrete Overflow), GT (Gated), NO (Native Channel Overflow), OT (Other), TO (Timber Overflow).
DAM_FUNCTION DAM_FNCTN VARCHAR2 12 DAM FUNCTION is the role of the dam when there are multiple dams on a reservoir, e.g., MAIN, SADDLE.
COMMISSIONED_YEAR CMMSSND_YR VARCHAR2 12 COMMISSIONED YEAR is the year the dam was commissioned.
DAM_HEIGHT_IN_METRES DAM_HT NUMBER 10 DAM HEIGHT IN METRES is height of the dam, in metres.
CREST_ELEVATION_IN_METRES CREST_ELEV NUMBER 10 CREST ELEVATION IN METRES is the dam crest elevation above mean sea level, in metres.
CREST_LENGTH_IN_METRES CREST_LEN NUMBER 10 CREST LENGTH IN METRES is the longitudinal length of the dam crest along the centre line of the dam from the left abutment to the right abutment, in metres.
FAILURE_CONSEQUENCE FAIL_CONSQ VARCHAR2 75 FAILURE_CONSEQUENCE represents the Consequence to downstream should the dam fail.
RISK_LEVEL RISK_LEVEL VARCHAR2 3 RISK LEVEL is a subjective numerical rating of the potential of a dam failure based on both the failure consequence and failure probability, i.e., from 1 (high) to 5 (low).
POINTS_CODE POINTS_CD VARCHAR2 36 POINTS CODE is the water rights point of diversion number for the dam which links to the water licence(s) for the dam, e.g., PD57752.
DAM_REGULATED_CODE DAM_REG_CD VARCHAR2 120 DAM REGULATED CODE indicates whether the dam is regulated or not regulated, and what part of the regulation applies to the dam, e.g., Regulated, Regulated - Part 3 Exempt, Non-Regulated - Including Minor Dam.
DAM_OPERATION_CODE DAM_OP_CD VARCHAR2 60 DAM OPERATION CODE is the current operating stage of the dam in its life cycle, i.e., Abandoned, Active, Application, Breached, Deactivated, Decommissioned, Not Constructed, Removed.
DAM_SAFETY_OFFICER DSO VARCHAR2 60 DAM SAFETY OFFICER is an engineer or officer employed by the BC government who is designated in writing by the comptroller under the Water Sustainability Act.
FEATURE_LENGTH_M FEAT_LEN NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters.
GEOMETRY GEOMETRY SDO_GEOMETRY 64 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 ANNO_CAD 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.