Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2019/2020

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
155UZPR Z,ZK 5 2P+2C Czech
Lecturer:
Martin Landa
Tutor:
Martin Landa
Supervisor:
Department of Geomatics
Synopsis:

1. Introduction to the problem, specification of OpeGIS Simple Features

2. Spatial relations, 9-crossection model (DE-9IM)

3. Object-relational database model, introduction to PostGIS geodatabase

4. Spatial SQL, data types, indices, functions

5. Advanced technics of spatial SQL

6. Topology of vector data, data models

7, Raster data in object-relational databases and their processing

8. GIS network analyses in object-relational databases

9. Data access, web services, map servers

10.Data publicising, creation of application using data warehouses

11. Set geodatabases, practical applications

12. Distributed, document oriented (NoSQL) databases and their application in geoinformatics

13. Introduction to the problem of BigData processing

Requirements:

155ING2 Informatics 2 - Database systems

Syllabus of lectures:

1. Introduction to the problem, specification of OpeGIS Simple Features

2. Spatial relations, 9-crossection model (DE-9IM)

3. Object-relational database model, introduction to PostGIS geodatabase

4. Spatial SQL, data types, indices, functions

5. Advanced technics of spatial SQL

6. Topology of vector data, data models

7, Raster data in object-relational databases and their processing

8. GIS network analyses in object-relational databases

9. Data access, web services, map servers

10.Data publicising, creation of application using data warehouses

11. Set geodatabases, practical applications

12. Distributed, document oriented (NoSQL) databases and their application in geoinformatics

13. Introduction to the problem of BigData processing

Syllabus of tutorials:

Semester project

Study Objective:

The goal of the subject is to work with geospatial data, databases and queries incuding the problemacy of BigData.

Study materials:

!Obe, R. Hsu, L. 2011. PostGIS in Action. Manning. ISBN 9781935182269

!Rigaux P. et al., 2002. Spatial Databases: With Application to GIS. ISBN 9781558605886.

!Yeung, G. Hall, 2007. Spatial Database Systems: Design, Implementation and Project Management. Springer. ISBN 978-1402053931

?H. Karimi, 2014. Big Data: Techniques and Technologies in Geoinformatics. CRC Press. ISBN 978-1466586512.

?M. Zurbaran, 2018. PostGIS Cookbook. ISBN 1788299329

?R. Obe, L. Hsu, 2011. pgRouting: A Practical Guide. ISBN 978-0989421737

:PostGIS documentation, http://postgis.net/docs

:GISMentors training materials, http://training.gismentors.eu/postgis-zacatecnik

Note:
Further information:
http://gama.fsv.cvut.cz/gwiki/155UZPD_Úvod_do_zpracován%C3%AD_prostorových_dat http://gama.fsv.cvut.cz/gwiki/155UZPD_/_Semestráln%C3%AD_projekt
Time-table for winter semester 2019/2020:
06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon
Tue
Fri
roomTH:B-870

16:00–17:50
(lecture parallel1)
Thákurova 7 (FSv-budova A)
B870
roomTH:B-870

18:00–19:50
(lecture parallel1
parallel nr.101)

Thákurova 7 (FSv-budova A)
B870
Thu
Fri
Time-table for summer semester 2019/2020:
Time-table is not available yet
The course is a part of the following study plans:
Data valid to 2020-04-08
For updated information see http://bilakniha.cvut.cz/en/predmet5636906.html