RE: Normalization was Left AS/400 and Returned

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

> -----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&addtohistory=&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