Lat and lon from a location

[Dario Maimone Ansaldo Patti]

Dear All,

I have a dataset which includes the names of several locations (mainly cities) around the world. I need to obtain lat and lon from them.

I checked online and found opengeodata and geocode. However the first one has a limit of queries for each day (which means that in my case I can finish this task in more than 2 weeks). The second one apparently freezes when I try to execute it.

Is there any other alternative I can use?

Thanks in advance for any help you may provide.

Dario

[Clyde Schechter]

Perhaps one of the databases at https://simplemaps.com/resources/free-country-cities will meet your needs.

[Dario Maimone Ansaldo Patti]

Clyde Schechter I was checking for an automatic way to do that through stata. For instance, opengeodata works fantastic, but it has a limited number of queries. But your suggestion is very useful! I can download the excel files for the countries and use merge. Thanks a lot!

[Dario Maimone Ansaldo Patti]

Just to be precise. The user-written routine I was referring to is opencagegeo, not opengeodata. Apologies for the mistake