Residential Care Facilities
0 views (0 recent)
Published by the Ministry of Health - Seniors Services BranchLicensed under Open Government Licence - British Columbia
Data and Resources
-
BC Geographic Warehouse Custom Downloadother
-
WMS getCapabilities requestwms
For use in viewers such as ESRI tools Click here for information on how to...
-
KML Network Linkkml
For use in viewers such as Google Earth Click here for information on how...
-
GSR_residential_care_csv
(321.9 KiB)
Source tabular data of residential care locations with latitude and longitude...
Additional Information
Contact Information
Name | Julie Brown (pointOfContact) |
Julie.Brown@gov.bc.ca | |
Organization | Ministry of Health |
Sub-Organization | Seniors Services Branch |
Name | Angela French (pointOfContact) |
Angela.French@gov.bc.ca | |
Organization | Ministry of Health |
Sub-Organization | Seniors 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 | 2021-03-02 |
Resource Status | onGoing |
Spatial Data | SDO_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. |