nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Update a table in ArcGIS Online Open Data

WarrenDavison

Hi There,

I'd like to be be able to routinely update a table that I have published to my ArcGIS Open Data site. Has anyone implemented something like this? I've been creating it as a CSV and replacing it on our web server using a script but my Open Data site only references an external download. So users are unable to query and filter the data. Has anyone been able to update a table in a way that users can still interact with it as a feature service?

Thanks,

Warren

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

AndrewTurner

As Daniel Fenton said, the `applyEdits` REST API call would be very useful here. Here is a Python ArcREST example. There are also Javascript, Ruby and probably a few other examples that may be useful.

DanielFenton1

Hey Warren, a couple thoughts here.

1. You can script uploads of that CSV. The best way to see how that works is to Open dev tools in your browser and visit the CSV Item page in ArcGIS Online. Then hit the upload button and replace the csv while watching the API calls your browser makes in the network activity tab. Here's the relevant documentation for that. http://resources.arcgis.com/EN/HELP/ARCGIS-REST-API/index.html#/Update_Features/02r3000000zt000000/

2. The other way you can go is adding the features to a hosted service. You can do that programmatically as well. Each time your underlying data updates, you can update the features in place, or delete all the features and upload over them. You can do all this while maintaining the same service. Here's the docs for that: http://resources.arcgis.com/EN/HELP/ARCGIS-REST-API/index.html#/Update_Features/02r3000000zt000000/

If neither of these ways work, I've got a few other ideas for you, but they're going to be more difficult and less supported.

Let me know what you think.

WarrenDavison

Hi Daniel Fenton,

I have indeed uploaded a table as a CSV directly ArcGIS Online and I recognize that I can replace this item in order to update it with an updated source file. However, much of our data is sensor data or data that we would like to keep up to date on a daily basis. Therefore, my goal with this post was to seek out alternatives to would allow us to keep our data near real time without manually updating this information as it would be very labour intensive.

With all of our other open data that has a spatial context we've been using FME to publish directly to the ArcGIS Online feature service. Ideally I would like to be able to do something very similar.

When I did upload my CSV to ArcGIS Online I had it create a hosted table as well, would it not be possible to interact with the hosted table since it seems to have all the features of a feature service when I view the REST endpoint?

I appreciate your suggestions,

Warren

DanielFenton1

Hi Warren, have you tried uploading that CSV directly to ArcGIS Online then replacing that CSV item?

WarrenDavison

Hi There,

I haven't found a solution to this yet... I briefly talked to Daniel Fenton and Courtney Claessens about this in Sand Diego this year, any chance you guys have some thoughts?

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.