Ground Water Quality Zones of Total Alkalinity Concentrations in BC

282 views (4 recent)

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

Polygon features showing ground water quality zones of total alkalinity concentrations. Does not represent current or historic conditions. Retained for demonstration purposes. Do not use for any practical purpose

Data and Resources

Dataset Extent

Latitude: 49.0° to 49.1°
Longitude: -118.5° to -118.4°

Additional Information


Spatial layers intended to provide specific ground water chemistry information to assist in the management and protection of the ground water resource.

Lineage Statement

Ground water well locations are identified onto well cards by well drillers as part of the drilling process. There is no statutory requirement for well drillers to submit these records to the Government of British Columbia, therefore not all ground water wells are represented in this dataset. It is uncertain the percentage of wells that are represented, but the best estimate is around 50%. The dataset is in a constant state of update and does not stay static for any length of time. Accuracy is defined by one of five codes (see SOURCE_ACCURACY attribute description).

Contact Information

NameGround Water Group (pointOfContact)
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-06-17
Resource Status onGoing

Object Description


Short Name: GW_ALK_PLY
Comments: A spatial layer that shows the total alkalinity concentration values, measured in milligrams per litre, in groundwater. This spatial layer has polygonal features.

Column Name Short Name Data Type Data Precision Comments
TOTAL_ALKALINITY_ID TTLLKLNTD NUMBER 10 A unique identifier for the table.
AQUIFER_ID AQUIFER_ID NUMBER 5 Sequential business key maintained by the system starting at 1. If a new
FEATURE_CODE FTRCD VARCHAR2 10 A feature code is most importantly a means of linking a feature to its name and definition. For example, the code GB15300120 on a digital geographic feature links it to the name "Lake - Dry" with the definition "A lake bed from which all water has drained or evaporated." The feature code does NOT mark when it was digitized, what dataset it belongs to, how accurate it is, what it should look like when plotted, or who is responsible for updating it. It only says what it represents in the real world. It also doesn't even matter how the lake is represented. If it is a very small lake, it may be stored as a point feature. If it is large enough to have a shape at the scale of data capture, it may be stored as an outline, or a closed polygon. The same feature code still links it to the same definition.
INTERPRETED_BY NTRPRTDB VARCHAR2 50 The person who created the initial spatial layer.
TOTAL_ALKALINITY TTLLKLNT VARCHAR2 20 Groundwater Quality Zones of total alkalinity concentrations in BC.Zones of total alkalinity concentration in groundwater are determined by zoning/contouring total alkalinity concentrations of individual wells. Since wells are completed to various depths within an aquifer, the resultant map of total alkalinity concentration in groundwater is a vertically integrated representation of the total alkalinity in groundwater in that aquifer. Total alkalinity reflects the capacity of water to neutralize acid. Total alkalinity concentration also reflects the concentration of bicarbonate ions dissolved in groundwater. Bicarbonate ion is one of the major chemicals found naturally in groundwater.
WHEN_CREATED WHNCRTD DATE 7 The date and time the entry was created.
WHEN_UPDATED WHNPDTD DATE 7 The date and time the entry was last modified.
WHO_CREATED WHCRTD VARCHAR2 30 The unique id of the user who created this entry.
WHO_UPDATED WHPDTD VARCHAR2 30 The unique id of the user who last modified this entry.
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.
FEATURE_AREA_SQM AREA_SQM NUMBER 19 FEATURE_AREA_SQM is the system calculated area of a two-dimensional polygon in square meters
FEATURE_LENGTH_M FEAT_LEN NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters