I don't know if this will help, but I had these links left over from some work I did a few years ago...
http://www.itl.nist.gov/fipspubs/fip6-4.htm http://www.itl.nist.gov/fipspubs/co-codes/states.htm On Wed, 2 Jun 2004, David Blomstrom wrote: > I have a big database focusing on U.S. counties. I'd > like to assign each county a code for use as a key. > I'm thinking of simply using the state postal code, > followed by numerals. > > For example, Arizona's counties would be arranged > alphabetically, beginning with az1, az2, az3, etc. > > I just wondered if anyone on this list has worked with > counties in databases and is aware of a pre-existing > code system that's in fairly wide use. It would be > nice to make a database that's compatible with other > databases, if they share a common code for counties. > > Thanks. > > > > > > __________________________________ > Do you Yahoo!? > Friends. Fun. Try the all-new Yahoo! Messenger. > http://messenger.yahoo.com/ > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]