Electrical Poles (English, CSV)

Explore the interactive map. Electrical Poles: English CSV file you can open as a table, filter, chart and export up to 10,000 rows. From City of Victoria, updated Nov 2024.

Format
CSV
Access
Table on demand (prepared when opened) and interactive map
Fields
20
Publisher-reported update
2024-11-04

An Electrical Pole is a column or post used to support electrical fixtures (e.g. streetlights and decorative lights) and related equipment. Electrical Poles data are edited in the field by our Electrical staff. Edits get copied into VicMap and our Open Data Portal on a nightly basis. The "Last Updated" date shown on our Open Data Portal refers to the last time the data schema was modified in the portal, or any changes were made to this description. We update our data through nightly scripts which does not trigger the "last updated" date to change. Note: Attributes represent each field in a dataset, and some fields will contain information such as ID numbers. As a result some visualizations on the tabs on our Open Data page will not be relevant.

Access original file

Data overview

Formats
CSV
File languages
English
Available actions
Explore table (prepared automatically) · Explore map · Access original file

Available fields (20/20)

Fields from the recorded map schema.

FieldRecorded type
PoleTypeesriFieldTypeString
OBJECTIDesriFieldTypeOID
AssetIDesriFieldTypeString
PoleIDesriFieldTypeInteger
PoleMaterialesriFieldTypeString
CommentsesriFieldTypeString
HasLightsesriFieldTypeSmallInteger
InstallDateesriFieldTypeDate
OwnedByesriFieldTypeString
CustodianesriFieldTypeString
CreatedByesriFieldTypeString
CreatedOnesriFieldTypeDate
ModifiedByesriFieldTypeString
ModifiedOnesriFieldTypeDate
DataSourceesriFieldTypeString
DecorativeTypeesriFieldTypeString
LifecycleStatusesriFieldTypeString
TotalHeightesriFieldTypeSmallInteger
JurisdictionesriFieldTypeString
SurveyRequiredesriFieldTypeSmallInteger

Sample rows

The first 10 rows, as CanQuery read them from the start of the publisher's file on 2026-11-07. Showing 20 of 22 columns.

XYOBJECTIDAssetIDPoleIDPoleTypePoleMaterialCommentsHasLightsInstallDateOwnedByCustodianCreatedByCreatedOnModifiedByModifiedOnDataSourceDecorativeTypeLifecycleStatusTotalHeight
473210.3765365897.6551EPL00313420001Type 2GalvanizedPole and base in good condition as of 202012015/07/23 18:28:43+00City of VictoriaCity of VictoriaCOV2017/03/28 22:52:00+00AGOUDINE2024/09/12 21:19:56+00APXACT
472800.2525366100.43622EPL00299220002Streetlight (one piece)SteelBase good11980/07/16 16:19:31+00City of VictoriaCityElecCOV2017/03/28 22:52:00+00BHeagle@victoria.ca2024/06/24 16:31:09+00APXACT
473099.29125365530.37588EPL00764220008Streetlight (one piece)Steel1City of VictoriaBC HydroCOV2017/03/28 22:52:00+00BHeagle@victoria.ca2023/10/10 20:20:54+00APXACT
473202.6565365938.85341EPL00313320041Type 2GalvanizedPole and base in good condition as of 202012015/07/23 18:30:12+00City of VictoriaCity of VictoriaCOV2017/03/28 22:52:00+00GISPUBLISHER2022/07/05 16:57:06+00APXACT
472814.22855366064.004442EPL00299120042Type 2SteelBase good12021/04/21 07:00:00+00City of VictoriaCity of VictoriaCOV2017/03/28 22:52:00+00GISPUBLISHER2022/07/05 16:57:06+00APXACT
472827.40545366027.962680EPL00299020082Type 2GalvanizedBase good12008/07/16 16:16:17+00City of VictoriaCity of VictoriaCOV2017/03/28 22:52:00+00GISPUBLISHER2022/07/05 16:57:06+00APXACT
472445.4185366140.917118EPL00740620121Type 7Galvanized12020/07/15 17:26:15+00City of VictoriaCity of VictoriaCOV2017/03/28 22:52:00+00AGOUDINE2024/11/08 23:07:49+00SURACT
473232.30775365526.1516384EPL00744220401Type 2Steel1City of VictoriaCity of VictoriaCOV2017/03/28 22:52:00+00GISPUBLISHER2022/07/05 16:57:06+00APXACT
474266.165365712.365385EPL00581320402Type 2GalvanizedAs of Aug 202011997/08/13 15:57:33+00City of VictoriaCity of VictoriaCOV2017/03/28 22:52:00+00GISPUBLISHER2022/07/05 16:57:06+00APXACT
473257.65825365530.8735423EPL00764020441Type 2Steel1City of VictoriaCity of VictoriaCOV2017/03/28 22:52:00+00GISPUBLISHER2022/07/05 16:57:06+00APXACT

Official sources and licences

Related open data