Drinking Water Sources (Surface Water PODs)

1459 views (12 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 layer displaying consumptive water licence points of diversion for drinking water systems. In the context of this layer, Drinking Water Systems means two or more water licences for domestic purposes at a single POD; and/or a water licence(s) for any other purpose indicating a water diversion and distribution system supplying water directly to residences and/or buildings for human consumption. This layer is an instantiation of the spatial view WLS_BC_POD_DRINKING_SOURCES_SVW

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Spatial layer intended to display the location of water rights points of diversion for drinking water systems, as licensed under the Water Act.

Lineage Statement

Spatial view created by SQL query for consumptive purposes on WHSE_WATER_MANAGEMENT.WLS_POD_LICENCE_SP.

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 2012-03-05
Record Last Modified 2019-09-05
Resource Status onGoing

Object Description

Object Name: WHSE_WATER_MANAGEMENT.WLS_BC_POD_DRINKNG_SOURCES_SP

Short Name: WLSBCPDDRN
Comments: BC POD DRINKNG SOURCES is a province-wide SDE layer displaying the location of water rights points of diversion for drinking water systems, as licensed under the Water Act. In the context of this layer, Drinking Water Systems means two or more water licences for domestic purpose at a single POD; and/or a water licence(s) for any other purpose indicating a water diversion and distribution system supplying water directly to residences and/or buildings for human consumption. This layer is a spatially de-normalized version of WLS_BC_POD_DRINKING_SOURCES_SVW.

Column Name Short Name Data Type Data Precision Comments
BC_POD_DRINKING_SOURCE_ID BCPDDRNKNG NUMBER 18 The BC POD DRINKING SOURCE ID is the unique identifier of a drinking water point of diversion that is associated to a Water Act licence. This identifier is not persistent.
STRM_NAME STRM_NAME VARCHAR2 30 STRM NAME describes the name of the stream the point of diversion is marked upon.
STATUS STATUS VARCHAR2 2 STATUS is the status of license creation. A = applicaiton for license, L = License granted , AL = both License issued and application for license on point of diversion, I = inactive
PNTS_CODE PNTS_CODE VARCHAR2 12 PNTS CODE describes a unique identifier for the point of diversion at a branch on the stream. An example of the PNTS CODE is PD22935
LICENCE_COUNT LCNCCNT NUMBER 22 LICENCE COUNT indicates the number of licences that are associated to the POINT OF DIVERSION for the associated LICENCE PURPOSE.
LICENCE_PURPOSE LCNCPRPS VARCHAR2 25 LICENCE PURPOSE indicates the intended purpose of the water being diverted by the POINT OF DIVERSION. For example, DOMESTIC indicates that the water will be used for human consumption.
FEATURE_CODE FTRCD VARCHAR2 10 FEATURE CODE contains a value based on the Canadian Council of Surveys and Mapping's (CCSM) system for classification of geographic features
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.