Municipal Sanitary Sewer Lines

185 views (5 recent)

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

Municipal Sanitary Sewer Lines - Host municipalities for 2010 Olympic Games - Vancouver, Richmond, West Vancouver, Delta

Data and Resources

Dataset Extent

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

Additional Information


2010 Olympic Games - Emergency Management 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_SANITARY_SEWER_ID MNSNTRSWRD NUMBER 10 MUN SANITARY SEWER 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. force main, gravity, etc.
PIPE_MATERIAL PPMTRL VARCHAR2 30 PIPE MATERIAL: material that the pipe is made of e.g. PVC, steel, 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