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, Martin [catala(a)cutr.usf.edu] Sent: Monday, February 10, 2014 10:49 AM To: ctpp-news(a)chrispy.net Subject: Re: [CTPP] CTPP 2006-2010 Nationwide County Flow File is available! Thanks 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. Thanks again. From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Liang Long Sent: Friday, February 07, 2014 4:44 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] CTPP 2006-2010 Nationwide County Flow File is available! Hi, all 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: ftp://ftp.camsys.com/clientsupport/CTPPdata/County%20Flows/MOT/ Username: 8305CTPP Password: 1900NJA Please note the username and password are case sensitive. Enjoy! Liang Long Cambridge Systematics, Inc. 4800 Hampden Lane Suite 800 Bethesda, MD 20814 tel 301 347 0100 fax 301 347 0101 FHWA 202-366-6971 e-mail llong@camsys.com<mailto:llong@camsys.com> www.camsys.com