Lecture “Spatial Databases and Geographic Information Systems”

Information
Classification: 
Master Informatik, Master Wirtschaftsinformatik
Credits: 
4
Exam: 
Oral
Regular Dates: 
On 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 Recordings
23.10.2009 Introduction
(Organizational Issues, Content and Overview, Literature)

Spatial Data Modelling
(Introduction)

 

Chapter 01 

 

 

Chapter 02

 

 

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

Exercise 01

All insignificant
pixel patterns

Video
06.11.2009 Spatial Data Modelling
(Topology, Fields, AAA-Project, Operations)
---  Video 
13.11.2009

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

Chapter 03

 

 

Chapter 04

Exercise 02 Video
20.11.2009

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

Spatial Queries
(Development of SQL, Core SQL Queries)

Exercise 03 Video 
27.11.2009  Spatial Queries
(Spatial Queries and Core SQL, Spatial Extension of the Relational Algebra, Spatial Extensions of SQL, Evaluation of Spatial Queries)
Exercise 04  Video 
04.12.2009 Spatial Access Methods
(Introduction, Quadtree, R-tree)

Chapter 05

 

 

Chapter 06

Exercise 05

Video

(Poor audio quality due to hardware problems, sorry!)

11.12.2009

Spatial Access Methods
(K-d tree, BSP tree, Grid File) 

Spatial Data and XML
(Standards, XML)

Exercise 06 Video
18.12.2009  Spatial Data and XML
(XML, GML, XSLT, SVG)
Exercise 07 Video
08.01.2010 Application Programming
(Connecting SQL with Programming Languages, Postgres and JDBC, Oracle Spatial and JDBC, Processing of GML-based Data, Functional Programming with Polygons) 
Chapter 07

Exercise 08

Building Data

Parcel Data

Video
15.01.2010

Architecture of Geographic Information Systems
(GIS Hardware and Software, Hybrid vs. Integrated Systems, Client/Server Systems, Web-based Spatial Databases)

GIS Servers and Clients
(Classification Characteristics, Servers, Clients)

Chapter 08

Chapter 09

Exercise 09  Video 

22.01.2010

 Remote Sensing
(Physical Basics, Recording Techniques)

Chapter 10

 

Chapter 11

Exercise 10  Video
29.01.2010

Remote Sensing
(Image Processing, Thematic Classification) 

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

 --- Video
05.02.2010
 Review and Outlook Chapter 12 ---  Video