An OLAP-GIS System for Numerical-Spatial Problem Solving in Community Health Assessment Analysis

Community health assessment (CHA) professionals who use information technology need a complete system that is capable of supporting numerical-spatial problem solving. On-Line Analytical Processing (OLAP) is a multidimensional data warehouse technique that is commonly used as a decision support system in standard industry. Coupling OLAP with Geospatial Information System (GIS) offers the potential for a very powerful system. For this work, OLAP and GIS were combined to develop the Spatial OLAP Visualization and Analysis Tool (SOVAT) for numerical-spatial problem solving. In addition to the development of this system, this dissertation describes three studies in relation to this work: a usability study, a CHA survey, and a summative evaluation.The purpose of the usability study was to identify human-computer interaction issues. Fifteen participants took part in the study. Three participants per round used the system to complete typical numerical-spatial tasks. Objective and subjective results were analyzed after each round and system modifications were implemented. The result of this study was a novel OLAP-GIS system streamlined for the purposes of numerical-spatial problem solving.The online CHA survey aimed to identify the information technology currently used for numerical-spatial problem solving. The survey was sent to CHA professionals and allowed for them to record the individual technologies they used during specific steps of a numerical-spatial routine. In total, 27 participants completed the survey. Results favored SPSS for numerical-related steps and GIS for spatial-related steps.Next, a summative within-subjects crossover design compared SOVAT to the combined use of SPSS and GIS (termed SPSS-GIS) for numerical-spatial problem solving. Twelve individuals from the health sciences at the University of Pittsburgh participated. Half were randomly selected to use SOVAT first, while the other half used SPSS-GIS first. In the second session, they used the alternate application. Objective and subjective results favored SOVAT over SPSS-GIS. Inferential statistics were analyzed using linear mixed model analysis. At the .01 level, SOVAT was statistically significant from SPSS-GIS for satisfaction and time (p < .002).The results demonstrate the potential for OLAP-GIS in CHA analysis. Future work will explore the impact of an OLAP-GIS system in other areas of public health

Linkages between animal and human health sentinel data

INTRODUCTION: In order to identify priorities for building integrated surveillance systems that effectively model and predict human risk of zoonotic diseases, there is a need for improved understanding of the practical options for linking surveillance data of animals and humans. We conducted an analysis of the literature and characterized the linkage between animal and human health data. We discuss the findings in relation to zoonotic surveillance and the linkage of human and animal data. METHODS: The Canary Database, an online bibliographic database of animal-sentinel studies was searched and articles were classified according to four linkage categories. RESULTS: 465 studies were identified and assigned to linkage categories involving: descriptive, analytic, molecular, or no human outcomes of human and animal health. Descriptive linkage was the most common, whereby both animal and human health outcomes were presented, but without quantitative linkage between the two. Rarely, analytic linkage was utilized in which animal data was used to quantitatively predict human risk. The other two categories included molecular linkage, and no human outcomes, which present health outcomes in animals but not humans. DISCUSSION: We found limited use of animal data to quantitatively predict human risk and listed the methods from the literature that performed analytic linkage. The lack of analytic linkage in the literature might not be solely related to technological barriers including access to electronic database, statistical software packages, and Geographical Information System (GIS). Rather, the problem might be from a lack of understanding by researchers of the importance of animal data as a 'sentinel' for human health. Researchers performing zoonotic surveillance should be aware of the value of animal-sentinel approaches for predicting human risk and consider analytic methods for linking animal and human data. Qualitative work needs to be done in order to examine researchers' decisions in linkage strategies between animal and human data

pyJacqQ: Python Implementation of Jacquez's Q-Statistics for Space-Time Clustering of Disease Exposure in Case-Control Studies

Jacquez's Q is a set of statistics for detecting the presence and location of space-time clusters of disease exposure. Until now, the only implementation was available in the proprietary SpaceStat software which is not suitable for a pipeline Linux environment. We have developed an open source implementation of Jacquez's Q statistics in Python using an object-oriented approach. The most recent source code for the implementation is available at https://github.com/sjirjies/pyJacqQ under the GPL-3. It has a command line interface and a Python application programming interface

Exploring the role of GIS during community health assessment problem solving: experiences of public health professionals

