15 Mar
2022
15 Mar
'22
8:13 p.m.
Ben:
Yes, I’m learning a lot about MCDs. I tried pulling Pennsylvania MCDs from TIDYCENSUS for
the decennial census, but TIDYCENSUS (and the Census API) doesn’t have “MCD” as a standard
geography. Instead, according to the Census Bureau documentation, MCDs in Pennsylvania are
“county subdivision”.
I adapted a tidycensus script to pull “county subdivision” (aka Minor Civil Divisions,
aka boroughs, townships and cities) for three sets of Pennsylvania PL 94-171 files: 2000,
2010, 2020. This script also has my best script used to calculate racial/ethnic diversity
(using the dplyr “mutate” function.)
It appears that townships and boroughs can straddle counties. I wonder what happens with
an MCD-to-MCD CTPP flow for PA?
Philadelphia is a huge county, with a 2020 population of 1,603,797. The best bet here is
to use PUMA-of-Residence to PUMA-of-Work for just Philadelphia County. It’s a rectangular
“trip table” with multiple rows (PUMAs) and just one column (Philadelphia County), but
should be the finest grained commuter flow data for Philadelphia that has primary
workplace allocation. (This is the case for the Bay Area, with 54 PUMAs of residence by 9
POWPUMAs — counties — of work!)
Here’s my script for Pennsylvania, 2000-2020, “The Best of PL 94171”, at MCD/County
Subdivision level.
https://gist.github.com/chuckpurvis/27a713f85c1f30aafdfef3451d074077
<https://gist.github.com/chuckpurvis/27a713f85c1f30aafdfef3451d074077>
Chuck
On Mar 15, 2022, at 1:58 PM, Benjamin Gruswitz
<bgruswitz(a)dvrpc.org> wrote:
Yes, Chuck, this is a data advantage for strong MCD regions--the workplace allocation is
complete at this subcounty level that covers all areas of each county (as opposed to
place, which doesn't have county-wide coverage). And our TAZs nest within our
municipal boundaries, so fitting their flows to the MCD total is a good way to go for
adjustments. The only issue in our region is that Philadelphia is both a county and MCD,
so we don't get a subcounty control for our TAZ workplace fitting within our high
pop/high employment urban center the way we do for our smallest boroughs and townships (we
have one borough with a population of 10 and employment of 25).
Thanks for always pointing us to good resources and encouraging our experienced and
burgeoning R users to explore CTPP data with that toolset!
Ben
Working from Home | 301.655.3170
Ben Gruswitz, AICP | Manager, Socioeconomic & Land Use Analytics
(Pronouns: he/him)
Delaware Valley Regional Planning Commission
190 N Independence Mall West, 8th Floor
Philadelphia, PA 19106-1520
<https://www.google.com/maps/place/Delaware+Valley+Regional+Planning+Commission/@39.9543225,-75.1508621,18.75z>
215.238.2882 <> | www.dvrpc.org <https://www.dvrpc.org/>
Subscribe <https://app.e2ma.net/app2/audience/signup/1808352/1403728/> | Facebook
<http://www.facebook.com/DVRPC> | Twitter <http://www.twitter.com/DVRPC> |
Instagram <http://www.instagram.com/DVRPC> | LinkedIn
<http://www.linkedin.com/company/delaware-valley-regional-planning-commission> |
YouTube <https://www.youtube.com/channel/UCEU8UI5_iGkVypHP93b5jLA>
<https://www.dvrpc.org/>