Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: De Duping Street Addresses Fuzzily

by nmerriweather (Friar)
on Feb 01, 2005 at 17:30 UTC ( [id://426972]=note: print w/replies, xml ) Need Help??


in reply to De Duping Street Addresses Fuzzily

We did this in our office for a client once... First, we normalized the database to USPS standardized text, based on the chart of accepted postal abbreviations: http://www.usps.com/ncsc/lookups/usps_abbreviations.html That alone turned probably 90% of the potential dupes into exact duplicates as for the rest -- if there are multiple apartments/suites/floors on the same address, we suggested that they send that anyways -- there isn't any real way to tell that address isn't a separate entity. could be neighbors or co-workers who should each have gotten their own postcard.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://426972]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (8)
As of 2024-03-28 11:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found