RE: Normalization was Left AS/400 and Returned

["Jones, John \(US\)" <John.Jones@xxxxxxxxxx>]

Nice.  Thanks for the correction.  Now, can we can find a zip that
overlaps city boundaries where the cities are named the same? :)

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 Wilt, Charles
Sent: Wednesday, May 04, 2005 1:50 PM
To: Midrange Systems Technical Discussion
Subject: RE: Normalization was Left AS/400 and Returned

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Jones, John (US)
> Sent: Wednesday, May 04, 2005 2:22 PM
> To: Midrange Systems Technical Discussion
> 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
> 

No I don't think so.  There's plenty of examples of a state having
multiple cities with the same name.

http://www.mapquest.com/maps/map.adp?searchtype=address&country=US&addto
history=&searchtab=home&address=&city=MIddletown&state=oh&zipcode=

or http://tinyurl.com/9u3jj



Charles Wilt
iSeries Systems Administrator / Developer Mitsubishi Electric Automotive
America
ph: 513-573-4343
fax: 513-398-1121
 

--
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.