Lookup—Help | ArcGIS for Desktop

Available with 3D Analyst license.

Summary
Illustration
Usage
Syntax
Code sample
Environments
Licensing information

Summary

Creates a new raster by looking up values found in another field in the table of the input raster.

Illustration

Lookup_3d (InRas1, "Category", OutRas)

Usage

Both numeric (integer or floating point) or string field types are supported. If the field is integer or string, the output will be an integer raster; otherwise, the output raster will be a floating-point raster.
If the lookup field is of integer type, the values of that field will be written to the output raster attribute table as Value. Other items in the input raster attribute table will not be transferred to the output raster attribute table.
For example, an attribute table of input raster with numeric field Attr1
```
    Value   Count   Attr1
    1       294     1
    2       345     8
    3       654     3
```
Output attribute table from Lookup on Attr1 field
```
    Value   Count
    1       294
    3       654
    8       345
```
If the lookup field is a string type, the lookup field will appear in the output raster attribute table, and the value field will be the same numeric type as for input raster. Any other items in the input raster's attribute table will not be transferred to the output raster's attribute table.
For example, consider the attribute table of an input raster with string field Text1
```
    Value   Count   Attr1   Text1
    1        294    1       A
    2       6218    8       B
    3         28    3
    4       3603    9       3
```
The attribute table of the output raster from running Lookup on the Text1 field would be
```
    Value   Count   Text1
    1        294    A
    2       6218    B
    3         28    
    4       3603    3
```

Syntax

Lookup_3d (in_raster, lookup_field, out_raster)

Parameter	Explanation	Data Type
in_raster	The input raster that contains a field from which to create a new raster.	Raster Layer
lookup_field	Field containing the desired values for the new raster. It can be a numeric or string type.	Field
out_raster	The output raster whose values are determined by the specified field of the input raster.	Raster Dataset

Code sample

Lookup example 1 (Python window)

This example creates a new raster determined by the specified field of the input raster.

import arcpy
from arcpy import env  
env.workspace = "C:/data"
arcpy.Lookup_3d("mycity", "land_code", "C:/output/mylandcode.img")

Lookup example 2 (stand-alone script)

This example creates a new raster determined by the specified field of the input raster.

# Name: Lookup_3d_Ex_02.py
# Description: Creates a new raster by looking up values found in another 
#     field in the table of the input raster.
# Requirements: 3D Analyst Extension

# Import system modules
import arcpy
from arcpy import env

# Set environment settings
env.workspace = "C:/data"

# Set local variables
inRaster = "mycity"
lookupField = "land_code"
outRaster = "C:/output/mylandcode"

# Check out the ArcGIS 3D Analyst extension license
arcpy.CheckOutExtension("3D")

# Execute Lookup
arcpy.Lookup_3d(inRaster, lookupField, outRaster)

Environments

Licensing information

ArcGIS for Desktop Basic: Requires 3D Analyst or Spatial Analyst
ArcGIS for Desktop Standard: Requires 3D Analyst or Spatial Analyst
ArcGIS for Desktop Advanced: Requires 3D Analyst or Spatial Analyst

ArcMap

Lookup