Environmental Remediation Sites
1304 views (11 recent)Published by the Ministry of Environment and Climate Change Strategy - Environmental Emergencies and Land Remediation
Licensed under Access Only
Data and Resources
BC Geographic Warehouse Custom Downloadother
WMS getCapabilities requestwms
For use in viewers such as ESRI tools use this truncated link:...
KML Network Linkkml
For use in viewers such as Google Earth Click here for information on how to...
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.
|Name||Vincent Hanemayer (pointOfContact)|
|Organization||Ministry of Environment and Climate Change Strategy|
|Sub-Organization||Environmental Emergencies and Land Remediation|
Access & Security
|Who can view this dataset?||Public|
|Who can download this dataset?||Public|
|Record Last Modified||2019-05-04|
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.|
|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.|