Connexion
S'inscrire
Réinitialiser le mot de passe
Publier & Distribuer
Solutions d'édition
Solutions de distribution
Thèmes
Architecture et design
Arts
Business et économie
Chimie
Chimie industrielle
Droit
Géosciences
Histoire
Informatique
Ingénierie
Intérêt général
Linguistique et sémiotique
Littérature
Mathématiques
Musique
Médecine
Pharmacie
Philosophie
Physique
Sciences bibliothécaires et de l'information, études du livre
Sciences des matériaux
Sciences du vivant
Sciences sociales
Sport et loisirs
Théologie et religion
Études classiques et du Proche-Orient ancient
Études culturelles
Études juives
Publications
Journaux
Livres
Comptes-rendus
Éditeurs
Blog
Contact
Chercher
EUR
USD
GBP
Français
English
Deutsch
Polski
Español
Français
Italiano
Panier
Home
Journaux
Quaestiones Geographicae
Édition 37 (2018): Edition 3 (September 2018)
Accès libre
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 sept. 2018
Quaestiones Geographicae
Édition 37 (2018): Edition 3 (September 2018)
À propos de cet article
Article précédent
Article suivant
Résumé
Article
Figures et tableaux
Références
Auteurs
Articles dans cette édition
Aperçu
PDF
Citez
Partagez
Publié en ligne:
06 sept. 2018
Pages:
25 - 34
Reçu:
25 sept. 2017
DOI:
https://doi.org/10.2478/quageo-2018-0023
Mots clés
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.