US address correction, address verification, and geocoding using ZP4, Google Geocoding API, and Bing Maps API
From a couple of months, I have been involved in Tax certificate address verification project for educational purpose; I have around 8 million parcel address collected and maintained by different tax collecting agencies in various format for instance COBOL ,CSV, ASCII, Excel , and some are even in pdf for their tax districts. My task was to find the address from those different files and export them in CSV with corrected standard USPS address format (STREET, CITY, STATE, and ZIP) to make Universal Tax File format for data analysis by removing unwanted data from the address rows. Initially, I used ZP4 software, it has “ official United States Postal Service data files on a single DVD-ROM that provides a powerful tool for automatically determining the correct mailing address, ZIP + 4 code, and mail carrier route number for any location in the United States”, works fine for few address (about 15%) which has proper USPS standard address format. The real challenge s...