Select to view content in your preferred language

Reload table cache in ArcGIS Pro?

1944
6
10-17-2020 01:22 PM
CandiceOoi1
New Contributor

In ArcMap, it is very easy to reload table cache where it will call the CSV that was previously used to create the feature class to update the feature with any new data from the same CSV.


In ArcGIS Pro, it seems to me that once we create a feature layer from a CSV file, the attribute table of the feature layer is independent to the CSV file used. There doesn’t seem to be a way to reload table cache in ArcGIS Pro.


I’d like to be able to have the feature class updated using the same CSV (with new data added) instead of me recreating the feature every time we collect new data. This is so that I can preserve the symbology as well and don't need to repeat the steps of updating the symbology. 


I’ve considered appending, but as some entries from previous import can change, I prefer to overwrite the attribute table in the feature class instead. Is this possible using ArcGIS Pro or Arcpy? If so, how?

Thank you for your help in advance!

Edit: I tested with ArcMap and ArcGIS Pro, once the feature class is created, the attribute table is independent of the csv and reload table cache in ArcMap/ refresh in ArcGIS Pro will not update with the latest csv. So I guess there is not really away where I can update the attribute tables of a feature class without recreating the features using a new version of the csv?

6 Replies
by Anonymous User
Not applicable

I have the same question - anyone have suggestions? 

0 Kudos
DuncanHornby
MVP Notable Contributor

You don't say how you actually add your CSV data to the map. If you want to visualise a point dataset from a CSV you use the Make XY Event Layer tool:

CSV file is:

id,x,y,type
1,227202,438092
2,227212,438062
3,227222,438072
4,227232,438082

Tool is:

DuncanHornby_0-1627040344585.png

You can edit (add or amend rows) the CSV in notepad then simply refresh the map. The only issue is that if you add a new field to your CSV file then you will need to drop the layer and re-run the Make XY Event Layer tool so it picks are the schema change

0 Kudos
DavidTST
New Contributor

Hi Duncan. This hasn't worked for me. I have made CSV files of point locations and imported the data successfully using either Add X Y Data or View > Geoprocessing > X Y Table to point. However, when I edit the CSV file I cannot see the changes by simply refreshing the map, nor the database via the Catalog pane for that matter. Any ideas what I'm doing wrong? Thanks. 

0 Kudos
DuncanHornby
MVP Notable Contributor

You have run the xy table to point tool NOT THE make XY event layer tool as I had suggested above. The tool you ran converts your csv into a proper permanent spatial dataset whilst an event layer is  a read-only layer built on the fly.

0 Kudos
AJR
by
Frequent Contributor

This also applies to reading data from an enterprise geodatabase table that's being updated by some other user.  In ArcMap you could see those changes by clicking the reload cache menu, but in ArcGIS Pro you have to completely close the table and re-open it (way more clicks/hassle than it was in ArcMap).  Note, as of AGP 3.2 this is still a problem.

Bud
by
Esteemed Contributor
0 Kudos