CTPP

ctpp@listserv.transportation.org

5 participants
3069 discussions

by Murakami

This week, the Census Bureau mailed CDs to: IA, ME, MA, NE, PA, RI, SD, VT, WY This leaves 14 states remaining, of which 8 are already in the duplication process and will probably be mailed early next week. The Census Bureau's goal is to complete the Part 1 release by August 15. It is still taking from a week to 10 days for people to receive their copies in the mail, but we have asked the Census Bureau to investigate. Many people are having problems with installing the software, but our computer whiz, Nanda Srinivasan is helping everyone out. 202-366-5021. Just as a reminder: State DOTs and MPOs have a month to review the data and talk to the Census Bureau if they find data problems. After a month, the Census Bureau will finalize the data and provide copies for general public distribution via the USDOTs Bureau of Transportation Statistics. We do not anticipate CTPP Parts 2 and 3 to be available until late Fall 2003 and into Winter 2004. Elaine Murakami, FHWA 206-220-4460 in Seattle

22 years

[CTPP] Commuting to Downtown: TRB Committee Project

by Chuck Purvis

To: CTPP-News and Urban Data Committee listserv At our TRB committee's mid-year meeting this past month we discussed a proposed committee project "Commuting to Downtown." We are hoping to have several sets of analyses complete (or at least well under progress) by the January 2004 TRB annual meeting. The project abstract and the "protoype downtown maps and tables (San Francisco, San Jose, Oakland)" are posted here: http://www.mtc.ca.gov/trb/urban/commute/ The preface to this abstract reads: "The United States has invested billions of dollars in transit and highways over the past several decades. One of the issues is measuring the success of transit investments in terms of transit market share. The purpose of this research is to analyze the changes in employment trends and transit commuting to central business districts (CBD) in the United States. The results of this research may point to the obvious: that transit does well in serving commuters working in downtown America, and that high levels of employment density are associated with the highest levels, shares and success stories related to transit commuting. Data from the decennial census is used to characterize workers at CBD-of-work in the largest cities in the United States. Data can be extracted from the various "journey-to-work" datasets including the 1970 Census Urban Transportation Package (UTP), the 1980 Census Urban Transportation Planning Package (UTPP), and the 1990 and 2000 Census Transportation Planning Package (CTPP)." Much of this analysis is dependent on new data from CTPP 2000, Part 2 (data by zone-of-work or tract-of-work), that none of us have, and we all hope to have before TRB 2004. This project is intended as a voluntary effort by persons with best access to historical journey-to-work datasets, namely, the MPO staffs in large metropolitan areas. Eventually it would be great to have data for all CBDs in cities with population of 250,000+. My hope is that urban data committee members will be the most eager to participate (New York, Chicago, Detroit, Baltimore, Seattle, San Francisco, Sacramento) and others have already voiced an interest (Atlanta.) What can be started now is assembling historical journey-to-work data for your CBDs, and mapping of each CBD. Some of this may be tough to impossible, for example, the 1970 UTP or the 1980 UTPP for your area may not be archived or accessible. At the very least we would want to examine changes between 1990 and 2000. In addition, there may be university researchers who can pitch in to assemble and reduce the historical data, or to help on the cartography. At the committee meeting we discussed the need to have "multiple definitions of CBDs" for the largest cities: e.g., the San Francisco financial district compared to the greater San Francisco CBD; the Chicago "loop" versus the greater downtown, etc. Any persons interested in contributing to the project just drop me an e-mail. That's about all for now! Chuck Purvis, MTC ************************************************************** Charles L. Purvis, AICP Principal Transportation Planner/Analyst Metropolitan Transportation Commission 101 Eighth Street Oakland, CA 94607-4700 (510) 464-7731 (office) (510) 464-7848 (fax) www: http://www.mtc.ca.gov/ Census WWW: http://www.bayareacensus.ca.gov/ **************************************************************

22 years

[CTPP] PUMS Five-Percent Files: release starting August 6th

