Child Care Map Data

991 views (39 recent)

Published by the Ministry of Children and Family Development - Child Care Programs and Services
Licensed under Open Government License - British Columbia

This dataset provides information which is currently displayed on the Child Care Programs Map. The intent of the Child Care Programs Map is to provide an online resource to assist families searching for ministry-funded licensed child care listed by city, address, licence type and services offered. New licensed child care facilities are added as they become operational. The dataset is updated daily. Child Care Map Application

Data and Resources

Dataset Extent

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

Additional Information

Purpose

This data is assembled and published as an online resource to maintain a list of ministry-funded licensed child care locations, their services offered and available spaces to assist families searching for licensed child care.

Data Quality
Lineage Statement

Contact Information

NameChild Care Operating Funding Program (pointOfContact)
Emailmcf.ccof@gov.bc.ca
OrganizationMinistry of Children and Family Development
Sub-OrganizationChild Care Programs and Services

Access & Security

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

Metadata Information

Record Published 2017-10-26
Record Last Modified 2018-12-13
Resource Status completed

Object Description

Object Name: WHSE_IMAGERY_AND_BASE_MAPS.GSR_CHILD_CARE_PROVIDERS_SVW

Short Name: CC_PRVDRS
Comments: GSR_CHILD_CARE_PROVIDERS_SVW is a spatially enabled layer comprising CHILD CARE PROVIDERS is a dataset comprised of Ministry funded licensed child care providers in British Columbia.

