Lecture “Spatial Databases and Geographic Information Systems”

Master Informatik, Master Wirtschaftsinformatik
4 or 5 (depending on course of study and exam regulations)
Regular Dates: 
Fridays, 9:45-12:00, IZ 161

This lecture covers the topics of spatial databases and geographic information systems.

Among others the following issues are treated:
Modelling, mapping and indexing of spatial data, spatial queries, spatial data and XML, architecture of geographic information systems, remote sensing, location based services.


  Results of course evaluation

Date Topic Slides Exercise Video Recording
 19.10.12 Introduction
(Motivation, Organizational Issues, Content and Overview, Literature)

Spatial Data Modelling

Chapter 01



Chapter 02

--- Video  01
 26.10.12 Spatial Data Modelling
(Introduction, Geometry, Conversion between Vector and Raster Models, Topology)
Exercise 01 Video 02
 02.11.12 Spatial Data Modelling
(Fields, AAA-Project, Operations)

Exercise 02

sources and data

Video 03
 09.11.12 Mapping of Spatial Data
(Properties of Maps, Sinatures, Text, Color, Geometric Generalization)

Chapter 03




Chapter 04





Chapter 05



Chapter 06


Chapter 07

Exercise 03 Video 04

Mapping of Spatial Data
(Label and Symbol Placement)

Spatial Queries
(Development of SQL, Core SQL Queries, Spatial Queries and Core SQL)

Exercise 04 Video  05

 Spatial Queries
(Spatial Extension of the Relational Algebra, Spatial Extensions of SQL, Evaluation of Spatial Queries)

Spatial Access Methods

 --- Video  06
 30.11.12  Spatial Access Methods
(Quadtree, R-tree, K-d tree, BSP tree)
Exercise 05 Video  07

Spatial Access Methods
(Grid File)

Spatial Data and XML
(Standards, XML, GML, XSLT)

Exercise 06

Unfortunately, only the second part of the lecture has been recorded.

Video 08


Spatial Data and XML

Application Programming
(Connecting SQL with Programming Languages, Postgres and JDBC, Oracle Spatial and JDBC, Processing of GML-based Data)

Exercise  07

building data

parcel data

Video 09
 21.12.12 Architecture of Geographic Information Systems
(GIS Hardware and Software, Hybrid vs. Integrated Systems, Clients and Servers, Web-based Spatial Databases)
Chapter 08 Exercise 08 Video 10
 11.01.13 Remote Sensing
(Physical Basics, Recording Techniques

Chapter 09




Chapter 10


Chapter 11


Exercise 09 Video 11

Remote Sensing
(Image Processing, Thematic Classification)

Location Based Services

Exercise 10 Video 12


Location Based Services
(Car Navigation, Map Matching, Privacy)

Environmental Information Systems (Environmental Data,  Collection of Environmental Data,
Monitoring Networks, Laboratory Data, Example: EIS Baden-Württemberg)

 --- Video 13
 01.02.13 Review and Outlook Chapter 12  --- Video 14