Employment by industry sector and place of work, aggregated to census economic region

301 views (8 recent)

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

Counts of employment by industry sector and place of work, aggregated to census economic region in British Columbia. Also contained in the datasets are sector’s shares of regional employment (by sector and region) and regional share of employment in a sector, by sector and region.

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/)

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-08-29
Resource Status completed

Object Description

Object Name: WHSE_HUMAN_CULTURAL_ECONOMIC.ECON_EMPLOYMENT_BY_SECTOR_ER

Short Name: EMP_SEC_ER
Comments: This dataset contains counts of employment by industry sector and place of work, aggregated to census economic region in British Columbia. Also contained in the datasets are sector’s shares of regional employment (by sector and region) and regional share of employment in a sector, by sector and region.

Column Name Short Name Data Type Data Precision Comments
EMPLOYMENT_BY_SECTOR_ER_ID NUMBER 10 EMPLOYMENT BY SECTOR ER ID is a system generated unique identification number.
CENSUS_YEAR NUMBER 4 CENSUS YEAR is the census year to which ECONOMIC REGION ID pertains. e.g., 2006, 2011. With ECONOMIC REGION ID, this forms a foreign key linking to CENSUS YEAR + ECONOMIC REGION ID in CEN ECONOMIC REGIONS SP
ECONOMIC_REGION_ID VARCHAR2 4 ECONOMIC REGION ID together with CENSUS YEAR is used to form a foreign Key, linking to CENSUS YEAR + ECONOMIC REGION ID in CEN ECONOMIC REGIONS SP, e.g., 5910. With CENSUS YEAR, this identifies the economic region to which the numbers apply.
TOURISM_EMPLYMNT_COUNT NUMBER 10 TOURISM EMPLYMNT COUNT is count of employment (by place of work (economic region)) in the agrifoods sector (i.e., food and beverage harvest and manufacture), e.g., 975
AGRIFOODS_EMPLYMNT_COUNT NUMBER 10 AGRIFOODS EMPLYMNT COUNT is count of employment (by place of work (economic region)) in the tourism sector, e.g., 975
FORESTRY_EMPLYMNT_COUNT NUMBER 10 FORESTRY EMPLYMNT COUNT is count of employment (by place of work (economic region)) in the forest sector (logging, silviculture, wood and paper manufacturing). e.g., 975
MINING_ENERGY_EMPLYMNT_COUNT NUMBER 10 MINING ENERGY EMPLYMNT COUNT is count of employment (by place of work (economic region)) in the mining and energy sector (excluding oil and gas extraction). e.g., 975
OIL_NATURAL_GAS_EMPLYMNT_COUNT NUMBER 10 OIL NATURAL GAS EMPLYMNT COUNT is count of employment (by place of work (economic region)) in the oil and gas extraction sector., e.g., 975
TRANSPORTATION_EMPLYMNT_COUNT NUMBER 10 TRANSPORTATION EMPLYMNT COUNT is count of employment (by place of work (economic region)) in the transportation sector. e.g., 975
TOURISM_PCT_SECTOR NUMBER 4 TOURISM PCT SECTOR is Regional share of employment (by place of work (economic region)) in the tourism sector. e.g., 12.2
HIGH_TECH_PCT_SECTOR NUMBER 4 HIGH TECH PCT SECTOR is Regional share (in percent) of employment (by place of work (economic region)) in the high technology sector. e.g., 12.2
AGRIFOODS_PCT_SECTOR NUMBER 4 AGRIFOODS PCT SECTOR is Regional share (in percent) of employment (by place of work (economic region)) in the agrifoods sector (i.e., food and beverage harvest and manufacture). e.g., 12.2
FORESTRY_PCT_SECTOR NUMBER 4 FORESTRY PCT SECTOR is Regional share (in percent) of employment (by place of work (economic region)) in the forest sector (logging, silviculture, wood and paper manufacturing). e.g., 12.2
MINING_ENERGY_PCT_SECTOR NUMBER 4 MINING ENERGY PCT SECTOR is Regional share (in percent) of employment (by place of work (economic region)) in the mining and energy sector (excluding oil and gas extraction). e.g., 12.2
OIL_NATURAL_GAS_PCT_SECTOR NUMBER 4 OIL NATURAL GAS PCT SECTOR is Regional share (in percent) of employment in the oil and gas extraction sector. e.g., 12.2
TRANSPORTATION_PCT_SECTOR NUMBER 4 TRANSPORTATION PCT SECTOR is Regional share (in percent) of employment in the transportation sector. e.g., 12.2
TOURISM_PCT_REGION NUMBER 4 TOURISM PCT REGION is Tourism sector’s share (in percent) of regional employment. e.g., 12.2
HIGH_TECH_PCT_REGION NUMBER 4 HIGH TECH PCT REGION is High technology sector’s share (in percent) of regional employment. e.g., 12.2
AGRIFOODS_PCT_REGION NUMBER 4 AGRIFOODS PCT REGION is Agrifood (i. e.g., 12.2e. e.g., 12.2, food and beverage harvest and manufacture) sector’s share (in percent) of regional employment. e.g., 12.2
FORESTRY_PCT_REGION NUMBER 4 FORESTRY PCT REGION is Forest (logging, silviculture, wood and paper manufacturing) sector’s share (in percent) of regional employment. e.g., 12.2
MINING_ENERGY_PCT_REGION NUMBER 4 MINING ENERGY PCT REGION is Mining and energy (excluding oil and gas extraction) sector’s share (in percent) of regional employment. e.g., 12.2
OIL_NATURAL_GAS_PCT_REGION NUMBER 4 OIL NATURAL GAS PCT REGION is Oil and natural gas extraction sector’s share (in percent) of regional employment. e.g., 12.2
TRANSPORTATION_PCT_REGION NUMBER 4 TRANSPORTATION PCT REGION is Transportation sector’s share (in percent) of regional employment. e.g., 12.2
OBJECTID NUMBER 38 OBJECTID is a column required by spatial layers that interact with ESRI ArcSDE. It is populated with unique values automatically by SDE.