Points of Well Diversion - Applications - Internal

184 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 active applications for Groundwater licence Points of Well Diversion (PWD) joined with Groundwater licence information. This layer contains a record for each Groundwater licence application on each PWD that exists in the province (each PWD can have multiple licence applications). For each record, some basic information about the Groundwater water licence application is included. This dataset has been replaced by the following:

Water Rights Applications - Internal: WHSE_WATER_MANAGEMENT.WLS_WATER_RIGHTS_APPLICTNS_SP

For public access of the Water Rights Applications WHSE_WATER_MANAGEMENT.WLS_WATER_RIGHTS_APPLICTNS_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 locations of applications for groundwater rights at each proposed point of well diversion, as licensed under the Water Sustainability Act, along with some basic information about the Groundwater water licence application.

Data Quality

If an application has been granted in part or in full, it will no longer be visible in the Points of Well Diversion - Applications layer, but will appear in the Points of Well Diversion - Licences layer. If an application is refused it will appear within the Points of Well Diversion - Applications layer as refused with a different color than active applications.

The only applications that appear on this layer, are those that have been received and reviewed by FrontCounter BC and submitted to Water Management. Applications that are still in progress with FrontCounter BC do not appear in this layer.

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-10-18
Record Last Modified 2019-02-12
Resource Status obsolete
Replacement Recordhttps://catalogue.data.gov.bc.ca/dataset/f3a53d7f-da09-4726-ac83-f0032e4bd490

Object Description

Object Name: WHSE_WATER_MANAGEMENT.WLS_PWD_APPLICATIONS_SP

Short Name: PWD_APPL_I
Comments: Groundwater well locations of points of well diversions (PWD) for authorization applications. Each PWD can have multiple authorization applications.

Column Name Short Name Data Type Data Precision Comments
PWD_APPLICATION_ID PWD_APP_ID NUMBER 10 PWD APPLICATION ID is a system generated unique identifier number.
APPLICATION_JOB_NUMBER APP_JB_NUM VARCHAR2 40 APPLICATION JOB NUMBER is a unique identifier for a ground water licence application, e.g. 1003202.
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 applications associated with it.
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 applications.
APPLICATION_STATUS APP_STATUS VARCHAR2 50 APPLICATION STATUS is the status of the water rights application submitted by the applicant. There are two possible statuses: Active Application, if the application is undergoing adjudication; or Refused, if the application is complete but no licence was granted. When an application is granted as a licence it is removed from the applications dataset and added to the licences dataset.
WELL_TAG_NUMBER WELLTAGNUM NUMBER 14 WELL TAG NUMBER is a unique well identifier for either registered or licensed wells, e.g., 12345.
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.
PRIVATE_CONTACT_INFO_IND PVT_IND VARCHAR2 1 PRIVATE CONTACT INFO IND is an indicator of whether the applicant is a private landowner, i.e., Y or N.
PRIMARY_APPLICANT_NAME PRM_APPLNT VARCHAR2 500 PRIMARY APPLICANT NAME is the primary contact for the application, co-applicants will be displayed as et al.
ADDRESS_LINE_1 ADDRESSLN1 VARCHAR2 150 ADDRESS LINE 1 is the first line of the applicant's mailing address.
ADDRESS_LINE_2 ADDRESSLN2 VARCHAR2 150 ADDRESS LINE 2 is the second line of the applicant's mailing address.
ADDRESS_LINE_3 ADDRESSLN3 VARCHAR2 150 ADDRESS LINE 3 is the third line of the applicant's mailing address.
ADDRESS_LINE_4 ADDRESSLN4 VARCHAR2 150 ADDRESS LINE 4 is the fourth line of the applicant's mailing address.
COUNTRY COUNTRY VARCHAR2 25 COUNTRY is the applicant's country.
POSTAL_CODE POSTL_CODE VARCHAR2 10 POSTAL CODE is the applicant'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.