Metro Vancouver Sewage Treatment Plants

223 views (1 recent)

Published by the Local Government - Greater Vancouver Regional District
Licensed under Access Only

Metro Vancouver Sewage Treatment Plants

Data and Resources

Dataset Extent

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

Additional Information

Purpose

2010 Olympic Games Security and Emergency Preparedness Planning purposes.

Contact Information

NameJoshua Chan (pointOfContact)
Emailjoshua.chan@gov.bc.ca
OrganizationLocal Government
Sub-OrganizationGreater Vancouver Regional District

Access & Security

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

Metadata Information

Record Published 2014-12-15
Record Last Modified 2017-04-12
Resource Status completed

Object Description

Object Name: WHSE_IMAGERY_AND_BASE_MAPS.DRP_MUN_SEWAGE_PLANTS_SP

Short Name: DRPMNSWGPL

Column Name Short Name Data Type Data Precision Comments
MUN_SEWAGE_PLANT_ID MNSWGPLNTD NUMBER 10 MUN SEWAGE PLANT ID: is the primary key containing a unique value populated from a sequence triggered on insert.
PLANT_ACRONYM PLNTCRNM VARCHAR2 4 PLANT ACRONYM: abbreviated name of facility.
PLAN_AREA_CODE PLNRCD VARCHAR2 2 PLAN AREA CODE: area designation for GVRD purposes.
OWNER_CODE OWNER_CODE VARCHAR2 4 OWNER CODE: code representing the owner of the facility.
LIFECYCLE LIFECYCLE VARCHAR2 12 LIFECYCLE: whether the facility is active or not.
FACILITY_TYPE FCLTTP VARCHAR2 16 FACILITY TYPE: designates the type of the facility e.g. treatment etc.
LOCATION LOCATION VARCHAR2 30 LOCATION: general area of the location of the plant.
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.