]
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
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.
cc:
Fax to:
06/02/2004 10:21 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
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
--- 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