Skip To Content

Extract Values To Table

Available with Geostatistical Analyst license.

Summary

Extracts cell values from a set of rasters to a table, based on a point or polygon feature class.

Usage

  • This tool is primarily designed to analyze the output from the Gaussian Geostatistical Simulations tool.

  • All the rasters must have the same spatial reference and cell size.

  • If a point feature class is used, the output table has a record for each point and each raster that has data. Polygonal data will be treated as point data. The cell center of the input rasters will determine the number of points and will also be used to decide whether the cell is contained within the polygon or not.

  • Values outside the raster's extent will be ignored.

  • Multipart feature classes are not supported.

  • In the case of coincident points, the last one encountered will be used and the rest will be ignored. In the same vane, if overlapping polygons are encountered only one of the intersected features will be processed.

  • If Spatial Analyst is available, the Sample tool can also be used. However, the output table needs to be transposed if the values are to be graphed.

Syntax

ExtractValuesToTable_ga (in_features, in_rasters, out_table, {out_raster_names_table}, {add_warning_field})
ParameterExplanationData Type
in_features

The points or polygon features to be created.

Feature Layer
in_rasters
[in_raster,...]

The rasters must all have the same extent, coordinate system, and cell size.

Raster Layer; Mosaic Layer
out_table

The output table contains a record for each point and each raster that has data. If polygon features are input, they are converted to points that coincide with the raster cell centers.

Table
out_raster_names_table
(Optional)

Saves the names of the Input rasters to disc.

Table
add_warning_field
(Optional)

Records if input features are partially or completely covered by the Input rasters.

  • ADD_WARNING_FIELDWarning field is added to the output table and populated with a P when a feature is partially covered by raster values.
  • DO_NOT_ADD_WARNING_FIELDWarning field is not added to the output table.
Boolean

Code sample

ExtractValuesToTable example 1 (Python window)

Extract the cell values from a raster to a table, based on a point feature class.

import arcpy
from arcpy import env
env.workspace = "C:/gapyexamples/data"
arcpy.ExtractValuesToTable_ga("C:/gapyexamples/data/ca_ozone_pts.shp",
                              "C:/gapyexamples/data/inraster", 
                              "C:/gapyexamples/output/outEVFR.dbf", "", "")
ExtractValuesToTable example 2 (stand-alone script)

Extract the cell values from a raster to a table, based on a point feature class.

# Name: ExtractValuesToTable_Example_02.py
# Description: Extract the cell values from a raster, based on 
#              a point feature class, to a table.
# Requirements: Geostatistical Analyst Extension

# Import system modules
import arcpy
from arcpy import env

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

# Set local variables
inPoints = "C:/gapyexamples/data/ca_ozone_pts.shp"
raster = "C:/gapyexamples/data/inraster"
outTable = "C:/gapyexamples/output/outEVFR.dbf"

# Execute ExtractValuesToTable
arcpy.ExtractValuesToTable_ga(inPoints, raster, outTable, "", "")

Licensing information

  • ArcGIS Desktop Basic: Requires Geostatistical Analyst
  • ArcGIS Desktop Standard: Requires Geostatistical Analyst
  • ArcGIS Desktop Advanced: Requires Geostatistical Analyst

Related topics