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
The only way I know who to do this is to use a 3rd party add on like Juiced who can produce maps and record the geocodes into Quick Base fields so they do not have to be re-geocoded each time.
Maybe Dan has some other magic, but I thought that you now need to have a Subscription contract with Google to routinely do geocoding. I thought is no longer a free service from Google although perhaps they allow small volumes for free. But I think for the maps or the usage of the geocodes to be fast, they need to get calculated once and recorded in Quick Base as geocoding is relatively slow. My experience with Juiced is they are able to geocode at a rate of about 3 per second, which sounds fast, but if you have 1000 addresses on report, that would take 50 minutes!
But in our use case, we just code Customer Accounts that are not already geocoded, so there may just be a few each day. So we run a dummy map of accounts not geocoded each day and Juiced writes the missing geocodes into a pair of lat long fields of the customer Account record.
Maybe Dan has some other magic, but I thought that you now need to have a Subscription contract with Google to routinely do geocoding. I thought is no longer a free service from Google although perhaps they allow small volumes for free. But I think for the maps or the usage of the geocodes to be fast, they need to get calculated once and recorded in Quick Base as geocoding is relatively slow. My experience with Juiced is they are able to geocode at a rate of about 3 per second, which sounds fast, but if you have 1000 addresses on report, that would take 50 minutes!
But in our use case, we just code Customer Accounts that are not already geocoded, so there may just be a few each day. So we run a dummy map of accounts not geocoded each day and Juiced writes the missing geocodes into a pair of lat long fields of the customer Account record.