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

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

Chapter 01




Chapter 02



Chapter 03



Chapter 04



Chapter 05

--- Video 01
28.10.16 Spatial Data Modelling
(Introduction, Geometry, Conversion between Vector and Raster Models, Topology)
Exercise 01 Video 02
04.11.16 Spatial Data Modelling
Exercise 02 Video 03
11.11.16 Spatial Data Modelling
(AAA-Project, Operations)
Mapping of Spatial Data
(Properties of Maps)
Exercise 03 Video 04
18.11.16 Mapping of Spatial Data
(Sinatures, Text, Color, Geometric Generalization, Label and Symbol Placement)
Exercise 04 Video 05
25.11.16 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
02.12.16 Spatial Queries
(Spatial Extensions of SQL, Evaluation of Spatial Queries)
Spatial Access Methods
(Introduction, Quadtree)
Exercise 06 Video 07
09.12.16 Spatial Access Methods
(R-tree, K-d tree, BSP tree, Grid File)
Exercise 07 Video 08
16.12.16 Spatial Data and XML
(Standards, XML, GML, SVG)
Chapter 06 Exercise 08 Video 09
13.01.17 Application Programming
(Connecting SQL with Programming Languages, 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)

Chapter 07



Chapter 08



Chapter 09



Chapter 10

Exercise 09 Video 10
20.01.17 Architecture of Geographic Information Systems
(Clients and Servers, Web-based Spatial Databases)
Remote Sensing
(Physical Basics, Recording Techniques)
Exercise 10 Video 11
27.01.17 Remote Sensing
(Recording Techniques, Image Processing, Thematic Classification)
Exercise 11 Video 12
03.02.17 Remote Sensing
(Thematic Classification)
Location Based Services
(Positioning, Car Navigation, Map Matching, Privacy)
Exercise 12 Video 13
10.02.17 Review and Outlook  Chapter 12 --- Video 14