Program of lectures and exercises Geo875

Timetable, scripts, assignments and solutions

(1) Introduction to Spatial Databases: Definitions and Concepts 08.11.2024

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 15.11.2024

Spatial data types, OGC simple features, coordinate systems, spatial data models, physical models

• Lecture notes
• Exercise 2 - Task
• Exercise 2 - Solution
• Selfdemo SQL file Examples with spatial functions and queries that you can run in the course database.
• E-Learning: Postgis Intro (Chapters 6-12)

(3) Topology 22.11.2024

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 29.11.2024

Extensions to SQL, spatial operators, filter-refine, spatial range, spatial join

• Lecture notes
• Exercise 4 - Task
• Exercise 4 - Solution

(5) Spatial Indices 06.12.2024

Index principles non-spatial vs. spatial, indexing parameters, index tuning

• Lecture notes

(6) Raster Data 13.12.2024

Raster data principles. database and other storage places, pyramids
Feedback
Introduction of master thesis topcis / research

• Lecture notes
• Projects, Topics, Master Thesis

(7) No Lecture & Lab 20.12.2024

Delivery of project work until 11:59 am (morning) - digital PDF version to Zhiyong Zhou (see the Communication rules)