Storm Drain Facilities (English, CSV)
Explore the interactive map. Storm Drain Facilities: 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
- 20
- Publisher-reported update
- 2024-11-04
Stormwater facilities may temporarily collect and move stormwater. e.g. a stormwater pump station is a collection tank with a submersible pump at the bottom. Stormwater is pumped to the discharge point rather than relying on gravity. Data are updated by city staff as needed, and automatically copied to the Open Data Portal. 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 (20/20)
Fields from the recorded map schema.
| Field | Recorded type |
|---|---|
| Name | esriFieldTypeString |
| OBJECTID | esriFieldTypeOID |
| InfrastructureID | esriFieldTypeString |
| dfaSubtype | esriFieldTypeSmallInteger |
| InstallDate | esriFieldTypeDate |
| Jurisdiction | esriFieldTypeString |
| OwnedBy | esriFieldTypeString |
| LifecycleStatus | esriFieldTypeString |
| DataSource | esriFieldTypeString |
| Custodian | esriFieldTypeString |
| CustodianNotes | esriFieldTypeString |
| ModifiedBy | esriFieldTypeString |
| ModifiedOn | esriFieldTypeDate |
| Comments | esriFieldTypeString |
| DrawingNumber | esriFieldTypeString |
| WaterType | esriFieldTypeString |
| AssetID | esriFieldTypeString |
| CreatedBy | esriFieldTypeString |
| CreatedOn | esriFieldTypeDate |
| Underground | esriFieldTypeSmallInteger |
Sample rows
The first 6 rows, as CanQuery read them from the start of the publisher's file on 2026-11-06. Showing 20 of 23 columns.
| OBJECTID | InfrastructureID | dfaSubtype | Name | InstallDate | Jurisdiction | OwnedBy | LifecycleStatus | DataSource | Custodian | CustodianNotes | ModifiedBy | ModifiedOn | Comments | DrawingNumber | WaterType | AssetID | CreatedBy | CreatedOn | Underground |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 1 | Shakespeare Pump Station | 1991/01/01 00:00:00+00 | VC | VC | ACT | APX | VC | CartegraphIntegration | 2024/01/18 22:02:04+00 | STM | DFA000001 | GIS | 2020/12/16 22:12:41+00 | ||||
| 2 | 2 | 1 | St Charles Pump Station | 1992/01/01 00:00:00+00 | VC | VC | ACT | APX | VC | CartegraphIntegration | 2024/02/15 18:43:31+00 | STM | DFA000002 | GIS | 2020/12/16 22:12:41+00 | ||||
| 3 | 3 | 1 | San Jose Pump Station | 1994/01/01 00:00:00+00 | VC | VC | ACT | APX | VC | CartegraphIntegration | 2024/01/18 22:02:46+00 | STM | DFA000003 | GIS | 2020/12/16 22:12:41+00 | ||||
| 4 | 4 | 1 | Eberts Pump Station | 1991/01/01 00:00:00+00 | VC | VC | ACT | APX | VC | AGOUDINE | 2024/07/11 22:24:55+00 | UG-621 | STM | DFA000004 | GIS | 2020/12/16 22:12:41+00 | |||
| 5 | 5 | 2 | San Jose Pump Station Kiosk | VC | VC | ACT | APX | VC | CartegraphIntegration | 2023/12/07 22:31:48+00 | STM | DFA000005 | GIS | 2020/12/16 22:12:41+00 | |||||
| 6 | 6 | 2 | Eberts Pump Station Kiosk | VC | VC | ACT | APX | VC | CartegraphIntegration | 2023/12/12 21:12:46+00 | STM | DFA000006 | GIS | 2020/12/16 22:12:41+00 |