BC Research Centres

315 views (4 recent)

Published by the Ministry of Jobs, Trade and Technology - Technology and Innovation
Licensed under Access Only

This dataset provides the names, addresses, geographic locations, affiliated institutions, and areas of research specialization for many research centres affiliated with public post-secondary institutions and research hospitals in British Columbia.

This dataset is intended to provide a robust set of examples of the research centres in BC it is not to be considered exhaustive or complete.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

This dataset is intended to provide a robust set of examples of the research centres in BC.

Data Quality

This dataset is not to be considered exhaustive or complete.

Lineage Statement

Data collected from public sources by the BC Ministry of Jobs, Trade and Technology, Innovation and Technology Branch, 2017. Original data collected by the BC Ministry of International Trade, 2015

Contact Information

NameTammi Carter (businessExpert)
EmailTammi.Carter@gov.bc.ca
OrganizationMinistry of Jobs, Trade and Technology
Sub-OrganizationTechnology and Innovation
NameCecile Lacombe (custodian)
EmailCecile.Lacombe@gov.bc.ca
OrganizationMinistry of Jobs, Trade and Technology
Sub-OrganizationTechnology and Innovation

Access & Security

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

Metadata Information

Record Published 2016-06-17
Record Last Modified 2018-11-27
Resource Status completed

Object Description

Object Name: WHSE_IMAGERY_AND_BASE_MAPS.GSR_RESEARCH_CENTRES_SVW

Short Name: RSRCH_CENT
Comments: GSR_RESEARCH_CENTRES_SVW is a spatially enabled layer comprising This dataset provides the names, addresses, geographic locations, affiliated institutions, and areas of research specialization for the research centres affiliated with public post-secondary institutions and research hospitals in British Columbia.

Column Name Short Name Data Type Data Precision Comments
CUSTODIAN_ORG_DESCRIPTION CUST_ORG VARCHAR2 200 CUSTODIAN_ORG_DESCRIPTION contains the name or description of the custodial organization (usually Ministry and Branch)
BUSINESS_CATEGORY_CLASS BUS_CAT_CL VARCHAR2 1000 BUSINESS_CATEGORY_CLASS designates the category of business, i.e., scientificResearchAndDevelopmentServices
BUSINESS_CATEGORY_DESCRIPTION BUS_CAT_DS VARCHAR2 1000 BUSINESS_CATEGORY_DESCRIPTION describes the category of business, i.e., Scientific Research and Development Services
OCCUPANT_TYPE_DESCRIPTION OCCPNT_TYP VARCHAR2 500 OCCUPANT_TYPE_DESCRIPTION contains the description of the occupant type, e.g. Hospital
RESEARCH_CENTRE_ID RSRCH_C_ID VARCHAR2 20 RESEARCH_CENTRE_ID is a system-generated unique identification number.
RESEARCH_CENTRE_NAME RSRCH_C_NM VARCHAR2 500 RESEARCH_CENTRE_NAME is the name of the research centre, e.g., The Centre for Advanced Wood Processing: University of British Columbia
STREET_ADDRESS ST_ADDRESS VARCHAR2 200 STREET_ADDRESS is a free form expression of the site descriptor (e.g., unit) and the civic building number / street / street indicator portion of an address, e.g., Unit 1, 123 Main Street East.
POSTAL_CODE POSTAL_CD VARCHAR2 10 POSTAL_CODE is the Canadian Postal code value associated with the physical address, e.g., V9Z 2K1
LOCALITY LOCALITY VARCHAR2 100 LOCALITY is the name of the municipality, community, Federal Indian Reserve (IR), subdivision, regional district, indigenous land or natural feature the occupant site is located in, e.g., Victoria, Saanich IR 1, Capital Regional District.
CONTACT_PHONE VARCHAR2 50 CONTACT PHONE contains the "general office" phone number of the Occupant, e.g., (250) 555-1234 or 250-555-1234
CONTACT_EMAIL VARCHAR2 100 CONTACT_EMAIL contains the "general office" email address of the Occupant.
CONTACT_FAX VARCHAR2 50 CONTACT FAX contains the "general office" fax number of the Occupant, e.g., (250) 555-1234 or 250-555-1234
WEBSITE_URL WEBSITE VARCHAR2 500 WEBSITE_URL contains the link to the Home page of the Occupant's Website
IMAGE_URL VARCHAR2 500 IMAGE_URL contains a full URL link to a picture of the Occupant's Location.
LATITUDE LATITUDE NUMBER 9 LATITUDE is the geographic coordinate, in decimal degrees (dd.dddddd), of the location of the feature as measured from the equator, e.g., 55.323653
LONGITUDE LONGITUDE NUMBER 10 LONGITUDE is the geographic coordinate, in decimal degrees (-ddd.dddddd), of the location of the feature as measured from the prime meridian, e.g., -123.093544
KEYWORDS KEYWORDS VARCHAR2 1000 KEYWORDS contains text strings supplied by the Custodian, to be used for search/query purposes. Keywords are separated by the ; delimiter.
DATE_UPDATED DATE 7 DATE_UPDATED contains the date that the Occupant data was updated in the Occupant structure (system-generated)
SITE_GEOCODED_IND VARCHAR2 1 SITE_GEOCODED_IND contains a Flag/indicator (Y/N) that the Occupant Physical Address has been geo-coded by the DataBC Address Geocoder and the results provide a valid site address, e.g., Y, N
CENSUS_SUBDIVISION_ID CEN_SDV_ID VARCHAR2 7 CENSUS_SUBDIVISION_ID together with CENSUS_YEAR is used to provide a link to CENSUS_YEAR + CENSUS_SUBDIVISION ID in CEN_CENSUS_SUBDIVISIONS SP, e.g., 5901022. With CENSUS_YEAR, this identifies the community in which the research centre is located.
CENSUS_YEAR CEN_YR NUMBER 4 CENSUS_YEAR is the census year to which CENSUS_SUBDIVISION_ID pertains. e.g., 2006, 2011. With CENSUS_SUBDIVISION_ID, this provides a link to CENSUS_YEAR + CENSUS_SUBDIVISION_ID in CEN_CENSUS_SUBDIVISIONS_SP
CENTRE_TYPE CNTR_TYPE VARCHAR2 100 CENTRE_TYPE is the specific type of research centre, if applicable, e.g. Canada Research Chair, Centre of Excellence.
DATA_SOURCE DATA_SRCE VARCHAR2 100 DATA_SOURCE is the website from which information about the Research Centre was retrieved.
DATA_UPDATED_YEAR UPDATE_YR NUMBER 4 DATA_UPDATED_YEAR is the year in which the source of the information in this table was last updated
RESEARCH_CENTRE_AFFILIATION RSRCH_CNTN VARCHAR2 30 RESEARCH_CENTRE_AFFILIATION is the affiliation of research centre, e.g., university, non-profit, provincial government.
RESEARCH_SECTOR RSRCH_SCTR VARCHAR2 100 RESEARCH_SECTOR is the work sector that the research centres operates in, e.g., Forestry
SHAPE SHAPE SDO_GEOMETRY 64 SHAPE is the column used to reference the spatial coordinates defining the feature.
SEQUENCE_ID SEQ_ID NUMBER 10 SEQUENCE_ID contains a value to distinguish occupant instances. Where a single occupant can have multiple instances (representing different services, for example), this field distinguishes this occupant instance from other instances of the same or different occupants.
SE_ANNO_CAD_DATA ANNO_CAD 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.

Comments

No comments have been posted yet.