Hazardous waste hauling companies

149 views (1 recent)

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

names, addresses, and geographic locations of hazardous waste hauling companies in British Columbia.

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_HAULERS

Short Name: E_HAZ_WA_H
Comments: HAZRDOUS WASTE HAULER contains names, addresses, and geographic locations of hazardous waste hauling companies in British Columbia

Column Name Short Name Data Type Data Precision Comments
HAZRDOUS_WASTE_HAULER_ID HZRDS_W_ID NUMBER 38 HAZRDOUS WASTE HAULER 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 hazardous waste hauler is located.
HAULER_COMPANY_NAME HLR_CMPNYM VARCHAR2 100 HAULER COMPANY NAME: Company name of the hazardous waste hauler, e.g., Advantage Waste Specialties Inc.
DISPATCH_LOCATION_ADDRESS DSPTCH_LCS VARCHAR2 100 DISPATCH LOCATION ADDRESS: Street address of the hazardous waste hauler dispatch location, e.g., 20334 56th Ave
DISPATCH_LOCATION_MUNICIPALITY DSPTCH_LCY VARCHAR2 100 DISPATCH LOCATION MUNICIPALITY: Closest municipality to the hazardous waste hauler dispatch location, e.g., Langley
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