DSXchange

For getting latitude and longitude data from an address (geocoding), in the past we used IBM GeoLocator, then later we tried using the AVI add-on to QualityStage.

Are there other less expensive or free alternatives? What do you all use for geocoding needs?

Our needs are for U.S. addresses only.

I see that USPS TIGER/ZIP + 4 File product includes latitude and longitude data, but it's dated 2007 and they do not provide updates. It's also not clear from the online description how accurate the data may be, or if it's only provided at a ZIP code level. Anyone use this and could confirm if this is the tradeoff?

https://ribbs.usps.gov/index.cfm?page=a ... e_products

We use Experian's 'QAS Batch' called from a custom DataStage stage. See more about it here:

https://www.youtube.com/watch?v=UKihsDecQ2w

It can enhance your address with a heap of additional enrichment information. See the Experian site for all the additional stuff it can provide, beyond a simple 'clean' address.

J.

Thanks for replying. Interesting video, however my question was specifically about geocoding options.

Is anyone geocoding with DataStage? What software or service do you use?

You can try to use the free Google API, its a RESTful web service i believe which can be invoked by DataStage

https://developers.google.com/maps/docu ... tion/intro

The number of requests you can make would be limited though

Thanks for the tip.

It's an old thread, but I'll update my response for clarity: I mentioned QAS Batch because geocoding is available by licensing additional datasets (e.g. Mosaic) which can all be accessed via QAS.