Admin Guide

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

• Datamodel
• pgAdmin
  • Install pgAdmin
    • Windows
    • Linux
  • Using pgAdmin
    • SQL query
    • Database dump
• User Roles
• INTERLIS Data exchange
  • General
  • Prerequisites
    • Java
    • Python libraries
    • TWW Version
  • Usage (GUI)
    • Enable admin mode
  • INTERLIS Export
    • Export extra organisations
  • INTERLIS Import
  • Usage (command line)
    • Dependencies
    • Import
    • Export
  • Quality control
    • Quality control with VSA online checker (Fachprüfung mit VSA Checker (online))
• Customization of the data model
  • Alterations to ordinary data
    • Introduction
    • Altering symbology and labelling behaviour
    • Creation of custom tables
    • Adding fields to base tables
    • Datamodel updates
  • Modification Framework for application schema
    • Creation and loading of modifications
    • Limitations for sql scripts
• Data model tool
  • Setup
  • Usage
    • Main dialog
    • Troubleshooting
• Manual update of the datamodel
  • Requirements
    • Client
    • PostgreSQL
    • Python
    • PUM installation
  • Database update
    • PostgreSQL service
    • Database backup
    • Download and install current database release
    • Create empty database
    • 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