Skip to main content

Configure Lookup Table (Location Referencing Tools)

Summary

Configures a lookup table for one or more fields used in a multifield route ID.

This tool can be run after Create LRS Network From Existing Dataset or Modify LRS Network for a multifield route ID.

Learn more about creating the LRS, networks, and events

A lookup table is an alternative to using coded value domains when a field that makes up a multifield route ID has several hundred or thousands of potential values, for example, a list of street names or a Geographic Names Information System (GNIS) code. The lookup table is used primarily when creating a route.

Learn more about configuring a lookup table

Usage

  • The lookup table can be configured with both the Lookup Key and Lookup Display parameter fields, allowing you to search for a key value using its display value:

    • The Lookup Key field is the value that will be saved for the field in the multifield route ID.

    • The Lookup Display field is the value that appears in the text box for the multifield route ID.

  • The Field Applied To parameter drop-down menu will display only the fields that make up a multifield route ID for the chosen LRS Network.

    Note:

    The Lookup Key and Lookup Display fields can be the same or different fields in the lookup table.

    The Lookup Key parameter drop-down menu will display only the fields from the lookup table that have the same field type and a length less than or equal to the Field Applied To parameter value.

  • The Lookup Display parameter value is optional. If you want to allow a value that is not in the lookup table, you cannot configure the Lookup Display parameter.

  • This tool only reads the lookup table and will not add records to it. If the desired value is not present, you can add it to the lookup table using this tool.

  • If padding is configured for the field, it will be added if the Lookup Key field value is shorter than the field length.

  • If the lookup table is in an enterprise geodatabase, it must be nonversioned.

Parameters

Label Explanation Data type

LRS Network Feature Class

The input LRS Network feature class in which the lookup table will be configured. The network must have a multifield route ID.

Feature Layer

Lookup Table

A table that contains a list of street names and their corresponding GNIS codes. It can be a stand-alone table or reside in an enterprise geodatabase.

Table View

Field Applied To

The route ID field in the LRS Network in which the lookup table will be configured.

String

Lookup Key

The key field in the lookup table.

String

Lookup Display

(Optional)

The lookup table description field. This field appears in the text box for the multifield route ID.

String

Allow any lookup value

(Optional)

Specifies whether a value that is not in the lookup table can be added. The Lookup Display parameter cannot be configured when this option is checked.

  • Checked—Allow a lookup display value to be configured.

  • Unchecked—Don't allow a value to be configured when one is not present in the table. This is the default.

Boolean

Derived output

Label Explanation Data type

Output Network Feature Class

The updated route network feature class with a lookup table configured.

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)