1 / 18

A National-Scale Infrastructure Database and Modelling Environment for the UK

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

niel
Download Presentation

A National-Scale Infrastructure Database and Modelling Environment for the UK

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. A National-Scale Infrastructure Databaseand 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

  2. Overview • Introduction • National Infrastructure System Model (NISMOD-DB) • Contents • Technology • Visualisation • NISMOD-DB for Networks • Overview • Structure • Visualisation • Future work… • Summary • Contacts and Links

  3. 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

  4. 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

  5. NISMOD-DB - Overview

  6. NISMOD – DB – Technology Prototype web client(s) Desktop D3js.org {“key”: “JSON”} Middleware / Analysis packages NetworkX Network views (SQL/plpgSQL) SQL / plpgSQL Admin Database(s) Network Schema

  7. NISMOD-DB - Visualisation • Requirements: • Reporting • Investigation • Interactivity • Standard approaches: maps, plots, charts, graphs, diagrams…

  8. NISMOD-DB – Visualisation… Control Panel Map Panel Chart Panel

  9. NISMOD-DB – Visualisation… Control Panel Chart / Map Panel Chart Panel

  10. NISMOD-DB – Visualisation… Control Panel Chart / Map Panel Chart Panel

  11. NISMOD-DB for Networks • Architecture to handle various regional and national scale spatial networks • Storage • Analysis • Visualisation

  12. NISMOD-DB for Networks… Import / export graph: GEXF, PAJEK, YAML, GRAPHML, CSV, JSON Calculate metrics: wrap NetworkX algorithms, can add custom calculations Publish networks: Interface with Geoserver WMS via gsconfig (in dev) Network Database Schema nx_pgnet nx_pg NetworkX

  13. 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

  14. Example: Network analysis, London, UK Substations Tube stations Dependency links GUI for network analysis

  15. 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

  16. 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

  17. 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/

  18. Thank you. David.Alderson@ncl.ac.uk Stuart.Barr@ncl.ac.uk C.A.Robson1@ncl.ac.uk Alexander.Otto@ouce.ox.ac.uk Jim.Hall@eci.ox.ac.uk Scott.Thacker@ouce.ox.ac.uk Raghav.Pant@ouce.ox.ac.uk

More Related