Creating Google Maps Plus Codes from Lat Long value in AppSheet

[LeventK]

Hello Everyone,

I haven't shared any tips&tricks for a very long time in AppSheet Community, so here is a brand new one 🙂 I hope you like it.

Anyone who is interested in creating Google Maps Plus Codes in address, instead of a lat long value itself for a more precise mapping, here's an easy peasy HowTo:

[STEP-1]

Create a 2-column table from the value and symbol info from below GitHub page below, import it as a Read-Only table to your DB, and name it as you like,i.e., PLUS:

https://github.com/google/open-location-code/blob/main/Documentation/Specification/specification.md

Your table will look like this:

"Plus" Table

[STEP-2]

For any address-type column you have, you can use the below AppFormula to create a 10-digit Google Maps Plus Code:

CONCATENATE(
	LOOKUP(MOD(FLOOR(((LAT(HERE())+90)*8000)/160000),20),"PLUS","VALUE","SYMBOL"),
	LOOKUP(MOD(FLOOR(((LONG(HERE())+180)*8000)/160000),20),"PLUS","VALUE","SYMBOL"),
	LOOKUP(MOD(FLOOR(((LAT(HERE())+90)*8000)/8000),20),"PLUS","VALUE","SYMBOL"),
	LOOKUP(MOD(FLOOR(((LONG(HERE())+180)*8000)/8000),20),"PLUS","VALUE","SYMBOL"),
	LOOKUP(MOD(FLOOR(((LAT(HERE())+90)*8000)/400),20),"PLUS","VALUE","SYMBOL"),
	LOOKUP(MOD(FLOOR(((LONG(HERE())+180)*8000)/400),20),"PLUS","VALUE","SYMBOL"),
	LOOKUP(MOD(FLOOR(((LAT(HERE())+90)*8000)/20),20),"PLUS","VALUE","SYMBOL"),
	LOOKUP(MOD(FLOOR(((LONG(HERE())+180)*8000)/20),20),"PLUS","VALUE","SYMBOL"),
	"+",
	LOOKUP(MOD(FLOOR((LAT(HERE())+90)*8000),20),"PLUS","VALUE","SYMBOL")
	LOOKUP(MOD(FLOOR((LONG(HERE())+180)*8000),20),"PLUS","VALUE","SYMBOL")
)

Anyone interested can read more about the Plus Code from the webpage below:

https://towardsdatascience.com/plus-codes-open-location-code-and-scripting-in-google-bigquery-30b727...

[Suvrutt_Gurjar]

Thank you Levent.

Nice to see you back in the community after a while with your interesting tips as usual. 

[LeventK]

Thanks Suvrutt, it's good to be back. It's been a very long time because of my extremely busy schedule, the platform has changed a lot, so I need to catch up from somewhere.

[Mauricio_Bick]

@LeventK  can you share your app or screen shots?

Thank you!

[LeventK]

@Mauricio_Bick for what?