Hi,
I would like to create a workflow to automate a process that allows me on a regular basis to update the list of addresses to be geocoded from a CSV file available on a Google Drive by creating the location of points and updating the published feature layer in ArcGIS Online.
However, I would just like to keep the new addresses added in the CSV file when updating the hosted feature layer in ArcGIS Online.
Is there an easy and efficient way to accomplish this process from ArcGIS Pro using Model Builder or other methods?
Thanks for providing leads!
Best regards,
Solved! Go to Solution.
You're welcome! I only aim to help and I of course understand not sharing data due to security. Please keep me posted on the outcome!
This is absolutely possible to automate. Although, I must admit I never used Google Drive to update a hosted feature layer in AGOL, there are options.
Since I'm not an expert programmer, I would use ModelBuilder. The workflow would look something like this:
1. If it doesn't already exist, create a hosted feature layer with the addresses and necessary fields in ArcGIS Online.
2. Download the .csv file from the Google Drive using "FeatureClassToFeatureClass" tool and for the input parameter use a URL link from the .csv file in Google Drive (only assuming this is possible because I never used Google Drive for this). The output parameter for the tool would be a local file geodatabase. Then run it and check your file to make sure it ran correctly and all the records match the source data.
3. Then you will use the "GeocodeFile" tool. The input table is your table from step #2, For the locator, I would create my own using local address points (this locator will also need to be rebuilt frequently to update the address points). If you use the ArcGIS World Geocoding Service, you will use credits! If you don't have a local locator, see this link on how to create one: https://pro.arcgis.com/en/pro-app/2.8/help/data/geocoding/create-a-locator.htm , then the output type will be "Feature class" and the output Location, I would use the same local file geodatabase you used for the table, the output name is the name of the feature class. Then run it.
4. Then you will use the "Append" tool to append the hosted feature layer in AGOL using the feature layer created in step #3.
Models can be exported to python scripts and scheduled in Microsoft Task Scheduler. Just make sure that whatever computer you are automating the script, you are signed in as the user, that you have ArcGIS Pro installed, and you are signed into AGOL. Otherwise, it won't authenticate you and the script won't run.