Sunday, December 26, 2010

Geocoding Customer Data using Talend

Geocoding customer data based on their zip or street address can add value to your data in many ways. For example you can do proximity searches using Solr on your customer data and show them relevant content every time they login to your site.

Talend makes it real easy and fast to achieve this. You can download a list of US Zip codes and a lat/long mapping at They have geocodes for other countries as well.

You can then create a basic job in Talend with a two csv input files and a tMap and see the results.

You can use the Google Map API to get more accurate Lat/Long results when you supply the address. The only problem is that there is a limit of 2500 per day. Talend has a connector called tGoogleGeoCoder that does precisely that.

No comments:

Post a Comment