RE: Normalization was Left AS/400 and Returned

Make that 1000+ PO boxes.  Stupid el-cheapo keyboard...

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 Jones, John (US)
Sent: Wednesday, May 04, 2005 1:58 PM
To: Midrange Systems Technical Discussion
Subject: RE: Normalization was Left AS/400 and Returned

Regarding zip+4, the extra 4 digits can also be a PO box number (PO Box
102 would be represented by xxxxx-0102).  I don't know if the USPS
refrains from overlap between street addresses and PO boxes or not.  I
don't see how it logically can, since it's not too dificult to have 100+
PO boxes in a single zip.  And a zip that large would likely have many
unique addresses as well.

So do rural routes/stops impact this discussion as well?

Maybe it's just plain easier to store c/s/z.  Plus, it probably makes
storing international addresses in the same db easier as they should map
to city/province/postal code.

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



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.