Skip to main content
Question

Writing LARGE datasets to ArcGIS Online

  • May 14, 2019
  • 8 replies
  • 239 views

runneals
Supporter
Forum|alt.badge.img+29

Working with esri and the developers for ArcGIS Online, we came up with this script that can be used on shutdown. You will need to write data out to a zipped file geodatabase (or other formats), then configure the script.

Only works with 2019.x+ as it requires you to use ArcGIS Pro (tested in 2.3). It does take a while to run (as it has to use the ArcGIS Python library), but is SUPER efficient when trying to write LARGE datasets to ArcGIS Online. It is much preferred over using the FME writer because that one uses the traditional database insert for each record while this is similar to bulk inserts. Can probably be modified for writing to Portal as well.

https://github.com/runneals/GISProjects/tree/master/agol/Append

cc @carsonlam @bruceharold @mmccart

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

8 replies

bruceharold
Supporter
Forum|alt.badge.img+19
  • Supporter
  • May 14, 2019

Very cool David. Also check it out @1spatialdave


bruceharold
Supporter
Forum|alt.badge.img+19
  • Supporter
  • May 15, 2019

@carsonlam Hi, this question could be refactored as an idea, namely to support bulk appends when the arcgis Python API is available, with and without truncate. Personally I use Pro to populate feature services and use DI/FME for maintenance operations but others may like a bulk writer.


carsonlam
Safer
Forum|alt.badge.img+7
  • Safer
  • May 15, 2019

@carsonlam Hi, this question could be refactored as an idea, namely to support bulk appends when the arcgis Python API is available, with and without truncate. Personally I use Pro to populate feature services and use DI/FME for maintenance operations but others may like a bulk writer.

Is there a similar bulk append mechanism in the ArcGIS REST API?


bruceharold
Supporter
Forum|alt.badge.img+19
  • Supporter
  • May 15, 2019

LizAtSafe
Safer
Forum|alt.badge.img+18
  • Safer
  • May 15, 2019

@carsonlam Hi, this question could be refactored as an idea, namely to support bulk appends when the arcgis Python API is available, with and without truncate. Personally I use Pro to populate feature services and use DI/FME for maintenance operations but others may like a bulk writer.

Hi @bruceharold,

Unfortunately we cannot convert questions to ideas, but I have created the idea for you to vote on. Please see Support bulk appends when the ArcGIS Python API becomes available

- Liz

cc: @runneals, @mmccart, @1spatialdave, @carsonlam


bruceharold
Supporter
Forum|alt.badge.img+19
  • Supporter
  • May 15, 2019

Hi @bruceharold,

Unfortunately we cannot convert questions to ideas, but I have created the idea for you to vote on. Please see Support bulk appends when the ArcGIS Python API becomes available

- Liz

cc: @runneals, @mmccart, @1spatialdave, @carsonlam

Thanks Liz! Maybe Carson will make an end run around the idea and do it with the REST API so there is no ArcGIS dependency. I'm seeing a lot of action with bulk work to AGOL so it will be popular.


runneals
Supporter
Forum|alt.badge.img+29
  • Author
  • Supporter
  • May 15, 2019

Is there a similar bulk append mechanism in the ArcGIS REST API?

Great minds think alike @carsonlam :) I was going to go that way with the next enhancements for improving the script, as using the ArcGIS Pro API requires quite a bit of overhead and increases the run time quite a bit. However my workload exceeds my free time, so probably won't be happening for a while on my end.

If you need a use case, we have a workspace that runs every week that updates historic rail lines in Iowa that takes almost 30 minutes to run, and almost 20 minutes of that is just writing data up to ArcGIS online, so using this bulk append method would only take a couple minutes and speed it up quite a bit.


runneals
Supporter
Forum|alt.badge.img+29
  • Author
  • Supporter
  • June 14, 2019

I was successfully able to get over the major issue when the file geodatabase would get stuck on ArcGIS Online due to the delete portion of the script not being executed. See the sample below for the best implementation that works now (using feature writer and a python caller)!

Sample_Workspace_AGOL_Append_PUBLIC.fmw