4. Admin Guide

This represents a guide on how to administrate the database, install a Virtual machine, import and export data

• 4.1. Datamodel
• 4.2. pgAdmin
  • 4.2.1. Install pgAdmin
    • 4.2.1.1. Windows
    • 4.2.1.2. Linux
  • 4.2.2. Using pgAdmin
    • 4.2.2.1. SQL query
    • 4.2.2.2. Database dump
• 4.3. User Roles
• 4.4. INTERLIS Data exchange
  • 4.4.1. General
  • 4.4.2. Prerequisites
    • 4.4.2.1. Java
    • 4.4.2.2. Python libraries
    • 4.4.2.3. TWW Version
  • 4.4.3. Usage (GUI)
    • 4.4.3.1. Enable admin mode
  • 4.4.4. INTERLIS Export
    • 4.4.4.1. Export extra organisations
  • 4.4.5. INTERLIS Import
  • 4.4.6. Usage (command line)
    • 4.4.6.1. Dependencies
    • 4.4.6.2. Import
    • 4.4.6.3. Export
  • 4.4.7. Quality control
    • 4.4.7.1. Quality control with VSA online checker (Fachprüfung mit VSA Checker (online))
• 4.5. Customization of the data model
  • 4.5.1. Alterations to ordinary data
    • 4.5.1.1. Introduction
    • 4.5.1.2. Altering symbology and labelling behaviour
    • 4.5.1.3. Creation of custom tables
    • 4.5.1.4. Adding fields to base tables
    • 4.5.1.5. Datamodel updates
  • 4.5.2. Modification Framework for application schema
    • 4.5.2.1. Creation and loading of modifications
    • 4.5.2.2. Limitations for sql scripts
• 4.6. Data model tool
  • 4.6.1. Setup
  • 4.6.2. Usage
    • 4.6.2.1. Main dialog
    • 4.6.2.2. Troubleshooting
• 4.7. Manual update of the datamodel
  • 4.7.1. Requirements
    • 4.7.1.1. Client
    • 4.7.1.2. PostgreSQL
    • 4.7.1.3. Python
    • 4.7.1.4. PUM installation
  • 4.7.2. Database update
    • 4.7.2.1. PostgreSQL service
    • 4.7.2.2. Database backup
    • 4.7.2.3. Download and install current database release
    • 4.7.2.4. Create empty database
    • 4.7.2.5. Launch update

In discussion:

• dxf (see improved dxf export feature description (since QGIS 3.38) from opengis.ch and QGIS user documentation

• Shape

• MOUSE / MikeUrban (please connect with the developer team if you are interested in this)

• other