Yes, we are very happy that the Census Bureau has delivered the 3-year CTPP (2006-2008 ACS) to us.  As you all know, the CTPP includes many tables, I believe over 200.  I am too lazy to figure out the exact count.

Here is a link to the table list: http://ctpp.transportation.org/Pages/ACSData.aspx

I knew that the county-to-county flow table is of high interest, so Liang Long, who is our CTPP Tech Support staff, prepared this data, which for your convenience includes CTPP2000 results.   

There are over 200,000 county-to-county pairs, so if you want to open this in Excel, you need to use Microsoft Office 2007, otherwise you will run over the record limit.  You will see the “swiss cheese” nature of the data, since the 2006-2008 tabulations are subject to the 20,000 population threshold for 3-year ACS data. 

AASHTO’s data access software vendor, Beyond 2020 and Citygate have now received the FULL component of data (5 DVDs), and a CTPP subcommittee will be reviewing an early version of the software that is due on August 4.   The vendor was limited in their development because the Census Bureau gave them blank table shells and they did not have any test data for the development process, until they received the DVDs a week ago.  Beyond 2020 is expected to finalize the software in September, but since the CB’s data delivery was about 2.5 weeks delayed, we don’t get yet know if the software will also be delayed.

In August, Liang is going to be very busy working on updating the TAZ responsibility spreadsheets, as we need to deliver the list to the Census Bureau Geography Division very soon.  But, depending on how that goes, I will see if she has time to make a Place-to-Place flow tabulation similar to the County-to-County flow tab, but this will definitely make you crazy with the “swiss cheese” nature of the results. 

Elaine Murakami

FHWA Office of Planning

206-220-4460

(I will be out of the office from August 2-4)

From: Liang Long [mailto:LLong@camsys.com]
Sent: Friday, July 30, 2010 1:59 PM
To: ctpp-news@chrispy.net
Cc: Murakami, Elaine (FHWA); edc@berwyned.com; pweinberger@aashto.org
Subject: CTPP2006-2008 County-toCounty work flows are OUT!

Hi,

We are pound to announce that CTPP2006-2008 County-toCounty flows using ACS are available for downloading now!  The data file also contains CTPP2000 County-to-county flow for users convenience.  Two data formats are available: SAS and CVS.  A detailed note for dataset  is also available.

Check it out now!

ftp://ftp.camsys.com/temp/outgoing/CTPP/New%20CTPP%20ACS/

Liang Long
Cambridge Systematics, Inc.
4800 Hampden Lane
Suite 800
Bethesda, MD 20814
tel  301 347 9141
fax 301 347 0101
FHWA 202-366-6971
e-mail  llong@camsys.com
www.camsys.com