TEKSI wastewater

TEKSI wastewater and general wastewater management plan (GWMP) is an open source wastewater management module for QGIS based on SIA 405 Wastewater (pipe cadastre) and VSA-DSS 2020 (GWMP) and developed closely to the QGIS application.

Contents

• 1. TEKSI wastewater (TWW)
  • 1.1. Main features
  • 1.2. More to come
• 2. TWW Installation Guide
  • 2.1. Requirements
    • 2.1.1. Provider Side
    • 2.1.2. Client Side
    • 2.1.3. PostgreSQL Server side :
  • 2.2. Setup database server
    • 2.2.1. Required Software
      • 2.2.1.1. Server installation
  • 2.3. Database initialization
    • 2.3.1. Process
      • 2.3.1.1. Create minimal roles and access
      • 2.3.1.2. Restore data model with demodata
      • 2.3.1.3. Empty data model
      • 2.3.1.4. Generate the data model under Linux
  • 2.4. Setup workstation
    • 2.4.1. Database configuration
      • 2.4.1.1. Windows pg_service
      • 2.4.1.2. Linux/macOS pg_service
      • 2.4.1.3. All systems
    • 2.4.2. Install QGIS
    • 2.4.3. Install TWW plugin
    • 2.4.4. Install the demo data
    • 2.4.5. Install the demo project
    • 2.4.6. If you are a data owner: Add your own OID to the project
    • 2.4.7. Working with more than one database
• 3. TWW User Guide
  • 3.1. Overview of TWW
    • 3.1.1. Introduction and Overview
    • 3.1.2. Layers explanation
      • 3.1.2.1. Main layers
      • 3.1.2.2. Wastewater Structures
      • 3.1.2.3. Maintenance events tww_app.vw_tww_maintenance
      • 3.1.2.4. Value Lists tww_vl.*
      • 3.1.2.5. Hydraulic
      • 3.1.2.6. Topology
      • 3.1.2.7. Catchment tww_od.catchment_area
    • 3.1.3. Naming conventions
      • 3.1.3.1. Schemas in the TWW-Database
      • 3.1.3.2. Layer names
      • 3.1.3.3. Attribute names
    • 3.1.4. TWW-project properties and settings
      • 3.1.4.1. Project Properties
      • 3.1.4.2. Map Themes
      • 3.1.4.3. Layer Order
  • 3.2. Digitizing in TWW
    • 3.2.1. Data entry
      • 3.2.1.1. The TWW wizard
      • 3.2.1.2. QGIS standard tools
    • 3.2.2. Digitizing Wastewater Structures
      • 3.2.2.1. General
      • 3.2.2.2. Digitizing
      • 3.2.2.3. Further attributes and classes
      • 3.2.2.4. Geometry synchronization
    • 3.2.3. Digitizing detailed geometry
      • 3.2.3.1. General
      • 3.2.3.2. Digitizing tool
    • 3.2.4. Digitizing Detailed Geometry as Drainage Channel
      • 3.2.4.1. General
      • 3.2.4.2. Digitizing tool
    • 3.2.5. Digitizing Channels
      • 3.2.5.1. General
      • 3.2.5.2. Digitizing
      • 3.2.5.3. Further attributes and classes
      • 3.2.5.4. Geometry synchronization
    • 3.2.6. Deleting objects
      • 3.2.6.1. Delete Reach
      • 3.2.6.2. Delete Manhole or other Wastewater Structure
      • 3.2.6.3. Delete Wastewater Structure, but keep the wastewater_node and the connections to the wastewater_node
      • 3.2.6.4. Delete Cover
      • 3.2.6.5. Delete Structure parts
      • 3.2.6.6. Delete detailed geometries
    • 3.2.7. Digitizing Catchment Areas
      • 3.2.7.1. General
      • 3.2.7.2. Digitizing
      • 3.2.7.3. Editing
      • 3.2.7.4. Split Areas
      • 3.2.7.5. Merge Areas
      • 3.2.7.6. Connect Catchment area to Wastewater Network Nodes
      • 3.2.7.7. The ‘duplicate coord’-error
    • 3.2.8. Importing data
      • 3.2.8.1. General
      • 3.2.8.2. Example Importing manholes from a TXT-File:
      • 3.2.8.3. Example Importing manholes with attributes:
  • 3.3. Editing in TWW
    • 3.3.1. Editing of existing data
      • 3.3.1.1. Demo project (chapter / pictures not adjusted to TWW)
      • 3.3.1.2. Layers
      • 3.3.1.3. Changing attributes of point elements (manholes / special structures)
      • 3.3.1.4. Changing attributes of linear elements (channels)
      • 3.3.1.5. Change reach direction
      • 3.3.1.6. Snap reach geometry
      • 3.3.1.7. Working with codes of value list
      • 3.3.1.8. An other way to choose an object
      • 3.3.1.9. Adding additional covers and nodes to an existing wastewater structure
      • 3.3.1.10. Adding a wastewater node to an existing reach
      • 3.3.1.11. Change multiple records at once
      • 3.3.1.12. Saving changes
      • 3.3.1.13. Changing Wastewater Structure Type (ws_type)
      • 3.3.1.14. Split a reach (channel) into different reaches
    • 3.3.2. Moving Wastewater Structures with Reaches, Covers and Nodes
      • 3.3.2.1. General
      • 3.3.2.2. Moving a manhole
      • 3.3.2.3. Moving a cover / a node
      • 3.3.2.4. Moving a reachpoint
      • 3.3.2.5. Video Tutorial (outdated)
    • 3.3.3. Adding or Editing of Maintenance Events
      • 3.3.3.1. General
      • 3.3.3.2. Adding a new Maintenance Event
      • 3.3.3.3. Link an existing Maintenance Event
      • 3.3.3.4. Unlink Maintenance Events
      • 3.3.3.5. Editing
      • 3.3.3.6. Mark as outdated
      • 3.3.3.7. Multi Edit
    • 3.3.4. Connect Wastewater Network Elements
      • 3.3.4.1. General
      • 3.3.4.2. How to connect reaches to nodes or reaches to reaches
      • 3.3.4.3. Video Tutorial (not adapted for TWW)
      • 3.3.4.4. How to delete a connection
  • 3.4. Length profiles
  • 3.5. Network following tools
    • 3.5.1. Refresh network topology
    • 3.5.2. Upstream
    • 3.5.3. Downstream
    • 3.5.4. Sum up upstream
    • 3.5.5. Flow times downstream
  • 3.6. Plan plotting
    • 3.6.1. General
  • 3.7. History in TWW
    • 3.7.1. History viewer
      • 3.7.1.1. Plugin configuration
      • 3.7.1.2. Database configuration
      • 3.7.1.3. Usage
      • 3.7.1.4. Replay function
  • 3.8. How To
    • 3.8.1. Setting default values
    • 3.8.2. How vw_tww_wastewater_structure labels work
    • 3.8.3. How to translate a label prefix (C, B, I, O)
    • 3.8.4. How to check if triggers are active
    • 3.8.5. How to run symbology functions manually
    • 3.8.6. Manual Label-positioning for different scales
    • 3.8.7. How to import existing label-positions
    • 3.8.8. Collecting a hydr_geometry (corresponds to a basin geometry in Mike+)
    • 3.8.9. Hydraulic modeling of an overflow (prank weir / leapingweir / pump)
    • 3.8.10. Overflow characteristic
    • 3.8.11. Further informations
