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 Mains

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,885
Formats
5
Last updated
Nov 17, 2026

Download & API

Sanitary Mains (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
Download
Sanitary Mains (GeoJSON)geojson
GeoJSON — for web maps and GIS tools
Download
Sanitary Mains (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
Download
Sanitary Mains (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
Date_of_As_Builtstring
Date_of_Rehabstring11 values: Oct 07, 2007 (49), Jul 28, 2017 (6), Apr 30, 2009 (5)…
Locationstring7 values: 525 Ioco Road (2), Heritage Peak Rd (2), Mount Royal Court (2)…
MH_Downstream_Invert_Elev
MH_Downstream_Invert_Elevation
string
MH_Downstream_Namestring
MH_Upstream_Invert_Elev
MH_Upstream_Invert_Elevation
string
MH_Upstream_Namestring
Ownerstring9 values: City of Port Moody (2,260), GVSDD (236), Private (198)…
Pipe_Diameterstring
Pipe_Lengthstring
Pipe_Materialstring
Pipe_Slopestring
Projectstring
Record_Drawing_Numberstring
Record_Draw_Num_Rehab
Record_Drawing_Number_of_Rehab
string5 values: DA784 (4), SA701 (3), DA785 (2)…
Remarksstring
Statusstring2 values: OPERATIONAL (2,840), ABANDONED (39)
Status_Datestring
Status_Drawing_Numberstring12 values: RA2360 (2), SA601 (2), SA693 (2)…
Subtypestring6 values: Forced Main (67), Siphon (18), Ioco Siphon (16)…
AssetIDstring
GIS_KEYstring
GIS_THEMEstring9 values: S_PIPES (2,206), S_PIPES Private (257), S_PIPES GVS&DD (213)…
LAYERstring1 values: SSNMN (2,885)
MC_PKinteger2,376 to 118,683
PROPER_NAMEstring9 values: S_PIPES (2,206), S_PIPES Private (257), S_PIPES GVS&DD (213)…