ctpp-news August 2011

ctpp-news@mailman.chrispy.net

39 participants
25 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>

14 years, 4 months

FW: [TMIP-L] CTPP Hands-on training opportunity in California - 3 locations

by Weinberger, Penelope

Apologies for cross and double posting. Penelope Weinberger CTPP Program Manager AASHTO 202-624-3556 http://ctpp.transportation.org/Pages/default.aspx <http://ctpp.transportation.org/Pages/default.aspx> Hello, The FHWA, AASHTO and Caltrans are sponsoring and hosting three CTPP data access software hands-on training in September. In these hands on sessions you will learn all about the CTPP, including * What questions are the basis for the data * How to get the data * History of the CTPP * Data products available from CTPP * Data Caveats * Geography * Tables * Creating data profiles The training sessions will be held as follows: When: September 19-20, 2011 Where: Caltrans District 4 (Oakland) 111 Grand Ave Oakland, CA 94612 What time: September 19 - 12:30-4:00pm September 20 - 8:30 - 11:45am 1:00 - 4:00pm ____________________________________________________ When: September 21-22, 2011 Where: Caltrans Training Center 1616 29th Street Sacramento, CA 95816 What time: September 21 - 12:30-4:00pm September 22 - 8:30 - 11:45am 1:00 - 4:00pm _____________________________________________________ When: September 26-27, 2011 Where: Caltrans District 7 (Los Angeles) 100 S. Main Street Los Angeles, CA 90012 What time: September 26 - 12:30-4:00pm September 27 - 8:30 - 11:45am 1:00 - 4:00pm Please register for a training session by replying to Diana Portillo [diana_portillo(a)dot.ca.gov] with the following information: Name/Title Organization Address Phone # Email Special Accommodation The session you wish to attend (Oakland, Sacramento or Los Angeles) Seating is limited and available on a first-come-first-served basis. One (1) representative per organization only. If you have any questions, please contact Diana Portillo. Thank you. Diana Portillo, Research Program Specialist Office of Travel Forecasting and Analysis Transportation System Information 916-653-3182 -------------------------------------------- This message is being sent on behalf of the TMIP-L email discussion list. To change your email address or other settings, go to: http://listserv.tamu.edu/archives/tmip-l.html To unsubscribe from the list, send an email to: listserv(a)listserv.tamu.edu <mailto:listserv@listserv.tamu.edu&BODY=Signoff%20TMIP-L> . Put "SIGNOFF TMIP-L" (without quotes) in the body of the email. Be sure to leave the SUBJECT line blank. The comments and opinions expressed in emails posted to the TMIP-L Listserv(c) are solely those of the author. They do not reflect the policy or position of the U.S. Department of Transportation, the Federal Highway Administration, the Texas Transportation Institute, or Texas A&M University.

14 years, 6 months

CTPP Hands-on training opportunity in California - 3 locations

by Weinberger, Penelope

Hello, The FHWA, AASHTO and Caltrans are sponsoring and hosting three CTPP data access software hands-on training in September. In these hands on sessions you will learn all about the CTPP, including * What questions are the basis for the data * How to get the data * History of the CTPP * Data products available from CTPP * Data Caveats * Geography * Tables * Creating data profiles The training sessions will be held as follows: When: September 19-20, 2011 Where: Caltrans District 4 (Oakland) 111 Grand Ave Oakland, CA 94612 What time: September 19 - 12:30-4:00pm September 20 - 8:30 - 11:45am 1:00 - 4:00pm ____________________________________________________ When: September 21-22, 2011 Where: Caltrans Training Center 1616 29th Street Sacramento, CA 95816 What time: September 21 - 12:30-4:00pm September 22 - 8:30 - 11:45am 1:00 - 4:00pm _____________________________________________________ When: September 26-27, 2011 Where: Caltrans District 7 (Los Angeles) 100 S. Main Street Los Angeles, CA 90012 What time: September 26 - 12:30-4:00pm September 27 - 8:30 - 11:45am 1:00 - 4:00pm Please register for a training session by replying to Diana Portillo [diana_portillo(a)dot.ca.gov] with the following information: Name/Title Organization Address Phone # Email Special Accommodation The session you wish to attend (Oakland, Sacramento or Los Angeles) Seating is limited and available on a first-come-first-served basis. One (1) representative per organization only. If you have any questions, please contact Diana Portillo. Thank you. Diana Portillo, Research Program Specialist Office of Travel Forecasting and Analysis Transportation System Information 916-653-3182

14 years, 6 months

SF1 Access Shell Import Error

by Kevin Garcia

