Translink Administrative Offices

232 views (3 recent)

Published by the Non-government - TransLink
Licensed under Access Only

Translink Administrative Offices

Data and Resources

Dataset Extent

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

Additional Information

Purpose

2010 Olympic Games - Emergency Mgmt Planning

Contact Information

NameJoshua Chan (pointOfContact)
Emailjoshua.chan@gov.bc.ca
OrganizationNon-government
Sub-OrganizationTransLink

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_TRANSLINK_ADMIN_OFFICES_SP

Short Name: DRPTRNSLNK
Comments: This feature repesents the locations of Translink administrative offices using point geometry.

Column Name Short Name Data Type Data Precision Comments
TRANSLINK_OFFICE_ID TRNSLNKFFC NUMBER 10 TRANSLINK OFFICE ID: is a surrogate primary key populated by a trigger and sequence.
OFFICE_NAME FFCNM VARCHAR2 50 OFFICE NAME: contains the name of the office.
ADDRESS ADDRESS VARCHAR2 50 ADDRESS: contains the address of the office e.g. 13401 - 108'th Avenue, Surrey.
PURPOSE PURPOSE VARCHAR2 20 PURPOSE: contains the purpose of the administrative office e.g. Translink Head Office.
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.