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? Marcus Wigan wrote: -- Ed Christopher 708-283-3534 (V) 708-574-8131 (cell) FHWA RC-TST-PLN 4749 Lincoln Mall Drive, Suite 600 Matteson, IL 60443

Be careful applying IPF. Although it produces maximum-likelihood estimates of cell values, it can overestimate or underestimate when the intersecting row and column changes for a cell vary a lot from the mean change. I've observed this behavior when developing population synthesizers for sample-enumeration models. David Reinke Senior Transportation Engineer/Economist Dowling Associates, Inc. 180 Grand Avenue, Suite 250 Oakland, California 94612-3774 510.839.1742 x104 (voice) 510.839.0871 (fax) www.dowlinginc.com  Please consider the environment before printing this e-mail. Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s), and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. -----Original Message----- From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@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?

OOPS-- I re-did the PUMS run to have the same age groups as the ACS standard tab. Not thinking clearly on a Friday afternoon. Elaine -----Original Message----- From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Elaine.Murakami(a)dot.gov Sent: Friday, March 11, 2011 3:46 PM To: ctpp-news(a)chrispy.net Subject: RE: [CTPP] IPF macro? 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@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?

I am not sure if my original post came through and if its a copy i apologize for reposting (computer issues). Original email below. Unless I am missing something, Elaine's challenge has not yet been met or not responded to on this list. Anyway, while trying to IPF a table in R i ran across this resource (http://www.demog.berkeley.edu/~eddieh/datafitting.html) that might be useful to meet Elaine's challenge (there is a bunch of R code that will help meet the challenge).  Elaine has already given Age x Mode, and Gender x Mode. Link to Age x Gender for workers 16 years and older [no MOEs included and obtained after raking the marginals of tables B08101 and B08006] given below so that all the data elements are available to meet her challenge. Download Age x Gender for workers 16 years and older from here: https://docs.google.com/leaf?id=0B0hTmthiX5dpMDRiZGE4ZWYtZTk0Mi00OTExLTgwYT… Krishnan On Fri, Mar 11, 2011 at 6:45 PM, <Elaine.Murakami(a)dot.gov> wrote: -- Krishnan Viswanathan 1101 High Meadow Dr Tallahassee FL 32311 -- Krishnan Viswanathan 1101 High Meadow Dr Tallahassee FL 32311

Hi Beverly, you are probably wanting some geographic unit like an MCD. The 2006-2008 CTPP includes flows, including MCD flow data (MCD in 12 states), of which I am 99% sure that includes MA, but this tabulation is restricted to those geographic units with population 20,000 and over, so it is somewhat of a "swiss cheese" dataset. The full CTPP data, INCLUDING THE MCD FLOWS, can be found at: http://ctpp.transportation.org/Pages/3yrdas.aspx by clicking "take me to the data." The data are available free and can be accessed after registering and logging in, there is also a tutorial there. Go to CTPP Part 3 to get the flow data. PLEASE CONTACT MS. LIANG LONG FOR ASSISTANCE AT 202-366-6971, or PENELOPE WEINBERGER AT 202-624-3556 for assistance on using this software. For smaller geographic units, the CTPP will not have anything until after the 2006-2010 CTPP is produced. This is expected to include tract and TAZ (where defined). Also, an information item that doesn't help you, but might be of interest to others... the Census Bureau is discussing a new "quasi-standard" product for county-to-county flow using 5-years of ACS data, starting with 2005-2009 ACS. Since they are just in the development stage, they do not have a schedule, or list of possible tables (which characteristics to include). They have discussed this concept with the State Data Center program. Elaine Murakami FHWA Office of Planning 206-220-4460 -----Original Message----- From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Beverly Woods Sent: Tuesday, July 12, 2011 3:12 PM To: ctpp-news(a)chrispy.net Subject: RE: [CTPP] 2010 Data Release Watch Hello- Is there any journey to work data available at the community level that is more recent than the 2000 Census? We are updating our regional transportation plan and would like to evaluate commuting patterns. Thanks, Beverly Woods Executive Director Northern Middlesex Council of Governments                       40 Church Street, Suite 200 Lowell, MA  01852 Phone:  (978) 454-8021, ext. 20 Email:  bwoods(a)nmcog.org _______________________________________________ ctpp-news mailing list ctpp-news(a)chrispy.net http://www.chrispy.net/mailman/listinfo/ctpp-news