arcpy . env . addOutputsToMap = False arcpy . MakeTableView_management ( " \\RDA.DBO.Immediate_Assessment" , "tmp_tbl" , where_clause ) # arcpy . GetCount_management ( 'tmp_tbl' ) # File " ", line 1, in # File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 17492, in GetCount # raise e # File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 17489, in GetCount # retval = convertArcObjectToPythonObject(gp.GetCount_management(*gp_fixargs((in_rows,), True))) # File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\geoprocessing\_base.py", line 496, in # return lambda *args: val(*gp_fixargs(args, True)) # Error in sys.excepthook: # Traceback (most recent call last): # File "C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\Extensions\Microsoft\Python\Core\ptvsd\debugger.py", line 2409, in _excepthook # print_exception(exc_type, exc_value, exc_tb) # File "C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\Extensions\Microsoft\Python\Core\ptvsd\debugger.py", line 2656, in print_exception # sys.stdout.write(out) # AttributeError: 'NoneType' object has no attribute 'write' # # Original exception was: # Traceback (most recent call last): # File " ", line 1, in # File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 17492, in GetCount # raise e # File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 17489, in GetCount # retval = convertArcObjectToPythonObject(gp.GetCount_management(*gp_fixargs((in_rows,), True))) # File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\geoprocessing\_base.py", line 496, in # return lambda *args: val(*gp_fixargs(args, True)) # arcgisscripting.ExecuteError: Failed to execute. Parameters are not valid. # ERROR 000732: Input Rows: Dataset tmp_tbl does not exist or is not supported # Failed to execute (GetCount). If the arcpy.env.addOutputsToMap is set to True, the same code will work. arcpy . env . addOutputsToMap = True arcpy . MakeTableView_management ( " \\RDA.DBO.Immediate_Assessment" , "tmp_tbl" , where_clause ) arcpy . GetCount_management ( 'tmp_tbl' ) # What I really want to do is the same as the Python following example, but I don't want to add the temporary layer to the map (the code should not rely on an active map in my case) # Name: DeleteFeatures_Example2.py # Description: Delete features from a feature class based on an expression # Import system modules import arcpy # Set environment settings arcpy . env . workspace = "C:/data/airport.gdb" # Set local variables inFeatures = "parcels" outFeatures = "C:/output/output.gdb/new_parcels" tempLayer = "parcelsLayer" expression = arcpy . AddFieldDelimiters ( tempLayer , "PARCEL_ID" ) + " = 'Cemetery'" # Execute CopyFeatures to make a new copy of the feature class arcpy . CopyFeatures_management ( inFeatures , outFeatures ) # Execute MakeFeatureLayer arcpy . MakeFeatureLayer_management ( outFeatures , tempLayer ) # Execute SelectLayerByAttribute to determine which features to delete arcpy . SelectLayerByAttribute_management ( tempLayer , "NEW_SELECTION" , expression ) # Execute GetCount and if some features have been selected, then # execute DeleteFeatures to remove the selected features. if int ( arcpy . GetCount_management ( tempLayer ) [ 0 ] ) > 0 : arcpy . DeleteFeatures_management ( tempLayer ) the above code is from ESRI help document: Delete Features—Data Management toolbox | ArcGIS Desktop So the question is: Can we make in-memory feature layers or tables without adding them to a map?

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

MakeTableView_management and MakeFeatureLayer_management won't work if arcpy.env.addOutputsToMap is set to False

