Table Select (Analysis) |
|
Release 9.2
Last modified January 13, 2009 |
![]() ![]() ![]() Print all topics in : "Tools" |
Extracts selected table records or features from an input table or table view and stores them in a new output table.
Usage tips
The input can be an INFO table, a dBASE table, a geodatabase table, a VPF table, a feature class, or a table view.
If an SQL expression is used but returns nothing, the output table will be empty.
For details on the syntax for the Expression parameter, see Building an SQL Expression or SQL Reference.
The map layers in your Table of Contents may be used to define Output Table.
When using layers, only the currently selected features are used in the expression calculation.
The following environment settings affect this tool: Coordinate system, Extent , XY Tolerance, Z Tolerance, M Tolerance, XY Resolution, Z Resolution, M Resolution, Output XY domain, Output Z domain, Output M domain, Output has M values, Output has Z values, Default Z value, Configuration keyword, Output Spatial Grid.
Command line syntax
An overview of the Command Line window
TableSelect_analysis <in_table> <out_table> {where_clause}
Parameter | Explanation | Data Type |
<in_table> |
The input table can be an INFO table, a dBASE table, a geodatabase table, a feature class, or a table view. |
Table View | Raster Layer |
<out_table> |
The output table to be created. The output table can be a dBASE table or a geodatabase table. |
Table |
{where_clause} |
An SQL expression used to select a subset of records. The syntax for the expression differs slightly depending on the data source. For example, if you're querying file or ArcSDE geodatabases, dBASE or INFO tables, enclose field names in double quotes: "MY_FIELD" If you're querying personal geodatabases, enclose fields in square brackets: [MY_FIELD]. For more information on SQL syntax and how it differs between data sources, see SQL Reference. |
SQL Expression |
tableselect_analysis d:\workspace\wells.shp d:\workspace\wells_Gas.dbf "WELL_TYP" = 'GAS'
Scripting syntax
About getting started with writing geoprocessing scripts
TableSelect_analysis (in_table, out_table, where_clause)
Parameter | Explanation | Data Type |
in_table (Required) |
The input table can be an INFO table, a dBASE table, a geodatabase table, a feature class, or a table view. |
Table View | Raster Layer |
out_table (Required) |
The output table to be created. The output table can be a dBASE table or a geodatabase table. |
Table |
where_clause (Optional) |
An SQL expression used to select a subset of records. The syntax for the expression differs slightly depending on the data source. For example, if you're querying file or ArcSDE geodatabases, dBASE or INFO tables, enclose field names in double quotes: "MY_FIELD" If you're querying personal geodatabases, enclose fields in square brackets: [MY_FIELD]. For more information on SQL syntax and how it differs between data sources, see SQL Reference. |
SQL Expression |
import arcgisscripting gp = arcgisscripting.create() gp.workspace = "h:/workspace" gp.tableselect("nfroads.shp", "paved.dbf", '"ROAD_CLASS" = \'PAVED\'')