Do you mean cities (as in municipalities), urban areas or metropolitan areas? Hope you are aware that in 2000, Census included taxicabs in the public transit data, but has since reported that separately. Metropolitan definitions have changed, so if you are using metropolitan areas I suspect the referenced table will not do. Some really major changes, such as the reduction of the NY CMSA (the standard metropolitan definition for Census in 2000) from something like 21M to 18 or 19M and the reduction of LA from 16M to 12 or so. Let me know if any questions. Best regards, Wendell Cox On Tue, Feb 23, 2010 at 6:10 PM, <Elaine.Murakami(a)dot.gov> wrote: -- -- Wendell Cox Demographia | Wendell Cox Consultancy - St. Louis Missouri-Illinois metropolitan region Visiting Professor, Conservatoire National des Arts et Metiers, +1.618 632 8507 www.demographia.com | www.publicpurpose.com | www.rentalcartours.net Books & Publications WAR ON THE DREAM: How Anti-Sprawl Policy Threatens the Quality of Life http://www.demographia.com/wod1.pdf 5th 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

FYI. Missouri State Census Data Center does not require SAS to access or query the data. There's a handy little app "Uexplore/Dexter" at the site that will do the job for you. Cheers! [cid:image002.jpg@01CAB4A0.BB232490] Ted L. Gallion, Research Associate Office of Social and Economic Data Analysis (OSEDA) University of Missouri Extension 623 Clark Hall, Columbia, MO 65211 galliont(a)umsystem.edu Phone: (573) 882-7396 Fax: (573) 884-4635 From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Srinivasan, Nanda Sent: Tuesday, February 23, 2010 1:49 PM To: ctpp-news(a)chrispy.net Subject: RE: [CTPP] CTPP 2000 JTW by Public Transportation Mode for All US Cities I am aware of three ways to construct nationwide tables from Census 2000. As Wendell points out, first, please be sure of which geography you want: MSA/CMSA (Metropolitan Areas), Place (Closest to city definitions), Urbanized areas, urban clusters etc. For any of these areas, there are different, but easy methods to aggregate the data for the nation. Then, please be aware that public transportation may sometimes include Taxicabs, and sometimes they may not. It is often best to add up the disaggregate modes that are available in the manner you see fit for your analysis (18 total categories in Census 2000) 1. If you have access to SAS software, you can obtain some of these files from the Missouri State Data Center (SDC) at http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000 2. American Factfinder is very useful in summarizing "geography within geography", but the geographies are limited to 7,000 from their website (so this should work for state, county, MSA, Urbanized area geographies). AFF outputs are easy to understand and take the least effort. 3. For place and tracts (which may number more than 7,000 geographies), the easiest I've found is to use the BTS Transtats website: http://www.transtats.bts.gov/Tables.asp?DB_ID=630&DB_Name=Census%20Tran… Place codes for Census 2000 may be found using the special product STP64 on the CTPP website. Please see attached. http://www.fhwa.dot.gov/ctpp/stp/stp64.zip Thank you Nanda Srinivasan