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.
Ted L. Gallion, Research Associate
Office of Social and Economic Data Analysis (OSEDA)
University of Missouri Extension
623 Clark Hall, Columbia, MO 65211
Phone: (573) 882-7396
Fax: (573) 884-4635
From: ctpp-news-bounces(a)chrispy.net [mailto:firstname.lastname@example.org] On Behalf Of
Sent: Tuesday, February 23, 2010 1:49 PM
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
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
1. If you have access to SAS software, you can obtain some of these files from the
Missouri State Data Center (SDC) at
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:
Place codes for Census 2000 may be found using the special product STP64 on the CTPP
website. Please see attached.