Ground Water Wells

4850 views (82 recent)

Published by the Ministry of Environment and Climate Change Strategy - Water Protection and Sustainability
Licensed under Open Government Licence - British Columbia

Point features showing the location of groundwater wells in BC joined with attributes and information from the WELLS database. NOTE: Artesian wells are flowing wells at the time of drilling.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Spatial view intended to show location and other attributes of wells which have been drilled, dug or driven in the province, to assist in the management and protection of the groundwater resource.

Lineage Statement

Update to source (GWells database) and data model (updated fields) was completed January 15, 2020.

Contact Information

NameLindsay Macfarlane (businessExpert)
EmailLindsay.Macfarlane@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationWater Protection and Sustainability
NameErin McGinnis (businessExpert)
EmailErin.McGinnis@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationWater Protection and Sustainability

Access & Security

Who can view this dataset? Public
Who can download this dataset?Public

Metadata Information

Record Published 2011-03-09
Record Last Modified 2020-03-09
Resource Status onGoing

Object Description

Object Name: WHSE_WATER_MANAGEMENT.GW_WATER_WELLS_WRBC_SVW

Short Name: GW_WW_WRBC
Comments: The locations of groundwater wells in BC.

Column Name Short Name Data Type Data Precision Comments
GW_WW_SYSID GW_WW_SYSD NUMBER 10 GW_WW_SYSID is a system generated unique identification number
WELL_TAG_NUMBER WELL_TAG NUMBER 10 The file number assigned to a particular well in the in the province's Groundwater Wells and Aquifers application, e.g., 56809.
IDENTIFICATION_PLATE_NUMBER ID_PLATE NUMBER 10 Steel plate with a unique number that is attached to required wells under the groundwater protection regulations such as water supply wells, recharge or injection wells made by drilling or boring, and permanent dewatering wells, e.g., 691.
STREET_ADDRESS ADDRESS VARCHAR2 200 Street address of the property that the well is physically located on.
WELL_STATUS WELLSTATUS VARCHAR2 300 Description of the status of a well as defined in the Groundwater Protection Regulation of the Water Act, i.e. New, Abandoned, Alteration, Closure, Other.
WELL_CLASS WELL_CLASS VARCHAR2 100 Valid classification as defined in the Groundwater Protection Regulation of the Water Sustainability Act, i.e., Water Supply, Monitoring, Recharge, Injection, Dewatering, Drainage, Remediation, Geotechnical, Closed-loop geoexchange.
INTENDED_WATER_USE INTEND_USE VARCHAR2 100 The intended use of the water in a water supply well as reported by the driller at time of work completion on the well, e.g., private domestic, irrigation, water supply system, industrial commercial, unknown.
LICENCE_STATUS LIC_STATUS VARCHAR2 300 Description of valid licencing option granted to a well under the Water Water Sustainability Act. This information comes from eLicensing, i.e. Unlicensed, Licensed, Historical
WELL_DETAILS_URL WELL_URL VARCHAR2 255 Link to the well summary report within the Groundwater Wells and Aquifer (GWELLS) application, which provides the overall desription and history of the well.
ARTESIAN_IND ARTSN_IND CHAR 1 Indicates whether the well is an artesian well, i.e., Y, N.
ARTESIAN_FLOW ARTSN_FLW NUMBER 8 Measurement of the artesian well*s water flow that occurs naturally due to inherent water pressure in the well. Pressure within the aquifer forces the groundwater to rise above the land surface naturally without using a pump. Flowing artesian wells can flow on an intermittent or continuous basis. Measured in US Gallons/minute.
ARTESIAN_FLOW_UNITS ARTSNUNITS VARCHAR2 300 The unit of measure for the artesian flow.
ARTESIAN_PRESSURE ARTSN_PRSS NUMBER 8 Pressure of the water coming out of an artesian well as measured at the time of well construction, measured in PSI (pounds per square inch).
FINISHED_WELL_DEPTH FNSH_DEPTH NUMBER 8 The depth at which the well was 'finished', measured in units of feet bgl (below ground level), e.g. 157.0. It can be shallower than the total well depth which is the total depth at which the well was drilled.
BEDROCK_DEPTH BDRCKDPTH NUMBER 8 Depth below ground level at which bedrock starts, measured in feet, e.g. 132.0.
YIELD YIELD NUMBER 8 An approximate estimate of the capacity of the well to produce groundwater. Estimated by the well driller during construction by conducting a well yield test.
YIELD_UNITS YLD_UNITS VARCHAR2 100 The unit of measure used for the well yield. As of April 2019 well yields are reported in U.S. Gallons per Minute. Prior to April 2019, well yield units vary or are unknown, e.g., U.S. Gallons per Minute, Gallons per Hour (U.S./Imperial), Dry Hole, Unknown Yield.
STATIC_WATER_LEVEL STATIC_LVL NUMBER 8 The level (depth below ground) to which water will naturally rise in a well without pumping, measured in feet, e.g. 280.0
DIAMETER DIAMETER NUMBER 8 The diameter of the casing of the well, measured in inches, e.g. 6.62. There can be multiple casings in a well, e.g. surface casing, and production casing. Diameter of casing made available to the public is generally the production casing.
AQUIFER_ID AQUIFER_ID NUMBER 10 System generated unique sequential number assigned to each mapped aquifer. The aquifer ID identifies which aquifer a well is in. An aquifer can have multiple wells, while a single well can only be in one aquifer.
OBSERVATION_WELL_NUMBER OBSWELLNUM VARCHAR2 30
OBSERVATION_WELL_STATUS OBSWELLSTS VARCHAR2 10
GEOMETRY GEOMETRY SDO_GEOMETRY 64 GEOMETRY 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 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.