CTPP January 2020

ctpp@listserv.transportation.org

22 participants
11 discussions

[CTPP] FW: Question Regarding Mapping Low Income Population by Census Tract

by Weinberger Penelope

Hey CTPPers, I received this query, I welcome your thoughts. We are currently looking at environmental justice factors on Urban Arterials in the Denver Metro area, and I was wondering if you might have any insights into mapping low income population by census tract. The only data I have been able to find includes low and moderate income (from HUD), and I am having trouble even finding that data at the tract level. Do you know of a good data source for this? Any help or insights would be greatly appreciated.

4 years, 3 months

[CTPP] Re: Question Regarding Mapping Low Income Population by Census Tract

by jonathan lupton

I agree with Patty that data.census.gov still isn’t up to par, but I’m beginning to get the hang of it. There’s no going back (as best I understand it) and if you don’t make the switch you’ll be pretty flatfooted when they pull FactFinder away this summer. While not denying that the changeover from AFF to data.census.gov is challenging, let me throw out a few hacks that I’ve found helpful: 1. If you’re getting up in years (like me!) you might ask a younger staffer to play with it a while. I’m saying that because a 20-something in my office showed me a neat trick I’d completely missed. I’m not downplaying the value of experience, but the younger generation might have an edge in a few areas. 2. Be sure to use Google Chrome for data.census.gov, this has the best interface. 3. I have written a “cheat sheet” of key table numbers to help me find the critical tables I used a lot in FactFinder, like DP-02 (selected Social characteristics), DP-03 (economic characteristics) and so on. While the “search” feature in data.census.gov is arguably better, it can be off-putting. Don’t forget you can select by a list of topics in the “advanced search” mode. 4. The staff at data.census.gov do listen to suggestions and get back to you with questions and complaints via email. 5. You can select data straight from a table in data.census.gov and paste it into an Excel spreadsheet. It’s way faster than any previous downloading system, but (for now at least) limited by the fact that you can only select a few cells, you can’t (yet?) do shift-ctrl-right or shift-ctrl-down to grab an entire table (if some data.census.gov staff are reading this please please please this would help). Jonathan Lupton AICP Metroplan Little Rock AR From: Patricia Becker <pbecker(a)umich.edu> Sent: Wednesday, January 29, 2020 3:34 PM To: ctpp-news(a)mailman.chrispy.net Subject: [CTPP] Re: Question Regarding Mapping Low Income Population by Census Tract I apologize for getting my years mixed up. 2018 5 year ACS is on data.census.gov<http://data.census.gov>, and 2017 is on American FactFinder. Patty Becker On Wed, Jan 29, 2020 at 4:04 PM Sally Goodman <Sgoodman(a)actransit.org<mailto:Sgoodman(a)actransit.org>> wrote: We do, too. The key is to define low-income for your analysis. In the SF Bay Area transit agencies all use 200% of the Federal Poverty Rate as the low-income cut off, and you should be able to get Census data on that basis. For example table B17026, “RATIO OF INCOME TO POVERTY LEVEL OF FAMILIES IN THE PAST 12 MONTHS” shows the population (in this case, number of families) with income under 50% of the federal poverty level, 50-74% of the FPL, and so on, up to 5 times the FPL. You should be able to find other data like that by tract, and even by block group. SALLY GOODMAN Title VI Program Administrator Alameda-Contra Costa Transit District 1600 Franklin Street, Oakland 94612 510-891-4719 | sgoodman(a)actransit.org<mailto:sgoodman(a)actransit.org> | www.actransit.org/CivilRights<http://www.actransit.org/CivilRights> From: Jackie Eastwood <jeastwood(a)lacrossecounty.org<mailto:jeastwood(a)lacrossecounty.org>> Sent: Wednesday, January 29, 2020 11:05 AM To: ctpp-news(a)mailman.chrispy.net<mailto:ctpp-news(a)mailman.chrispy.net> Subject: [CTPP] Re: Question Regarding Mapping Low Income Population by Census Tract We use ratio of income to poverty. You can define low-income as the poverty line or some percentage of the poverty line. We use 150%. Jackie Eastwood Transportation Planner La Crosse Area Planning Committee 212 6th St N, Room 1200 La Crosse Wi 54601 608.785.6141 or 608.792.0520 (cell) From: Weinberger Penelope <pweinberger(a)aashto.org<mailto:pweinberger(a)aashto.org>> Sent: Wednesday, January 29, 2020 12:58 PM To: ctpp-news(a)chrispy.net<mailto:ctpp-news(a)chrispy.net> Subject: [CTPP] FW: Question Regarding Mapping Low Income Population by Census Tract Hey CTPPers, I received this query, I welcome your thoughts. We are currently looking at environmental justice factors on Urban Arterials in the Denver Metro area, and I was wondering if you might have any insights into mapping low income population by census tract. The only data I have been able to find includes low and moderate income (from HUD), and I am having trouble even finding that data at the tract level. Do you know of a good data source for this? Any help or insights would be greatly appreciated. PRIVATE AND CONFIDENTIAL This e-mail and attachments are intended for the addressed recipient only. If you are not the correct recipient please notify the sender of the delivery error and delete this message. Improper disclosure, copying, distribution, retransmission, or use of information from this e-mail is Prohibited, and may result in liability and damages for misuse of this information. _______________________________________________ ctpp-news mailing list -- ctpp-news(a)mailman.chrispy.net<mailto:ctpp-news(a)mailman.chrispy.net> To unsubscribe send an email to ctpp-news-leave(a)mailman.chrispy.net<mailto:ctpp-news-leave(a)mailman.chrispy.net> -- Patricia C. (Patty) Becker APB Associates/Southeast Michigan Census Council (SEMCC) 28332 Franklin Rd, Southfield, MI 48034 office: 248-354-6520 home:248-355-2428 pbecker(a)umich.edu<mailto:pbecker(a)umich.edu>

