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

Water Fountains

Water Fountains in Port Moody both display and drinking fountains

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. Specific information regarding land, including lot sizes, legal descriptions, and charges must be confirmed at the Land Title Office and the User must not rely on the City of Port Moody for this information.

Features
20
Formats
5
Last updated
Aug 27, 2025

Download & API

Water Fountains (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
Download
Water Fountains (GeoJSON)geojson
GeoJSON — for web maps and GIS tools
Download
Water Fountains (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
Download
Water Fountains (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
All_Season_Frost_Freestring3 values: No (13), Yes (3), NO (1)
Bottle_Refill_Stationstring3 values: No (14), Yes (2), NO (1)
Commentsstring3 values: with Metal bowl (2), 3-way fountain (1), brand new multipurpose fountain (1)
Foot_Bathstring4 values: No (8), Yes (7), NO (1)…
Locationstring
Location_Descriptionstring
Materialsstring4 values: Steel (13), Mixed (2), Aluminum (1)…
Ownerstring1 values: City of Port Moody (20)
Record_Drawing_Numberstring
Sizestring6 values: 3ft x 2ft (10), 3ft x 3ft (1), 3ft x2ft (1)…
Statusstring1 values: OPERATIONAL (20)
Status_Datestring
Status_Drawing_Numberstring
Structurestring2 values: Stand Alone (17), Wall Mount (1)
Stylestring4 values: Metal Stand (11), Aggregate Stone Wrap (2), Open Bowl (2)…
Subtypestring4 values: Drinking Fountain (17), Display Fountain (1), Hose Bib (1)…
Typestring1 values: Fountain (19)
AssetIDstring
GIS_THEMEstring2 values: Drinking Fountain (19), Display Fountain (1)
LAYERstring1 values: FTN (20)
PROPER_NAMEstring2 values: Drinking Fountain (19), Display Fountain (1)