Lookup (3D Analyst Tools)

Summary

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

Illustration

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
```

Label	Explanation	Data type
Input 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
Output raster	The output raster whose values are determined by the specified field of the input raster.	Raster Dataset

Label

Explanation

Data type

Input 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

Output raster

The output raster whose values are determined by the specified field of the input raster.

Raster Dataset

arcpy.3d.Lookup(in_raster, lookup_field, out_raster)

Name	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

Name

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
arcpy.env.workspace = "C:/data"
arcpy.ddd.Lookup("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"

# Run Lookup
arcpy.ddd.Lookup(inRaster, lookupField, outRaster)

Environments

Auto Commit, Cell Size, Cell Size Projection Method, Compression, Current Workspace, Extent, Geographic Transformations, Mask, Output CONFIG Keyword, Output Coordinate System, Scratch Workspace, Snap Raster, Tile Size

Licensing information

Basic: Requires 3D Analyst or Spatial Analyst
Standard: Requires 3D Analyst or Spatial Analyst
Advanced: Requires 3D Analyst or Spatial Analyst