ge@mcnc.org (George Entenman) (10/02/90)
I need a list which matches zip codes with their corresponding cities and states. Is there such a list in the public domain or available inexpensively from a commercial source? Any help will be appreciated. ########################################################################## # # # George Entenman (ge@mcnc.org) # # The Microelectronics Center of North Carolina # # P.O. Box 12889 # # Research Triangle Park, NC 27709-2889 # # 919/248-1953 # # 919/248-1455 (fax) # # # ##########################################################################
nolan@tssi.UUCP (Michael Nolan) (10/02/90)
In article <2620@speedy.mcnc.org> ge@mcnc.org (George Entenman) writes: > >I need a list which matches zip codes with their corresponding cities >and states. Is there such a list in the public domain or available >inexpensively from a commercial source? Any help will be appreciated. Have you checked with the Post Office? They provide such a service. I just checked, and this data is available on a quarterly or monthly basis, on 1/2 inch magnetic tape (1600 or 6250) and on 3480 tape cartridge. There is a charge of $350 for a year's subscription. (This charge is the same for either monthly or quarterly, which doesn't make much sense, but then again we are talking about the Post Office here, aren't we. ;-} ) Since the Post Office (oops, Postal Service) is always changing, adding, and deleting zip codes, this information is usually substantially more up-to-date than that available from commercial services. The file gives all valid zip codes, the city and 'place name', the state, and the FIPS county code. (A 'place name' is when an area is known by more than one city name; such as Manhattan for New York City.) There are around 80,000 valid zip codes on this file. Contact: National Address Information Center 6060 Primacy Pky Ste 101 Memphis TN 38188-0001 800-238-3150 X 80 (From Tennesee 800-233-0453) PS. I understand that there is a similar file available from the National Bureau of Standards and/or the Census Bureau, but I don't have this information readily at hand. There are six other addressing data files available from the Postal Service, as well. ------------------------------------------------------------------------------ Mike Nolan "To err is human, to forgive Tailored Software Services, Inc. is divine, to procrastinate is, Lincoln, Nebraska (402) 423-1490 um, can I get back to you on that?" UUCP: tssi!nolan (feed site changed, dsndata!tssi!nolan might be better) INTERNET: nolan@pythia.unl.edu (only if the other address doesn't work)
jbridges@hpcupt1.HP.COM (Jim Bridges) (10/03/90)
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!
jak9213@helios.TAMU.EDU (John Kane) (10/04/90)
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_. -- 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
randall@informix.com (Randall Rhea) (10/04/90)
In article <2620@speedy.mcnc.org> ge@mcnc.org (George Entenman) writes: > >I need a list which matches zip codes with their corresponding cities >and states. Is there such a list in the public domain or available >inexpensively from a commercial source? Any help will be appreciated. > A couple of years ago, the US Post Office was giving away this information on magnetic tape for free. I believe that they still are. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Randall Rhea Informix Software, Inc. Senior Programmer/Analyst, MIS uunet!pyramid!infmx!randall
larrys@crg5.UUCP (Larry Scheurich) (10/05/90)
> >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_. > >-- > 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 We use a company called Vertex to get tax rates of cities, counties, and states (along with countires like Puerto Rico). They're really reliable, and my users have informed me that the rates are always accurate. They're from the Philadelphia area, and they send out updates once a month. -- Larry Scheurich uunet!sequent!larrys Financial Systems Analyst Sequent Computer Systems (503)-526-4240 Beaverton, OR "Smile, it makes people wonder what you're up to"
jak9213@helios.TAMU.EDU (John Kane) (10/05/90)
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
jak9213@helios.TAMU.EDU (John Kane) (10/07/90)
In article <1990Oct4.012938.25021@informix.com> randall@informix.com (Randall Rhea) writes: >In article <2620@speedy.mcnc.org> ge@mcnc.org (George Entenman) writes: [ ... deleted ... ] >A couple of years ago, the US Post Office was giving away this information >on magnetic tape for free. I believe that they still are. The USPS _was_ doing this, I used to get this subscription. It must have cost too much to keep doing this because in March (I think it was March) you had to start paying for the tapes (about $300 a year?) or you stopped getting them. Guess it is only fair. -- 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
jpr@jpradley.uucp (Jean-Pierre Radley) (10/09/90)
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! Such a database exists, written in filePro by Bob Snapp, whom you may contact at: 6962 Plainfield Road Cincinnati, OH 45236 513-891-4496 -- Jean-Pierre Radley HIGH-Q jpr@jpradley CIS: 72160.1341
ampah@swpyr2.sbc.com (Paul Herzog) (10/10/90)
In article <1990Oct4.012938.25021@informix.com> randall@informix.com (Randall Rhea) writes: >In article <2620@speedy.mcnc.org> ge@mcnc.org (George Entenman) writes: >> >>I need a list which matches zip codes with their corresponding cities >>and states. Is there such a list in the public domain or available >>inexpensively from a commercial source? Any help will be appreciated. >> > >A couple of years ago, the US Post Office was giving away this information >on magnetic tape for free. I believe that they still are. Sorry, it is no longer free. For the entire USA and territories the cost is about $1600. You can get selected states with a minimum of about $900 (? this price I'm unsure). And we are talking about IBM format, 6250 bpi, 9-track tapes; costs can be more for other formats. > >-- >=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= >Randall Rhea Informix Software, Inc. >Senior Programmer/Analyst, MIS uunet!pyramid!infmx!randall -- Paul Herzog VOICE : 314-235-8025 One Bell Center RM 30F7 UUCP : uunet!swbatl!swpyr2!ampah Southwestern Bell INTERNET: ampah@swpyr2.sbc.com St. Louis, MO 63050
jwi@cbnewsj.att.com (Jim Winer @ AT&T, Middletown, NJ) (10/11/90)
> >In article <2620@speedy.mcnc.org> ge@mcnc.org (George Entenman) writes: > >>I need a list which matches zip codes with their corresponding cities > >>and states. Is there such a list in the public domain or available > >>inexpensively from a commercial source? Any help will be appreciated. PC-ZIP QZIP Find closest office to customer address RZIP Find all zips in a radius from given EZIP Verify city/state against zip or auto enter city/state given zip $190.00 Extra for twice yearly updates of new zip codes This and lots of other zip code stuff for various machines available from: Melissa Data Company 32118 Paseo Adelanto #8 Jan Juan Capistrano, CA 92675 (714) 661-5885 Free catalog on request They also have an 800 number, but it's not on their free catalog. Call 800-555-1212. No affiliation, just mutual interest. Jim Winer -- jwi@mtfme.att.com -- Opinions not represent employer. ------------------------------------------------------------------ "No, no: the purpose of language is to cast spells on other people ..." Lisa S Chabot