The US Census Bureau thread

[SIGSEGV]

Total US population in census tracts above 10k density: 39,049,224
Total US population in census tracts above 20k density: 17,317,678
Total US population in census tracts above 30k density: 10,656,582
Total US population in census tracts above 40k density: 7,709,739
Total US population in census tracts above 50k density: 6,128,182
Total US population in census tracts above 60k density: 4,861,268
Total US population in census tracts above 70k density: 3,829,651
Total US population in census tracts above 80k density: 2,959,145
Total US population in census tracts above 90k density: 2,346,202
Total US population in census tracts above 100k density: 1,738,146
Total US population in census tracts above 110k density: 1,326,501
Total US population in census tracts above 120k density: 889,149
Total US population in census tracts above 130k density: 672,056
Total US population in census tracts above 140k density: 473,606
Total US population in census tracts above 150k density: 358,938
Total US population in census tracts above 160k density: 261,368
Total US population in census tracts above 170k density: 191,494
Total US population in census tracts above 180k density: 140,687
Total US population in census tracts above 190k density: 67,924
Total US population in census tracts above 200k density: 62,356

[mhays]

Awesome! I wonder what the same thing is minus the New York metro.

[proghousehead]

How about a calc of % of metro pop living in tracts over 20k/sq mile?

Also can we find city level data? For example -
Jersey City.

[C.]

Originally Posted by SIGSEGV

Total US population in census tracts above 10k density: 39,049,224
Total US population in census tracts above 20k density: 17,317,678
Total US population in census tracts above 30k density: 10,656,582
Total US population in census tracts above 40k density: 7,709,739
Total US population in census tracts above 50k density: 6,128,182
Total US population in census tracts above 60k density: 4,861,268
Total US population in census tracts above 70k density: 3,829,651
Total US population in census tracts above 80k density: 2,959,145
Total US population in census tracts above 90k density: 2,346,202
Total US population in census tracts above 100k density: 1,738,146
Total US population in census tracts above 110k density: 1,326,501
Total US population in census tracts above 120k density: 889,149
Total US population in census tracts above 130k density: 672,056
Total US population in census tracts above 140k density: 473,606
Total US population in census tracts above 150k density: 358,938
Total US population in census tracts above 160k density: 261,368
Total US population in census tracts above 170k density: 191,494
Total US population in census tracts above 180k density: 140,687
Total US population in census tracts above 190k density: 67,924
Total US population in census tracts above 200k density: 62,356

Whoa. Nice work!

[Crawford]

Allentown, if anything, would be in the NY MSA/CSA. It was in the NY CSA until a few years ago, and the transit/commuter patterns are oriented towards NY.

I'm really surprised Baltimore's numbers are so low. I would think its giant swath of medium density rowhouse neighborhoods would fare well at a 20k cutoff.

And the MI numbers remind me that we can't put too much into the relative counts, given that census tracts are of wildly varying size. East Lansing, with the largest concentration in MI, is mostly an unwalkable postwar suburban mess, but there are apparently some Michigan State dorms that put it on top. In contrast, Ann Arbor generally has good urbanity, and is much denser and more walkable, with a clearly more urban campus, but a considerably lower Census tract count.

[iheartthed]

Originally Posted by SIGSEGV

Total US population in census tracts above 10k density: 39,049,224
Total US population in census tracts above 20k density: 17,317,678
Total US population in census tracts above 30k density: 10,656,582
Total US population in census tracts above 40k density: 7,709,739
Total US population in census tracts above 50k density: 6,128,182
Total US population in census tracts above 60k density: 4,861,268
Total US population in census tracts above 70k density: 3,829,651
Total US population in census tracts above 80k density: 2,959,145
Total US population in census tracts above 90k density: 2,346,202
Total US population in census tracts above 100k density: 1,738,146
Total US population in census tracts above 110k density: 1,326,501
Total US population in census tracts above 120k density: 889,149
Total US population in census tracts above 130k density: 672,056
Total US population in census tracts above 140k density: 473,606
Total US population in census tracts above 150k density: 358,938
Total US population in census tracts above 160k density: 261,368
Total US population in census tracts above 170k density: 191,494
Total US population in census tracts above 180k density: 140,687
Total US population in census tracts above 190k density: 67,924
Total US population in census tracts above 200k density: 62,356