Hello Everybody, I've been following the steps to import the SF1 data into the Access table shell. Everything was working smoothly until I got to the 8th table to import, and then I got the following message: 'Cannot open database " . It may not be a database that your application recognizes, or the file may be corrupt.' (See screenshot below.) I tried importing the next table, and got the same result. Has anyone run into this problem? I'm at a loss because, as I said, everything was working fine previously. Any help is much appreciated. Thanks! [cid:image003.jpg@01CC66FD.0F351D80] Best wishes, Kevin J. Garcia Data Resources Planner Northwestern Indiana Regional Planning Commission (219) 763-6060 x 125 kgarcia(a)nirpc.org p.s. I used a program called Greenshot to capture the above image. It's like a much better "print screen". It's free and totally worth checking out: http://getgreenshot.org/downloads/. I share this with all my friends!

14 years, 6 months

Re: [CTPP] Re: AFF2 and its well-known faults

by mkaminowitz＠baltometro.org

Can data from third party distributors be trusted? I would like to break free of AFF2, in fact I have to since half the time the data won't download or the table is mysteriously unavailable. But I am concerned about relying on data that has been removed from the original source. If there were an error in a table the the Census corrected the data, would the correction carry over to these sites? Mara -----Original Message----- From: Graham, Todd [mailto:todd.graham@metc.state.mn.us] Sent: Thursday, August 25, 2011 05:36 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] Re: AFF2 and its well-known faults I know you?re frustrated with AFF2. I no longer recommend it to anyone. So if you need Census 2010 summary tabulations, here are best online alternatives to AFF2 (my picks): ?http://mcdc.missouri.edu/pub/data/sf12010/Datasets.html if you need many tables for a large number of locations (for example, all Census Tracts in Minnesota). User interface looks complex the first time ? but you?ll see it?s easy ? and allows output in SAS, or flat-file or other formats. ?http://nhgis.org if you need a few tables (a few topics) for a large number of locations + you want ArcGIS shapefile too. ?http://census.ire.org/data/bulkdata.html if you just need one table (1 at a time) for a large number of locations. This is the quickest to navigate. The drawback is: this site does not provide descriptive column headings/labels. You?ll need SF1 documentation to decipher and re-label the column headings it provides. ________________________ Todd Graham Principal Forecaster and Project Manager Metropolitan Council 390 Robert Street North Saint Paul, MN 55101 ph: 651/602-1322 email: todd.graham(a)metc.state.mn.us in: www.linkedin.com/in/toddgraham web: http://www.metrocouncil.org/data/ ________________________ From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Jonathan Lupton Sent: Wednesday, August 24, 2011 2:42 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] BEA data vs AFF2 and its well-known faults I know it?s a lost cause to expect the Census Bureau to see reason and dump AFF2, which sometime this fall will become their only portal for census and ACS data. But anyone who believes a data searching and downloading product has to require tutorials and special training, or has to be clunky, needlessly complex, visually confusing, and counter-intuitive should visit the BEA?s new web site, and try downloading economic data for his/her local area. The steps are quick, the icons are clear and intuitive, and you can get to some pretty complex stuff in a series of steps that leaves you feeling smart. By comparison, speaking only for myself, I always come away from AFF2 either feeling dumb, or like a shoplifter who actually got away with something useful, despite the risks I had to take and the danger of complete failure. However, I do appreciate the efforts of Elaine and others to provide tips and data-downloading alternatives to AFF2 ? thanks! Jonathan Lupton AICP Research Planner Metroplan Little Rock AR 501-372-3300

14 years, 6 months

Re: [CTPP] RE: AFF2 and its well-known faults

by Patty Becker

