Towards a SOLAP-based public participation GIS

In this paper, we describe how spatial on-line analytical processing (SOLAP), a specific category of business intelligence technology especially adapted to geospatial data, can help to improve the technological side of public participation GIS applications. Based on two simulated cases of realistic scenarios of a public audience, this paper aims at demonstrating the relevance of this SOLAP technology to support and improve the interactive access and analysis of multi-scale, multi-epoch geospatial information (and indirectly public involvement) for an environmental management PPGIS application.

Easier surveillance of climate-related health vulnerabilities through a Web-based spatial OLAP application

BACKGROUND

Climate change has a significant impact on population health. Population vulnerabilities depend on several determinants of different types, including biological, psychological, environmental, social and economic ones. Surveillance of climate-related health vulnerabilities must take into account these different factors, their interdependence, as well as their inherent spatial and temporal aspects on several scales, for informed analyses. Currently used technology includes commercial off-the-shelf Geographic Information Systems (GIS) and Database Management Systems with spatial extensions. It has been widely recognized that such OLTP (On-Line Transaction Processing) systems were not designed to support complex, multi-temporal and multi-scale analysis as required above. On-Line Analytical Processing (OLAP) is central to the field known as BI (Business Intelligence), a key field for such decision-support systems. In the last few years, we have seen a few projects that combine OLAP and GIS to improve spatio-temporal analysis and geographic knowledge discovery. This has given rise to SOLAP (Spatial OLAP) and a new research area. This paper presents how SOLAP and climate-related health vulnerability data were investigated and combined to facilitate surveillance.

RESULTS

Based on recent spatial decision-support technologies, this paper presents a spatio-temporal web-based application that goes beyond GIS applications with regard to speed, ease of use, and interactive analysis capabilities. It supports the multi-scale exploration and analysis of integrated socio-economic, health and environmental geospatial data over several periods. This project was meant to validate the potential of recent technologies to contribute to a better understanding of the interactions between public health and climate change, and to facilitate future decision-making by public health agencies and municipalities in Canada and elsewhere. The project also aimed at integrating an initial collection of geo-referenced multi-scale indicators that were identified by Canadian specialists and end-users as relevant for the surveillance of the public health impacts of climate change. This system was developed in a multidisciplinary context involving researchers, policy makers and practitioners, using BI and web-mapping concepts (more particularly SOLAP technologies), while exploring new solutions for frequent automatic updating of data and for providing contextual warnings for users (to minimize the risk of data misinterpretation). According to the project participants, the final system succeeds in facilitating surveillance activities in a way not achievable with today's GIS. Regarding the experiments on frequent automatic updating and contextual user warnings, the results obtained indicate that these are meaningful and achievable goals but they still require research and development for their successful implementation in the context of surveillance and multiple organizations.

CONCLUSION

Surveillance of climate-related health vulnerabilities may be more efficiently supported using a combination of BI and GIS concepts, and more specifically, SOLAP technologies (in that it facilitates and accelerates multi-scale spatial and temporal analysis to a point where a user can maintain an uninterrupted train of thought by focussing on "what" she/he wants (not on "how" to get it) and always obtain instant answers, including to the most complex queries that take minutes or hours with OLTP systems (e.g., aggregated, temporal, comparative)). The developed system respects Newell's cognitive band of 10 seconds when performing knowledge discovery (exploring data, looking for hypotheses, validating models). The developed system provides new operators for easily and rapidly exploring multidimensional data at different levels of granularity, for different regions and epochs, and for visualizing the results in synchronized maps, tables and charts. It is naturally adapted to deal with multiscale indicators such as those used in the surveillance community, as confirmed by this project's end-users.

Interobserver agreement of a probabilistic approach to reporting breast fine-needle aspirations on ThinPrep®

We have previously demonstrated the accuracy and reproducibility of a probabilistic/categorical approach for reporting breast fine-needle aspiration (FNA). However, the interobserver agreement in the application of this approach has not been assessed. Twenty breast FNA cases (each on one ThinPrep slide) were pulled from the cytology files of Beth Israel Deaconess Medical Center. The cases included benign epithelial proliferative lesions (6), DCIS (4), and infiltrating carcinoma (10), as shown by subsequent histology. Six pathologists with 14-25 yr of experience in interpreting breast FNA and 0-8 yr of experience with ThinPrep preparations rendered diagnoses according to the probabilistic approach. The kappa statistic for the unremarkable/proliferative, atypical, suspicious, and positive categories were 0.64, 0.08, 0.43, and 0.75, respectively (P < 0.001 for all except for the atypical category [P = 0.09]). Spearman's rho correlating the individual pathologist's diagnosis and the histologic diagnosis ranged from 0.51 (P = 0.02) to 0.78 (P < 0.0001). This was not correlated with the pathologists' years of experience interpreting breast FNA (P = 1.0) or with their years using ThinPrep preparations for breast FNA (P = 0.96). In conclusion, the interobserver agreement was excellent for the positive category in the probabilistic approach, poor for the atypical category, and fair to good for the other categories. The specific level of experience interpreting breast FNA or using ThinPrep among experienced pathologists did not seem to influence their accuracy in reporting the cases in our study.

Integrating GIS components with knowledge discovery technology for environmental health decision support

This paper presents a new category of decision-support tools that builds on today's Geographic Information Systems (GIS) and On-Line Analytical Processing (OLAP) technologies to facilitate Geographic Knowledge Discovery (GKD). This new category, named Spatial OLAP (SOLAP), has been an R&D topic for about 5 years in a few university labs and is now being implemented by early adopters in different fields, including public health where it provides numerous advantages. In this paper, we present an example of a SOLAP application in the field of environmental health: the ICEM-SE project. After having presented this example, we describe the design of this system and explain how it provides fast and easy access to the detailed and aggregated data that are needed for GKD and decision-making in public health. The SOLAP concept is also described and a comparison is made with traditional GIS applications.

Modern information technologies in environmental health surveillance. An overview and analysis

In recent years we have witnessed the massive introduction of new information technologies that are drastically changing the face of our society. These technologies are being implemented en masse in developed countries, but also in some pockets of developing nations as well. They rely on the convergence of several technologies such as powerful and affordable computers, real-time electronic measurement and monitoring devices, massive production of digital information in different formats, and faster, wireless communication media. Such technologies are having significant impacts on every domain of application, including environmental health surveillance. The current paper provides an overview of those technologies that are having or will likely have the most significant impacts on environmental health. They include World Wide Web-based systems and applications, Database Management Systems and Universal Servers, and GIS and related technologies. The usefulness of these technologies as well as the desire to use them further in the future in the context of environmental health are discussed. Expanding the development and use of these technologies to obtain support for global environmental health will require major efforts in the areas of data access, training and support.

Aneurysmal cyst of soft tissue: report of a case with serial magnetic resonance imaging and biopsy

We report a case of an extraosseous aneurysmal cyst arising in the left retroclavicular soft tissue of a 29-year-old woman. A magnetic resonance imaging (MRI) scan showed a solid lesion within soft tissue, abutting the clavicle without bone involvement. An incisional biopsy was interpreted as showing osteoclast rich nodular fasciitis with prominent vascularity. A second MRI 5 months later showed intralesional cystic change with areas of increased signal on T2-weighted images, still without any bony defect. The lesion was excised. Histological examination revealed large vascular spaces lined focally by giant cells. The remainder of the lesion was composed of an admixture of spindle cells and osteoclast-like giant cells. The histological and ultrastructural appearance was that of an aneurysmal bone cyst; however, in view of the lack of any bony involvement, a diagnosis of aneurysmal cyst of soft tissue was made. Primary aneurysmal cysts of soft tissue are rare; this is the third well-documented case in the literature, and the first to describe both the MRI appearance and the histological evolution from a solid to multiloculated lesion.

Comparison of daily energy expenditure of greater snow geese between two habitats

We estimated the daily energy expenditure (DEE) of greater snow geese (Anser caerulescens atlanticus) on their St. Lawrence River estuary spring staging ground using time budget data. We compared DEE between two habitats: the traditionally occupied freshwater Scirpus-dominated marsh (SCI), and the recently invaded Spartina-dominated salt marsh (SPA). As greater snow geese staging at SCI have been found to accumulate larger fat reserves in the spring than those staging at SPA, we sought to explain these differences in diverging DEE patterns between the two habitats. We found that geese spent 42% more time (and energy) feeding in the marsh at SCI, but spent 61% less energy feeding in the field than at SPA. The energy spent in other activities was similar in both habitats. However, during the 6-week staging period, DEE was lower by only 4.7% at SPA (1613 kJ/day; 2.3 × basal metabolic rate (BMR) when compared with SCI (1689 kJ/day; 2.5 × BMR). This difference in DEE cannot account for the habitat-based differences in prebreeding fattening, and alternative hypotheses are examined.