4 years, 3 months

[CTPP] Re: FW: Question Regarding Mapping Low Income Population by Census Tract

by Chuck Imbrogno

FTA uses Table B17024 (AGE BY RATIO OF INCOME TO POVERTY LEVEL IN THE PAST 12 MONTHS) from the 5-year ACS for the low income population data they need in their urban formula assistance calculations. FTA uses Urban areas as the geography for their calculations. But the table also provides data at the Tract level. As Patty noted – the error estimates are huge. Chuck Imbrogno, Models/Data Manager Southwestern Pennsylvania Commission Two Chatham Center – Suite 500 112 Washington Place Pittsburgh, PA 15219-3451 voice: 412-391-5590 ext 319 fax: 412-391-9160 From: Patricia Becker [mailto:pbecker(a)umich.edu] Sent: Wednesday, January 29, 2020 2:25 PM To: ctpp-news(a)mailman.chrispy.net Cc: ctpp-news(a)chrispy.net Subject: [CTPP] Re: FW: Question Regarding Mapping Low Income Population by Census Tract If you're looking for median household income, it should be available at the tract level in the 2019 five year ACS data. You have to go to data.census.gov to get access to that data set -- good luck. If you're willing to settle for the 2018 file (which is 80% the same data), you should still be able to go to American Factfinder (factfinder.census.gov), where access is better. Bear in mind that the margins of error on income data at the tract level are huge. Patty Becker On Wed, Jan 29, 2020 at 2:09 PM Weinberger Penelope <pweinberger(a)aashto.org> wrote: Hey CTPPers, I received this query, I welcome your thoughts. We are currently looking at environmental justice factors on Urban Arterials in the Denver Metro area, and I was wondering if you might have any insights into mapping low income population by census tract. The only data I have been able to find includes low and moderate income (from HUD), and I am having trouble even finding that data at the tract level. Do you know of a good data source for this? Any help or insights would be greatly appreciated. _______________________________________________ ctpp-news mailing list -- ctpp-news(a)mailman.chrispy.net To unsubscribe send an email to ctpp-news-leave(a)mailman.chrispy.net -- Patricia C. (Patty) Becker APB Associates/Southeast Michigan Census Council (SEMCC) 28332 Franklin Rd, Southfield, MI 48034 office: 248-354-6520 home:248-355-2428 pbecker(a)umich.edu

