CTPP October 2011

ctpp@listserv.transportation.org

18 participants
16 discussions

RE: [CTPP] Geography file in ACS 2005-2009

by mkaminowitz＠baltometro.org

I am not sure if this is what you are looking for, but if you download the summary file data at <http://www2.census.gov/acs2005_2009_5yr/summaryfile/2005-2009_ACSSF_By_Stat e_All_Tables/> http://www2.census.gov/acs2005_2009_5yr/summaryfile/2005-2009_ACSSF_By_State _All_Tables/ there should be a text file in with the estimates called "g20095md.txt" or something similar for your state. This is the LOGRECNO to geography relationship table. It can be linked to the estimates in Access or ArcGIS. 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 From: Sulabh Aryal [mailto:saryal(a)richmondregional.org] Sent: Friday, October 28, 2011 3:23 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] Geography file in ACS 2005-2009 Hi everyone, I was trying to merge the geography file with the estimates file in ACS 2005-2009 5 Year data. I could not find the geography file which had Summary level, State, county and census tract FIPs as we had for Census 2000 and even Census 2010 summary files. The ACS documentation is rather very unclear and does not seem to be in order. Any remedies or suggestions? Thanks, Sulabh Sulabh Aryal Associate Planner Richmond Regional Planning District Commission 9211 Forest Hill Avenue, Suite 200 Richmond, VA 23235 Phone: 804.323.2033 3 Fax: 804.323.2025 <mailto:saryal(a)richmondregional.org> saryal(a)richmondregional.org 3 <http://www.richmondregional.org> www.richmondregional.org

13 years, 9 months

[CTPP] Geography file in ACS 2005-2009

by Sulabh Aryal

Hi everyone, I was trying to merge the geography file with the estimates file in ACS 2005-2009 5 Year data. I could not find the geography file which had Summary level, State, county and census tract FIPs as we had for Census 2000 and even Census 2010 summary files. The ACS documentation is rather very unclear and does not seem to be in order. Any remedies or suggestions? Thanks, Sulabh Sulabh Aryal Associate Planner Richmond Regional Planning District Commission 9211 Forest Hill Avenue, Suite 200 Richmond, VA 23235 Phone: 804.323.2033 3 Fax: 804.323.2025 saryal(a)richmondregional.org<mailto:saryal(a)richmondregional.org> 3 www.richmondregional.org<http://www.richmondregional.org>

13 years, 9 months

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

13 years, 9 months

[CTPP] question about HUD Low-Mod census tabulation

by Nancy Reger

I know this isn't a CTPP question- but I'm looking for the HUD Low Mod Income tabulation from post 2000 census at the census tract level. It seems like I read an email about this recently, but can't find it, and can't remember what I read. Has Census done their special tabulation for HUD at the census tract level from ACS? Are they going to? If not, what are people using for low/moderate income data for HUD related programs that require this? Nancy Reger, AICP Deputy Director, Transportation MORPC 111 Liberty St. Ste. 100 Columbus, Ohio 43215 nreger(a)morpc.org 614-233-4154

13 years, 9 months

[CTPP] RE: does anyone have a link to the field names in the 2005-2009 ACS file?

by Graham

Census Bureau field names are concatenation of the ACS base table ID + the line or item within the table. Labels for the field names can be found in the Census provided SAS programming, as Nancy G suggests. Or maybe more accessible - if you are not a SAS user - is the lookup table of all ACS data elements. Find this at: * For ACS 2008-10... http://www2.census.gov/acs2010_3yr/summaryfile/Sequence_Number_and_Table_Nu… * For ACS 2005-09... http://www2.census.gov/acs2009_5yr/summaryfile/Sequence_Number_and_Table_Nu… * Prior vintages (2008 and earlier) have same lookup, but the file had a different name: "merge_5_6.XLS" See http://www2.census.gov/acs2008_3yr/summaryfile/merge_5_6.xls If you want "intuitive" names, then you can develop a process or script to rename field (or calculate fields) with names to your liking (or custom calculations). I just finished, this morning, assembling the 150 pieces of the new ACS 3-year data. Always a joy. ________________________ 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<mailto:todd.graham(a)metc.state.mn.us> in: www.linkedin.com/in/toddgraham web: http://www.metrocouncil.org/data/ ________________________ From: Gemignani, Nancy Sent: Wednesday, October 26, 2011 11:03 AM To: ctpp-news(a)chrispy.net Subject: RE: [CTPP] does anyone have a link to the field names in the 2005-2009 ACS file? You can find the labels for every cell in the ACS Summary File in the Census Bureau's ACS FTP site. They provide SAS input statements and labels in their UserTools folder - ftp://ftp2.census.gov/acs2009_5yr/summaryfile/UserTools/ The file is called SF20095YR_SAS.zip<ftp://ftp2.census.gov/acs2009_5yr/summaryfile/UserTools/SF20095YR_SAS.zip> Even if you do not have SAS, you can just change the file extension to "txt" and open it in Excel. Remove everything but the labels then A simple 'text-to-columns' procedure in Excel and you will have a "look-up" table with the label in one column and the label in the next. Hope this helps. Nancy Gemignani California State Census Data Center Demographic Research Unit (916) 327-0103 ext 2550 From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Nancy Reger Sent: Wednesday, October 26, 2011 8:44 AM To: ctpp-news(a)chrispy.net Subject: [CTPP] does anyone have a link to the field names in the 2005-2009 ACS file? I'm trying to find a way to replace the field headers, B0010001 for example, with a more descriptive title. Does anyone have a way of doing this? I can't find the data dictionary for the ACS - does anyone have a link? Nancy Reger, AICP Deputy Director, Transportation MORPC 111 Liberty St. Ste. 100 Columbus, Ohio 43215 nreger(a)morpc.org 614-233-4154

