Skip to main content

Modify Route ID Padding (Location Referencing Tools)

Summary

Modifies the padding, null, and length properties for fields that are part of a multifield route ID.

In the image example below, a multifield route ID is configured with four fields: RouteType, CityCode, RouteNumber, and RampNumber. Sample padding, null settings, and lookup table for the four fields are as follows:

  • RouteType is a text field with a length of 2 and has a coded value domain configured. The maximum number of characters in the domain values is two. However, some routes may only have a domain value with one character, and a zero (0) is used as a padding character to the right.

  • CityCode is a text field with a length of 4 and has a lookup table configured to allow searching for the key value using a display field. Since all the CityCode values have a length of 4 in the lookup table, no padding is needed for this field.

  • RouteNumber is a short field type. This field has values ranging from 0 to 99999. A hyphen is used as a padding character to the left and right.

  • RampNumber is a text field with a length of 7. Some routes do not have all the 7 characters entered for this field, while others do not have a value for this field and must be left blank; therefore, no padding is needed.

Learn more about configuring and modifying route ID padding settings

Illustration

Route ID padding diagram

Usage

  • Each field that makes up a multifield route ID supports the following:

    • Can have the maximum length shortened
    • Can be of variable or fixed length
    • Can have padding characters added to the left, right, or both left and right sides
    • Can have padding added when the field has a null value

  • The route ID for each record will be stored with padding and null values included. Each field that makes up a multifield route ID will be stored without any padding character.

  • Padding and null settings can be changed once the network is created. Any routes loaded and created before changing the settings remain the same. Any routes loaded and created after changing the settings will use the updated settings.

  • Changing the Length value only affects the maximum number of characters expected by ArcGIS Roads and Highways tools for each field. The sum of the lengths of the fields that make up the multifield route ID must not exceed the length of the route ID field in the geodatabase.

  • The Allow Null Values padding option must be checked if the Pad if Null padding option is checked.

  • If you allow null values in a field, all fields to the right of that field must also allow null values.

  • A number sign (#) is not supported as a padding character.

Parameters

Label Explanation Data type

LRS Network Feature Class

The input multifield route ID network layer that contains fields for padding, null, and length values that need to be modified.

Feature Layer

Route ID Padding

A table of values that specifies the field that will be modified and its corresponding padding, null, and length values.

Value table columns:

  • Field—The field to be modified.

  • Length—The length value of the field to be modified. The field length should be between 1 and the length of the database field.

  • Variable Length—Specifies if the Length value is a variable value or a fixed value.

  • Enable Padding—Specifies if the field supports padding.

  • Padding Character—The padding character for the field. The default is a space.

  • Padding Location—Specifies where the padding should be applied to the field value.

    • Left—The padding characters will be added to the left of the value in the field. This is the default.

    • Right—The padding characters will be added to the right of the value in the field.

    • Left and Right—The padding characters will be added to the left and right of the value in the field.

  • Pad if Null—Specifies if the padding characters are added when the field has a null value.

  • Allow Null Values—Specifies if the field supports null values.

Value Table

Derived output

Label Explanation Data type

Output Network Feature Class

The updated network feature layer.

Feature Layer

Environments

Current Workspace

Licensing information

  • Basic: Requires ArcGIS Location Referencing (ArcGIS Pipeline Referencing or ArcGIS Roads and Highways)
  • Standard: Requires ArcGIS Location Referencing (ArcGIS Pipeline Referencing or ArcGIS Roads and Highways)
  • Advanced: Requires ArcGIS Location Referencing (ArcGIS Pipeline Referencing or ArcGIS Roads and Highways)