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

Spatial Data Modelling
(Introduction)

Chapter 01

 

 

Chapter 02

 

--- Video 01
 04.11.11

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

Exercise 01 Video 02
 11.11.11 Spatial Data Modelling
(Fields, AAA-Project, Operations)
Exercise 02 Video 03
 18.11.11 Mapping of Spatial Data
(Properties of Maps, Sinatures, Text, Color, Geometric Generalization)

Chapter 03

 

 

Chapter 04

 

 

 

Chapter 05

 

 

 

Exercise 03 Video 04
 25.11.11

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
 02.12.11

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

Spatial Access Methods
(Introduction)

Exercise 05

      

Video 06
 09.12.11 Spatial Access Methods
(Quadtree, R-tree, K-d tree, BSP tree, Grid File)

Exercise 06

      

We had to remove
several fragments
due to audio noise,
sorry for that.

Video 07

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

Chapter 06    

Exercise 07 Video 08
 23.12.11 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 09
 13.01.12 Architecture of Geographic Information Systems
(GIS Hardware and Software, Hybrid vs. Integrated Systems, Clients and Servers, Web-based Spatial Databases)

Chapter 08       

Exercise 09 Video 10

 20.01.12

Remote Sensing
(Physical Basics, Recording Techniques)

 Chapter 09

 

 

Chapter 10

 

Chapter 11

Exercise 10 Video  11
 27.01.12

Remote Sensing
(Image Processing, Thematic Classification)

Location Based Services
(Positioning)

Exercise 11 Video 12
 03.02.12

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
 10.02.12 Review and Outlook

Chapter 12

--- Video 14