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

470 views (1 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 division (regional district) 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_CD

Short Name: EMP_SEC_CD
Comments: This dataset contains counts of employment by industry sector and place of work, aggregated to census division (regional district) 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_CD_ID NUMBER 10 EMPLOYMENT BY SECTOR CD ID is a system generated unique identification number.
CENSUS_YEAR NUMBER 4 CENSUS YEAR is the census year to which CENSUS DIVISION ID pertains. e.g., 2006, 2011. With CENSUS DIVISION ID, this forms a foreign key linking to CENSUS YEAR + CENSUS DIVISION ID in CEN CENSUS SUBDIVISIONS SP
CENSUS_DIVISION_ID VARCHAR2 4 CENSUS DIVISION ID together with CENSUS YEAR is used to form a foreign Key, linking to CENSUS YEAR + CENSUS DIVISION ID in CEN CENSUS DIVISIONS SP, e.g., 5901. With CENSUS YEAR, this identifies the census district for which the numbers apply.
AGRIFOODS_EMPLYMNT_COUNT NUMBER 10 AGRIFOODS EMPLYMNT COUNT is count of employment (by place of work (census division)) in the agrifoods sector (i.e., food and beverage harvest and manufacture), e.g., 975
FORESTRY_EMPLYMNT_COUNT NUMBER 10 FORESTRY EMPLYMNT COUNT is count of employment (by place of work (census division)) 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 (census division)) 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 (census division)) 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 (census division)) in the transportation sector. e.g., 975
AGRIFOODS_PCT_SECTOR NUMBER 4 AGRIFOODS PCT SECTOR is Regional share (in percent) of employment (by place of work (census division)) 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 (census division)) 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 (census division)) 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
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.