Lecture "Spatial Databases and Geographic Information Systems"

Information
Classification: 
Master Informatik, Master Wirtschaftsinformatik
Credits: 
5
Exam: 
Oral; exams take place in February 5th to 9th, 2018 (see chapter 1.2, slide 11 and/or video 01 from 25th min.)
Regular Dates: 
Fridays, 9:45-12:00, IZ 161
First lecture on October, 20th
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
20.10.17 Introduction
(Motivation, Organizational Issues, Content and Overview, Literature)
Spatial Data Modelling
(Introduction)

Chapter 01

 

 

 

 

Chapter 02

 

 

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

Exercise 01

Solution 01

Video 02
03.11.17 Spatial Data Modelling
(Fields, AAA-Project, Operations)

Exercise 02

Solution 02

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

 

Chapter 03

 

 

Chapter 04

Exercise 03

Solution 03

Video 04
17.11.17 Mapping of Spatial Data
(Label and Symbol Placement)
Spatial Queries
(Development of SQL, Core SQL Queries, Spatial Queries and Core SQL)

Exercise 04

Solution 04

Video 05
24.11.17 Spatial Queries
(Spatial Queries and Core SQL, Spatial Extensions of SQL, Evaluation of Spatial Queries)

Exercise 05

Solution 05

Video 06

(Sound for solution wasn't recorded, sorry!)

01.12.17 Spatial Access Methods
(Introduction, Quadtree, R-tree)

 

Chapter 05

 

Chapter 06

 

Chapter 07

Exercise 06

Solution 06

Video 07
08.12.17

Spatial Access Methods
(BSP tree, Grid File)
Spatial Data and XML
(Standards, XML, GML)

Exercise 07

Solution 07

Video 08
15.12.17

Spatial Data and XML
(SVG)
Application Programming
(Connecting SQL with Programming Languages, Postgres and JDBC,Oracle Spatial and JDBC, Processing of GML-based Data)

Exercise 08

Building data

Parcel data

Solution 08

Video 09
22.12.17 Architecture of Geographic Information Systems
(GIS Hardware and Software, Hybrid vs. Integrated Systems, Clients and Servers, Web-based Spatial Databases)
Chapter 08

Exercise 09

Solution 09

Video 10
12.01.18 Remote Sensing
(Physical Basics, Recording Techniques)

 

 

Chapter 09

 

Chapter 10

 

Chapter 11

Exercise 10

Solution 10

Video 11
19.01.18 Remote Sensing
(Image Processing, Thematic Classification)
Location Based Services
(Positioning)

Exercise 11

Solution 11

Video 12
26.01.18

Location Based Services
(Car Navigation, Map Matching, Privacy)
Environmental Information Systems
(Environmental Data, Collection of Environmental Data, Monitoring Networks, Laboratory Data)

Exercise 12

Solution 12

Video 13

(Sound for 11.1 wasn't recorded, sorry!)

02.02.18 Review and Outlook Chapter 12 --- Video 14