Points of Well Diversion - Licences - Internal

205 views (2 recent)

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

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

Water Rights Licences - Internal: WHSE_WATER_MANAGEMENT.WLS_WATER_RIGHTS_LICENCES_SP

For public access of the Water Rights Licences: WHSE_WATER_MANAGEMENT.WLS_WATER_RIGHTS_LICENCES_SV

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 groundwater rights points of well diversion (PWD), as licensed under the Water Sustainability Act, along with the licence information.

Data Quality
Lineage Statement

Contact Information

NameSusan Waldock (custodian)
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? Government
Who can download this dataset?Government

Metadata Information

Record Published 2017-07-25
Record Last Modified 2019-02-12
Resource Status obsolete
Replacement Recordhttps://catalogue.data.gov.bc.ca/dataset/c0491e4d-9961-47c8-aa9b-98e29b1a9251
Spatial DataSDO_GEOMETRY

Object Description

Object Name: WHSE_WATER_MANAGEMENT.WLS_PWD_LICENCES_SP

Short Name: PWD_LIC_I
Comments: Groundwater well locations of points of well diversions (PWD) for licences. Each PWD can have multiple licences, both historical and current.

Column Name Short Name Data Type Data Precision Comments
PWD_LICENCE_ID PWD_LIC_ID NUMBER 10 PWD LICENCE ID is a system generated unique identifier number.
PWD_NUMBER PWD_NUM VARCHAR2 10 PWD NUMBER is the unique identifier for a Point of Well Diversion, e.g., PW189413. Each PWD can have multiple licences associated with it.
PWD_STATUS PWD_STATUS VARCHAR2 10 PWD STATUS is the status of the Point of Well Diversion (PWD). Each PWD can have multiple licences, e.g., Active (one or more active licences associated), Inactive (only historical inactive licences associated).
FILE_NUMBER FILE_NUM 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 WELLTAGNUM NUMBER 14 WELL TAG NUMBER is a unique well identifier for either registered or licensed wells, e.g., 12345.
LICENCE_NUMBER LIC_NUM VARCHAR2 12 LICENCE NUMBER is the authorization number referenced in the water licence document, e.g., 121173.
LICENCE_STATUS LIC_STATUS VARCHAR2 30 LICENCE STATUS represents the existing status of licence, e.g., Current, Cancelled, Pending.
LICENCE_STATUS_DATE LIC_STATDT DATE 7 LICENCE STATUS DATE indicates the last time the licence status changed.
PRIORITY_DATE PRIORTY_DT 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 EXPIRY_DT DATE 7 EXPIRY DATE is the date the licence expires.
PURPOSE_USE_CODE PRP_USE_CD VARCHAR2 5 PURPOSE USE CODE is the use of water authorized by the licence, identified as a code, e.g., 02I.
PURPOSE_USE PRP_USE VARCHAR2 100 PURPOSE USE is the use of water authorized by the licence, e.g. Industrial.
AQUIFER_NAME AQUIFER_NM VARCHAR2 100 AQUIFER NAME is the aquifer from which the licence is authorized to extract water. 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 REDIV_IND 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 Q_UNITS VARCHAR2 25 QUANTITY UNITS is the units of measurement for the quantity of water authorized in the licence, e.g., m3 / year.
QUANTITY_FLAG Q_FLAG 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 Q_FLAG_DSC 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).
HYDRAULIC_CONNECTIVITY HYD_CONNCT VARCHAR2 215 HYDRAULIC CONNECTIVITY is an indicator of whether the licensed aquifer source may be hydraulically connected to one or more surface water sources (stream or lake), i.e., Likely, Unknown.
PERMIT_OVER_CROWN_LAND_NUMBER PCL_NUM VARCHAR2 15 PERMIT OVER CROWN LAND NUMBER is an Internal number assigned to a Permit over Crown Land (PCL), e.g., 12345.
PRIVATE_CONTACT_INFO_IND PVT_IND VARCHAR2 1 PRIVATE CONTACT INFO IND is an indicator of whether the licensee is a private landowner, i.e., Y or N.
PRIMARY_LICENSEE_NAME PRM_LCNSEE VARCHAR2 500 PRIMARY LICENSEE NAME is the primary contact for the licence, co-licensees will be displayed as et al.
ADDRESS_LINE_1 ADDRESSLN1 VARCHAR2 150 ADDRESS LINE 1 is the first line of the licensee's mailing address.
ADDRESS_LINE_2 ADDRESSLN2 VARCHAR2 150 ADDRESS LINE 2 is the second line of the licensee's mailing address.
ADDRESS_LINE_3 ADDRESSLN3 VARCHAR2 150 ADDRESS LINE 3 is the third line of the licensee's mailing address.
ADDRESS_LINE_4 ADDRESSLN4 VARCHAR2 150 ADDRESS LINE 4 is the fourth line of the licensee's mailing address.
COUNTRY COUNTRY VARCHAR2 25 COUNTRY is the licensee's country.
POSTAL_CODE POSTL_CODE VARCHAR2 10 POSTAL CODE is the licensee's postal code.
LATITUDE LAT 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 LONG 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 DST_PRC_NM 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 1 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.