Lecture "Spatial Databases and Geographic Information Systems"

Master Informatik, Master Wirtschaftsinformatik
Oral; exams take place in February 5th to 9th, 2018 (see chapter 1.2, slide 11 and/or video 01 from 25th min.)
Regular Dates: 
Fridays, 9:45-12:00, IZ 161
First lecture on October, 20th

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

Chapter 01





Chapter 02



--- Video 01
27.10.17 Spatial Data Modelling
(Introduction, Geometry, Conversion between Vector and Raster Models, Topology, Fields)

Exercise 01

Solution 01

Video 02
03.11.17 Spatial Data Modelling
(Fields, AAA-Project, Operations)

Exercise 02

Solution 02

Video 03
10.11.17 Mapping of Spatial Data
(Properties of Maps, Signatures, Text, Color, Geometric Generalization)


Chapter 03



Chapter 04

Exercise 03

Solution 03

Video 04
17.11.17 Mapping of Spatial Data
(Label and Symbol Placement)
Spatial Queries
(Development of SQL, Core SQL Queries, Spatial Queries and Core SQL)

Exercise 04

Solution 04

Video 05
24.11.17 Spatial Queries
(Spatial Queries and Core SQL, Spatial Extensions of SQL, Evaluation of Spatial Queries)

Exercise 05

Solution 05

Video 06

(Sound for solution wasn't recorded, sorry!)

01.12.17 Spatial Access Methods
(Introduction, Quadtree, R-tree)


Chapter 05


Chapter 06


Chapter 07

Exercise 06

Solution 06

Video 07

Spatial Access Methods
(BSP tree, Grid File)
Spatial Data and XML
(Standards, XML, GML)

Exercise 07

Solution 07

Video 08

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

Building data

Parcel data

Solution 08

Video 09
22.12.17 Architecture of Geographic Information Systems
(GIS Hardware and Software, Hybrid vs. Integrated Systems, Clients and Servers, Web-based Spatial Databases)
Chapter 08

Exercise 09

Solution 09

Video 10
12.01.18 Remote Sensing
(Physical Basics, Recording Techniques)



Chapter 09


Chapter 10


Chapter 11

Exercise 10

Solution 10

Video 11
19.01.18 Remote Sensing
(Image Processing, Thematic Classification)
Location Based Services

Exercise 11

Solution 11

Video 12

Location Based Services
(Car Navigation, Map Matching, Privacy)
Environmental Information Systems
(Environmental Data, Collection of Environmental Data, Monitoring Networks, Laboratory Data)

Exercise 12

Solution 12

Video 13

(Sound for 11.1 wasn't recorded, sorry!)

02.02.18 Review and Outlook Chapter 12 --- Video 14