13 years, 9 months

RE: [CTPP] does anyone have a link to the field names in the 2005-2009 ACS file?

by Kody Thurnau

Nancy, Following the other Nancy's comments, here is the technical document that has the step by step directions. On page 20 it gets at what you are looking for. Kody Thurnau GIS Specialist Duluth-Superior Metropolitan Interstate Council 221 West First Street Duluth, MN 55802 Phone: 218.529.7515 / kthurnau(a)ardc.org www.dsmic.org <http://www.dsmic.org> / www.ardc.org <http://www.ardc.org> From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Nancy Reger Sent: Wednesday, October 26, 2011 10:44 AM To: ctpp-news(a)chrispy.net Subject: [CTPP] does anyone have a link to the field names in the 2005-2009 ACS file? I'm trying to find a way to replace the field headers, B0010001 for example, with a more descriptive title. Does anyone have a way of doing this? I can't find the data dictionary for the ACS - does anyone have a link? Nancy Reger, AICP Deputy Director, Transportation MORPC 111 Liberty St. Ste. 100 Columbus, Ohio 43215 nreger(a)morpc.org 614-233-4154

13 years, 9 months

[CTPP] does anyone have a link to the field names in the 2005-2009 ACS file?

by Nancy Reger

I'm trying to find a way to replace the field headers, B0010001 for example, with a more descriptive title. Does anyone have a way of doing this? I can't find the data dictionary for the ACS - does anyone have a link? Nancy Reger, AICP Deputy Director, Transportation MORPC 111 Liberty St. Ste. 100 Columbus, Ohio 43215 nreger(a)morpc.org 614-233-4154

13 years, 9 months

[CTPP] MTA's Open Approach to Real-Time Bus Tracking - Webinar Sponsored by NCTR Transit GIS Clearinghouse

by Catala

SAVE THE DATE: WEDNESDAY NOVEMBER 16th 2011, 10:00-11:00AM EST A Webinar from the National Center for Transit Research's Transit GIS Clearinghouse: Real-Time Bus Tracking and Customer Information in New York City: MTA's Open Approach to Doing it Faster and Cheaper Webinar Objectives: The objectives of this webinar are to: * Inform other members of the transit and agency community regarding MTA's approach to developing and implementing a real-time bus tracking and customer information system at reduced costs and schedules * Offer lessons learned to peers considering a similar approach * Elicit interest among other agencies for co-investment in the open source, software package powering the back end of MTA's system Webinar Description: This Webinar will explain Metropolitan Transit Authority's (MTA) approach to developing its real-time bus tracking and customer information system (branded "MTA Bus Time") for its fleet of 6,000 buses and 2.5 million daily, bus riders in New York City. Mr. Michael Frumin will discuss the technical and procurement/contracting strategies that are allowing MTA to achieve its customer-facing and internal objectives for the project. These customer-facing objectives include minimizing the time to deliver the MTA Bus Time service to customers, and making the information widely available to all customers wherever, whenever, and however they may want it. The internal objectives are primarily to minimize both the capital and whole-life cost of the project, as well as to maintain the flexibility to change the system over time as technologies and needs evolve. The strategies to achieve these objectives are many. Among the most critical are the adoption of mobile and internet-based delivery of customer information; provisioning of free, publically available developer API's; use of open standard interfaces and commercially available technology components; sharing of on-bus infrastructure between projects and systems; open source software licensing; and MTA adopting the role of the overall systems integrator willing to contract with multiple vendors. Webinar Presenter: Michael Frumin is the Systems Engineering Manager for MTA's Bus Customer Information Systems (Bus CIS, aka "MTA Bus Time") project.In this capacity, he leads the technical portion of MTA's effort to develop a real-time bus tracking and customer information system which, when complete, will track a fleet of nearly 6,000 buses and serve over 2.5 million daily riders via a variety of web and mobile interfaces.Michael joined the MTA Bus Time team while finishing a graduate program at MIT in Transportation and Operations Research. Prior to MIT, he worked as a software developer and researcher at an open source R&D lab, a $4 billion hedge fund, and a number of internet startups. A consistent thread throughout his work has been open-licensed or otherwise online, publically accessible data streams, and the use and development of open source software. Michael lives in Brooklyn, NY, very close to where he grew up.He attended public schools in New York City and studied Computer Science at Stanford University.Michael has commuted and traveled via public transportation his entire life, including once traveling half way around the world (a good portion on the Trans-Siberian Railway), only to have to turn around and fly home the way he came. Connection Information https://www.livemeeting.com/cc/cutr/join?id=BusTracking&role=attend&pw=info… or Join the meeting. Audio Information Computer Audio To use computer audio, you need speakers and microphone, or a headset. Telephone conferencing Choose one of the following: Start Live Meeting client, and then in Voice & Video pane under Join Audio options, click Call Me. The conferencing service will call you at the number you specify. (Recommended) Use the information below to connect: Toll-free: +1 (866) 347-0397 Participant code: 3117 First Time Users: To save time before the meeting, check your system to make sure it is ready to use Microsoft Office Live Meeting. Notes Troubleshooting Unable to join the meeting? Follow these steps: Copy this address and paste it into your web browser: https://www.livemeeting.com/cc/cutr/join Copy and paste the required information: Meeting ID: BusTracking Entry Code: information Location: https://www.livemeeting.com/cc/cutr If you still cannot enter the meeting, contact Stephanie Zavacki: Email: zavacki(a)cutr.usf.edu 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. Martin Catala Manager GIS and Informatics Group Center for Urban Transportation Research 4202 East Fowler Ave (CUT100) Tampa, FL 33620 813-974-9791 catala(a)cutr.usf.edu http://www.transitgis.org Join the Transit GIS Listserv<http://lists.cutr.usf.edu/read/all_forums/subscribe?name=transitgis>

