Course syllabus

Geografiska databaser
Geographical Databases

EXTN70, 7,5 credits, A (Second Cycle)

Valid for: 2012/13
Decided by: Education Board 2
Date of Decision: 2012-03-16

General Information

Elective for: L4-gi
Language of instruction: The course might be given in English


The aim of the course is to provide a theoretical basis for how geographic databases are structured and how they can be used. Additionally, the course aims to provide practical skill in the modelling, creation, and use of such databases.

Learning outcomes

Knowledge and understanding
For a passing grade the student must

• explain how a structured query language can be used to create relational databases as well as for implementing advanced queries

• describe how geographical data can be stored, and how they can be searched, in a database

* explain spatial indexation techniques,

• analyze the advantages and disadvantages for storing geographical data in a database compared to a file system

• explain fundamental concepts in object oriented modelling, and

• describe how object-oriented modelling can be used to describe the structure of a geographical database.

Competences and skills
For a passing grade the student must

• independently create an object oriented model that describes the structure of a geographic database in a standardized modelling language, and

• be able to communicate with a database designed for geographic data.

Judgement and approach
For a passing grade the student must

• take a critical stance to the structure of, and techniques for storing, geographic data.


The course contains the central concepts and techniques for management of geographic databases. The areas covered in particular include spatial databases, object oriented modelling of the content of geographic databases, structure query language – SQL (as well as an extension of this language to handle spatially explicit queries), and spatial indexing.

Examination details

Grading scale: TH
Assessment: Assessment takes the form of a written examination, and evaluation of project work. Approved on all exercises and participation on all compulsory activities.


Admission requirements:

The number of participants is limited to: 30
Selection: Total number of credits on master level within specialisation of LTH program.
The course might be cancelled: If the number of applicants is less than 16.
The course overlaps following course/s: EDA216, GISN06

Reading list

Contact and other information

Course coordinator: Lars Harrie,
Course homepage: