We really don’t want to break things that work, it’s super frustrating. We test to make sure that any changes we make do not break another piece of the code in our applications. Of course manual or exploratory tests are important but the dream is to get this stuff fully automated.
A lot of manual work can be avoided by using scripts to automate the processes. However, you inevitably end up with a lot of scripts to automate different pieces of a process.
a quick and concise guide to geocoding in a hurry
How to make GeoJson available to a database. This article demos web scraping with python and writing to an SDE feature.