[dwyerm]

In retrospect I also wonder why we didn't just do a bulk update. I think the problem was that we discovered the geocoding problem and started correcting for it before we understood where the problem was actually coming from. By the time we discovered it was a simple constant offset, we'd already damaged our own data with the one-off fixes.

Worse, the offset was right there in black-and-white in the release notes that we failed to read.

By the way, I apologize for being flippant about it. Location is just one of those things -- like time -- that too many people think is simple, but actually has devilish details that bite the unwary. You are fortunate that lat/long is sufficient and I hope you remain wary.