Here is the challenge! I do not know how to do IPF, but I know that many
of you out there can do it!
Attached are: ACS B08101 ; ACS B08006 for Maricopa County Arizona.
You can ignore the MOE cells for this IPF challenge.
Also attached is a 3-way tabulation using IPUMS for Maricopa County AZ.
All are using 2009 ACS.
You will note that carpool is not broken out, as the question is really
in 2 parts (what mode, and then how many people), so this table could be
re-done by creating a carpool variable, if you wanted.
We have an archived webinar on using IPUMS, if you are interested in
making your own tabs using ACS PUMS.
http://ctpp.transportation.org/Pages/webinardirectory.aspx
Elaine
-----Original Message-----
From: ctpp-news-bounces(a)chrispy.net
[mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Erlbaum, Nathan
(DOT)
Sent: Friday, March 11, 2011 11:42 AM
To: ctpp-news(a)chrispy.net
Subject: RE: [CTPP] 2010 Data Release Watch
Noted below is a question and a response that appeared on the list serve
earlier today and that suggests a solution method to creating data that
almost exists but is needed. I am reposting this to the list serve,
because I believe that this might be a worthwhile effort for someone who
is adept and familiar with IPF to provide a valuable resources to the
CTPP community in much the same way the ACS MOE spreadsheets have
evolved to explain how to deal with this statistical concept in an easy
to use way for the practitioner.
Recently there was a post to the listserve by Jonnette Kreideweis about
the Census Conference in California and the call for papers. There was
also a recent post about the Planning Methods Conference.
A spreadsheet that would answer the question posed is potentially a good
basis for a paper. Further it helps share skills with the larger
practitioner community based upon solutions and techniques that others
have implemented. When presented and discussed on a listserve then
many more people perhaps those who might never consider this as an
option may now have a solution to the very same problem or may move on
to adapt the method to other analysis areas.
I want to encourage anyone who has the time to give it a try, maybe a
student can use this to apply what they have learned, or a modeler can
cannibalize something he/she has already used, many may benefit from you
efforts.
----------------------------------------------------------
Nathan Erlbaum
Associate Transportation Analyst
Office of Policy, Planning & Performance New York State Department of
Transportation 50 Wolf Road, 6th Floor Albany, New York 12232
(Tel) 518.457.2967
(Fax) 518.457.4944
(E-mail) nerlbaum(a)dot.state.ny.us
(Web) www.nysdot.gov
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Marcus Wigan wrote:
> ed
>
> a terribly simple question
>
> How best to do age group by gender by travel on the CTTP!
> best
> marc
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Ed Christopher's response:
Unfortunately, there is no clean way to get Age by Gender by Mode (Means
of travel), that I know about, directly out of the current 3-year CTPP
data product nor the Standard Census ACS products for that matter.
However, there are some options that will get you close but they will
take a little work.
Option 1. In CTPP take table 12201 ( Age by Mode to work) and table
11203 (Age by Sex/gender)and run an IPF (Iterative Proportional
Fitting-fratar) routine between the two tables to get what you want. At
least I think it will work.
Option 2. Do the same with standard ACS product tables B08006 (Sex by
Mode) and B08101 (Mode by Age). If you go this route I think these
tables may even exist in the 5-year ACS so you could do it at smaller
than Places over 20K population geography.
Option 3. Just make your table using the PUMS data but you would be
limited to geographical areas of over 100K people.
Over the years we has suggested that people use an IPF routine to make
tables that might not exist in the various data products. I would be
interested in hearing if anyone has actually done it. Have you?
Next week the Census Bureau is poised to release the local-level 2010
Census population counts for Alaska, Florida, Georgia, Kentucky,
Minnesota, Montana, New Mexico, North Dakota and Tennessee.
Based on a quick and cursory review that leaves only MI, SC, WV, NY, MA,
NH,ME,RI and PR.
http://2010.census.gov/2010census/data/
--
Ed Christopher
708-283-3534 (V)
708-574-8131 (cell)
FHWA RC-TST-PLN
4749 Lincoln Mall Drive, Suite 600
Matteson, IL 60443
To the MPOs and State DOTs who are working on TAZ and TAD delineation
for 2006-2010 CTPP:
Just a reminder that you have approximately 3-5 weeks to complete your
work. I hope that the work is progressing well.
If you have questions about the software, please contact the Census
Bureau Geography Division at 301-763-1099, or via email
geo.taz.list(a)census.gov
And thank you to all of you who have ALREADY completed this task and
returned files to the Census Bureau.
Elaine Murakami
FHWA Office of Planning
206-220-4460
600 pop or workers. Just finished 5 counties.
Hanna Cockburn
Planning Program Manager
Piedmont Triad Council of Governments
by blackberry
----- Original Message -----
From: ctpp-news-bounces(a)chrispy.net <ctpp-news-bounces(a)chrispy.net>
To: ctpp-news(a)chrispy.net <ctpp-news(a)chrispy.net>
Sent: Fri May 27 17:28:29 2011
Subject: Re: [CTPP] REMINDER: TAZ files to be returned to Census Bureaubetween June 17 and 30
What is the site for taz?
Thanks,
Dloug
On Thu, May 26, 2011 at 11:29 AM, <Elaine.Murakami(a)dot.gov> wrote:
To the MPOs and State DOTs who are working on TAZ and TAD delineation for 2006-2010 CTPP:
Just a reminder that you have approximately 3-5 weeks to complete your work. I hope that the work is progressing well.
If you have questions about the software, please contact the Census Bureau Geography Division at 301-763-1099, or via email geo.taz.list(a)census.gov
And thank you to all of you who have ALREADY completed this task and returned files to the Census Bureau.
Elaine Murakami
FHWA Office of Planning
206-220-4460
_______________________________________________
ctpp-news mailing list
ctpp-news(a)chrispy.nethttp://www.chrispy.net/mailman/listinfo/ctpp-news
Hi, all
We attended a Census Bureau American Factfinder 2 and DataFerrett training May 24 and were informed that the Census Bureau is offering toll free numbers for help. I have attached the contact information below and if you have any questions about AFF2 and DataFerrett, you can contact the Census Bureau directly.
American Factfinder 2 : 1-800-923-8282
Data Ferrett: 1-866-437-0171 Email: dsd.ferrett(a)census.gov
Enjoy!
Liang Long
Federal Highway Administration
Room 74-440
1200 New Jersey, SE
Washington, DC 20590
tel 202 366 6971
fax 202 493 2198
e-mail liang.long(a)dot.gov <mailto:liang.long(a)dot.gov>
On May 23rd USDOT hosted a forum on transportation and demographic
changes over the last decade. The 3-hour webcast including the
presenter slides will be available at the link
below for the next six months.
http://mediasite.yorkcast.com/webcast/Viewer/?peid=17f98d9e1a2743a1a9c24b3d…
The forum was keynoted by Census Director Robert Groves and featured
William Frey and other leading experts. The forum discussed demographic
trends from the recently released 2010 census. As expected demographic
shifts will have a profound effect on the demand for transportation in
coming years. Panels members also examined the transportation
implications for urban and rural populations, disability, migration,
race, immigration and more.
Speakers and Panelists included:
Dr. Robert Groves, U.S. Census
Dr. William Frey, Brookings Institution
Dr. Mark Hugo Lopez, Pew Hispanic Center
Dr. Barbara Altman, National Center for Health Statistics
Dr. John Cromartie, U.S. Department of Agriculture
Dr. Johanna Zmud, Rand Corporation
Dr. Richard Marottoli, Yale University
Beth Jarosz, San Diego Association of Governments
Michael Alexander, Atlanta Regional Commission
----
Ed Christopher
708-283-3534 (V)
708-574-8131 (cell)
FHWA RC-TST-PLN
4749 Lincoln Mall Drive, Suite 600
Matteson, IL 60443
Please follow the directions on this page to unsubscribe, or change your
listserv preferences.
http://www.chrispy.net/mailman/listinfo/ctpp-news
From: ctpp-news-bounces(a)chrispy.net
[mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Dennis Hooker
Sent: Wednesday, May 25, 2011 9:36 AM
To: ctpp-news(a)chrispy.net
Subject: RE: [CTPP] taz delineation
How can I get off this list
From: ctpp-news-bounces(a)chrispy.net
[mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of
Elaine.Murakami(a)dot.gov
Sent: Wednesday, May 25, 2011 12:30 PM
To: ctpp-news(a)chrispy.net
Subject: RE: [CTPP] taz delineation
Here are some questions to ask yourself:
1. How much growth (residential population and employment) has
occurred and WHERE. If there is a lot of growth, you should make new
TAZs and not worry about keeping the same geography.
2. How big or small were the TAZs for CTPP 2000? (In a few cases
nationwide in 2000, the TAZs were very very small and the results were
probably not reliable). We have never controlled the size of TAZs, and
even this time, it is a suggested threshold, not a firm threshold. The
software allows you to define very small TAZs, but gives you a warning.
You probably DON'T want to compare TAZ-to-TAZ flows between 2000 and the
2006-2010. Most likely, I think that people will use the 2006-2010 CTPP
TAZ-to-TAZ flows as a validation data source for their travel demand
model. And in some cases, will use an adjusted TAZ-to-TAZ flow as inputs
into HB-Work trips (after accounting for the fact that this represents
only the journey-TO-work).
For comparing between the 2 timeframes, one which is point-in-time and
the other a "period estimate", given the ACS sample size, you would be
better off to make SuperTAZs (combinations of TAZs) to do the
comparison.
The UNWEIGHTED sample size after five years of ACS data collection
(2006-2010) is about one-half the sample size from the Census 2000 long
form, therefore the margin of error is much higher.
We are asking MPOs (and State DOTs) to also define TADs, which is
another word for a Super TAZs, using a minimum of 20,000 population.
This would be approximately the size of 4 or 5 census tracts. For your
comparison task, you might want SuperTAZs that are smaller than that.
Glad to hear that you understand the difference between your model TAZs
and the Census-TAZs defined for CTPP.
Elaine Murakami
FHWA Office of Planning
206-220-4460
From: ctpp-news-bounces(a)chrispy.net
[mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Kendra Watkins
Sent: Wednesday, May 25, 2011 7:29 AM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] taz delineation
Could someone shed some light on how reliable TAZ to TAZ flow
comparisons will be between the 2000 CTPP data and the 2006 - 2010
release? I am asking because as I delineate TAZ's I am trying to
prioritize my "rules" for delineation and wonder if TAZ continuity will
really be useful if the data won't be comparable anyway.
Of course we are keeping our smaller travel model zones as consistent as
possible, but our Census TAZ's will be in many cases quite a bit larger.
Kendra Watkins
Senior Planner
Mid-Region Council of Governments
809 Copper Ave. NW
Albuquerque, NM 87102
Phone: (505)724-3601
Fax: (505)247-1753
Email: kwatkins(a)mrcog-nm.gov <mailto:tgaudette(a)mrcog-nm.gov>
Could someone shed some light on how reliable TAZ to TAZ flow
comparisons will be between the 2000 CTPP data and the 2006 - 2010
release? I am asking because as I delineate TAZ's I am trying to
prioritize my "rules" for delineation and wonder if TAZ continuity will
really be useful if the data won't be comparable anyway.
Of course we are keeping our smaller travel model zones as consistent as
possible, but our Census TAZ's will be in many cases quite a bit larger.
Kendra Watkins
Senior Planner
Mid-Region Council of Governments
809 Copper Ave. NW
Albuquerque, NM 87102
Phone: (505)724-3601
Fax: (505)247-1753
Email: kwatkins(a)mrcog-nm.gov <mailto:tgaudette(a)mrcog-nm.gov>
Hi Elizabeth
I was just looking through the CTPP mailing list and came upon your
posting of about having developed an ACS data import tool. I am very
interested in this and any other tools you may know of that will help us
get all the data we need from the Census to carry out our role as a
regional transportation planning agency. We want to establish a
comprehensive library about our region that we can draw on in the
development of various plans and to answer local agency questions. As
it is now, it appears that it is necessary to use the census search
tools.
Thank you.
Michael Harmon
Census Data Coordinator
San Luis Obispo Council of Governments (SLOCOG)
805-781-5724
mharmon(a)slocog.org