Thread: address matching and verification
I have two large databases of addresses (street name and number, postal code and municipality). I need to match the addresses to varify that they actually do exist. has anyone done this before with pgAdmin?
Sincerely,
Aaron Griffin
GIS Data Acquisition Technician
DMTI Spatial Inc.
Phone: 905-948-2000 ext. 2026
Toll Free: 1-877-477-3684 ext. 2026
Fax: 905-948-9404
625 Cochrane Drive, 3rd Floor
Markham, ON
L3R 9R9
Canada
Now Shipping!
CanMap®v2005.4
Canada's #1 choice for street, route, and rail mapping data
Aaron Griffin wrote: > I have two large databases of addresses (street name and number, postal > code and municipality). I need to match the addresses to varify that > they actually do exist. Are you comparing the two databases? Are the formats the same? What rules are you going to use to determine a match - an exact match, or will you try to handle small spelling errors? If there is a discrepancy is database A guaranteed to be right? What about an address in B that isn't in A? > has anyone done this before with pgAdmin? I'm not sure it's got anything to do with pgAdmin - that's just a user-interface to the database. I'd write a small Perl script, but you'll need to provide more information if you'd like something more specific. -- Richard Huxton Archonet Ltd
On Feb 15, 2006, at 12:50 PM, Aaron Griffin wrote: > I have two large databases of addresses (street name and number, > postal code and municipality). I need to match the addresses to > varify that they actually do exist. has anyone done this before > with pgAdmin? > I doubt they've done it entirely with pgadmin. If your addresses are all normalised already then this is a fairly basic SQL problem. If they're not normalised then you have an entirely different problem, and you'll need to do a normalisation pass (I suspect you have the expertise in-house to do that, given you work for an address database provider, but if not you might try melissadata.com). Which of those is the case? If it's the former then if you post the table descriptions someone can probably point you in the right direction. If you could be a bit more specific about what you mean by "match" that would help. Cheers, Steve