by Chuck Purvis

TO: CTPP-NEWs The following message was posted on the State Data Center Listserv this morning. The 5-percent PUMS data will probably be released over the next 6 weeks. A couple of the provided links don't work. They might work tomorrow. CP ************************************************************************************************************************* The Public Use Microdata Sample files for Rhode Island, Vermont, and Wyoming will be released to the public on August 6, 2003 at 12:01 AM. There is no embargo period for these data. The data can be accessed on 8/6/03 at: http://www2.census.gov/census_2000/datasets/PUMS/FivePercent/ ftp://ftp2.census.gov/census_2000/datasets/PUMS/FivePercent/ The PUMS tech doc in TXT format is on the Customer Liaison Office's website at the following URL: http://www.census.gov/sdc/www/pums.html Chapter J-Equivalency files is forthcoming. The PUMS files will be released on a weekly flow basis beginning this month through September 2003. This is end date is subject to change. I do not have a "look ahead" list of planned state releases at this time. I will let you know when this information becomes available. For more information on PUMS refer to the product description at: http://www.census.gov/population/www/censusdata/c2kproducts.html CLO will provide the network with copies of the CD-ROMs for the leads, coords, and affiliate organizations in each state during the August through September time period. Renée Jefferson-Copeland Customer Liaison Office Census Bureau

22 years

[CTPP] CTPP2000 Documentation is Online

by Chuck Purvis

TO: CTPP-News We have started a new web page that provides our local (San Francisco Bay Area) data users with access to the CTPP documentation, and data in GIS and CSV formats. The page is here: http://www.mtc.ca.gov/datamart/census/ctpp2000/ What can be very helpful to others in the country is the section of this page that provides links to ALL of the CTPP documentation that came on our California CD (received 7/9/03). I also have links to the SAS programs provided by the Census Bureau, and my MTC SAS programs to extract data from these SAS databases. I also constructed a new spreadsheet that lists all 11,444 variables in the CTPP Part 1 dataset, with the "SAS variable labels" provided by the Census Bureau as a column in the spreadsheet. It's 179 pages in length, but it may prove to come in handy.... We are uploading these CTPP documentation to our agency's web site, given the difficulties that federal agency staff have in uploading certain document types (PDF, XLS, DOC) to federal web sites. Ed and I will also update the www.trbcensus.com web site to provide links to the CTPP documentation stored on our web site.... Hope this helps. Chuck Purvis ************************************************************** Charles L. Purvis, AICP Principal Transportation Planner/Analyst Metropolitan Transportation Commission 101 Eighth Street Oakland, CA 94607-4700 (510) 464-7731 (office) (510) 464-7848 (fax) www: http://www.mtc.ca.gov/ Census WWW: http://www.bayareacensus.ca.gov/ **************************************************************

22 years

RE: [CTPP] CTPP2000 Part 1 State released (UPDATE)

by Srinivasan

