A methodology for combining multiple commercial data sources to improve measurement of the food and alcohol environment: applications of geographical information systems

Submitted: 9 December 2014
Accepted: 9 December 2014
Published: 1 November 2014
Abstract Views: 2275
PDF: 1093
Publisher's note
All claims expressed in this article are solely those of the authors and do not necessarily represent those of their affiliated organizations, or those of the publisher, the editors and the reviewers. Any product that may be evaluated in this article or claim that may be made by its manufacturer is not guaranteed or endorsed by the publisher.

Authors

Commercial data sources have been increasingly used to measure and locate community resources. We describe a methodology for combining and comparing the differences in commercial data of the food and alcohol environment. We used commercial data from two commercial databases (InfoUSA and Dun&Bradstreet) for 2003 and 2009 to obtain infor- mation on food and alcohol establishments and developed a matching process using computer algorithms and manual review by applying ArcGIS to geocode addresses, standard industrial classification and North American industry classification tax- onomy for type of establishment and establishment name. We constructed population and area-based density measures (e.g. grocery stores) and assessed differences across data sources and used ArcGIS to map the densities. The matching process resulted in 8,705 and 7,078 unique establishments for 2003 and 2009, respectively. There were more establishments cap- tured in the combined dataset than relying on one data source alone, and the additional establishments captured ranged from 1,255 to 2,752 in 2009. The correlations for the density measures between the two data sources was highest for alcohol out- lets (r = 0.75 and 0.79 for per capita and area, respectively) and lowest for grocery stores/supermarkets (r = 0.32 for both). This process for applying geographical information systems to combine multiple commercial data sources and develop meas- ures of the food and alcohol environment captured more establishments than relying on one data source alone. This replic- able methodology was found to be useful for understanding the food and alcohol environment when local or public data are limited.

Dimensions

Altmetric

PlumX Metrics

Downloads

Download data is not yet available.

Citations

How to Cite

Mendez, D. D., Duell, J., Reiser, S., Martin, D., Gradeck, R., & Fabio, A. (2014). A methodology for combining multiple commercial data sources to improve measurement of the food and alcohol environment: applications of geographical information systems. Geospatial Health, 9(1), 71–96. https://doi.org/10.4081/gh.2014.7