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!

ScannedSignature_Ted

Ted L. Gallion, Research Associate
Office of Social and Economic Data Analysis (OSEDA)
University of Missouri Extension
623 Clark Hall, Columbia, MO  65211
galliont@umsystem.edu
Phone: (573) 882-7396
Fax: (573) 884-4635

 

From: ctpp-news-bounces@chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Srinivasan, Nanda
Sent: Tuesday, February 23, 2010 1:49 PM
To: ctpp-news@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%20Transportation%20Planning%20Package%20%28CTPP%29%202000&DB_Short_Name=CTPP%202000

 

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