CTPP August 2010

ctpp@listserv.transportation.org

19 participants
16 discussions

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

by Howard Slavin

Tom, Caliper will be providing a free download of the data in the form of TransCAD matrices and ESRI geodatabases which should be more convenient for many people. Howard Howard Slavin, Ph.D. President Caliper Corporation -----Original Message----- From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Tom Mank Sent: Tuesday, August 03, 2010 2: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 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 >>> Liang Long <LLong(a)camsys.com> 7/30/2010 4:58 PM >>> 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

14 years, 12 months

[CTPP] Where is the CTPP Program with the CTPP Data Access Software?

by Weinberger

Hi All, An Update. The 2006 - 2008 ACS data have been released by the US Census Bureau (CB) and the CTPP Special Tabulation has been developed and delivered. (for the table list see: http://ctpp.transportation.org/Pages/ACSData.aspx) This data set is the one we (the CTPP Program) are using to develop the first CTPP product based on three year ACS Data. In the next few months, I will try to keep this community apprised of our progress on developing and releasing the data access software for the CTPP based on three year ACS special tabulation that we purchased from CB. We issued an RFP in June of 2009 with proposals due late July. The contract was ultimate awarded to the Beyond 20/20 Citygate team. Work commenced on software development in January 2010. The preliminary software has gone through one round of alpha testing, with beta originally scheduled to be the next round. It was decided after alpha testing that another intermediate round of user testing should occur when the software had greater functionality, but was still in a flexible, malleable state. The project is nearly ready for the next round of user testing, identified as "alpha-prime". The purpose of this round of testing is to highlight the changes so far and to elicit feedback from users. Beyond 20/20 has received and started processing the data from ACS. This data was due to be delivered by 30-Jun, but the final tables were not received until 28-Jul. Sample data was provided by mid-June, so Beyond 20/20 has been able to use this to continue development of the data processing logic and for testing. The data in the first set of delivered tables will be part of the alpha-prime testing. Work on the additional features and customization is nearly complete, with all functionality in the alpha-prime testing, except the export to shape files (currently under development) and the thematic mapping. Work on the Session Editor, the customization that will allow users to select geographies from a map, is still in progress. It is essentially functionally complete, but there are still many issues to be resolved. A significant outstanding issue is how the Part 3 data will be represented both in the Session Editor and in the tables themselves. Based on input from CTPP, it appears that there will need to be data available for Part 3 in which the flows are represented in two dimensions (residence and workplace), but it may also be necessary to have a version with a single dimension for those users who do not need to have them split. The alpha-prime will demonstrate both approaches and the final decision on how to represent the data will be made based on feedback from this testing. The next contracted milestone is delivery of the beta release of the package. There has been a request by CTPP for a new piece of functionality to be added to the solution: export to Geodatabase format. This format contains similar information to SHP files, but is stored in a more up-to-date format in a Microsoft Access database. Beyond 20/20 and Citygate are working on a proposal that will identify the additional cost/time required to add this. I will send another update in a few weeks, if you have any questions, do not hesitate to contact me on or off list. Penelope Weinberger CTPP Program Manager AASHTO 202-624-3556 http://ctpp.transportation.org/Pages/default.aspx <http://ctpp.transportation.org/Pages/default.aspx> <http://www.transportation.org> It's just as bad to not make a plan as to blindly follow the one you already have.

14 years, 12 months

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

by Pete Swensson

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(a)chrispy.net] On Behalf Of Seidensticker, Dan Sent: Tuesday, August 03, 2010 12:02 PM To: 'ctpp-news(a)chrispy.net' 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(a)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/MeansofTranspo rtation_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 >>> Liang Long <LLong(a)camsys.com> 7/30/2010 4:58 PM >>> 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

14 years, 12 months

[CTPP] What to do when steps in Standard Error Calculations return Negative Numbers

by Krishnan Viswanathan

Apologies for using this forum but I figured this might be appropriate. I am trying to get the upper and lower bound at the 90% CI around shares of people who live and work in Palm Beach County and who live in PB County but work outside PB county. I am using 1 year ACS data from 2008 and am using table B08007. I am getting a negative number under the square root term and obviously it cannot calculate SE. Anyone has pointers for a workaround or what you did when faced with something like this? I doubt if it can deal with imaginary numbers but if there are any statisticians who can elaborate that would be helpful. I am attaching a screenshot of the error along with the actual XLS file. TIA, Krishnan [image: se_error.jpg] -- Krishnan Viswanathan 1101 High Meadow Dr Tallahassee FL 32311

14 years, 12 months

[CTPP] Transportation Planner for Madison WI MPO Job Announcement

by Schaefer

Transportation Planner (Planner 3) City of Madison Planning Division Staff for the Madison WI Area Metropolitan Planning Organization (MPO) This is responsible advanced-level professional urban and regional transportation planning work within the Transportation Planning Section of the City of Madison Planning Division, providing support for the Madison Area Transportation Planning Board (Metropolitan Planning Organization, MPO). Two years of professional planning experience comparable to that gained as a Planner 2 with the City of Madison (that is two years of professional planning experience following three years of experience in related areas). Such experience would normally be gained after graduation from an accredited college or university with a degree in Urban Studies, Urban and Regional Planning, Engineering, or other related studies or programs. Other combinations of training and/or experience which can be demonstrated to result in the possession of the knowledge, skills, and abilities necessary to perform the duties of this position will also be considered. City of Madison job application form must be received no later than 4:30 p.m. on August 31, 2010. See the following link for the job announcement: Website: http://www.cityofmadison.com/employment/employmentListingDetails.cfm?Id=531 Bill Schaefer, Transportation Planning Manager Madison Area Transportation Planning Board - An MPO 121 S. Pinckney St., #400 Madison, WI 53703 PH: (608) 266-9115 FAX: (608) 261-9967

14 years, 12 months

[CTPP] Duplicate records issue in CTPP2006-2008 County-to-County flow data have been FIXED.

by Liang Long

Thanks for Ed Christopher and other people catching the duplicate records issue in the County-to-County data that I sent out last Friday. We have fixed the issue and the new data has been uploaded this morning. 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

15 years

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

1999

1998

CTPP August 2010