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.
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 |
|---|---|
| MATERIAL | esriFieldTypeString |
| OBJECTID | esriFieldTypeOID |
| LENGTH_M | esriFieldTypeSingle |
| DIAMETER | esriFieldTypeInteger |
| OFFSETM | esriFieldTypeSingle |
| FCODE | esriFieldTypeInteger |
| OWNER | esriFieldTypeString |
| UNITID | esriFieldTypeString |
| UNITID2 | esriFieldTypeString |
| MAINCOMP1 | esriFieldTypeInteger |
| MAINCOMP2 | esriFieldTypeInteger |
| COMPTYPE | esriFieldTypeInteger |
| COMPKEY | esriFieldTypeInteger |
| PARLINENO | esriFieldTypeString |
| DIAM | esriFieldTypeDouble |
| PIPETYPE | esriFieldTypeString |
| PIPELEN | esriFieldTypeDouble |
| INSTDATE | esriFieldTypeDate |
| OWN | esriFieldTypeString |
| AREA | esriFieldTypeString |
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.
| OBJECTID | SHAPE | MATERIAL | LENGTH_M | DIAMETER | OFFSETM | FCODE | OWNER | UNITID | UNITID2 | MAINCOMP1 | MAINCOMP2 | COMPTYPE | COMPKEY | PARLINENO | DIAM | PIPETYPE | PIPELEN | INSTDATE | OWN |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4621 | CI | 21.2999992 | 250 | 0 | 26 | CITY | WF001907 | WT010914 | 43 | 43 | 41 | 223921 | 250 | CI | 21.3 | 1947/01/01 08:00:00+00 | CITY | ||
| 4622 | CI | 8.80000019 | 150 | 4.30000019 | 24 | CITY | WX010394 | WT014399 | 43 | 43 | 41 | 195799 | 150 | CI | 8.8 | 1953/05/29 07:00:00+00 | CITY | ||
| 4623 | CI | 0.300000012 | 150 | 6.4000001 | 24 | CITY | WT003570 | WF002757 | 43 | 43 | 41 | 247787 | 150 | CI | 0.3 | 1949/06/03 07:00:00+00 | CITY | ||
| 4624 | CI | 3 | 200 | 4.30000019 | 25 | CITY | WV004427 | WT014039 | 46 | 43 | 41 | 197307 | 200 | CI | 3 | 1953/09/16 07:00:00+00 | CITY | ||
| 4625 | CI | 55.7999992 | 250 | 1.20000005 | 26 | CITY | WT003204 | WV008831 | 43 | 46 | 41 | 230715 | 250 | CI | 55.8 | 1947/01/01 08:00:00+00 | CITY | ||
| 4626 | DI | 1.39999998 | 150 | 7 | 0 | CITY | WF019093 | WV022697 | 43 | 46 | 41 | 623985 | 150 | DI | 1.4 | 2016/12/01 08:00:00+00 | CITY | ||
| 4627 | CI | 73.0999985 | 150 | 4.30000019 | 24 | CITY | WF019092 | WV001464 | 43 | 46 | 41 | 623991 | 150 | CI | 73.1 | 1953/01/01 08:00:00+00 | CITY | ||
| 4628 | ACP | 3.4000001 | 150 | 4.30000019 | 24 | CITY | WT014791 | WF021815 | 43 | 43 | 41 | 700681 | 150 | ACP | 3.4 | 1958/10/24 07:00:00+00 | CITY | ||
| 4629 | ACP | 45 | 150 | 4.30000019 | 24 | CITY | WX010477 | WT027059 | 43 | 43 | 41 | 678621 | 150 | ACP | 45 | 1958/10/24 07:00:00+00 | CITY | ||
| 4630 | CI | 0.400000006 | 150 | 4.30000019 | 24 | CITY | WT002442 | WV011378 | 43 | 46 | 41 | 185742 | 150 | CI | 0.4 | 1949/06/29 07:00:00+00 | CITY |