Ground Water Quality Zones of Total Dissolved Solids (TDS) in BC
440 views (7 recent)Published by the Ministry of Environment and Climate Change Strategy - Water Protection and Sustainability
Licensed under Open Government Licence - British Columbia
Data and Resources
BC Geographic Warehouse Custom Downloadother
WMS getCapabilities requestwms
For use in viewers such as ESRI tools use this truncated link:...
KML Network Linkkml
For use in viewers such as Google Earth Click here for information on how to...
Spatial layers intended to provide specific ground water chemistry information to assist in the management and protection of the ground water resource.
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).
|Name||Mike Wei (pointOfContact)|
|Organization||Ministry of Environment and Climate Change Strategy|
|Sub-Organization||Water Protection and Sustainability|
Access & Security
|Who can view this dataset?||Public|
|Who can download this dataset?||Public|
|Record Last Modified||2019-05-04|
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|