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.

Access original file

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.

FieldRecorded type
NameesriFieldTypeString
OBJECTIDesriFieldTypeOID
InfrastructureIDesriFieldTypeString
dfaSubtypeesriFieldTypeSmallInteger
InstallDateesriFieldTypeDate
JurisdictionesriFieldTypeString
OwnedByesriFieldTypeString
LifecycleStatusesriFieldTypeString
DataSourceesriFieldTypeString
CustodianesriFieldTypeString
CustodianNotesesriFieldTypeString
ModifiedByesriFieldTypeString
ModifiedOnesriFieldTypeDate
CommentsesriFieldTypeString
DrawingNumberesriFieldTypeString
WaterTypeesriFieldTypeString
AssetIDesriFieldTypeString
CreatedByesriFieldTypeString
CreatedOnesriFieldTypeDate
UndergroundesriFieldTypeSmallInteger

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.

OBJECTIDInfrastructureIDdfaSubtypeNameInstallDateJurisdictionOwnedByLifecycleStatusDataSourceCustodianCustodianNotesModifiedByModifiedOnCommentsDrawingNumberWaterTypeAssetIDCreatedByCreatedOnUnderground
111Shakespeare Pump Station1991/01/01 00:00:00+00VCVCACTAPXVCCartegraphIntegration2024/01/18 22:02:04+00STMDFA000001GIS2020/12/16 22:12:41+00
221St Charles Pump Station1992/01/01 00:00:00+00VCVCACTAPXVCCartegraphIntegration2024/02/15 18:43:31+00STMDFA000002GIS2020/12/16 22:12:41+00
331San Jose Pump Station1994/01/01 00:00:00+00VCVCACTAPXVCCartegraphIntegration2024/01/18 22:02:46+00STMDFA000003GIS2020/12/16 22:12:41+00
441Eberts Pump Station1991/01/01 00:00:00+00VCVCACTAPXVCAGOUDINE2024/07/11 22:24:55+00UG-621STMDFA000004GIS2020/12/16 22:12:41+00
552San Jose Pump Station KioskVCVCACTAPXVCCartegraphIntegration2023/12/07 22:31:48+00STMDFA000005GIS2020/12/16 22:12:41+00
662Eberts Pump Station KioskVCVCACTAPXVCCartegraphIntegration2023/12/12 21:12:46+00STMDFA000006GIS2020/12/16 22:12:41+00

Official sources and licences

Related open data