About Defining Labels

The basic Gas application contains predefined label definitions for most feature classes. The standard attribute for the label text is called Name Number.

Note:

By default labels are not visible in the drawing. Only labels that are defined as auto labels are created during the create feature operation. To insert labels, in the Maintenance workspace, click Home tab Modify panel Create Label.

Example Pipe label — The following label definition is used to display a label containing the diameter, material, and installation date. The label text is queried from the tables GA_PIPE and GA_MATERIAL_TBD.

select c.value||' '||a.DIAMETER_NOMINAL||' '||to_char(a.date_installation,'YYYY') 
from ga_pipe a, ga_material_tbd c
where a.ID_MATERIAL = c.id 
and a.FID = $id

Example Armature label — The following label definition is used to display the armature type. The label text is queried from the tables GA_ARMATURE, and GA_ARMATURE_TYPE_TBD.

select b.value from ga_armature a, ga_armature_type_tbd b where a.ID_TYPE = b.ID and a.FID = $id