Spatial Databases Geo875

Lectures, exercises and practical sessions in Fall Semester 2025

Registration and booking

The course is fully booked for Fall Semester 2025.

Content and objectives

In this course we extend the knowledge of data management in relational databases acquired in Geo874 (Introduction to Databases) with a focus on spatial data management, usage and analysis. We will introduce spatial indexes, topological data models and spatial queries. Open source software (PostGIS) will be used as an example.

You will learn about the handling of both geometrical and attribute variables in an efficient manner. We will then extend this knowledge to handling of georeferenced raster data, considerations for the storage of topological data, intricacies of spatial indexing and the optimization of topological analysis through spatial indexes. The course will cover the extensions to the SQL query language that relate to spatial data handling.

In parallel to the theoretical stream, practical skills will be acquired by dealing with real-world data step-by-step from the creation of relational data models, through data import to querying and spatial data analysis. The practical part will consist of exercises relating to selected parts of lectures and an accompanying group project.

The criteria listed in this document apply for the final evaluation of the entire module and the award of ECTS-points. The GIUZ AI guidelines apply for this course as well


Communication rules: Email with the following information = easier processing

  1. Email: Use our addresses listed on this webpage. Put your group member in CC.
  2. Subject: Mention course and group and some text. Example: "geo875 group99 ER-Diagram"
  3. Attachments in pdf format: Example: "geo875_group99_er_proposal.pdf".
  4. Attachment's content: Title, your personal names, group ID and date. Use legends. Add comments to your sql code (lines starting with "--").

Time and place

Every Friday
08:00-09:45 - Lecture
10:15-12:00 - Practical / Exercise / Project

Timetable and deadlines