I just took a look at the ire site. It does not appear to allow selection of a subset beneath the state level -- e.g., in my case, all the tracts in the City of Detroit. It would be helpful if the user could specify a placefp code beneath the state level. At 05:28 PM 8/26/2011, you wrote: >Simplicity? Would be no easier to use if it were in Greek. > >On Fri, Aug 26, 2011 at 8:23 PM, Overberg, Paul ><<mailto:poverber@usatoday.com>poverber(a)usatoday.com> wrote: > ><http://Census.ire.org>Census.ire.org only >allows single-table downloads via bulk download >(geo within geo), but its table browser allows >download of many tables at once for one or a few geos. > > > >The table browser also shows descriptive column >headings via a toggle to show or hide the table >browser. Descriptive labels arent included in the download file. > > > >Two other key features: > >-- It lets you look at a table for multiple >levels of geography, so you can inspect >side-by-side (for instance) a table for 4 >tracts, 2 cities, a metro and a state. Then you >can download just those geos for that table. > >-- Finally, both bulk download and table >browser automatically link equivalent Census >2000 SF1 and Census 2010 SF1 tables for most >geos and calculates the change and % change. > > > >We designed it for journalists, so data mavens >should enjoy its simplicity. We welcome your >feedback. Code is posted: ><https://github.com/ireapps/census>https://github.com/ireapps/census > > > >Paul Overberg > >USA TODAY > > > > > > > > > >From: ><mailto:ctpp-news-bounces@chrispy.net>ctpp-news-bounces(a)chrispy.net >[mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Graham, Todd >Sent: Thursday, August 25, 2011 5:36 PM > >To: <mailto:ctpp-news@chrispy.net>ctpp-news(a)chrispy.net >Subject: [CTPP] Re: AFF2 and its well-known faults > > > >I know youre frustrated with AFF2. I no longer recommend it to anyone. > > > >So if you need Census 2010 summary tabulations, >here are best online alternatives to AFF2 (my picks): > > > >· ><http://mcdc.missouri.edu/pub/data/sf12010/Datasets.html>http://mcdc.missouri.edu/pub/data/sf12010/Datasets.html >if you need many tables for a large number of >locations (for example, all Census Tracts in >Minnesota). User interface looks complex the >first time but youll see its easy and >allows output in SAS, or flat-file or other formats. > >· <http://nhgis.org>http://nhgis.org if >you need a few tables (a few topics) for a large >number of locations + you want ArcGIS shapefile too. > >· ><http://census.ire.org/data/bulkdata.html>http://census.ire.org/data/bulkdata.html >if you just need one table (1 at a time) for a >large number of locations. This is the quickest >to navigate. The drawback is: this site does not >provide descriptive column headings/labels. >Youll need SF1 documentation to decipher and >re-label the column headings it provides. > > > > > >________________________ > >Todd Graham >Principal Forecaster and Project Manager >Metropolitan Council >390 Robert Street North >Saint Paul, MN 55101 > >ph: <tel:651%2F602-1322>651/602-1322 >email: <mailto:todd.graham@metc.state.mn.us>todd.graham(a)metc.state.mn.us >in: <http://www.linkedin.com/in/toddgraham>www.linkedin.com/in/toddgraham >web: <http://www.metrocouncil.org/data/>http://www.metrocouncil.org/data/ >________________________ > > > >From: ><mailto:ctpp-news-bounces@chrispy.net>ctpp-news-bounces(a)chrispy.net >[mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Jonathan Lupton >Sent: Wednesday, August 24, 2011 2:42 PM >To: <mailto:ctpp-news@chrispy.net>ctpp-news(a)chrispy.net >Subject: [CTPP] BEA data vs AFF2 and its well-known faults > > > >I know its a lost cause to expect the Census >Bureau to see reason and dump AFF2, which >sometime this fall will become their only portal >for census and ACS data. But anyone who believes >a data searching and downloading product has to >require tutorials and special training, or has >to be clunky, needlessly complex, visually >confusing, and counter-intuitive should visit >the BEAs new web site, and try downloading >economic data for his/her local area. The steps >are quick, the icons are clear and intuitive, >and you can get to some pretty complex stuff in >a series of steps that leaves you feeling smart. > > > >By comparison, speaking only for myself, I >always come away from AFF2 either feeling dumb, >or like a shoplifter who actually got away with >something useful, despite the risks I had to >take and the danger of complete failure. > > > >However, I do appreciate the efforts of Elaine >and others to provide tips and data-downloading alternatives to AFF2 thanks! > > > >Jonathan Lupton AICP > >Research Planner > >Metroplan > >Little Rock AR > ><tel:501-372-3300>501-372-3300 > > > > > >_______________________________________________ >ctpp-news mailing list ><mailto:ctpp-news@chrispy.net>ctpp-news(a)chrispy.net >http://www.chrispy.net/mailman/listinfo/ctpp-news > > > > >-- >-- >Wendell Cox >Demographia | Wendell Cox Consultancy - St. >Louis Missouri-Illinois metropolitan region > >Visiting Professor, Conservatoire National des Arts et Metiers, Paris >+1.618 632 8507 > ><http://www.demographia.com>www.demographia.com >| www.publicpurpose.com | <http://www.rentalcartours.net>www.rentalcartours.net > >Books & Publications >WAR ON THE DREAM: How Anti-Sprawl Policy Threatens the Quality of Life ><http://www.demographia.com/wod1.pdf>http://www.demographia.com/wod1.pdf > > >7th ANNUAL DEMOGRAPHIA INTERNATIONAL HOUSING >AFFORDABILITY SURVEY >(<http://www.demographia.com/dhi.pdf>http://www.demographia.com/dhi.pdf) > >THE WAL-MART REVOLUTION: How Big-Box Stores >Benefit Consumers, Workers, and the Economy >By Richard Vedder & Wendell Cox > >_______________________________________________ >ctpp-news mailing list >ctpp-news(a)chrispy.net >http://www.chrispy.net/mailman/listinfo/ctpp-news ------------------------------------------------------------------------------------------------- Patricia C. (Patty) Becker 248/354-6520 APB Associates/SEMCC FAX 248/354-6645 28300 Franklin Road Home 248/355-2428 Southfield, MI 48034 pbecker(a)umich.edu

