We have a new look coming! The new catalogue is going live on October 27th. The catalogue will be unavailable between 8am-1:30pm PST on October 27th during the upgrade. If you want a sneak peek, check out the beta site.

BC Schools - K-12 with Francophone Indicators

827 views (11 recent)

Published by the Ministry of Education - Education Analytics
Licensed under Open Government Licence - British Columbia

This dataset is comprised of all schools for Kindergarten to Grade 12 in British Columbia. Indicators are included for schools that offer French programs including: Core French, Early French Immersion, Late French Immersion and Francophone Program.

Data and Resources

Dataset Extent

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

Additional Information


The primary use of this data is to provide information about Kindergarden to Grade 12 Schools at specific civic address locations in B.C.

More Information

Contact Information

NameAnalysis and Reporting Unit (pointOfContact)
OrganizationMinistry of Education
Sub-OrganizationEducation Analytics

Access & Security

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

Metadata Information

Record Published 2014-12-11
Record Last Modified 2021-09-28
Resource Status onGoing

Object Description


Short Name: SCHOOL_K12
Comments: GSR_SCHOOLS_K_TO_12_SVW describes schools in British Columbia offering kindergarten to grade 12

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., elementaryAndSecondarySchools
BUSINESS_CATEGORY_DESCRIPTION BUS_CAT_DS VARCHAR2 1000 BUSINESS_CATEGORY_DESCRIPTION describes the category of business, i.e., Elementary and secondary schools
OCCUPANT_TYPE_DESCRIPTION OCCPNT_TYP VARCHAR2 500 OCCUPANT_TYPE_DESCRIPTION contains the description of the occupant type, 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
SUPPLIED_SOURCE_ID_IND SRC_ID_IND VARCHAR2 1 SUPPLIED_SOURCE_ID_IND is an indicator of whether the source data id was supplied by the supplier (Y) or DataBC (N)
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 ALS_DDRSS 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
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 CONT_PHONE VARCHAR2 50 CONTACT_PHONE contains the "general office" phone number of the Occupant, e.g., 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
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.
DATE_UPDATED DT_UPDATE DATE 7 DATE_UPDATED contains the date that the Occupant data was updated in the Occupant structure (system-generated)
SITE_GEOCODED_IND GEOCD_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
CORE_FRENCH_OFFERED CR_FR_OFFR VARCHAR2 3 CORE_FRENCH_OFFERED identifies whether the school offers a Core French program. Valid values are "YES" or "NO".
DISTRICT_NAME DIST_NAME VARCHAR2 254 DISTRICT_NAME is the name of the school district, e.g. Southeast Kootenay.
DISTRICT_NUMBER DSTRCT_NUM VARCHAR2 3 DISTRICT_NUMBER is a 3 digit code used to identify school district, e.g. 005
EARLY_FRENCH_IMMERSION_OFFERED EARLY_IMM VARCHAR2 3 EARLY_FRENCH_IMMERSION_OFFERED identifies whether the school offers an early French Immersion program. Valid values are "YES" or "NO".
FACILITY_TYPE FCLTY_TYPE VARCHAR2 254 FACILITY_TYPE is the type of school facility, e.g. District Distance Ed
FRANCOPHONE_PROGRAM_OFFERED FRPH_PRGRM VARCHAR2 3 FRANCOPHONE_PROGRAM_OFFERED identifies whether the school offers a Francophone program. Valid values are "YES" or "NO".
LATE_FRENCH_IMMERSION_OFFERED FR_IMM_LT VARCHAR2 3 LATE_FRENCH_IMMERSION_OFFERED identifies whether the school offers a late French Immersion program. Valid values are "YES" or "NO".
SCHOOL_CATEGORY SCHL_CTGRY VARCHAR2 254 SCHOOL_CATEGORY identifies if the school is public, independent, long distance, e.g. BC PUBLIC SCHOOL
SCHOOL_EDUCATION_LEVEL SCHL_DCTNL VARCHAR2 254 SCHOOL_EDUCATION_LEVEL indicates the level of education offered by the school, e.g. ELEMENTARY, SECONDARY.
SCHOOL_NUMBER SCHL_NMBR VARCHAR2 8 SCHOOL_NUMBER is a code assigned to the school for this enrollment period.
SCHOOL_YEAR SCHOOL_YR VARCHAR2 9 SCHOOL_YEAR indicates the enrolment period, e.g. 2012/2013.
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 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.