Olympic Transportation Sites

131 views (1 recent)

Published by the Non-government - Vancouver Olympic Organizing Committee
Licensed under Access Only

Location of Departure Hubs, Bus Depots, Fleet Compounds, etc. for 2010 Winter Olympics

Data and Resources

Dataset Extent

Latitude: 49.0° to 50.0°
Longitude: -124.0° to -122.0°

Additional Information

Purpose

2010 Olympic Games - Emergency Mgmt Planning

Contact Information

NameGurdeep Singh (pointOfContact)
EmailGurdeep.Singh@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationGeoBC
NameJoshua Chan (pointOfContact)
Emailjoshua.chan@gov.bc.ca
OrganizationNon-government
Sub-OrganizationVancouver Olympic Organizing Committee

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_TRANSPORTATION_SITES_SP

Short Name: DRPTRNSPR1
Comments: This feature represents transportation sites associated with Olympic venues using point geometry.

Column Name Short Name Data Type Data Precision Comments
TRANSPORTATION_SITE_ID TRNSPRTTNS NUMBER 10 TRANSPORTATION SITE ID: is the primary key containing a unique value populated from a sequence triggered on insert.
SITE_NAME SITE_NAME VARCHAR2 254 SITE NAME: the name by which the site is known.
SITE_CODE SITE_CODE VARCHAR2 254 SITE CODE: the code assigned to the site by VANOC.
SITE_TYPE SITE_TYPE VARCHAR2 254 SITE TYPE: the type of transportation site e.g. bus depot, park and ride etc.
SITE_ADDRESS STDDRSS VARCHAR2 254 SITE ADDRESS: the municipal address of the site.
CITY CITY VARCHAR2 254 CITY: the municipality in which the site resides.
ACTIVITY ACTIVITY VARCHAR2 254 ACTIVITY: activities that are planned to take place at the site.
OLD_NAME OLD_NAME VARCHAR2 254 OLD NAME: contains the pre-Olympic name of the site.
ACTIVE ACTIVE VARCHAR2 1 ACTIVE: an indicator of whether or not the site is planned for operation e.g. y or n.
RELATED_VENUE RLTDVN VARCHAR2 50 RELATED VENUE: the venue(s) related to the transportation site.
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.