Hazardous waste facilities

247 views (3 recent)

Published by the Ministry of Jobs, Trade and Technology - International Marketing
Licensed under Access Only

Names, addresses, and geographic locations of hazardous waste facilities in BC.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Application-specific for the Trade and Invest British Columbia website (https://www.britishcolumbia.ca/)

Lineage Statement

Data source: British Columbia Environment Industry Association http://www.hazwastebc.com/

Contact Information

Access & Security

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

Metadata Information

Record Published 2016-06-17
Record Last Modified 2019-05-04
Resource Status completed

Object Description

Object Name: WHSE_HUMAN_CULTURAL_ECONOMIC.ECON_HAZRDOUS_WASTE_FACILITIES

Short Name: E_HAZ_WA_F
Comments: HAZRDOUS WASTE FACILITY contains names, addresses, and geographic locations of hazardous waste facilities in BC.

Column Name Short Name Data Type Data Precision Comments
HAZRDOUS_WASTE_FACILITY_ID HZRDS_W_ID NUMBER 10 HAZRDOUS WASTE FACILITY ID is a system generated unique identification number, e.g., 1
CENSUS_YEAR CNSS_YR NUMBER 4 CENSUS YEAR is the census year to which CENSUS SUBDIVISION ID pertains. e.g., 2006, 2011. With CENSUS SUBDIVISION ID, this forms a foreign key linking to CENSUS YEAR + CENSUS SUBDIVISION ID in CEN CENSUS SUBDIVISIONS SP
CENSUS_SUBDIVISION_ID CNSS_SB_ID VARCHAR2 7 CENSUS SUBDIVISION ID together with CENSUS YEAR is used to form a foreign Key, linking to CENSUS YEAR + CENSUS SUBDIVISION ID in CEN CENSUS SUBDIVISIONS SP, e.g., 5901022. With CENSUS YEAR, this identifies the community in which the waste facility is located.
FACILITY_COMPANY_NAME FCLTY_CMPM VARCHAR2 100 FACILITY COMPANY NAME: Name of the company that owns the hazardous waste facility, e.g., New West Energy Services Inc., Bearstone Environmental Solutions Inc.
FACILITY_ADDRESS FCLTY_DDRS VARCHAR2 100 FACILITY ADDRESS: Street address of the hazardous waste facility, e.g., 4623 Byrne Rd
FACILITY_CLOSEST_MUNICIPALITY FCLTY_CLSY VARCHAR2 100 FACILITY MUNICIPALITY: Closest municipality that the facility is located, e.g., Fort St. John
FACILITY_REGIONAL_DISTRICT FCLTY_RGNT VARCHAR2 100 FACILITY REGIONAL DISTRICT: Regional District that the facility operates within, e.g., Metro Vancouver
DATA_PUBLICATION_YEAR DT_PBLCTNR NUMBER 4 DATE PUBLICATION YEAR: The year in which the source of the information in this table was published, e.g., 2014
LATITUDE LATITUDE NUMBER 8 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 NUMBER 9 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