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 9th to 13th, 2015 (see chapter 1.2, slide 12 and/or video 01 from 24th min.)
Regular Dates: 
Fridays, 9:45-12:00, IZ 161
First lecture on October, 24th

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
 24.10.14 Introduction
(Motivation, Organizational Issues, Content and Overview, Literature)
Spatial Data Modelling
Chapter 01
Chapter 02


Chapter 03 

--- Video 01
 31.10.14 Spatial Data Modelling
(Introduction, Geometry, Conversion between Vector and Raster Models, Topology)
Exercise 01 Video 02
 07.11.14 Spatial Data Modelling
(Fields, AAA-Project, Operations)
Exercise 02 Video 03
 14.11.14 Spatial Data Modelling
Mapping of Spatial Data
(Properties of Maps, Sinatures, Text, Color, Geometric Generalization)
Exercise 03 Video 04

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

Exercise 04 Video 05
 28.11.14 Spatial Queries
(Development of SQL, Core SQL Queries, Spatial Queries and Core SQL, Spatial Extension of the Relational Algebra, Spatial Extensions of SQL)
Chapter 04

Chapter 05


Chapter 06

Chapter 07
Chapter 08

Exercise 05 Video 06
 05.12.14 Spatial Queries
(Evaluation of Spatial Queries)
Spatial Access Methods
(Introduction, Quadtree)
Exercise 06 Video 07
 12.12.14 Spatial Access Methods
(R-tree, K-d tree, BSP tree, Grid File)

Spatial Data and XML

Exercise 07 Video 08
 19.12.14 Spatial Data and XML

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

Exercise 08

building data

parcel data

Video 09
 09.01.15 Application Programming
(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
 16.01.15 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)

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