JISAR

Journal of Information Systems Applied Research

Volume13

V13 N2 Pages 33-53

Jul 2020


Developing a GIS Dashboard Tool to Inform Non-Profit Hospitals of Community Health Needs at the Neighborhood Level


Evan Copello
University of North Florida
Jacksonville, FL USA

Anna Mease
Mayo Clinic
Jacksonville, FL USA

Karthikeyan Umapathy
University of North Florida
Jacksonville, FL USA

Dan Richard
University of North Florida
Jacksonville, FL USA

Ann-Marie Knight
Mayo Clinic
Jacksonville, FL USA

Monica Albertie
Mayo Clinic
Jacksonville, FL USA

Hanadi Hamadi
University of North Florida
Jacksonville, FL USA

Aaron C. Spaulding
Mayo Clinic
Jacksonville, FL USA

Emma Apatu
McMaster University
Hamilton, ON Canada

Abstract: The objective of this paper is to describe the methods used to develop geographic information systems (GIS) dashboard tool and explain how it can assist nonprofit hospitals to identify priority neighborhoods. Multiple data sources were analyzed from the 500 Cities Project databases, and two online dashboards were created. The first dashboard is a hospital-specific composite dashboard, and the second is a comparison dashboard of health outcomes identified by both the hospital and the county’s community health needs assessment focused on neighborhood level disparities. Hospital-specific health outcomes were Stroke, Diabetes, and Coronary Heart Disease. County-specific health outcomes were Obesity, Dental, and Poor Mental Health. All of the six health outcomes were standardized, rescaled and weighted within the final composite score. Tableau was used for developing the dashboards and geographically mapping the analyzed data. The maps were developed specifically for a large hospital in Florida; however, this methodology can be utilized by other hospitals across the US. City-specific data is essential to ensure the accuracy of community health needs. The development of an interactive, comprehensive map using Tableau is a useful tool for visualizing target neighborhoods for community health outreach. The integration of community needs assessment findings into the development of composite scores allows hospitals in the US to use this tool to inform community health outreach strategy effectively.

Download this article: JISAR - V13 N2 Page 33.pdf


Recommended Citation: Copello, E., Mease, A., Umapathy, K., Richard, D., Knight, A., Albertie, M., Hamadi, H., Spaulding, A., Apatu, E., (2020). Developing a GIS Dashboard Tool to Inform Non-Profit Hospitals of Community Health Needs at the Neighborhood Level. Journal of Information Systems Applied Research13(2) pp 33-53. http://JISAR.org/2020-2/ ISSN : 1946 - 1836. A preliminary version appears in The Proceedings of CONISAR 2019