Water Licensed Works - Points

627 views (11 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 point works associated with a Water Licence

Data and Resources

Dataset Extent

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

Additional Information


Layer intended to display the location of point works, as licensed, under the Water Act.

Lineage Statement

Dataset created by digitizing from hardcopy maps, and now updated nightly based on newest data edits.

Contact Information

NameAnn Matteson (pointOfContact)
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationWater Management
NameWater Business Mailbox (pointOfContact)
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 2021-05-10
Resource Status onGoing

Object Description


Short Name: WLS_WLO_SP
Comments: A Water Licensced Work Location (WATER LICENCED WRK LOC SP) is a Single point feature representing "works" associated with water licences, digitized from the plat map associated with a water licence. Question of redundancy with TRIM: these are the features that are necessary for licensing under the Water Act. Some of these features (such as access roads) may exist in TRIM, in which case the TRIM feature may be used. In many cases, however, because the feature is a licenced work, meaning that it is permitted according to the licence but might not actually exist yet (as opposed to TRIM features, which strive to show what exists on the ground).This is not a multipart feature.

Column Name Short Name Data Type Data Precision Comments
WATER_LICENCED_WORK_LOC_ID WRK_LOC_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.
WORKS_ID WORKS_ID VARCHAR2 10 Suppose to be a user defined unique id. Currently some have empty values, others are mixed alphanumeric, often in the format NNAANNNN.
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.