Can't overwrite a join_features output layer using ArcGIS Online Notebook Tasks

AhmedShehata3

Hi all, 

I have the below code written in AGOL notebook and its purpose is to join features of two feature layers. The output layer will need to be overwritten regularly through running the code every day and the layer also needs to be maintained because it will be used to build a dashboard. I used the Tasks functionality to run the code everyday, but I always get the below error, despite having the Overwrite parameter in my join_features function. Any idea how I can achieve that? 

---------------

The error: 

"The provided output name is already in use or contains invalid characters."

 

--------------

The code:

 

from arcgis.gis import GIS
gis = GIS("home")

itemDis = gis.content.get("8119.............14")
itemDis

itemSrv = gis.content.get("2056ad................fa73")
itemSrv

from arcgis import features

intersectionLayer= features.summarize_data.join_features(target_layer=itemDis,
                                                                                                         join_layer=itemSrv,
                                                                                                        spatial_relationship='intersects',
                                                                                                        output_name='intersection features',
                                                                                                        context = {"overwrite": True})
intersectionLayer

ryan_grammer

Hi @AhmedShehata3 @EmilyMills11 @JiříKomínek,

In order to use "overwrite": True in the context parameter, the output_name must be a feature layer, not a text string. 

Here's a sample code:

from arcgis.gis import GIS

gis = GIS("home")

from arcgis import features

 

polygon_target = gis.content.get('<ITEM_ID_1>')

polygon_join = gis.content.get('<ITEM_ID_2>'')

new_feature = gis.content.get('<ITEM_ID_3>'')

new_feature_lyr = new_feature.layers[0]

 

from arcgis.features.summarize_data import join_features

 

join_features(target_layer = polygon,

                                  join_layer = point,

                                  spatial_relationship = 'intersects'

                                  output_name = new_feature_lyr,

                                  context = {"overwrite": True})

 

There is a known bug with this, as it creates duplicate layers in the feature layer. There is a documented workaround:

 

Use ArcGIS Online Assistant to remove sublayers from feature layer. NOTE: ArcGIS Online Assistant is not supported by Esri Technical Support.

1. Navigate to assistant.esri-ps.com and Log In.

2. Under "My Content", find the target feature layer and click it. Click "View Item JSON".

3. Click on the "Data Tab". Click "Edit JSON".

4. Delete the duplicate json data. Be sure to keep the original ("id": 0). Deleting it all will break the layer and any dependent apps.