Water Reserves and Water Allocation Restrictions

41 views (3 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 layer showing the most downstream point of a stream or drainage system, having a Water Reserve or a Water Allocation Restriction. This data is also available in two separate layers: one showing only water reserves (WHSE_WATER_MANAGEMENT.WLS_WATER_RESERVE_LOC_SVW) and one showing only water allocation restrictions (WHSE_WATER_MANAGEMENT.WLS_WATER_RESTRICTION_LOC_SVW). Restrictions last updated September 1, 2015.

Data and Resources

Dataset Extent

Latitude: 47.8° to 60.2°
Longitude: -135.2° to -111.1°

Additional Information

Purpose

Layer intended to display the location of water sources or systems established as having a Water Reserve or a Water Allocation Restriction.

Contact Information

NameSusan Waldock (pointOfContact)
EmailSusan.Waldock@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-09-10
Resource Status onGoing

Object Description

Object Name: WHSE_WATER_MANAGEMENT.WLS_WATER_RSRV_RSTRCTN_LOC_SP

Short Name: RERS_LO_SP
Comments: A Water Reserve Restriction Location (WATER RSRV RSTRCTN LOC SP) is a feature that "tags" water features that are "reserved" or "restricted" according to the definitions in the FCODE field converted to FEATUR CODE on transition from arc coverage. Features are digitized at the mouth (downstream location) of a water feature - to indicate that everything upstream (at either TRIM or non-TRIM feature) is reserved/restricted. This is not a multipart feature.

Column Name Short Name Data Type Data Precision Comments
WATER_RSRV_RSTRCTN_LOC_ID RERS_LO_ID NUMBER 10 Primary unique numeric identifier for a feature.
FEATURE_CODE FEAT_CODE VARCHAR2 10 A standard numeric code to identify the type of feature represented by the spatial data. A feature code is most importantly a means of linking a feature to its name and definition. For example, the code GB15300120 on a digital geographic feature links it to the name "Lake - Dry" with the definition "A lake bed from which all water has drained or evaporated." The feature code does NOT mark when it was digitized, what dataset it belongs to, how accurate it is, what it should look like when plotted, or who is responsible for updating it. It only says what it represents in the real world. It also doesn't even matter how the lake is represented. If it is a very small lake, it may be stored as a point feature. If it is large enough to have a shape at the scale of data capture, it may be stored as an outline, or a closed polygon. The same feature code still links it to the same definition.
RESERVE_OR_RESTRICTION_ID RERS_ID VARCHAR2 10 User defined, not unique ID.Beginning with RV� or RS�
DESCRIPTION DESCRPTN VARCHAR2 70 Description and date in one field. This comes out of the Oracle table as such, and re-working of this information would require re-working of the processes and structure of the table. Leave as is for now, and consider revisiting as part of system migration in the future.
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 required attribute of feature classes and object classes in a geodatabase.
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.