selectAndExport

Select and Export

Running programmatically

Exports the features of a dataset to a new layer based on an attribute query.

Inputs:

A layer
The WHERE clause of an SQL Expression. The expression builder can be used if executed from the ET GeoWizards interface. For example if the WHERE clause is " ACRES < 1.5", the full SQL expression will be "SELECT * FROM FullPathToTheLayer WHERE ACRES < 1.5"

Outputs:

New layer
- The output layer will contain only the selected features of the input dataset
- The attributes of the input data set are preserved.

Running Programmatically

Parameters

Expression	Explanation
Function Name	SelectAndExport
<input dataset>	A String representing the input layer.
<output dataset>	A String - the full name of the output layer.
<SQL Expression>	A String representing the selection expression. Example: Shape_Area < 200 AND Name = 'a'

Running the function

ETGWPath used in the table below is the full path to ETGWRun.exe (E.G. "C:\Program Files\ETSpatial Techniques\ETGeo Wizards\ETGWRun.exe")

Language	Syntax
Python	subprocess.call([ETGWPath, "SelectAndExport", "input dataset", "output dataset", "SQL Expression"])
.NET using ETGWRun.exe	StartInfo.FileName = ETGWPath StartInfo.Arguments = "SelectAndExport" "input dataset" "output dataset" "SQL Expression"
.NET using ETGWOutX.dll	SelectAndExport(input dataset, output dataset, SQL Expression)
ArcPy	arcpy.SelectAndExport(input dataset, output dataset, "SQL Expression")

Notes:

<> - required parameter
{} - optional parameter
See examples for Python , .NET or ArcPy
The argument separator for StartInfo.Arguments is space. If a string might contain a space, you need to double quote it.