By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 921 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

Reconcile two similar but unequal entries as equivalent

P: 1
Government data from various federal, state, and local sources shows entries referring to the same company name, address, and GPS location are similar but not equal. Such as "GE" vs "General Electric" or "12 1st Street" vs "#12 First Street" etc.
I request hints or tools to successfully reconcile these to a single database entry without manually comparing many thousands of lines.
Thanks.
May 23 '17 #1
Share this Question
Share on Google+
1 Reply


jforbes
Expert 100+
P: 1,107
The United States Postal Service has a Web-service available to validate an address. Using the Web-service, you could use it's results as a way to find similar addresses. This is something that I've wanted to do in-house for years, but it hasn't become a high enough priority with our data.

This is the link to the Web Tools API.
May 23 '17 #2

Post your reply

Sign in to post your reply or Sign up for a free account.