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

<p>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.<br> 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.<br> 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.</p

Identifying culturally significant areas for marine spatial planning

Despite the growing recognition of their importance, immaterial cultural values associated with the sea still tend to be neglected in marine spatial planning (MSP). This socio-cultural evidence gap is due to inherent difficulties in defining and eliciting cultural values, but also to difficulties in linking cultural values to specific places, thus enabling an area-based approach to management. This paper addresses three aspects that are important for including marine cultural values in MSP: Defining cultural values, identifying places of cultural importance, and establishing the relative significance of places of cultural importance. We argue that common classification schemes such as cultural ecosystem services can be a helpful starting point for identifying cultural values, but only go so far in capturing communities' cultural connections with the sea. A method is proposed for structuring a community-based narrative on cultural values and “spatialising” them for MSP purposes, using five criteria that can lead to the definition of “culturally significant areas”. A baseline of culturally significant areas is suggested as an aid to planners to pinpoint places where cultural connections to the sea are particularly strong. Throughout, we emphasise the need for participative processes

Impact of regulatory perturbations to disease spread through cattle movements in Great Britain

During the past decade the British livestock industry has suffered from several major pathogen outbreaks, and a variety of regulatory and disease control measures have been applied to the movement of livestock with the express aim of mitigating the spread of infection. The Rapid Analysis and Detection of Animal-related Risks (RADAR) project, which has been collecting data on the movement of cattle since 1998, provides a relatively comprehensive record of how these policies have influenced the movement of cattle between animal holdings, markets, and slaughterhouses in Britain. Many previous studies have focused on the properties of the network that can be derived from these movements – treating farms as nodes and movements as directed (and potentially weighted) edges in the network. However, of far greater importance is how these policy changes have influenced the potential spread of infectious diseases. Here we use a stochastic fully individual-based model of cattle in Britain to assess how the epidemic potential has varied from 2000 to 2009 as the pattern of movements has changed in response to legislation and market forces. Our simulations show that the majority of policy changes lead to significant decreases in the epidemic potential (measured in multiple ways), but that this potential then increases through time as cattle farmers modify their behaviour in response. Our results suggest that the cattle industry is likely to experience boom-bust dynamics, with the actions that farmers take during epidemic-free periods to maximise their profitability likely to increase the potential for large-scale epidemics to occur