Customization of Font and Formatting for Standard Manholes

The manhole labeling  AWKT_SCHACHT consists by default of designation, cover height, invert height, as well as inlet and outlet heights.

This labeling is applied exclusively to subtype 1 (standard manhole) of the table AWK_ABWASSERKNOTEN.

Problem

In some cases, the formatting of the label is not displayed correctly. This is usually related to the use of ArcGIS text formatting tags, which are also used in GEONIS. By default, the following formula is used in the GEONIS data model to create the manhole labels:

%If([BEZEICHNUNG]<>%Null();<FNT name="Arial Bold Italic" size="11"><UND>[BEZEICHNUNG]</UND></FNT>;)

This formula is stored in the GEONIS Administrator under object relations with the name Kbezeichnung.

Cause

Depending on the operating system language settings or the installed fonts, ArcMap does not recognize the specified font. For example, the font "Arial Bold Italic" is not recognized if the corresponding German font "Arial Fett Kursiv" is present, and instead, the default font "Arial" is used.

Solution

If the labeling is displayed incorrectly or a general adjustment of the formatting is desired, it is recommended to configure the formula independent of the language settings. For this, the font "Arial" can be used:

%If([BEZEICHNUNG]<>%Null();<FNT name="Arial" size="11"><UND>[BEZEICHNUNG]</UND></FNT>;)

If the manhole number should be further formatted (e.g., bold and italic), this can be done with the additional tags <ITA> and <BOL>:

%If([BEZEICHNUNG]<>%Null();<FNT name="Arial" size="11"><BOL><ITA><UND>[BEZEICHNUNG]</UND></ITA></BOL></FNT>;)

After adjusting the formula, all newly created labels will receive the updated formatting. Existing labels can be updated accordingly using the validation Update Labels: Standard Manhole:

Interfaces

Starting with GEONIS Sewer Version 2023.0.8, no adjustments to the interface (FME Workspace) are required.

However, in older FME exports to Interlis, formatting tags are removed differently. If there have been customizations made to the label font settings, it must be ensured in the workspace that the tags are properly removed. This can be done by configuring the transformers WPText_Textinhalt_StringReplacer1 and WPText_Textinhalt_StringReplacer2 as follows:

Text To Replace: <FNT name="Arial[^"]*"[^>]*>[\s\S]*?<UND>

Text To Replace: </UND>[\s\S]*?</FNT>

Additional Notes

VertiGIS deliberately refrains from adjusting the formula in the standard because this could have unintended effects on the display for customers. Furthermore, we recommend making adjustments only if the font and formatting for manholes do not meet expectations.