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>
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
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
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.orgwww.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
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
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.eduhttp://www.transitgis.org
Join the Transit GIS Listserv<http://lists.cutr.usf.edu/read/all_forums/subscribe?name=transitgis>
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
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