dmacpher
|
Posted: May 17, 2011 19:43 by dmacpher
|
|
I'm wondering if OpenEMPI could be used to help with postal address matching. Comparing two free-form postal addresses to determine if they point to the same delivery point can be an exceedingly difficult task. I'm thinking that the normalization and probabilistic functions of the EMPI (even tho we're not specifically dealing with Persons in this context) could help with this problem. Has anyone attemped this at all? Regards, Dave |
Address Matching
4 posts
Replies: 3 - Last Post: November 28, 2011 20:12
by: Csaba Toth
by: Csaba Toth
showing 1 - 4 of 4
Csaba Toth
|
Posted: May 26, 2011 20:57 by Csaba Toth
|
|
The probabilistic functions can provide a very good solution for you. You probably have to deal with the format of your data though. - See if OpenEMPI's DB schema is good for you, you can modify it - You may have to tweak with file imports (that means a little development) to format your input, but it all depends on your data |
|
galileotech
|
Posted: September 01, 2011 13:30 by galileotech
|
|
I have used one of many companies on the Internet that buys the USPS data and creates an address search service around it. The idea is that address can be validated and, this is key, normalized. A service runs, you submit a raw free form address to it and, if it finds the address, you take the formatted, clean, normalized address back and make a hash key from it. Any other raw address that also has this same address hash key is the same address. So "123 Maple Street, Anytown, AL 36301" and "123 North Maple Road, Anytown, AL" could match, The service can be used over the Internet (Web Service) or download as a stand-along local web service (for high volume). BTW, I consider this a "Address Index" but not done using a EMPI matching tool. So the EMPI uses the ... EMAI. Oh, as a bonus, you get your addresses validated as "deliverable", "partial premise" or "no found". Just a consideration. |
|
Csaba Toth
|
Posted: November 28, 2011 20:12 by Csaba Toth
|
| Thanks for the advices galileotech! Yes, address standardization can be a very important part. If you have any contribution, don't hesitate to share with us. |
Replies: 3 - Last Post: November 28, 2011 20:12
by: Csaba Toth
by: Csaba Toth
