Skip To Content

Configure Lookup Table

Mit der Location Referencing-Lizenz verfügbar.

Zusammenfassung

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. For more information, see Create 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 in the Create Route editing activity.

Verwendung

  • The lookup table can be configured with both the Lookup Key and Lookup Display 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 drop-down menu will display only those fields that are part of a multifield route ID for the chosen LRS Network Feature Class.

    Hinweis:

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

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

Syntax

ConfigureLookupTable(in_feature_class, lookup_table, field_applied_to, lookup_key, {lookup_display}, {allow_any_lookup_value})
ParameterErklärungDatentyp
in_feature_class

The input LRS Network feature class in which to configure the lookup table. 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. The table can be stand-alone or reside in an SDE.

Table View
field_applied_to

The route ID field in the LRS Network in which the lookup_tableneeds to 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 if 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

Abgeleitete Ausgabe

NameErklärungDatentyp
out_feature_class

The updated route network feature class with Lookup Table configured.

Feature Layer

Codebeispiel

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: Location Referencing license

# tool variables
LRS_Network = r"C:\RH_Data.gdb\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")
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 same database
# Requires: Location Referencing license

# Check out any necessary license
import arcpy
arcpy.CheckOutExtension("LocationReferencing")

# Set LRS network and table
LRS_Network = r"C:\RH_Data.gdb\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")

Lizenzinformationen

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

Verwandte Themen