Cardiff University | Prifysgol Caerdydd ORCA
Online Research @ Cardiff 
WelshClear Cookie - decide language by browser settings

Using routinely collected administrative data in public health research: geocoding alcohol outlet data

Fry, Richard J., Rodgers, Sarah E., Morgan, Jennifer ORCID:, Orford, Scott ORCID: and Fone, David Lawrence ORCID: 2017. Using routinely collected administrative data in public health research: geocoding alcohol outlet data. Applied Spatial Analysis and Policy 10 (2) , pp. 301-315. 10.1007/s12061-016-9184-4

[thumbnail of ASAP paper 2016.pdf]
PDF - Accepted Post-Print Version
Available under License Creative Commons Attribution.

Download (519kB) | Preview


We describe our process of geocoding alcohol outlets to create a national longitudinal exposure dataset for Wales, United Kingdom from 2006 to 2011. We investigated variation in the availability of data items and the quality of alcohol outlet addresses held within unitary authorities. We used a standard geocoding method augmented with a manual matching procedure to achieve a fully spatially referenced dataset. We found higher quality addresses are held for outlets based in urban areas, resulting in the automatic geocoding of 68 % of urban outlets, compared to 48 % in rural areas. Missing postcodes and a lack of address structure contributed to a lower geocoding proportion. An urban rural bias was removed with the development of a manual matching procedure. Only one-half of the unitary authorities provided data on on/off sales and opening times, which are important availability factors. The resulting outlet dataset is suitable for contributing to the evidence-base of alcohol availability and alcohol-related harm. Local government should be encouraged to use standardised data fields, including addresses, to enable accurate geocoding of alcohol outlets and facilitate research that aims to prevent alcohol-related harm. Standardising data collection would enable efficient secondary data reuse using record linkage techniques, allowing the retrospective creation and evaluation of population-based natural experiments to provide evidence for policy and practice.

Item Type: Article
Date Type: Publication
Status: Published
Schools: Mathematics
Geography and Planning (GEOPL)
Additional Information: First online 18 March 2016
Publisher: Springer Verlag
ISSN: 1874-463X
Funders: NIHR
Date of First Compliant Deposit: 1 April 2016
Date of Acceptance: 4 March 2016
Last Modified: 12 Nov 2023 19:25

Citation Data

Cited 4 times in Scopus. View in Scopus. Powered By Scopus® Data

Actions (repository staff only)

Edit Item Edit Item


Downloads per month over past year

View more statistics