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 Traffic Lights

Road Network Electrical Utility Traffic 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
206
Formats
5
Last updated
Nov 18, 2026
How we tidied this dataset:
  • The City's layer has 405,228 rows but only 206 distinct AssetID values: each record is repeated about 1,967 times. This demo keeps one row per AssetID (the first one).

Download & API

Transportation Traffic Lights (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
Download
Transportation Traffic Lights (GeoJSON)geojson
GeoJSON — for web maps and GIS tools
Download
Transportation Traffic Lights (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
Download
Transportation Traffic 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
Road Name
Road_Name
string
Road Segment Name
Road_Segme
string
Date of As Built
Date_of_As
string
Materialsstring5 values: STL (63), GLV (41), GALVANIZED STEEL (9)…
Ownerstring1 values: City of Port Moody (28)
Remarksstring
Statusstring1 values: OPERATIONAL (205)
Streetlight Type
Streetligh
string
Subtypestring1 values: Traffic Light (163)
AssetIDstring
GIS_THEMEstring3 values: T_LIGHTS (203), T_LIGHTS (1), T_LIGTHS (1)
MC_PKinteger57,528 to 118,669
Asset
PROPER_NAM
string4 values: Transportation Traffic Lights (164), T_LIGHTS (39), T_LIGHTS (1)…