Dave et.al, The software allows you to BATCH PROCESS and EXPORT files into different formats - MS Excel, CSV, Text, D-Base, Shape, HTML, and ASCII. To do this, "Create a session" (as explained in your installation advice and question 9 on anticipating the CTPP). At the stage when you get a screen called "Open Session Table" click on cancel. Then click on File-Open Session Manager. Click on the session you just created, and then on Export. This option allows you to export ALL SELECTED TABLES into one of the formats (MS Excel, CSV, Text, D-Base, Shape, HTML, and ASCII). There are read me files associated with D-Base (Table name.dbt file), Shape (Table name.dbt), and ASCII. The other option is to order an ASCII file from Census Bureau (Contact Clara Reschovsky - Clara.a.reschovksy(a)census.gov) The rule of thumb I would use is: 1. If you are trying to browse a few tables, OR some numbers OR data quickly for one or a few TAZs, use the CTPP Access Tool. You can also use the software to make quick maps, summary reports etc. Although the software may not look intuitive in the beginning, it is VERY useful, and powerful once you get a hang of it. 2. If you are MORE COMFORTABLE looking at the data in other softwares, try exporting the tables as shown above. 3. If you are an EXPERT programmer, and are much more comfortable writing your own code, then order the flat ASCII files from Clara. As always, you are welcome to call me at 202-366-5021 for any help! Nanda Srinivasan -----Original Message----- From: dabrams(a)mrcog-nm.gov Sent: Monday, August 04, 2003 3:48 PM To: Murakami, Elaine; ctpp-news(a)chrispy.net Subject: RE: [CTPP] CTPP2000 Part 1 State released (UPDATE) We have installed the CD for New Mexico. However, there seems to be no way to access the data except with the browser. Prior to release of the CD there was a table of the CTPP 2000 Standard Tabulations: Description of Variable Category Labels. It would be very useful to directly access the variables listed in that table in a format similar to other census files that can be directly read into SAS or Excel. Does anyone know how to get to the data? Dave Abrams Albuquerque MPO -----Original Message----- From: Murakami, Elaine [mailto:Elaine.Murakami(a)fhwa.dot.gov] Sent: Monday, August 04, 2003 12:39 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] CTPP2000 Part 1 State released (UPDATE) Here is the list of Part 1 CDs which have been mailed to States and MPOs as of July 31, 2003. AK, AZ, CA, CO, DE, DC, FL, GA, ID, IL, IN, MD, MI, MN, NV, NJ, NM, NY, NC, ND, OH, OR, TN, TX, UT, WA, WV, WI. Note: CA is being re-done (TAZs were missing in first release) and should be mailed by today (08/04). We have been finding that it is taking 10-12 days from the posted mail-out date to arrival to the West Coast, and the Census Bureau is trying to determine if there is anything they can do to expedite this. If you have problems installing the software, please call Nanda Srinivasan at 202-366-5021, and he will try to help you. As noted in previous posts to the CTPP listserv, the Census Bureau is providing the States and MPOs a 30-day window to review the data and to convey any problems back to them for correction. If you find errors, please notify Clara Reschovsky at: clara.a.reschovsky(a)census.gov 301-763-2454 When the data are "finalized," CD copies will be made available through the USDOT's Bureau of Transportation Statistics, and eventually available thru on-line data access.

22 years

RE: [CTPP] CTPP2000 Part 1 State released (UPDATE)

by Murakami

Maybe you would prefer to have the zipped ASCII file of the entire dataset for your state. If so, please contact Clara Reschovsky at the Census Bureau, as noted in the prior email, and she will send it to you on CD. Chuck Purvis of MTC has made SAS programs for CTPP Part 1 available. I believe his email to the listserv was posted last week. If you only want one or two tables from Part 1, you should use the EXTRACT command in the CTPP Access Tool, and you can save your data to many different formats, including .csv, .dbf, .xls, etc. SAS is NOT one of the formats. -----Original Message----- From: hubsmtp.gwhub."dabrams(a)mrcog-nm.gov" [mailto:hubsmtp.gwhub."dabrams(a)mrcog-nm.gov"] Sent: Mon 8/4/2003 3:46 PM To: Murakami, Elaine; ctpp-news(a)chrispy.net Cc: Subject: RE: [CTPP] CTPP2000 Part 1 State released (UPDATE) We have installed the CD for New Mexico. However, there seems to be no way to access the data except with the browser. Prior to release of the CD there was a table of the CTPP 2000 Standard Tabulations: Description of Variable Category Labels. It would be very useful to directly access the variables listed in that table in a format similar to other census files that can be directly read into SAS or Excel. Does anyone know how to get to the data? Dave Abrams Albuquerque MPO

22 years

RE: [CTPP] CTPP2000 Part 1 State released (UPDATE)

by David Abrams

