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

(This layer is an instantiation of the spatial view GW_WATER_WELLS_LITHOLOGY_SVW.)

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 2019-09-05
Resource Status onGoing

Object Description

Object Name: WHSE_WATER_MANAGEMENT.GW_WATER_WELLS_LITHOLOGY_SP

Short Name: WTR_WELL_L
Comments: GW_WATER_WELLS_LITHOLOGY_SP contains Province-wide SDE spatial layer joining the GW_WATER_WELLS spatial layer to the well lithology in GW_WELLS_LITHOLOGY_MVW and other attribute data from GW_WELLS_WRBC_MVW and GW_AQUIFER_WELLS. The lithology attributes describe the lithology (soil layers) that the well is constructed into from the ground surface to the bottom of the Overburden layer (also known as Lithological layer). The Overburden layer is any unconsolidated materials that overlie bedrock (examples: clay, silt, sand, gravel, and boulders).This layer is an instantiation of the spatial view GW_WATER_WELLS_LITHOLOGY_SVW.

Column Name Short Name Data Type Data Precision Comments
WATER_WELL_LITHOLOGY_ID WW_LITH_ID NUMBER 10 The WATER WELLS LITHOLOGY ID is a system generated identifier to ensure row uniqueness.
WELL_TAG_NO WELLTAGNO VARCHAR2 12 The unique number of the groundwater well as assigned by
LITHOLOGY_FROM LITH_FROM NUMBER 7 The LITHOLOGY FROM is the start of the measure of the lithology material from the ground surface for a particular lithology layer.
LITHOLOGY_TO LITH_TO NUMBER 7 The LITHOLOGY TO is the End lithology measurement of the lithology material from the ground surface for a particular lithology layer.
TOTAL_DEPTH TOTL_DEPTH NUMBER 9 The TOTAL DEPTH is the Total depth of lithology
LITHOLOGY_MEASURE_UNIT LITH_UNIT VARCHAR2 10 The LITHOLOGY MEASURE UNIT is Feet or inches default expected for measurement unit used with the lithology measurements for a lithology layer.
AQUIFER_LITHOLOGY_CODE AQFR_LTHLD VARCHAR2 10 The AQUIFER LITHOLOGY CODE is the Aquifer lithology identifier, enables lithology layers to be indentified by a short reference.
RELATIVE_HARDNESS_CODE HARDN_CODE VARCHAR2 10 The RELATIVE HARDNESS CODE is a unique recognizable code that represents the hardness of the soil and subsurface material that a well is drilled into (the lithology). Some examples of relative hardness include Very hard, Hard, Dense, Stiff, Medium, Loose, Soft, Very soft.
LITHOLOGY_COLOUR_DESCRIPTION LITHCLRDES VARCHAR2 255 LITHOLOGY COLOUR DESCRIPTION is a description of the lithology colour. Examples include black, blue, brown, etc.
LITHOLOGY_DESCRIPTION_ID LITH_ ID NUMBER 10 The LITHOLOGY DESCRIPTION ID is the Unique ID for lithology description.
LITHOLOGY_DESCRIPTION_COUNT LITH_COUNT VARCHAR2 101 Number of Lithology layers identified.
LITHOLOGY_DESCRIPTION LITH_DESCR VARCHAR2 255 LITHOLOGY DESCRIPTION is the description of lithology.
LITHOLOGY_MATERIAL_DESCRIPTION LITHMATDES VARCHAR2 255 LITHOLOGY MATERIAL DESCRIPTION is a qualitative description of the type of the lithology material. Examples include overburden, organic matter, and top soil.
LITHOLOGY_MATERIAL_CODE LITHMAT_CD VARCHAR2 10 The LITHOLOGY MATERIAL CODE is Material noted for lithology. Rock, Clay, Sand are some potential examples. This field is not an actively being used.
LITHOLOGY_RAW_DATA LITH_RAW VARCHAR2 100 The LITHOLOGY RAW DATA is Text data for raw lithology information.
LITHOLOGY_EDITED_DATA LITHEDITED VARCHAR2 10 The LITHOLOGY EDITED DATA is the edited data of the original driller's lithological description stored in LITHOLOGY RAW DATA.
LITHOLOGY_OBSERVATIONS LITHOBSERV VARCHAR2 100 LITHOLOGY OBSERVATIONS is a 100 character text field required to store the LITHOLOGY information imported from the MS-Access application.
OVERBURDEN_DEPTH OVBR_DEPTH NUMBER 9 The OVERBURDEN DEPTH is the depth from the ground surface to the bottom of the Overburden layer (also known as Lithological layer). The Overburden layer is any unconsolidated materials that overlie bedrock (examples: clay, silt, sand, gravel, and boulders).
WELL_ID WELL_ID NUMBER 10 The WELL ID is the unique identifier for the well the lithology describes.
LITHOLOGY_CODE LITH_CODE VARCHAR2 10 The LITHOLOGY CODE describes the lithology, besides the material and colour that are handled by two other code tables. Codes for this table have not been defined.
LITHOLOGY_SEQUENCE_NUMBER LITHSEQ_NO NUMBER 10 The LITHOLOGY SEQUENCE NUMBER is the Sequence number of the layer in respect to the other Lithology layers.
WELL_IDENTIFICATION_PLATE_NO WLLIDPLTNO NUMBER 10 The Groundwater Protection Regulation of the Water Act requires a WELL IDENTIFICATION PLATE NO for water supply system wells and new and altered water supply wells. WLAP produces these aluminum plates with a unique number for each plate. These plates are attached to the pump house or well by the drillers. Existing wells can have these plates attached after the fact, especially if any lab samples or other information is being collected about the well.
WHERE_PLATE_ATTACHED WHEREPLTAT VARCHAR2 500 The WHERE PLATE ATTACHED is a description of where the identification plate has been attached. The Groundwater Protection Regulation of the Water Act requires this information for water supply system wells and new and altered water supply wells.
PLATE_ATTACHED_BY PLTATTCHBY VARCHAR2 80 The PLATE ATTACHED BY is the name of the person who attached the WELL IDENTIFICATION PLATE. The Groundwater Protection Regulation of the Water Act requires this information for water supply system wells and new and altered water supply wells.
OBSERVATION_WELL_NUMBER OBSWELL_NO NUMBER 3 The OBSERVATION WELL NUMBER exists when a well has been selected for monitoring. An Observation well will have water level readings recorded to track groundwater levels
MINISTRY_OBSERVATION_WELL_STAT OBSWELL_ST VARCHAR2 25 Ministry of Water Land and Air Protection, formerly (Ministry of Environment) observation
CHEMISTRY_SITE_ID CHMSTRY_ID VARCHAR2 10 Chemistry site ID number, assigned by water EMS (environmental management system)
CLASS_OF_WELL CLSS_F_WLL VARCHAR2 30 The CLASS OF WELL is a classification defined in the Groundwater Protection Regulation of the Water Act. The classes are: Water Supply, Monitoring, Recharge / Injection, Dewatering / Drainage, Remediation, Geotechnical.
WELL_USE_NAME WELLUSE_NM VARCHAR2 255 Long well use name. Examples may include private, commercial, domestic.
WATER_SUPPLY_SYSTEM_NAME WTRSUPSYNM VARCHAR2 80 The WATER SUPPLY SYSTEM NAME is the name of a Utility under the Water Act. The Utility has applied and been granted a licence to be a Water Supply Purveyor. This data is only filled in when the well is owned by a Utility. E.g. Parksville Water Utility.
WATER_SUPPLY_WELL_NAME WTRSUPWLNM VARCHAR2 80 The WATER SUPPLY WELL NAME is the Utilitys name for this well. This is used when the well is owned by a Utility under the Water Act. The Utility has applied and been granted a licence to be a Water Supply Purveyor. This data is only filled in when the well is owned by a Utility. E.g. Parksville Water Utility calls one of its wells Roberts Road Well No. 5
CONTRACTOR_WELL_PLATE_NMBR CNTRCTR_WR VARCHAR2 50 The Contractor may assign well plate number to a WELL. If the driller uses one of the WLAP identification plate, then this number may be the same as the WELL_IDENTIFICATION_PLATE_NO. Sometimes drillers have their own plates made up and this number is different.
OWNERS_WELL_NUMBER OWNRWELLNO VARCHAR2 20 Local WELL number applied by owner for internal tracking.
SURNAME SURNAME VARCHAR2 100 Last Name of WELL owner.
SITE_STREET SITE_STR VARCHAR2 100 Well location, address (well) description of where well is outside additional well information
SITE_AREA SITE_AREA VARCHAR2 50 Town or nearest describable geographic area.
LOT_NUMBER LOT_NO VARCHAR2 10 Parcels of land in B.C. can be identified by the combination of Lot, Legal Land District and Map # identifiers. This attribute consists of the Lot to help identify the property where the WELL is located.
LEGAL_PLAN LEGAL_PLAN VARCHAR2 20 Parcels of land in B.C. can be identified by the combination of Lot, Legal Land District and Plan # identifiers. This attribute consists of the Legal Plan to help identify the property where the WELL is located.
LEGAL_DISTRICT_LOT LGL_DISTLT VARCHAR2 20 The LEGAL DISTRICT LOT is part of the legal description of the land the well is located on. Example 2514S
LEGAL_BLOCK LGL_BLCK VARCHAR2 5 Additional parcels identifiers for land in B.C. include Legal block.
QUARTER QUARTER VARCHAR2 2 Additional parcels identifiers for land in B.C. include Legal quarter.
LEGAL_SECTION LGL_SECTN VARCHAR2 5 Additional parcels identifiers for land in B.C. include Legal section.
LEGAL_TOWNSHIP LGL_TOWNSH VARCHAR2 20 Additional parcels identifiers for land in B.C. include Legal township.
LEGAL_RANGE LGL_RANGE VARCHAR2 5 Additional parcels identifiers for land in B.C. include legal range.
MERIDIAN MERIDIAN VARCHAR2 20 The MERIDIAN indicates if the location of the well is east or west of the 6th meridian which runs North-South. The meridian is part of a legal description for land in British Columbia. Example W6TH - the well is west of the 6th meridian.
PID PID NUMBER 10 Parcel Identifier, identifies parcel where well is located.
LEGAL_LAND_DISTRICT_NAME LGL_LDDIST VARCHAR2 255 The LEGAL LAND DISTRICT NAME is part of the legal description of the land the well is located on. Example CHEMAINUS. Alberni Barclay Bright Cameron Cariboo Cassiar Cedar Chemainus Clayoquot Coast Range 1 Coast Range 2 Coast Range 3 Coast Range 4 Coast Range 5 Comiaken Comox Cowichan Cowichan Lake Cranberry Douglas Dunsmuir Esquimalt Goldstream Helmcken Highland Kamloops (KDYD) Kootenay Lake Lillooet Malahat Metchosin Mountain Nanaimo Nanoose Nelson Newcastle New Westminster Nootka North Saanich Osoyoos (ODYD) Otter Oyster Peace River Quamichan Queen Charlotte Renfrew Rupert Sahtlam Sayward Seymour Shawnigan Similkameen Somenos Sooke South Saanich Texada Island Victoria Wellington Yale (YDYD)
SITE_ISLAND SITE_ISLND VARCHAR2 50 If the well is located on an Island, record the Island name.
INDIAN_RESERVE INDN_RSRVE VARCHAR2 10 Additional parcels identifiers for land in B.C. include Legal Indian Reserve.
WELL_LOCATION WELL_LOCTN VARCHAR2 255 Location description used in the MS-Access application.
LEGAL_MISCELLANEOUS LGL_MISC VARCHAR2 255 Additional legal land information.
BCGS_NUMBER BCGS_NMBR VARCHAR2 20 Mapsheets are based on the British Columbia Geographic System (BCGS) number scheme. The mapsheet number is added to the well record after the well record has been added in the system.
SEQUENCE_NO SEQ_NO NUMBER 15 SEQUENCE_NO is a number which describes the order a particular well is located in a particular BCGS grid square. For example the well 082L042321 #1is the first well located in BCGS grid 082L042321. Before a system generated non-intelligent WELL TAG NUMBER was in use this is how particular wells were named.
ELEVATION ELEVATION NUMBER 10 The ELEVATION is the elevation above sea level in feet of the ground surface at the WELL.
UTM_ZONE_CODE UTM_ZN_CD VARCHAR2 10 The UTM ZONE CODE is the unique recognizable code that represents the Universal Transverse Mercator (UTM) zone coordinates which can be used in the location specification for a well. BC contains 5 UTM zones these are 7, 8,9,10 and 11.
UTM_EAST UTM_EAST NUMBER 6 The UTM EAST attribute stored in the spatial database and associated with the WELL TAG NUMBER coordinated.
UTM_NORTH UTM_NORTH NUMBER 7 The UTM NORTH attribute stored in the spatial database and associated with the WELL TAG NUMBER coordinated.
UTM_ACCURACY_CODE UTM_ACC_CD VARCHAR2 10 A description of how accurate the UTM coordinate position is. Also implies scale to the coordinate. Codes are numeric 01 etc.... 01 - less than 3 metres margin of error 02 - 3-10 metres margin of error 03 - 10-30 metres margin of error 04 - 30-100 metres margin of error 1:25 000 scale 05 - 100-300 metres margin of error 1:50 000 scale 06 - 300-1000 metres margin of error 1:125 000 scale 07 - 1000-3000 metres margin of error 1:250 000 scale 08 - 3000-10 000 metres margin of error 09 - well location is unknown 10 - UTM Zone 10 from 1:50 000 scale 30-100 metres moe. 11 - UTM Zone 11 from 1:50 000 scale 30-100 metres
CONSTRUCTION_METHOD_NAME CNSTRCTN_M VARCHAR2 255 The CONSTRUCTION METHOD NAME is the method of constructing the well. Example DRILLED indicates a drill rig was used to construct the well. Indicates the industry trends in well construction methods.
TYPE_OF_RIG RIG_TYPE VARCHAR2 20 Type of RIG (drilling hardware) used during the creation of the WELL.
DIAMETER DIAMETER VARCHAR2 9 Well diameter, represented in units of inches.
DEPTH_WELL_DRILLED DPTH_WLL_D NUMBER 7 Finished Well depth, represented in units of feet bgl (below ground level).
BEDROCK_DEPTH BDRCK_DPTH NUMBER 7 Capture the depth at which bedrock starts.
WATER_DEPTH WATERDEPTH NUMBER 7 Water depth, how far down the well before water is reached.
DEVELOPMENT_HOURS DVLPMNT_HS NUMBER 9 Total hours devoted to develop WELL (develop in this means enabling production of water)
DEVELOPMENT_NOTES DVLPMNT_NS VARCHAR2 255 Additional notes regarding well development effort.
YIELD_UNIT_CODE YIELDUNTCD VARCHAR2 10 Yield unit of measure, unique code. The MS-Access database expects flow rates to be entered as USgpm.
YIELD_VALUE YIELDVALUE NUMBER 8 Well yield value, measured water yield amount, estimate how much water flow a WELL is capable of sustaining.
ARTESIAN_FLOW_VALUE ARTSN_FLWE NUMBER 7 The ARTESIAN FLOW VALUE is the Artesian water flow measurement of the flow that occurs naturally due to inherent water pressure in the WELL. The measurement is in ARTESIAN FLOW UNITS
SURFACE_SEAL_DEPTH SRFCSLDPTH NUMBER 5 The SURFACE SEAL DEPTH indicates depth of surface seal which is depth in feet below ground surface to bottom of Surface Seal.
SURFACE_SEAL_THICKNESS SRFCSLTHCK NUMBER 7 A "surface seal" means a sealant placed in the annular space around the outside of the outermost well casing and between multiple well casings and extending to or just below the ground surface. Good practice is a sealant with a minimum thickness of 1 inch, minimum length of 15 feet and extending a minimum of 3 feet into bedrock.
GRAVEL_PACKED_FROM GRVL_PCKDM NUMBER 7 Indicates degree gravel dispersed around WELL site.
GRAVEL_PACKED_TO GRVL_PCKDO NUMBER 7 Indicates degree gravel dispersed around WELL site.
SCREEN_LENGTH SCRNLENGTH VARCHAR2 101 The SCREEN LENGTH is the total length of the screen assembly, including blanks and risers. (feet) . Most screens are cylindrical in shape.
SCREEN_INFORMATION_TEXT SCRN_INFO VARCHAR2 255 Additional information regarding the screen.
GENERAL_REMARKS GNRL_RMRKS VARCHAR2 2000 General water well comment
CONSTRUCTION_START_DATE CNSTRCTN_E DATE 7 Date when WELL construction was started.
CONSTRUCTION_END_DATE CNSTRCTN_E DATE 7 Date when WELL construction was complete, defaults to date the well record was added to the system.
AQUIFER_ID AQUIFER_ID NUMBER 5 Sequential business key maintained by the system starting at 1.
TRANSMISSIVITY TRNSMSSVTY NUMBER 10 The TRANSMISSIVITY is the product of the hydraulic conductivity and the saturated thickness of the aquifer. It is a measure of how much water can be transmitted horizontally through a unit width of a fully saturated aquifer under a hydraulic gradient (slope of the groundwater level) of 1.0. Transmissivity values can be expressed as square metres per day (m2/day), or as square metres per second (m2/s).
STORATIVITY STRTVTY NUMBER 10 The STORATIVITY or storage coefficient is the amount of water stored or released per unit area of aquifer given unit change in head. The equations for estimating storativity are different for confined and unconfined aquifers.
CHEMISTRY_LAB_DATA CHMSTRY_LA VARCHAR2 1 Chemistry lab data exists. (flag), lab data exists usually tied to chemistry site id.
DRILLER_COMPANY_NAME DRLLR_CMPM VARCHAR2 255 Drillers may work for a company. Record the company name here.
CREW_DRILLER_NAME CRW_DRLLRM VARCHAR2 50 The CREW DRILLER NAME is the first and last name of a certified water well Driller.
CREW_HELPER_NAME CRW_HLPR_M VARCHAR2 50 Name of Driller Helper.
CONSULTANT_COMPANY CNSLTNT_CY VARCHAR2 100 Description of consulting company hired by owner to locate well site.
CONTRACTOR_INFO_1 CNTRCTR_N1 VARCHAR2 255 Field from MS Access database used to store additional contractor information.
LITHOLOGY_FLAG LITH_FLAG VARCHAR2 1 The LITHOLOGY FLAG indicates if there is Lithology data available for the well. Y - yes the soil and subsurface material types have been documented. N - the lithology is not documented.
GRAVEL_PACKED_FLAG GRVL_PCKDG VARCHAR2 1 Indicated whether a gravel pack was applied during the creation of the WELL.
SURFACE_SEAL_FLAG SRFCSLFLAG VARCHAR2 1 The SURFACE SEAL FLAG indicates if a surface seal was applied upon completion of WELL.Y- yes surface seal was constructed. N- no surface seal was applied. Blank is unknown
PERFORATION_FLAG PERF_FLAG VARCHAR2 1 The PERFORATION FLAG indicates if the steel casing has been perforated by a hydraulic shear. Perforations improve flow to the bottom of the well. Some wells have been perforated rather than having a screen installed. Perforations do not consider soil size. Y- Yes there are holes in the casing. N- no additional holes in casing.
PRODUCTION_TIDAL_FLAG PRODTIFLAG VARCHAR2 1 Indicates if production well rates are influenced by tidal activity.
PUMP_FLAG PUMP_FLAG VARCHAR2 1 Indicates a pump is being used on the WELL.
REPORTS_FLAG RPRTS_FLAG VARCHAR2 1 The REPORTS FLAG indicates if there is a report on the National Topographical System (NTS) filing system or the utility files(which are reports submitted in support of an application for a certificate of PUBLIC CONVENIENCE AND NECESSITY). Y yes Well Report(s) Exist. N - no reports exist
SCREEN_FLAG SCRN_FLAG VARCHAR2 4 Depicts the use of a screen(s) in a WELL. Indicates at least 1 SCREEN record is associated with the WELL record.
WATER_UTILITY_FLAG WTRUTLFLAG VARCHAR2 1 Some wells belong to water utilities for provision of water to their.
SITE_FLAG SITE_FLAG VARCHAR2 9 Indicated site inspection was done.
WHEN_CREATED WHENCREATE DATE 7 The date and time the entry was created.
WHEN_UPDATED WHENUPDATE DATE 7 The date and time the entry was last modified.
WHO_CREATED WHOCREATED VARCHAR2 30 The unique id of the user who created this entry.
WHO_UPDATED WHOUPDATED VARCHAR2 30 The unique id of the user who last modified this entry.
FEATURE_CODE FEATURE_CD VARCHAR2 10 FEATURE CODE contains a value based on the Canadian Council of Surveys and Mapping's (CCSM) system for classification of geographic features.
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 required attribute of feature classes and object classes in a geodatabase.
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.