Login
Registrati
Reimposta password
Pubblica & Distribuisci
Soluzioni Editoriali
Soluzioni di Distribuzione
Temi
Architettura e design
Arti
Business e Economia
Chimica
Chimica industriale
Farmacia
Filosofia
Fisica
Geoscienze
Ingegneria
Interesse generale
Legge
Letteratura
Linguistica e semiotica
Matematica
Medicina
Musica
Scienze bibliotecarie e dell'informazione, studi library
Scienze dei materiali
Scienze della vita
Scienze informatiche
Scienze sociali
Sport e tempo libero
Storia
Studi classici e del Vicino Oriente antico
Studi culturali
Studi ebraici
Teologia e religione
Pubblicazioni
Riviste
Libri
Atti
Editori
Blog
Contatti
Cerca
EUR
USD
GBP
Italiano
English
Deutsch
Polski
Español
Français
Italiano
Carrello
Home
Riviste
Quaestiones Geographicae
Volume 37 (2018): Numero 3 (September 2018)
Accesso libero
Application of the Spatial Database for Shoreline Change Analysis and Visualisation: Example from the Western Polish Coast, Southern Baltic Sea
Robert Kostecki
Robert Kostecki
| 06 set 2018
Quaestiones Geographicae
Volume 37 (2018): Numero 3 (September 2018)
INFORMAZIONI SU QUESTO ARTICOLO
Articolo precedente
Articolo Successivo
Sommario
Articolo
Immagini e tabelle
Bibliografia
Autori
Articoli in questo Numero
Anteprima
PDF
Cita
CONDIVIDI
Pubblicato online:
06 set 2018
Pagine:
25 - 34
Ricevuto:
25 set 2017
DOI:
https://doi.org/10.2478/quageo-2018-0023
Parole chiave
shoreline change analysis
,
spatial database
,
open source GIS software
,
PostGIS
,
PostgreSQL
© 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.
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.