simoxu

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>addOutputsToMap<SPAN class="operator token">=</SPAN><SPAN class="token boolean">False</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>MakeTableView_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"<workspace>\\RDA.DBO.Immediate_Assessment"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"tmp_tbl"</SPAN><SPAN class="punctuation token">,</SPAN>where_clause<SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># <Result 'tmp_tbl'></SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'tmp_tbl'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp; File "<string>", line 1, in <module></SPAN>
<SPAN class="comment token">#&nbsp;&nbsp; File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 17492, in GetCount</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp;&nbsp; raise e</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp; File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 17489, in GetCount</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp;&nbsp; retval = convertArcObjectToPythonObject(gp.GetCount_management(*gp_fixargs((in_rows,), True)))</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp; File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\geoprocessing\_base.py", line 496, in <lambda></SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp;&nbsp; return lambda *args: val(*gp_fixargs(args, True))</SPAN>
<SPAN class="comment token"># Error in sys.excepthook:</SPAN>
<SPAN class="comment token"># Traceback (most recent call last):</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp; File "C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\Extensions\Microsoft\Python\Core\ptvsd\debugger.py", line 2409, in _excepthook</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp;&nbsp; print_exception(exc_type, exc_value, exc_tb)</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp; File "C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\Extensions\Microsoft\Python\Core\ptvsd\debugger.py", line 2656, in print_exception</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp;&nbsp; sys.stdout.write(out)</SPAN>
<SPAN class="comment token"># AttributeError: 'NoneType' object has no attribute 'write'</SPAN>
<SPAN class="comment token"># </SPAN>
<SPAN class="comment token"># Original exception was:</SPAN>
<SPAN class="comment token"># Traceback (most recent call last):</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp; File "<string>", line 1, in <module></SPAN>
<SPAN class="comment token">#&nbsp;&nbsp; File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 17492, in GetCount</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp;&nbsp; raise e</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp; File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 17489, in GetCount</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp;&nbsp; retval = convertArcObjectToPythonObject(gp.GetCount_management(*gp_fixargs((in_rows,), True)))</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp; File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\geoprocessing\_base.py", line 496, in <lambda></SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp;&nbsp; return lambda *args: val(*gp_fixargs(args, True))</SPAN>
<SPAN class="comment token"># arcgisscripting.ExecuteError: Failed to execute. Parameters are not valid.</SPAN>
<SPAN class="comment token"># ERROR 000732: Input Rows: Dataset tmp_tbl does not exist or is not supported</SPAN>
<SPAN class="comment token"># Failed to execute (GetCount).</SPAN>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

If the arcpy.env.addOutputsToMap is set to True, the same code will work.

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>addOutputsToMap<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>MakeTableView_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"<workspace>\\RDA.DBO.Immediate_Assessment"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"tmp_tbl"</SPAN><SPAN class="punctuation token">,</SPAN>where_clause<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'tmp_tbl'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># <Result '45'>‍‍‍‍‍</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

What I really want to do is the same as the Python following example, but I don't want to add the temporary layer to the map (the code should not rely on an active map in my case)

<SPAN class="comment token"># Name: DeleteFeatures_Example2.py</SPAN>
<SPAN class="comment token"># Description: Delete features from a feature class based on an expression</SPAN>
 
<SPAN class="comment token"># Import system modules</SPAN>
<SPAN class="keyword token">import</SPAN> arcpy
 
<SPAN class="comment token"># Set environment settings</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:/data/airport.gdb"</SPAN>
 
