Extract latitude and longitude from maps.google

[guif]

hi!

I trying to extract via command line the latitude and longitude with this command

curl -s 'http://maps.google.com/maps?q=Madrid, Spain'

Can anybody help me to use any more command to parse this result?

very thanks

[Kloschüssel]

There is a public API to the google maps service. One should not parse the website content, also because it is really slow and bandwidth consuming. The service provides you data that will be easy to parse.

[guif]

but i don't have any web page to obtain a public KEY for an API.
How can I resolve this?

In my case I have a MySQL with all postal codes, cities and countries.
My idea is to start a script to collect all information and insert all longitudes and latitudes.

[RDU]

You can find this easily with google search !!. Here is it : Sign Up for the Google Maps API - Google Maps API Family - Google Code

It's a huge job to scan all cities in the world !! And probably lot of them will never be used. Try to query the API when you need one instead of storing lot of stuff !

[guif]

ok thanks.