BC Points of Diversion with Water Licence Information

2856 views (23 recent)

Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - Water Management
Licensed under Open Government Licence - British Columbia

DEPRECATED: Province-wide SDE spatial layer displaying water licence points of diversion joined with licence information. This layer contains a record for each water licence on each Point of Diversion that exists in the province (each Point of Diversion can have multiple licences). For each record, some basic information about the water licence is included. This dataset has been replaced by:

Water Rights Licences: WHSE_WATER_MANAGEMENT.WLS_WATER_RIGHTS_LICENCES_SV

Water Rights Licences - Internal: WHSE_WATER_MANAGEMENT.WLS_WATER_RIGHTS_LICENCES_SP

Water Rights Applications: [WHSE_WATER_MANAGEMENT.WLS_WATER_RIGHTS_APPLICTNS_SV] (https://catalogue.data.gov.bc.ca/dataset/f3a53d7f-da09-4726-ac83-f0032e4bd490)

Water Rights Applications - Internal: [WHSE_WATER_MANAGEMENT.WLS_WATER_RIGHTS_APPLICTNS_SP] (https://catalogue.data.gov.bc.ca/dataset/723e86f9-738f-4d2c-b18d-1ebe7a1dd7b5)

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, as licensed under the Water Act, along with the licence information.

Data Quality

Note: In the dataset, the water licence quantity units are reported as a 2-letter code. MS = cubic meters per second; MD = cubic meters per day; MY = cubic meters per year; TF = a unit shown against non-consumptive purposes (e.g. land improvement, conservation) for which the total flow of the stream is authorized to pass through the licensed works. No water is diverted from the stream.

Lineage Statement

Spatial view created by joining spatial layer WHSE_WATER_MANAGEMENT.BC_POINTS_OF_DIVERSION with attribute table WHSE_WATER_MANAGEMENT.GOAT_POD_LICENCES by TPOD_TAG/PNTS_CODE. Results of spatial view then instantiated into spatial layer WHSE_WATER_MANAGEMENT.WLS_POD_LICENCE_SP. Records without a captured point of diversion to join to, are placed into the table WHSE_WATER_MANAGEMENT.WLS_POD_LICENCE_EXCEPTIONS_VW.

Contact Information

NameSusan Waldock (businessExpert)
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-05-01
Resource Status obsolete
Replacement Recordhttps://catalogue.data.gov.bc.ca/dataset/5549cae0-c2b1-4b96-9777-529d9720803c

Object Description

Object Name: WHSE_WATER_MANAGEMENT.WLS_POD_LICENCE_SP

Short Name: WLS_PDL_SP
Comments: WLS POD LICENCE SP is the result of an INNER join between BC_POINTS_OF_DIVERSION and GOAT_POD_LICENCES. All of the columns from both objects are included in the resulting spatial layer that is populated form the sptial view WLS_POD_LICENCE_SVW.

Column Name Short Name Data Type Data Precision Comments
FEATURE_CODE FTRCD VARCHAR2 10
TPOD_TAG TPOD_TAG VARCHAR2 10
STRM_NAME STRM_NAME VARCHAR2 30
STATUS STATUS VARCHAR2 2
REDIV_FLAG REDIV_FLAG VARCHAR2 1
LICENCE_NO LICENCE_NO VARCHAR2 7
PRIORITY_DATE PRRTDT NUMBER 10
LIC_STATUS LIC_STATUS VARCHAR2 15
LIC_STAT_DATE LCSTTDT NUMBER 10
MAPSHEET_POD MPSHTPD VARCHAR2 70
STREAM_NAME STRMNM VARCHAR2 30
PURPOSE PURPOSE VARCHAR2 25
QUANTITY QUANTITY NUMBER 20
UNITS UNITS VARCHAR2 2
QTY_FLAG QTY_FLAG VARCHAR2 1
FLAG_DESC FLAG_DESC VARCHAR2 69
FILE_NO FILE_NO VARCHAR2 7
DIST_PREC_NAME DSTPRCNM VARCHAR2 25
LIC_APPL_FLAG LCPPLFLG VARCHAR2 1
PROC_STATUS PRCSTTS VARCHAR2 20
LICENSEE LICENSEE VARCHAR2 40
ADDRESS_LINE1 DDRSSLN1 VARCHAR2 25
ADDRESS_LINE2 DDRSSLN2 VARCHAR2 25
ADDRESS_LINE3 DDRSSLN3 VARCHAR2 25
ADDRESS_LINE4 DDRSSLN4 VARCHAR2 25
COUNTRY COUNTRY VARCHAR2 25
POSTAL_CODE PSTLCD VARCHAR2 10
PCL_NO PCL_NO VARCHAR2 5
EXPIRY_DATE XPRDT NUMBER 10
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.

Comments

No comments have been posted yet.