RE: City/State/County Info by Zip Codes

[ron_adams@xxxxxxxxxxxxxx]

It's been a while since I've used the Vertex software, but I do seem to
remember that their database contains a good bit of Zip code info that you
may be able to utilize.

Ron Adams
Information Technology Group
Crane Valves
9200 New Trails Dr. Suite 200
The Woodlands, TX 77385
Office: 281-298-5463 x104
Direct: 281-465-3054
Cell: 281-216-7721



|---------+------------------------------->
|         |           "Sannan Solberg"    |
|         |           <SSolberg@xxxxxxxxxx|
|         |           om>                 |
|         |           Sent by:            |
|         |           midrange-l-bounces@m|
|         |           idrange.com         |
|         |                               |
|         |                               |
|         |           08/19/2004 09:30 AM |
|         |           Please respond to   |
|         |           Midrange Systems    |
|         |           Technical Discussion|
|         |                               |
|---------+------------------------------->
  
>-------------------------------------------------------------------------------------------------------------------|
  |                                                                             
                                      |
  |       To:       "Midrange Systems Technical Discussion" 
<midrange-l@xxxxxxxxxxxx>                                 |
  |       cc:                                                                   
                                      |
  |       Fax to:                                                               
                                      |
  |       Subject:  RE: City/State/County Info by Zip Codes                     
                                      |
  
>-------------------------------------------------------------------------------------------------------------------|




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
>

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