Community Utility Companies

235 views (2 recent)

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

This dataset is a list of electrical, natural gas, telephone and cable companies that serve the included communities. The coverage areas are derived from Integrated Cadastral Information Society (ICIS) utility infrastructure mapping and Ministry of International Trade research. Use with caution and contact providers directly for property based service information. This dataset contains links to https://catalogue.data.gov.bc.ca/dataset/british-columbia-utilities-and-sample-average-rate-charges and https://catalogue.data.gov.bc.ca/dataset/british-columbia-utilities-and-sample-average-rate-charges

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

BC Ministry of International Trade research; Integrated Cadastral Information Society, 2015

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_UTILITY_SERVICE_AREAS

Short Name: UTL_SRV_AR
Comments: Lists electrical, natural gas, telephone and cable companies that serve the included communities. The coverage areas are derived from Integrated Cadastral Information Society (ICIS) utility infrastructure mapping and Ministry of International Trade research. Use with caution and contact providers directly for property based service information.

Column Name Short Name Data Type Data Precision Comments
UTILITY_SERVICE_AREA_ID NUMBER 10 UTILITY_SERVICE_AREA_ID: is a system generated unique identification number. This is the primary key of this table. e.g., 1
CENSUS_YEAR NUMBER 4 CENSUS_YEAR: is the census year to which the 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 VARCHAR2 7 CENSUS_SUBDIVISION_ID: With CENSUS_YEAR, this forms a foreign Key, linking to CENSUS_YEAR + CENSUS_SUBDIVISION_ID in CEN_CENSUS_SUBDIVISIONS_SP, e.g., 5901022
CLAB_ID VARCHAR2 14 CLAB_ID: is a Canada Lands Administrative Boundary (CLAB) unique identifier. e.g., 00009. This is a foreign key to WHSE_ADMIN_BOUNDARIES.CLAB_INDIAN_RESERVES.
ENERGY_UTILITY_ELECTRIC_ID NUMBER 2 ENERGY_UTILITY_ELECTRIC_ID: is an ID of electrical utility that serves the given community. e.g., 1. This is a foreign key to ENERGY_UTILITY_ID in ECON_ENERGY_UTILITIES_TBL
ENERGY_UTILITY_GAS_ID NUMBER 2 ENERGY_UTILITY_GAS_ID: is an ID of gas utility that serves the community. e.g., 2 This is a foreign key to ENERGY_UTILITY_ID in ECON_ENERGY_UTILITIES_TBL
TELECOMM_UTILITY_PHONE_ID NUMBER 2 TELECOMM_UTILITY_PHONE_ID: is an ID of primary phone company that serves the community. e.g., 1 This is a foreign key to TELECOMM_UTILITY_ID in ECON_TELECOMM_UTILITIES_TBL
TELECOMM_UTILITY_CABLE_ID NUMBER 2 TELECOMM_UTILITY_CABLE_ID: is an ID of primary cable company that serves the community. e.g., 2 This is a foreign key to TELECOMM_UTILITY_ID in ECON_TELECOMM_UTILITIES_TBL