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

Polygon features showing ground water quality zones of nitrate-nitrogen 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

Purpose

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

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_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