AVI and other options for geocoding

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

AVI and other options for geocoding

Post by qt_ky »

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
Choose a job you love, and you will never have to work a day in your life. - Confucius
jhmckeever
Premium Member
Premium Member
Posts: 301
Joined: Thu Jul 14, 2005 10:27 am
Location: Melbourne, Australia
Contact:

Re: AVI and other options for geocoding

Post by jhmckeever »

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.
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

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?
Choose a job you love, and you will never have to work a day in your life. - Confucius
skathaitrooney
Participant
Posts: 103
Joined: Tue Jan 06, 2015 4:30 am

Post by skathaitrooney »

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
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Thanks for the tip.
Choose a job you love, and you will never have to work a day in your life. - Confucius
jhmckeever
Premium Member
Premium Member
Posts: 301
Joined: Thu Jul 14, 2005 10:27 am
Location: Melbourne, Australia
Contact:

Post by jhmckeever »

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.
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Post Reply