Problem: Over the past several years our clients property management business has seen tremendous growth. Unfortunately the existing application did not have the proper field validation methods, to ensure that agents and clients were properly adding accurate property data such as the City, State, Zip codes. The company was seeking to correct each indiviual record.

Soltuion: To solve this problem we wrote a PHP program in combination with CURL remote scripting to connect our program with Google's web service.  Using the street address from the database we were able to obtain the City State and Zip from Google and updated the record on the database accordingly.