Looking to use the Google Maps Geocoding API to build a program that will lookup addresses in a SQL Server database that will return address results such as corrected (valid or not) address, county, neighborhood (if available) , latitude and longitude points.
The program will have the capability to run daily with new addresses populated in View or Table. The configuration should allow up 2,500 hits per day and with new pricing set limits higher (based upon configuration file).
The program will have logic in place for bad or incomplete addresses where results aren't returned.
I will setup the process and data feed of which records to search daily.
I'd like to setup the program to run on a daily schedule. So may need help with that as well.
The configuration should allow me to easily update/change the Google API Key.
The program can be written in any language. I prefer a programmer who has already done something similar to this before.
Please see attachment of sample data, create tables, and query.
I am looking for a mix of experience and value