Olympic Venues and Sites of Interest

171 views (2 recent)

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

Locations of 2010 Winter Olympics venues and sites of interest defined by Vancouver 2010 Integrated Security Unit

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
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationGeoBC

Access & Security

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

Metadata Information

Record Published 2014-12-15
Record Last Modified 2020-01-30
Resource Status completed

Object Description

Object Name: WHSE_IMAGERY_AND_BASE_MAPS.DRP_OLY_VEN_ISU_SITES_LIST_SP

Short Name: DRPLVNSSTS
Comments: ISU Site List: A point file of all the sites to be used during the Olympics. Eg. ROO = Richmond Olympic Oval. This spatial layer contains single part points.

Column Name Short Name Data Type Data Precision Comments
ISU_SITE_ID SSTD NUMBER 10 ISU SITE ID is the primary key containing a unique value populated from a sequence triggered on insert.
VENUE_ID VENUE_ID NUMBER 16 VENUE ID contains a number identifying the site.
NAME NAME VARCHAR2 254 NAME: is the venue name (e.g. UBC Thunderbird Area)
PRE_OLYMPIC_NAME PRLMPCNM VARCHAR2 254 PRE OLYMPIC NAME: Venue name prior to the Olympic Games (e.g. David Lam Park becomes Vancouver Live Site during the event)
ISU_SITE_TYPE SSTTP VARCHAR2 254 TYPE: Type of the venue (e.g. Accomodation, airport, competition, media centre, etc.)
CATEGORY CATEGORY VARCHAR2 254 CATEGORY: Venue category (e.g. Competition, non-competition, Support Facility, etc.)
CODE CODE VARCHAR2 254 CODE: Venue code (e.g. UBC, ROO, etc.)
ISU_SITE_COMMENT SSTCMMNT VARCHAR2 254 ISU SITE COMMENT: Additional information associated with the site.
ACTIVITY ACTIVITY VARCHAR2 254 ACTIVITY: Name of activity that takes place at the venue (e.g. Snowboarding)
CAPACITY CAPACITY VARCHAR2 254 CAPACITY: Number of people allowable to the venue as determined by the fire department
SCOPE SCOPE VARCHAR2 254 SCOPE: Indicates whether the venue is used during the Olympic, Paralympic, or both
ADDRESS ADDRESS VARCHAR2 254 ADDRESS: Street address of the venue
MUNICIPALITY MNCPLT VARCHAR2 254 MUNICIPALITY: Name of the Municipality the venue falls under
LATITUDE LATITUDE NUMBER 10 LATITUDE: latitude of the venue in decimal degrees.
LONGITUDE LONGITUDE NUMBER 12 LONGITUDE: longitude of the venue in decimal degrees.
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.