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

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