Storm Drain Structure (English, CSV)

Explore the interactive map. Storm Drain Structure: 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

Storm Drain System Structures such as vaults, CO Box, Stormwater Rehabilitation Units (SWRU), and culverts. 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
dueSubtypeesriFieldTypeSmallInteger
InstallDateesriFieldTypeDate
JurisdictionesriFieldTypeString
OwnedByesriFieldTypeString
LifecycleStatusesriFieldTypeString
DataSourceesriFieldTypeString
CustodianesriFieldTypeString
CustodianNotesesriFieldTypeString
OwnerIDesriFieldTypeString
PreviousIDesriFieldTypeString
ModifiedByesriFieldTypeString
ModifiedOnesriFieldTypeDate
CommentsesriFieldTypeString
DrawingNumberesriFieldTypeString
WaterTypeesriFieldTypeString
AssetIDesriFieldTypeString
CreatedByesriFieldTypeString

Sample rows

The first 10 rows, as CanQuery read them from the start of the publisher's file on 2026-11-06. Showing 20 of 24 columns.

OBJECTIDInfrastructureIDdueSubtypeNameInstallDateJurisdictionOwnedByLifecycleStatusDataSourceCustodianCustodianNotesOwnerIDPreviousIDModifiedByModifiedOnCommentsDrawingNumberWaterTypeAssetIDCreatedBy
114Government SWRU2003/01/01 00:00:00+00VCVCACTSURVCCartegraphIntegration2024/06/26 21:11:27+00STMDST000001GIS
224Fisherman's Wharf SRWU2004/01/01 00:00:00+00VCVCACTSURVCCartegraphIntegration2024/06/26 21:11:28+00STMDST000002GIS
35Humboldt Drain Diversion StructureVCVCACTASBVCCartegraphIntegration2023/11/22 00:50:25+00UG-523STMDST000003GIS
45Bowker CreekVCVCACTVCCartegraphIntegration2023/11/22 00:50:25+00UGT-004STMDST000004GIS
55Bowker CreekVCVCACTVCCartegraphIntegration2023/11/22 00:50:25+00UGT-004STMDST000005GIS
65Bowker Creek CulvertVCVCACTVCCartegraphIntegration2023/11/22 00:50:25+00STMDST000006GIS
72VCVCACTVCCartegraphIntegration2023/11/22 00:50:25+00STMDST000007GIS
82VCVCACTVCCartegraphIntegration2023/11/22 00:50:25+00STMDST000008GIS
92VCVCACTVCCartegraphIntegration2023/11/22 00:50:25+00STMDST000009GIS
102VCVCACTVCCartegraphIntegration2023/11/22 00:50:25+00STMDST000010GIS

Official sources and licences

Related open data