topic Re: Updating Feature Class Information from Excel in ArcGIS Pro Questions

Updating Feature Class Information from Excel

kcole — Mon, 04 Mar 2024 18:06:21 GMT

I am creating a python script to update a feature class monthly from excel spreadsheet information. I have already worked out how to delete records that are no longer active as well as geocode and add new records, but I am also wanting to update any information that has changed without having to geocode it all again. I know the easiest way would be to just drop all the information and geocode and republish, but that will consume a lot of credits.

I have looked at a few different options like UpdateCursor or merging and dropping fields, but I have not gotten them to work. Does anyone have a better idea on how I could go about this?

Re: Updating Feature Class Information from Excel

SeaRM — Tue, 05 Mar 2024 06:34:15 GMT

XTools Pro Edit in Excel tool can do this.

https://xtools.pro/en/features/table-tools/edit-in-excel/

Re: Updating Feature Class Information from Excel

kcole — Tue, 05 Mar 2024 14:33:35 GMT

I was hoping to have it be a standalone python script rather than having to use more tools. Thank you though!