topic Re: Append web feature layer in model builder- avoid duplicates in ArcGIS Pro Questions

Append web feature layer in model builder- avoid duplicates

LucileFayolle — Mon, 04 Oct 2021 05:21:05 GMT

I have a model to update the data of a hosted web feature layer.

Problem is: a big part of the 'new' data are identical to the 'already existing' dataset. So, to update the layer and limit the duplicate I use the tool Delete Rows on the web layer, then Append. Just the delete rows takes 10min on my computer and with time the dataset will grow quickly..

Is there an easier and quicker way to append just the new data in the web layer?

May be the use of Dissolve before the Append?

Thanks

Re: Append web feature layer in model builder- avoid duplicates

JakeSkinner — Mon, 04 Oct 2021 14:45:01 GMT

Hi @LucileFayolle,

If you export your model to a python script, you can leverage the ArcGIS API for Python. With this module you can use the truncate method, which is much faster than Delete Rows. Ex:

import arcpy from arcgis import GIS # Variables portal = 'https://portal.esri.com/portal' # Portal URL username = 'portaladmin' # portal username password = '********' # portal username password fsItemId = '7b51dcf43c3847ecabf850c607bca967' # item id of hosted feature service # Sign Into Portal gis = GIS(portal, username, password, verify=False) # Truncate Hosted Feature Service hostedFlyr = gis.content.get(fsItemId) fLyr = hostedFlyr.layers[0] fLyr.manager.truncate()

Re: Append web feature layer in model builder- avoid duplicates

LucileFayolle — Fri, 08 Oct 2021 03:51:45 GMT

Thanks for that!

I never used the ArcGIS API for Python, will give it a try.

I also find a way to script a tool to Overwrite web layer but have some trouble with it, so I may try this.