RE: Normalization was Left AS/400 and Returned

Interesting idea on the lookup.  Software like Zip City by WorksRight 
might help you to make sure your city is spelled right, and consistent. 
And it has api's that you can hook into data entry.  That way you don't 
have things like:
Fort Wayne
Ft Wayne
Ft. Wayne
F. Wayne
It's also pretty slick for when area code's change.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Jones, John \(US\)" <John.Jones@xxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
05/04/2005 01:22 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: Normalization was Left AS/400 and Returned






Zip codes cross town boundaries all the time.  60195 serves parts of 3
different Chicagoland suburbs (Schaumburg, Hoffman Estates, and
Palatine).  60504 crosses county boudaries.  There are also zips that
cross state boundaries.

The 5-digit zip cannot accurately be used to determine state & town.  It
may be possible to get that level of granularity if you use the full
9-digit zip; I'm not sure.

It seems from a normalization standpoint, the 5-digit zip is the
redundant field.  Try storing the address, city, and state and do a
lookup for the right zip instead of the other way around.

John A. Jones, CISSP
Americas Information Security Officer
Jones Lang LaSalle, Inc.
V: +1-630-455-2787  F: +1-312-601-1782
john.jones@xxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Steve Richter
Sent: Wednesday, May 04, 2005 1:07 PM
To: Midrange Systems Technical Discussion
Subject: Re: Normalization was Left AS/400 and Returned

On 5/4/05, Booth Martin <booth@xxxxxxxxxxxx> wrote:
> This raises a question that has bothered me for some time:  Why do we 
> store town and state anymore?  Zip code does it all, doesn't it?

you cant have two towns in the same zip code?

-Steve

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.




This email is for the use of the intended recipient(s) only.  If you have 
received this email in error, please notify the sender immediately and 
then delete it.  If you are not the intended recipient, you must not keep, 
use, disclose, copy or distribute this email without the author's prior 
permission.  We have taken precautions to minimize the risk of 
transmitting software viruses, but we advise you to carry out your own 
virus checks on any attachment to this message.  We cannot accept 
liability for any loss or damage caused by software viruses.  The 
information contained in this communication may be confidential and may be 
subject to the attorney-client privilege. If you are the intended 
recipient and you do not wish to receive similar electronic messages from 
us in the future then please respond to the sender to this effect.

-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.