Re: City/State/County Info by Zip Codes

Hi Sannan,

> What I'm really shooting to find is a resource that has zipcodes
> (preferably ranges of zip codes) with City/State/County information for
> each zip (or range of zips).  I only need the US and just want to do
> this as a "one time" thing.
[SNIP]
> Can anyone suggest where I might find such a (free) resource?  I'll take
> it just about any flavor (txt, excel, access, db2 table, etc.) and
> massage it to get it into my table.

We use software from WorksRight Software, and it works well -- but it's
not free.

The only free resource that I know of the US Postal Service's WebTools.
with WebTools, you can create an XML request and send it to the USPS web
server.  In that request, you send a zip code, and it returns the city and
state)

(You can do other things, like find a zip code based on the address, etc)

It would be possible to invoke this request from an RPG program using
HTTPAPI, my open source HTTP software for RPG programmers.  You can find
it here:
   http://www.scottklement.com/httpapi/

In fact, I may do a session on that at RPG World (http://www.rpgworld.com)
though, we haven't made that decision yet.  (I really need to talk to them
and sort that out, I'm running out of time!)

Anyway... that's the only free resource that I'm aware of.  If you find
something else, please clue me in :)