ECTS
ECTS Course Catalogue

Course details
Course code: IGS20467o12
Semester: 2012/2013 winter
Name: Spatial databases
Major: Geodesy and Cartography
Study Type: second cycle
Course type: compulsory
Study Semester: 2
ECTS points: 6
Hours (Lectures / Tutorials / Other): 30 / 30 / 0
Lecturer: dr inż. Tomasz Kubik
Language of instruction: Polish / English
The course in English will be available if a minimum of 6 students sign up for a group. If less than 6 students sign up for the group, the course will be available in Polish with the possibility of individual support in English.

Learning outcomes: Learning outcomes: Student knows opportunities rising up from enabling spatial option in databases, knows methods used to solve common problems related to the analysis of spatial data on the database side, understand the role of spatial databases in the infrastructure for spatial information implementation.

Competences: Student can design a database schema to store and process geometric and descriptive attributes of variety of objects, can run spatial queries against data collected within the scope of database server, can convert geospatial data with the use of tolls embedded in the databases, can configure databases to work with geospatial web services.

Prerequisites: Data bases, Programming in GIS

Course content: Introduction to spatial databases (Simple Feature Access: SQL option, data providers, databases implementation: PostgreSQL and PostGIS). Implementation of clients of spatial databases (network services, web applications, desktop applications). Overview of tools for spatial data processing. Geometry representation in relationa databases (geometry types, WKT and EWKT formats). Representation and use of geographic reference systems. Modeling of complex geometries. Protecting spatial data. Spatial analysis on the database server side (creation and modification of data, topological operators, measurements, composition and decomposition). Spatial index and bounding box. Spatial data conversion. Spatial database performance. Managing raster data.

Recommended literature: Regina O. Obe, Leo S. Hsu: PostGIS in action. Greenwich, Conn. London, Manning, 2011 PostGIS manual (e-document available at postgis.refractions.net/docs/)

Assessment methods: written exam (only after successful evaluation of all exercises), exercises evaluated on the base of results of computer assignments (evaluated individually).

Comment: