ctpp-news July 2011

ctpp-news@mailman.chrispy.net

18 participants
12 discussions

Join us for "CTPP Data Access Software Basics"

by Weinberger, Penelope

Hi all, Please join us for CTPP Software Basics on one of the three dates below. Seating is limited and first come first serve. This is a basic introduction to the CTPP data access software and functionality. You will learn how to register/log in, how to access a table, how to manipulate data, or move/swap dimensions within a table, how to download the data and more. If you like, you may first go to: http://ctpp.transportation.org/Pages/3yrdas.aspx and click on “take me to the data” to create a user profile and “poke around” a bit. Register and bring your questions to one of the three trainings below. See you there. Penelope Weinberger CTPP Program Manager AASHTO 202-624-3556 http://ctpp.transportation.org/Pages/default.aspx <http://ctpp.transportation.org/Pages/default.aspx> It's just as bad to not make a plan as to blindly follow the one you already have. <http://img.gotomeeting.com/g2mimages/1x1.gif> <http://www1.gotomeeting.com/g2w/images/61220428935832225/embed.jpg> CTPP Data Access Software Basics A guided tour through the CTPP Based on three year ACS, including software demo and Q&A Register for a session now by clicking a date below: Wed, May 4, 2011 10:00 AM - 11:00 AM EDT <https://www1.gotomeeting.com/register/209058312> Mon, May 16, 2011 3:30 PM - 4:30 PM EDT <https://www1.gotomeeting.com/register/999583609> Thu, Jun 2, 2011 2:00 PM - 3:00 PM EDT <https://www1.gotomeeting.com/register/899536416> Once registered you will receive an email confirming your registration with information you need to join the Webinar. System Requirements PC-based attendees Required: Windows® 7, Vista, XP or 2003 Server Macintosh®-based attendees Required: Mac OS® X 10.4.11 (Tiger®) or newer <http://img.gotomeeting.com/g2mimages/1x1.gif>

13 years, 1 month

5-year tables

by Kendra Watkins

Hi all, I am trying to pull together some information about the future 5 year CTPP release for the small area worker flows... what to expect in terms of variables, crosstabs, timeline etc. I've checked the primary sites but maybe I'm missing it. Specifically, does anyone know if the tables in the 5-year product will be the same as what is offered in the 3 year? Thanks in advance. Kendra Watkins Senior Planner Mid-Region Council of Governments 809 Copper NW, Albuquerque, NM 87102 (505)724-3601

13 years, 4 months

2010 Data Release Watch

by Ed Christopher

Next week the Census Bureau is poised to release the local-level 2010 Census population counts for Alaska, Florida, Georgia, Kentucky, Minnesota, Montana, New Mexico, North Dakota and Tennessee. Based on a quick and cursory review that leaves only MI, SC, WV, NY, MA, NH,ME,RI and PR. http://2010.census.gov/2010census/data/ -- Ed Christopher 708-283-3534 (V) 708-574-8131 (cell) FHWA RC-TST-PLN 4749 Lincoln Mall Drive, Suite 600 Matteson, IL 60443

13 years, 4 months

ACS data mapping including sampling error

by Elaine.Murakami＠dot.gov

Hi Everyone -- I attended a Federal Data Users Workshop at the Census Bureau last week. Nancy Torrieri (CB) announced this new ArcGIS extension at the meeting. I haven't had time to look at it, so I hope that some of you will take the time to do so, and report back to the listserv with your results! This is an extension that works with ArcGIS 9.3 or 10.0 Please visit the George Mason University website at: http://gesg.gmu.edu/census I LOVE the listserv! I am so glad that Ed Christopher set it up so many years ago when he chaired the TRB subcommittee on Census data. AND, I love how everyone helps each other out! The reason that I was at the Census Bureau is that they are conducting an ACS Program Review that they expect to run for 12-18 months. The workshop for people from Federal agencies was one of the 8 parts of the program review. They are also planning for ways for non-federal data users to be part of this review, including a CNSTAT workshop to be held in Fall 2011 (don't have a date), and other outreach from the ACS Communications team. James B. Treat, the Chief of the ACS Office, said they MUST look at reducing the size of the ACS products and need data users to convey their preferences and understand that trade-offs must be made. They need to know if the 3-year products are used, or people mostly want the 5-year products, and which geographic summary levels are needed. For example: how much tabulation for tracts split by place? vs. whole tracts. And finally, in case you had not heard, the Census Bureau announced a few weeks ago that they will be closing 6 of the 12 regional offices by the end of 2012. http://www.census.gov/newsroom/releases/archives/miscellaneous/realignment.… Elaine Murakami FHWA Office of Planning 206-220-4460 (in Seattle)

13 years, 4 months

More on 2010 Census Summary File 1

by Elaine.Murakami＠dot.gov

On Thursday, July 7 , the U.S. Census Bureau will release a 2010 Census Summary File 1 Microsoft Access table shell. The table shell will provide an easier way to access Summary File 1 information from the Census Bureau's FTP site http://www2.census.gov/census_2010/04-Summary_File_1/. Instructions for how to use the shell and work with the information will also be included in the .zip file. Some of the tables in Summary File 1 of interest to transportation planners include: P12 Sex by Age (23 age categories) P14 Sex by Age (Single years 0-19) P19 Household size and type by presence of children (19 cells) P28 Household type and Household size (16 cells) P42 Group Quarters by GQ Type (10 cells) H3 Housing Units H12 Average Household Size by Housing Tenure (own/rent) For more information on which states have been released, please see: http://2010.census.gov/news/press-kits/summary-file-1.html Elaine Murakami FHWA Office of Planning 206-220-4460

