Uneingeschränkter Zugang

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

Robert Kostecki

Robert Kostecki

Institute of Geoecology and Geoinformation, Adam Mickiewicz UniversityPoznań, Poland
Suche nach diesem Autor auf
Sciendo|Google Scholar
Kostecki, Robert
  
06. Sept. 2018
Application of the Spatial Database for Shoreline Change Analysis and Visualisation: Example from the Western Polish Coast, Southern Baltic Sea's Cover Image
Über diesen Artikel
Vorheriger Artikel
Nächster Artikel
Zitieren
COVER HERUNTERLADEN
Online veröffentlicht: 06. Sept. 2018
Seitenbereich: 25 - 34
Eingereicht: 25. Sept. 2017
DOI: https://doi.org/10.2478/quageo-2018-0023
Schlüsselwörter
© 2018 Robert Kostecki, published by Sciendo
This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 3.0 License.

Fig. 1

Location map of tested shoreline.
Location map of tested shoreline.

Fig. 2

Workflow diagram illustrating the steps necessary to create the transects table with calculations of coastline changes.
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.
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.
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.
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).
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.
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.
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.
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.
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.
Example of the map presenting results of classified shoreline change measurements made in the QGIS environment connected with data from PostGIS database.
Sprache:
Englisch
Zeitrahmen der Veröffentlichung:
4 Hefte pro Jahr
Fachgebiete der Zeitschrift:
Geowissenschaften, Geografie
Zeitschrift RSS Feed