CTPP March 2011

ctpp@listserv.transportation.org

56 participants
56 discussions

Start a nNew thread

Accepted: [CTPP] CUTR Webcast-American Community Survey Statistical Analyzer March 24 at Noon (EDT)

by Sabula

14 years, 4 months

Accepted: [CTPP] CUTR Webcast-American Community Survey Statistical AnalyzerMarch 24 at Noon (EDT)

by ARNOLD Richard D

14 years, 4 months

Accepted: [CTPP] CUTR Webcast-American Community Survey Statistical Analyzer March 24 at Noon (EDT)

by Erlbaum

14 years, 4 months

Tentative: [CTPP] CUTR Webcast-American Community Survey Statistical Analyzer March 24 at Noon (EDT)

by Spring

14 years, 4 months

Canceled: [CTPP] CUTR Webcast-American Community Survey Statistical Analyzer March 24 at Noon (EDT)

by Dickson

_____________________________________________ From: ctpp-news-bounces(a)chrispy.net<mailto:ctpp-news-bounces(a)chrispy.net> [mailto:ctpp-news-bounces(a)chrispy.net]<mailto:[mailto:ctpp-news-bounces(a)chrispy.net]> On Behalf Of Chu, Xuehao Sent: Tuesday, March 22, 2011 10:24 AM To: ctpp-news(a)chrispy.net<mailto:ctpp-news(a)chrispy.net> Subject: [CTPP] CUTR Webcast-American Community Survey Statistical Analyzer March 24 at Noon (EDT) From: Iley, Jennifer Sent: Monday, March 21, 2011 4:30 PM To: cutr(a)lists.cutr.usf.edu<mailto:cutr(a)lists.cutr.usf.edu>; nctr(a)lists.cutr.usf.edu<mailto:nctr(a)lists.cutr.usf.edu>; CUTR Faculty; CUTR Staff; CUTR Students Subject: *REMINDER CUTR Webcast-American Community Survey Statistical Analyzer March 24 at Noon (EDT) Please join us for a FREE CUTR webcast, The American Community Survey (ACS) Statistical Analyzer on March 24 from 12 to 1PM (EDT). This webcast is hosted by the Center for Urban Transportation Research<http://www.cutr.usf.edu/> at the University of South Florida<http://www.usf.edu/>. The link to join the webcast and the toll-free phone number are below. These will remain the same for all webcasts. The schedule of upcoming webcasts is also shown below. If you cannot join us, the event will be recorded and available for on-demand streaming within 48 hours after the event. Visit www.cutr.usf.edu<http://www.cutr.usf.edu/> for the links. About the Presenter: Dr. Xuehao Chu is a senior research associate at the Center for Urban Transportation Research, University of South Florida since 1993. He has his BS degree in Mathematics from Hangzhou University, China and his Ph.D. in Economics from the University of California at Irvine. His recent work focuses on developing manuals and tools for practitioners, including the National Transit Database Sampling Manual and the American Community Survey Statistical Analyzer. About the Session: This session introduces and demonstrates the ACS Statistical Analyzer. It is an Excel-based template for users of estimates from the American Community Survey (ACS) to assess the precision of individual estimates and to compare pairs of estimates for their statistical differences. The ACS Statistical Analyzer covers the following four functions and fifteen sub-functions (not listed): * To derive other precision measures for published ACS estimates at American FactFinder or from the Census Transportation Planning Products (CTPP), which already have a margin of error (MOE). * To derive the precision measures for estimates that do not already have an MOE. * To derive the precision measures of new estimates obtained from two or more original estimates that already have an MOE. * To compare pairs of two estimates that already have an MOE. FIRST-TIME USERS 1. Use Internet Explorer or Google Chrome for your browser when using Live Meeting. DO NOT use Firefox for Live Meeting events. 2. Don't wait until the last minute. Check your system NOW<http://go.microsoft.com/fwlink/?LinkId=90703> to ensure you are ready to use Microsoft Office Live Meeting.* *If prompted during installation, install the FULL/Windows-based CLIENT version of Live Meeting. If you have problems installing the FULL version, install the Web Access version. CLICK ON THE LINK BELOW TO JOIN THE WEBCAST https://www.livemeeting.com/cc/cutr/join?id=CUTR+Webcast+Series&role=attend… Add to my Outlook Calendar: https://www.livemeeting.com/cc/cutr/meetingICS?id=CUTR+Webcast+Series&role=… AUDIO INFORMATION We recommend that you listen to the CUTR webcast through your computer speakers or headset. A Q&A feature will allow you to ask questions online during the webcast. If you are unable to use your computer speakers or headset, use your telephone to receive the audio. Toll-free: +1 (877) 536-4294 Participant code: 4705 TROUBLESHOOTING Unable to join the meeting? Follow these steps: 1. 1. Copy this address and paste it into your web browser: https://www.livemeeting.com/cc/cutr/join 2. Copy and paste the required information: Meeting ID: CUTR Webcast Series Entry Code: cutrcast Location: https://www.livemeeting.com/cc/cutr If you still cannot enter the meeting, contact technical support at 1-866-493-2825. Online technical support is also available: http://www.conferencevisuals.net<http://www.conferencevisuals.net/> NOTICE Microsoft Office Live Meeting can be used to record meetings. By participating in this meeting, you agree that your communications may be monitored or recorded at any time during the meeting. SCHEDULE Date Title of Presentation Presenter(s) 3/24/2011 The American Community Survey (ACS) Statistical Analyzer Xuehao Chu, Ph.D. 4/7/2011 Walk Wise: A Grassroots Pedestrian Safety Campaign Julie Bond 4/21/2011 Mobility Planning Strategies and Concepts Karen Seggerman, AICP and Kristine Williams, AICP 5/5/2011 Trip Reduction Impacts for Mobility Management Strategies: A Practitioner-Oriented Sketch Planning Tool Sisinnio Concas, Ph.D. 5/19/2011 Evaluation of Camera-Based Systems to Reduce Transit Bus Side Collisions Pei-Sung Lin, Ph.D. and Achilles Kourtellis, Ph.D. 6/16/2011 Moving the Bus Safely Back Into Traffic Pei-Sung Lin, Ph.D. and Aldo Fabregas, Ph.D. 6/30/2011 Transit Boardings Estimation and Simulation Tool (TBEST) Steven Polzin, Ph.D. and Rodney Bunner

