Watermain (English, CSV)

Explore the interactive map. Watermain: English CSV file you can open as a table, filter, chart and export up to 10,000 rows. From City of Burnaby, updated Aug 2023.

Format
CSV
Access
Table on demand (prepared when opened) and interactive map
Fields
20
Publisher-reported update
2023-08-25

Dataset consisting of City water mains and GVRD trunk lines within the City of Burnaby. The vertical datum used is CGVD28 which uses the GVRD geoid to obtain orthometric heights.

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
MATERIALesriFieldTypeString
OBJECTIDesriFieldTypeOID
LENGTH_MesriFieldTypeSingle
DIAMETEResriFieldTypeInteger
OFFSETMesriFieldTypeSingle
FCODEesriFieldTypeInteger
OWNEResriFieldTypeString
UNITIDesriFieldTypeString
UNITID2esriFieldTypeString
MAINCOMP1esriFieldTypeInteger
MAINCOMP2esriFieldTypeInteger
COMPTYPEesriFieldTypeInteger
COMPKEYesriFieldTypeInteger
PARLINENOesriFieldTypeString
DIAMesriFieldTypeDouble
PIPETYPEesriFieldTypeString
PIPELENesriFieldTypeDouble
INSTDATEesriFieldTypeDate
OWNesriFieldTypeString
AREAesriFieldTypeString

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 37 columns.

OBJECTIDSHAPEMATERIALLENGTH_MDIAMETEROFFSETMFCODEOWNERUNITIDUNITID2MAINCOMP1MAINCOMP2COMPTYPECOMPKEYPARLINENODIAMPIPETYPEPIPELENINSTDATEOWN
4621CI21.2999992250026CITYWF001907WT010914434341223921250CI21.31947/01/01 08:00:00+00CITY
4622CI8.800000191504.3000001924CITYWX010394WT014399434341195799150CI8.81953/05/29 07:00:00+00CITY
4623CI0.3000000121506.400000124CITYWT003570WF002757434341247787150CI0.31949/06/03 07:00:00+00CITY
4624CI32004.3000001925CITYWV004427WT014039464341197307200CI31953/09/16 07:00:00+00CITY
4625CI55.79999922501.2000000526CITYWT003204WV008831434641230715250CI55.81947/01/01 08:00:00+00CITY
4626DI1.3999999815070CITYWF019093WV022697434641623985150DI1.42016/12/01 08:00:00+00CITY
4627CI73.09999851504.3000001924CITYWF019092WV001464434641623991150CI73.11953/01/01 08:00:00+00CITY
4628ACP3.40000011504.3000001924CITYWT014791WF021815434341700681150ACP3.41958/10/24 07:00:00+00CITY
4629ACP451504.3000001924CITYWX010477WT027059434341678621150ACP451958/10/24 07:00:00+00CITY
4630CI0.4000000061504.3000001924CITYWT002442WV011378434641185742150CI0.41949/06/29 07:00:00+00CITY

Official sources and licences

Related open data