CTPP August 2003

ctpp@listserv.transportation.org

6 participants
15 discussions

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.

21 years, 12 months

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

21 years, 12 months

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.

21 years, 12 months

[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.

21 years, 12 months

[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

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 August 2003