Almost 12% of the U.S. lives in +10k density. That's a little higher than I would've guessed.

[Crawford]

Originally Posted by ChiSoxRox

Adding DC/Baltimore. This might be complete for metros over 20,000 people living over 20k ppsm.

I could see New Haven and Bridgeport MSAs (NY CSA) possibly making the cut.

Also some random big university towns, probably. If Michigan State, with a sprawly postwar campus, fared well, I could see lots of big universities sneaking in.

Oh, and then the Poughkeepsie MSA (NY CSA). But not bc of traditional urbanity, bc of the very dense Orthodox Jewish enclaves, like Kiryas Joel.

[ChiSoxRox]

Originally Posted by Crawford

Allentown, if anything, would be in the NY MSA/CSA. It was in the NY CSA until a few years ago, and the transit/commuter patterns are oriented towards NY.

I'm really surprised Baltimore's numbers are so low. I would think its giant swath of medium density rowhouse neighborhoods would fare well at a 20k cutoff.

And the MI numbers remind me that we can't put too much into the relative counts, given that census tracts are of wildly varying size. East Lansing, with the largest concentration in MI, is mostly an unwalkable postwar suburban mess, but there are apparently some Michigan State dorms that put it on top. In contrast, Ann Arbor generally has good urbanity, and is much denser and more walkable, with a clearly more urban campus, but a considerably lower Census tract count.

For Baltimore, I was also surprised. It must be that the dense core of the city has emptied out sufficiently without extensive revived neighborhoods to bring the density back up. It is the only major Northeastern city that is still falling. Next biggest in BosWash that declined seems to be Hartford, CT.

As for the census tract granularity, that is an important point to keep in mind, and the key reason I truncated my list at 20,000 people.

Originally Posted by Crawford

I could see New Haven and Bridgeport MSAs (NY CSA) possibly making the cut.

Also some random big university towns, probably. If Michigan State, with a sprawly postwar campus, fared well, I could see lots of big universities sneaking in.

Oh, and then the Poughkeepsie MSA (NY CSA). But not bc of traditional urbanity, bc of the very dense Orthodox Jewish enclaves.

Bridgeport is on the list, while New Haven only has 8,733 qualifying.

Poughkeepsie is 14,947, all in Orange County across the Hudson. Rockland County being in the NY MSA makes for an awkward split.

[iheartthed]

Originally Posted by ChiSoxRox

Adding DC/Baltimore. This might be complete for metros over 20,000 people living over 20k ppsm.

New York: 9,151,543
Los Angeles: 1,919,006
Chicago: 1,238,801
San Francisco: 899,765
Philadelphia: 841,729
Boston: 727,666
Washington: 501,510
Miami: 396,021
Honolulu: 182,167
Seattle: 160,101
San Diego: 103,421
Houston: 88,080
Baltimore: 67,095
San Jose: 64,724
Dallas: 54,893
Minneapolis: 52,998
Denver: 49,423
Milwaukee: 47,988
Bridgeport: 47,791
Providence: 39,442
Portland: 38,057
Madison: 35,514
Columbus: 31,592
Allentown: 29,319
Atlanta: 26,589
Worcester: 26,374
Las Vegas: 26,114
Austin: 23,224
Champaign: 22,271
Phoenix: 20,351

That seems very high for Washington.

[ChiSoxRox]

Originally Posted by iheartthed

That seems very high for Washington.

Washington MSA
Montgomery, MD 48,774
Prince Georges, MD 24,708
DC 288,907
Arlington, VA 83,467
Alexandria, VA 37,303
Fairfax County 18,351

All other counties and equivalents are 0. (Unless I missed a Virginia city.)

[streetscaper]

Superb work so far, guys!

what does the 20K/sqmi threshold look like on the ground?

[craigs]

Another count of people in tracts of 20,000+ ppsm:

