FIPS US states, territories, and possesions codes

Question

FIPS US states, territories, and possesions codes

Dave-3000

SSCertifiable

Points: 6186
More actions
December 7, 2004 at 10:18 am

#361705

Does anyone have a free source for FIPS 6-4? That's the list of US states, territories and possessions and their FIPS codes. The FIPS web site has a text file, but not a downloadable file I can just load up into the database; you gotta type it . Thanks.
There is no "i" in team, but idiot has two.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

if you can see it you can save it :-).

However maybe you mean the file is not formated in a way that can be transfered into the database... because if there's even anything that resemble as delimiter you can use dts to transfer to sql server.

Dave-3000 SSCertifiable Points: 6186 More actions · Answer 2

Yep, that's what I mean. Nothing even close to a delimiter, multiple codes on one line. I was hoping that I wasn't the only one who needs to validate FIPS state and county codes.

There is no "i" in team, but idiot has two.

Antares686 SSC Guru Points: 125444 More actions · Answer 3

Where were you looking becuase to me it is all fixed width datasets and there is a record layout on the first page for FIPS55.

Here is where you can download the most current.

http://geonames.usgs.gov/fips55/fips55down.html

Record layout is here

http://geonames.usgs.gov/layout.html

Robert Stewart Hall of Fame Points: 3399 More actions · Answer 4

If you still need it, email me off the forum and I can send it to you.

rl_stewart@highstream.net

Dave-3000 SSCertifiable Points: 6186 More actions · Answer 5

Thanks, all. Silly me, I was looking for a FIPS standard at the FIPS site, http://www.itl.nist.gov/fipspubs/.

What was I thinking?

There is no "i" in team, but idiot has two.