Lecture “Spatial Databases and Geographic Information Systems”

Master Informatik, Master Wirtschaftsinformatik
4 or 5 (depending on examination rules)
Regular Dates: 
On 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
 29.10.10 Introduction
(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
 12.11.10 Spatial Data Modelling
(Fields, AAA-Project, Operations)

Exercise 02 

sources and data

Video 03
 19.11.10 Mapping of Spatial Data
(Properties of Maps, Sinatures, Text, Color, Geometric Generalization, Label and Symbol Placement)


Chapter 03 



Chapter 04




Chapter 05




Chapter 06



Chapter 07




Chapter 08



Chapter 09

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
 10.12.10 Spatial Access Methods
(Quadtree, R-tree, K-d tree, BSP tree)
Exercise 06 Video 07

Spatial Access Methods
(Grid File)

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

Exercise 07 Video 08

Spatial Data and XML

Application Programming
(Connecting SQL with Programming Languages, Postgres and JDBC, Oracle Spatial and JDBC )

Exercise 08

Building data

Parcel data

Video 09

 Application Programming
(Processing of GML-based Data, Functional Programming with Polygons)

Architecture of Geographic Information Systems
(GIS Hardware and Software, Hybrid vs. Integrated Systems, Clients and Servers)

Exercise 09 Video 10

Architecture of Geographic Information Systems
(Web-based Spatial Databases)

Remote Sensing
(Physical Basics, Recording Techniques)

Exercise 10 Video 11
 28.01.11 Remote Sensing
(Recording Techniques, Image Processing, Thematic Classification)
Exercise 11 Video 12

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

Environmental Information Systems
(short summary, 10 minutes)

Chapter 10

Chapter 11



recording software failed!

 11.02.11 Review and Outlook Chapter 12 --- Video 14