From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
---|---|
To: | Andreas <maps(dot)on(at)gmx(dot)net> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: HowTo divide streetname from house-nr ? |
Date: | 2010-09-23 02:08:31 |
Message-ID: | 4C9AB69F.7080009@postnewspapers.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On 23/09/2010 9:25 AM, Andreas wrote:
> Hi,
>
> how could I divide streetnames from housenumbers ?
You can't, reliably. There are papers written on the subject of
addressing, address analysis, addressing in databases, etc.
How would you handle the address:
Person's Name
RD3 Clemo Rd
Whangarei
? "RD3" is "Rural Delivery Area 3". The posties deliver within the area
by named recipient. This is a real address scheme.
The world is full of weird and wacky addressing. IMO, unless you're
willing to confine your schema to only handling addresses of a
particular area you know about, don't try to normalize address. Even
then, I wouldn't try to normalize addresses with text processing, I'd
ask the user to do it during form entry or not do it at all.
If you're trying to find duplicate addresses, matching addreses, etc,
then IMO you're better off using existing tools that do this with
free-form addresses using national phone databases, postcode databases, etc.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Johnson | 2010-09-23 03:30:23 | unique fields |
Previous Message | Andreas | 2010-09-23 01:25:25 | HowTo divide streetname from house-nr ? |