RE: City/State/County Info by Zip Codes

["Sannan Solberg" <SSolberg@xxxxxxxxxxxx>]

Thanks again everyone for the suggestions.  I'll look again at some of the 
links everyone provided.  I've checked out a few of them already. To address a 
couple of the questions that arose.  

1. We actually do have the Vertex Tax software and I've been trying to scour 
around in their data to see if I can find this info in their "geocoding" stuff. 
 I might have to break down and call them.
2. The spanning zipcodes per county is fine.  In fact the file I'm looking to 
fill is setup just that way; you provide a range of zip codes (including +4) 
for each record.
3. I'm actually trying to fill a pre-existing file in JDE/Peoplesoft World 
software that will do a bunch of work for me so I don't have to create my own 
table and do something different.  JDE/Psft does NOT fill this file or have any 
clue who could help us fill it.  Their "address book" module then will look at 
this file when doing some validation of addresses as entered (for 
city/state/county) if you don't type them in yourself.  Nothing fancy but 
serves it's purpose.

-----Original Message-----
From: Jim Franz [mailto:franz400@xxxxxxxxxxxx]
Sent: Wednesday, August 18, 2004 8:45 PM
To: Midrange Systems Technical Discussion
Subject: Re: City/State/County Info by Zip Codes


A note that once you get a database, you will find some zip codes span
multiple counties, and can even span states (in some rural areas along the
Mississippi river, etc). Originally zip codes were handed out to mostly
"states", but later some unused zip codes originally assigned one state were
reassigned to another state (Virginia, Maryland, DC area is one example)
Also, we are not the only country in the world with  5 digit zip codes
(I know we truly have a 5 +4 system, but lots of software deals with only
the 5).
jim
> Beacon Insurance
> 940-720-4672
>