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.comwww.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.comwww.camsys.com
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.comwww.camsys.com
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(a)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.comwww.camsys.com
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.comwww.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
Yes, these are the business rules agreed upon by AASHTO and the Census
Bureau Geog division.
-----Original Message-----
From: ctpp-news-bounces(a)chrispy.net
[mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Paul Tiley
Sent: Monday, July 12, 2010 12:30 PM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] TAZ delineation in Calendar 2011
Elaine,
I hadn't heard anything about the Business Rules being finalized. Are
the rules at the URL below the finalized rules?
Paul Tiley
TXDOT TPP
My Email address is changing to Paul.Tiley(a)txdot.gov by early August.
>>> <Elaine.Murakami(a)dot.gov> 7/8/2010 3:59 PM >>>
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
=====================
TxDOT is going Green to keep our air clean.
Find out how at
www.drivecleanacrosstexas.org
_______________________________________________
ctpp-news mailing list
ctpp-news(a)chrispy.nethttp://www.chrispy.net/mailman/listinfo/ctpp-news
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(a)VDOT.Virginia.gov>
http://www.trbtoolsofthetrade.org/ <http://www.trbtoolsofthetrade.org/>
Elaine Murakami
206-220-4460