RE: Codes for U.S. Counties
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]
Re: Codes for U.S. Counties
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]
Re: Codes for U.S. Counties
David, I would recommend you check out the US Census, the USGS, and the USPS. All of those organizations have to deal with county-level information on a daily basis. If anyone has publicly available data (which would include the county codes you seek), they would. You should be able to get to each of their respective sites if you first visit the US Government's portal site at http://www.firstgov.gov. Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine David Blomstrom david_blomstrom@To: [EMAIL PROTECTED] yahoo.com cc: Fax to: 06/02/2004 10:21 Subject: Codes for U.S. Counties PM 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
Re: Codes for U.S. Counties
David Blomstrom wrote: 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. I don't know, but you might ask the folks at: http://www.naco.org/ The National Association of Counties (NACo) =Paul -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Codes for U.S. Counties
--- P. Hill [EMAIL PROTECTED] wrote: David Blomstrom wrote: 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. I don't know, but you might ask the folks at: http://www.naco.org/ The National Association of Counties (NACo) I checked NACO out long ago and decided they're an amateur act. My project is nicer than theirs (though mine isn't online yet). :) __ 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]