Warning! The directory is not yet complete and will be amended until the beginning of the term.
290187 PS Geodatabases (2021S)
Continuous assessment of course work
Labels
Registration/Deregistration
Note: The time of your registration within the registration period has no effect on the allocation of places (no first come, first served).
- Registration is open from Mo 08.02.2021 11:00 to Mo 22.02.2021 10:00
- Deregistration possible until We 31.03.2021 23:59
Details
max. 20 participants
Language: German
Lecturers
Classes
Diese LV findet ausschließlich digital statt.
Mittwoch, 03.03.2021 - 16:00-18:00 UhrMittwoch, 10.03.2021 - 16:00-18:00 Uhr
Mittwoch, 17.03.2021 - 16:00-18:00 Uhr
Mittwoch, 24.03.2021 - 16:00-18:00 Uhr
Mittwoch, 14.04.2021 - 16:00-18:00 Uhr
Mittwoch, 21.04.2021 - 16:00-18:00 Uhr
Mittwoch, 28.04.2021 - 16:00-18:00 Uhr
Mittwoch, 05.05.2021 - 16:00-18:00 Uhr
Mittwoch, 12.05.2021 - 16:00-18:00 Uhr
Mittwoch, 19.05.2021 - 16:00-18:00 Uhr - Präsentationstermin I
Mittwoch, 26.05.2021 - 16:00-18:00 Uhr - Präsentationstermin II
Mittwoch, 02.06.2021 - 16:00-17:00 Uhr - Tutorium
Mittwoch, 16.06.2021 - 16:00-17:00 Uhr - Abschlussprüfung
Information
Aims, contents and method of the course
Assessment and permitted materials
The grade is composed of participation (10%), an intermediate test (20%), a final exam (40%), and a group project including a short presentation (30%). A positive completion requires an overall grade of at least 51%.
Minimum requirements and assessment criteria
The grade is composed of participation (10%), an intermediate test (20%), a final exam (40%), and a group project including a short presentation (30%). A positive completion requires an overall grade of at least 51%.
A maximum of 2 units may be missed.
< 50%: Nicht genügend
>50 - 62,5%: Genügend
>62,5 - 75%: Befriedigend
>75 - 87,5%: Gut
> 87,5 - 100%: Sehr gut
A maximum of 2 units may be missed.
< 50%: Nicht genügend
>50 - 62,5%: Genügend
>62,5 - 75%: Befriedigend
>75 - 87,5%: Gut
> 87,5 - 100%: Sehr gut
Examination topics
Provided via e-learning platform as well as documents from the course Geodatabases.
Reading list
Obe R. & Hsu L. (2015): PostGIS in Action. - Shelter Island, NY, USA.
Connolly T. & Begg C. (2015): Database Systems: A Practical Approach to Design, Implementation, and Management, Global Edition. - London.
Elmasri R. & Navathe S. (2016): Fundamentals of Database Systems. – Pearson.
Coronel C. & Morris S. (2018). Database systems: Design, implementation, and management. - Boston, MA, USA.
Winand M. (2012): SQL Performance Explained: Everything Developers Need to Know about SQL Performance. - Wien
Connolly T. & Begg C. (2015): Database Systems: A Practical Approach to Design, Implementation, and Management, Global Edition. - London.
Elmasri R. & Navathe S. (2016): Fundamentals of Database Systems. – Pearson.
Coronel C. & Morris S. (2018). Database systems: Design, implementation, and management. - Boston, MA, USA.
Winand M. (2012): SQL Performance Explained: Everything Developers Need to Know about SQL Performance. - Wien
Association in the course directory
(MK1-W1-PI)
Last modified: We 19.05.2021 12:48
- Introduction
o Review of the basics of relational databases and SQL
Working environment and relational model
Tables, views, relations, data types, indexes and normalization
Functions, procedures and queries
o Spatial databases
Introduction to GIS ecosystem, consisting of GIS clients and databases
Database 'tooling
Notes on the set-up of PostGIS
Connection of PostGIS and GIS client
Presentation of the demo databases that will accompany the course throughout the semester
- Working in PostGIS
o Spatial data types and indices
Geometry, Geography, Raster and Topology
Types and uses of spatial indices: GIST, BRIN and SP-GIST
o Spatial Functions: Core
Creation of spatial database objects in the database
Transfer to another reference system
Measurement functions
Decomposition and simplification functions
o Spatial functions: Topological
Creation and use of enveloping boxes (bounding boxes)
Difference spatial and geometric equality
Relations (intersection, overlap, within, etc.)
Spatial links
Special functions: Difference and division
- Connection to GIS client (ArcPro and QGIS)
o Setting up the connections
o Control of the effects in the client, with change in the data base
o Explaining the advantages and disadvantages between GIS client and working in the databaseMethods
At the beginning of each unit, the students learn the basics of the respective topic in interactive lessons. Afterwards, the practical application of the newly learned knowledge with special software begins.Targets
Students are familiar with the basics of geodatabases and know the current methods and procedures for data storage and management of spatial data. They are able to design geodatabases and to use the data they contain as information with different software applications.