Re: Availability of Zipcode listing to upload to Informix DBS

In article <1994Feb1.192450.26017@ringer.cs.utsa.edu> whitaker@lonestar.utsa.edu (Kevin T. Whitaker) writes: >In article <zorbaCKK35A.2JJ@netcom.com>, Harry Skelton wrote: >> You have only to look towards your local post office. > When I do, all I get are vacant, vaguely hostile stares. :-( > I would be interested in acquiring the same kind of data - don't need >9 digit but that would be nice. I'd like to be able to validate at least >the city, state, zip combination on data entry. > > I would also be interested in acquiring a data base that would allow >me to cross a city name field from an address to the county (or county-code) >in which it is located. Somewhere inn the SIMTEL archives (now available at places like oak.oakland.edu) there was a datafile of zipcodes, cities and states. (Note that at one time, at least, there was a stand-alone PC binary program at Simtel that did this as well). It's been a while since I played around with it, but essentially you dezip the file (into ascii) and then load it (appropriately defined) into a database table. Even if you do not have a PC, "unzip", etc., under UNIX should still result in a loadable ascii data file. Be warned that this is not a small amount of data....