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
AVI and other options for geocoding
Moderators: chulett, rschirm, roy
AVI and other options for geocoding
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Premium Member
- Posts: 301
- Joined: Thu Jul 14, 2005 10:27 am
- Location: Melbourne, Australia
- Contact:
Re: AVI and other options for geocoding
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.
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>
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>
-
- Participant
- Posts: 103
- Joined: Tue Jan 06, 2015 4:30 am
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
https://developers.google.com/maps/docu ... tion/intro
The number of requests you can make would be limited though
-
- Premium Member
- Posts: 301
- Joined: Thu Jul 14, 2005 10:27 am
- Location: Melbourne, Australia
- Contact:
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>
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>