Skip to main content
Have a personal or library account? Click to login
Application of the Spatial Database for Shoreline Change Analysis and Visualisation: Example from the Western Polish Coast, Southern Baltic Sea Cover

Application of the Spatial Database for Shoreline Change Analysis and Visualisation: Example from the Western Polish Coast, Southern Baltic Sea

Quaestiones Geographicae
Volume 37 (2018): Issue 3 (September 2018)
By: Robert Kostecki  
Open Access
|Sep 2018
Figures & tables

Figures & Tables

Fig. 1

Location map of tested shoreline.

Fig. 2

Workflow diagram illustrating the steps necessary to create the transects table with calculations of coastline changes.

Fig. 3

Example of SQL execution statements necessary to create the geometry of transects and perform transect calculations.

Fig. 4

Preview of example PostgreSQL database structure in window of the client application pgAdmin III with all necessary tables and functions to made calculations.

Fig. 5

Example for erosional part of shoreline with resultant transect lines at 10-m spacing intersected and digitalised historic shorelines.

Fig. 6

PL/SQL source code for function necessary to creating geometry of the transects along the analysed shoreline (detailed description in the text).

Fig. 7

PL/SQL source code for function labelling transects according to kilometre names.

Fig. 8

PL/SQL source code for function calculating distances between analysed shorelines.

Fig. 9

R source code statements executed in the R statistical environment necessary to create diagram of the rate of shoreline change.

Fig. 10

Example of diagram of shoreline change during analysed period (grey lines: error margin ±15 m) and rate of annual shoreline change (grey lines: error margin ±0.65 m) in the study area created by the R statements on the basis of results stored in the table transects_table.

Fig. 11

Example of the map presenting results of classified shoreline change measurements made in the QGIS environment connected with data from PostGIS database.
DOI: https://doi.org/10.2478/quageo-2018-0023 | Journal eISSN: 2081-6383 | Journal ISSN: 2082-2103
Journal RSS Feed
Language: English
Page range: 25 - 34
Submitted on: Sep 25, 2017
Published on: Sep 6, 2018
Published by: Adam Mickiewicz University
In partnership with: Paradigm Publishing Services
Publication frequency: 4 issues per year
Keywords:
shoreline change analysis,
spatial database,
open source GIS software,
PostGIS,
PostgreSQL
Related subjects:
Geosciences,
Geography

© 2018 Robert Kostecki, published by Adam Mickiewicz University
This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 3.0 License.

Volume 37 (2018): Issue 3 (September 2018)
Previous article
Next article