Lithology of Ground Water Wells

2049 views (15 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 locations of groundwater wells which have lithology recorded.
Each record in the dataset represents a lithology interval. Because each water well often has multiple lithology layers recorded, there will often be multiple points overlapped at each well location.

For the locations of all water wells in BC (without lithology), please see:
https://catalogue.data.gov.bc.ca/dataset/e4731a85-ffca-4112-8caf-cb0a96905778

NOTE: When choosing to download this GIS dataset below, there can be errors when trying to download the entire province. The large file size is a problem for the default file format (shapefile).

If you need to download the entire province, please choose a different file format (e.g. ESRI File Geodatabase).

If you need to download in shapefile format, please use an area of interest (AOI).

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Spatial layer intended to show lithologies at locations of wells which have been drilled, dug or driven in the province, to assist in the management and protection of the groundwater resource.

Data Quality

Completeness - Variable. Some wells have no lithology reported. Attribute Accuracy - For wells database: Attribute data is supplied voluntarily and no formal standard for completeness or accuracy is in place. Logical Consistency - Data has been modelled.

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

Access & Security

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

Metadata Information

Record Published 2015-01-05
Record Last Modified 2020-01-16
Resource Status onGoing

Object Description

Object Name: WHSE_WATER_MANAGEMENT.GW_WATER_WELLS_LITHOLOGY_SP

Short Name: WTR_WELL_L
Comments: The lithology intervals for all groundwater wells in BC which have lithology recorded.

Column Name Short Name Data Type Data Precision Comments
GW_WWL_SYSID GW_WWL_SYD NUMBER 10 GW_WWL_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.
LITHOLOGY_FROM LITH_FROM NUMBER 8 Depth below ground surface of the start of the lithology material for a particular lithology layer, as observed during the construction or alteration of a well, measured in feet.
LITHOLOGY_TO LITH_TO NUMBER 8 Depth below ground surface of the end of the lithology material for a particular lithology layer as observed during the construction or alteration of a well, measured in feet.
LITHOLOGY_DESCRIPTION LITH_DESCR VARCHAR2 300 Describes the standard terms used to characterize the different qualities of lithologic material, e.g. dry, loose, weathered, soft.
LITHOLOGY_MATERIAL LITH_MTRL VARCHAR2 500 Description of the material noted for lithology. E.g. Rock, Clay, Sand, Unspecified.
LITHOLOGY_COLOUR LITH_COLR VARCHAR2 100 The colour of the lithologic material identified at time of drilling, e.g. black, dark, tan, rust-coloured
LITHOLOGY_HARDNESS LITHHRDNSS VARCHAR2 100 The hardness of the material that a well is drilled into (the lithology), e.g. Very Hard, Medium, Very Soft.
LITHOLOGY_OBSERVATION LITH_OBSVN VARCHAR2 500 Free form text used by the driller to describe observations made of the well lithology including, but not limited to, the lithologic material.
LITHOLOGY_RAW_DATA LITHRWDATA VARCHAR2 500 Free form text used by the driller to describe observations made of the well lithology including, but not limited to, the lithologic material.
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 BDRCKDEPTH 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.
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 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.