Alcohol and Tobacco Environments in Scotland

Description This application allows you to map the number of alcohol and tobacco outlets and related harm for small neighbourhoods across Scotland. Further information is available from the 'About' and 'How to Use' tabs on the right hand side.



Background

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 niamh.shortt@ed.ac.uk or Dr Mark Cherrie at mark.cherrie@ed.ac.uk.

Area boundaries

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.

Other boundaries

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 Data

Alcohol 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. 

alcbuffermap

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

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.

Further information

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.



Getting started

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 data

The 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:·
  • Click on the ‘Register to Download’ tab and enter your contact information
  • Click on the ‘Submit’ icon
  • Click on the 'Download' tab and the data will visible
  • Use the search box in the top right hand corner to filter the data further, for example all the datazones containing 'Culter'
  • Scroll to the bottom of the table and the click on the 'Download Filtered Data' icon
A spreadsheet will download containing the data. Descriptions of the data columns are below:
  • DZ_2011_code = Datazone 2011 code
  • DZ_2011_name = Datazone 2011 name
  • IZ_2011_code = Intermediate Zone 2011 code
  • IZ_2011_name = Intermediate Zone 2011 name
  • LA_code = Local Authority code
  • LA_name = Local Authority name
  • X------ = These columns contain the outlet availability data and are structured as follows: "X", Typical distance to outlet, data type and then either count or density
  • TobMortSMR_2011_2015 = Tobacco related deaths, see 'About' tab
  • AlcMortSMR_2011_2015 = Alcohol related deaths, see 'About' tab
  • UR6_2013_2014 = Scottish Government's Urban/rural 6 fold classification
  • SIMD_2016_AlcHosp = Scottish Government's SIMD 2016 Hospital stays related to alcohol misuse indicator, see 'About' tab
  • SIMD_2016_income = Scottish Government's SIMD 2016 income indicator (quintiles)
  • SIMD_2016_crime = Scottish Government's SIMD 2016 crime indicator, see 'About' tab
The spreadsheet is in comma-seperated values format (.csv) and can also be opened in several programs such as Microsoft Excel and OpenOffice.org’s free Calc program (go to http://www.openoffice.org/ to download).

Important notes:
  1. Contact information is used by us confidentially to find out how the data are being used
  2. If the 'Download Filtered Data' icon is greyed out then it might indicate that you have not registered to download
  3. If you have selected an option in the 'local authorities' box the data will be filtered to this local authority
  4. If the whole of Scotland option is selected this will result in slow loading times (up to 30 seconds)
  5. If the website doesn’t look or function as described below it is possible that the web browser you are using (e.g., Internet Explorer) is out of date. Try using a newer browser – such as the free Google Chrome browser

For more information please don’t hesitate to contact us:
Dr Niamh Shortt niamh.shortt@ed.ac.uk
Dr Mark Cherrie mark.cherrie@ed.ac.uk
The data presented here are based on your choices to the left, once you have registered, click download below the table to get a .csv file which can be opened in Excel. If you want a specific datazone, perhaps ones that was of interest in the map tab, copy and paste the name into the search box in the top right hand corner to filter the data to this single datazone.

            
              
              Download Filtered Data
            
          

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").

This page informs you of our policies regarding the collection, use, and disclosure of personal data when you use our Service and the choices you have associated with that data. Our Privacy Policy for https://cresh.org.uk/ is managed through Free Privacy Policy Website.

We use your data to provide and improve the Service. By using the Service, you agree to the collection and use of information in accordance with this policy. Unless otherwise defined in this Privacy Policy, terms used in this Privacy Policy have the same meanings as in our Terms and Conditions, accessible from https://creshmap.com

Information Collection And Use

We collect several different types of information for various purposes to provide and improve our Service to you.

Types of Data Collected

Personal Data

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:

  • Email address
  • First name and last name
  • Cookies and Usage Data

Usage Data

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.

Tracking & Cookies Data

We use cookies and similar tracking technologies to track the activity on our Service and hold certain information.

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:

  • Session Cookies. We use Session Cookies to operate our Service.
  • Preference Cookies. We use Preference Cookies to remember your preferences and various settings.
  • Security Cookies. We use Security Cookies for security purposes.

Use of Data

https://cresh.org.uk/ uses the collected data for various purposes:

  • To provide and maintain the Service
  • To notify you about changes to our Service
  • To allow you to participate in interactive features of our Service when you choose to do so
  • To provide customer care and support
  • To provide analysis or valuable information so that we can improve the Service
  • To monitor the usage of the Service
  • To detect, prevent and address technical issues

Transfer Of Data

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.

Your consent to this Privacy Policy followed by your submission of such information represents your agreement to that transfer.

https://cresh.org.uk/ will take all steps reasonably necessary to ensure that your data is treated securely and in accordance with this Privacy Policy and no transfer of your Personal Data will take place to an organization or a country unless there are adequate controls in place including the security of your data and other personal information.

Disclosure Of Data

Legal Requirements

https://cresh.org.uk/ may disclose your Personal Data in the good faith belief that such action is necessary to:

  • To comply with a legal obligation
  • To protect and defend the rights or property of https://cresh.org.uk/
  • To prevent or investigate possible wrongdoing in connection with the Service
  • To protect the personal safety of users of the Service or the public
  • To protect against legal liability

Security Of Data

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.

Service Providers

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.

Analytics

We may use third-party Service Providers to monitor and analyze the use of our Service.

  • Google Analytics

    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.

    You can opt-out of having made your activity on the Service available to Google Analytics by installing the Google Analytics opt-out browser add-on. The add-on prevents the Google Analytics JavaScript (ga.js, analytics.js, and dc.js) from sharing information with Google Analytics about visits activity.

    For more information on the privacy practices of Google, please visit the Google Privacy & Terms web page: https://policies.google.com/privacy?hl=en

Links To Other Sites

Our Service may contain links to other sites that are not operated by us. If you click on a third party link, you will be directed to that third party's site. We strongly advise you to review the Privacy Policy of every site you visit.

We have no control over and assume no responsibility for the content, privacy policies or practices of any third party sites or services.

Children's Privacy

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.

Changes To This Privacy Policy

We may update our Privacy Policy from time to time. We will notify you of any changes by posting the new Privacy Policy on this page.

We will let you know via email and/or a prominent notice on our Service, prior to the change becoming effective and update the "effective date" at the top of this Privacy Policy.

You are advised to review this Privacy Policy periodically for any changes. Changes to this Privacy Policy are effective when they are posted on this page.

Contact Us

If you have any questions about this Privacy Policy, please contact us:

  • By visiting our website: https://cresh.org.uk/