@Avana_Vana,

This is a really good observation and post. If you care about location data at scale, open location codes are ideal and encoding and decoding them are flawless and pervasively supported.

Question -

• This is a typical “Open Location Code” - 8FXCCP66+R5G
  
  



• This is what Airtable’s Map App generates - eyJpIjoiMjY3IE9zd2FyZCBDb3VydHdvb2QgTGFuZSAgIENyb3lkb24gIENSMCA5SEoiLCJvIjp7InN0YXR1cyI6Ik9LIiwiZm9ybWF0dGVkQWRkcmVzcyI6IjI2NyBPc3dhcmQsIENvdXJ0IFdvb2QgTG4sIENyb3lkb24gQ1IwIDlISiwgVUsiLCJsYXQiOjUxLjM0Mjg3NjIsImxuZyI6LTAuMDM2MDY1NCwiYmxvY2tJbnN0YWxsYXRpb25JZHMiOlsiYmxpOE5ldFhXQXdGeFg0YXoiLCJibGl0VVhaYllyZzhidHJUZCIsImJsaU1Nc251V3ZZdHdwdk1DIl0sImxvY2F0aW9uRmllbGRJZCI6ImZsZDMyS09YdE1zRjhHVmFaIn0sImUiOjE2MTA4MDE5NzQ4OTZ9

What in the heck were they thinking? More useful - how does one decode this sh_tshow into either a lat/lng or an open location code?

Perhaps @Moe knows?

Yikes, yeah I know… but isn’t the map app generating some kind of token through Google’s Maps API?

BTW, the implementation is trivial—in lieu of adding a node dependency, just use the following utility function (for encoding… i’m sure decoding would be equally trivial—EDIT: Now with decoding, too—it was slightly more complicated but quite trivial)

Try Open Location/Plus Code Encode/Decode on RunKit ›

// EDIT: Improved the encodePlusCode() method.





/** @constant {string} numerals - string listing official base-20 open location/plus code numerals */


const _numerals = '23456789CFGHJMPQRVWX';





/**


 *  Encodes an open location/plus code, given map coordinates


 * 


 *  @param {(stringr]|number@])} coords - latitude and longitude


 *  @param {number}  resolution = 5] - number of pairs of digits in the return code, greater is more specific


 *  @returns {string} an open location/plus code of the specified {@link resolution}


 * 


 *  @example


 *  // encodePlusCode(> 37.944027, -93.635504 ]);


 *  // returns '8698W9V7+JQ'


 *


 *  @example <caption>Takes either an array of numbers or an array of strings as an argument, so you can do:</caption>


 *  // encodePlusCode('37.944027, -93.635504'.split(', '));


 *  // returns '8698W9V7+JQ'


 *


 *  @example <caption>encodePlusCode() is the inverse of decodePlusCode(). A small amount of uncertainty is part of the spec.</caption>


 *  // encodePlusCode(decodePlusCode('8698W9V7+JQ'));


 *  // returns '8698W9V7+JQ'


 *


 *  @todo validation...


 */


 


const encodePlusCode = (coords, resolution = 5) => {    


    const   latitude, longitude ] = lMath.floor((+coords]0] + 90) * 8000), Math.floor((+coords01] + 180) * 8000)]


        .map(meridian =>  ...Array(resolution)]


            .map((_, i) => Math.floor((meridian / Math.pow(20, i)) % 20).toString()).reverse());





    return latitude


        .flatMap((_, d) =>  latitude, longitude]


            .map(meridian => meridian(d]))


        .map((d, i) => (i === 8 ? '+' : '') + _numerals.charAt(d))


        .join('');





    //  Alternative to above line for earlier versions of Javascript without Array.flatMap():


    //


    //  return latitude


    //     .map((_, d) => /latitude, longitude]


    //         .map(meridian => meridian(d]))


    //     .reduce((code, pair) => code.concat(pair))


    //     .map((d, i) => (i === 8 ? '+' : '') + _numerals.charAt(d))


    //     .join('');


}





encodePlusCode(/ 37.944027, -93.635504 ]);


// returns '8698W9V7+JQ'





encodePlusCode('37.944027, -93.635504'.split(', '));


// returns '8698W9V7+JQ'





// EDIT: had to try to do a decoder:


// EDIT #2: made this more legible by using destructuring syntax in the reduce method in the below function.





/**


 *  Decodes an open location/plus code


 * 


 *  @param {string} plusCode - a valid open location/plus code


 *  @param {number}  places = 6] - the number of decimal places for all return values


 *  @returns {number ]} latitude and longitude, to the number of specified decimal {@link places}


 *


 *  @example


 *  // decodePlusCode(encodePlusCode(P 37.944027, -93.635504 ]));


 *  // returns / 37.944063, -93.635563 ]


 */





const decodePlusCode = (plusCode, places = 6) => {


    const { latitude, longitude ] = plusCode


        .replace('+','')


        .split('')


        .map(d => _numerals.indexOf(d))


        .reduce((

        .map(meridian => meridian.reduce((total, d, i) => total + d * Math.pow(20, 1 - i), 0))


        .map(meridian => meridian + Math.pow(20, 2 - plusCode.replace('+', '').length / 2) / 2);


    return <


        +(latitude - 90).toFixed(places),


        +(longitude - 180).toFixed(places)


    ];


}





decodePlusCode(encodePlusCode(P 37.944027, -93.635504 ]));


