How to retrieve latitude and longitude from address

As mentioned, you'll need the Location Insights add on for this tool to work - it has a specific dataset to enable use of these tools. Do you have it? Location Insights

All comments

There is the Address tool palette, but do you have the Location insights add on? Street Geocoder Tool

Otherwise your best method is API

Hi Alex,

I already tried the Street Geocoder Tool, I am getting the error saying at 'Select a Geocoder'. In the dropdown, it shows 'No Geocoder Datasets Available'

As mentioned, you'll need the Location Insights add on for this tool to work - it has a specific dataset to enable use of these tools. Do you have it? Location Insights

No, I don't have Location insights add on. You mentioned about an API, could you tell me which one is it?

There are a bunch out there - it all depends on what you are willing to spend (if anything) and what is accepted by IT. I would search online but here are a few:

Thank you Alex!

Happy to help!

Note: @alexnajm reply might have solved your solution by providing several API links. I didn't see them until I refreshed.

This is a topic where there are many commercial solutions out there and then "free tiers" for the big players like Google. It's not a topic that just has an easy free solution all the time, but it's one that you can normally find a solution that works. It will most likely require development from you to get a solution working, but there is tons of info out there that we can point you to.

This will go a lot quicker with the following information.

You tried geocoder macro and it worked for one week.
- What macro was this?
- Can you provide the link ideally, or at least a name? I've seen up to 10 different geocoder macros on the community over the years.
- What is error code 9? Have you got a screenshot, or more info?
What country are you trying to geocode?
- The Street Geocoder in the Location Insights pack only works for certain countries I think. And you would need different subscriptions if you were trying to geocode addresses on different continents.
- This is something that is relevant in APAC at least, as different countries use very different address formats and sometimes there is good in country solutions.
What quantity of data are we talking about here?
- Will it fit into a free tier, or are we talking about 100,000 addresses
- If it's only a couple hundred then there are multiple ways. I've previously got the lat/long of a couple hundred residential addresses by using the download tool to search them on a real estate site and ripping the webpage for the lat/long. I wouldn't advise needing that in 2025, but it's an example of going a different way.
Do you want something that can geocode once? Or do you plan to set it up to geocode new addresses every day/week?

Hi @KGT,

You tried geocoder macro and it worked for one week.

Geocoder macro
https://traveltime.com
What is error code 9? The description for this error is ‘You have exceeded the maximum number of requests per minute allowed on your plan. To upgrade your plan to one with higher limits, log in to your account at https://account.traveltime.com and click Upgrade.’

What country are you trying to geocode?

US and Canada.

What quantity of data are we talking about here?

It should be less than 100,000 addresses.

Do you want something that can geocode once? Or do you plan to set it up to geocode new addresses every day/week?

New addresses will be adding up on daily basis.

All very good points @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.

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?

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

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