Sites Registry (Open Government Licence)

441 views (8 recent)

Published by the Ministry of Citizens Services - DataBC Program
Licensed under Open Government Licence - British Columbia

This dataset is a subset of the Sites Registry dataset. The Sites Registry is a collection of locations that are important to government carrying out its business, including sharing information with citizens. Most locations have civic addresses and are government offices or facilities, e.g. hospitals, schools, post-secondary institutions, court houses, tourism centres. It is comprised of all sites licensed under the Open Government Licence – British Columbia. For more information see the Sites Registry catalogue record.

Data and Resources

Dataset Extent

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

Additional Information


This data provides information about locations important to government carrying out its business.

Lineage Statement

Contains information licensed under the Open Government Licence – Destination BC

More Information

Contact Information

NameDataBC Program (pointOfContact)
OrganizationMinistry of Citizens Services
Sub-OrganizationDataBC Program

Access & Security

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

Metadata Information

Record Published 2016-06-15
Record Last Modified 2020-08-24
Resource Status onGoing

Object Description


Short Name: GSR_OC_OGL
Comments: GSR_OCCUPANTS_SVW describes GSR occupants of occupant types in British Columbia, for occupant types that have their data licensed under BC-OGL.

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_ID BSNSS_C_ID NUMBER 10 BUSINESS_CATEGORY_ID contains the system-generated ID of the business category associated with the occupant type.
BUSINESS_CATEGORY_CLASS BUS_CAT_CL VARCHAR2 1000 BUSINESS_CATEGORY_CLASS is the designation that the business belongs to. E.g. accommodationFoodServices.accommodations or educationalServices.multiLevelSchool
BUSINESS_CATEGORY_DESCRIPTION BUS_CAT_DS VARCHAR2 1000 BUSINESS_CATEGORY_DESCRIPTION is the description that applies to its corresponding BUSINESS_CATEGORY_CLASS. E.g. Tourist accommodations for class accommodationFoodServices.accommodations.
OCCUPANT_TYPE_ID OCCPNT__ID NUMBER 10 OCCUPANT_TYPE_ID contains the primary key value for the GSR_OCCUPANT_TYPES table.
OCCUPANT_TYPE_DESCRIPTION OCCPNT_TYP VARCHAR2 500 OCCUPANT_TYPE_DESCRIPTION contains the description of the occupant type, e.g. Hospital
CUSTOM_STYLE_NAME CUST_STYNM VARCHAR2 240 CUSTOM_STYLE_NAME is a text string that can be used to override the category style produced by the BC Physical Address Geocoder. e.g, hospital
SOURCE_DATA_ID SRCDATA_ID VARCHAR2 20 SOURCE_DATA_ID is a unique occupant id either supplied by the source data system or produced by GSR, depending on the value of SUPPLIED_SOURCE_ID_IND
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.
DESCRIPTION DESCRIPTN VARCHAR2 4000 DESCRIPTION describes the Occupant in more detail
PHYSICAL_ADDRESS ADDRESS VARCHAR2 1000 PHYSICAL_ADDRESS contains 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.
ALIAS_ADDRESS ALIAS_ADDR VARCHAR2 1000 ALIAS_ADDRESS contains an address string, not a parsed address. It is the address that will be displayed for presentation purposes, e.g., 32900 Marshall Road, Abbotsford, BC
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 CONT_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 CONT_EMAIL VARCHAR2 100 CONTACT_EMAIL contains the "general office" email address of the Occupant.
CONTACT_FAX CONT_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 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.
NON_CIVIC_ADDRESS_IND NN_CVC_DDD VARCHAR2 1 NON_CIVIC_ADDRESS_IND is a flag/indicator to identify if the STREET_ADDRESS has no civic number, i.e., Y or N. The civic number, for example "1175" in "1175 Douglas St, Victoria, BC", is assigned to a site on a street by an address authority.
LOCATION_DESCRIPTOR LCTN_DSCRR VARCHAR2 30 LOCATION_DESCRIPTOR describes the type of post secondary education facility location, e.g. Campus, Satellite, Learning Centre, Regional Campus.
DATE_ADDED DT_ADDED DATE 7 DATE_ADDED contains the date that the Occupant data was created in the Occupant structure (system-generated)
DATE_UPDATED DT_UPDATE DATE 7 DATE_UPDATED contains the date that the Occupant data was updated in the Occupant structure (system-generated)
SHAPE SHAPE SDO_GEOMETRY 64 SHAPE is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a column required by spatial layers that interact with ESRI ArcSDE. It is populated with unique values automatically by SDE.
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.