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
Data and Resources
BC Geographic Warehouse Custom Downloadother
WMS getCapabilities requestwms
For use in viewers such as ESRI tools use this truncated link:...
KML Network Linkkml
For use in viewers such as Google Earth Click here for information on how to...
Spatial view intended to display the location of dams in the province, along with the attributes deemed accessible to the public.
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.
|Name||Scott Morgan (pointOfContact)|
|Organization||Ministry of Forests, Lands, Natural Resource Operations and Rural Development|
Access & Security
|Who can view this dataset?||Public|
|Who can download this dataset?||Public|
|Record Last Modified||2019-05-04|
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.|