Обсуждение: address matching and verification

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