Post reply

FIPS US states, territories, and possesions codes

  • 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.

  • December 7, 2004 at 11:24 am

    #532885

    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.

  • December 7, 2004 at 3:13 pm

    #532926

    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.

  • December 7, 2004 at 3:31 pm

    #532930

    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

  • December 8, 2004 at 1:17 pm

    #533096

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

    rl_stewart@highstream.net

  • December 13, 2004 at 11:32 am

    #533605

    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.

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

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