4 years, 3 months

[CTPP] Re: Troubles with data.census.gov

by Jami Dennis

This is wonderful! Thanks for sharing it! > On Jan 23, 2020, at 8:23 AM, Alex Karner <alex.karner(a)gmail.com> wrote: > > > Everyone should check out Kyle Walker's tidycensus package for R. It's a wrapper for the various census APIs and makes downloading/importing/mapping/visualizing a breeze: https://walkerke.github.io/tidycensus/articles/basic-usage.html > > I no longer access census data using any other method. > >> On Thu, Jan 23, 2020 at 10:04 AM Jami Dennis <jami(a)geodetic.xyz> wrote: >> Totally agree! I ended up downloading the summary files and importing them into ms sql databases. Then just query what i want from there. If anyone wants those i have the files exported by state so should be easily imported into SQL. You will need to know sql and understand the summary file and geography relationships but it isnt too difficult and i can provide sample queries if needed. >> >> -Jami >> >> Jami Dennis >> Geodetic Analysis, llc >> Jami(a)geodetic.xyz >> >>>> On Jan 23, 2020, at 7:54 AM, Vince Post <vince.post(a)movrc.org> wrote: >>>> >>> >>> Alan, >>> >>> >>> >>> Truer words have not been spoken. >>> >>> >>> >>> _________________________________________________ >>> >>> >>> >>> Vincent Post, III >>> >>> Transportation/GIS Specialist >>> >>> Mid-Ohio Valley Regional Council >>> >>> Wood-Washington-Wirt Interstate Planning Commission >>> >>> 709 Market Street >>> >>> P.O. Box 247 >>> >>> Parkersburg, WV 26101 >>> >>> E-mail: vince.post(a)movrc.org >>> >>> Phone: 304.422.4993 ext. 106 >>> >>> Fax: 304.422.4998 >>> >>> >>> >>> From: Alan Pisarski [mailto:alanpisarski(a)alanpisarski.com] >>> Sent: Thursday, January 23, 2020 10:48 AM >>> To: ctpp-news(a)mailman.chrispy.net; ctpp-news(a)chrispy.net >>> Subject: [CTPP] Re: Troubles with data.census.gov >>> >>> >>> >>> Hard to believe they could have produced something worse than FactFinder. I could never imagine missing it. Alan E Pisarski >>> >>> >>> >>> >>> >>> Alan E. Pisarski Consultancy >>> >>> Landline 703 941-4257 >>> >>> Cell 703 650-8925 >>> >>> >>> >>> >>> >>> >>> >>> From: Catala, Martin <catala(a)cutr.usf.edu> >>> Sent: Thursday, January 23, 2020 8:29 AM >>> To: ctpp-news(a)mailman.chrispy.net; ctpp-news(a)chrispy.net >>> Subject: [CTPP] Re: Troubles with data.census.gov >>> >>> >>> >>> +1 >>> >>> >>> >>> Get Outlook for iOS >>> >>> From: Bob Schwartz <schwartz(a)spcregion.org> >>> Sent: Thursday, January 23, 2020 7:12:23 AM >>> To: ctpp-news(a)mailman.chrispy.net <ctpp-news(a)mailman.chrispy.net>; ctpp-news(a)chrispy.net <ctpp-news(a)chrispy.net> >>> Subject: [CTPP] Re: Troubles with data.census.gov >>> >>> >>> >>> This email originated from outside of USF. Do not click links or open attachments unless you recognize the sender or understand the content is safe. >>> >>> >>> >>> I agree with Jonathan. I HATE data.census.gov. Bring back American FactFinder. >>> >>> >>> >>> From: jonathan lupton [mailto:jlupton(a)Metroplan.org] >>> Sent: Wednesday, January 22, 2020 4:22 PM >>> To: ctpp-news(a)chrispy.net >>> Subject: [CTPP] Troubles with data.census.gov >>> >>> >>> >>> Am I the only user having chronic problems with data.census.gov? >>> >>> >>> >>> After nearly a year of constant attempts at use and self-training, my personal experience is that data.census.gov is capricious, inconsistent, and inadequate. The potential is (probably) there but to my view it’s not yet ready for prime time – yet it is the only way you can access the 2018 ACS. American Factfinder is going away in a matter of months, so soon the shaky and unstable data.census.gov system will be all that we have. >>> >>> >>> >>> Perhaps there’s some magic bullet I have yet to find. Or an alternative that provides the professional reliability the data community needs. API? >>> >>> >>> >>> Can anybody in the data community offer insights? >>> >>> >>> >>> Thanks! >>> >>> >>> >>> Jonathan Lupton AICP >>> >>> Senior Planner – Publications >>> >>> Metroplan >>> >>> Little Rock AR >>> >>> _______________________________________________ >>> ctpp-news mailing list -- ctpp-news(a)mailman.chrispy.net >>> To unsubscribe send an email to ctpp-news-leave(a)mailman.chrispy.net >> _______________________________________________ >> ctpp-news mailing list -- ctpp-news(a)mailman.chrispy.net >> To unsubscribe send an email to ctpp-news-leave(a)mailman.chrispy.net > _______________________________________________ > ctpp-news mailing list -- ctpp-news(a)mailman.chrispy.net > To unsubscribe send an email to ctpp-news-leave(a)mailman.chrispy.net

