I have look through this group (and others) put haven't found an
acceptable answer. I have an SQL database with address, city, state
and zip in separate columns. I need an automated process to geocode
these address and put them into the database. It is not possible to
geocode them manually. The database is completely destroyed and
recreated every night with 4000+ - address. Any ideas on how I could
get this to work?

Maybe Google's geocoder isn't the service for you, although you could put
4000 addresses throught the HTTP geocoder if you were careful. If your
addresses are all in the US you could try Geocoder.us. The Perl source code
is freely available and you can get the TIGER/LINE data from the US census.

- http://geocoder.us/
- http://search.cpan.org/~sderle/Geo-Coder-US/
- http://www.census.gov/geo/www/tiger/

Alex

Depending how the database is used, you could rethink the strategy
perhaps;

Not much point geocoding everything daily if much of it is thrown away
without ever being used.  Maybe geocode each location only when
actually required, and then also store the result in case it does get
looked at again later.

Or look again at why all the data is discarded daily.

cheers, Ross K