This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 3.0 License.
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.