Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sdd.hp.com!caen!ox.com!ox.com!emv From: emv@ox.com (Ed Vielmetti) Newsgroups: comp.databases Subject: Re: Zip-Code => City/State WANTED! Message-ID: Date: 7 Feb 91 20:59:31 GMT References: <1375@pdxgate.UUCP> Sender: usenet@ox.com (Usenet News Administrator) Organization: OTA Limited Partnership, Ann Arbor MI. Lines: 88 In-Reply-To: swansonc@acc.stolaf.edu's message of 6 Feb 91 23:53:55 GMT In article swansonc@acc.stolaf.edu (Chris Swanson, St. Olaf College) writes: If you have access to the Internet, there is a site that has a Geographical database that will do what you want. You might be able to get the data from them. I am not sure of the address, but it is listed in the "Internet Resources Guide" available via ftp from nic.nsf.net and a few other places. martini.eecs.umich.edu, port 3000. here's the help screen. --Ed emv@ox.com # Geographic Name Server, Copyright 1989, 1990 Merit Inc. All rights reserved. # >>> NEW VERSION!!! <<< Use "help" or "?" for details. . help # New version: Wed Mar 14 10:33:50 EST 1990 # # Change summary: # 1) ZIP code queries now supported # 2) ed(1)-style regular expression queries now supported # 3) Query and session timeouts now enabled # 4) Better query parsing, error messages # 5) Response lines now terminated with CRLF instead of just LF # # NOTE: This server is intended for use with clients which interpret # the raw protocol. However, you may also use the server directly # if you don't have the clients. There are currently four clients: # 1) A user agent which pretty-prints the raw protocol and optionally # computes distance and azimuth between any two cities, # 2) A filter for producing input files for Brian Reid's netmap program, # 3) A US map browser which uses the X Window System, # 3) A prototype X-based network browsing tool. # # Data came primarily from the US Geodetic Survey and the US Postal Service. # Coverage includes all US cities, counties, and states, # as well as some US mountains, rivers, lakes, national parks, etc. # A few international cities have also been included. # Unfortunately, some minor inaccuracies remain. Merit Inc. is not responsible # for maintaining this data. # # Queries should generally look like the last line of a postal # address, as in "Ann Arbor, MI 48103". # # All these queries will also work: # 1) ed(1)-style regular expression, like "[Bb]os.*n$" # 2) A city name alone, like "Ann Arbor" # 3) A ZIP or ZIP+4 code alone, like this: "46556", "48103-2112" # NOTE: only the first 5 digits in a ZIP+4 code are used. # 4) As in 1) or 2) but with a state name or abbreviation, like # this: "Ann Arbor, MI", "Los Angeles, California" # 5) As above but with optional nation name or abbreviation, like # "Toronto, , Canada". NOTE: there are currently very few # foreign cities. # # Punctuation, white space, and upper/lower case are ignored. # Any reasonable state/nation abbreviations are recognized. # # Here are more example queries: # # "Ann Arbor, Mich" "48103" "annarbor,mi" "Paris,,France" # "Mammoth Cave National Park" "mount mckinley" "lake michigan" # # If a query fails, try expanding abbreviations (e.g. change "Mt." # to "Mount", etc. # # Interpret server replies as follows: # # 0 # 1 # 2 # 3 # A # E # F # L # P <1980 census population> # R # T