topic Re: How to Stop "SelectLayerByAttribute_management" creating temporary tables, while running script in ArcPro in Python Questions

How to Stop "SelectLayerByAttribute_management" creating temporary tables, while running script in ArcPro

EdX1 — Mon, 15 Apr 2024 06:08:34 GMT

Hello,

I am running a python script to update fields in a table based on polygons selected within ArcPro, via the python window in ArcPro.

At 3 parts in the script I use "SelectLayerByAttribute_management" to make selections from the table to get specific items from that table using a SQL query.

Each time I call "SelectLayerByAttribute_management" a temporary view is created within the contents panel which persist after the script is completed.

How can I avoid these from being created? I wish to avoid using arcpy.Delete_management("TEST_FILE_View1") to remove the tables because this adds an extra minute or two to the processing time which is not feasible given this task requires this process to be run many times over. What alternative options do I have?

Thanks.

Re: How to Stop "SelectLayerByAttribute_management" creating temporary tables, while running script in ArcPro

DanPatterson — Mon, 15 Apr 2024 09:15:54 GMT

That tool doesn't support geoprocessing environment settings, but try

Project, Options, Geoprocessing ... Add outputs to an open map

Is it toggle on?, if so, try toggling it off.

'memory' workspace is another option to try

Write geoprocessing output to memory—ArcGIS Pro | Documentation

or at the end of your script, you can add another select layer by attribute with the clear selection option

Delete is generally the recommended approach, but it shouldn't take that long, unless you are working with non-locally stored data

Re: How to Stop "SelectLayerByAttribute_management" creating temporary tables, while running script in ArcPro

JoshuaBixby — Mon, 15 Apr 2024 14:07:49 GMT

Providing representative code would be helpful because it is likely how you are calling the tool that is causing the issue. From Select Layer By Attribute (Data Management)—ArcGIS Pro | Documentation

If the input is a feature class or dataset path, this tool will create and return a new layer with the result of the tool applied.

Are you passing a feature class or dataset path to the tool or the name of a layer or view?

Re: How to Stop "SelectLayerByAttribute_management" creating temporary tables, while running script in ArcPro

EdX1 — Mon, 15 Apr 2024 23:10:55 GMT

This was the issue!
I was passing in a complete sde path to the table into my SelectLayerByAttribute instead of just passing it the table name of the table I wanted to use, which was open in my ArcPro project!!

Thank you very much.