Transcript An open source relational database schema and system for

A National-Scale Infrastructure Database
and Modelling Environment for the UK
Mr David Alderson
Dr Stuart Barr, Mr Craig Robson
Dr Alexander Otto, Prof Jim Hall, Mr Scott Thacker, Dr Raghav Pant
International Symposium for Next Generation Infrastructure
SMART Infrastructure Facility, University of Wollongong
3rd October 2013
Overview
• Introduction
• National Infrastructure System Model (NISMOD-DB)
• Contents
• Technology
• Visualisation
• NISMOD-DB for Networks
• Overview
• Structure
• Visualisation
• Future work…
• Summary
• Contacts and Links
This research was funded by EPSRC Programme Grant EP/I01344X/1
Introduction
• Infrastructure planning, investment, delivery,
maintenance, upgrading and improving all require DATA!
–
–
–
–
–
Supply and demand (NISMOD-LP)
Asset inventory
Performance
Failures and recovery
Connectivity
• Integrated data management environment required
– Storage, maintenance and updates
– Modelling and analysis
– Visualisation and dissemination
www.itrc.org.uk
NISMOD-DB - Contents
• Database of spatial and aspatial infrastructure-related data for the
UK
– Traditional physical infrastructure assets
– Hazards
– Infrastructure capacity and demand modelling inputs and outputs
(NISMOD-LP)
– Network modelling and storage
• Network-enabled database schema
• Physical infrastructure network construction
• Prototype visualisation tools
– Visualisation of infrastructure networks
– Infrastructure data dashboard for demographic and economic projections
to 2100
www.itrc.org.uk
NISMOD-DB - Overview
www.itrc.org.uk
NISMOD – DB – Technology
Prototype web client(s)
D3js.org
Desktop
{“key”: “JSON”}
Middleware / Analysis packages
NetworkX
Network views
(SQL/plpgSQL)
SQL / plpgSQL
Admin
Database(s)
Network Schema
www.itrc.org.uk
NISMOD-DB - Visualisation
• Requirements:
– Reporting
– Investigation
– Interactivity
• Standard approaches: maps, plots, charts, graphs, diagrams…
www.itrc.org.uk
NISMOD-DB – Visualisation…
Control Panel
Map Panel
Chart Panel
www.itrc.org.uk
NISMOD-DB – Visualisation…
Control Panel
Chart / Map Panel
Chart Panel
www.itrc.org.uk
NISMOD-DB – Visualisation…
Control Panel
Chart / Map Panel
Chart Panel
www.itrc.org.uk
NISMOD-DB for Networks
• Architecture to handle various regional and national scale
spatial networks
– Storage
– Analysis
– Visualisation
www.itrc.org.uk
NISMOD-DB for Networks…
Import / export graph: GEXF,
PAJEK, YAML, GRAPHML, CSV,
JSON
Network Database
Schema
nx_pg
Calculate metrics: wrap
NetworkX algorithms, can add
custom calculations
Publish networks: Interface
with Geoserver WMS via
gsconfig (in dev)
nx_pgnet
NetworkX
www.itrc.org.uk
NISMOD-DB for Networks…
UK Road
• OS Meridian (24071 nodes, 50292 edges)
• OS Strategi (18066 nodes, 28089 edges)
• UK Rail (2526 stations, 1415 junctions)
• UK National Grid-owned Electricity Transmission
• Generation Stations, Interconnectors, Substations (643
nodes)
• Underground cables, Overhead lines, Interconnectors (759
edges)
•UK National Grid-owned Gas Transmission
• Offtakes, Block Valves, Compressors, Storage Sites, LNG
Sites, Terminals, Pipelines plus more (625 nodes, 679 edges)
NISMOD-DB – Networks…
Topographical View
Topological View
Metric View
Example: Network analysis, London, UK
Substations
Tube stations
Dependency links
GUI for network analysis
www.itrc.org.uk
Future Work…
• Complex sets of outputs from infrastructure capacity and
demand modelling (NISMOD-LP)
•
•
•
Integration of inputs/outputs within NISMOD-DB
Web services for remote execution
Development of infrastructure data dashboards
• Extension of current dashboards per sector
• Single, integrated interface for all sectors
• Development of visualisations for investigating and
disseminating infrastructure performance
• Development of network visualisation
•
•
•
Use of network visualisation tools for NISMOD-LP
Further development of network visualisation dashboards
for failure simulation
Extension of network module for end-to-end network
construction, storage, analysis and dissemination
This research was funded by EPSRC Programme Grant EP/I01344X/1
Summary
• Data available on many aspects of infrastructure
• Management, provenance, analysis and
dissemination key to effective research
• Relational database, with spatial and network
extensions being developed as part of UK ITRC
to:
• Handle model outputs for future capacity and
demand under range of different scenarios
• Build, store and manage networks
• Disseminate data via prototype visualisation
tools
This research was funded by EPSRC Programme Grant EP/I01344X/1
Links
• Infrastructure Transitions Research Consortium
www.itrc.org.uk
http://gow.epsrc.ac.uk/NGBOViewGrant.aspx?GrantRef=EP/I01344X/1
• School of Civil Engineering and Geosciences,
Newcastle University
www.ceg.ncl.ac.uk
• Geospatial Engineering Group@ Newcastle
http://www.ncl.ac.uk/ceg/research/geomatics/geospatialengineering/
• Geospatial Engineering Group Blog @ Newcastle
http://blogs.ncl.ac.uk/geospatialengineering
• Centre for Earth System’s Engineering Research
(CESER) @ Newcastle
http://www.ncl.ac.uk/ceser/
This research was funded by EPSRC Programme Grant EP/I01344X/1
Thank you.
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
This research was funded by EPSRC Programme Grant EP/I01344X/1