Duration
30h Th, 30h Pr
Number of credits
Lecturer
Coordinator
Language(s) of instruction
French language
Organisation and examination
Teaching in the first semester, review in January
Schedule
Units courses prerequisite and corequisite
Prerequisite or corequisite units are presented within each program
Learning unit contents
- Definition, functions and components of the geographic information system in an organization
- relational database: relational models, SQL language and DBMS Postgres
- Modeling of a database: UML formalism (class diagram)
- Vector data: object-relational model, ISO 19107 and OGC schema for vector feature definition, coordinate system management (SRID), topological models (PostGIS topology), spatial predicates, DBMS PostGIS, complementarity between spatial database and GIS software
- Raster data: conceptual aspect, raster construction, transcription of geographic phenomena, physical definition of the raster, resampling, optimization of raster processing, rasters files, object-relational model, PostGIS raster
- Process modeling: descriptive and conceptual analysis, UML (deployment, use cases, sequences, transitions and activities diagrams), development strategies (SQL, server programming and GIS software exploitation) , graphic modelers and ETL tools
- Vector space operators and rasters
- Calculations of shortest paths and exploitation of PGRouting tool
- Geographic data sharing: metadata (ISO 19115), data quality (ISO 19157), spatial data infrastructures and OGC web services
- Spatial Business Intelligence: data warehouses and SOLAP systems
- NoSQL databases
Learning outcomes of the learning unit
- Design and implementation of a spatial data infrastructure in an organization
- Model vector and raster data and processing
Prerequisite knowledge and skills
- Geographical Information System
Planned learning activities and teaching methods
- GIS design in UML
- Implementation of a spatial database PotGIS
- Transformation and integration of data (ETL)
- Integrated exercise: from the design of the data model to the creation of a spatial enabled database
- Exercises dealing with spatial decision support and involving vector and raster data
Mode of delivery (face to face, distance learning, hybrid learning)
Face-to-face course
Additional information:
3 hours sessions including theory and tutorials.
Practical work by group of students (conception of a spatial database and its exploitation in SQL and dedicated tools) given on two sessions of three hours then finished in autonomy
Course materials and recommended or required readings
Slides available on E-Campus
Exam(s) in session
Any session
- In-person
written exam ( open-ended questions ) AND oral exam
Written work / report
Additional information:
- Practical: 40%
--Practical works: during the year 15%
- Practival exam: exercises on computer 25%
- Theory: 60%
-- Oral exam
Success is conditionned by the success in both exams (theory and practical). In case of failure, partial exemption (theory or practical) coud be given.
Attendance to courses and exercise sessions is mandatory to present exams.
Work placement(s)
Organisational remarks and main changes to the course
Most of the software used for the exercises is Open Source and free to download. Desktop computers are available to students for in-class exercises and the exam, but it is recommended to use their own machine (Windows 10 OS or higher), particularly for practical work and preparation for the practical exam.
Contacts
Unit of Geomatics
University of Liège,
Agora, 19 Allée du 6 Août, 4000 Liège (building B5a)
Secretaryship :
Tel : 04/366.57.42
Professeur Roland Billen
Dr Jean-Paul Kasprzyk
Assistant : Thomas Dethinne