Collaborative Web-GIS Design: A Case Study for Road Risk Analysis and Monitoring

This article presents a methodology for designing a WebGIS framework intended for automatically analyzing spatial data and updating statistics of interest with new information inserted daily by multiple users via a Web portal. A practical example is used on vehicle accident data for assessing risk in specific road segments. Two main blocks integrated together will be described: the collaborative block and the data-analysis block. The former gives end-users computer-aided tools to view, insert, modify and manage data related to accidents and traffic monitoring sensors, whereas the latter is developed to automatically analyze the accident data coming from user's collaboration. Because different agencies can survey accident sites, a collaborative environment is necessary – and a Web-based solution is ideal – for permitting multi-user access and data insertion. A centralized approach to process the data in real time is described in all its components. Server-side Structured Query Language functions optimize performance by using dedicated libraries for spatial processing and re-structuring the attributes associated with elements which are consequently re-classified for correct color-scaling. The end-product is a system that provides a seamless integration of front-end tools for user collaboration and back-end tools to update accident risk statistics in real time and provide them to stakeholders.

[1]  Walid G. Aref,et al.  Space-Partitioning Trees in PostgreSQL: Realization and Performance , 2006, 22nd International Conference on Data Engineering (ICDE'06).

[2]  Trias Aditya,et al.  Usability Issues in Applying Participatory Mapping for Neighborhood Infrastructure Planning , 2010 .

[3]  Rashaad E. T. Jones,et al.  Supporting Knowledge Management In Emergency Crisis Management Domains: Envisioned Designs for Collaborative Work , 2006, Emergent Information Technologies and Enabling Policies for Counter-Terrorism.

[4]  Jacek Malczewski,et al.  GIS‐based multicriteria decision analysis: a survey of the literature , 2006, Int. J. Geogr. Inf. Sci..

[5]  Regina O. Obe,et al.  PostGIS in Action , 2011 .

[6]  S. Farchi,et al.  Road traffic injuries in one local health unit in the Lazio region: results of a surveillance system integrating police and health data , 2009, International journal of health geographics.

[7]  Angi Voß,et al.  Evolution of a participatory GIS , 2004, Comput. Environ. Urban Syst..

[8]  Ricardo A. Baeza-Yates,et al.  Searching in metric spaces , 2001, CSUR.

[9]  Cesare Furlanello,et al.  [Epidemiology of traffic accidents in the province of Trento: first results of an integrated surveillance system (MITRIS)]. , 2005, Epidemiologia e prevenzione.

[10]  Michael K. McCall,et al.  Seeking good governance in participatory-GIS: a review of processes and governance dimensions in applying GIS to participatory spatial planning , 2003 .

[11]  C. Dunn Participatory GIS — a people's GIS? , 2007 .

[12]  Sarah Elwood,et al.  Negotiating Knowledge Production: The Everyday Inclusions, Exclusions, and Contradictions of Participatory GIS Research* , 2006 .

[13]  Max J. Egenhofer,et al.  Spatial SQL: A Query and Presentation Language , 1994, IEEE Trans. Knowl. Data Eng..

[14]  Shivanand Balram,et al.  Collaborative geographic information systems , 2006 .

[15]  Richard E. Allsop Assessing Risk and Setting Targets in Transport Safety Programmes , 2003 .

[16]  Agnès Voisard,et al.  An Introduction to Spatial Databases , 2002 .

[17]  Jeffrey F. Naughton,et al.  Generalized Search Trees for Database Systems , 1995, VLDB.

[18]  Alan M. MacEachren,et al.  Collaborative geographic visualization: enabling shared understanding of environmental processes , 2000, IEEE Symposium on Information Visualization 2000. INFOVIS 2000. Proceedings.

[19]  Christian Böhm,et al.  Searching in high-dimensional spaces: Index structures for improving the performance of multimedia databases , 2001, CSUR.

[20]  Sarah Elwood,et al.  Critical Issues in Participatory GIS: Deconstructions, Reconstructions, and New Research Directions , 2006, Trans. GIS.