Automating Data Updates at Cumberland County


In my work with Cumberland County, I developed a template Python script that is used to automate various data update workflows. Various scripts are run as Windows Scheduled Tasks on a daily, weekly, or monthly basis. The scripts write the informational and error messages of the processes to a text file. Below are some of the data updates we have automated:

  • Data replication to County departments
  • Rebuilding tiles for cached map services
  • Rebuilding address locators
  • Overwriting feature services hosted on ArcGIS Online
  • Converting a non-spatial database table to a GIS feature class
  • Running maintenance tools on enterprise geodatabases

sketch diagram of the automated data update script for Cumberland County