Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!helios!jak9213 From: jak9213@helios.TAMU.EDU (John Kane) Newsgroups: comp.databases Subject: Re: List of Zip Codes with Cities and States Needed Message-ID: <8810@helios.TAMU.EDU> Date: 4 Oct 90 19:47:38 GMT References: <2620@speedy.mcnc.org> <5910010@hpcupt1.HP.COM> <8778@helios.TAMU.EDU> Organization: Texas A&M University Lines: 31 In article <8778@helios.TAMU.EDU> jak9213@helios.TAMU.EDU (John Kane) writes: :>In article <5910010@hpcupt1.HP.COM> jbridges@hpcupt1.HP.COM (Jim Bridges) writes: :>>If you have limited need, there is a list organized alphabetically by :>>state & city in the World Almanac. If you have a way to scan it :>>electronically, the opportunity to develop a database is there! :>I am going to regret this, but I used to get the zip code tapes from :>USPS. I quit getting them a few months ago (when they started charging :>for them). :> :>If someone sends me mail, we can figure out how to get a copy of these :>_huge_ files to them. They are _LARGE_. OK, I must be feeling sorry for folks out here. I took my last tape from the USPS (feb 90) and created a data file that has: ZipCode, RecordType, State, PlaceName, USPSName, CountyNumber, and CountyName. This is a comma seperated file with quotes around the PlaceName, USPSName, and CountyName fields. It is 4MB in size (~83,000 zip codes, what do you expect), BUT ... I have PKZipped it and it is only about 840,000. Sooooo, anyone need it? have a suggestion for a central place for it? a suggestion for distribution? (I hesitate to send it out over the internet, a bit too large, but ...) -- John Arthur Kane, Systems Analyst, Microcomputer Support and Training Texas A&M University, College Station, TX 77843 (409) 845-9999 jak9213@helios.tamu.edu profs: x043jk@tamvm1.tamu.edu