Lecture “Spatial Databases and Geographic Information Systems”

Information
Classification: 
Master Informatik, Master Wirtschaftsinformatik
Credits: 
4 or 5 (depending on course of study and exam regulations)
Exam: 
Oral
Regular Dates: 
Fridays, 9:45-12:00, IZ 161
Contents
Contents: 

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.

Materials

  Results of course evaluation

Date Topic Slides Exercise Video Recording
 19.10.12 Introduction
(Motivation, Organizational Issues, Content and Overview, Literature)

Spatial Data Modelling
(Introduction)

Chapter 01

 

 

Chapter 02

--- Video  01
 26.10.12 Spatial Data Modelling
(Introduction, Geometry, Conversion between Vector and Raster Models, Topology)
Exercise 01 Video 02
 02.11.12 Spatial Data Modelling
(Fields, AAA-Project, Operations)

Exercise 02

sources and data

Video 03
 09.11.12 Mapping of Spatial Data
(Properties of Maps, Sinatures, Text, Color, Geometric Generalization)

Chapter 03

 

 

 

Chapter 04

 

 

 

 

Chapter 05

 

 

Chapter 06

 

Chapter 07

Exercise 03 Video 04
 16.11.12

Mapping of Spatial Data
(Label and Symbol Placement)

Spatial Queries
(Development of SQL, Core SQL Queries, Spatial Queries and Core SQL)

Exercise 04 Video  05
 23.11.12

 Spatial Queries
(Spatial Extension of the Relational Algebra, Spatial Extensions of SQL, Evaluation of Spatial Queries)

Spatial Access Methods
(Introduction)

 --- Video  06
 30.11.12  Spatial Access Methods
(Quadtree, R-tree, K-d tree, BSP tree)
Exercise 05 Video  07
 07.12.12

Spatial Access Methods
(Grid File)

Spatial Data and XML
(Standards, XML, GML, XSLT)

Exercise 06

Unfortunately, only the second part of the lecture has been recorded.

Video 08

 14.12.12

Spatial Data and XML
(SVG)

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

Exercise  07

building data

parcel data

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

Chapter 09

 

 

 

Chapter 10

 

Chapter 11

 

Exercise 09 Video 11
 18.01.13

Remote Sensing
(Image Processing, Thematic Classification)

Location Based Services
(Positioning)

Exercise 10 Video 12

 24.01.13


Location Based Services
(Car Navigation, Map Matching, Privacy)

Environmental Information Systems (Environmental Data,  Collection of Environmental Data,
Monitoring Networks, Laboratory Data, Example: EIS Baden-Württemberg)

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