Assisted Living Locations

0 views (0 recent)

Published by the Ministry of Health - Seniors Services Branch
Licensed under Open Government Licence - British Columbia

This dataset provides information which is currently displayed on the Assisted Living Programs Map. The intent of the Assisted Living Programs Map is to provide an online resource to assist families searching for all types of assisted living services, including seniors, mental health and supportive recovery. Information is listed by service type, registrant, name of residence, address, city and maximum capacity. This dataset includes both publicly subsidized and private paid residences. New registered assisted living residences are added as they become operational. The dataset is updated biweekly.

Data and Resources

Dataset Extent

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

Additional Information

Contact Information

NameJulie Brown (pointOfContact)
EmailJulie.Brown@gov.bc.ca
OrganizationMinistry of Health
Sub-OrganizationSeniors Services Branch
NameAngela French (pointOfContact)
EmailAngela.French@gov.bc.ca
OrganizationMinistry of Health
Sub-OrganizationSeniors Services Branch

Access & Security

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

Metadata Information

Record Published 2019-10-15
Record Last Modified 2019-10-18
Resource Status onGoing
Spatial DataSDO_GEOMETRY

Object Description

Object Name: WHSE_IMAGERY_AND_BASE_MAPS.GSR_ASSISTED_LIVING_LOCS_SV

Short Name: ASSIST_LIV
Comments: GSR_ASSISTED_LIVING_LOCS_SV is a spatially enabled layer comprising locations of assisted living residences for seniors, mental health services, and supportive recovery in British Columbia.

Column Name Short Name Data Type Data Precision Comments
OPERATOR_NAME OPERATR_NM VARCHAR2 500 OPERATOR_NAME is the name of the organization operating the residence, e.g., Amica Mature Lifestyles Inc.
BUSINESS_NAME BUSINSS_NM VARCHAR2 500 BUSINESS_NAME is the name of the residence, e.g., Amica at Arbutus Manor.
STREET_ADDRESS 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.
LOCALITY LOCALITY VARCHAR2 100 LOCALITY is the name of the municipality, community, Indian reservation, subdivision, regional district, aboriginal lands, or natural feature the occupant site is located in, e.g., Victoria, Saanich IR 1, Capital Regional District.
POSTAL_CODE POSTAL_CD VARCHAR2 10 POSTAL CODE is the Canadian Postal code value associated with the physical address, e.g., V9Z 2K1.
BUSINESS_PHONE BUSINSS_PH VARCHAR2 50 BUSINESS_PHONE contains the "general office" phone number of the Occupant.
TYPE TYPE VARCHAR2 100 TYPE is the type of residence, i.e., Assisted Living.
MENTAL_HEALTH_IND MNTL_HLTH VARCHAR2 5 MENTAL_HEALTH_IND indicates whether or not mental health services is provided at the residence, i.e., Y (true), N (false).
MENTAL_HLTH_PRIV_PAY_UNITS MH_PRV_NUM NUMBER 5 MENTAL_HEALTH_PRIVATE_PAY_UNITS is the number of privately-paid living units for mental health services at the residence, e.g. 10.
MENTAL_HLTH_PUBLIC_UNITS MH_PUB_NUM NUMBER 5 MENTAL_HEALTH_PUBLIC_UNITS is the number of publicly-funded living units for mental health services at the residence, e.g., 10.
SENIOR_ASSISTED_LIVING_IND SR_LIVING VARCHAR2 5 SENIOR_ASSISTED_LIVING_IND indicates whether or not assisted living for seniors is provided at the residence, i.e., Y (true), N (false).
SENIOR_PRIVATE_PAY_UNITS SR_PRV_NUM NUMBER 5 SENIOR_PRIVATE_PAY_UNITS is the number of privately-paid living units for seniors at the residence, e.g. 10.
SENIOR_PUBLIC_UNITS SR_PUB_NUM NUMBER 5 SENIOR_PUBLIC_UNITS is the number of publicly-funded living units for seniors at the residence, e.g. 10.
SUPPRTV_RCVRY_IND SUPRT_RCOV VARCHAR2 5 SUPPRTV_RCVRY_IND indicates whether supportive recovery services is provided at the residence, i.e., Y (true), N (false).
SUPPRTV_RCVRY_PRIV_PAY_UNITS RCOV_PRV_N NUMBER 5 SUPPRTV_RCVRY_PRIV_PAY_UNITS is the number of privately-paid living units for supportive recovery services at the residence, e.g. 10.
SUPPRTV_RCVRY_PUBLIC_UNITS RCOV_PUB_N NUMBER 5 SUPPRTV_RCVRY_PUBLIC_UNITS is the number of publicly-funded living units for supportive recovery services at the residence, e.g. 10.
INSPECTION_URL INSPCT_URL VARCHAR2 254 INSPECTION_URL is a link to the inspection report for the residence.
GOVERNING_ACT GOVRN_ACT VARCHAR2 254 GOVERNING_ACT is the name of the act which governs operations.
GOVERNING_REGULATION GOVRN_REG VARCHAR2 254 GOVERNING_REGULATION is the name of the regulation which governs operations.
HEALTH_AUTHORITY HLTH_AUTH VARCHAR2 100 HEALTH_AUTHORITY is the name of the regional health authority that the residence is in, e.g. Vancouver Coastal.
LATITUDE LATITUDE NUMBER 9 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
LONGITUDE LONGITUDE NUMBER 10 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
CUSTODIAN_ORG_DESCRIPTION CUSTDN_ORG VARCHAR2 200
BUSINESS_CATEGORY_CLASS BIZ_CLASS VARCHAR2 1000
BUSINESS_CATEGORY_DESCRIPTION BIZ_DESCR VARCHAR2 1000
OCCUPANT_TYPE_DESCRIPTION OCCPNT_TYP VARCHAR2 500
SOURCE_DATA_ID SRCDATA_ID VARCHAR2 20
SHAPE SHAPE SDO_GEOMETRY 64
SEQUENCE_ID SQNC_ID NUMBER 10
SE_ANNO_CAD_DATA BLOB 4000