It looks like most workplace data including means of transportation, travel time is not available in the small geography, but only States, Counties, Places and MCDs. I have attached a 2005-2009 5 year table list and locations from the Census Bureau website. It's very helpful to figure out the availability of 5 year tables. 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> ________________________________ From: ctpp-news-bounces(a)chrispy.net on behalf of wendell cox Sent: Mon 12/27/2010 9:09 AM To: ctpp-news(a)chrispy.net Subject: Re: [CTPP] ACS 5-year Summary File retrieval tool Elaine... A quick, I hope easy question. Does the 2005-9 data from the CTPP listserve have workplace data by census tract, such as journey to work time, income data, etc. I note that it is not available at AFF. Thank you Happy Holidays, Best regards, Wendell Cox On Thu, Dec 16, 2010 at 6:11 PM, <Elaine.Murakami(a)dot.gov> wrote: Hi Everyone-- Brian McKenzie at the Census Bureau provided this information on viewing files in Excel to help those of you when you download the tract or block group data from the "summary file" format, instead of the AFF. Please be sure to share your experiences with analyzing the new 2005-2009 ACS data with the CTPP listserv. Thanks in advance. Elaine ________________________________ From: brian.mckenzie(a)census.gov [mailto:brian.mckenzie(a)census.gov] The Excel-based retrieval tool that I mentioned yesterday can be access via the following page. Once you http://www.census.gov/acs/www/data_documentation/summary_file/ <http://www.census.gov/acs/www/data_documentation/summary_file/> . Below this link is the user guide. You just download the excel file with the macro built into it onto your hard drive, and you can view any SF table in Excel format rather than having to deal with ASCII files. _______________________________________________ ctpp-news mailing list ctpp-news(a)chrispy.net http://www.chrispy.net/mailman/listinfo/ctpp-news -- -- Wendell Cox Demographia | Wendell Cox Consultancy - St. Louis Missouri-Illinois metropolitan region Visiting Professor, Conservatoire National des Arts et Metiers, Paris +1.618 632 8507 www.demographia.com <http://www.demographia.com/> | www.publicpurpose.com <http://www.publicpurpose.com/> | www.rentalcartours.net <http://www.rentalcartours.net/> Books & Publications WAR ON THE DREAM: How Anti-Sprawl Policy Threatens the Quality of Life http://www.demographia.com/wod1.pdf 6th ANNUAL DEMOGRAPHIA INTERNATIONAL HOUSING AFFORDABILITY SURVEY (http://www.demographia.com/dhi.pdf) THE WAL-MART REVOLUTION: How Big-Box Stores Benefit Consumers, Workers, and the Economy By Richard Vedder & Wendell Cox