BC Environmental Monitoring Location Groups

387 views (5 recent)

Published by the Ministry of Environment and Climate Change Strategy - Knowledge Management
Licensed under Open Government Licence - British Columbia

Environmental monitoring stations (EMS) points coverage for the Province by MONITORING LOCATION GROUPS.

Data and Resources

Dataset Extent

Latitude: 48.0° to 60.0°
Longitude: -139.5° to -113.5°

Additional Information

Purpose

This provides easy access to the spatial coverage of environmental monitoring stations which can be filtered by the monitoring group of interest.

More Information

Contact Information

NameRobert Gibson (pointOfContact)
EmailRobert.Gibson@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationKnowledge Management
NameEMS Helpdesk (pointOfContact)
EmailEMSHELP@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationKnowledge Management
NameRobert Williams (pointOfContact)
EmailRobert.Williams@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationKnowledge Management

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-07
Resource Status onGoing

Object Description

Object Name: WHSE_ENVIRONMENTAL_MONITORING.EMS_MONITORING_LOCN_GROUPS_SVW

Short Name: MON_LOC_GR
Comments: EMS_MONITORING_LOCN_GROUPS_SVW is a spatial view joining EMS BC Monitoring Location geometry with EMS Monitoring Groups.

Column Name Short Name Data Type Data Precision Comments
MONITORING_GROUP_ID MON_GRP_ID NUMBER 6 MONITORING_GROUP_ID is a unique number assigned by the system to distinguish a Monitoring Group. This is a numeric value from the EMS_MONITORING_GROUPS table, and is populated by a database trigger pulling the next value from a sequence.
DESCRIPTION DESCR VARCHAR2 765 DESCRIPTION is a detailed description of the Monitoring Group.
GROUP_NAME GROUP_NAME VARCHAR2 180 GROUP_NAME is a short descriptive name of the Monitoring Group. Examples: MURRAY CREEK FRBC, SICAMOUS CREEK FRBC.
OFFICE_CD OFFICE_CD VARCHAR2 18 OFFICE_CD is a code to uniquely identify a Region/Region Office of the Ministry. Examples: AR, 50.
AEMS_TAG AEMS_TAG VARCHAR2 7 AEMS_TAG is a unique identifier for an environmental monitoring station. This is a seven character code from the BC_ENV_MONITOR_LOCNS table. Example: 'E102624'
FEATURE_CODE FCODE VARCHAR2 10 FEATURE CODE is a standard alphanumeric code to identify the type of feature represented by the spatial data. 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.
GEOMETRY GEOMETRY SDO_GEOMETRY 64 GEOMETRY is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a column required by spatial layers that interact with ESRI ArcSDE. It is populated with unique values automatically by SDE.
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.