BACKGROUND: A Community health assessment (CHA) involves the use of Geographic Information Systems (GIS) in conjunction with other software to analyze health and population data and perform numerical-spatial problem solving. There has been little research on identifying how public health professionals integrate this software during typical problem solving scenarios. A better understanding of this is needed to answer the "What" and the "How". The "What" identifies the specific software being used and the "How" explains the way they are integrated together during problem solving steps. This level of understanding will highlight the role of GIS utilization during problem solving and suggest to developers how GIS can be enhanced to better support data analysis during community health assessment. RESULTS: An online survey was developed to identify the information technology used during CHA analysis. The tasks were broken down into steps and for our analysis these steps were categorized by action: Data Management/Access, Data Navigation, Geographic Comparison, Detection of Spatial Boundaries, Spatial Modelling, and Ranking Analysis. 27 CHA professionals completed the survey, with the majority of participants (14) being from health departments. Statistical software (e.g. SPSS) was the most popular software for all but one of the types of steps. For this step (detection of spatial boundaries), GIS was identified as the most popular technology. CONCLUSION: Most CHA professionals indicated they use statistical software in conjunction with GIS. The statistical software appears to drive the analysis, while GIS is used primarily for simple spatial display (and not complex spatial analysis). This purpose of this survey was to thoroughly examine into the process of problem solving during community health assessment data analysis and to gauge how GIS is integrated with other software for this purpose. These findings suggest that GIS is used more for spatial display while other software such as statistical packages (the "What") are used to drive data management, data navigation, and data calculation (the "How"). Focusing at the level of how public health problems are solved, can shed light on how GIS technology can be enhanced to encompass a stronger role during community health assessment problem solving

Web GIS in practice VI: a demo playlist of geo-mashups for public health neogeographers

'Mashup' was originally used to describe the mixing together of musical tracks to create a new piece of music. The term now refers to Web sites or services that weave data from different sources into a new data source or service. Using a musical metaphor that builds on the origin of the word 'mashup', this paper presents a demonstration "playlist" of four geo-mashup vignettes that make use of a range of Web 2.0, Semantic Web, and 3-D Internet methods, with outputs/end-user interfaces spanning the flat Web (two-dimensional – 2-D maps), a three-dimensional – 3-D mirror world (Google Earth) and a 3-D virtual world (Second Life ®). The four geo-mashup "songs" in this "playlist" are: 'Web 2.0 and GIS (Geographic Information Systems) for infectious disease surveillance', 'Web 2.0 and GIS for molecular epidemiology', 'Semantic Web for GIS mashup', and 'From Yahoo! Pipes to 3-D, avatar-inhabited geo-mashups'. It is hoped that this showcase of examples and ideas, and the pointers we are providing to the many online tools that are freely available today for creating, sharing and reusing geo-mashups with minimal or no coding, will ultimately spark the imagination of many public health practitioners and stimulate them to start exploring the use of these methods and tools in their day-to-day practice. The paper also discusses how today's Web is rapidly evolving into a much more intensely immersive, mixed-reality and ubiquitous socio-experiential Metaverse that is heavily interconnected through various kinds of user-created mashups

Mathematical assessment of the impact of non-pharmaceutical interventions on curtailing the 2019 novel Coronavirus

A novel Coronavirus pandemic emerged in December of 2019, causing devastating public health impact across the world. In the absence of a safe and effective vaccine or antiviral, strategies for mitigating the burden of the pandemic are focused on non-pharmaceutical interventions, such as social-distancing, contact-tracing, quarantine, isolation and the use of face-masks in public. We develop a new mathematical model for assessing the population-level impact of these mitigation strategies. Simulations of the model, using data relevant to COVID-19 transmission in New York state and the entire US, show that the pandemic will peak in mid and late April, respectively. The worst-case scenario projections for cumulative mortality (based on the baseline levels of anti-COVID non-pharmaceutical interventions considered in the study) in New York State and the entire US decrease dramatically by 80% and 64%, respectively, if the strict social-distancing measures implemented are maintained until the end of May or June, 2020. This study shows that early termination of strict social-distancing could trigger a devastating second wave with burden similar to that projected before the onset of strict social-distance. The use of efficacious face-masks (efficacy greater than 70%) could lead to the elimination of the pandemic if at least 70% of the residents of New York state use such masks consistently (nationwide, a compliance of at least 80% will be required using such masks). The use of low efficacy masks, such as cloth masks (of efficacy less than 30%), could also lead to significant reduction of COVID-19 burden (albeit, they are not able to lead to elimination). Combining low efficacy masks with improved levels of other anti-COVID-19 intervention measures can lead to elimination of the pandemic. The mask coverage needed to eliminate COVID-19 decreases if mask-use is combined with strict social-distancing

