Environmental Remediation Sites

1315 views (14 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.

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

Purpose

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.

Lineage Statement

Formally WHSE_WASTE.SITE_ENV_REMEDIATION_SITES_SVW

Contact Information

NameVincent Hanemayer (pointOfContact)
EmailVincent.Hanemayer@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationEnvironmental Emergencies and Land Remediation

Access & Security

Who can view this dataset? Public
Who can download this dataset?Public

Metadata Information

Record Published 2014-12-11
Record Last Modified 2019-05-04
Resource Status onGoing

Object Description

Object Name: WHSE_WASTE.SITE_ENV_RMDTN_SITES_SVW

Short Name: RMDTN_STS
Comments: SITE_ENV_RMDTN_SITES_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 NUMBER 10 Primary unique numeric identifier for a feature.
SITE_ID SITE_ID NUMBER 38
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 VICFILENO VARCHAR2 40 VICTORIA FILE NO represents the main file number for a specific site.
REGIONAL_FILE_NO REGFILENO 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 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 S_NN_CD_DT 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.