Environmental Remediation Sites - Internal

313 views (8 recent)

Published by the Ministry of Environment and Climate Change Strategy - Environmental Emergencies and Land Remediation
Licensed under Access Only

A layer containing data on known and potentially contaminated properties in British Columbia. A site is contaminated if its land, water and/or sediment are unsuitable for particular uses from waste that exceeds environmental quality standards. For publicly downloadable data, please use https://catalogue.data.gov.bc.ca/dataset/63804e64-a4f3-4bc7-b1e3-5f736bbc3967.

Contact BC OnLine for further details for each site.

Data and Resources

Dataset Extent

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

Additional Information


The Site Registry records information about environmental conditions for sites that have been screened, investigated or cleaned up since the recording of site maintenance began.

More Information

Contact Information

NameVincent Hanemayer (pointOfContact)
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationEnvironmental Emergencies and Land Remediation

Access & Security

Who can view this dataset? Government
Who can download this dataset?Government

Metadata Information

Record Published 2016-04-05
Record Last Modified 2021-06-12
Resource Status onGoing

Object Description


Short Name: RMDTN_S_GV
Comments: SITE_ENV_RMDTN_SITES_GOV_SVW is a spatial view consists of point representation of Environmental Remediation Sites. Remediation is the removal or neutralization of chemical substances from a site to mitigate or prevent any adverse effects. Also known as decontamination. The view exposes the site attributes stored in table SITE_GOAT.

Column Name Short Name Data Type Data Precision Comments
ENV_RMDTN_SITES_ID ENV_RMD_ID NUMBER 10 Primary unique numeric identifier for a feature.
SR_STATUS SR_STAT VARCHAR2 1 SR STATUS is a Y/N flag indicating whether this SITE should be exported (once approved) to the Site Registry (SR) system.
GENERAL_DESCRIPTION GEN_DESC VARCHAR2 255 GENERAL DESCRIPTION contains free form text used to describe the SITE. It often contains information about how the lat/long was collect such as by GPS, or from mapsheet number XYZ. It may also contain additional location information such as 13 miles up the road from the interseconf of highway 14.
VICTORIA_FILE_NO VCTR_FL_N VARCHAR2 40 VICTORIA FILE NO represents the main file number for a specific site.
REGIONAL_FILE_NO RGNL_FL_N VARCHAR2 40 REGIONAL FILE NO represents the file number of files formerly held in regional offices for a specific site. In most cases the regional files have been consolidated with the associated Victoria file.
COMMON_NAME COMMON_NM VARCHAR2 40 COMMON NAME is the name commonly used to identify the site.
ADDRESS ADDRESS VARCHAR2 232 ADDRESS stores the street name and number where known.
LATITUDE LATITUDE VARCHAR2 18 LATITUDE is the geographic coordinate, in decimal degrees (dd.dddddd), of the location of the feature as measured from the equator, e.g., 55.323653.
LONGITUDE LONGITUDE VARCHAR2 19 LONGITUDE is the geographic coordinate, in decimal degrees (dd.dddddd), of the location of the feature as measured from the prime meridian, e.g., -123.093544.
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 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.