Municipal Water Utility Lines

215 views (3 recent)

Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - GeoBC
Licensed under Access Only

Municipal Water Utility Lines - covers host municipalities for Olympics

Data and Resources

Dataset Extent

Latitude: 49.2° to 49.3°
Longitude: -123.2° to -123.0°

Additional Information


2010 Olympic Games - Emergency Mgmt Planning

Contact Information

NameJoshua Chan (pointOfContact)
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development

Access & Security

Who can view this dataset? Government
Who can download this dataset?Government

Metadata Information

Record Published 2014-12-16
Record Last Modified 2019-12-17
Resource Status completed

Object Description



Column Name Short Name Data Type Data Precision Comments
MUN_WATER_UTILITY_LINE_ID MNWTRTLTLN NUMBER 10 WATER UTILITY LINE ID: is the primary key containing a unique value populated from a sequence triggered on insert.
PIPE_ID PIPE_ID VARCHAR2 50 PIPE ID: the ID of the pipe as provided by the respective municipality.
PIPE_TYPE PIPE_TYPE VARCHAR2 50 PIPE TYPE: categorization of pipe based on flow e.g. trunk, main, etc.
PIPE_MATERIAL PPMTRL VARCHAR2 30 PIPE MATERIAL: material that the pipe is made of e.g. HDPE, ST (steel), DI (ductile iron), etc
PIPE_DIAMETER PPDMTR NUMBER 12 PIPE DIAMETER: the diameter of the pipe in millimeters.
GEOMETRY GEOMETRY SDO_GEOMETRY 1 GEOMETRY is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a required attribute of feature classes and object classes in a geodatabase.
SE_ANNO_CAD_DATA BLOB 4000 SE_ANNO_CAD_DATA is a binary column used by spatial tools to store annotation, curve features and CAD data when using the SDO_GEOMETRY storage data type.
FEATURE_LENGTH_M FEAT_LEN NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters