Water Rights Licences - Public

148 views (55 recent)

Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - Water Management
Licensed under Access Only

This is a province-wide SDE spatial layer displaying water rights licence data administrated under the Water Sustainability Act which includes data for both surface water and groundwater Points of Diversions. Point of Diversion types include Surface water Points of Diversion (PDs) Groundwater Points of Well Diversion (PWDs) as well as points of Groundwater diversion (PGs), non-well groundwater diversion points such as dugouts, ditches and quarries. This layer contains a record for each water licence on each POD type that exists in the province (each POD can have multiple licences). For each record, some basic information about the water licence is included.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

This dataset is intended for the public display of water rights licence diversion locations and information.

Data Quality

This dataset contains NULL geometries. When downloading the data in shapefile format, this results in two separate shapefiles being created: [DATASET_NAME]_point (contains features with geometry) and [DATASET_NAME]_geom (contains features with NULL geometry).

Lineage Statement

This data is updated within the Water e-licensing database nightly, and is replicated into the BCGW every two days.

More Information

Contact Information

NameSusan Waldock (custodian)
Emailsusan.waldock@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationWater Management
NameWater Business Mailbox (pointOfContact)
Emailwater.business@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 2018-11-09
Record Last Modified 2018-11-26
Resource Status onGoing
Spatial DataSDO_GEOMETRY

Object Description

Object Name: WHSE_WATER_MANAGEMENT.WLS_WATER_RIGHTS_LICENCES_SV

Short Name: WLS_WRL_P
Comments: Water Licences are issued under the Water Sustainability Act for diverting water from the province of BC. The water can be diverted from surface water sources such as lakes and rivers with Points of Diversion (PODs), groundwater sources such as aquifers can be diverted by Points of Well Diversion locations of points of well diversion (PWD) or non-well points of groundwater diversion (PGs) such as dugouts, ditches and quarries. Each diversion type can have multiple licences, both historical and current.

