Ground Water Quality Zones of Nitrate-Nitrogen Concentrations in BC
265 views (4 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_NITRATE_NITROGEN_POLY
Short Name: GW_NNC_PLY
Comments: A spatial layer that shows the level to which water rises in a well with reference to a datum such as sea level. This spatial layer has polygonal features.
|Column Name||Short Name||Data Type||Data Precision||Comments|
|NITRATE_NITROGEN_ID||NTRTNTRGND||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.|
|NITRATE_NITROGEN||NTRTNTRGN||VARCHAR2||20||Shows the areas of Nitrate-nitrogen concentrations are based on actual analyses of well water samples. Zones of nitrate-nitrogen concentration in groundwater are determined by zoning / contouring nitrate-nitrogen concentrations of individual wells. Since wells are completed to various depths within an aquifer, the resultant map of nitrate-nitrogen concentration in groundwater is a vertically integrated representation of the nitrate-nitrogen in groundwater in that aquifer.Nitrate-nitrogen is a chemical not normally found in elevated concentrations in groundwater. Areas of elevated nitrate-nitrogen may indicate areas of where groundwater has been impacted by human activities such as leaching of chemical fertilizers, manure, and/or sewage effluent.|
|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|