13 years, 9 months

RE: [CTPP] lowmod data

by Cook

To add a bit more information, data about the low to moderate income population, which is calculated for HUD from a special Census tabulation, is available from the 2006-8 ACS at the subcounty level from the 2006-8 ACS. As Guy notes below, it will not be available at the Census Tract level until next Spring. Based on my reading of the linked Powerpoint, lowmod data will not be available any longer at the blockgroup level. However, grant recipients can choose to "to conduct their own surveys at the block level". Current low mod data can downloaded from here: http://www.huduser.org/portal/datasets/cp/CHAS/data_download_chas.html For documentation and other lowmod data sets, search HUDUser.org for "CHAS data". Cliff Cook ----------------------------------------------------------------------------- Clifford Cook Planning Information Manager Cambridge Community Development Dept. 344 Broadway Cambridge, MA. 02139 617/349-4656 FAX 617/349-4669 TTY 617/349-4621 email => ccook(a)cambridgema.gov<mailto:ccook(a)cambridgema.gov> web site => <http://www.cambridgema.gov/~CDD/> From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Guy Rousseau Sent: Friday, October 21, 2011 10:40 AM To: ctpp-news(a)chrispy.net Subject: RE: [CTPP] lowmod data Looks like such 05-09 ACS tabulations for income will be available for tracts (nothing below) in the Spring of 2012, see slides #14 & #15: http://coscda.org/databases/2011%20Annual%20Conference%20Presentations/Neba… Guy Rousseau Surveys & Transportation Model Development Manager Atlanta Regional Commission 40 Courtland Street, NE Atlanta, GA 30303 404-463-3274 (work) 678-986-4344 (cell) grousseau(a)atlantaregional.com<mailto:grousseau(a)atlantaregional.com> www.atlantaregional.com<http://www.atlantaregional.com> CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use or disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender immediately and destroy all copies of the original message. From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Marie Bousfield Sent: Thursday, October 20, 2011 8:57 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] lowmod data Does anyone know if HUD has calculated the lowmod (low and moderate income) data by census tract and block group based on the 2005-2009 ACS data. These data were used for CDBG (community development block grants) and for some city programs. Thank you. Marie Bousfield

13 years, 9 months

RE: [CTPP] lowmod data

by Marie Bousfield

Thank you, Guy!! From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Guy Rousseau Sent: Friday, October 21, 2011 9:40 AM To: ctpp-news(a)chrispy.net Subject: RE: [CTPP] lowmod data Looks like such 05-09 ACS tabulations for income will be available for tracts (nothing below) in the Spring of 2012, see slides #14 & #15: http://coscda.org/databases/2011%20Annual%20Conference%20Presentations/Neba% 20Funiba%20-%20HUD%20Officials.ppt Guy Rousseau Surveys & Transportation Model Development Manager Atlanta Regional Commission 40 Courtland Street, NE Atlanta, GA 30303 404-463-3274 (work) 678-986-4344 (cell) grousseau(a)atlantaregional.com <http://www.atlantaregional.com> www.atlantaregional.com CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use or disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender immediately and destroy all copies of the original message. From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Marie Bousfield Sent: Thursday, October 20, 2011 8:57 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] lowmod data Does anyone know if HUD has calculated the lowmod (low and moderate income) data by census tract and block group based on the 2005-2009 ACS data. These data were used for CDBG (community development block grants) and for some city programs. Thank you. Marie Bousfield

13 years, 9 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 October 2011