B.C. Dams

1757 views (44 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.

Data Quality
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-05-04
Resource Status onGoing

Object Description

Object Name: WHSE_WATER_MANAGEMENT.WRIS_DAMS_PUBLIC_SVW

Short Name: WRIS_DMPUB
Comments: View to be used primarily within the IMAP application. (Public users) Containing 14 attributes attached to the dams, revealing: Identification through; the dam name and file number (D-number). Licensing information obtained by using the Point code. Location of the Dam within BC using; District, Precinct and Region. Dam description with; Category, Type and Function. Physical Characteristics through; Height, Crest elevation and length. Ownership of the dam established with the Dam owner. NOTE: null geometries are NOT incuded.

Column Name Short Name Data Type Data Precision Comments
DAM_NAME DAM_NAME VARCHAR2 120 Name given to a Dam
DAM_FILE_NO DMFLN VARCHAR2 50 This is known as the 'D file' number. It is the unique reference number by which dams are identified and files are kept. In the context of this DAMS view, dams can be located in Imap using this number.
COMMISSIONED_YEAR CMMSSNDR VARCHAR2 12 COMMISSIONED YEAR is the year the dam was commissioned.
DAM_OWNER DAM_OWNER VARCHAR2 40 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.
NEXT_AUDIT_DATE NXTDTDT DATE 7 NEXT_AUDIT_DATE is the next date in which a Dam Safety Audit is planned to be undertaken by a Dam Safety Officer.
NEXT_AUDIT_YEAR NXTDTR NUMBER 38 The next year in which a Dam Safety Audit is planned to be undertaken by a Dam Safety Officer
REGION_NAME RGNNM VARCHAR2 20 The Region in which the Dam is located.
DISTRICT_PRECINCT_NAME DSTRCTPRCN VARCHAR2 30 The Water District and Precinct in which the Dam is located.
POINTS_CODE PNTSCD VARCHAR2 36 This is the Point of Interest code for the dam location.
DAM_REGULATED_CODE REG_CODE VARCHAR2 120 The DAM REGULATED CODE indicates whether the dam is regulated or not regulated. Values are Regulated and Non-Regulated.
DAM_OPERATION_CODE OP_CODE VARCHAR2 60 A dam is placed into categories within the Water Licensing system. The life of a dam goes from Application category at the beginning of its life to Breached category at the end of its life and many steps in between.
DAM_TYPE DAM_TYPE VARCHAR2 25 Type of Dam construction
DAM_HEIGHT_IN_METRES DMHGHTNMTR NUMBER 10 Height of Dam in Metres
DAM_FUNCTION DMFNCTN VARCHAR2 12 This differentiates the role of the dam when there are multiple dams on a reservoir.
CREST_ELEVATION_IN_METRES CRSTLVTNNM NUMBER 10 Dam crest elevation above mean sea level, in metres
CREST_LENGTH_IN_METRES CRSTLNGTHN NUMBER 10 The longitudinal length of the dam crest along centre line of the dam from the left abutment to the right abutment in metres
DAM_SAFETY_OFFICER DMSFTFFCR VARCHAR2 60 An engineer or officer employed by the government and designated in writing by the Comptroller under the Water Act of British Columbia.
FEATURE_LENGTH_M 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.
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.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a required attribute of feature classes and object classes in a geodatabase.

Comments

No comments have been posted yet.