How to retrieve latitude and longitude from address

[NakulMalisetty]

Hi,

My data set has address field, is there a way to get latitude and longitude from the address field? 

I tried Geocoder macro which worked fine for one week however, throwing error code 9 now. I would like to know if there is any tool in alteryx to retrieve latitude and longitude from address?

Any help is appreciated.

Thanks

Nakul

[alexnajm]

All very good points @KGT !

[KGT]

Right, so that actually makes it a lot easier.

So, it's this macro created by Traveltime. https://community.alteryx.com/t5/Community-Gallery/Geocoder-Macro/ta-p/895849

For a commercial solution, (which 100k addresses and new ones every week might necessitate) then best option is to talk to Traveltime about a license. Or the Location Insights through Alteryx will also do this for you if you wanted to look into that pricing with your Alteryx rep.

Depends how many will come in each week. 100k on a free license will be very iterative and then you'll be restricted as to how many you can do each week without splitting the process.

The free tier on that looks like it's restricted to 2 weeks and 60 hits/minute which would require a throttle tool to restrict the input to 45-50 or so per minute.

If you have an existing license with Traveltime, then it may be limited to a certain number of hits/minute and again the throttle tool will help.

[NakulMalisetty]

With around 50k addresses, if the throttle tool reduces the input to 50 per minute, can't it take more time to read all the 50k addresses?

[KGT]

It will absolutely take more time. The throttle tool is essentially slowing the rest of the process down to the api limit. 

[NakulMalisetty]

Hi @alexnajm and @KGT,

Installed the location insights add on's, the street geocoder works now. Thanks to you both for all the inputs, very much appreciated.

Thanks

Nakul

[KGT]

Great to hear!