Lat/Long
I need to build a Heat Map for our executive team displaying saturation of certain geographically defined areas. Sadly, QB doesn't allow for a heat map organically, and most tools require the use of ...
Forum Discussion
You are going to have to use script to do the geocoding of the address.
This code:
https://pastebin.com/CZiAy9gd
Notes
(1) You may have to get a key from Google for your planned usage:.
https://developers.google.com/maps/documentation/geocoding/start
(2) If you use a key you have to add it the the URL being fetched
This code:
async function geocodeAddress(address, key) {
let response = await fetch('https://maps.googleapis.com/maps/api/geocode/json?address=${address}');
let data = await response.json();
return data;
}
var address = "1600 Amphitheatre Parkway, Mountain+View, CA";
var key = "";
geocodeAddress(address)
.then(data => console.log(JSON.stringify(data, null, " "))); Returns JSON which includes the lat/lon values::https://pastebin.com/CZiAy9gd
Notes
(1) You may have to get a key from Google for your planned usage:.
https://developers.google.com/maps/documentation/geocoding/start
(2) If you use a key you have to add it the the URL being fetched