Column Name Short Name Data Type Data Precision Comments
WLS_WRL_SYSID WLS_WRL_SD NUMBER 10 WLS WRL SYSID is a system generated unique identification number.
POD_NUMBER POD_NUMBER VARCHAR2 10 POD NUMBER is the unique identifier for a Point of Diversion, e.g., PW189413. Each POD can have multiple licences associated with it.
POD_SUBTYPE PD_SBTYPE VARCHAR2 10 POD SUBTYPE distinguishes the different POD types, i.e., POD (a surface water point of diversion), PWD (a point of well diversion that diverts groundwater), or PG (a point of groundwater diversion that diverts groundwater such as a dugout, ditch or quarry).
POD_STATUS POD_STATUS VARCHAR2 10 POD STATUS is the status of the Point of Diversion. Each POD can have multiple licences, e.g., Active (one or more active licences associated), Inactive (only historical inactive licences associated).
FILE_NUMBER FL_NMBR VARCHAR2 10 FILE NUMBER is the water business file number, assigned during the application phase, e.g., 0321048. A file may hold one or more licences.
WELL_TAG_NUMBER WLL_TG_NMR NUMBER 14 WELL TAG NUMBER is a unique well identifier for either registered or licensed wells, e.g., 12345.
LICENCE_NUMBER LCNC_NMBR VARCHAR2 12 LICENCE NUMBER is the authorization number referenced in the water licence document, e.g., 121173.
LICENCE_STATUS LCNC_STTS VARCHAR2 30 LICENCE STATUS represents the existing status of licence, e.g., Current, Cancelled, Pending.
LICENCE_STATUS_DATE LCNC_STTSE DATE 7 LICENCE STATUS DATE indicates the last time the licence status changed.
PRIORITY_DATE PRRTY_DTE DATE 7 PRIORITY DATE is the date from which the precedence of the licence is established within the first in time first in right framework.
EXPIRY_DATE EXP_DATE DATE 7 EXPIRY DATE is the date the licence expires.
PURPOSE_USE_CODE PRPS_S_CD VARCHAR2 5 PURPOSE USE CODE is the use of water authorized by the licence, identified as a code, e.g., 02I.
PURPOSE_USE PRPS_SE VARCHAR2 100 PURPOSE USE is the use of water authorized by the licence, e.g. Industrial.
SOURCE_NAME SOURCE_NM VARCHAR2 100 SOURCE NAME is the aquifer or body of surface water from which the licence is authorized to extract water. A surface water body can be a lake, river, creek or any other surface water source e.g., Skaha Lake or Kokanee Creek. For a known aquifer that has been mapped, the aquifer name is the BC Government's Aquifer ID number, e.g., 1137. For an unmapped aquifer, the aquifer name is derived from water precinct's names in common use, and lithologic or litho-stratigraphic units, e.g., Nelson Unconsolidated; Nelson Bedrock.
REDIVERSION_IND RDVRSN_ND VARCHAR2 1 REDIVERSION IND is an indicator of whether the Point of Well Diversion is, for the particular licence, used to divert water from another water source, i.e., Y or N.
QUANTITY QUANTITY NUMBER 16 QUANTITY is the maximum quantity of water that is authorized to be diverted for the purpose use, e.g., 500.
QUANTITY_UNITS QNTTY_NTS VARCHAR2 25 QUANTITY UNITS is the units of measurement for the quantity of water authorized in the licence, e.g., m3 / year.
QUANTITY_FLAG QNTTY_FLG VARCHAR2 1 QUANTITY FLAG is the code used to identify how the total quantity is assigned across multiple Points of Well Diversion (PWD) for a particular licence and purpose use, i.e., T, M, D, or P.
QUANTITY_FLAG_DESCRIPTION QNTTY_FLGN VARCHAR2 100 QUANTITY FLAG DESCRIPTION is a description of the QUANTITY FLAG code used to identify how the total quantity is assigned across multiple Points of Well Diversion (PWD) for a particular licence and purpose use, i.e., T (Total demand for purpose, one PWD); M (Maximum licensed demand for purpose, multiple PWDs, quantity at each PWD unknown); D (Multiple PWDs for purpose, quantities at each are known, PWDs on different aquifers); P (Multiple PWDs for purpose, quantities at each are known, PWDs on same aquifer).
QTY_DIVERSION_MAX_RATE QTY_DVRSNE NUMBER 25 QTY DIVERSION MAX RATE is the maximum authorized diversion rate of water within a second, minute or day up to the total licensed quantity per year, e.g, 0.006, 2000
QTY_UNITS_DIVERSION_MAX_RATE QTY_NTS_DE VARCHAR2 25 QTY UNITS DIVERSION MAX RATE are the units of measurement for the maximum diversion rate of water authorized in the licence, e.g., m3/second, m3/minute, m3/day, m3/year.
HYDRAULIC_CONNECTIVITY HYDRLC_CNY VARCHAR2 215 HYDRAULIC CONNECTIVITY is an indicator of whether the licensed aquifer diversion (PWD or PG) may be hydraulically connected to one or more surface water sources (stream or lake), i.e., Likely, Unknown.
PERMIT_OVER_CROWN_LAND_NUMBER PRMT_VR_CR VARCHAR2 15 PERMIT OVER CROWN LAND NUMBER is an Internal number assigned to a Permit over Crown Land (PCL), e.g., 12345.
PRIMARY_LICENSEE_NAME PRMRY_LCNM VARCHAR2 500 PRIMARY LICENSEE NAME is the primary contact for the licence, co-licensees will be displayed as et al.
ADDRESS_LINE_1 ADDRSS_LN1 VARCHAR2 150 ADDRESS LINE 1 is the first line of the licensee's mailing address.
ADDRESS_LINE_2 ADDRSS_LN2 VARCHAR2 150 ADDRESS LINE 2 is the second line of the licensee's mailing address.
ADDRESS_LINE_3 ADDRSS_LN3 VARCHAR2 150 ADDRESS LINE 3 is the third line of the licensee's mailing address.
ADDRESS_LINE_4 ADDRSS_LN4 VARCHAR2 150 ADDRESS LINE 4 is the fourth line of the licensee's mailing address.
COUNTRY COUNTRY VARCHAR2 26 COUNTRY is the licensee's country.
POSTAL_CODE POSTAL_CD VARCHAR2 30 POSTAL CODE is the licensee's postal code.
LATITUDE LATITUDE NUMBER 9 LATITUDE is the geographic coordinate, in decimal degrees (dd.dddddd), of the location of the feature as measured from the equator, e.g., 55.323653.
LONGITUDE LONGITUDE NUMBER 10 LONGITUDE is the geographic coordinate, in decimal degrees (-ddd.dddddd), of the location of the feature as measured from the prime meridian, e.g., -123.093544.
DISTRICT_PRECINCT_NAME DSTRCT_PRM VARCHAR2 100 DISTRICT PRECINCT NAME is a jurisdictional area within a Water District. It is a combination of District and Precinct codes and names, e.g., New Westminster / Coquitlam. Not all Water Districts contain Precincts.
SHAPE SHAPE SDO_GEOMETRY 64 SHAPE is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a column required by spatial layers that interact with ESRI ArcSDE. It is populated with unique values automatically by SDE.
SE_ANNO_CAD_DATA ANNO_CAD 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.