Lecture "Spatial Databases and Geographic Information Systems"

Master Informatik, Master Wirtschaftsinformatik
4 or 5 (depending on course of study and exam regulations)
Oral; exams take place in February 15th to 19th, 2016 (see chapter 1.2, slide 12 and/or video 01 from 26th min.)
Regular Dates: 
Fridays, 9:45-12:00, IZ 161
First lecture on October, 30th

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.

  List of contents


  Results of course evaluation


Date Topic Slides Exercise Video Recording
 30.10.15 Introduction
(Motivation, Organizational Issues, Content and Overview, Literature)
Spatial Data Modelling

Chapter 01



Chapter 02





Chapter 03





Chapter 04



Chapter 05

 --- Video 01
 06.11.15 Spatial Data Modelling
(Introduction, Geometry, Conversion between Vector and Raster Models, Topology)
Exercise 01 Video 02
 13.11.15 Spatial Data Modelling
(Fields, AAA-Project, Operations)
Exercise 02 Video 03
 20.11.15 Spatial Data Modelling
Mapping of Spatial Data
(Properties of Maps, Sinatures, Text, Color, Geometric Generalization)
Exercise 03 Video 04
 27.11.15 Mapping of Spatial Data
(Geometric Generalization,Label and Symbol Placement)
Exercise 04 Video 05
 04.12.15 Mapping of Spatial Data
(Label and Symbol Placement)
Spatial Queries
(Development of SQL, Core SQL Queries, Spatial Queries and Core SQL,  Spatial Extensions of SQL)
Exercise 05 Video 06
 11.12.15 Spatial Queries
(Spatial Extensions of SQL, Evaluation of Spatial Queries)
Spatial Access Methods
(Introduction, Quadtree)
Exercise 06 Video 07
 18.12.15 Spatial Access Methods
(R-tree, K-d tree, BSP tree, Grid File)
Exercise 07 Video 08
 08.01.16 Spatial Data and XML
(Standards, XML, GML, SVG)
Application Programming
(Connecting SQL with Programming Languages)

Chapter 06


Chapter 07


Chapter 08

Exercise 08 Video 09
 15.01.16 Application Programming
(Postgres and JDBC,Oracle Spatial and JDBC, Processing of GML-based Data)
Architecture of Geographic Information Systems
(GIS Hardware and Software, Hybrid vs. Integrated Systems, Clients and Servers, Web-based Spatial Databases)
Exercise 09 Video 10
 22.01.16 Remote Sensing
(Physical Basics, Recording Techniques)
Chapter 09 Exercise 10 Video 11
 29.01.16 Remote Sensing
(Recording Techniques, Image Processing, Thematic Classification)
Exercise 11 Video 12 (copy from last year)
 05.02.16 Location Based Services
(Positioning, Car Navigation, Map Matching, Privacy)
Chapter 10 --- Video 13 (copy from last year)
 12.02.16 Review and Outlook  Chapter 12 --- Video 14