Configure Lookup Table (Location Referencing)

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

arcpy.locref.ConfigureLookupTable(in_feature_class, lookup_table, field_applied_to, lookup_key, {lookup_display}, {allow_any_lookup_value})
NameExplanationData Type
in_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.

  • DO_NOT_ALLOW_ANY_VALUEAllow a value to be configured when one is not present in the table.
  • ALLOW_ANY_VALUEDon't allow a lookup display value to be configured. This is the default.
Boolean

Derived Output

NameExplanationData Type
out_feature_class

The updated route network feature class with Lookup Table configured.

Feature Layer

Code sample

ConfigureLookupTable example 1 (Python window)

Demonstrates how to use the ConfigureLookupTable tool in the Python window.

# Name: Configure_Lookup_Table.py
# Description: Configures a Lookup Table outside of database.
# Requires: ArcGIS Location Referencing

# Check out license
arcpy.CheckOutExtension("LocationReferencing")

# Tool variables
LRS_Network = r"C:\RH_Data.gdb\LRS\StateLog"
Table = r"C:\Data\cityCodeLookup.dbf"

# Execute the tool
arcpy.locref.ConfigureLookupTable(LRS_Network, Table, "CITY_CODE", "CODE", "DESC_LOOKU", "DO_NOT_ALLOW_ANY_VALUE")

# Check in license
arcpy.CheckInExtension('LocationReferencing')
ConfigureLookupTable example 2 (stand-alone script)

Demonstrates how to use the ConfigureLookupTable tool as a stand-alone Python script.

# Name: Configure_Lookup_Table.py
# Description: Configures a Lookup Table present in the same database.
# Requires: ArcGIS Location Referencing

# Import arcpy module
import arcpy

# Check out license
arcpy.CheckOutExtension("LocationReferencing")

# Set LRS network and table
LRS_Network = r"C:\RH_Data.gdb\LRS\StateLog"
Table = r"C:\RH_Data.gdb\cityCodeLookup"

# Execute the tool
arcpy.locref.ConfigureLookupTable(LRS_Network, Table, "CITY_CODE", "CODE", "DESC_LOOKU", "DO_NOT_ALLOW_ANY_VALUE")

print("Table configured successfully")

# Check in license
arcpy.CheckInExtension('LocationReferencing')

Environments

Licensing information

  • Basic: Requires ArcGIS Location Referencing
  • Standard: Requires ArcGIS Location Referencing
  • Advanced: Requires ArcGIS Location Referencing

Related topics