NEWS

An open source relational database schema and system for the analysis of large scale spatially interdependent infrastructure networks

Sep 5, 2012

Abstract

There is an increasing interest both academically, commercially and at a governmental level to spatially understand and model the performance of infrastructure networks at local, regional and national scales. Particular interest lies in understanding the vulnerability and probabilistic risk faced by large scale physical infrastructure networks to spatially localised extreme events such as natural hazards. In order to perform such analysis and modelling in a holistic manner one requires the ability to represent and model the dependencies and interdependencies that exist between different infrastructure networks, which in turn requires the ability to derive a ‘network-of-networks’ spatial representation and expression of physical infrastructure. Traditionally, spatial networks and their subsequent analysis have been performed within a GIS environment. However, the ability of GIS packages to explicitly represent large interdependent networks comprising of potentially many hundreds of thousands of nodes and edges has been limited. Moreover, the analytical network functionality provided by GIS packages often falls some way short of the complex analysis required to understand how failures propagate through individual networks, between dependent networks and feedback when interdependent relationships exist.

In order to address these issues we have developed a fully relationally compliant open source spatial database schema and a python coupled-interface to the NetworkX graph analysis package for the representation, encoding and analysis of networks and their dependencies/interdependencies. In particular we have used collaborative rapid-prototyping to develop our database schema for network representation and dependence/interdependence encoding using PostgreSQL and the spatial extension PostGIS. The schema is exposed through plpgsql functions, which are provided to the user wrapped in python class methods, forming the software API.

An open source relational database schema and system for the analysis of large scale spatially interdependent infrastructure networks. In: 4th Open Source GIS Conference (OSGIS), 2012. 2012, University of Nottingham: Nottingham Geospatial Institute.

Authors

Barr, S.L., Holderness, T., Alderson,D., Robson, C. and Ford, A.

LATEST NEWS

Coalition for Disaster Resilient Infrastructure (CDRI) Fellowship Programme

Coalition for Disaster Resilient Infrastructure (CDRI) Fellowship Programme

The Coalition for Disaster Resilient Infrastructure (CDRI) is promoting the programme to further the coverage of fellowships within all CDRI member countries and ensure high-quality research ... read more

Getting animated about the business impacts of extreme weather

Getting animated about the business impacts of extreme weather

Weather-related disasters are creating huge economic strain across the globe, with many businesses requiring climate risk calculations to help manage financial growth and prevent losses. ... read more

Lena Fuldauer awarded 1st prize in the Allianz Climate Risk Research Award

Lena Fuldauer awarded 1st prize in the Allianz Climate Risk Research Award

Congratulations to Lena Fuldauer (ITRC Researcher and PhD student at the Environmental Change Institute, Oxford University) who has won 1st prize in the Allianz Climate Risk Research Awards. The ... read more

RESEARCH THEMES

ENERGY
TRANSPORT
WATER
DIGITAL COMMUNICATIONS
DEMOGRAPHICS
URBAN
DEVELOPMENT
ECONOMICS
INFRASTRUCTURE
GOVERNANCE
NISMOD
RISK AND
RESILIENCE
RESEARCH SOFTWARE ENGINEERING
DATABASES