With all the news around privacy and geolocation for pandemic analysis, my mind started wandering on the general subject of geolocation randomization or rounding. The simplest, yet crude, approach is to use AppSheet’s Here() function and then lop off some decimal places. There is probably a more sophisticated way to do this (rounding on mercatur calc, etc). However, even converting a full Lat/Long to a rounded one provides some level of obscurity of geolocation, while still allowing for meaningful analysis to occur later.
Slight brag about the platform: I’m not aware of many tools or software out there that can allow for geolocation and rounding/obfuscation to occur simultaneously in realtime during data entry or data capture. Let us know if you know of some!
Anyway, here’s a quick example of what the AppSheet expression looks like: