Proof of concept.This is an unofficial demo built by Datopian from the City of Port Moody's public data. The official portal is data.portmoody.ca. Questions or feedback: hello@datopian.com

Transportation Street Lights

Road Network Electrical Utility Street Lights

City’s data disclaimer

The User acknowledges and agrees that the Data is provided by the City to the User for the User's convenience and reference, and that the City makes no guarantees, representations or warranties, whether express or implied, as to the Data or as to any results to be or intended to be achieved from use of the Data, including without limitation guarantees, representations or warranties as to the accuracy, quality or completeness of the Data, merchantability or fitness for use for any particular purpose, and the User hereby waives all guarantees, representations and warranties in respect of the Data, whether express, implied by statute or otherwise. The User hereby releases The City from, and hereby indemnifies and holds harmless The City from and against, any liability, obligation, costs (including without limitation legal costs), expenses, claims, actions, proceedings, damages and penalties to the User or any other person or legal entity resulting from or related to the use, disclosure or reproduction of or reliance on the Data.

Features
2,407
Formats
5
Last updated
Nov 18, 2026

Download & API

Transportation Street Lights (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
Download
Transportation Street Lights (GeoJSON)geojson
GeoJSON — for web maps and GIS tools
Download
Transportation Street Lights (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
Download
Transportation Street Lights (map tiles)pmtiles
Vector tiles — embed in a map
Download
Live ArcGIS layer (source)arcgis
Download

Rendered from PMTiles, queried in-browser from GeoParquet — no server. How this works

Schema

FieldTypeValues
Wattagestring
Subtypestring7 values: Street Light (2,289), Streetlight (37), Tennis Field Light (12)…
Streetlight Type
Streetlight_Type
string
Statusstring1 values: OPERATIONAL (2,403)
Road Segment Name
Road_Segment_Location
string
Road Name
Road_Name
string
Record Drawing Number
Record_Drawing_Number
string
Projectstring
Pole Height
Pole_Height
string
Pole Head Type
Pole_Head_Type
string
Pole Base Type
Pole_Base_Type
string
Pole Arm Type
Pole_Arm_Type
string
Ownerstring3 values: City of Port Moody (2,304), Translink/BCRTC/Evergreen Line (49), BC Hydro (2)
MC PK
MC_PK
integer55,271 to 118,721
Materialsstring6 values: Steel Powder (754), Steel Galvanized (605), Steel Painted (337)…
Locationstring
Light Technology
Light_Technology
string
Theme
GIS_THEME
string1 values: S_LIGHTS (2,405)
Date Pole Replaced
Date_Pole_Replaced
string
Date Pole Painted
Date_Pole_Painted
string
Date of As Built
Date_of_As_Built
string
Date Bulb Replaced
Date_Bulb_Replaced
string
Date Bulb Last Inspected
Date_Bulb_Last_Inspected
string
Control Box
Control_Box
string3 values: NO (2,129), YES (82), N (3)
Bannerstring8 values: None (1,770), Single (194), Double (148)…
AssetIDstring