Lecture “Spatial Databases and Geographic Information Systems”

Information
Classification: 
Master Informatik, Master Wirtschaftsinformatik
Credits: 
4 or 5 (depending on examination rules)
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 Recording
 29.10.10 Introduction
(Organizational Issues, Content and Overview, Literature)

Spatial Data Modelling
(Introduction)

Chapter 01

    
 

Chapter 02

---  Video 01
 05.11.10

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

Exercise 01 Video 02
 12.11.10 Spatial Data Modelling
(Fields, AAA-Project, Operations)

Exercise 02 

sources and data

Video 03
 19.11.10 Mapping of Spatial Data
(Properties of Maps, Sinatures, Text, Color, Geometric Generalization, Label and Symbol Placement)

 

Chapter 03 

 

 

Chapter 04

 

 

 

Chapter 05

 

 

 

Chapter 06

 

 

Chapter 07

 

 

 

Chapter 08

 

 

Chapter 09

Exercise 03  Video 04
 26.11.10

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
 03.12.10

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

Spatial Access Methods
(Introduction)

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

Spatial Access Methods
(Grid File)

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

Exercise 07 Video 08
 07.01.11

Spatial Data and XML
(SVG)

Application Programming
(Connecting SQL with Programming Languages, Postgres and JDBC, Oracle Spatial and JDBC )

Exercise 08

Building data

Parcel data

Video 09
 14.01.11

 Application Programming
(Processing of GML-based Data, Functional Programming with Polygons)

Architecture of Geographic Information Systems
(GIS Hardware and Software, Hybrid vs. Integrated Systems, Clients and Servers)

Exercise 09 Video 10
 21.01.11

Architecture of Geographic Information Systems
(Web-based Spatial Databases)

Remote Sensing
(Physical Basics, Recording Techniques)

Exercise 10 Video 11
 28.01.11 Remote Sensing
(Recording Techniques, Image Processing, Thematic Classification)
Exercise 11 Video 12
 04.02.11

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

Environmental Information Systems
(short summary, 10 minutes)

Chapter 10

Chapter 11

---

none

recording software failed!

 11.02.11 Review and Outlook Chapter 12 --- Video 14