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 and i suppose you can make it zero but if anybody can
elaborate on this it that would be helpful. I am attaching the actual XLS
file and you can see a screenshot of the file here:
http://picasaweb.google.com/krisviswanathan/ACS_STANDARD_ERROR
TIA,
Krishnan
Probably tomorrow.
-----Original Message-----
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Supin.Yoder(a)dot.gov
Sent: Wednesday, August 04, 2010 12:15 PM
To: ctpp-news(a)chrispy.net
Subject: RE: [CTPP] CTPP2006-2008 County-toCounty work flows are OUT!
Howard, this is great! When will the matrices be available? This will save me some effort to import to TransCAD.
*************************************************
Supin L. Yoder
Travel Demand Forecasting and GIS Specialist
Office of Planning
Federal Highway Administration
Phone: 708-283-3554
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Howard Slavin
Sent: Tuesday, August 03, 2010 3:50 PM
To: ctpp-news(a)chrispy.net
Subject: RE: [CTPP] CTPP2006-2008 County-toCounty work flows are OUT!
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@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
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@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
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.
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
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
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
Job Posting: Transportation Planner 1, Iowa Department of Transportation
The Iowa Department of Transportation (DOT), Office of Systems Planning is seeking a Transportation Planner that will serve on the Traffic Forecasting, Modeling and Highway Planning Team. Responsibilities of this position will focus on assisting with the development of an Asset Management Plan for the department, working on various highway planning projects, supporting travel demand modeling and traffic forecasting work, utilizing Geographic Information System software as well as performing a variety of long-range transportation planning activities for the Department of Transportation.
This position will play a critical role in developing working partnerships among various offices within the Department with the goal to integrate asset management principles and techniques into the transportation planning process and to support programming decisions. This position will assist with various highway planning activities such as analyzing data to support the development of plans and studies.
In addition, this position will assist with work to strengthen and improve the department's urban traffic modeling/forecasting efforts and analytical capabilities using geographic information system software. Additional responsibilities include performing long-range planning activities for highways including capacity analyses, asset management system integration, sufficiency analyses, Census data analysis, etc. Other responsibilities include representing the department and making presentations to MPO and RPA technical committees and policy boards.
Excellent written and verbal communication skills are essential. Shift: Days, Monday thru Friday, 8:00 am - 4:30 pm with flextime available. Travel: Overnight travel not regularly required.
In addition to applying to DAS-HRE, all candidates must submit a resume to:
Iowa Department of Transportation
Office of Systems Planning
Attention: Phil Mescher
800 Lincoln Way
Ames, IA 50010
Minimum Qualifications
Graduation from an accredited college or university course work with a major in civil/transportation engineering, community development planning, economics, environmental engineering, mathematics, regional planning, transportation planning or urban planning.
To Apply:
Submit a completed Iowa Department of Administrative Services - Human Resources Enterprise (DAS-HRE) application form by the closing date (08/05/2010). To complete an electronic application form, click on "Apply for Job Vacancy(s)" button. You may also mail an application form to: Iowa Department of Administrative Services - Human Resources Enterprise, Hoover State Office Building, 1305 East Walnut, Des Moines, IA 50319-0150 or fax your application to (515) 281-7970. http://das.hre.iowa.gov/state_jobs.html
Phillip J. Mescher, AICP
Office of Systems Planning
Iowa Department of Transportation
515-239-1629
Phil.Mescher(a)dot.iowa.gov
Dear Everyone -
We are awaiting the delivery of the first 3-year CTPP using 2006-2008
ACS records. This CTPP is restricted to large geography (county, places
with 20,000 population and over). Our goal was to have web-accessible
data in September 2010, but today we learned that the CB now has a delay
of 2 weeks, which MAY impact the delivery schedule from Beyond 2020 and
Citygate, the CTPP data access software vendors. We will keep you
updated.
In the meantime, you are probably putting together your annual workplans
and I want to remind everyone who plans to submit TAZ (and TADs) for the
5-year CTPP tabulation to include labor hours for Spring and Summer 2011
for this task.
For a copy of the TAZ delineation business rules:
http://download.ctpp.transportation.org/TAZ_Rules/TAZ%20Delineation%20Bu
siness%20Rules_CTPP%20Final.pdf
Q. Do you have to define TAZs or TADs?
A. No, you can still get CTPP tabulations for Census tracts or
Census block groups if you do not want to delineate TAZs.
Q. What is a TAZ and what is a TAD?
A. A TAZ is a Transportation Analysis Zone and is the smallest
geographic unit for which the CTPP tabulations will be provided. A TAD
is a Transportation Analysis District, and will either be an
accumulation of TAZs, or accumulation of tracts, to total approximately
20,000 population. This will provide a geographic unit that is smaller
than a PUMA (100,000 population), and larger than a census tract (4,000
population). The TAD is larger geographic unit which has the potential
to be used in nation-wide tabulations for 3-year ACS tabulations in the
future.
Q. What process will be used to submit TAZs?
A. some of you probably saw the Caliper announcement that they will be
developing the software for the Census Bureau's Geography Division for
this part of the CTPP. It will be a GIS-based application and will not
require you to purchase or license any additional software. It will be
a block-equivalency program. That is, you are restricted to existing
Census-defined blocks. This means that your agency's TAZ for your
forecasting model may not exactly match the TAZ submitted for the CTPP
tabulation.
Elaine Murakami
FHWA Office of Planning
206-220-4460
Hello Everyone -
The 12th National "Tools of the Trade" Conference is scheduled for
September 22-24, 2010 at the Crowne Plaza at Fort Magruder in Historic
Williamsburg. On Sept 22, the CTPP team is hosting a Federal Data
workshop where we will discuss 2010 Census, ACS, CTPP and NHTS, so I
hope to see you there. If you don't know what all those acronyms are,
you should definitely plan to attend! J
The preliminary program for the conference is posted on the TRB
Committee website
http://www.trbtoolsofthetrade.org/pdf/conf/2010/DraftProgram_May24_2010.
pdf
REGISTRATION IS NOW OPEN!
The following is a link to registration on the internet:
https://www.regonline.com/ToolsoftheTradeConference
<https://www.regonline.com/ToolsoftheTradeConference>
Please come to this conference to learn ready-to-use, economical and
practical techniques for transportation professionals in small (under
50,000) and medium-sized (50,000 - 250,000) communities. Advance
registration is only $200.00 and includes most meals and the group
outing in Colonial Williamsburg on Thursday night during the Conference.
For additional information, please contact Marsha Fiol, Virginia
Department of Transportation Phone 804 786-2985, E-mail:
Marsha.Fiol(a)VDOT.Virginia.gov <mailto:Marsha.Fiol@VDOT.Virginia.gov>
http://www.trbtoolsofthetrade.org/ <http://www.trbtoolsofthetrade.org/>
Elaine Murakami
206-220-4460