Open Data Catalogue

Drinking Fountains data

Data custodian

Parks and Recreation, Engineering Services Water Design

Data currency comments

The extract for this dataset is updated weekly. There may be no change in data content from one week to the next because there is no change in source data. Priorities and resources will also determine how fast a change in reality is reflected in the database.

Data set description

This dataset includes locations of permanent and temporary public drinking fountains (and bottle filling station) in the City that are managed by Parks and Recreation and Engineering Services Water Design departments.

Data accuracy comments

The locations shown are approximate locations of the fountains.

There is no known error. This data set is manually maintained by respective business departments


  • MAPID: Unique identifier for each drinking fountain
  • LATITUDE: Latitude of specified drinking fountain measured from the equator in degrees, with positive values going north and negative values going south. Follows World Geodetic System 84 (WGS 84) standard.
  • LONGITUDE: Longitude of specified drinking fountain measured in degrees from the Zero Meridian (which is the longitude that runs through Greenwich, England), with positive values going east and negative values going west. Follows World Geodetic System 84 (WGS 84) standard.
  • NAME: Name of drinking fountain location or facility where the specified drinking fountain is located at.
  • LOCATION: Additional location information or direction of the drinking fountain at an intersection
  • MAINTAINER: Department responsible to maintain specified public drinking fountain
  • IN_OPERATION: Time period when the drinking fountain is in operation
  • PET_FRIENDLY: Yes/No (Y/N) indication if the drinking fountain is pet-friendly

Websites for further information

Coordinate system

DWG, SHP, TIF, Mr. SID, and ECW formatted data are projected in UTM Zone 10, NAD83 (CSRS). KML, CSV, and XLS formatted data are in latitude and longitude (WGS84). Not all CSV and XLS files have latitude and longitude

Data set details


Field may be blank if related information is not available