School enrollment

1129 views (28 recent)

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

This dataset represents the most recent enrollment information for public and private elementary and secondary schools in British Columbia. Also included are the geographic location (latitude/longitude) of each school and the id of the Census Subdivision in which it resides.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Application-specific for the Trade and Invest British Columbia website (https://www.britishcolumbia.ca/)

Lineage Statement

Data source: BC Ministry of Education, 2014

Contact Information

Access & Security

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

Metadata Information

Record Published 2016-06-17
Record Last Modified 2019-05-04
Resource Status completed

Object Description

Object Name: WHSE_HUMAN_CULTURAL_ECONOMIC.ECON_SCHOOL_ENROLLMENTS

Short Name: SCHL_ENRLM
Comments: SCHOOL ENROLLMENT represents most recent enrollment information for public and private elementary and secondary schools in British Columbia

Column Name Short Name Data Type Data Precision Comments
SCHOOL_ENROLLMENT_ID SCHL_NR_ID NUMBER 10 SCHOOL ENROLLMENT ID is a system generated unique identification number, e.g., 1
CENSUS_YEAR CNSS_YR NUMBER 4 CENSUS YEAR is the census year to which CENSUS SUBDIVISION ID pertains. e.g., 2006, 2011. With CENSUS SUBDIVISION ID, this forms a foreign key linking to CENSUS YEAR + CENSUS SUBDIVISION ID in CEN CENSUS SUBDIVISIONS SP
CENSUS_SUBDIVISION_ID CNSS_SB_ID VARCHAR2 7 CENSUS SUBDIVISION ID together with CENSUS YEAR is used to form a foreign Key, linking to CENSUS_YEAR + CENSUS_SUBDIVISION_ID in CEN_CENSUS_SUBDIVISIONS_SP, e.g., 5901022. With CENSUS_YEAR, this identifies the community in which the school is located.
SCHOOL_NAME SCHOOL_NM VARCHAR2 100 SCHOOL NAME: The name of the school, e.g., Gordon Terrace Elementary
SCHOOL_DISTRICT SCHL_DSTRT VARCHAR2 50 SCHOOL DISTRICT: School district that the school is located in, e.g., Southeast Kootenay
ELEMENTARY_SCHOOL_ENROLLMENT ELMNTRY_ST NUMBER 5 ELEMENTARY SCHOOL ENROLLMENT: The number of student enrolled in grades 1 through 7, e.g., 221
SECONDARY_SCHOOL_ENROLLMENT SCNDRY_SCT NUMBER 5 SECONDARY SCHOOL ENROLLMENT: The number of student enrolled in grades 8 through 12, e.g., 27
SCHOOL_YEAR_PERIOD SCHL_YR_PD VARCHAR2 9 SCHOOL YEAR PERIOD: is the school year period for which the data pertains, e.g., 2013/2014
DATA_PUBLICATION_YEAR DT_PBLCTNR NUMBER 4 DATA PUBLICATION YEAR: The year in which the source of the information in this table was published, e.g., 2014
LATITUDE LATITUDE NUMBER 8 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 9 LONGITUDE is the geographic coordinate, in decimal degrees (dd.dddddd), of the location of the feature as measured from the prime meridian, e.g., -123.093544