topic Re: Replace existing feature class data with new shapefile data in Data Management Questions

Replace existing feature class data with new shapefile data

NCantwell — Mon, 13 Mar 2017 15:33:56 GMT

I would like to replace existing feature class data with new shapefile data. I receive periodic data updates in shapefile format that I would like to apply to existing feature classes. IE existing feature class has 20 k rows of data, new file is updated with 2000 new rows of data, so 22k rows in the new shapefile.

I thought truncate (then load) would work, but getting an error. Is there a more straight forward method I'm missing?

Any advice greatly appreciated ,....Thanks!!

using ArcGIS 10.4.1

Re: Replace existing feature class data with new shapefile data

JayantaPoddar — Mon, 13 Mar 2017 15:52:07 GMT

Why not append the new records to the existing feature class?

The new records will get added to the destination feature class, so you won't have to worry about replacing it.

Re: Replace existing feature class data with new shapefile data

NCantwell — Mon, 13 Mar 2017 17:03:48 GMT

Thanks, I always receive a complete new file (rather than just the new records). So there's some edits, and new records.

So I prefer to just replace the records all together. I just tried "delete rows (data management)" , then loaded the new data. Worked fine, but is that a reliable efficient solution? For the number of files I have to update, its not a big deal........

Re: Replace existing feature class data with new shapefile data

JayantaPoddar — Mon, 13 Mar 2017 17:29:43 GMT

In that case, check the Overwrite the output of geoprocessing operations in Geoprocessing options of ArcMap.

Then run Copy Features tool to overwrite the older output.

You could automate the process, if required, by using it in a model builder or a python script.

Re: Replace existing feature class data with new shapefile data

NCantwell — Tue, 14 Mar 2017 15:42:42 GMT

worked great, thank you. Must beware of lack of warnings though, as I inadvertently overwrote a line file with a point file, different table structure.

Handy for me though, thanks again!

Re: Replace existing feature class data with new shapefile data

JayantaPoddar — Wed, 15 Mar 2017 13:03:09 GMT

I am glad that it worked for you!!!

Re: Replace existing feature class data with new shapefile data

VinceAngelo — Thu, 23 Mar 2017 13:42:09 GMT

DeleteRows is not efficient (no "delete" is), but TruncateTable is, not that it would much matter with only 20k rows (but if you cross 500k rows, you'll notice a difference).

- V

Re: Replace existing feature class data with new shapefile data

JoeBorgione — Thu, 23 Mar 2017 13:43:53 GMT

While jayanta.poddar‌ has answered your question I'll add a little tidbit as well: I overwrite existing feature classes all the time, using the delete features tool, followed by the append tool in a model. By doing so, I maintain the original schema of my target feature class, empty it out and replace it completely. Using the append tool in a model is great in it allows you to set up mapping fields from the source data to the target data once and only once.

Re: Replace existing feature class data with new shapefile data

Asrujit_SenGupta — Thu, 23 Mar 2017 13:49:58 GMT

Duplicate Post: https://community.esri.com/thread/191686-replace-existing-feature-class-data-with-new-shapefile-data

Re: Replace existing feature class data with new shapefile data

RebeccaStrauch__GISP — Thu, 23 Mar 2017 17:48:10 GMT

asrujit_pb since this one is "answered" and the other isn't, I put the duplicate comment on the other thread (and pointed here).