4 years, 3 months

[CTPP] Troubles with data.census.gov

by jonathan lupton

Am I the only user having chronic problems with data.census.gov? After nearly a year of constant attempts at use and self-training, my personal experience is that data.census.gov is capricious, inconsistent, and inadequate. The potential is (probably) there but to my view it's not yet ready for prime time - yet it is the only way you can access the 2018 ACS. American Factfinder is going away in a matter of months, so soon the shaky and unstable data.census.gov system will be all that we have. Perhaps there's some magic bullet I have yet to find. Or an alternative that provides the professional reliability the data community needs. API? Can anybody in the data community offer insights? Thanks! Jonathan Lupton AICP Senior Planner - Publications Metroplan Little Rock AR

4 years, 3 months

[CTPP] ctpp-news mailing list migrated to ctpp-news@mailman.chrispy.net

by Chris Parrinello

All, The ctpp-news(a)chrispy.net mailing list has been migrated to a new email address: ctpp-news(a)mailman.chrispy.net. The archives for this mailing list have also been migrated to a new URL: https://mailman.chrispy.net/hyperkitty/list/ctpp-news(a)mailman.chrispy.net/ Please let me know you have any questions or run into any problems with the new mailing list. Thanks, Chris Parrinello

4 years, 3 months

[CTPP] PSAP Validation - Downloading Shapefiles

by Kathleen Yu

Hi Everyone, The Census Bureau has recommended reviewing the new Census 2020 geographies using TigerWeb or PDFs. If you want to look at the shapefiles in your own GIS software, you can download them from here - they are marked as 19v2. https://www2.census.gov/geo/pvs/ Regards, Kathy ___________________________________ Kathy Yu Principal Transportation System Modeler, Model and Data Development North Central Texas Council of Governments Phone: (817) 608-2343 Email: kyu(a)nctcog.org<mailto:kyu(a)nctcog.org>

4 years, 3 months

[CTPP] 2020 Participant Statistical Areas Program... continued

by Graham