<SPAN class="comment token"># Set local variables</SPAN>
inFeatures <SPAN class="operator token">=</SPAN> <SPAN class="string token">"parcels"</SPAN>
outFeatures <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:/output/output.gdb/new_parcels"</SPAN>
tempLayer <SPAN class="operator token">=</SPAN> <SPAN class="string token">"parcelsLayer"</SPAN>
expression <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>AddFieldDelimiters<SPAN class="punctuation token">(</SPAN>tempLayer<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"PARCEL_ID"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" = 'Cemetery'"</SPAN>
 

<SPAN class="comment token"># Execute CopyFeatures to make a new copy of the feature class</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CopyFeatures_management<SPAN class="punctuation token">(</SPAN>inFeatures<SPAN class="punctuation token">,</SPAN> outFeatures<SPAN class="punctuation token">)</SPAN>
 
<SPAN class="comment token"># Execute MakeFeatureLayer</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>outFeatures<SPAN class="punctuation token">,</SPAN> tempLayer<SPAN class="punctuation token">)</SPAN>
 
<SPAN class="comment token"># Execute SelectLayerByAttribute to determine which features to delete</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>tempLayer<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; expression<SPAN class="punctuation token">)</SPAN>
 
<SPAN class="comment token"># Execute GetCount and if some features have been selected, then </SPAN>
<SPAN class="comment token">#&nbsp; execute DeleteFeatures to remove the selected features.</SPAN>
<SPAN class="keyword token">if</SPAN> int<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN>tempLayer<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>DeleteFeatures_management<SPAN class="punctuation token">(</SPAN>tempLayer<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

the above code is from ESRI help document:

Delete Features—Data Management toolbox | ArcGIS Desktop

So the question is:

Can we make in-memory feature layers or tables without adding them to a map?

Find more posts tagged with

Accepted answers

JoshuaBixby

I logged a bug with Esri Support, you can attach your organization to it instead of submitting another one:

BUG-000116163 : In ArcGIS Pro when arcpy.env.AddOutputsToMap is set to False, the object fails to exist

All comments

DanPatterson_Retired

From here....

Considerations when using the in_memory workspace—Appendices | ArcGIS Desktop

results are temporary

Data written to the in_memory workspace is temporary and will be lost when the application is closed, making in_memory ideal for intermediate data created from model and Python script tools.

and with Delete being available, why would you be concerned about results being added to the map?

simoxu

Thanks Dan.

I am concerned that the temporary layer will mess up one of my maps. If I have an active map this will be my active map otherwise this will be first map in my map list (I guess...)

Although I can delete the records in the temp layer, but I assume the layer itself will still be listed in the content pane.

The point is, in my case I don't have a need to visualize this intermediate layer/table.

Hope this make sense.

JoshuaBixby

If you aren't adding the feature layer or table view to a map, you need to pass an object reference to other geoprocessing tools, not just the label:

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>addOutputsToMap<SPAN class="operator token">=</SPAN><SPAN class="token boolean">False</SPAN>

res <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeTableView_management<SPAN class="punctuation token">(</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"workspace>\\RDA.DBO.Immediate_Assessment"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"tmp_tbl"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; where_clause
<SPAN class="punctuation token">)</SPAN>
fl <SPAN class="operator token">=</SPAN> res<SPAN class="punctuation token">.</SPAN>getOutput<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN>fl<SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

The strings people commonly pass to geoprocessing tools are a kind of shorthand, a label, for an object. ArcPy uses that label to search an index of sorts to get a reference to the object. When addOutputsToMap is False the feature layer or table view isn't added to that index because it isn't part of any map, which is why you see the error that the dataset doesn't exist. When addOutputsToMap is False the object is created, you just need to capture a reference to the object from the result object returned from the geoprocessing tool.

simoxu

Thanks Joshua.

I've tried that but no success.

Please have a look at the screenshot.

Python environment in ArcGIS Pro

JoshuaBixby

Although the Esri document link in the original question was for Pro, I wasn't sure you were working in Pro. The code I posted works in ArcMap/ArcCatalog, which is where I have done something similar before. I just tried it in Pro, and it does not work because the Result object from the geoprocessing tool isn't returning a reference to the object like in ArcMap. I believe this should qualify as an equivalence bug if you open a case with Esri Support.

simoxu

Good idea.

deleted-user-1_r2dgYuILKY

Is there any news on this bug? I have a script that copies thousands of features, performs analysis and then deletes the copies. When I run this script in the Python window in ArcGIS Pro, the features copy to the TOC (ex. feature_new), and then are deleted. However, each time this happens, another copy with the original feature name and a number (ex. feature_old26) is created in the TOC, and remains after the script moves on to the next feature. So I have thousands of these in the TOC. If I use arcpy.env.addOutputsToMap = False in the script, it fails. ERROR 000732: Input Features: Dataset feature_old26 does not exist or is not supported

JacqueHamilton

I am also getting this error. Has there been any resolution Yet? I can run my script alone in IDEL but when I'm running it in Notebooks it want's to add my hundreds of layers to the map which I don't need.

JacqueHamilton

Any resolution to this problem in ArcPro? I'm running Notebooks in ArcPro. #BUG-000116163 : In ArcGIS Pro when arcpy.env.AddOutputsToMap is set to False, the object fails to exist

JoshuaBixby

Unfortunately, no: BUG-000116163: In ArcGIS Pro, when arcpy.env.AddOutputsToMap is set.. The "In Product Plan" means they acknowledge a defect, but they won't commit to when it will be addressed. Given the defect was logged 2 years ago, "In Product Plan" is about as reassuring as "the check is in the mail."

JacqueHamilton

Thanks for the update and the link to the notification. I added myself to the notify list when it gets fixed. I guess I won't be using Notebooks in ArcPro any time soon. Not until they fix this. I hate having to manually delete the hundreds of temp layer files and shapefiles that get added the map when I'm running my model.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.