We have installed the CD for New Mexico. However, there seems to be no way to access the data except with the browser. Prior to release of the CD there was a table of the CTPP 2000 Standard Tabulations: Description of Variable Category Labels. It would be very useful to directly access the variables listed in that table in a format similar to other census files that can be directly read into SAS or Excel. Does anyone know how to get to the data? Dave Abrams Albuquerque MPO -----Original Message----- From: Murakami, Elaine [mailto:Elaine.Murakami(a)fhwa.dot.gov] Sent: Monday, August 04, 2003 12:39 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] CTPP2000 Part 1 State released (UPDATE) Here is the list of Part 1 CDs which have been mailed to States and MPOs as of July 31, 2003. AK, AZ, CA, CO, DE, DC, FL, GA, ID, IL, IN, MD, MI, MN, NV, NJ, NM, NY, NC, ND, OH, OR, TN, TX, UT, WA, WV, WI. Note: CA is being re-done (TAZs were missing in first release) and should be mailed by today (08/04). We have been finding that it is taking 10-12 days from the posted mail-out date to arrival to the West Coast, and the Census Bureau is trying to determine if there is anything they can do to expedite this. If you have problems installing the software, please call Nanda Srinivasan at 202-366-5021, and he will try to help you. As noted in previous posts to the CTPP listserv, the Census Bureau is providing the States and MPOs a 30-day window to review the data and to convey any problems back to them for correction. If you find errors, please notify Clara Reschovsky at: clara.a.reschovsky(a)census.gov 301-763-2454 When the data are "finalized," CD copies will be made available through the USDOT's Bureau of Transportation Statistics, and eventually available thru on-line data access.

22 years

[CTPP] CTPP2000 Part 1 State released (UPDATE)

by Murakami

Here is the list of Part 1 CDs which have been mailed to States and MPOs as of July 31, 2003. AK, AZ, CA, CO, DE, DC, FL, GA, ID, IL, IN, MD, MI, MN, NV, NJ, NM, NY, NC, ND, OH, OR, TN, TX, UT, WA, WV, WI. Note: CA is being re-done (TAZs were missing in first release) and should be mailed by today (08/04). We have been finding that it is taking 10-12 days from the posted mail-out date to arrival to the West Coast, and the Census Bureau is trying to determine if there is anything they can do to expedite this. If you have problems installing the software, please call Nanda Srinivasan at 202-366-5021, and he will try to help you. As noted in previous posts to the CTPP listserv, the Census Bureau is providing the States and MPOs a 30-day window to review the data and to convey any problems back to them for correction. If you find errors, please notify Clara Reschovsky at: clara.a.reschovsky(a)census.gov 301-763-2454 When the data are "finalized," CD copies will be made available through the USDOT's Bureau of Transportation Statistics, and eventually available thru on-line data access.

22 years

[CTPP] Data Problem Fixed: MCD/County-to-MCD/County Worker Flow Files

by clara.a.reschovsky＠census.gov

