You should try the USGS or the USPS sites. I would expect that either of them might offer a set of standard codes for identifying counties from the US.
Dave -----Original Message----- From: David Blomstrom [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 9:22 PM To: [EMAIL PROTECTED] Subject: Codes for U.S. Counties 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]