SkyscraperPage Forum

SkyscraperPage Forum (https://skyscraperpage.com/forum/index.php)
-   City Discussions (https://skyscraperpage.com/forum/forumdisplay.php?f=24)
-   -   Population density of cities by neighborhood (census tract) (https://skyscraperpage.com/forum/showthread.php?t=204523)

Cirrus Mar 21, 2013 5:31 AM

Population density of cities by neighborhood (census tract)
 
I made a series of maps. They show the population density (people per square mile) of census tracts in the central counties of the 20 largest US urbanized areas. The data is from the 2010 US Census. The maps are all to the same geographic scale, and the color scales representing density are also the same on each map (except if you look at the high-end number on each one you can see the peak density for that city).

Anyone can make maps just like these for anywhere in the US, but it is complicated. I had to get a friend who works at the census bureau to help me. Here's the process:
  1. Go to factfinder2.census.gov
  2. Click "advanced search"
  3. Search for topic/table name "GCT-PH1", but do not actually select any of the results.
  4. Once the results are listed on the screen, click the "geographies" button.
  5. Use drop-down menu to select "..... County - 050", then navigate to the county you want.
  6. After you've selected the county, click "close" in upper right corner of the geographies pop-up.
  7. Click the table titled "Population, Housing Units, Area, and Density: 2010 - County - Census Tract"
  8. A new page will load. Click the "Create a map" link.
  9. Find the table column for population, under the desnity per square mile header, and click on the 2nd number from top (do not click the top number).
  10. A pop-up will appear. Click "show map".
  11. When the map loads, click "colors and data classes"
  12. Change transparency to 0%
  13. Change number of classes to 4 (if it is not already).
  14. Change classing method to "user defined".
  15. Set the values to be:
    0 - 9999.9
    10000 - 19999.9
    20000 - 39999.9
    40000 - (whatever is the max)
    (If you city has a max below 40,000 you will need to adjust the scale, because the webpage will not accept a null result. Just tell us if you do.)
  16. Click "go".
  17. When the map loads, take a screencap.
  18. To go back and make another one for a different place, click "back to advanced search" and select a different geography. You will need to remove the county you don't want anymore from the "your selections" panel in the upper left.

Now here are the maps I made:

New York:
https://farm9.staticflickr.com/8529/...9332e3ea_b.jpg

LA:
https://farm9.staticflickr.com/8238/...a5a75b6d_b.jpg

Chicago:
https://farm9.staticflickr.com/8239/...1086b11f_b.jpg

Miami:
https://farm9.staticflickr.com/8392/...50422b97_b.jpg

Philadelphia:
https://farm9.staticflickr.com/8384/...7e4eda72_b.jpg

Dallas:
https://farm9.staticflickr.com/8524/...d3915e18_b.jpg

Houston:
https://farm9.staticflickr.com/8530/...d49f7960_b.jpg

Washington DC (I added Arlington and Alexandria to this one because I was interested):
https://farm9.staticflickr.com/8510/...4f8bf0ee_b.jpg

Atlanta:
https://farm9.staticflickr.com/8519/...bbe48a99_b.jpg

Boston:
https://farm9.staticflickr.com/8387/...bfd7d5c2_b.jpg

Detroit:
https://farm9.staticflickr.com/8237/...316f6cdb_b.jpg

Phoenix:
https://farm9.staticflickr.com/8103/...6eb36b0e_b.jpg

San Francisco:
https://farm9.staticflickr.com/8251/...344558fe_b.jpg

Seattle:
https://farm9.staticflickr.com/8372/...02edab7c_b.jpg

San Diego:
https://farm9.staticflickr.com/8229/...89cdfabf_b.jpg

Minneapolis:
https://farm9.staticflickr.com/8240/...c6206281_b.jpg

Tampa:
https://farm9.staticflickr.com/8098/...bd298fc8_b.jpg

Denver:
https://farm9.staticflickr.com/8388/...b3a85230_b.jpg

Baltimore:
https://farm9.staticflickr.com/8381/...433580a1_b.jpg

Saint Louis:
https://farm9.staticflickr.com/8509/...c7041380_b.jpg



This is a follow-up to a similar project I did several years ago using data from the 2000 census. You can see those maps here.

Cirrus Mar 21, 2013 5:39 AM

Now here are the 20 cities ranked according to peak density (that is to say, their single densest census tract):
  1. Chicago: 508,697 (This is likely a fluke caused by a prison or something, and will require looking into more deeply.)
  2. New York: 200,764
  3. San Francisco: 161,499
  4. Boston: 110,107
  5. Los Angeles: 94,490
  6. Baltimore: 86,889
  7. Miami: 77,214
  8. Washington: 66,782
  9. Philadelphia: 64,262
  10. Houston: 55,254
  11. Seattle: 51,128
  12. San Diego: 50,077
  13. Dallas: 44,099
  14. Minneapolis: 25,732
  15. Denver: 23,724
  16. Phoenix: 23,431
  17. Atlanta: 21,189
  18. Detroit: 18,404
  19. Tampa: 13,962
  20. Saint Louis: 13,329

Cirrus Mar 21, 2013 6:08 AM

Digging into the data a little further, here are maps showing only tracts above 100,000 ppsm. Oddly, I cannot find that Chicago tract, and there don't appear to be any others that are above the 100k threshold in that city. Very weird.

Chicago (none visible):
https://farm9.staticflickr.com/8239/...f7305ce7_b.jpg

New York:
https://farm9.staticflickr.com/8382/...f5535553_b.jpg

San Francisco:
https://farm9.staticflickr.com/8377/...9b200a78_b.jpg

Boston:
https://farm9.staticflickr.com/8532/...926cda9a_b.jpg

Cirrus Mar 21, 2013 6:31 AM

I found the Chicago mystery. The 500,000 ppsm tract is super-tiny. It's a couple of very tall residential skyscrapers, and nothing else. Here's an aerial.

https://farm9.staticflickr.com/8511/...02ac8721_b.jpg

ardecila Mar 21, 2013 8:19 AM

It is weird that Edgewater Beach highrises get such a tiny census tract for themselves.

dgreen Mar 21, 2013 11:42 AM

Link

Quote:

Census tracts are small, relatively permanent statistical subdivisions of a county. Census tracts are delineated for most metropolitan areas (MA's) and other densely populated counties by local census statistical areas committees following Census Bureau guidelines (more than 3,000 census tracts have been established in 221 counties outside MA's). Six States (California, Connecticut, Delaware, Hawaii, New Jersey, and Rhode Island) and the District of Columbia are covered entirely by census tracts. Census tracts usually have between 2,500 and 8,000 persons and, when first delineated, are designed to be homogeneous with respect to population characteristics, economic status, and living conditions. Census tracts do not cross county boundaries. The spatial size of census tracts varies widely depending on the density of settlement. Census tract boundaries are delineated with the intention of being maintained over a long time so that statistical comparisons can be made from census to census. However, physical changes in street patterns caused by highway construction, new development, etc., may require occasional revisions; census tracts occasionally are split due to large population growth, or combined as a result of substantial population decline.

dave8721 Mar 21, 2013 1:15 PM

Just wondering if the fact that Miami's census tracts span Biscayne Bay for some reason (rather than being clipped at the coast like they seem to be in every other city) throw off the density figures for what should be Miami's densest area - the west coast of South Beach. Clipping the census tracts at the shore line and using that new area to count density would be more accurate.

-edit: It looks like the area values are clipped to the coast.

Cirrus Mar 21, 2013 2:49 PM

There are some oddities with how Miami is being shown, but they skew the results in both directions.

Here's Miami zoomed in to the core, and with only tracts above 40,000 ppsm highlighted. Most of the densest tracts already hug the coast, and are quite a bit smaller than the typical neighborhood tract from New York or San Francisco, which skews them to read as "too" dense. On the other hand, there are some tracts that don't hug the coast, most notably Brickell Key and the coastal tracts north of 15th Street; but if they were reduced to hug the coast then they would be too small, so it's a tough problem.

Regardless, I think we can say with authority that Miami's high-rise coast is extremely dense, but that its neighborhoods are moderate.

http://farm9.staticflickr.com/8246/8...8227cef3_b.jpg

dave8721 Mar 21, 2013 3:21 PM

The tract directly to the west in Brickell would probably be over 40k if it were cut at the narrow pinch point. Also the tract west of that might too if it didn't include that little peice of commercial area west of I-95. Especially now. Maybe not so much in 2009/2010. Too bad they only do tract level population counts every 10 years. The donut hole tract just west of the Brickell Key tract would be included if they took the census now that the 1800+ unit Icon Brickell went up in that tract (occupancy levels were pretty low until 2011/2012).
The South Beach tract just below the 2 40+k tracts would be included as well if it didn't have that little jaunt to the east for some reason. Even with those less dense blocks included it just misses the cut at 39,900/per square mile.

jcchii Mar 21, 2013 3:45 PM

the only prison/jail that would qualify is Cook County Jail on california south of the courthouse at 26th St, busiest single-site courthouse in the country

It's one of the biggest pretrial detention facilities in the US with a population of 10,000+ most of the time

Cirrus Mar 21, 2013 5:37 PM

Quote:

Originally Posted by dave8721 (Post 6061028)
The tract directly to the west in Brickell would probably be over 40k if it were cut at the narrow pinch point. Also the tract west of that might too if it didn't include that little peice of commercial area west of I-95.

The same could be said of just about every tract in every city in the country. If you set out to define them solely to produce the highest possible density number, everyone would have much higher numbers all throughout.

dave8721 Mar 21, 2013 6:00 PM

Quote:

Originally Posted by Cirrus (Post 6061234)
The same could be said of just about every tract in every city in the country. If you set out to define them solely to produce the highest possible density number, everyone would have much higher numbers all throughout.

Of course. But what I was doing was actually simplifying things. Basically, all of Brickell: East of I-95, South of the Miami River, north of SW 15th RD (the diagonal street that runs from the bay to I-95) is a 40k+ per square mile neighborhood as well as all of the West Avenue corridor in South Beach.

shivtim Mar 21, 2013 6:32 PM

Great maps, thanks for putting them together.

I'd be interested to see these same maps with change in density for each census tract from 2000 to 2010. I wonder if that's possible from the data available on the census factfinder.

Cirrus Mar 21, 2013 6:55 PM

It wouldn't be possible using that process. You'd have to download the data and do it on a spreadsheet, then import the spreadsheet to GIS. But I do have maps from the 2000 census that you can compare.

shivtim Mar 21, 2013 7:11 PM

^Yep. I also poked around the data for Atlanta and the census tracts changed so much from 2000 to 2010 that a comparison isn't really possible. I imagine a lot of cities would have this same problem. Interestingly enough, the most dense tract in Atlanta in 2000 was over 40000/sqmi, and now it's down to around 20000/sqmi. It's due to demolition of public housing in a very small tract.

mhays Mar 21, 2013 8:27 PM

This is fascinating. Thanks Cirrus.

I suspect they changed the methods for group quarters. The 2010 numbers in Seattle declined significantly in two places: frat row at the UW and the county jail downtown. Seems like gray areas.

The 2000-2010 comparison is interesting. So is the 2010-2013 comparison, and especially "when today's construction projects are open and leased up" comparison.

PS, Los Angeles gets some vindication here. That's a lot of 20,000+ and even 40,000+.

fflint Mar 21, 2013 10:22 PM

Thanks for putting the maps together, seems very tedious! Some random observations:

*It's easy to see how LA turns out to be the most consistently dense metropolitan area, as high density areas sprawl in all directions within the city and county. I'm sure we'd see the same phenomenon with the entire city of New York, but NYC has a reputation for high density that LA doesn't--but should

*San Diego's densest tract appears to be the campus of UC San Diego, but the map confirms what I've always noticed on the ground--the Hillcrest, University Heights and Normal Heights areas form the main cluster of high population density within the central city

*Minneapolis isn't as dense as I would have expected

*Atlanta is as sparsely populated as I would have expected

*Houston has a relatively high peak density for the South, but it appears to be far outside downtown. Where is that?

*St. Louis really highlights the difference between population density and built density

*Detroit's low population densities are now comparable with the worst of the Sunbelt sprawlers

*The Chicago peak density tract is very odd--there are hundreds of residential towers in New York that could have been assembled similarly--but weren't. Ever. It's odd to define a census tract this way now, all of a sudden and only for one city, to say the least. That said, Chicago maintains huge swathes of high-density cityscape

memph Mar 21, 2013 11:55 PM

Valencia:
http://i273.photobucket.com/albums/j...ps5053498b.png

That's over 3/4 of the city's population there in dark green (40k+ ppsm).


http://i273.photobucket.com/albums/j...ps7fa09f44.png
And around 20% of the population at 100k+ ppsm.

Technically these aren't census tracts but neighbourhoods, which are usually a bit bigger.

Chase Unperson Mar 22, 2013 3:21 AM

Is the Chicago census tract new? It would be surprising that we just learned that Chicago had the densest census tract of a half million people per square mile if it has always been there.

Cirrus Mar 22, 2013 4:26 AM

The tract must be new, or newly modified to be that small. In 2000 the densest in Chicago was 90,683 ppsm, and the buildings in that 500,000 tract were there in 2000.


All times are GMT. The time now is 4:14 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2024, vBulletin Solutions, Inc.