Program of lectures and exercises Geo875
Timetable, scripts, assignments and solutions
(1) Introduction to Spatial Databases: Definitions and Concepts 07.11.2025
Overview, spatial is special, object-relational DBMS, spatial DB, ER modelling of spatial relationship and data types
- Lecture notes
- Template file (Powerpoint) for drawing spatial ER models
- DB Connections - DBeaver Config from course Geo874 for setting up your database connections
(2) Spatial Data Types 14.11.2025
Spatial data types, OGC simple features, coordinate systems, spatial data models, physical models
- Lecture notes
- Selfdemo SQL file Examples with spatial functions and queries that you can run in the course database.
- Exercise 2 - Task
- Exercise 2 - Solution
- E-Learning: Postgis Intro (Chapters 6-12)
(3) Topology 21.11.2025
Data models for topology, object topology (adjacenct, overlapping, disjointness, inclusion), 9-intersection model
- Lecture notes
- Tips & Hints for ER Diagrams
- Exercise 3 - Task
- Exercise 3 - Solution
- E-Learning: Postgis Intro (Chapters 11-18)
(4) Spatial Queries 28.11.2025
Extensions to SQL, spatial operators, filter-refine, spatial range, spatial join
(5) Spatial Indices 05.12.2025
Index principles non-spatial vs. spatial, indexing parameters, index tuning
(6) Raster Data 12.12.2025
Raster data principles. database and other storage places, pyramids
Feedback
Introduction of master thesis topcis / research
- Lecture notes
- Projects, Topics, Master Thesis
- Individual Evaluation - Lecture & Lab & Excercise & Project open 05.12.2025 - 19.12.2025
(7) No Lecture & Lab 19.12.2025
Delivery of project work
until 11:59 am (morning) - digital PDF version to Esra Suel (see the Communication rules)