With the Geomapping module it is simple to show a Google Map. But then you need to have longitude and latitude of every address. I have a custom table with about 600 addresses. Because there are so many addresses, and because the addresses change regularly, I would like to automate the geocoding (converting an address to longitude and latitude).

I guess for speed reasons, and because the Google geocoding service only allows so many requests per day, it would be sensible to go through the 600 addresses and to put longitude and latitude values in the tablerow for each address. Does anyone have experience in this and can help me further with this?

Any help would be appreciated.

Kind regards,
Martijn