Drinking Fountains (English, CSV)
Explore the interactive map. Drinking Fountains: English CSV file you can open as a table, filter, chart and export up to 10,000 rows. From City of Victoria, updated Nov 2024.
- Format
- CSV
- Access
- Table on demand (prepared when opened) and interactive map
- Fields
- 14
- Publisher-reported update
- 2024-11-04
Drinking Fountains. Includes regular fountains and bottle fillers. Data are updated by city staff as needed, and copied to the Open Data Portal on daily. The "Last Updated" date shown on our Open Data Portal refers to the last time the data schema was modified in the portal, or any changes were made to this description. We update our data through automated scripts which does not trigger the "last updated" date to change. Note: Attributes represent each field in a dataset, and some fields will contain information such as ID numbers. As a result some visualizations on the tabs on our Open Data page will not be relevant.
Data overview
- Formats
- CSV
- File languages
- English
- Available actions
- Explore table (prepared automatically) · Explore map · Access original file
Available fields (14/14)
Fields from the recorded map schema.
| Field | Recorded type |
|---|---|
| LocationName | esriFieldTypeString |
| OBJECTID | esriFieldTypeOID |
| InfrastructureID | esriFieldTypeString |
| LifecycleStatus | esriFieldTypeString |
| Condition | esriFieldTypeSmallInteger |
| InstallDate | esriFieldTypeDate |
| FountainType | esriFieldTypeString |
| LocationType | esriFieldTypeString |
| Owner | esriFieldTypeString |
| OwnerNotes | esriFieldTypeString |
| Custodian | esriFieldTypeString |
| CustodianNotes | esriFieldTypeString |
| Uniformat | esriFieldTypeString |
| FrostFree | esriFieldTypeString |
Sample rows
The first 10 rows, as CanQuery read them from the start of the publisher's file on 2026-11-06.
| X | Y | OBJECTID | InfrastructureID | LifecycleStatus | Condition | InstallDate | FountainType | LocationType | LocationName | Owner | OwnerNotes | Custodian | CustodianNotes | Uniformat |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 475230.2499 | 5362301.0146 | 1 | DRF2 | ACT | 4 | 2008/11/14 00:00:00+00 | Hollywood Park | VC | City of Victoria | VC | Hort Department | G2040185 | ||
| 474288.8075 | 5364303.6304 | 2 | DRF12 | ACT | 3 | 2003/06/01 00:00:00+00 | William Stevenson Memorial Park | VC | City of Victoria | VC | Hort Department | G2040185 | ||
| 474852.2169 | 5366152.8448 | 3 | DRF28 | ACT | 3 | 2015/06/01 00:00:00+00 | Clawthorpe Avenue Park | VC | City of Victoria | VC | Hort Department | G2040185 | ||
| 472854.985 | 5362214.7392 | 4 | DRF27 | ACT | 4 | 2005/12/04 00:00:00+00 | Beacon Hill Park | VC | City of Victoria | VC | Parks Department | G2040185 | ||
| 471663.0383 | 5363285.7404 | 5 | DRF6 | ACT | 4 | 2010/01/01 00:00:00+00 | Fisherman's Wharf Park | VC | City of Victoria | VC | Parks Department | G2040185 | ||
| 473148.6291 | 5362199.4942 | 6 | DRF20 | ACT | 3 | 1998/12/04 00:00:00+00 | Beacon Hill Park | VC | City of Victoria | VC | Parks Department | G2040185 | ||
| 472031.5756 | 5364507.2016 | 7 | DRF16 | ACT | 3 | 2024/06/13 00:00:00+00 | Point Ellice Park | VC | City of Victoria | VC | Parks Department | G2040185 | ||
| 473515.289 | 5362125.3038 | 8 | DRF26 | ACT | 3 | 2008/12/02 00:00:00+00 | Beacon Hill Park | VC | City of Victoria | VC | Parks Department - Hort | G2040185 | ||
| 473489.9513 | 5361744.0344 | 9 | DRF4438 | ACT | 5 | 2022/02/16 00:00:00+00 | Beacon Hill Park | VC | City of Victoria | VC | Maintained by Facilities | G2040186 | ||
| 471767.3651 | 5362362.3911 | 10 | DRF4432 | ACT | 5 | 2020/11/05 00:00:00+00 | 300 block Dallas Rd | VC | City of Victoria | VC | Public Works | G2040185 |