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 10th to 14th, 2014 (see chapter 1.2, slide 12 and/or video 01 from 25th min.)
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
 25.10.13 Introduction
(Motivation, Organizational Issues, Content and Overview, Literature)

Spatial Data Modelling

Chapter 01

Chapter 02

Chapter 03


Chapter 04

  --- Video 01
 01.11.13 Spatial Data Modelling
(Introduction, Geometry, Conversion between Vector and Raster Models, Topology)
Exercise 01 Video 02
 08.11.13 Spatial Data Modelling
(Fields, AAA-Project, Operations)
Exercise 02 Video 03
 15.11.13 Spatial Data Modelling
Mapping of Spatial Data
(Properties of Maps, Sinatures, Text, Color, Geometric Generalization)
Exercise 03 Video 04
(now with enhanced audio quality)

Mapping of Spatial Data
(Geometric Generalization,Label and Symbol Placement)

Spatial Queries
(Development of SQL)

Exercise 04 Video 05
 29.11.13  Spatial Queries
(Core SQL Queries, Spatial Queries and Core SQL, Spatial Extension of the Relational Algebra, Spatial Extensions of SQL, Evaluation of Spatial Queries)
Exercise 05 Video 06
 06.12.13 Spatial Access Methods
(Introduction, Quadtree, R-tree)
Chapter 05
Chapter 06
Chapter 07
Exercise 06 Video 07
 13.12.13 Spatial Access Methods
(K-d tree, BSP tree, Grid File)

Spatial Data and XML
(Standards, XML)

Exercise 07 Video 08
 20.12.13 Spatial Data and XML

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

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

Chapter 10
Chapter 11

Excercise 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)

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