Mental Health and Substance Use Health Services
1206 views (33 recent)Published by the Ministry of Health - HealthLinkBC
Licensed under Open Government Licence - British Columbia
Data and Resources
HealthLinkBC MHSU AIRS Taxonomy Classificationxlsx
Listing of all AIRS Taxonomy terms with associated Taxonomy Code and...
HealthLinkBC MHSU Field Definitionspdf
Plain language description of each HealthLinkBC Directory taxonomy term...
CSV file formatted for use by the DataBC broker to populate the Mental Health...
KML file formatted for use by the DataBC mapping application to create a...
HealthLinkBC MHSU Health Servicescsv
Extract of all MHSU related listings from HealthLinkBC as of May 27-2020
BC Geographic Warehouse Custom Downloadother
|Latitude:||48.0° to 60.0°|
|Longitude:||-139.5° to -113.5°|
The primary purpose of this data is for populating the HealthLinkBC Directory. The HealthLinkBC Directory is a public service that provides detailed information about how and where to access health services in British Columbia. The Directory is funded by the provincial government and delivered by HealthLinkBC through https://www.healthlinkbc.ca/ or by dialling 8-1-1. The purpose of the HealthLinkBC Directory is to help British Columbians maintain and achieve better health by providing them with the right information at the right time. As a publicly-funded service, the directory includes health care and mental health and addiction services that are publicly funded (either in whole or in part) and serve the residents of British Columbia.
The secondary purpose of this data is for populating the Mental Health and Substance Use Supports in B.C. digital hub at https://www2.gov.bc.ca/gov/content/mental-health-support-in-bc and the StopOverdose website at https://www.stopoverdose.gov.bc.ca/
The data included in the HealthLinkBC Directory and by extension this data set, is maintained by the Health Information Design and Delivery team of HealthLink BC, Ministry of Health. All records in the Directory are reviewed for accuracy and completeness at minimum every two years by a Data Steward of HealthLink BC working direct with an administrator of the service listed in the record.
|Organization||Ministry of Health|
Access & Security
|Who can view this dataset?||Public|
|Who can download this dataset?||Public|
|Record Last Modified||2020-05-28|
Object Name: WHSE_IMAGERY_AND_BASE_MAPS.GSR_MENTAL_HLTH_SUBSTCE_USE_SV
Short Name: MHSU
Comments: GSR_MENTAL_HLTH_SUBSTCE_USE_SV is a spatially enabled layer comprising
|Column Name||Short Name||Data Type||Data Precision||Comments|
|SERVICE_NAME||SERV_NAME||VARCHAR2||500||The name of the program or service, e.g., Youth Mindfulness Group, Mind Fit.|
|DESCRIPTION||DESCRPTN||VARCHAR2||4000||A description of the services provided.|
|CONTACT_PHONE||PHONE||VARCHAR2||50||Contains the "general office" phone number of the organization providing the service, e.g., 6044640345.|
|WEBSITE_URL||WEBSITE||VARCHAR2||500||Contains the full URL link to a web page that describes the program or service.|
|CONTACT_EMAIL||VARCHAR2||100||Contains the "general office" email address of the organization providing the service.|
|STREET_ADDRESS||ADDRESS||VARCHAR2||200||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. Note that some services may not be associated with a physical address (e.g., online services).|
|LOCALITY||LOCALITY||VARCHAR2||100||The name of the municipality, community, Indian reservation, subdivision, regional district, aboriginal lands, or natural feature in which the service is located, e.g., Victoria, Saanich IR 1, Capital Regional District. Note that some services may not be associated with a physical address (e.g., online services).|
|POSTAL_CODE||POSTAL_CD||VARCHAR2||10||The Canadian Postal code value associated with the physical address, e.g., V9Z 2K1.|
|KEYWORDS||KEYWORDS||VARCHAR2||1000||Contains text strings supplied by the Custodian, to be used for search/query purposes. Keywords are separated by the ; delimiter.|
|LATITUDE||LATITUDE||NUMBER||9||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||The geographic coordinate, in decimal degrees (-ddd.dddddd), of the location of the feature as measured from the prime meridian, e.g., -123.093544.|
|ORGANIZATION_NAME||ORG_NAME||VARCHAR2||100||The name of the organization operating the program or service, e.g., YWCA Metro Vancouver, Our Place Society.|
|SERVICE_REF||SERV_REF||NUMBER||10||A unique number, called an Internal Service Key, that is assigned to uniquely identify the service or program, e.g., 17640736.|
|WHEELCHAIR_ACCESSIBLE_IND||WHLCHR_ACC||VARCHAR2||1||Indicates whether the location is wheelchair accessible.|
|HOURS_OF_OPERATION||HOURS||VARCHAR2||500||A list of the hours of operation for each day of the week and other related notes about days and times when the service may be closed.|
|PROVINCE||PROVINCE||VARCHAR2||2||The province or territory in which the service is offered, e.g., BC.|
|WEBSITE_HEALTHLINKBC_URL||HLBC_URL||VARCHAR2||254||The link to the 811 service record in the HealthLink BC Directory.|
|DATE_UPDATED||DATE_UPDTD||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.|
|OBJECTID||OBJECTID||NUMBER||10||OBJECTID is a column required by spatial layers that interact with ESRI ArcSDE.|
|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.|