You can do this using the Google Maps Data API. The geocoding section will be of interest to you ( See API Docs ). Just write a PHP script to:
1) Scroll to your addresses
2) Send an HTTP request (use CURL or just file_get_contents()) tohttp://maps.googleapis.com/maps/api/geocode/json?address=1600+Amphitheatre+Parkway,+Mountain+View,+CA&sensor=true_or_false
3) Parse the JSON response
4) Store in your database
Remember that Google has usage restrictions. I'm not sure if this is so, 1600 queries may or may not be a problem. You can add delays between requests and / or run them for several days.
source
share