Configure Lookup Table (Location Referencing)

ArcGIS Pro 3.4 | | Help archive

Available with Location Referencing license.

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.

Usage

  • The lookup table can be configured with both the Lookup Key and Lookup Display parameter fields, allowing the user 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 those fields that are part of a multifield route ID for the chosen LRS Network Feature Class.

    Note:

    The Lookup Key Field parameter value will be saved in the geodatabase as both a field and as part of the multifield route ID.

    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 those fields from the lookup table that have the same field type and a length less than or equal to the route field selected in the Field Applied To parameter drop-down menu.

  • 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.

  • Location Referencing only reads the lookup table; it will not add records to the table. 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.

  • Only one lookup table can be configured per LRS Network.

  • If the lookup table is in a multiuser geodatabase, the table should be nonversioned.

Parameters

LabelExplanationData 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 SDE.

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 value to be configured when one is not present in the table.
  • Unchecked—Don't allow a lookup display value to be configured. This is the default.
Boolean

Derived Output

LabelExplanationData Type
Output Network Feature Class

The updated route network feature class with Lookup Table configured.

Feature Layer

Environments

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)

Related topics