BC Environmental Monitoring Locations

935 views (17 recent)

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

Environmental Monitoring Stations (EMS) spatial points coverage for the Province by LOCATION TYPES.

The following spatial layers reference this as a data source:

  1. Environmental Monitoring - All Stations
  2. Environmental Monitoring Stations - Air Monitoring (Ambient Air Site)
  3. Environmental Monitoring Stations - Air Monitoring (Air Permit)
  4. Environmental Monitoring Stations - Water Sites (Water Monitoring)
  5. Environmental Monitoring Stations - Water Sites (Water Permits)
  6. Environmental Monitoring Stations - Water Sites (Well)
  7. Environmental Monitoring Stations - Water Sites (Observation Well)
  8. Environmental Monitoring Stations - Water Sites (Spring)

Data and Resources

Dataset Extent

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

Additional Information

Lineage Statement

To enable the ability to filter locations with samples and results, or locations related to a permit, the following additional attributes were added May 18, 2018.

  1. First Sample Date
  2. Last Sample Date
  3. Sample Count
  4. Result Count
  5. Permit ID
  6. Permit Relationship

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-08-01
Resource Status onGoing

Object Description

Object Name: WHSE_ENVIRONMENTAL_MONITORING.EMS_MONITORING_LOCN_TYPES_SVW

Short Name: EMS_MLOCTY
Comments: EMS_MONITORING_LOCN_TYPES_SVW is a spatial view joining EMS BC monitoring location geometry with EMS monitoring location data.

Column Name Short Name Data Type Data Precision Comments
MONITORING_LOCATION_ID MNTRNG_ID VARCHAR2 7 MONITORING_LOCATION_ID is the unique identifier of the monitoring location. This is a seven character code that matches the AEMS_TAG field in the BC_ENV_MONITOR_LOCNS table, e.g. E102624.
CLIENT_LOCATION_ID CLNT_LC_ID NUMBER 10 CLIENT_LOCATION_ID is an identifier to uniquely identify a physical location of a client of the Ministry.
CONTAMINATED_SITE_ID CNT_STE_ID NUMBER 10 CONTAMINATED_SITE_ID is the SITE system contaminated site identifier.
DISCHARGE_MEDIA_CD DSCHRG_MED VARCHAR2 6 DISCHARGE_MEDIA_CD is a numeric code to uniquely identify the enviromnental resource being discharged to.
ECO_REGION_CD ECOREG_CD VARCHAR2 6 ECO_REGION_CD is a unique identifier for an ecological region. Examples: 02, 50.
GEOREFERENCE_SOURCE_CD GEOR_SR_CD VARCHAR2 6 GEOREFERENCE_SOURCE_CD is the unique identifier for the georeference source. Examples: M1:50, G1:20
LOCATION_PURPOSE_CD LOC_PRPSD VARCHAR2 6 LOCATION_PURPOSE_CD is a classification of the intended purpose of a monitoring location.
LOCATION_TYPE_CD LOC_TY_CD VARCHAR2 6 LOCATION_TYPE_CD is a code used to categorize a monitoring location with respect to the major environmental resource that is monitored, It is equivalent to SEAM Site Type.
OFFICE_CD OFFICE_CD VARCHAR2 6 OFFICE_CD is a code to uniquely identify a Region/Region Office of the Ministry. Examples: AR, 50.
SOURCE_CLASS_CD SRC_CLSS_D VARCHAR2 8 SOURCE_CLASS_CD is the source classification code, e.g., 10500106, 11640.
WATERSHED_CD WTRSHD_CD VARCHAR2 45 WATERSHED_CD is a code to uniquely identify a Watershed in the Province of British Columbia (External to EMS). Examples: 1002419005540070100, 100317400.
CALC_STATISTICS_IND CALC_STAT VARCHAR2 1 CALC_STATISTICS_IND is an indicator whether statistics for a monitoring location will be calculated, i.e., Y or N.
LOCATION_AREA_IND LOC_IND VARCHAR2 1 LOCATION_AREA_IND indicates whether or not a location is an area or discrete point for samples collected, i.e., Y or N.
MOBILE_LOCATION_IND MBL_LOC_I VARCHAR2 1 MOBILE_LOCATION_IND is an indicator to show whether a monitoring location is mobile or not, i.e., Y or N
CLOSED_DATE CLOSED_DT DATE 7 CLOSED_DATE is the date that a monitoring location was closed.
DESCRIPTION DESCRPTN VARCHAR2 255 DESCRIPTION is a detailed description of the monitoring location.
ELEVATION ELEVATION NUMBER 6 ELEVATION is the elevation of the monitoring location expressed in metres above sea level.
ESTABLISHED_DATE ESTBL_DT DATE 7 ESTABLISHED_DATE is the date that a monitoring location was established.
LATITUDE LATITUDE NUMBER 8 LATITUDE is the geographic coordinate, in decimal degrees (dd.dddddd), of the location of the monitoring station as measured from the equator, e.g., 55.323653.
LONGITUDE LONGITUDE NUMBER 9 LONGITUDE is the geographic coordinate, in decimal degrees (-ddd.dddddd), of the location of the monitoring station as measured from the prime meridian, e.g., -123.093544.
LEGAL_DESCRIPTION LGL_DSCRPN VARCHAR2 255 LEGAL_DESCRIPTION provides the legal description for the monitoring location.
MONITORING_LOCN_COMMENT MNTR_LOC VARCHAR2 1000 MONITORING_LOCN_COMMENT is a comment relavent to the monitoring location.
MONITORING_LOCATION_NAME MNTR_LOC_N VARCHAR2 75 MONITORING_LOCATION_NAME IS the descriptive name of the monitoring location, e.g., "TAHSIS CO PUMPHOUSE, GOLD R", "PORT ALBERNI AT HEALTH UNIT:.
SOURCE_CLASS_NARRATIVE SRC_CLSS_N VARCHAR2 255 SOURCE_CLASS_NARRATIVE provides a description of the source classification if a source classification code is not suitable.
WELL_IDENTIFICATION_PLATE_NO WELLID_PNO VARCHAR2 10 The Groundwater Protection Regulation of the Water Act requires a WELL IDENTIFICATION PLATE NO for water supply system wells and new and altered water supply wells. WLAP (British Columbia Ministry of Water, Land and. Air Protection ) produces these aluminum plates with a unique number for each plate. These plates are attached to the pump house or well by the drillers. Existing wells can have these plates attached after the fact, especially if any lab samples or other information is being collected about the well. This number is used for groundwater well monitoring locations.
FIRST_SAMPLE_DATE FRT_SMP_DT DATE 7 FIRST_SAMPLE_DATE is the date of the first sample available in EMS for this monitoring location.
LAST_SAMPLE_DATE LST_SMP_DT DATE 7 LAST_SAMPLE_DATE is the date of the most recent sample available in EMS for this monitoring location.
SAMPLE_COUNT SMPL_CNT NUMBER 38 SAMPLE_COUNT is the number of samples for this monitoring location.
RESULT_COUNT RSLT_CNT NUMBER 38 RESULT_COUNT is the number of results for this monitoring location.
PERMIT_ID PERMIT_ID NUMBER 38 PERMIT_ID is the permit number associated with this monitoring location, if applicable.
PERMIT_RELATIONSHIP PRMT_RLSHP VARCHAR2 180 PERMIT_RELATIONSHIP is the type of monitoring associated with the permit, e.g., CONTROL, DISCHARGE, INITIAL DILUTION ZONE, PERMIT IMPACT ASSESSMENT.
FEATURE_CODE FEATURE_CD 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 ANNO_CAD 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.