OpportunitiesBC

365 views (6 recent)

Published by the Ministry of Jobs, Trade and Technology - Labour Market Programs
Licensed under Access Only

OpportunitiesBC is an online searchable database of business and project opportunities within British Columbia suitable for foreign investment.

Data and Resources

Dataset Extent

Latitude: 48.0° to 60.0°
Longitude: -139.5° to -113.5°

Additional Information

Purpose

The primary use of this data is to provide information about investment opportunities identified at specific civic address locations in B.C.

Contact Information

NameJosh Thompson (pointOfContact)
Emailjosh.thompson@gov.bc.ca
OrganizationMinistry of Jobs, Trade and Technology
Sub-OrganizationLabour Market Programs
NameAmy Schneider (pointOfContact)
EmailAmy.Schneider@gov.bc.ca
OrganizationMinistry of Jobs, Trade and Technology
Sub-OrganizationLabour Market Programs

Access & Security

Who can view this dataset? Public
Who can download this dataset?Public

Metadata Information

Record Published 2014-12-11
Record Last Modified 2019-09-05
Resource Status onGoing

Object Description

Object Name: WHSE_IMAGERY_AND_BASE_MAPS.GSR_OPPORTUNITIES_ISP

Short Name: GSRPPRTNTS
Comments: OPPORTUNITY ISP is a spatially enabled layer comprising organisations and businesses offering investment opportunities to foreign or local investors in British Columbia. This is not a multipart feature class. This entity is an instantiated spatial view of the Occupants and related Service records comprising a join of the following tables: OCCUPANT SP (sub-type OPPORTUNTIES SP), and INVESTMENT OPS. The tables are joined in the subsequent FME script housed with replications services.

Column Name Short Name Data Type Data Precision Comments
OPPORTUNITY_ID OPP_ID NUMBER 10 OPPORTUNITY ID is a system generated unique identification number.
INVESTMENT_OPPORTUNITY_ID INV_OPP_ID NUMBER 10 INVESTMENT OPPORTUNITY ID is the unique identifier for the opportunity.
TAXONOMY_CATEGORY_ID TAX_CAT_ID NUMBER 10 TAXONOMY CATEGORY ID is the id of a class in the TAXONOMIC CATEGORY entity related to the Occupant.
OCCUPANT_ID OCCPNT_ID NUMBER 10 OCCUPANT ID is a system generated unique identification number.
OCCUPANT_NAME NAME VARCHAR2 500 OCCUPANT_NAME is a business name that can identify the occupant who provides the BC Government or BC Government related services to public. e.g., Burnaby General Hospital, Golden Food Bank
OCCUPANT_DESCRIPTION OCCPNT_DSC VARCHAR2 1000 OCCUPANT DESCRIPTION describes the Occupant in more detail. e.g., Burnaby General Hospital (BGH) that is managed by Fraser Health Authority provides a wide range of integrated health care services from acute care hospitals to community-based residential, home health, mental health and public health.
SOURCE_OPPORTUNITY_ID SRC_OPP_ID NUMBER 10 SOURCE OPPORTUNITY ID stores the identifier (Opportunity_ID) for the source dataset
SOURCE_DATA_ID SRCDATA_ID VARCHAR2 20 SOURCE DATA ID stores the identifier from the source dataset. If the source data id is not a text field, it will be converted during the data load. e.g., 1
OPPORTUNITY_TYPE_ID OPP_TYP_ID NUMBER 10 OPPORTUNITY TYPE ID is a numeric code used to identify the type of opportunity, e.g., 22.
OPPORTUNITY_TYPE_NAME OPP_TYP_NM VARCHAR2 254 OPPORTUNITY TYPE NAME describes the type of opportunity, e.g., Tourism and Accommodations.
ADDR_LOCALITY_NAME LOCALITY VARCHAR2 50 ADDR LOCALITY NAME is the name of the municipality, community, Indian reservation, subdivision, regional district, aboriginal lands, or natural feature the site is located in. The locality of a civic address is that defined by the civic address authority. A locality name that starts with a directional is not abbreviated (e.g., North Vancouver, not N Vancouver). Spelling of localities that are place names or natural feature names MUST match that published by the BC Geographical Names Information System [R2]. e.g., GOLDEN
ADDR_ADDRESS_STRING CIVIC_ADDR VARCHAR2 254 ADDR ADDRESS STRING is the civic or non-civic address as a single string, structured according to the specification of the Physical Address and Geocoding Standard, e.g., 420 GORGE RD E, VICTORIA, BC.
ADDR_NARRATIVE_LOCATION LCTN_DSC VARCHAR2 240 ADDR NARRATIVE LOCATION contains written directions to access the site. The narrative should start at the closest known, named physical feature to the site. e.g., from Tlell, travel north on highway 16 to the big golden spruce tree on your left, hike west for about one kilometre
ADDR_ACCESS_NOTES ACCSS_NOTE VARCHAR2 254 ADDR ACCESS NOTES contains additional information that is helpful in determining the access location and any restrictions on mode of access. e.g., boat only, floatplane only
REGION_ID REGION_ID NUMBER 10 REGION_ID is the identifier for the Economic Development Region that the Opportunity is located within
REGION REGION VARCHAR2 50 REGION is the Economic Development Region that the Opportunity is located within
CATEGORY CATEGORY VARCHAR2 255 CATEGORY is the name of the taxonomic class. This is a period-separated list of categories with the taxonomy name appearing first (e.g., bcgsr.health-sector.hospital where bcgsr is the name of a provincial taxonomy for the GSR). Periods (“.”) and dashes (“-“) are the only special characters allowed, e.g., "bcgsr.artsEntertainmentRecreation.events"
OPPORTUNITY_URL OPP_URL VARCHAR2 2000 OPPORTUNITY URL is the link to the website page for the specific opportunity
AFFILIATED_ORG_WEBSITE AF_ORG_WEB VARCHAR2 254 AFFILIATED ORG WEBSITE is the website for the affiliated organization related to the investment opportunity, e.g., www.hellobc.ca.
OCC_SEARCH_TAGS_ADD O_SRCH_TAG VARCHAR2 4000 OCC SEARCH TAGS ADD includes the list of services provided by the occupant in a single string (comma delimited). The standardized service names are available for inclusion and this information will be used in searching the occupant providing for a particular service. e.g., acute care, mental health, public health.
SHAPE SHAPE SDO_GEOMETRY 1
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.