[CTPP] RE: CTPP2006-2008 County-toCounty work flows are OUT!

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(a)chrispy.net Cc: Murakami, Elaine (FHWA); edc(a)berwyned.com; pweinberger(a)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/ <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(a)camsys.com www.camsys.com