29 Jan
2020
29 Jan
'20
12:58 p.m.
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.
29 Jan
29 Jan
1:05 p.m.
New subject: 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>
Sent: Wednesday, January 29, 2020 12:58 PM
To: 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.
2:54 p.m.
New subject: Question Regarding Mapping Low Income Population by Census Tract
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@actransit.org<mailto:sgoodman@actransit.org> |
www.actransit.org/CivilRights<http://www.actransit.org/CivilRights>
From: Jackie Eastwood <jeastwood(a)lacrossecounty.org>
Sent: Wednesday, January 29, 2020 11:05 AM
To: 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@aashto.org<mailto:pweinberger@aashto.org>>
Sent: Wednesday, January 29, 2020 12:58 PM
To: ctpp-news@chrispy.net<mailto:ctpp-news@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.
3:33 p.m.
New subject: 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, and 2017 is on American FactFinder.
Patty Becker
On Wed, Jan 29, 2020 at 4:04 PM Sally Goodman <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 | www.actransit.org/CivilRights
*From:* Jackie Eastwood <jeastwood(a)lacrossecounty.org>
*Sent:* Wednesday, January 29, 2020 11:05 AM
*To:* 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>
*Sent:* Wednesday, January 29, 2020 12:58 PM
*To:* 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
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:20 p.m.
New subject: Question Regarding Mapping Low Income Population by Census Tract
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@actransit.org<mailto:Sgoodman@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@actransit.org<mailto:sgoodman@actransit.org> |
www.actransit.org/CivilRights<http://www.actransit.org/CivilRights>
From: Jackie Eastwood
<jeastwood@lacrossecounty.org<mailto:jeastwood@lacrossecounty.org>>
Sent: Wednesday, January 29, 2020 11:05 AM
To: ctpp-news@mailman.chrispy.net<mailto:ctpp-news@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@aashto.org<mailto:pweinberger@aashto.org>>
Sent: Wednesday, January 29, 2020 12:58 PM
To: ctpp-news@chrispy.net<mailto:ctpp-news@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@mailman.chrispy.net<mailto:ctpp-news@mailman.chrispy.net>
To unsubscribe send an email to
ctpp-news-leave@mailman.chrispy.net<mailto:ctpp-news-leave@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@umich.edu<mailto:pbecker@umich.edu>
30 Jan
30 Jan
10:44 a.m.
New subject: Question Regarding Mapping Low Income Population by Census Tract
Hi Jonathan… The way I copy an entire table from data.census.gov is to click in first cell
in the header row, hold the shift key, scroll down to the bottom most right cell, right
click and choose Export Table and Export to Excel. It needs some clean up, but all the
data are captured… Darlanne
Darlanne Hoctor Mulmat
Regional Census Data Center Manager
SANDAG
(619) 699-7326
401 B Street, Suite 800, San Diego, CA 92101
[cid:image001.png@01D5D749.73DE4A70]<http://www.sandag.org/>
Facebook<https://www.facebook.com/SANDAGregion/> |
Twitter<https://twitter.com/sandag> |
YouTube<https://www.youtube.com/user/SANDAGREGION> |
Instagram<https://www.instagram.com/sandagregion/>
SANDAG offices are open Tuesday-Friday and every other
Monday<https://www.sandag.org/organization/about/pubs/SANDAG-office-clos…
from 8 a.m.-5 p.m.
From: jonathan lupton <jlupton(a)Metroplan.org>
Sent: Wednesday, January 29, 2020 2:21 PM
To: ctpp-news(a)mailman.chrispy.net
Subject: [CTPP] Re: Question Regarding Mapping Low Income Population by Census Tract
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@umich.edu<mailto:pbecker@umich.edu>>
Sent: Wednesday, January 29, 2020 3:34 PM
To: ctpp-news@mailman.chrispy.net<mailto:ctpp-news@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@actransit.org<mailto:Sgoodman@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@actransit.org<mailto:sgoodman@actransit.org> |
www.actransit.org/CivilRights<http://www.actransit.org/CivilRights>
From: Jackie Eastwood
<jeastwood@lacrossecounty.org<mailto:jeastwood@lacrossecounty.org>>
Sent: Wednesday, January 29, 2020 11:05 AM
To: ctpp-news@mailman.chrispy.net<mailto:ctpp-news@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@aashto.org<mailto:pweinberger@aashto.org>>
Sent: Wednesday, January 29, 2020 12:58 PM
To: ctpp-news@chrispy.net<mailto:ctpp-news@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@mailman.chrispy.net<mailto:ctpp-news@mailman.chrispy.net>
To unsubscribe send an email to
ctpp-news-leave@mailman.chrispy.net<mailto:ctpp-news-leave@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@umich.edu<mailto:pbecker@umich.edu>
29 Jan
29 Jan
1:24 p.m.
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
1:41 p.m.
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@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
30 Jan
30 Jan
7:31 a.m.
Rather than use the ACS itself as a data source I would use the CHAS data from
huduser.gov:
https://www.huduser.gov/portal/datasets/cp.html
This is ACS data recompiled for HUD that provides figures for low and moderate income
households down to the tract level. (The on-line query tool only goes down to places.)
The data here on households might be more recent than the latest HUD figures for low and
moderate income population. It might take a bit of digging to get to the table that best
serves your needs.
Cliff Cook
Clifford Cook
Senior Planning Information Manager
Cambridge Community Development Department
344 Broadway, Cambridge, MA. 02139
[cid:image001.png@01D5D747.B858B9D0]
<https://www.facebook.com/CDDat344> [cid:image002.jpg@01D5D747.B858B9D0]
<https://twitter.com/cddat344> [cid:image003.jpg@01D5D747.B858B9D0]
<http://instagram.com/cddat344>
www.cambridgema.gov/CDD<http://www.cambridgema.gov/CDD.aspx>
ccook@cambridgema.gov<mailto:ccook@cambridgema.gov>
M: 8:30-8:00 T-Th: 8:30-5:00 F: 8:30-Noon
617/349-4656
617/349-4669 FAX
617/349-4621 TTY
From: Chuck Imbrogno <imbrogno(a)spcregion.org>
Sent: Wednesday, January 29, 2020 2:41 PM
To: ctpp-news(a)mailman.chrispy.net
Subject: [CTPP] Re: FW: Question Regarding Mapping Low Income Population by Census Tract
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@umich.edu]
Sent: Wednesday, January 29, 2020 2:25 PM
To: ctpp-news@mailman.chrispy.net<mailto:ctpp-news@mailman.chrispy.net>
Cc: ctpp-news@chrispy.net<mailto:ctpp-news@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<https://gcc01.safelinks.protection.outlook.com/?url=http…
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<https://gcc01.safelinks.protection.outlook.com/?ur…)mp;reserved=0>),
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@aashto.org<mailto:pweinberger@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@mailman.chrispy.net<mailto:ctpp-news@mailman.chrispy.net>
To unsubscribe send an email to
ctpp-news-leave@mailman.chrispy.net<mailto:ctpp-news-leave@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@umich.edu<mailto:pbecker@umich.edu>
29 Jan
29 Jan
1:28 p.m.
It depends on how you define low income, but I would assume Federal Poverty level would be
the best option here. The ACS 5-year estimates have data for poverty by tract – Table
B17001 and Table C17002 (type the table number into the search at Http://data.census.gov),
Table C17002 will let you get various levels above and below the federal poverty level.
You can also get household income ranges from table B19001.
2018 5-year is the most recent ACS data there.
DrCOG could be another good resource for help with acquiring Census data
https://data.drcog.org/
==============
Jami Dennis, GISP
From: Weinberger Penelope <pweinberger(a)aashto.org>
Sent: Wednesday, January 29, 2020 10:58 AM
To: 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.
1:33 p.m.
New subject: Question Regarding Mapping Low Income Population by Census Tract
Low and Moderate income is something defined by HUD for the CDBG program. Moderate income
is 50 to 80% of the area’s median income and low income is 50% and below. The HUD data is
generally at the Block Group level. You could summarize the data by Tract or simply ID
tracts that have a median income at or below 50% or the area’s median income.
[logo]<https://www.starkcountyohio.gov/regional-planning>
201 3rd. St. NE, STE. 201, Canton OH 44702-1211
Jeff Dotson
SCATS Technical Director
t:330-451-7402
f:330-451-7990
e:jgdotson@starkcountyohio.gov
www.rpc.starkcountyohio.gov<http://www.rpc.starkcountyohio.gov>
[Facebook
icon]<https://www.facebook.com/Stark-County-Regional-Planning-Commission…
[LinkedIn icon]
<https://www.linkedin.com/company/stark-county-regional-planning-commission/>
From: Weinberger Penelope [mailto:pweinberger@aashto.org]
Sent: Wednesday, January 29, 2020 1:58 PM
To: 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.
Stark County Email Disclaimer
Privileged/Confidential information may be contained in this message and may be subject to
legal privilege. Access to this e-mail by anyone other than the intended is unauthorized.
If you are not the intended recipient (or responsible for delivery of the message to such
person), you may not use, copy, distribute or deliver to anyone this message (or any part
of its contents ) or take any action in reliance on it. In such case, you should destroy
this message, and notify us immediately. If you have received this email in error, please
notify us immediately by e-mail or telephone and delete the e-mail from any computer. If
you or your employer does not consent to internet e-mail messages of this kind, please
notify us immediately. All reasonable precautions have been taken to ensure no viruses are
present in this e-mail. As Stark County cannot accept responsibility for any loss or
damage arising from the use of this e-mail or attachments we recommend that you subject
these to your virus checking procedures prior to use. The views, opinions, conclusions and
other information expressed in this electronic mail are not given or endorsed by Stark
County unless otherwise indicated by an authorized representative independent of this
message.
Stark County Website<http://www.starkcountyohio.gov/>
3:39 p.m.
New subject: Question Regarding Mapping Low Income Population by Census Tract
Penelope- Transit agencies have to perform what is called Title 6 analysis to show that
they do not discriminate by race or income. We usually rely on HUD data which defines
low income based on a combination of income and the size of the household. So the
problem is that you have to look at identifying household size by income and do that for
up to 7 categories. That is how low income is defined. The other issue is that these are
changed based on inflation so that the income ranges change every year I think, So you
have to sort how many households are below a certain income level by size of household and
add them together. The income ranges typically do not match census income ranges also.
For simplicity, we generally pick an income level that covers the majority of household
sizes, typically 4 or 5 persons. For recent examples, we used a Household Income of
$25,000 or less as a definition of low income. Granted somewhat simple, but it can narrow
the process and comports with Census income ranges.
Tom Marchwinski
Director, Market Research and Fare Policy
Metro-North Railroad
From: Weinberger Penelope [mailto:pweinberger@aashto.org]
Sent: Wednesday, January 29, 2020 1:58 PM
To: 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.
4:21 p.m.
New subject: Question Regarding Mapping Low Income Population by Census Tract
I’m a fan of poverty measures because they take into consideration family/household size.
It can be used for Title VI analysis too.
Get Outlook for iOS<https://aka.ms/o0ukef>
________________________________
From: Marchwinski, Thomas <Marchwinski(a)mnr.org>
Sent: Wednesday, January 29, 2020 4:39:39 PM
To: ctpp-news(a)mailman.chrispy.net <ctpp-news(a)mailman.chrispy.net>
Subject: [CTPP] Re: Question Regarding Mapping Low Income Population by Census Tract
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.
Penelope- Transit agencies have to perform what is called Title 6 analysis to show that
they do not discriminate by race or income. We usually rely on HUD data which defines
low income based on a combination of income and the size of the household. So the
problem is that you have to look at identifying household size by income and do that for
up to 7 categories. That is how low income is defined. The other issue is that these are
changed based on inflation so that the income ranges change every year I think, So you
have to sort how many households are below a certain income level by size of household and
add them together. The income ranges typically do not match census income ranges also.
For simplicity, we generally pick an income level that covers the majority of household
sizes, typically 4 or 5 persons. For recent examples, we used a Household Income of
$25,000 or less as a definition of low income. Granted somewhat simple, but it can narrow
the process and comports with Census income ranges.
Tom Marchwinski
Director, Market Research and Fare Policy
Metro-North Railroad
From: Weinberger Penelope [mailto:pweinberger@aashto.org]
Sent: Wednesday, January 29, 2020 1:58 PM
To: 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.
30 Jan
30 Jan
10:50 a.m.
New subject: Question Regarding Mapping Low Income Population by Census Tract
Several people have already said some of this – but I spent a few minutes synthesizing it
all into a summary. So here it is:
Low-income, moderate-income, etc., are pegged to a multiple of Area Median Income for any
housing or HUD program.
Low-income, moderate-income, etc., could instead be pegged to a multiple of the poverty
line for HHS, US DOT, and most other programs.
If one is using the multiples of Area Median Income:
* Importantly, every metro area has its own distinct level of Area Median Income,
determined by analysts at HUD.
* Low-income (generally) means households with a household income <= 50% of AMI.
Moderate-income (generally) means income 51-80% of AMI.
* * I say “generally” because there are some minor and nuanced exceptions when HUD
sets the metro-specific affordability cut-offs.
* The low- and moderate-income bands have a sliding scale varying with household
size.
* Data: HUD, working with Census, publishes “CHAS” estimates of households (and
housing units) in each income band (or affordability band).
www.huduser.gov/portal/datasets/cp.html<http://www.huduser.gov/portal/da…
Geographic units: counties, county subdivisions (aka MCDs), places, and tracts.
* “CHAS” estimates do not include population counts. It would be possible to join
the CHAS household estimates with ACS average household sizes, then calculate “pop in
households” – but if population is the metric you prefer, it’s easier to instead use ACS
tables concerning income bands (C17002, B17024, B17026) – see below.
If one is using the multiples of the poverty line
* The poverty schedule is the same nationwide; does not vary by metro or state.
* In the Mpls-St Paul metro area*, low-income means people or families with a family
income <= 185% of the poverty line. Moderate-income means income 186% to 300% of the
poverty line.
* * Your metro area might set the thresholds differently. We have set the
thresholds as we have because, for the Mpls-St Paul metro 300% of poverty is roughly
equivalent to 80% of AMI (moderate-income); 185% of poverty is roughly 50% of AMI
(low-income); and 100% of poverty line (officially poor) is roughly 30% of AMI (extremely
low-income)
* The poverty line has a sliding scale varying with family size. So, in Census’s
American Community Survey, every family and every person case is classified to an income
band using the sliding scale.
* Data: ACS tables (C17002, B17024, B17026) present population in each income band.
Hope that helps.
[cid:image001.png@01D5D6BB.62687920]
Todd Graham
Principal Forecaster | Metropolitan Council | Regional Policy and Research
todd.graham(a)metc.state.mn.us
Phone 651.602.1322 | Fax 651.602.1674
390 North Robert Street | St. Paul, MN 55101 |
metrocouncil.org/data<http://www.metrocouncil.org/data>
[ConWUs][FaceBook_32x32]<http://www.facebook.com/MetropolitanCouncil>[…
[EmailSU]
<https://public.govdelivery.com/accounts/MNORGMETC/subscribers/new?preferences=true>
From: Weinberger Penelope <pweinberger(a)aashto.org>
Sent: Wednesday, January 29, 2020 12:58 PM
To: 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.
1790
days inactive
1791
days old
13 comments
13 participants
participants (13)
-
Catala, Martin -
Chuck Imbrogno -
Cook, Cliff -
Graham, Todd -
Hoctor Mulmat, Darlanne -
Jackie Eastwood -
jami＠geodetic.xyz -
Jeff G. Dotson -
jonathan lupton -
Marchwinski, Thomas -
Patricia Becker -
Sally Goodman -
Weinberger Penelope