CTPP

ctpp@listserv.transportation.org

5 participants
3069 discussions

RE: [CTPP] ACS Household Income by Household size and R Scripts

by Gemignani

1. Krishnan, you are correct, B19019 is the only table combining income and household size. I'm not familiar with "IPF" but you could create a tabulation of household ranges by household size using the PUMS file for the ACS. As a side note, Table B19019 is not available in the 5-year ACS. The 5-year has only B19119, Family income by family size. So, you cannot even get table B19019 for places below 20,000 pop. Nancy Gemignani California State Census Data Center Demographic Research Unit Department of Finance 915 L Street, 8th Floor Sacramento, CA 95814 (916) 327-0103 ext 2550 From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Krishnan Viswanathan Sent: Thursday, September 08, 2011 4:55 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] ACS Household Income by Household size and R Scripts This is a two part question: 1. AFAIK there is no direct Household income x HH size table available in the ACS. The only thing that is available is Table B19019 (Median HH income x HH Size). Am i correct? And the only way to obtain the desired HH Inc x HH size table is via IPF. If others have a better idea please let me know. 2. Has anyone written the R equivalent of the eak_0{n}.sas to read the summary files available here: http://www2.census.gov/acs2005_2009_5yr/summaryfile/UserTools/? If anyone has, do you mind sharing with me? TIA, Krishnan -- Krishnan Viswanathan 1101 High Meadow Dr Tallahassee FL 32311

13 years, 11 months

[CTPP] ACS Household Income by Household size and R Scripts

by Krishnan Viswanathan

This is a two part question: 1. AFAIK there is no direct Household income x HH size table available in the ACS. The only thing that is available is Table B19019 (Median HH income x HH Size). Am i correct? And the only way to obtain the desired HH Inc x HH size table is via IPF. If others have a better idea please let me know. 2. Has anyone written the R equivalent of the eak_0{n}.sas to read the summary files available here: http://www2.census.gov/acs2005_2009_5yr/summaryfile/UserTools/? If anyone has, do you mind sharing with me? TIA, Krishnan -- Krishnan Viswanathan 1101 High Meadow Dr Tallahassee FL 32311

13 years, 11 months

[CTPP] NCHRP 08-36 Task 98 report on Employment Data

by Elaine.Murakami＠dot.gov

Hi Everyone on the CTPPlist! Are you tired of me yet? Today is such a fun day, with lots of information to share. This report was finalized and posted TODAY. Thank you to Bruce Spear at Cambridge Systematics, and to Nanda Srinivasan, TRB staff for NCHRP, for getting this report completed! http://onlinepubs.trb.org/onlinepubs/nchrp/docs/NCHRP08-36(98)_FR.pdf My favorite pages are: 52, 63-79, and Chapter 4. Hope this intrigues you enough to print out and read the full report. Elaine Murakami FHWA Office of Planning 206-220-4460 (in Seattle)

13 years, 11 months

[CTPP] new CTPP Status Report available

by Elaine.Murakami＠dot.gov

A new report (labeled as August) is now posted on the FHWA webpage in both HTML and pdf formats. http://www.fhwa.dot.gov/planning/census_issues/ctpp/status_report/ This issue includes a brief article (by me) about Summary File 1 and different ways to access the data. Thank you to all the CTPP listserv members who have helped others learn about alternative sites to access the 2010 Census results. We will have a training session on American FactFinder 2 to be conducted by Census Bureau staff in early October. I hope to have more information by tomorrow! We were told today that "there is no going back" to the legacy AFF for the new round of ACS data, with weights incorporating 2010 Census results . Also, the 2010 decennial census Summary File 1 is on AFF2. Elaine Murakami FHWA Office of Planning 206-220-4460 (in Seattle)

13 years, 11 months

[CTPP] New SF1 report applications from MCDC

by Elaine.Murakami＠dot.gov

This new report generator from the Missouri Census Data Center that uses the Summary File 1 was shared with the State Data Center (SDC) network today, and Nathan Erlbaum of NYSDOT is sharing with you via me. From: sdc_mlist-bounces(a)lists.berkeley.edu [mailto:sdc_mlist-bounces(a)lists.berkeley.edu] On Behalf Of Blodgett, John G. Sent: Thursday, September 08, 2011 10:11 AM To: sdc_mlist(a)lists.berkeley.edu; 'CENSUS-L(a)LISTS.IRE.ORG'; 'mcdc-l(a)soslistserv.sos.mo.gov' Subject: New SF1 report applications from MCDC The Missouri Census Data Center announces two new report modules for displaying data from the 2010 Summary File 1 data sets. These modules are similar to ones we have developed for the American Community Survey and 2000 census Summary File 3 data. You access both of the applications using a shared front-end menu app that lets you choose up to 4 geographic areas. The URL is http://mcdc1.missouri.edu/sf1_2010/sf1_2010_menu.html (there is a link to it at the top of the Quick Links navigation box which appears at the upper-right of most page on the mcdc web site.) This works almost identically to the menu front end for the ACS profiles. You select your geography and hit the "Generate Report" button. This produces the profile report with columns of data for each of the chosen geographic areas. At the top of the report page is a link to "SF1 Detailed Tables Menu". The geography selected is passed through; you now get to select your detailed tables before hitting the "Generate Report" button to view a report where each selected table is displayed for each selected geographic area. As with our other profile report products this one provides links to dynamically generated charts associated with the tables and has "drill-down" links that let you view the detailed table from the profile items were derived. See the MCDC home page ( http://mcdc.missouri.edu/ ) for more details and pictures with arrows. The first line of the first picture is taken from a sample profile report and says Note: Use this application with caution, it's still in beta mode. John Blodgett OSEDA - 626 Clark Hall University of Missouri Columbia, MO 65211 573 884-2727 blodgettj(a)missouri.edu Hours: 8:00 - Noon, M-Th

13 years, 11 months

[CTPP] requesting CTPP on-site training

by Elaine.Murakami＠dot.gov

Of course, the travel budget for conducting on-site training is limited, but the first thing to do is ASK. The squeaky wheel gets the grease. Please send your training requests to Penelope Weinberger at AASHTO pweinberger(a)aashto.org She is coordinating the requests. The 3 people who are doing the training are: Penelope, Ed Christopher from FHWA Resource Center, and Liang Long from Cambridge Systematics. For a 1.5 day workshop, or even a 1 day workshop, it is best to have 2 people as the trainers. If you are looking for a computer-based training course, you will need to find a host with a computer training room. Often a State DOT has a training room that works. All the computers need web access, since the 2006-2008 CTPP data are accessed via the web, and not using mail-out CD's which we used for CTPP2000. After our first computer-based training session for this release of CTPP, 1.5 days was determined to be much better than a 1 day session. That is why the sessions in California are 1.5 days. Elaine Murakami FHWA Office of Planning 206-220-4460 (in Seattle)

13 years, 11 months

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

by Weinberger

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

13 years, 11 months

[CTPP] CTPP Hands-on training opportunity in California - 3 locations

by Weinberger

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

13 years, 11 months

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

13 years, 11 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(a)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(a)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

13 years, 11 months

Jump to page:

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