Allow selection/SQL expression for all applicable geoprocessing tools

Bud — Tue, 07 Nov 2023 16:21:35 GMT

It would be helpful if all applicable geoprocessing tools allowed for:

Using a map layer that has a selection as the Input Data, and...
Apply an SQL expression/filter to the Input Data (as part of the GP tool)

I'm aware that we can work around tools where that functionality is missing, by creating a custom model and utilizing the Selection GP tool. However, I think that functionality should exist OOTB for all applicable tools.

In other words, I would like the ability to filter all GP tool input data parameters using SQL (using functionality right in the tool).

Re: Allow selection/SQL expression for all applicable geoprocessing tools

Bud — Wed, 03 Jan 2024 05:02:33 GMT

In ArcGIS Pro, the SQL expression dialog box can be found in the following locations:
Select by attributes using the Select Layer By Attribute geoprocessing tool.
Definition Query tab on the Layer Properties dialog box.
Display filters tab in the Symbology pane.
Create reports using the Create New Reports pane.
Export tables using the Export Table geoprocessing tool.
Export features using the Export Features geoprocessing tool.
Use the Calculate Field geoprocessing tool to create an expression to perform simple or complex calculations on field values.
Use Select to query data for further analysis.
Use the Make Query Table geoprocessing tool to create a layer or table view.
Use the Make Feature Layer geoprocessing tool to create a feature layer.
Create a view in a database or geodatabase using the Create Database View geoprocessing tool.
Use the Append geoprocessing tool to append multiple input datasets into a target dataset.
Use ProSDK Core.Data.QueryDef.

idea Allow selection/SQL expression for all applicable geoprocessing tools in ArcGIS Pro Ideas

Allow selection/SQL expression for all applicable geoprocessing tools

Re: Allow selection/SQL expression for all applicable geoprocessing tools