14 years, 4 months

[CTPP] CUTR Webcast-American Community Survey Statistical Analyzer March 24 at Noon (EDT)

by Dickson

14 years, 4 months

[CTPP] CUTR Webcast-American Community Survey Statistical Analyzer March 24 at Noon (EDT)

by Chu

From: Iley, Jennifer Sent: Monday, March 21, 2011 4:30 PM To: cutr(a)lists.cutr.usf.edu; nctr(a)lists.cutr.usf.edu; CUTR Faculty; CUTR Staff; CUTR Students Subject: *REMINDER CUTR Webcast-American Community Survey Statistical Analyzer March 24 at Noon (EDT) Please join us for a FREE CUTR webcast, The American Community Survey (ACS) Statistical Analyzer on March 24 from 12 to 1PM (EDT). This webcast is hosted by the Center for Urban Transportation Research<http://www.cutr.usf.edu/> at the University of South Florida<http://www.usf.edu/>. The link to join the webcast and the toll-free phone number are below. These will remain the same for all webcasts. The schedule of upcoming webcasts is also shown below. If you cannot join us, the event will be recorded and available for on-demand streaming within 48 hours after the event. Visit www.cutr.usf.edu<http://www.cutr.usf.edu/> for the links. About the Presenter: Dr. Xuehao Chu is a senior research associate at the Center for Urban Transportation Research, University of South Florida since 1993. He has his BS degree in Mathematics from Hangzhou University, China and his Ph.D. in Economics from the University of California at Irvine. His recent work focuses on developing manuals and tools for practitioners, including the National Transit Database Sampling Manual and the American Community Survey Statistical Analyzer. About the Session: This session introduces and demonstrates the ACS Statistical Analyzer. It is an Excel-based template for users of estimates from the American Community Survey (ACS) to assess the precision of individual estimates and to compare pairs of estimates for their statistical differences. The ACS Statistical Analyzer covers the following four functions and fifteen sub-functions (not listed): § To derive other precision measures for published ACS estimates at American FactFinder or from the Census Transportation Planning Products (CTPP), which already have a margin of error (MOE). § To derive the precision measures for estimates that do not already have an MOE. § To derive the precision measures of new estimates obtained from two or more original estimates that already have an MOE. § To compare pairs of two estimates that already have an MOE. FIRST-TIME USERS 1. Use Internet Explorer or Google Chrome for your browser when using Live Meeting. DO NOT use Firefox for Live Meeting events. 2. Don't wait until the last minute. Check your system NOW<http://go.microsoft.com/fwlink/?LinkId=90703> to ensure you are ready to use Microsoft Office Live Meeting.* *If prompted during installation, install the FULL/Windows-based CLIENT version of Live Meeting. If you have problems installing the FULL version, install the Web Access version. CLICK ON THE LINK BELOW TO JOIN THE WEBCAST https://www.livemeeting.com/cc/cutr/join?id=CUTR+Webcast+Series&role=attend… Add to my Outlook Calendar: https://www.livemeeting.com/cc/cutr/meetingICS?id=CUTR+Webcast+Series&role=… AUDIO INFORMATION We recommend that you listen to the CUTR webcast through your computer speakers or headset. A Q&A feature will allow you to ask questions online during the webcast. If you are unable to use your computer speakers or headset, use your telephone to receive the audio. Toll-free: +1 (877) 536-4294 Participant code: 4705 TROUBLESHOOTING Unable to join the meeting? Follow these steps: 1. 1. Copy this address and paste it into your web browser: https://www.livemeeting.com/cc/cutr/join 2. Copy and paste the required information: Meeting ID: CUTR Webcast Series Entry Code: cutrcast Location: https://www.livemeeting.com/cc/cutr If you still cannot enter the meeting, contact technical support at 1-866-493-2825. Online technical support is also available: http://www.conferencevisuals.net<http://www.conferencevisuals.net/> NOTICE Microsoft Office Live Meeting can be used to record meetings. By participating in this meeting, you agree that your communications may be monitored or recorded at any time during the meeting. SCHEDULE Date Title of Presentation Presenter(s) 3/24/2011 The American Community Survey (ACS) Statistical Analyzer Xuehao Chu, Ph.D. 4/7/2011 Walk Wise: A Grassroots Pedestrian Safety Campaign Julie Bond 4/21/2011 Mobility Planning Strategies and Concepts Karen Seggerman, AICP and Kristine Williams, AICP 5/5/2011 Trip Reduction Impacts for Mobility Management Strategies: A Practitioner-Oriented Sketch Planning Tool Sisinnio Concas, Ph.D. 5/19/2011 Evaluation of Camera-Based Systems to Reduce Transit Bus Side Collisions Pei-Sung Lin, Ph.D. and Achilles Kourtellis, Ph.D. 6/16/2011 Moving the Bus Safely Back Into Traffic Pei-Sung Lin, Ph.D. and Aldo Fabregas, Ph.D. 6/30/2011 Transit Boardings Estimation and Simulation Tool (TBEST) Steven Polzin, Ph.D. and Rodney Bunner

