QGIS-CH Mini Workshop Relations with Interlis and QGIS
| When |
Oct 19, 2021
from 09:00 AM to 12:00 PM |
|---|---|
| Where | Online (Google Meet) |
| Contact Name | Andreas Neumann |
| Add event to calendar |
vCal
iCal
|
Using simple models we will learn how to model classes (also with inheritance) and relations (relationships). The relation strengths (association and composition) will be covered and how they are implemented by ili2pg / QGIS ModelBaker.
For the implementation of data storage in relational databases, ili2pg knows 2 different modes for mapping inheritance:
- smart1Inheritance
- smart2Inheritance
The workshop will show the differences between the two approaches as well as their advantages and disadvantages. Other relevant il2pg parameters will be covered.
After creating a simple model and importing it into the Postgis database, it will be shown how to implement relations in QGIS forms, and what configuration options (e.g. buttons to link/unlink, create/delete, zoom in, etc.) are available in the user interface.
This is not an Interlis course. Basic knowledge of modeling Interlis is assumed.
Please install the following software prior to the workshop:
- UMLEditor
- QGIS (preferably the latest LTR version 3.16)
- QGIS ModelBaker (incl. ili2pg (the plugin automatically installs ili2pg)), installation via QGIS Plugin Manager
- PostgreSQL database (you need admin rights in the DB to create new objects)
- PostgreSQL admin tool (DBeaver or pgAdmin)
- Text editor (e.g. Notepad++ (with separate syntax highlighting file), Visual Studio Code or similar)
Link Online-Workshop (Google Meet)
Github-Repository zum Workshop
Workshop instructors: David Signer (OPENGIS.ch) and Andreas Neumann (Canton Solothurn)
Workshop language: English. Questions can be asked in German or French.