13 years, 5 months

RE: AFF2 download

by Morton, Brian J.

I was able to download a table containing county-level population statistics. But the downloaded file contained only the data for the particular county that was displayed in the results tab. The file did not contain data for the other 87 counties that I had also selected. ------------------------------------------ Brian J. Morton, Ph.D. Senior Research Associate Center for Urban and Regional Studies University of North Carolina Campus Box 3410 108 Battle Lane Chapel Hill, NC 27599-3410 USA (919) 962-8847 ________________________________________ From: ctpp-news-bounces(a)chrispy.net [ctpp-news-bounces(a)chrispy.net] on behalf of ctpp-news-request(a)chrispy.net [ctpp-news-request(a)chrispy.net] Sent: Friday, July 22, 2011 1:00 PM To: ctpp-news(a)chrispy.net Subject: ctpp-news Digest, Vol 89, Issue 11 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. AFF2 download (mkaminowitz(a)baltometro.org) 2. RE: AFF2 download (Colson, Regina) ---------------------------------------------------------------------- Message: 1 Date: Fri, 22 Jul 2011 09:37:58 -0400 From: <mkaminowitz(a)baltometro.org> Subject: [CTPP] AFF2 download To: <ctpp-news(a)chrispy.net> Message-ID: <000901cc4874$9215cc10$b6416430$(a)baltometro.org> Content-Type: text/plain; charset="us-ascii" Has anyone successfully downloaded a table in AFF2 in the last 24 hours or so? I can pull up the data I need but when I try to download it I either get a broken zip file or an error. My computer environment has changed so I am trying to figure out if the problem is the website or some setting on my computer. 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@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.

13 years, 5 months

AFF2 download

by mkaminowitz＠baltometro.org

Has anyone successfully downloaded a table in AFF2 in the last 24 hours or so? I can pull up the data I need but when I try to download it I either get a broken zip file or an error. My computer environment has changed so I am trying to figure out if the problem is the website or some setting on my computer. 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@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.

13 years, 5 months

Tips and Tricks for Using the New American FactFinder Webinar

by Ed Christopher

Below is information for a fee-based webinar dealing with using the New American FactFinder (AFF2). While this is the first webinar of this type that I have heard about we are also trying to get someone from the Census Bureau to do a FREE FHWA-sponsored webinar on AFF2. ------------------------- Tips and Tricks for Using the New American FactFinder Webinar July 28, 2011 2:00-3:30 PM EDT Are you frustrated by the Census Bureau's new American FactFinder? Can't find the data you want? This webinar will provide a how-to demonstration to get the tips and tricks you'll need to successfully use the new American FactFinder. The webinar will also cover when the Census Bureau plans to move other data sets, such as the American Community Survey, to the new FactFinder. Presenter: Nancy Gemignani Research Specialist, California State Census Data Center State of California Department of Finance, Demographic Research Unit Webinar pricing is as follows: * C2ER Members: Free * LMI Training Institute Member States: Free * APDU Members: $25 * All Others: $50 To Register go to: http://www.c2er.org/events/webinarreg.asp?id=47 -- Ed Christopher FHWA Resource Center Planning Team 4749 Lincoln Mall Drive, Suite 600 Matteson, IL 60443 708-283-3534 (V) 708-574-8131 (C)

13 years, 5 months

Directions on importing Summary File 1 into MS Access

by Elaine.Murakami＠dot.gov

Would anyone like to volunteer to test out these directions and then report back to the CTPP listserv on how well it worked? http://www2.census.gov/census_2010/04-Summary_File_1/0HowToUseMSAccessWi thSummaryFile1.pdf Sometimes when I send an email, the link gets broken. The full link ends in "....pdf" In the meantime, I am testing out the data access system at the Missouri data extractor (Dexter/uexplore) to look at Summary File 1. It is pretty easy, so far. http://mcdc.missouri.edu/cgi-bin/uexplore?/pub/data/sf12010 on this page, select the FIRST LINE "Datasets.html" then I selected Colorado. I chose counties in Denver 08031 using the FILTER (first set of boxes) and selected "tracts" and then I selected Table H 12 and got a comma-delimited file, which I read into excel. You have to select BOTH the geography fields in the LEFT box as well as the table (variable) fields in the RIGHT box. If you forget to select the geography fields, you will get the table variables without any corresponding geography, which is not very useful. Ask me how I know. J Finally, I thought that when the Census released the Summary File 1 files on the ftp site that it meant the data would also be in AFF2, but apparently this is not true. There are "quick tables" in AFF2, and these may satisfy your needs, but it is not the full set. Elaine Murakami FHWA Office of Planning 206-220-4460

13 years, 5 months

Flow data for areas smaller than 20,000

by Elaine.Murakami＠dot.gov

Someone from Massachusetts: Did you leave me a phone message? I did not get the correct phone number to return your call. The 2006-2008 CTPP does NOT have any places or towns with less than 20,000 population. The 20,000 population threshold is a rule established by the Census Bureau which limits the geographic units tabulated when 3 years of ACS are pulled together. The threshold for 1-year ACS tabulations is 65,000 population. After 5 years of accumulation, there is no geographic population threshold. Elaine Murakami FHWA Office of Planning 206-220-4460

13 years, 5 months

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-news July 2011