RE: Normalization was Left AS/400 and Returned

I can tell you with certainty that zip code 60007 is shared between two cities
(Elk Grove Village and Arlington Heights IL) and two counties (Cook and
DuPage).  Makes sales/use tax calculations fun!

Typical solution is to use GEO codes.  (But then you have to add that attribute
to each entity you have the zip code.)

William

> 
> message: 2
> date: Wed, 4 May 2005 12:18:55 -0600
> from: "Sannan Solberg" <ssolberg@xxxxxxxxxxxx>
> subject: RE: Normalization was Left AS/400 and Returned
> 
> You absolutely CAN have more than one town associated with a zip code.
> County is about the only thing that I can think of that may be "zip
> related" but I understand that that may not even be true.  
> 
> -----Original Message-----
> From: Steve Richter [mailto:stephenrichter@xxxxxxxxx] 
> Sent: Wednesday, May 04, 2005 12: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
>