MCD Flow users, I finally have some good news! We have the corrected MCD Flow files up on the internet site so you can use any of the files up on the website (see address below). If anybody has any questions or concerns, please let me know. Clara Reschovsky 301 763 2454 ----- Forwarded by Clara A Reschovsky/POP/HQ/BOC on 08/01/2003 09:58 AM ----- |---------+----------------------------> | | Clara A | | | Reschovsky | | | | | | 07/30/2003 04:21 | | | PM | | | | |---------+----------------------------> >-------------------------------------------------------------------------------------------------------------------------------| | | | To: ctpp-news(a)chrispy.net | | cc: | | Subject: Data Problem: MCD/County-to-MCD/County Worker Flow Files | >-------------------------------------------------------------------------------------------------------------------------------| MCD Flow users, It has come to our attention at the Census Bureau that some of the MCD Flow files on the internet site are not correct. The Excel files sorted by Workplace MCD for MI, MN, NJ, NY, PA, and WI erroneously contain the residence sorted data. We have transmitted the correct files to replace the incorrect files on the internet and will let you know as soon as they are fixed. In the meantime, you can use the plain text file to get the workplace sort for these states. The only drawback is you will not be able to open these in Excel as they have too many records. If this will be a problem for you, please let me know. We do appologize for any inconvienience this may have caused. Clara ----- Forwarded by Celia G Boertlein/POP/HQ/BOC on 07/30/2003 04:10 PM ----- |---------+----------------------------> | | phillip.a.salopek| | | @census.gov | | | Sent by: | | | owner-ctpp-news(a)c| | | hrispy.net | | | | | | | | | 07/25/2003 10:04 | | | AM | | | | |---------+----------------------------> >-------------------------------------------------------------------------------------------------------------------------------| | | | To: ctpp-news(a)chrispy.net | | cc: | | Subject: [CTPP] Release of MCD/County-to-MCD/County Worker Flow Files | >-------------------------------------------------------------------------------------------------------------------------------| The Census Bureau released today the Census 2000 MCD/County-to-MCD/County Worker Flow Files. These files contain commuter flow data at the county subdivision or minor civil division (MCD) level in twelve states: Connecticut, Maine, Massachusetts, Michigan, Minnesota, New Hampshire, New Jersey, New York, Pennsylvania, Rhode Island, Vermont, and Wisconsin. For the other 38 states and the District of Columbia data are presented at the county level. Files for Puerto Rico are also provided in this product, showing data at the county equivalent (municipio) level. The files may be found at the following location: www.census.gov/population/www/cen2000/mcdworkerflow.html Alternatively, from the Census Bureau home page (www.census.gov) click on "J" in the Subjects A to Z Index. On the next page click on the link for "Journey to Work and Place of Work Data." From there, under the heading Census 2000 Data click on the link "2000 Minor Civil Division/County-to-Minor Civil Division/County Worker Flow Files."

22 years

[CTPP] Data Problem: MCD/County-to-MCD/County Worker Flow Files

by clara.a.reschovsky＠census.gov

MCD Flow users, It has come to our attention at the Census Bureau that some of the MCD Flow files on the internet site are not correct. The Excel files sorted by Workplace MCD for MI, MN, NJ, NY, PA, and WI erroneously contain the residence sorted data. We have transmitted the correct files to replace the incorrect files on the internet and will let you know as soon as they are fixed. In the meantime, you can use the plain text file to get the workplace sort for these states. The only drawback is you will not be able to open these in Excel as they have too many records. If this will be a problem for you, please let me know. We do appologize for any inconvienience this may have caused. Clara ----- Forwarded by Celia G Boertlein/POP/HQ/BOC on 07/30/2003 04:10 PM ----- |---------+----------------------------> | | phillip.a.salopek| | | @census.gov | | | Sent by: | | | owner-ctpp-news(a)c| | | hrispy.net | | | | | | | | | 07/25/2003 10:04 | | | AM | | | | |---------+----------------------------> >-------------------------------------------------------------------------------------------------------------------------------| | | | To: ctpp-news(a)chrispy.net | | cc: | | Subject: [CTPP] Release of MCD/County-to-MCD/County Worker Flow Files | >-------------------------------------------------------------------------------------------------------------------------------| The Census Bureau released today the Census 2000 MCD/County-to-MCD/County Worker Flow Files. These files contain commuter flow data at the county subdivision or minor civil division (MCD) level in twelve states: Connecticut, Maine, Massachusetts, Michigan, Minnesota, New Hampshire, New Jersey, New York, Pennsylvania, Rhode Island, Vermont, and Wisconsin. For the other 38 states and the District of Columbia data are presented at the county level. Files for Puerto Rico are also provided in this product, showing data at the county equivalent (municipio) level. The files may be found at the following location: www.census.gov/population/www/cen2000/mcdworkerflow.html Alternatively, from the Census Bureau home page (www.census.gov) click on "J" in the Subjects A to Z Index. On the next page click on the link for "Journey to Work and Place of Work Data." From there, under the heading Census 2000 Data click on the link "2000 Minor Civil Division/County-to-Minor Civil Division/County Worker Flow Files."

22 years

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

1999

1998

CTPP