Residential Care 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 Residential Care Programs Map. The intent of the Residential Care Programs Map is to provide an online resource to assist families searching for all types of care under the Residential Care Regulation, including long term care, community living, hospice, acquired brain injury, mental health, substance use and child and youth residential care. Information is listed by care type, licensee, name of facility, address, city and maximum capacity. This dataset includes both publicly subsidized and private paid facilities. New licensed residential care facilities 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-11-01
Resource Status onGoing
Spatial DataSDO_GEOMETRY

Object Description

Object Name: WHSE_IMAGERY_AND_BASE_MAPS.GSR_RESIDENTIAL_CARE_LOCS_SV

Short Name: RESID_CARE
Comments: GSR_RESIDENTIAL_CARE_LOCS_SV is a spatially enabled layer comprising locations of residential care facilities which provide services such as nursing, mental health care, and end of life care.

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 facility, e.g., High Road Services Society.
BUSINESS_NAME BUSINSS_NM VARCHAR2 500 BUSINESS_NAME is the name of the facility, e.g., Alfred Adult Residential.
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 facility, i.e., Residential Care.
MENTAL_HEALTH_IND MNTL_HLTH VARCHAR2 5 MENTAL_HEALTH_IND indicates whether or not mental health care is provided at the facility, i.e., Y (true), N (false).
MENTAL_HEALTH_MAX_CAP M_HLTH_MAX NUMBER 5 MENTAL_HEALTH_MAX_CAP is the maximum number of units available for mental health care at the facility, e.g., 10.
HOSPICE_IND HOSPICE VARCHAR2 5 HOSPICE_IND indicates whether or not whether or not hospice care is provided at the facility, i.e., Y (true), N (false).
HOSPICE_MAX_CAP HOSPCE_MAX NUMBER 5 HOSPICE_MAX_CAP is the maximum number of units available for hospice care at the facility, e.g., 10.
SUBSTANCE_USE_IND SUBST_USE VARCHAR2 5 SUBSTANCE_USE_IND indicates whether or not substance use care is provided at the facility, i.e., Y (true), N (false).
SUBSTANCE_USE_MAX_CAP S_USE_MAX NUMBER 5 SUBSTANCE_USE_MAX_CAP is the maximum number of units available for substance use care at the facility, e.g., 10.
LONG_TERM_CARE_IND LNGTRMCARE VARCHAR2 5 LONG_TERM_CARE_IND indicates whether or not long-term care is provided at the facility, i.e., Y (true), N (false).
LONG_TERM_CARE_MAX_CAP LTCARE_MAX NUMBER 5 LONG_TERM_CARE_MAX_CAP is the maximum number of units available for long-term care at the facility, e.g., 10.
COMMUNITY_LIVING_IND CMMNTY_LIV VARCHAR2 5 COMMUNITY_LIVING_IND indicates whether or not community living care is provided at the facility, i.e., Y (true), N (false).
COMMUNITY_LIVING_MAX_CAP COMLIV_MAX NUMBER 5 COMMUNITY_LIVING_MAX_CAP is the maximum number of units available for community living care at the facility, e.g., 10.
ACQUIRED_BRAIN_INJURY_IND ACQ_BRNINJ VARCHAR2 5 ACQUIRED_BRAIN_INJURY_IND indicates whether or not acquired brain injury care is provided at the facility, i.e., Y (true), N (false).
ACQUIRED_BRAIN_INJURY_MAX_CAP ACQBRN_MAX NUMBER 5 ACQUIRED_BRAIN_INJURY_MAX_CAP is the maximum number of units available for acquired brain injury care at the facility, e.g., 10.
INSPECTION_URL INSPCT_URL VARCHAR2 254 INSPECTION_URL is a link to the inspection report for the facility.
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 facility is in, e.g. Vancouver Coastal.
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
CUSTODIAN_ORG_DESCRIPTION CUSTDN_ORG VARCHAR2 200 CUSTODIAN_ORG_DESCRIPTION contains the name or description of the custodial organization e.g. Ministry of Agriculture.
BUSINESS_CATEGORY_CLASS BIZ_CLASS VARCHAR2 1000 BUSINESS_CATEGORY_CLASS is the designation that the business belongs to. E.g. accommodationFoodServices.accommodations or educationalServices.multiLevelSchool
BUSINESS_CATEGORY_DESCRIPTION BIZ_DESCR 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_DESCRIPTION OCCPNT_TYP VARCHAR2 500 OCCUPANT_TYPE_DESCRIPTION contains the description of the occupant type e.g. Hospital
DATE_UPDATED DATE_UPD 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.
SEQUENCE_ID SQNC_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.