Thanks for pointing this out. So our users can be aware of that for the FIPS codes
variables, there is no preceding zero.
Actually, I did this on purpose. I like the way to keep FIPS code to number, not
characters. In this way, the first 0 got dropped of course. The reason I don't like
keep FIPS code as characters is that when you import the data into SAS or other
statistical software, you easily get lots of blank spaces before and after the value and
when merging it with other files using FIPS code, it cause lots of tourble.
From: ctpp-news-bounces(a)chrispy.net [ctpp-news-bounces(a)chrispy.net] on behalf of Catala,
Sent: Monday, February 10, 2014 10:49 AM
Subject: Re: [CTPP] CTPP 2006-2010 Nationwide County Flow File is available!
FYI I think there is something off with the file.
It seems when I import the file into mysql OR open it in note pad the county FIPS code is
truncated for Alabama
Autauga county FIPS should be 01001 instead of 1001.
We are able to work around this with a few clever SQL statements but for others it might
present a challenge.
From: ctpp-news-bounces(a)chrispy.net [mailto:email@example.com] On Behalf Of
Sent: Friday, February 07, 2014 4:44 PM
Subject: [CTPP] CTPP 2006-2010 Nationwide County Flow File is available!
We have developed this county flow file from CTPP 2006-2010. The file includes flows by
means of transportation from CTPP 2000, CTPP 2006-2008 and CTPP 2006-2010. Margin of Error
is also included for CTPP 2006-2010 and CTPP 2006-2008. The readme file is also provided.
You can download the data in CSV format from the following link:
Please note the username and password are case sensitive.
Cambridge Systematics, Inc.
4800 Hampden Lane
Bethesda, MD 20814
tel 301 347 0100
fax 301 347 0101