CTPP July 2011

ctpp@listserv.transportation.org

18 participants
15 discussions

[CTPP] Join us for "CTPP Data Access Software Basics"

by Weinberger

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>

12 years, 6 months

[CTPP] 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

12 years, 9 months

[CTPP] IPF macro?

by Krishnan Viswanathan

I am not sure if my original post came through and if its a copy i apologize for reposting (computer issues). Original email below. Unless I am missing something, Elaine's challenge has not yet been met or not responded to on this list. Anyway, while trying to IPF a table in R i ran across this resource (http://www.demog.berkeley.edu/~eddieh/datafitting.html) that might be useful to meet Elaine's challenge (there is a bunch of R code that will help meet the challenge). Elaine has already given Age x Mode, and Gender x Mode. Link to Age x Gender for workers 16 years and older [no MOEs included and obtained after raking the marginals of tables B08101 and B08006] given below so that all the data elements are available to meet her challenge. Download Age x Gender for workers 16 years and older from here: https://docs.google.com/leaf?id=0B0hTmthiX5dpMDRiZGE4ZWYtZTk0Mi00OTExLTgwYT… Krishnan On Fri, Mar 11, 2011 at 6:45 PM, <Elaine.Murakami(a)dot.gov> wrote: > > Here is the challenge! I do not know how to do IPF, but I know that many > of you out there can do it! > Attached are: ACS B08101 ; ACS B08006 for Maricopa County Arizona. > You can ignore the MOE cells for this IPF challenge. > > Also attached is a 3-way tabulation using IPUMS for Maricopa County AZ. > All are using 2009 ACS. > You will note that carpool is not broken out, as the question is really > in 2 parts (what mode, and then how many people), so this table could be > re-done by creating a carpool variable, if you wanted. > > We have an archived webinar on using IPUMS, if you are interested in > making your own tabs using ACS PUMS. > http://ctpp.transportation.org/Pages/webinardirectory.aspx > > Elaine > > -----Original Message----- > From: ctpp-news-bounces(a)chrispy.net > [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Erlbaum, Nathan > (DOT) > Sent: Friday, March 11, 2011 11:42 AM > To: ctpp-news(a)chrispy.net > Subject: RE: [CTPP] 2010 Data Release Watch > > Noted below is a question and a response that appeared on the list serve > earlier today and that suggests a solution method to creating data that > almost exists but is needed. I am reposting this to the list serve, > because I believe that this might be a worthwhile effort for someone who > is adept and familiar with IPF to provide a valuable resources to the > CTPP community in much the same way the ACS MOE spreadsheets have > evolved to explain how to deal with this statistical concept in an easy > to use way for the practitioner. > > Recently there was a post to the listserve by Jonnette Kreideweis about > the Census Conference in California and the call for papers. There was > also a recent post about the Planning Methods Conference. > > A spreadsheet that would answer the question posed is potentially a good > basis for a paper. Further it helps share skills with the larger > practitioner community based upon solutions and techniques that others > have implemented. When presented and discussed on a listserve then > many more people perhaps those who might never consider this as an > option may now have a solution to the very same problem or may move on > to adapt the method to other analysis areas. > > I want to encourage anyone who has the time to give it a try, maybe a > student can use this to apply what they have learned, or a modeler can > cannibalize something he/she has already used, many may benefit from you > efforts. > > > > ---------------------------------------------------------- > Nathan Erlbaum > Associate Transportation Analyst > Office of Policy, Planning & Performance New York State Department of > Transportation 50 Wolf Road, 6th Floor Albany, New York 12232 > > (Tel) 518.457.2967 > (Fax) 518.457.4944 > (E-mail) nerlbaum(a)dot.state.ny.us > (Web) www.nysdot.gov > > > > > >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> > Marcus Wigan wrote: > > ed > > > > a terribly simple question > > > > How best to do age group by gender by travel on the CTTP! > > best > > marc > >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> > > Ed Christopher's response: > > Unfortunately, there is no clean way to get Age by Gender by Mode (Means > of travel), that I know about, directly out of the current 3-year CTPP > data product nor the Standard Census ACS products for that matter. > However, there are some options that will get you close but they will > take a little work. > > Option 1. In CTPP take table 12201 ( Age by Mode to work) and table > 11203 (Age by Sex/gender)and run an IPF (Iterative Proportional > Fitting-fratar) routine between the two tables to get what you want. At > least I think it will work. > > Option 2. Do the same with standard ACS product tables B08006 (Sex by > Mode) and B08101 (Mode by Age). If you go this route I think these > tables may even exist in the 5-year ACS so you could do it at smaller > than Places over 20K population geography. > > Option 3. Just make your table using the PUMS data but you would be > limited to geographical areas of over 100K people. > > Over the years we has suggested that people use an IPF routine to make > tables that might not exist in the various data products. I would be > interested in hearing if anyone has actually done it. Have you? > > > > _______________________________________________ > ctpp-news mailing list > ctpp-news(a)chrispy.net > http://www.chrispy.net/mailman/listinfo/ctpp-news > -- Krishnan Viswanathan 1101 High Meadow Dr Tallahassee FL 32311 -- Krishnan Viswanathan 1101 High Meadow Dr Tallahassee FL 32311

