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

Tom, Sounds like you are loading into Excel 2000. It is limited to 65,536 rows. It loads successfully into Excel 2007 for me. Dan Seidensticker GIS Specialist Madison Area Transportation Planning Board: A Metropolitan Planning Organization (MPO) City of Madison Planning Unit 121 S. Pinckney Street, Suite 400 Madison, WI 53703 Voice: 608-266-9119 Fax: 608-261-9967 Email: dseidensticker@cityofmadison.com<mailto:dseidensticker@cityofmadison.com> www.MadisonAreaMPO.org<http://www.madisonareampo.org/> From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Tom Mank Sent: Tuesday, August 03, 2010 1:20 PM To: ctpp-news(a)chrispy.net Subject: Re: [CTPP] CTPP2006-2008 County-toCounty work flows are OUT! Liang - I tried downloading by clicking on the MeansofTransportation_v2.csv<ftp://ftp.camsys.com/temp/outgoing/CTPP/New… link (3 times) and I get a error message that says 'file not loaded completely' When I look at the file it has processed as far as Michigan ... Tom Tom Mank Ithaca-Tompkins County Transportation Council 607-274-5583 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(a)camsys.com www.camsys.com

Why are you still using Excel for database ? Import it using MS Access ! Process or filter it and export from Access to Excel. Still using MSO 2003 Hary -----Original Message----- From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Pete Swensson Sent: Tuesday, August 03, 2010 3:24 PM To: ctpp-news(a)chrispy.net Subject: RE: [CTPP] CTPP2006-2008 County-to County work flows are OUT! Or Excel 2002-2003, which has the same limitation. Pete Swensson, Senior Planner Thurston Regional Planning Council 2424 Heritage Ct. SW Olympia, WA 98502 (360) 741-2530 (direct line) (360) 956-7575 (main desk) (360) 956-7815 (fax) swenssp(a)trpc.org This e-mail and any attachments are for the use of the addressed individual. If you have received this e-mail in error, please notify our systems manager. TRPC has taken responsible precautions to ensure no viruses are present in this e-mail, however we do not accept responsibility for loss or damage arising from the use of this e-mail or attachments. From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Seidensticker, Dan Sent: Tuesday, August 03, 2010 12:02 PM To: &#39;ctpp-news(a)chrispy.net&#39; Subject: RE: [CTPP] CTPP2006-2008 County-toCounty work flows are OUT! Tom, Sounds like you are loading into Excel 2000. It is limited to 65,536 rows. It loads successfully into Excel 2007 for me. Dan Seidensticker GIS Specialist Madison Area Transportation Planning Board: A Metropolitan Planning Organization (MPO) City of Madison Planning Unit 121 S. Pinckney Street, Suite 400 Madison, WI 53703 Voice: 608-266-9119 Fax: 608-261-9967 Email: dseidensticker(a)cityofmadison.com www.MadisonAreaMPO.org <http://www.madisonareampo.org/> From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Tom Mank Sent: Tuesday, August 03, 2010 1:20 PM To: ctpp-news(a)chrispy.net Subject: Re: [CTPP] CTPP2006-2008 County-toCounty work flows are OUT! Liang - I tried downloading by clicking on the MeansofTransportation_v2.csv <ftp://ftp.camsys.com/temp/outgoing/CTPP/New%20CTPP%20ACS/MeansofTransportat ion_v2.csv> link (3 times) and I get a error message that says 'file not loaded completely' When I look at the file it has processed as far as Michigan ... Tom Tom Mank Ithaca-Tompkins County Transportation Council 607-274-5583 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

Thank you Peter bob Robert Wood Director Sherman - Denison MPO 1117 Gallagher Dr., Suite 300 Sherman, Texas 75090 Tel: (903) 813-3534 Fax: (903) 813-3539 rwood(a)sdmpo.org www.sdmpo.org On 8/4/2010 9:24 AM, Peter H. Van Demark wrote:

Typically the reason when data is not available like Bike broken out for both data sets and the same geography is that the data was collapsed. The CB uses a statistical test on the data quality for each mode and if the mode does not pass it is collapsed with other modes. when looking at ACS data on factfinder you will find tables starting with a B or C. The C means its a collapsed table. Nordbo, John - DOT wrote: -- Ed Christopher 708-283-3534 (V) 708-574-8131 (cell) FHWA RC-TST-PLN 4749 Lincoln Mall Drive, Suite 600 Matteson, IL 60443

Page 12 of this Census Bureau Compass Report gives some general information on collapsing for statistical reasons. http://www.census.gov/acs/www/Downloads/handbooks/ACSBusinessHandbook.pdf However, little is out there on how the process actually works. Starting on slide 3 of this 2006-7 power point are some details on the mechanics of the process. If you look at these slides ignore slide 2 as the disclosure rules have changed slightly. http://download.ctpp.transportation.org/training/ACS%20data%20issues.ppt Finally If you go to NCHRP Report 588 it says this about what I call statistical collapsing... "Table Variable Collapsing: As for the 2000 CTPP, the Census Bureau expects to apply quality control measures on ACS data products for geographic areas for which categorized tables could be misinterpreted. Any table whose median distribution of covariance for individual cell values is greater than 61 percent will be modified or suppressed for that geography. For example, for a given geography for County X, for a table with 18 means of transportation, individual covariances are calculated for estimates of workers who drove alone, carpooled, etc. If the median of these covariances isgreater than 61 percent, then these modes would be collapsed to fewer categories according to predefined collapsed table definitions. If the median of covariances for the collapsed table still exceeds 61 percent, the table will be suppressed for County X." http://onlinepubs.trb.org/onlinepubs/nchrp/nchrp_rpt_588.pdf Michael Moan wrote: -- Ed Christopher 708-283-3534 (V) 708-574-8131 (cell) FHWA RC-TST-PLN 4749 Lincoln Mall Drive, Suite 600 Matteson, IL 60443