Re: [CTPP] 2010 Data Release Watch

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