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
 28.10.11 Introduction
(Motivation, Organizational Issues, Content and Overview, Literature)

Spatial Data Modelling

Chapter 01



Chapter 02


--- Video 01

Spatial Data Modelling
(Introduction, Geometry, Conversion between Vector and Raster Models, Topology)

Exercise 01 Video 02
 11.11.11 Spatial Data Modelling
(Fields, AAA-Project, Operations)
Exercise 02 Video 03
 18.11.11 Mapping of Spatial Data
(Properties of Maps, Sinatures, Text, Color, Geometric Generalization)

Chapter 03



Chapter 04




Chapter 05




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

Exercise 05


Video 06
 09.12.11 Spatial Access Methods
(Quadtree, R-tree, K-d tree, BSP tree, Grid File)

Exercise 06


We had to remove
several fragments
due to audio noise,
sorry for that.

Video 07

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

Chapter 06    

Exercise 07 Video 08
 23.12.11 Application Programming
(Connecting SQL with Programming Languages, Postgres and JDBC, Oracle Spatial and JDBC, Processing of GML-based Data, Functional Programming with Polygons )

Chapter 07      

Exercise 08

building data

parcel data

Video 09
 13.01.12 Architecture of Geographic Information Systems
(GIS Hardware and Software, Hybrid vs. Integrated Systems, Clients and Servers, Web-based Spatial Databases)

Chapter 08       

Exercise 09 Video 10


Remote Sensing
(Physical Basics, Recording Techniques)

 Chapter 09



Chapter 10


Chapter 11

Exercise 10 Video  11

Remote Sensing
(Image Processing, Thematic Classification)

Location Based Services

Exercise 11 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
 10.02.12 Review and Outlook

Chapter 12

--- Video 14