Spatial and multidimensional visualization of Indonesia's village health statistics

Background: A community health assessment (CHA) is used to identify and address health issues in a given population. Effective CHA requires timely and comprehensive information from a wide variety of sources, such as: socio-economic data, disease surveillance, healthcare utilization, environmental data, and health resource allocation. Indonesia is a developing country with 235 million inhabitants over 13,000 islands. There are significant barriers to conducting CHA in developing countries like Indonesia, such as the high cost of computing resources and the lack of computing skills necessary to support such an assessment. At the University of Pittsburgh, we have developed the Spatial OLAP (On-Line Analytical Processing) Visualization and Analysis Tool (SOVAT) for performing CHA. SOVAT combines Geographic Information System (GIS) technology along with an advanced multidimensional data warehouse structure to facilitate analysis of large, disparate health, environmental, population, and spatial data. The objective of this paper is to demonstrate the potential of SOVAT for facilitating CHA among developing countries by using health, population, healthcare resources, and spatial data from Indonesia for use in two CHA cases studies. Results: Bureau of Statistics administered data sets from the Indonesian Census, and the Indonesian village statistics, were used in the case studies. The data consisted of: healthcare resources (number of healthcare professionals and facilities), population (census), morbidity and mortality, and spatial (GIS-formatted) information. The data was formatted, combined, and populated into SOVAT for CHA use. Case study 1 involves the distribution of healthcare professionals in Indonesia, while case study 2 involves malaria mortality. Screen shots are shown for both cases. The results for the CHA were retrieved in seconds and presented through the geospatial and numerical SOVAT interface. Conclusion: The case studies show the potential of spatial and multidimensional analysis using SOVAT for community health assessment in developing countries. Since SOVAT is based primarily on open-source components and can be deployed using small personal computers, it is cost-effective for developing countries. Also, combining the strength in analysis and the ease of use makes tools like SOVAT ideal for healthcare professionals without extensive computer skills. © 2008 Parmanto et al; licensee BioMed Central Ltd

Social Media Mining for Toxicovigilance: Automatic Monitoring of Prescription Medication Abuse from Twitter

Introduction Prescription medication overdose is the fastest growing drug-related problem in the USA. The growing nature of this problem necessitates the implementation of improved monitoring strategies for investigating the prevalence and patterns of abuse of specific medications. Objectives Our primary aims were to assess the possibility of utilizing social media as a resource for automatic monitoring of prescription medication abuse and to devise an automatic classification technique that can identify potentially abuse-indicating user posts. Methods We collected Twitter user posts (tweets) associated with three commonly abused medications (Adderall®, oxycodone, and quetiapine). We manually annotated 6400 tweets mentioning these three medications and a control medication (metformin) that is not the subject of abuse due to its mechanism of action. We performed quantitative and qualitative analyses of the annotated data to determine whether posts on Twitter contain signals of prescription medication abuse. Finally, we designed an automatic supervised classification technique to distinguish posts containing signals of medication abuse from those that do not and assessed the utility of Twitter in investigating patterns of abuse over time. Results Our analyses show that clear signals of medication abuse can be drawn from Twitter posts and the percentage of tweets containing abuse signals are significantly higher for the three case medications (Adderall®: 23 %, quetiapine: 5.0 %, oxycodone: 12 %) than the proportion for the control medication (metformin: 0.3 %). Our automatic classification approach achieves 82 % accuracy overall (medication abuse class recall: 0.51, precision: 0.41, F measure: 0.46). To illustrate the utility of automatic classification, we show how the classification data can be used to analyze abuse patterns over time. Conclusion Our study indicates that social media can be a crucial resource for obtaining abuse-related information for medications, and that automatic approaches involving supervised classification and natural language processing hold promises for essential future monitoring and intervention tasks