Hi friends— Some of you have been involved in Census Geog activities. Some of you have not. FYI, this week Census Geog has blasted out announcements of the verification & sign-off phase of PSAP (for Tracts, Block Groups, CDPs, etc. etc.). Many of you will see an email like the one below (scroll down). This went to a long list of governments and stakeholders. This email says: PSAP Verification phase is now begun. Wraps up in April. Contact your “primary participant responsible” if you have issues. Kind of a bewildering email = sure to generate some questions. Things to know: 1. Census Geog’s objective now is simply verification & sign-off, confirming the Tract and BG shapefiles submitted last year. This phase is not an opportunity to bring up new requests. Sorry. 2. You can find out who is your “primary participant responsible” by visiting here: https://www.census.gov/programs-surveys/decennial-census/about/psap.html#pa… 3. New this week, there is a new series of YouTube videos about PSAP Verification and navigating the GUPS/PSAP website. Find the videos here. https://www.youtube.com/watch?v=Tx_K2VFVRho That’s what I know. Hope it helps. If you have questions about any of that don’t call me. Instead call on Census Geog Dept: geo.psap(a)census.gov<mailto:geo.psap(a)census.gov> or 1-844-788-4921 Happy Tracting! --Todd Graham Metropolitan Council of the Twin Cities From: U.S. Census Bureau <GEO.PSAP(a)census.gov> Sent: Wednesday, January 15, 2020 11:05 AM Subject: 2020 Census Participant Statistical Areas Program – Verification Phase Announcement 01/15/2020 FROM THE ASSOCIATE DIRECTOR FOR DECENNIAL CENSUS PROGRAMS Dear PSAP Participant: Your government/organization expressed interest in providing input to the statistical geographies reviewed and updated as part of the U.S. Census Bureau’s 2020 Census Participant Statistical Areas Program (PSAP). The PSAP verification phase materials were provided to the primary PSAP participant in January 2020 for review to determine if corrections are needed. Corrections must be completed within 90 calendar days from receipt of the verification phase announcement. To provide input, please contact the primary PSAP participant responsible for the review and corrections of the statistical geographies for your area. Locate the information regarding the PSAP verification phase and/or the primary PSAP participant on the PSAP website at https://www.census.gov/programs-surveys/decennial-census/about/psap.html<https://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.censu…> or contact the Census Bureau PSAP team by email at geo.psap(a)census.gov<mailto:geo.psap(a)census.gov> or by phone at 1-844-788-4921 for that information. Thank you for your interest in the 2020 Census PSAP.

4 years, 3 months

[CTPP] TRB Workshop 1049 - NCHRP 08-123: Census Transportation Data Field Guide for Transportation Applications

by Krishnan Viswanathan

Apologies for cross-posting. The goal of National Cooperative Highway Research Program (NCHRP) Project 08-123 is to build a census data guide for transportation applications. In this age of big data, census data are critical to provide context and ensure decisions are made on a foundation of sound representative data that includes at-risk subpopulations. The diversity of stakeholders at the TRB Annual Meeting who can provide insights on integrating census data into their analytical toolkits is an opportunity to make this NCHRP research product more robust and useful to a wide audience. Agenda Sunday 1:30 PM- 4:30 PM Convention Center, 154 Presiding Officer Penelope Weinberger, AASHTO Participants and Presentations · Introduction and Workshop Objectives · Census Data Inventory – Krishnan Viswanathan, Cambridge Systematics, Inc. · Uses of Census Data – Ed Christopher · Field Guide Framework – Kimon Proussaloglou, Ph.D., Cambridge Systematics, Inc. & Kevin Tierney, Birds Hill Research · Break out groups · Report back and Summary – Ed Christopher

4 years, 3 months

[CTPP] TRB Census Data Subcommittee Agenda ABJ30(1)

by Reschovsky

Happy New Year! Attached is the agenda for the Census Data Subcommittee Meeting ABJ30(1) at the TRB Annual Meeting next week The in-person meeting is on Monday, January 13 from 1:30 to 3:15 in the Marriott Marquis in Liberty K on M4. We also encourage you to attend our poster session "Census Transportation Planning Products 2012-2016: New Data Analyses and Uses" in the main Convention Center, Hall A, also on Monday, January 13 from 10:15-12. We hope to see many of you there next week! Clara Reschovsky USDOT/BTS

4 years, 3 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 January 2020