12 years, 9 months

RE: [CTPP] IPF macro?

by Elaine.Murakami＠dot.gov

Here is the challenge! I do not know how to do IPF, but I know that many of you out there can do it! Attached are: ACS B08101 ; ACS B08006 for Maricopa County Arizona. You can ignore the MOE cells for this IPF challenge. Also attached is a 3-way tabulation using IPUMS for Maricopa County AZ. All are using 2009 ACS. You will note that carpool is not broken out, as the question is really in 2 parts (what mode, and then how many people), so this table could be re-done by creating a carpool variable, if you wanted. We have an archived webinar on using IPUMS, if you are interested in making your own tabs using ACS PUMS. http://ctpp.transportation.org/Pages/webinardirectory.aspx Elaine -----Original Message----- From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Erlbaum, Nathan (DOT) Sent: Friday, March 11, 2011 11:42 AM To: ctpp-news(a)chrispy.net Subject: RE: [CTPP] 2010 Data Release Watch Noted below is a question and a response that appeared on the list serve earlier today and that suggests a solution method to creating data that almost exists but is needed. I am reposting this to the list serve, because I believe that this might be a worthwhile effort for someone who is adept and familiar with IPF to provide a valuable resources to the CTPP community in much the same way the ACS MOE spreadsheets have evolved to explain how to deal with this statistical concept in an easy to use way for the practitioner. Recently there was a post to the listserve by Jonnette Kreideweis about the Census Conference in California and the call for papers. There was also a recent post about the Planning Methods Conference. A spreadsheet that would answer the question posed is potentially a good basis for a paper. Further it helps share skills with the larger practitioner community based upon solutions and techniques that others have implemented. When presented and discussed on a listserve then many more people perhaps those who might never consider this as an option may now have a solution to the very same problem or may move on to adapt the method to other analysis areas. I want to encourage anyone who has the time to give it a try, maybe a student can use this to apply what they have learned, or a modeler can cannibalize something he/she has already used, many may benefit from you efforts. ---------------------------------------------------------- Nathan Erlbaum Associate Transportation Analyst Office of Policy, Planning & Performance New York State Department of Transportation 50 Wolf Road, 6th Floor Albany, New York 12232 (Tel) 518.457.2967 (Fax) 518.457.4944 (E-mail) nerlbaum(a)dot.state.ny.us (Web) www.nysdot.gov >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Marcus Wigan wrote: > ed > > a terribly simple question > > How best to do age group by gender by travel on the CTTP! > best > marc >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Ed Christopher's response: Unfortunately, there is no clean way to get Age by Gender by Mode (Means of travel), that I know about, directly out of the current 3-year CTPP data product nor the Standard Census ACS products for that matter. However, there are some options that will get you close but they will take a little work. Option 1. In CTPP take table 12201 ( Age by Mode to work) and table 11203 (Age by Sex/gender)and run an IPF (Iterative Proportional Fitting-fratar) routine between the two tables to get what you want. At least I think it will work. Option 2. Do the same with standard ACS product tables B08006 (Sex by Mode) and B08101 (Mode by Age). If you go this route I think these tables may even exist in the 5-year ACS so you could do it at smaller than Places over 20K population geography. Option 3. Just make your table using the PUMS data but you would be limited to geographical areas of over 100K people. Over the years we has suggested that people use an IPF routine to make tables that might not exist in the various data products. I would be interested in hearing if anyone has actually done it. Have you?

12 years, 9 months

[CTPP] 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)

12 years, 9 months

[CTPP] 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

12 years, 9 months

[CTPP] RE: AFF2 download

by Morton

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

12 years, 9 months

[CTPP] 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(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.

12 years, 9 months

[CTPP] 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)

12 years, 9 months

RE: [CTPP] RE: Directions on importing Summary File 1 into MS Access

by Johnson

If someone has Access experience can help, I would love to know how to delete all the HI records from three tables I imported for testing purposes of the great Access instructions. I need to get the data out of there before KY's comes out and I don't use Access much. Thanks Linda J. ********************************* Linda J. Johnson C.A.R. Coordinator www.kentucky.com/greenspot page editor Lexington Herald-Leader (859) 231-3338 mailto:ljohnson1(a)herald-leader.com <mailto:ljohnson1(a)herald-leader.com> ********************************* In the interests of the environment, please do not print out this email. From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of JClark(a)bellevuewa.gov Sent: Thursday, July 14, 2011 12:29 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] RE: Directions on importing Summary File 1 into MS Access Hi I did the MS ACCESS Directions and it worked and was easy. I did the HI example (except I chose a different table than the example) and I guess with interruptions it still was fairly brief; e.g. less than half hour. Judy Clark Modeling and Forecasting Manager City of Bellevue (425) 452-7858 www.bellevuewa.gov <http://www.bellevuewa.gov> From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Elaine.Murakami(a)dot.gov Sent: Wednesday, July 13, 2011 9:51 AM To: ctpp-news(a)chrispy.net Subject: [CTPP] Directions on importing Summary File 1 into MS Access 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

12 years, 9 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 July 2011