14 years, 4 months

[CTPP] RE: processing redistricting files in Access

by Harun Rashid

Todd A. Steiss yesterday posted this - www.census.gov/rdo/pdf/0HowToUseMicrosoftAccessShells.pdf A very detailed, step-by-step (with screen-shots) set of instructions to work with Access shells provided by Census. An excellent resource to aid Mara Kaminowitz's original work-flow steps. Harun Harun Rashid, AICP Senior GIS Planner BCD Council of Governments 1362 McMillan Avenue, Suite 100 North Charleston, SC 29405 T: 843.529.0400 F: 843.529.0305 www.bcdcog.org

14 years, 4 months

Re: [CTPP] RE: TAZ Level Data from 2010 Census

by Philipp Gabathuler

Hello All, How can I get TZA level data from the new Census Website? Any help would be much appreciated. Thanks! On Mon, Mar 21, 2011 at 3:33 PM, Harun Rashid <hrashid(a)bcdcog.com> wrote: > In following Mara Kaminowitz's work steps, I'm stuck with instructions in the Census document - '0FILE_STRUCTURE'. I am referring to page 2, instructions under 'For Access Users' - > a. using Access 2007 in Windows XP > b. Step 3 of Part 1 says 'Unzip the PL files you wish to load into Access and rename the file extension to csv' - after extracting with WinZip, I simply renamed these files to add .csv at end. File types remain 'PL file', as shown in Windows explorer > c. Instructions in Part 2 seem to prepared for 2003 versions. When I try to follow similar steps in 2007, the files renamed in previous step are not recognized > > Any help will be appreciated. > > Harun > > Harun Rashid, AICP > Senior GIS Planner > BCD Council of Governments > 1362 McMillan Avenue, Suite 100 > North Charleston, SC 29405 > > T: 843.529.0400 > F: 843.529.0305 > > www.bcdcog.org > > -----Original Message----- > From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of ctpp-news-request(a)chrispy.net > Sent: Friday, February 18, 2011 10:02 AM > To: ctpp-news(a)chrispy.net > Subject: ctpp-news Digest, Vol 84, Issue 24 > > Send ctpp-news mailing list submissions to > ctpp-news(a)chrispy.net > > To subscribe or unsubscribe via the World Wide Web, visit > http://www.chrispy.net/mailman/listinfo/ctpp-news > or, via email, send a message with subject or body 'help' to > ctpp-news-request(a)chrispy.net > > You can reach the person managing the list at > ctpp-news-owner(a)chrispy.net > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of ctpp-news digest..." > > > Today's Topics: > > 1. How to use the Census Redistricting Summary File in Access > (Mara Kaminowitz) > 2. Re: How to use the Census Redistricting Summary File in > Access (Ed Christopher) > 3. Re: 2010 Population Data Release (Ed Christopher) > 4. Re: 2010 Population Data Release (wendell cox) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 18 Feb 2011 09:06:31 -0500 > From: "Mara Kaminowitz" <mkaminowitz(a)baltometro.org> > Subject: [CTPP] How to use the Census Redistricting Summary File in > Access > To: <ctpp-news(a)chrispy.net> > Message-ID: <E7C1057941BA4C6AB416BCA0737364B2(a)bmc.net> > Content-Type: text/plain; charset="us-ascii" > > Since I have seen a lot questions about this I thought I would post my > personal notes. If your state hasn't come out yet I strongly suggest > downloading a different state and practicing. Once you get the method down, > it will be easy to repeat. > > These instructions are for Access 2003 but I think they are similar for > Access 2007. > > You will need the following documents. Download them to your computer and > keep them close at all times. > > 0FILE_STRUCTURE.pdf found at > http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/0FILE_ST > RUCTURE.pdf > > 0GEOID_Construction_for_Matching.pdf found at > http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/0GEOID_C > onstruction_for_Matching.pdf > > pl94-171_tech_doc.pdf found at > http://www.census.gov/prod/cen2010/doc/pl94-171.pdf > > 1. Go to > http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/ and > download the access document that matches your MS Access version, either > PL2010_Access.accdb or PL2010_Access2003.mdb. > > 2. In the same directory, go to the folder your state is in and download > everything in the folder. > > 3. Unzip the files. > > 4. Open the PDF called 0FILE_STRUCTURE.pdf. Read the first page, it has > useful information. The go to the section marked "For Access Users" on page > 2. FOLLOW THESE INSTRUCTIONS EXACTLY. > > 5. After the tables are imported into Access, you should have the two data > tables and the geography table automatically joined by the LOGRECNO field. > >From here, you can use queries to extract tables on a single geography and > on the topics of your choice. Start a new query in design view. I recommend > starting all queries by adding the entire geography table until you get a > feel for which fields you don't need. > > 6. SUMLEV is the field that will let you extract a particular geography, > such as tracts or counties. You can find a full listing of SUMLEVs under > Chapter 4 of pl94-171_tech_doc.pdf. So if you want a table that has all the > census tracts in your state, type "140" under the Criteria field of the > SUMLEV column in your query design. > > 7. The other two tables list your data fields. The table names are given in > the back of 0FILE_STRUCTURE.pdf. > > 8. Export the query to the format of your choice - Excel, dbf, txt, ect. > Note that only the newest Excel program will handle more than 65,000 > columns. > > 9. If you are using the data in GIS, you will need to construct a GEOID > field to match the one in the shapefile. The file > 0GEOID_Construction_for_Matching.pdf provides formulas for doing this. > Concatenate the fields found in the geography half of your exported table > into a GEOID field. > > 10. Analyze! Analyze! Analyze! > > TIP: Compare the number of records in your shapefile with the numbers of > records in your exported table to make sure the table was extracted > correctly. > > Hopefully these steps make things less confusing, not more. Good luck! > > Mara > > > > > Mara Kaminowitz > GIS Analyst > ......................................................................... > Baltimore Metropolitan Council > Offices at McHenry Row > 1500 Whetstone Way > Suite 300 > Baltimore, MD 21230 > 410-732-0500 ext. 1030 > <mailto:mkaminowitz(a)baltometro.org> mkaminowitz(a)baltometro.org > <http://www.baltometro.org/> www.baltometro.org > > > _____ > > Confidentiality Statement > > This message may contain legally privileged and confidential information > that is intended only for the use of the recipient(s) named above. If you > are not an intended recipient, taking any action based on the contents of > this message is strictly prohibited. Please immediately notify the sender if > you have received this message in error. > > >