14 years, 6 months

BEA data vs AFF2 and its well-known faults

by Jonathan Lupton

I know it's a lost cause to expect the Census Bureau to see reason and dump AFF2, which sometime this fall will become their only portal for census and ACS data. But anyone who believes a data searching and downloading product has to require tutorials and special training, or has to be clunky, needlessly complex, visually confusing, and counter-intuitive should visit the BEA's new web site, and try downloading economic data for his/her local area. The steps are quick, the icons are clear and intuitive, and you can get to some pretty complex stuff in a series of steps that leaves you feeling smart. By comparison, speaking only for myself, I always come away from AFF2 either feeling dumb, or like a shoplifter who actually got away with something useful, despite the risks I had to take and the danger of complete failure. However, I do appreciate the efforts of Elaine and others to provide tips and data-downloading alternatives to AFF2 - thanks! Jonathan Lupton AICP Research Planner Metroplan Little Rock AR 501-372-3300

14 years, 6 months

Re: [CTPP] BEA data vs AFF2 and its well-known faults

by Gyanesh Lama

I couldn't agree more. Sometime I wonder what kind of thinking goes behind designing AFF2. Just because it's not commercial, does not needlessly have to be complex. It defeats its own purpose. >>> "Jonathan Lupton" <jlupton(a)metroplan.org> 08/24/2011 2:42 PM >>> I know it's a lost cause to expect the Census Bureau to see reason and dump AFF2, which sometime this fall will become their only portal for census and ACS data. But anyone who believes a data searching and downloading product has to require tutorials and special training, or has to be clunky, needlessly complex, visually confusing, and counter-intuitive should visit the BEA's new web site, and try downloading economic data for his/her local area. The steps are quick, the icons are clear and intuitive, and you can get to some pretty complex stuff in a series of steps that leaves you feeling smart. By comparison, speaking only for myself, I always come away from AFF2 either feeling dumb, or like a shoplifter who actually got away with something useful, despite the risks I had to take and the danger of complete failure. However, I do appreciate the efforts of Elaine and others to provide tips and data-downloading alternatives to AFF2 - thanks! Jonathan Lupton AICP Research Planner Metroplan Little Rock AR 501-372-3300

14 years, 6 months

Hints on using AFF2 for 2010 Census Summary File 1

by Elaine.Murakami＠dot.gov

Hi Everyone - Hope you are having a wonderful summer! Here is a small "helpful hints" document on using American FactFinder 2 with 2010 Census Summary File 1. Hope these 2 handouts are useful to you. Thank you to everyone who helped create and improve them: Linda Clark at the Seattle Regional Office of the Census Bureau, Ed Christopher from FHWA Resource Center, and Liang Long from Cambridge Systematics. You don't have to use Census Bureau's American FactFinder 2. There are other ways to get the Summary File 1 data. The August issue of the CTPP Status Report includes a link to instructions of using the Microsoft Access Table Shell, and the Missouri Census Data Center. We are expecting final approval of the August issue any day now. Elaine Murakami FHWA Office of Planning 206-220-4460 (in Seattle)

14 years, 6 months

REMINDER: Early bird registration rate for the TRB Census conference in October ends tomorrow, AUGUST 25

by Elaine.Murakami＠dot.gov

TRB Conference "Using Census Data for Transportation Applications" October 25- 27, 2011 at the Beckman Center in Irvine, CA http://www.cvent.com/events/using-census-data-for-transportation-applica tions-conference/event-summary-fecf178bb83a468d86c4d85de1a3bcbf.aspx Also, the hotel block is open until Sept 24, but they may run out of rooms, so an early reservation is recommended. Elaine Murakami FHWA Office of Planning 206-220-4460 (in Seattle)

14 years, 6 months

2026

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