Quote:
Originally Posted by wwmiv
Next up from ChiRoxSox: national weighted population density.
Jk jk
|
*screams*
The New York MSA is going to be nine pulls or so from the Census tool due to the 1000 tract bottleneck, summing up the product of density and population for each pull, then combining those at the end before finally dividing by the MSA population to get the weighted population density. (I am being careful not to divide by population until the very end, so as not to split the denominator and wreck the math.)
I'm doing all this in a Google Sheet, so quick to calculate but tedious to pull the data. I also have a cell summing the population for each jurisdiction as a check to ensure I pulled all of the right tracts
My New York plan is:
Each of the four dense boroughs is its own pull, being >500 tracts each. Then, I'll pull Staten Island so I can have the WPD for each borough and for NYC proper readily at hand. Then, Long Island is a pull, the Hudson Valley is a pull, and the New Jersey side is at least two, probably three pulls: Essex + Hudson + Bergen + Passaic if it fits for the Jersey core, then hopefully the rest of the Jersey side plus Pike, PA is under 1000 tracts.
I do want to calculate state numbers, but California is probably in the ballpark of 9,000 tracts. I'll have to do the same strategy as for LA County and its 2,495 tracts: add density filters to get bands of under 1000 tracts.
Threaded Mode