HOW TO

Label highways with a shield marker containing the highway number in ArcGIS Pro

Last Published: July 21, 2023

Summary

ArcGIS Pro allows labeling highways with a shield marker symbol containing a highway number by using Structured Query Language (SQL) in the Label Class pane.

In this example, the ROADS.shp file is used. This file can be downloaded from the Related Information section.

Procedure

The following steps describe how to label highways with a shield marker containing the highway number in ArcGIS Pro:

  1. Download Road.zip and extract the file to a folder on the computer.
  2. In ArcGIS Pro, open a new blank project.
  3. Add ROADS.shp using the Add Data button.
  4. In the Contents pane, right-click the ROADS layer and select Attribute Table. View the ADMN_CLASS field which contains:
    • Interstate
    • US Highway
    • State Highway
Note:
The RTE_NUM1 field contains the route number for each highway. Close the attribute table after viewing these items.
  1. Set the symbol color for each highway. 
    1. In the Appearance tab, click the Symbology icon in the Drawing group.
    2. In the Symbology pane, select Unique Values from the drop-down list.
    3. For Field 1, select ADMN_CLASS from the drop-down list.
    4. Click each line symbol and set the symbol color for Interstate to red, State Highway to green, and US Highway to blue.
Set the symbol color for Interstate to red, State Highway to green, and US Highway to blue.
  1. Create a new label class in the Label Class section.
    1. Click the Labeling tab. In the Class drop-down list, select Create label class to create a new label class.
Create a new label class.
  1. In the Create new label class dialog box, name the new label class as 'Interstate' and click OK. Ensure the Label Feature In This Class check box for 'Interstate' class is checked.
The Create new label class dialog box.
Make sure the Label Feature In This Class box is checked.
  1. Add an SQL Query expression.
    1. In the Label Class section, click SQL Query SQL Query next to the Class field.
    2. In the Label Class pane, click Clause > Add Clause and insert the following query:
Clause mode:  Where 'ADMN_CLASS' 'is equal to' 'Interstate'
or
SQL mode:  "ADMN_CLASS" = 'Interstate'
  1. Click Add and then click Apply.
Add query in the SQL Query.
  1. Add a label expression for the label.
    1. In the Label Class pane, click Label expression Label expression.
    2. Select RTE_NUM1 from the Fields field.
    3. Click Verify and then click Apply.
Label expression.
  1. In the Text Symbol group, expand the Text Symbol Style gallery. Under Shield, click Shield 1.
The Text Symbol Style gallery
  1. Return to the Labeling tab and repeat steps 6 through 9 for 'State Highway' and 'US Highway' classes.    
    1. Use the following SQL expression for each class respectively:
      • For State Highway:
Clause mode:  Where 'ADMN_CLASS' 'is equal to' 'State Highway'
or
SQL mode: "ADMN_CLASS" = 'State Highway'
  • For US Highway:
Clause mode: Where 'ADMN_CLASS' 'is equal to' 'US Highway'
or
SQL mode: "ADMN_CLASS" = 'US Highway'
  1. For Text Symbol in step 9, select the desired style from the Text Symbol Style gallery under the Shield section for each class.
  1. In the Label Class pane, remove the default class, Class 1, by clicking the menu button Menu and select Remove label class.
Remove the default class, Class 1
  1. Click the Label icon in the Layer group to view the three styles of highway shield symbols with the correct route numbers on the map.
Click the Label icon in the Layer group.
The three styles of highway shield symbols with the correct route numbers on the map.
Note:
If the symbols are rotated, change the Label Placement setting to Shield.
Label placement.

Article ID:000021628

Software:
  • ArcGIS Pro

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options