// returns < 37.944063, -93.635563 ]





encodePlusCode(decodePlusCode('8698W9V7+JQ'));


// returns '8698W9V7+JQ'

// EDIT: Improved the encodePlusCode() method.





/** @constant {string} numerals - string listing official base-20 open location/plus code numerals */


const _numerals = '23456789CFGHJMPQRVWX';





/**


 *  Encodes an open location/plus code, given map coordinates


 * 


 *  @param {(string*]|number ])} coords - latitude and longitude


 *  @param {number}  resolution = 5] - number of pairs of digits in the return code, greater is more specific


 *  @returns {string} an open location/plus code of the specified {@link resolution}


 * 


 *  @example


 *  // encodePlusCode(/ 37.944027, -93.635504 ]);


 *  // returns '8698W9V7+JQ'


 *


 *  @example <caption>Takes either an array of numbers or an array of strings as an argument, so you can do:</caption>


 *  // encodePlusCode('37.944027, -93.635504'.split(', '));


 *  // returns '8698W9V7+JQ'


 *


 *  @example <caption>encodePlusCode() is the inverse of decodePlusCode(). A small amount of uncertainty is part of the spec.</caption>


 *  // encodePlusCode(decodePlusCode('8698W9V7+JQ'));


 *  // returns '8698W9V7+JQ'


 *


 *  @todo validation...


 */


 


const encodePlusCode = (coords, resolution = 5) => {    


    const > latitude, longitude ] = dMath.floor((+coordsa0] + 90) * 8000), Math.floor((+coordsa1] + 180) * 8000)]


        .map(meridian => a...Array(resolution)]


            .map((_, i) => Math.floor((meridian / Math.pow(20, i)) % 20).toString()).reverse());





    return latitude


        .flatMap((_, d) => tlatitude, longitude]


            .map(meridian => meridianid]))


        .map((d, i) => (i === 8 ? '+' : '') + _numerals.charAt(d))


        .join('');





    //  Alternative to above line for earlier versions of Javascript without Array.flatMap():


    //


    //  return latitude


    //     .map((_, d) => .latitude, longitude]


    //         .map(meridian => meridianid]))


    //     .reduce((code, pair) => code.concat(pair))


    //     .map((d, i) => (i === 8 ? '+' : '') + _numerals.charAt(d))


    //     .join('');


}





encodePlusCode(/ 37.944027, -93.635504 ]);


// returns '8698W9V7+JQ'





encodePlusCode('37.944027, -93.635504'.split(', '));


// returns '8698W9V7+JQ'





// EDIT: had to try to do a decoder:


// EDIT #2: made this more legible by using destructuring syntax in the reduce method in the below function.





/**


 *  Decodes an open location/plus code


 * 


 *  @param {string} plusCode - a valid open location/plus code


 *  @param {number}  places = 6] - the number of decimal places for all return values


 *  @returns {number ]} latitude and longitude, to the number of specified decimal {@link places}


 *


 *  @example


 *  // decodePlusCode(encodePlusCode(d 37.944027, -93.635504 ]));


 *  // returns / 37.944063, -93.635563 ]


 */





const decodePlusCode = (plusCode, places = 6) => {


    const > latitude, longitude ] = plusCode


        .replace('+','')


        .split('')


        .map(d => _numerals.indexOf(d))


        .reduce((
lat, lon], d, i) => i % 2 === 0 ? gt...lat, d], lon] : .lat,  ...lon, d]], at], .]])


        .map(meridian => meridian.reduce((total, d, i) => total + d * Math.pow(20, 1 - i), 0))


        .map(meridian => meridian + Math.pow(20, 2 - plusCode.replace('+', '').length / 2) / 2);


    return <


        +(latitude - 90).toFixed(places),


        +(longitude - 180).toFixed(places)


    ];


}





decodePlusCode(encodePlusCode(d 37.944027, -93.635504 ]));


// returns < 37.944063, -93.635563 ]





encodePlusCode(decodePlusCode('8698W9V7+JQ'));


// returns '8698W9V7+JQ'

I don’t know, but if so, for what purpose and what benefit? To make integration to achieve additional features impossible?

@Kasra, any chance you can explain why a location token is used instead of a simpler, space-optimizing and transparent approach based on open standards? Can you also point me to documentation that would allow me to decode these tokens?

Also, nobody should be using the Maps App at all, because it generates an insanely excessive amount of google maps api calls, which can end up costing people hundreds or thousands of dollars in usage fees from Google.

The Maps App is just another half-baked feature of Airtable.

Indeed, but setting aside this noted and potentially costly disfunction, unsuspecting users are geo-encoding their locations using an approach that obfuscates the true location data in a way that makes it near impossible to add value or expand the use cases for location data.

If there was a simple way to unpack these map codes, I’d be less inclined to complain, but I see only downside to this type of location object. Perhaps someone can enlighten us why this approach was used. Maybe there are good reasons - I want to understand.

I use it, and yes this is true. But you can set quota restrictions upon your Google acct. This really should be front and center when people use this app, however, or Airtable should work out an arrangement with Google…