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; 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
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
 25.10.13 Introduction
(Motivation, Organizational Issues, Content and Overview, Literature)

Spatial Data Modelling
(Introduction)

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
(Operations)
Mapping of Spatial Data
(Properties of Maps, Sinatures, Text, Color, Geometric Generalization)
Exercise 03 Video 04
(now with enhanced audio quality)
 22.11.13

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
(XML, GML, SVG)

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
 24.01.14

Remote Sensing
(Image Processing, Thematic Classification)

Location Based Services
(Positioning)

Exercise 11 Video 12
 31.01.14

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