BC Hydro Facility Points

444 views (5 recent)

Published by the BC Agency - BC Hydro and Power Authority
Licensed under Access Only

Point locations of BC Hydro facility locations.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

To determine where BC Hydro facility locations are. To be used for small scale mapping purposes.

Lineage Statement

Data is sourced from a quarterly download of data from BC Hydro and then updated to the warehouse

Contact Information

NameSarah Balabanov (businessExpert)
EmailSarah.Balabanov@bchydro.com
OrganizationBC Agency
Sub-OrganizationBC Hydro and Power Authority
NameGeoBC Inquiries (distributor)
EmailGeoBCInfo@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationGeoBC
NameJoy Sinnett (pointOfContact)
EmailJoy.Sinnett@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationGeoBC

Access & Security

Who can view this dataset? Government
Who can download this dataset?Government

Metadata Information

Record Published 2014-12-15
Record Last Modified 2019-04-04
Resource Status onGoing

Object Description

Object Name: WHSE_IMAGERY_AND_BASE_MAPS.DRP_BCHYDRO_FACILITY_PNTS_SP

Short Name: DRPBCHDRF1
Comments: This feature represents the locations of BC Hydro facilities using point geometry.

Column Name Short Name Data Type Data Precision Comments
BCHYDRO_FACILITY_PNT_ID BCHDRFCLTP NUMBER 10 BCHYDRO FACILITY PNT ID: is a surrogate primary key populated by a trigger and sequence.
FACILITY_NAME FCLTNM VARCHAR2 60 FACILITY NAME: contains the name the facility.
FACILITY_CODE FCLTCD VARCHAR2 9 FACILITY CODE: this is a three character code used to identify the facility e.g. BTA, SMV, etc.
FACILITY_TYPE FCLTTP VARCHAR2 254 FACILITY TYPE: contains the type of the electrical complex e.g. substation, electric area, hydroelectric, complex
GEOMETRY GEOMETRY SDO_GEOMETRY 1 GEOMETRY is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a required attribute of feature classes and object classes in a geodatabase.
SE_ANNO_CAD_DATA BLOB 4000 SE_ANNO_CAD_DATA is a binary column used by spatial tools to store annotation, curve features and CAD data when using the SDO_GEOMETRY storage data type.