Salinas, CA MSA: 21,893

That's Monterey County, and more people in such tracts than the Phoenix MSA.

[ChiSoxRox]

Originally Posted by craigs

Another count of people in tracts of 20,000+ ppsm:

Salinas, CA MSA: 21,893

That's Monterey County, and more people in such tracts than the Phoenix MSA.

Thanks! The current list:

New York: 9,151,543
Los Angeles: 1,919,006
Chicago: 1,238,801
San Francisco: 899,765
Philadelphia: 841,729
Boston: 727,666
Washington: 501,510
Miami: 396,021
Honolulu: 182,167
Seattle: 160,101
San Diego: 103,421
Houston: 88,080
Baltimore: 67,095
San Jose: 64,724
Dallas: 54,893
Minneapolis: 52,998
Denver: 49,423
Milwaukee: 47,988
Bridgeport: 47,791
Providence: 39,442
Portland: 38,057
Madison: 35,514
Columbus: 31,592
Allentown: 29,319
Atlanta: 26,589
Worcester: 26,374
Las Vegas: 26,114
Austin: 23,224
Champaign: 22,271
Salinas: 21,893
Phoenix: 20,351

[chris08876]

Originally Posted by iheartthed

Almost 12% of the U.S. lives in +10k density. That's a little higher than I would've guessed.

Its amazing how sparse the U.S. is once you leave certain metros. And I mean sparse and empty.

[subterranean]

I guess this is a game Michigan can’t play. Ingham County (Lansing/East Lansing) surprisingly has the most above 20k ppsm, home of MSU. It’s a suburban campus and bested Washtenaw (U-M Ann Arbor - an urban campus).

[SIGSEGV]

Originally Posted by subterranean

I guess this is a game Michigan can’t play. Ingham County (Lansing/East Lansing) surprisingly has the most above 20k ppsm, home of MSU. It’s a suburban campus and bested Washtenaw (U-M Ann Arbor - an urban campus).

Midtown and Downtown Detroit have some tracts between 10 and 20k. A bit more growth there and Detroit could reach 20k above 20k by the next census.

And Ann Arbor has a few tracts just under 20k.

[ChiSoxRox]

Originally Posted by streetscaper

Superb work so far, guys!

what does the 20K/sqmi threshold look like on the ground?

Uptown, Chicago away from the lake is a good example, with tracts on either side of 20k. This is a typical street, with multistory apartment buildings but still separation from the street and each other.

Compare to 10k, like intact parts of the bungalow belt with their single-family detached-but-still-close homes.

Going the other way, 30k is going to be a Lakeview street where you're starting to directly abut the sidewalk and each adjacent building.

[wwmiv]

I am currently working on a mac and do not have access to a windows operating computer, which is required for use of the redistricting files (Microsoft Access). Is anyone on a windows operating system willing to download the redistricting data and convert the file into a .csv or set of .csvs (state by state) and email them to me?

https://www.census.gov/programs-surv...ary-files.html

[pip]

Originally Posted by ChiSoxRox

I agree on Boston!

Washington DC will be fun.

Meanwhile, Honolulu is an overlooked density node.

New York: 9,151,543
Los Angeles: 1,919,006
Chicago: 1,238,801
San Francisco: 899,765
Philadelphia - 841,729
Boston: 727,666
Miami: 396,021
Honolulu: 182,167
Seattle: 160,101
San Diego: 103,421
Houston: 88,080
San Jose: 64,724
Minneapolis: 52,998
Denver: 49,423
Milwaukee: 47,988
Portland: 38,057
Madison: 35,514
Columbus: 31,592

Boston: 727,666

I'm not sure I follow this census track density. Boston where I am at for the summer is for 2020 almost 15,000 people a square mile at just under 700,000 people. Throw in Sommerville at around 80,000 people with just under 20,000 people a square mile and Cambridge with roughly the same numbers. I'm not seeing how you get 727,666 people at over 20,000 people a square mile.

[BnaBreaker]

Nashville above 20,000 ppsm: 0

We'll get there one day!