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@chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Liang Long
Sent: Friday, February 07, 2014 4:44 PM
To: ctpp-news@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
www.camsys.com