Column Name Short Name Data Type Data Precision Comments
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.
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., childDayCareServices
BUSINESS_CATEGORY_DESCRIPTION BUS_CAT_DS VARCHAR2 1000 BUSINESS_CATEGORY_DESCRIPTION describes the category of business, i.e., Child day-care services
OCCUPANT_TYPE_DESCRIPTION OCCPNT_TYP VARCHAR2 500 OCCUPANT_TYPE_DESCRIPTION contains the description of the occupant type, e.g. Hospital
FACILITY_ID FCLTY_ID VARCHAR2 20 FACILITY_ID contains the identifier from Childcare Operating Fund (CCOF) Source System, e.g., 1001
SERVICE_TYPE_DESC S_TYPE_DSC VARCHAR2 30 SERVICE_TYPE_DESC indicates whether the child care facility is a Group Care or Licensed Family facility, i.e. Licensed Group or Licensed Family.
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 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., Little Ducks Daycare
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
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.
ADDRESS_LINE_2 ADDR_LINE2 VARCHAR2 200 ADDRESS_LINE_2 contains additional information about the facility's location, e.g., University of Victoria
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.
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
OP_WEEKDAY_IND OPEN_WKDY VARCHAR2 7 OP_WEEKDAY_IND indicates whether or not the facility is open on weekdays, i.e., Y or N
OP_WEEKEND_IND OPEN_WKND VARCHAR2 7 OP_WEEKEND_IND indicates whether or not the facility is open on weekends, i.e., Y or N
OP_STAT_HOLIDAY_IND OPEN_STAT VARCHAR2 7 OP_STAT_HOLIDAY_IND indicates whether or not the facility is open on statutory holidays, i.e., Y or N
OP_OVERNIGHT_IND OPEN_OVRNT VARCHAR2 7 OP_OVERNIGHT_IND indicates whether or not the facility is open for overnight stays, i.e., Y or N
OP_EXT_WEEKDAY_BEFORE6AM_IND OPEN_B_6AM VARCHAR2 7 OP_EXT_WEEKDAY_BEFORE6AM_IND indicates whether or not the facility is open for extended hours - before 6 a.m.-- on weekdays, i.e., Y or N
OP_EXT_WEEKDAY_AFTER7PM_IND OPEN_A_7PM VARCHAR2 7 OP_EXT_WEEKDAY_AFTER7PM_IND indicates whether or not the facility is open for extended hours - after 7 p.m - on weekends, i.e., Y or N
SRVC_UNDER36_IND S_UNDR_36 VARCHAR2 7 SRVC_UNDER36_IND indicates whether or not the facility offers child care services to children under 36 months of age, i.e., Y or N
SRVC_30MOS_5YRS_IND S_30M_5Y VARCHAR2 7 SRVC_30MOS_5YRS_IND indicates whether or not the facility offers child care services to children between the ages of 30 months and 5 years, i.e., Y or N
SRVC_LICPRE_IND S_LICPRE VARCHAR2 7 SRVC_LICPRE_IND indicates whether or not the facility is a licensed preschool, i.e., Y or N
SRVC_OOS_KINDER_IND S_OOS_KNDR VARCHAR2 7 SRVC_OOS_KINDER_IND indicates whether or not the facility offers care for out of school care for kindergarten aged children, i.e., Y or N
SRVC_OOS_GR1_AGE12_IND S_OOS_1_12 VARCHAR2 7 SRVC_OOS_GR1_AGE12_IND indicates whether or not the facility offers care for out of school care for children in grade 1 up to the age of 12, i.e., Y or N
LANG_CANTONESE_IND L_CANTNESE VARCHAR2 7 LANG_CANTONESE_IND indicates whether services are offered in Cantonese, i.e., Y or N
LANG_PUNJABI_IND L_PUNJABI VARCHAR2 7 LANG_PUNJABI_IND indicates whether services are offered in Punjabi, i.e., Y or N
LANG_MANDARIN_IND L_MANDARIN VARCHAR2 7 LANG_MANDARIN_IND indicates whether services are offered in mandarin, i.e., Y or N
LANG_FRENCH_IND L_FRENCH VARCHAR2 7 LANG_FRENCH_IND indicates whether services are offered in French, i.e., Y or N
LANG_SPANISH_IND L_SPANISH VARCHAR2 7 LANG_SPANISH_IND indicates whether services are offered in Spanish, i.e., Y or N
LANG_OTHER_IND L_OTHER VARCHAR2 7 LANG_OTHER_IND indicates whether services are offered in any other languages, i.e., Y or N
PROVIDE_MEALS_DESC PRVD_MEALS VARCHAR2 30 PROVIDE_MEALS_DESC indicates whether or not meals are included, available for extra cost, or are not provided at all, i.e., Included in fee, Not offered, Extra fee
PROVIDE_PICKUP_DESC PRVD_PCKUP VARCHAR2 30 PROVIDE_PICKUP_DESC indicates whether or not pickup services are included, available for extra cost, or are not provided at all, i.e., Not Offered, Extra Fee
PRESCHOOL_MORNING_IND PS_MORNING VARCHAR2 7 PRESCHOOL_MORNING_IND indicates whether morning preschool sessions are offered, i.e., Y or N
PRESCHOOL_MIDDAY_IND PS_MIDDAY VARCHAR2 7 PRESCHOOL_MIDDAY_IND indicates whether midday preschool sessions are offered, i.e., Y or N
PRESCHOOL_AFTERNOON_IND PS_AFTNOON VARCHAR2 7 PRESCHOOL_AFTERNOON_IND indicates whether afternoon preschool sessions are offered, i.e., Y or N
ABORIGINAL_PROGRAMMING_IND AB_PROG_IN VARCHAR2 7 ABORIGINAL_PROGRAMMING_IND indicates whether the facility offers aboriginal specific programming, i.e., Y or N
ACCOMMODATE_SPECIAL_NEEDS_IND SPCL_NEEDS VARCHAR2 7 ACCOMMODATE_SPECIAL_NEEDS_IND indicates the facility's ability to accommodate children with special needs, i.e., Y or N
ECE_CERTIFICATION_IND ECE_CERT VARCHAR2 7 ECE_CERTIFICATION_IND indicates one or more persons employed at the facility is an Early Childhood Educator (ECE), i.e., Y or N
ELF_PROGRAMMING_IND ELF_PRGMNG VARCHAR2 7 ELF_PROGRAMMING_IND indicates the provider uses the Early Learning Framework (ELF), i.e., Y or N
VACANCY_SRVC_UNDER36_IND VS_UNDR_36 VARCHAR2 7 VACANCY_SRVC_UNDER36_IND indicates whether or not the facility has any vacancies for children under 36 months of age, i.e., Y or N
VACANCY_SRVC_30MOS_5YRS_IND VS_30M_5Y VARCHAR2 7 VACANCY_SRVC_30MOS_5YRS_IND indicates whether or not the facility has any vacancies for children between the ages of 30 months and 5 years
VACANCY_SRVC_LICPRE_IND VS_LICPRE VARCHAR2 7 VACANCY_SRVC_LICPRE_IND indicates whether or not the facility has any vacancies for licensed preschool spots
VACANCY_SRVC_OOS_GR1_AGE12_IND VS_OOS1_12 VARCHAR2 7 VACANCY_SRVC_OOS_GR1_AGE12_IND indicates whether or not the facility has any vacancies for out of school care for children in grade 1 up to the age of 12, i.e., Y or N
VACANCY_LAST_UPDATE_DATE V_LAST_UPD VARCHAR2 40 VACANCY_LAST_UPDATE_DATE indicates the last time the vacancy information for that facility has last been updated
HA_FAC_INSPEC_RPTS_URL HA_F_IN_RP VARCHAR2 500 HA_FAC_INSPEC_RPTS_URL indicates the internet URL where users can access Facility Inspection Reports for the facility
IS_INCOMPLETE_TEXT CHAR 98
DESC_FULL_ADDRESS VARCHAR2 518
DESC_PROGRAMS_PROVIDED VARCHAR2 123
DESC_HOURS_OF_OPERATION VARCHAR2 114
DESC_PRESCHOOL_SESSIONS VARCHAR2 32
DESC_MAPTIP_PRESCHOOL_SESSIONS VARCHAR2 48
DESC_ADDITIONAL_LANGUAGES VARCHAR2 58
DESC_ABORIGINAL_PROGRAMMING VARCHAR2 22
DESC_SPECIAL_NEEDS VARCHAR2 26
DESC_ECE_CERTIFICATION VARCHAR2 17
DESC_ELF_PROGRAMMING VARCHAR2 15
VACANCY_IND VARCHAR2 7
VACANCY_FOR_LICENSE VARCHAR2 32
IS_INCOMPLETE_IND VARCHAR2 1 IS_INCOMPLETE_IND indicates whether the values for any of the other columns is null (unknown).
IS_CCFRI_AUTH_IND VARCHAR2 1 IS_CCFRI_AUTH_IND indicates that the child care facility has opted in and been approved for the Childcare Fee Reduction Initiative (CCFRI) for the current period, i.e., Y, N.
IS_MULTI_LOCN_IND VARCHAR2 1 IS_MULTI_LOCN_IND indicates whether multiple childcare facilities with the same name are located at the same address, i.e., Y, N.
SHAPE SHAPE SDO_GEOMETRY 64 SHAPE is the column used to reference the spatial coordinates defining the feature.
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.