Geoservers and geospatial data bases 1900-1-SBDP-SG

https://platforma.wgsr.uw.edu.pl/ml

The topics of the course cover theoretical and practical aspects of geoservers and spatial geodatabases. Theoretical part concerns basic concepts and terms, data models and main elements of modern database systems architecture, description of modern tools and database interfaces (including SQL language) used in the construction of geospatial databases. Practical part includes presentation of examples of elements and functions of database implementation in different systems and a description of functioning and available server tools and database clients, which are used by geographic information systems (GIS) and available on the Internet geoservers (geoportals). The course also includes examples of practical projects using the installed software geoservers and database clients. Practical classes also include the presentation of practical examples of handling: reporting and geovisualization of information based on spatial databases on the web using GIS software.

Main fields of studies for MISMaP

geography
spatial development

Type of course

elective courses

Mode

Classroom

Requirements

Fundamentals of Geoinformatics I
Fundamentals of Geoinformatics II

Prerequisites

Cartography and topography
Geographic Information Systems
Remote sensing

Prerequisites (description)

Appropriate application of sotware aiming the selection of relevant information representing spatial processes and spatial phenomena, selection of appropriate functions in order to achieve the intended results of numerical calculations or processing and proper preparation of elaboration of results in a descriptive form, report, supplemented by cartographic presentation, geovisualization or graphical presentation (chart).

Course coordinators

Piotr Werner

Learning outcomes

Theoretical and practical parts of the course are an essential element in shaping the profession of contemporary geographer and are a response to the real requirements of employers. Students learn the theoretical basis and practical applications of techniques and methods of information processing on the basis of databases, assuming a large variety of levels of computer knowledge and methodology, as well as different opportunities to use the skills mastered.

Assessment criteria

Continuous evaluation - progress of work during the classes, active participation in discussions and implementation of practical activities according to the instructions; implementation of practical projects possible asynchronously with the use of remote learning platform

Practical placement

Bibliography

Beynon-Davies P., 2003, Systemy baz danych, WNT, Warszawa
Bielecka E., 2006, Systemy Informacji Geograficznej. Teoria i zastosowania., PJWSTK, Warszawa
de Smith, Goodchild, Longley 2006-2008 Geospatial Analysis - a comprehensive guide. 2nd edition
Gotlib D., Iwaniak A., Olszewski R., 2008, GIS. Obszary zastosowań, PWN, Warszawa.
Krajewski M. (red) 2014, Wizualne bazy danych, Człowiek i społeczeństwo, XXXVI, 2, Wyd.Naukowe UAM, Poznań
Longley P.A., Goodchild D.J, Maguire D.J., Rhind D.W., 2006, GIS Teoria i praktyka. Wydawnictwo Naukowe PWN, Warszawa
Szczepanek, R., Politechnika Krakowska im. Tadeusza Kościuszki, & Wydawnictwo. (2017). Systemy informacji przestrzennej z QGIS: Podręcznik akademicki. Cz. 1 i 2 Cz. 1 i 2. Wydawnictwo PK.

Additional information

Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system:

Description of 1900-1-SBDP-SG in USOSweb