In Scotland, smoking and alcohol are two of the most important preventable causes of ill-health and premature death: one in every five deaths is attributable to tobacco and one in 20 to alcohol. The neighbourhood availability of tobacco and alcohol products has been implicated in promoting smoking and drinking behaviours. In CRESH we’ve been investigating the links between tobacco and alcohol environments and health (see here and here for more details). In partnership with Alcohol Focus Scotland (AFS) and Action on Smoking and HealthScotland (ASH Scotland) we’ve been funded by the Economic and Social Research Council (ESRC) to publicise our research and make it more accessible to the public and policy makers. In 2015, this enabled us to create a webmap and data download facility, as well as some eye-catching infographics for smoking and alcohol.
In May 2017 we updated the webmap and data download facility to version 2.0. This allows you to map the most recent alcohol and tobacco outlet count data for small neighbourhoods across Scotland, with some extra functionality to aid your experience. Future updates will allow you to visualise change in provision over time. At this point you are able to select between total alcohol sales, alcohol on sales, alcohol off sales, both on and off alcohol sales and total tobacco sales. When the webmap is first loaded your browser will ask if you would like to share your location. If you grant permission then the map will automatically zoom to your location. If you would prefer not to share this information, then you can select to see the data for the whole of scotland, between one and five local authorities, or you can search for a specific town or postcode. The added functionality is in the form of both presentation of the data and the versatility of download. The data can now be presented in a number of ways by specifying the year, typical distance to outlet (buffer size) and rank colour options. We have also made it possible to change the basemap to give your map a different focus. 'CartoDB Positron' is a light and subtle background map, it is good for accentuating the colours of the outlet counts. 'Stamen Toner' is a high-contrast B+W (black and white) map, which highlights the difference between land and water, and the road network. Finally, 'OSM' is the most detailed background map and can be useful for locating specific features of the urban environment.
In Scotland there are five licensing objectives to be considered when granting a licence to sell alcohol; the fifth objective is to protect and improve public health. Licensing boards are also required to assess overprovision of licensed premises in the board’s area. Until now this information has not been readily available to local residents. Our aim is to make the data publicly available allowing users to question notions of overprovision.
The website is free to use and the data are also free. You can explore the data as you wish, however as this is a funded project we ask you for some details before you download the data. This information will allow us to track data use and make improvements to the website in the future. Once this is completed the user will be granted access to the full data set with the data changing dynamically based on the options specified previously. This allows a bespoke dataset to be downloaded and used for further analysis.
On this page we describe the information that can be displayed and downloaded through the webmap site. For more information about the project please contact Dr Niamh Shortt at email@example.com or Dr Mark Cherrie at firstname.lastname@example.org.
The area boundaries that can be shown on the map can all be downloaded from other sources, for use in mapping software such as QGIS.
Neighbourhoods (= ‘datazones’)
The neighbourhood outlet, deaths and deprivation data that can be mapped all refer to small areas called ‘datazones’. Datazones are the main administrative geography used in Scotland, and are used for the dissemination of many types of official statistics (see http://statistics.gov.scot/). There are 6,976 datazones in Scotland, with populations typically between 500 and 1000. We use data zone boundaries to represent local neighbourhoods. Datazone boundaries are available from here.
Data can be displayed for Local Authorities (32 in Scotland), these boundaries can be downloaded as part of Ordnance Survey’s Boundary-Line product.
Neighbourhood DataAlcohol and tobacco outlet counts
We collated alcohol and tobacco outlet location data as part of an earlier project funded by the Scottish Collaboration for Public Health Research and Policy (SCPHRP). (Find out more about this work here). We obtained the locations of all outlets in Scotland licensed to sell alcohol for consumption on the premises (on-sales), off the premises (off-sales), both (on and off-sales) from each local licensing board in 2012 and 2016. We also obtained the locations of all premises registered on the Scottish Tobacco Retailers Register for 2012 and 2016. The datasets were checked for errors (e.g., duplications).
We counted the number of each outlet type within 800 m of the population centre of each datazone (800 m represents a 10-minute walk at average pace). This 800 m zone was assumed to represent the typical neighbourhood experienced by the population of a datazone, and was unaffected by artificially-imposed datazone boundaries or differing datazone sizes. Figure 1 below shows that a circle with a radius of 800 m around this datazone’s population centre (red star) contains 73 on-sales alcohol outlets, and that this includes a number within neighbouring datazones.
Figure 1: The number of on-sales alcohol outlets within 800 m of the population centre of one datazone.
This process was repeated for different buffer zone distances (400 m - 5,000 m). This was undertaken because of the acknowledgement that the urban/rural nature of the datazone may affect typical distances travelled, with more rural residents travelling further to reach their nearest outlet. We have provided options to compare the colour of each individual datazone count value to several averages: Scotland, Local Authority, Urban Rural Group and Deprivation Group. For the urban rural group comparison we used the 2013/2014 Urban Rural Classification (6-Fold). Therefore if a datazone was within urban rural Group 3, then it's count value would be compared to the Scottish average for Urban Rural Group 3. For the deprivation comparison we used quintiles of the SIMD 2016 income rank. As with the urban rural group comparison, individual data zone count values were compared against the Scottish average for specific quintiles of deprivation.
Alcohol hospitalisations data
Alcohol hospitalisations data were derived from the SIMD 2016 health domain. This is defined as the standardised ratio for hospital stays related to alcohol misuse.
Crime data were derived from the SIMD 2016 crime domain. This is defined as the count of recorded crimes of violence, sexual offences, domestic housebreaking, vandalism, drugs offences, and common assault per 10,000 people.Alcohol- and tobacco-related deaths
We have used deaths data to give an indication of the ill-health due to alcohol or tobacco in each neighbourhood. We requested deaths from lung cancer and lung disease, and those due to alcohol-related causes (defined by NHS Scotland here) for the period (2011 to 2015) National Records of Scotland's (NRS) statistics of Vital Events. We selected lung cancer and lung disease to provide a measure of tobacco-related illness because the large majority of these deaths are due to smoking. However, we acknowledge that a portion of these deaths may not have been related to smoking, and that a number of other causes of death (e.g., heart disease, other cancers, or diseases of the digestive system) are partly attributable to smoking. As a result our indicator will represent a substantial under-estimate of the smoking-related death rate. Detailed information about smoking-related illness is available from NHS Scotland here.
Numbers of deaths should not be compared between datazones because datazones have different population sizes, and the split between males and females, or younger and older people, will vary. Rates are often used for comparing areas, as these express deaths per 100,000 people. But as datazone populations are quite small, cause-specific death rates can be unreliable. We therefore used a more reliable method to ensure comparability: we calculated a Standardised Mortality Ratio (SMR) by comparing the number of deaths in each datazone to the number that would have been expected based on the average rates for Scotland (by age group and sex). The Scottish SMR for alcohol-related deaths or lung cancer and lung disease deaths is fixed at 100: datazones with SMRs higher than 100 can be said to have a higher rate than the Scottish average, and those with SMRs less than 100 have a lower rate. We acknowledge that there will be some instability in the mortality rates presented given that they are based on a low number of events.
Deaths data for individual datazones, and the SMRs we have derived from these data, are considered sensitive data by law and cannot legally be distributed publicly. Hence we have provided the data categorised into quintiles.
As not to duplicate data presented elsewhere for each datazone we provide a link to further information from statistics.gov.uk. For example clicking on the the "Canongate, Southside and Dumbiedykes -05" datazone link will redirect here. This webpage gives information on geography, housing, health, deprivation and urban/rural classification.
Several option boxes are located to the left – 'Local Authorities', 'Enter an Area of Interest', 'Data Type', 'Year', 'Typical Distance to Outlet (metres)' and 'Rank Colour Options'. When the website is first loaded you will be prompted on whether you would like to share your location, if you accept, the map will zoom to your current IP location (with a blue marker diplayed on your predicted location). If not, or if you would prefer to look at another area, then you can use the first two options on the options panel to locate an area on the map that you are interested in. In the "Local Authorities" option box you can choose from one to five of the 32 local authorites, or the whole of Scotland. If it is a specific local area then it might be better to type in an address to the "Enter an Area of Interest" box and click the Enter icon (with a blue marker diplayed on your predicted location). By specifying the location of the map in any of these three ways you will then be presented with the default options for the data- Data Type="Alcohol Total Sales", Year="2016", Typical Distance to Outlet (m)="800" and Rank Colour Options="Compared to Scottish Average". You are then able to change these options to dynamically display the data in different ways. For full information on the options see the 'About' tab. If you get stuck whilst using the application then hover over the option boxes with your cursor, to get some helpful tips instantly.
Understanding the map
When you have selected the geography and data type then you can explore the map using the map options in the corners of the map. In the bottom left hand corner is the scale bar which will change dynamically as you zoom. In the right hand corner is the Colour Rank, with red signifying a high number of outlets, yellow an average number of outlets and blue a low number of outlets, with the choice of comparison based on the option specified in the "Rank Colour Options" box. In the top left hand corner is the + and - zoom options, so that you can pan around the map to different areas. Below these is the full screen option, which we recommend using for taking screenshots of the maps. On the top right of the map is the basemap options, this includes some well known layers including CartoDB Positron designed by Stamen, Toner designed by Stamen and Open Street Map (OSM).
Hovering over a neighbourhood will turn the boundary black. By clicking a neighbourhood a text box will appear containing information on outlet count, health and crime. This neighbourhood's statistics will be compared to others based on the option selected for "Rank Colour Options" (e.g. Scotland, Local authority, SIMD group or urban/rural group). Note than the outlet availability is measured as number within a certain distance (determined by "typical distance to outlet (metres)" option) from the neighbourhood’s population centre. It is not the number of outlets within each datazone – such a measure wouldn’t be comparable between neighbourhoods because they differ in size so widely, and would also be artificially constrained by the neighbourhood boundaries in a way that residents aren’t in real life.
Downloading the dataThe map is useful for looking at the stats for a single neighbourhood and seeing the general patterns of outlet count, health and crime in the surrounding area, but what if you want to look at the data in greater depth, for example to find out how that neighbourhood ranks against others? To do this you can download the data for the area of interest:·
Feedback from the CRESH team, Jenn Ruddick (AFS), Aidan Collins (AFS) and Megan McNicol (NHS Analytical Exchange Programme 2017) facilitated the development of the app. The app was built in Rstudio (0.98.507) with support from the R user community. In particular the guides written by Dean Attali were invaluable. We acknowledge that the data on alcohol outlets were kindly supplied by representatives from each of the local authorities. We would also like to acknowledge the support from the following organisations:
Effective date: November 22, 2018
https://cresh.org.uk/ ("us", "we", or "our") operates the https://creshmap.com/ website (the "Service").
We collect several different types of information for various purposes to provide and improve our Service to you.
While using our Service, we may ask you to provide us with certain personally identifiable information that can be used to contact or identify you ("Personal Data"). Personally identifiable information may include, but is not limited to:
We may also collect information how the Service is accessed and used ("Usage Data"). This Usage Data may include information such as your computer's Internet Protocol address (e.g. IP address), browser type, browser version, the pages of our Service that you visit, the time and date of your visit, the time spent on those pages, unique device identifiers and other diagnostic data.
Cookies are files with small amount of data which may include an anonymous unique identifier. Cookies are sent to your browser from a website and stored on your device. Tracking technologies also used are beacons, tags, and scripts to collect and track information and to improve and analyze our Service.
You can instruct your browser to refuse all cookies or to indicate when a cookie is being sent. However, if you do not accept cookies, you may not be able to use some portions of our Service.
Examples of Cookies we use:
https://cresh.org.uk/ uses the collected data for various purposes:
Your information, including Personal Data, may be transferred to — and maintained on — computers located outside of your state, province, country or other governmental jurisdiction where the data protection laws may differ than those from your jurisdiction.
If you are located outside United Kingdom and choose to provide information to us, please note that we transfer the data, including Personal Data, to United Kingdom and process it there.
https://cresh.org.uk/ may disclose your Personal Data in the good faith belief that such action is necessary to:
The security of your data is important to us, but remember that no method of transmission over the Internet, or method of electronic storage is 100% secure. While we strive to use commercially acceptable means to protect your Personal Data, we cannot guarantee its absolute security.
We may employ third party companies and individuals to facilitate our Service ("Service Providers"), to provide the Service on our behalf, to perform Service-related services or to assist us in analyzing how our Service is used.
These third parties have access to your Personal Data only to perform these tasks on our behalf and are obligated not to disclose or use it for any other purpose.
We may use third-party Service Providers to monitor and analyze the use of our Service.
Google Analytics is a web analytics service offered by Google that tracks and reports website traffic. Google uses the data collected to track and monitor the use of our Service. This data is shared with other Google services. Google may use the collected data to contextualize and personalize the ads of its own advertising network.
For more information on the privacy practices of Google, please visit the Google Privacy & Terms web page: https://policies.google.com/privacy?hl=en
We have no control over and assume no responsibility for the content, privacy policies or practices of any third party sites or services.
Our Service does not address anyone under the age of 18 ("Children").
We do not knowingly collect personally identifiable information from anyone under the age of 18. If you are a parent or guardian and you are aware that your Children has provided us with Personal Data, please contact us. If we become aware that we have collected Personal Data from children without verification of parental consent, we take steps to remove that information from our servers.