14 years, 4 months

[CTPP] RE: how to use Census Redistricting Summary Files in Access

by Harun Rashid

In following Mara Kaminowitz's work steps, I'm stuck with instructions in the Census document - '0FILE_STRUCTURE'. I am referring to page 2, instructions under 'For Access Users' - a. using Access 2007 in Windows XP b. Step 3 of Part 1 says 'Unzip the PL files you wish to load into Access and rename the file extension to csv' - after extracting with WinZip, I simply renamed these files to add .csv at end. File types remain 'PL file', as shown in Windows explorer c. Instructions in Part 2 seem to prepared for 2003 versions. When I try to follow similar steps in 2007, the files renamed in previous step are not recognized Any help will be appreciated. Harun Harun Rashid, AICP Senior GIS Planner BCD Council of Governments 1362 McMillan Avenue, Suite 100 North Charleston, SC 29405 T: 843.529.0400 F: 843.529.0305 www.bcdcog.org -----Original Message----- From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of ctpp-news-request(a)chrispy.net Sent: Friday, February 18, 2011 10:02 AM To: ctpp-news(a)chrispy.net Subject: ctpp-news Digest, Vol 84, Issue 24 Send ctpp-news mailing list submissions to ctpp-news(a)chrispy.net To subscribe or unsubscribe via the World Wide Web, visit http://www.chrispy.net/mailman/listinfo/ctpp-news or, via email, send a message with subject or body 'help' to ctpp-news-request(a)chrispy.net You can reach the person managing the list at ctpp-news-owner(a)chrispy.net When replying, please edit your Subject line so it is more specific than "Re: Contents of ctpp-news digest..." Today's Topics: 1. How to use the Census Redistricting Summary File in Access (Mara Kaminowitz) 2. Re: How to use the Census Redistricting Summary File in Access (Ed Christopher) 3. Re: 2010 Population Data Release (Ed Christopher) 4. Re: 2010 Population Data Release (wendell cox) ---------------------------------------------------------------------- Message: 1 Date: Fri, 18 Feb 2011 09:06:31 -0500 From: "Mara Kaminowitz" <mkaminowitz(a)baltometro.org> Subject: [CTPP] How to use the Census Redistricting Summary File in Access To: <ctpp-news(a)chrispy.net> Message-ID: <E7C1057941BA4C6AB416BCA0737364B2(a)bmc.net> Content-Type: text/plain; charset="us-ascii" Since I have seen a lot questions about this I thought I would post my personal notes. If your state hasn't come out yet I strongly suggest downloading a different state and practicing. Once you get the method down, it will be easy to repeat. These instructions are for Access 2003 but I think they are similar for Access 2007. You will need the following documents. Download them to your computer and keep them close at all times. 0FILE_STRUCTURE.pdf found at http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/0FILE_ST RUCTURE.pdf 0GEOID_Construction_for_Matching.pdf found at http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/0GEOID_C onstruction_for_Matching.pdf pl94-171_tech_doc.pdf found at http://www.census.gov/prod/cen2010/doc/pl94-171.pdf 1. Go to http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/ and download the access document that matches your MS Access version, either PL2010_Access.accdb or PL2010_Access2003.mdb. 2. In the same directory, go to the folder your state is in and download everything in the folder. 3. Unzip the files. 4. Open the PDF called 0FILE_STRUCTURE.pdf. Read the first page, it has useful information. The go to the section marked "For Access Users" on page 2. FOLLOW THESE INSTRUCTIONS EXACTLY. 5. After the tables are imported into Access, you should have the two data tables and the geography table automatically joined by the LOGRECNO field. >From here, you can use queries to extract tables on a single geography and on the topics of your choice. Start a new query in design view. I recommend starting all queries by adding the entire geography table until you get a feel for which fields you don't need. 6. SUMLEV is the field that will let you extract a particular geography, such as tracts or counties. You can find a full listing of SUMLEVs under Chapter 4 of pl94-171_tech_doc.pdf. So if you want a table that has all the census tracts in your state, type "140" under the Criteria field of the SUMLEV column in your query design. 7. The other two tables list your data fields. The table names are given in the back of 0FILE_STRUCTURE.pdf. 8. Export the query to the format of your choice - Excel, dbf, txt, ect. Note that only the newest Excel program will handle more than 65,000 columns. 9. If you are using the data in GIS, you will need to construct a GEOID field to match the one in the shapefile. The file 0GEOID_Construction_for_Matching.pdf provides formulas for doing this. Concatenate the fields found in the geography half of your exported table into a GEOID field. 10. Analyze! Analyze! Analyze! TIP: Compare the number of records in your shapefile with the numbers of records in your exported table to make sure the table was extracted correctly. Hopefully these steps make things less confusing, not more. Good luck! Mara Mara Kaminowitz GIS Analyst ......................................................................... Baltimore Metropolitan Council Offices at McHenry Row 1500 Whetstone Way Suite 300 Baltimore, MD 21230 410-732-0500 ext. 1030 <mailto:mkaminowitz(a)baltometro.org> mkaminowitz(a)baltometro.org <http://www.baltometro.org/> www.baltometro.org _____ Confidentiality Statement This message may contain legally privileged and confidential information that is intended only for the use of the recipient(s) named above. If you are not an intended recipient, taking any action based on the contents of this message is strictly prohibited. Please immediately notify the sender if you have received this message in error.

14 years, 4 months

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 March 2011