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 9th to 13th, 2015 (see chapter 1.2, slide 12 and/or video 01 from 24th min.)
Regular Dates: 
Fridays, 9:45-12:00, IZ 161
First lecture on October, 24th
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.

  List of contents

 

Materials

  Results of course evaluation

Date Topic Slides Exercise Video Recording
 24.10.14 Introduction
(Motivation, Organizational Issues, Content and Overview, Literature)
Spatial Data Modelling
(Introduction)
Chapter 01
 
 
 
 
 
Chapter 02

 
 

 
Chapter 03 

--- Video 01
 31.10.14 Spatial Data Modelling
(Introduction, Geometry, Conversion between Vector and Raster Models, Topology)
Exercise 01 Video 02
 07.11.14 Spatial Data Modelling
(Fields, AAA-Project, Operations)
Exercise 02 Video 03
 14.11.14 Spatial Data Modelling
(Operations)
Mapping of Spatial Data
(Properties of Maps, Sinatures, Text, Color, Geometric Generalization)
Exercise 03 Video 04
 21.11.14

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

Exercise 04 Video 05
 28.11.14 Spatial Queries
(Development of SQL, Core SQL Queries, Spatial Queries and Core SQL, Spatial Extension of the Relational Algebra, Spatial Extensions of SQL)
Chapter 04

 
 
 
Chapter 05

 

 
Chapter 06
 
 

 
Chapter 07
 
 
 
 
Chapter 08

Exercise 05 Video 06
 05.12.14 Spatial Queries
(Evaluation of Spatial Queries)
Spatial Access Methods
(Introduction, Quadtree)
Exercise 06 Video 07
 12.12.14 Spatial Access Methods
(R-tree, K-d tree, BSP tree, Grid File)

Spatial Data and XML
(Standards)

Exercise 07 Video 08
 19.12.14 Spatial Data and XML
(XML, GML, SVG)

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

Exercise 08

building data

parcel data

Video 09
 09.01.15 Application Programming
(Oracle Spatial and JDBC, Processing of GML-based Data)
Architecture of Geographic Information Systems
(GIS Hardware and Software, Hybrid vs. Integrated Systems, Clients and Servers, Web-based Spatial Databases)
Exercise 09  Video 10
 16.01.15 Remote Sensing
(Physical Basics, Recording Techniques)
Chapter 09
 

 
Chapter 10
 
 

Chapter 11

Exercise 10 Video 11
 23.01.15

Remote Sensing
(Image Processing, Thematic Classification)

Location Based Services
(Positioning)

Exercise 11 Video 12
 30.01.15

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

Environmental Information Systems (Environmental Data,  Collection of Environmental Data, Monitoring Networks, Laboratory Data)

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