Presentation Open Access

Storage, Analysis and Visualisation of Spatial Data: A Workflow to Support Marine Spatial Planning in Rockall

Stirling, David; Neat, Francis; Gubbins, Matt

ATLAS work package 6 presentation at ATLAS 3rd General Assembly

Effective Marine Spatial Planning (MSP) relies heavily on the collation of spatial data from a wide range of sources. Here we present a suite of open-source, synergistic software that can be used in an efficient workflow to store, analyse and visualise spatial data.
For data storage we use PostgreSQL and PostGIS. PostgreSQL is a powerful object relational database system that has cross-platform support. It is extensible, with the PostGIS extension allowing it to store spatial data. For data visualisation and analysis we use R and QGIS. The R statistical programming language can be extended to be compatible with PostgreSQL / PostGIS. QGIS, a desktop GIS application, is similarly used in visualisation due to its intuitive interface and native support for PostgreSQL / PostGIS.
Using the Rockall case study as an example we demonstrate the use of these software and their interactions in a workflow that can be used to support MSP efforts.

44
24
views
downloads
All versions This version
Views 4444
Downloads 2424
Data volume 1.0 GB1.0 GB
Unique views 4141
Unique downloads 2424

Share

Cite as