datameet-pune / datameet-pune.github.io

Common repo and documentation space for DataMeet Pune chapter
https://sites.google.com/view/datameetpune/home
GNU General Public License v3.0
16 stars 20 forks source link

Calculate open location codes for tabular data #16

Open answerquest opened 5 years ago

answerquest commented 5 years ago

Input : A table having lat and long values.

Desired Output : Same table, with columns added carrying OpenLocationCodes at varying precision levels: 4,6,8,10.

Target Audience : Knows excel and copy paste. No coding.

Two possible ways to do it: