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

Sanitary Cap

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
52
Formats
5
Last updated
Nov 18, 2026

Download & API

Sanitary Cap (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
Download
Sanitary Cap (GeoJSON)geojson
GeoJSON — for web maps and GIS tools
Download
Sanitary Cap (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
Download
Sanitary Cap (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
Agestring
Conditionstring
Criticalitystring
Date of As Built
Date_of_As_Built
string9 values: Jun 10, 2022 (7), Apr 05, 2018 (2), Apr 19, 2019 (1)…
Expected Life
Expected_Life
string
Locationstring
Materialsstring
Old Agresso Parent ID
Old_Agresso_Parent_ID
string
Ownerstring3 values: City of Port Moody (16), Private (5), GVSDD (1)
Performancestring
Physical Description
Physical_Description
string
Projectstring6 values: R.F. Binnie & Associates Ltd_17-0576 (7), 2018_NoonsCreekLiftStation (2), Core Concept Consulting_16071 (1)…
Record Drawing Number
Record_Drawing_Number
string7 values: SA720 (7), SA692 (2), DA823 (1)…
Remaining Life
Remaining_Life
string
Remarksstring4 values: Service Connection (2), As per OPS field observations (1), Ops installed in field (1)…
Replacement Cost
Replacement_Cost
string
Replacement Value
Replacement_Value
string
Statusstring2 values: OPERATIONAL (47), ABANDONED (3)
Status Date
Status_Date
string
Status Drawing Number
Status_Drawing_Number
string
Subtypestring1 values: Cap (29)
Unit Rate
Unit_Rate
string
AssetIDstring
Theme
GIS_THEME
string2 values: S_FEATURES (49), S_FEATURES Abandoned (3)
LAYERstring1 values: SSNCP (52)
MC PK
MC_PK
integer3,193 to 117,633
PROPER_NAMEstring2 values: S_FEATURES (49), S_FEATURES Abandoned (3)