Duration
30h Th, 30h Pr
Number of credits
Lecturer
N...
Substitute(s)
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: different models (hybrid without topology, hybrid with topology, relational integrated and object-relational), ISO 19107 and OGC schema for vector feature definition, coordinate system management (SRID), 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, integrated mesh model, hybrid logic model, 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 - Map Algebra and Multicriteria Analysis - Calculations of shortest paths and exploitation of PGRouting tool
Learning outcomes of the learning unit
- Design and implementation of a GIS in an organization - Model vector and raster data and processing
Prerequisite knowledge and skills
- Cartography
Planned learning activities and teaching methods
- GIS design in UML
- Implementation of a spatial database management system
- Use of Case Tools and ETL
- Integrated exercise: from the design of the data model to the creation of a spatial enabled database
- Development of applications by graphic modelers and Python scripts
- Exercises dealing with spatial decision support in vector and raster modes
Mode of delivery (face-to-face ; distance-learning)
3 hours sessions including theory and tutorialsPractical work by group of students (conception of a spatial database and its exploitation in SQL) given on two sessions of three hours then finished in autonomy
Recommended or required readings
Slides available here : http://geomatics.ulg.ac.be/download/SIG/
Assessment methods and criteria
- 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)
Organizational remarks
Most of the software used for the exercises are Open Source. They can be downloaded by students on their computers, but the exercises are necessarily carried out on the university's computers (not students' laptops).
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 et Jean-Paul Kasprzyk
Assistant : Romain Neuville
Adaptation of teaching commitments following the COVID-19 pandemic for the May-June 2020 session
Teaching methods implemented : distance-learning
Assessment subjects
Assessment methods
Contacts
Adaptation of teaching commitments following the COVID-19 pandemic for the Aug-Sept 2020 session
Assessment subjects
No change compared to the january session
Assessment methods
Practical part: The examination will be a remote exercise with the tool PostGIS. The duration of the exam will be 2 hours and the evaluation will focus on the analysis of the documents returned by the student at the end of the exam. The choice of video conferencing platform is blackboard. Theoretical part: Oral exam of 15 min via the blackboard platform (closed book).
Contacts
Jean-Paul Kasprzyk Mail: jp.kasprzyk@uliege.be Tel: +32 4 3665089