Ground Water Quality Zones of Total Dissolved Solids (TDS) in BC

439 views (7 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 dissolved solids. 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

Purpose

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

Data Quality
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

NameMike Wei (pointOfContact)
EmailMike.Wei@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 2019-05-04
Resource Status onGoing

Object Description

Object Name: WHSE_WATER_MANAGEMENT.GW_TOTAL_DISSOLVED_SOLID_POLY

Short Name: GW_TDS_PLY
Comments: A spatial layer that shows the total dissolved solids (TDS) 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_DISSOLVED_SOLID_ID TTLDSSLVD1 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_DISSOLVED_SOLIDS TTLDSSLVDS VARCHAR2 20 Groundwater Quality Zones of total dissolved solids (TDS) concentrations in BC.Zones of total dissolved solids concentration in groundwater are determined by zoning/contouring total dissolved solids concentration of individual wells. Since wells are completed to various depths within an aquifer, the resultant map of total dissolved solids concentration in groundwater is a vertically integrated representation of the Total dissolved solids concentration in groundwater in that aquifer. Total dissolved solids concentration is a measure of the amount of total mineralization dissolved in the water. The higher the total dissolved solids concentration of water, the greater the amount of minerals are dissolved in the water. Total dissolved solids concentration can also reflect the presence of dissolved chemicals from human activities such as from landfills, septic waste and run-off of chemical fertilizers.Solid line - Total dissolved solids zone boundary interpretedDotted line - Total dissolved solids zone boundary assumed
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 NUMBER 19 FEATURE_AREA_SQM is the system calculated area of a two-dimensional polygon in square meters
FEATURE_LENGTH_M NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters

Comments

No comments have been posted yet.