• 4. Admin Guide
  • 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
• 5. Official TWW extensions
  • 5.1. Initialising Database extensions
    • 5.1.1. create an empty datamodel with an extension
    • 5.1.2. Generate the data model under Linux
  • 5.2. Extension AG-64/AG-96
    • 5.2.1. Plugin and Project Setup
      • 5.2.1.1. Enable AG-64/AG-96 Interlis Imports and Exports
      • 5.2.1.2. Handling of last modification
      • 5.2.1.3. Project setup
    • 5.2.2. Data collection policy
      • 5.2.2.1. Mapping
      • 5.2.2.2. Infrastrukturknoten/GEPKnoten
      • 5.2.2.3. Infrastrukturhaltung/GEPHaltung
      • 5.2.2.4. Ueberlauf_Foerderaggregat
      • 5.2.2.5. GEPMassnahme
      • 5.2.2.6. Bautenausserhalbbaugebiet
      • 5.2.2.7. SBW_Einzugsgebiet
      • 5.2.2.8. VersickerungsbereichAG
• 6. SWMM Data Exchange
  • 6.1. Storm Water Management Model (SWMM)
  • 6.2. Prepare Data
    • 6.2.1. Coefficient of friction
      • 6.2.1.1. Populate default coefficient of friction
  • 6.3. Generate SWMM File
    • 6.3.1. SWMM Create Input
      • 6.3.1.1. TWW plugin
    • 6.3.2. Selection
    • 6.3.3. Change default export parameters
  • 6.4. Check SWMM File
    • 6.4.1. Common import errors
      • 6.4.1.1. Missing status or _function_hierarchic (wn_function_hierarchic)
      • 6.4.1.2. Catchment area connected to secondary wastewater structure
      • 6.4.1.3. Missing discharge coefficients
      • 6.4.1.4. Missing population densities
    • 6.4.2. Subcatchments and rain Gauges
  • 6.5. Run SWMM Simulation
    • 6.5.1. Run a simulation from SWMM interface
    • 6.5.2. Run a simulation with command line
    • 6.5.3. Run a simulation with TWW-SWMM
    • 6.5.4. Common running errors
  • 6.6. Import results
    • 6.6.1. SWMM Import Results
      • 6.6.1.1. Measurement tables
      • 6.6.1.2. Launch import
    • 6.6.2. SWMM Extract Results
  • 6.7. Mapping
    • 6.7.1. Results are not imported in TWW
    • 6.7.2. Results are imported in TWW
      • 6.7.2.1. Show the indicators evolving along time
  • 6.8. For developpers and advanced users
• 7. Translation

Indices and tables

• Index

• Search Page