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

  survey about map symbols

 

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 Video 05
24.11.17      
01.12.17        
08.12.17        
15.12.17        
22.12.17        
12.01.18        
19.01.18        
26.01.18        
02.02.18