TWW-project properties and settings

Project Properties

There are several relevant properties in a TWW-project:

Data Sources

Main Settings:

• Transaction mode is recommended to be set on Automatic Transaction Groups

• Evaluate default values on provider side has to be checked

Relations

Relations are necessary for the Feature Attributes Windows to reference to connected tables (e.g. you can edit connected maintenance_events in Feature_Attribut window in vw_tww_reach). Where possible, value relations widgets are used instead of project relations. Value Relations are used for Value Lists, but also for organisations and for pipe_profiles.

Value Relations works perfect also with Multiedit, but can be slow if there are a lot records in the related table or list. Does not provide the ability to link a record on the map (e.g to define a manhole-catchment area-connection).

Project relations allows you to fully use the relation between two objects (parent and child(s)) and to link a record on the map. Is faster with large datasets.

Attention

With QGIS Version before 3.40: Using Multiedit with projet relations widgets encounters some bugs on QGIS side, handle with care when altering theses attributes.

Note

Project relations are not editable (yet) and are not copied when dealing with other .qgs projects.

Variables

The TWW-project uses project variables to simplify some of QGIS-functionalities. These approaches are not TWW specific and can be used also in other QGIS-projects.

In the project used variables have names that start with « tww ».

Variables for label translations

TWW uses 4 variables to translate the labeling of manholes into the desired language. Without changing the variables, the levels are labeled with « english » letters: « C » for cover level, « I » for Input level, « O » for Output level, « B » for Bottom level. In a german project, you will change these variables to « D » (Deckel), « E » (Einlauf), « A » (Auslauf) and « S » (Sohle) to get the expected labels.

Background: the database uses always the « english » letters to write the _*_label fields in vw_tww_wastewater_structure. In the label-definition of vw_tww_wastewater_structure is a « replace » formula, that change the « english » letter to the letter defined in the project variables

“concat(_label, replace(_cover_label,”C”,@tww_cover_prefix), replace(_bottom_label,”B”,@tww_bottom_prefix), replace(_input_label,”I”,@tww_input_prefix), replace(_output_label,”O”,@tww_output_prefix))”

Variables to define symbols size

Often are symbols big or small or with different labels depending on attributs (primary or secondary network, owner of the wastewater_structures). Because there are also differences in the languages (pwwf / paa / oap …), it’s one way, to define in a variable, which value has big symbols. You can use this variable in rule based symboldefinitions or in the size definition of symbols or in value definition of labels etc. in differnet layers.

Modifié dans la version 2025.0.

Note

use the tww_is_primary-fields to search or symbolize with values of field function_hierarchic.

Variables to define the scale, where the plansymbols change

In VSA-DSS are 5 plan-types defined (pipeline_registry, network_plan, 3 overview maps). Every plan has other rules for labeling and symbols. Therefore you have to define scales, where to show which plan-type. And these scales are used in reach labeldefinition, in reach symboldefinition, in manhole labeldefinition and manholesymboldefinition (and with several styles in every layer). If you work with variables, you can easy change the scales.

Example in vw_tww_reach:

Styles/Project Colors

The color for mixed_wastewater (as example) is used in vw_tww_reach symbols and labels, in vw_tww_wastewater_structures symbols and labels. To change the color (just a different shade of purple) is a lot of work and may result in errors, if you do not use project colors. In the TWW-project are project colors defined for all value of valuelist

• channel.usage(_current/planned)

• wastewater_structure.status.inoperative

• catchment_area.drainage_system(_current/planned)

• wastewater structure.structure_condition/renovation_necessity (also useable for condition_score and urgency_figure).

To change a projectcolor, go to project/properties/styles/project color, double click the color to be changed and define your color. Then click OK and do not forget to click Apply. You can export and import Projectcolors in a GPL-File.

Example in vw_tww_reach:

Map Themes

There are several map themes defined in the TWW-project as an invitation to use this great feature of QGIS to toggle between different layer-styles.

It is important to understand, what map themes do:

A map theme is a snapshot of the current map legend that records:

• the layers set as visible in the Layers panel

• and for each visible layer:

  • the reference to the style applied to the layer

  • the visible classes of the style, ie the layer checked node items in the Layers panel. This applies to symbologies other than the single symbol rendering

  • the collapsed/expanded state of the layer node(s) and the group(s) placed inside

Multisymbol Stiles

Modifié dans la version 2025.0.

Why multi-symbol-styles?

Because different representations are necessary for the important layers during GEP, a new style can be created for each symbology. However, with each new style, the entire labeling definition, the configuration of the attribute forms, and the field aliases are also copied. When translating the project file for a German or French version, only the field aliases in the active style are adjusted.

So there are many disadvantages just because we need different symbologies…

The solution: multi-symbol-styles

Create rule-based symbols and group them for different themes like network plan, overview, renovation necessity, etc.

How to do:

• Go to layer/properties/symbology and choose “Rule-based”

• Add a new rule with the + button

• Set the name of your new symbol-group as Label of the rule

• Do not enter a filter and unselect the symbol -> you have now a new “group-folder”

• Create symbols in this group-folder by using “Refine Selected Rules” or just with the + Button and move the new rule in the group-folder or copy/paste another existing rule…

Instead of changing styles, you just turn on one group and turn off the not used group. Or you work with QGIS map-themes as before with the old styles.

Layer Order

TWW uses a lot of layers. Therefore it’s a good idea to have the layer organised in a logical way.

The layer order panel enables to manually define the order of the layers displayed on the map canvas without altering it in the layer panel. It is strongly relevant when digitizing with QGIS standard tools and can be very handy in many situations.

Context-Hints for values

Ajouté dans la version 2025.0.

Place your mouse over a value in the valuelist of an attribut and you get additional info for this value if there is an additionial discription on the VSA-DSS-Objektkatalog.

Context-Hints for fields

Ajouté dans la version 2025.0.

This works just for layers based directly from the tww_od - tables, not for views.

Place your mouse over the name of the attribut and you get additional info for this field if there is an additionial discription on the VSA-DSS-Objektkatalog.