HomeDiagramsDatabaseMapsForum About
     

Go Back   SkyscraperPage Forum > Discussion Forums > City Discussions
Reload this Page The US Census Bureau thread
Register FAQ


Reply
Viewing Page 138 of 235

 
Thread Tools Display Modes
     
     
  #2741  
Old Posted Aug 18, 2021, 8:48 PM
SIGSEGV's Avatar
SIGSEGV SIGSEGV is offline
look at us still talking
  
Join Date: Jun 2018
Location: Loop, Chicago
Posts: 6,570
And here's roughly how to calculate the total for an MSA without doing any arithmetic (though in this case it looks like everything is in Cook County).

https://mtgis-server.geo.census.gov/...Default&f=html

edit: maybe I sent too many queries, my access seems to be gone now. hopefully it will come back soon .
__________________
And here the air that I breathe isn't dead.

All you need is a modest house in a modest neighborhood, in a modest town where honest people dwell.
Reply With Quote
     
     
  #2742  
Old Posted Aug 18, 2021, 8:51 PM
ChiSoxRox's Avatar
ChiSoxRox ChiSoxRox is offline
Registered User
  
Join Date: Mar 2007
Location: Boston, MA
Posts: 2,509
I'll get the Bay Area done.

Note I'll get two numbers, San Francisco and San Jose MSAs, using the most recent (2020) definitions.
__________________
Like the pre-war masonry skyscrapers? Then check out my list of the tallest buildings in 1950.
Reply With Quote
     
     
  #2743  
Old Posted Aug 18, 2021, 8:58 PM
the urban politician the urban politician is offline
The City
  
Join Date: Jul 2004
Location: Chicago region
Posts: 21,372
Another metric (and this would take a SHIT TON of work so no worries if we never get this info) would be comparing the 2020 numbers of people living in 20,000+/sq mi census tracts to the 2010 data.

And then....

Determining % change

And then....

Comparing whose is growing faster.

My guess is that NY and Chi, perhaps SF are seeing the highest % growth rate, with Chicago probably being the highest due to a lower denominator.

Nearly all of Chicago's losses occurred in areas that were below 20,000 ppsm anyhow, whereas all of its white hot growth occurred in areas that were already pretty dense to begin with.

Ok fellas, get to work. Get me that data, and do it quick. Post haste! Stop being slackers
__________________
Supercar Adventures is my YouTube channel:

https://www.youtube.com/channel/UC4W...lUKB1w8ED5bV2Q
Reply With Quote
     
     
  #2744  
Old Posted Aug 18, 2021, 9:00 PM
ChiSoxRox's Avatar
ChiSoxRox ChiSoxRox is offline
Registered User
  
Join Date: Mar 2007
Location: Boston, MA
Posts: 2,509
New York: 9,151,543
Los Angeles: 1,919,006
Chicago: 1,238,801
San Francisco: 899,765
Miami: 396,021
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

San Francisco + San Jose: 964,489

20k strips out a lot more of the Bay suburbia than I expected. San Francisco itself is 633,797 of that.

Philly is next
__________________
Like the pre-war masonry skyscrapers? Then check out my list of the tallest buildings in 1950.
Reply With Quote
     
     
  #2745  
Old Posted Aug 18, 2021, 9:00 PM
SIGSEGV's Avatar
SIGSEGV SIGSEGV is offline
look at us still talking
  
Join Date: Jun 2018
Location: Loop, Chicago
Posts: 6,570
Quote:
Originally Posted by ChiSoxRox View Post
I'll get the Bay Area done.

Note I'll get two numbers, San Francisco and San Jose MSAs, using the most recent (2020) definitions.
Here's SF + Marin + Alameda + San Mateo + Contra Costa. : 899,765.

Probably other counties are included in the MSA (Solano? Sonoma?) but doubtful they have much density anyway

https://mtgis-server.geo.census.gov/...Default&f=html
__________________
And here the air that I breathe isn't dead.

All you need is a modest house in a modest neighborhood, in a modest town where honest people dwell.
Reply With Quote
     
     
  #2746  
Old Posted Aug 18, 2021, 9:05 PM
ChiSoxRox's Avatar
ChiSoxRox ChiSoxRox is offline
Registered User
  
Join Date: Mar 2007
Location: Boston, MA
Posts: 2,509
Quote:
Originally Posted by SIGSEGV View Post
Here's SF + Marin + Alameda + San Mateo + Contra Costa. : 899,765.

Probably other counties are included in the MSA (Solano? Sonoma?) but doubtful they have much density anyway

https://mtgis-server.geo.census.gov/...Default&f=html
Thanks for the double check. Here is the definitions PDF. Indeed, San Francisco MSA is still 5 counties.
__________________
Like the pre-war masonry skyscrapers? Then check out my list of the tallest buildings in 1950.
Reply With Quote
     
     
  #2747  
Old Posted Aug 18, 2021, 9:17 PM
ChiSoxRox's Avatar
ChiSoxRox ChiSoxRox is offline
Registered User
  
Join Date: Mar 2007
Location: Boston, MA
Posts: 2,509
Philadelphia MSA - 841,729
Philadelphia proper - 801,816

New York: 9,151,543
Los Angeles: 1,919,006
Chicago: 1,238,801
San Francisco: 899,765
Philadelphia - 841,729
Miami: 396,021
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
__________________
Like the pre-war masonry skyscrapers? Then check out my list of the tallest buildings in 1950.
Reply With Quote
     
     
  #2748  
Old Posted Aug 18, 2021, 9:23 PM
SIGSEGV's Avatar
SIGSEGV SIGSEGV is offline
look at us still talking
  
Join Date: Jun 2018
Location: Loop, Chicago
Posts: 6,570
Quote:
Originally Posted by ChiSoxRox View Post
Thanks for the double check. Here is the definitions PDF. Indeed, San Francisco MSA is still 5 counties.
For Boston, I get 727,666

(my query, hopefully didn't mistype anything!: https://mtgis-server.geo.census.gov/...Default&f=html )

and an easy one, Honolulu: 182,167 (https://mtgis-server.geo.census.gov/...Default&f=html )
__________________
And here the air that I breathe isn't dead.

All you need is a modest house in a modest neighborhood, in a modest town where honest people dwell.
Reply With Quote
     
     
  #2749  
Old Posted Aug 18, 2021, 9:23 PM
mhays mhays is offline
Never Dell
  
Join Date: Jul 2001
Posts: 20,926
I'll have to learn how to use the query tool! For now, a couple more using the map-and-tally method:

Dallas: 50,418
Atlanta: 24,362
Reply With Quote
     
     
  #2750  
Old Posted Aug 18, 2021, 9:25 PM
ChiSoxRox's Avatar
ChiSoxRox ChiSoxRox is offline
Registered User
  
Join Date: Mar 2007
Location: Boston, MA
Posts: 2,509
Quote:
Originally Posted by SIGSEGV View Post
For Boston, I get 727,666

(my query, hopefully didn't mistype anything!: https://mtgis-server.geo.census.gov/...Default&f=html )
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
__________________
Like the pre-war masonry skyscrapers? Then check out my list of the tallest buildings in 1950.
Last edited by ChiSoxRox; Aug 18, 2021 at 9:27 PM. Reason: Add Honolulu
Reply With Quote
     
     
  #2751  
Old Posted Aug 18, 2021, 9:29 PM
SIGSEGV's Avatar
SIGSEGV SIGSEGV is offline
look at us still talking
  
Join Date: Jun 2018
Location: Loop, Chicago
Posts: 6,570
Quote:
Originally Posted by mhays View Post
I'll have to learn how to use the query tool! For now, a couple more using the map-and-tally method:

Dallas: 50,418
Atlanta: 24,362
Just take one of my queries and change the states/counties (adding more of each if necessary) and it will tally it up. Until you get rejected from the server like I now have done on two computers . Note that I'm being lazy and assuming the same county doesn't appear in multiple MSA's in multiple relevant states, though you could also just do one county at a time and it wouldn't be too bad...
__________________
And here the air that I breathe isn't dead.

All you need is a modest house in a modest neighborhood, in a modest town where honest people dwell.
Reply With Quote
     
     
  #2752  
Old Posted Aug 18, 2021, 9:32 PM
ChiSoxRox's Avatar
ChiSoxRox ChiSoxRox is offline
Registered User
  
Join Date: Mar 2007
Location: Boston, MA
Posts: 2,509
I am going county by county (using the map to see which ones have >10k as a filter).

Atlanta was quick though. 8 such tracts in all of Georgia, all 8 in Fulton County.

The Texas metros:

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
Dallas: 54,893
Minneapolis: 52,998
Denver: 49,423
Milwaukee: 47,988
Providence: 39,442
Portland: 38,057
Madison: 35,514
Columbus: 31,592
Atlanta: 26,589
Austin: 23,224

San Antonio and El Paso: Goose eggs.
__________________
Like the pre-war masonry skyscrapers? Then check out my list of the tallest buildings in 1950.
Last edited by ChiSoxRox; Aug 18, 2021 at 9:36 PM. Reason: Providence
Reply With Quote
     
     
  #2753  
Old Posted Aug 18, 2021, 9:40 PM
digitallagasse digitallagasse is offline
Registered User
  
Join Date: Sep 2018
Location: Henderson, NV
Posts: 104
I believe I found a few tracts in the Vegas metro. It likely will not add up to much.
Reply With Quote
     
     
  #2754  
Old Posted Aug 18, 2021, 9:45 PM
ChiSoxRox's Avatar
ChiSoxRox ChiSoxRox is offline
Registered User
  
Join Date: Mar 2007
Location: Boston, MA
Posts: 2,509
New rule: keeping metros over 20,000 people total

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
Dallas: 54,893
Minneapolis: 52,998
Denver: 49,423
Milwaukee: 47,988
Providence: 39,442
Portland: 38,057
Madison: 35,514
Columbus: 31,592
Atlanta: 26,589
Las Vegas: 26,114
Austin: 23,224
Champaign: 22,271

For comparison: Pittsburgh is 13,077. Buffalo surprisingly is another 0.
__________________
Like the pre-war masonry skyscrapers? Then check out my list of the tallest buildings in 1950.
Last edited by ChiSoxRox; Aug 18, 2021 at 9:55 PM.
Reply With Quote
     
     
  #2755  
Old Posted Aug 18, 2021, 9:49 PM
SIGSEGV's Avatar
SIGSEGV SIGSEGV is offline
look at us still talking
  
Join Date: Jun 2018
Location: Loop, Chicago
Posts: 6,570
PVD (well, all of Rhode Island, not including Fall River/ New Bedford): 30,224

https://mtgis-server.geo.census.gov/...Default&f=html

All of Tennessee has 2309 people in census tracts above 20k, from one census tract in Knoxville (so Memphis and Nashville have none).

Indiana has 8,044 people in census tracts above 20k in one tract in Lafayette.

Michigan has 3 counties with census tracts above 20k, with populations:
Wayne: 4,656
Washtenaw (Ann Arbor): 6,052
Ingham (East Lansing, presumably): 11896

North Carolina has one tract with 2000 people in Mecklenburg County (Charlotte)

Outside of Dallas/Houston/Austin, Lubbock has 6,374 people (presumably Texas Tech housing, but I didn't check).

Surprisingly to me, Las Vegas has 26,144 people and Reno has 2,049.

Phoenix has 20,351 (13,807 in Maricopa, 6,544 in Pinal) and Tucson has 5,138.

Iowa City has 4,165 and Ames has 4,837, both presumably student housing.

Cleveland has 3,431 and Cincinnati 3,836.

Idaho has 7,781 in Madison County (Rexburg, perhaps? I think there's a BYU branch there).

Utah has 13,203 in Utah County (probably also BYU)


Alabama, Kentucky, Kansas, Oklahoma, Nebraska, West Virginia, Alaska, Montana have zero.
__________________
And here the air that I breathe isn't dead.

All you need is a modest house in a modest neighborhood, in a modest town where honest people dwell.
Reply With Quote
     
     
  #2756  
Old Posted Aug 18, 2021, 9:49 PM
insidediamond insidediamond is offline
Registered User
  
Join Date: Aug 2021
Location: Ann Arbor/Nashville
Posts: 10
For Metro Detroit I got 2 tracts, one in Hamtramck, and the other in Ann Arbor,
This number is quite pathetic when compared with its peers and even smaller metros.

Detroit:10,708
Reply With Quote
     
     
  #2757  
Old Posted Aug 18, 2021, 9:56 PM
ChiSoxRox's Avatar
ChiSoxRox ChiSoxRox is offline
Registered User
  
Join Date: Mar 2007
Location: Boston, MA
Posts: 2,509
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
__________________
Like the pre-war masonry skyscrapers? Then check out my list of the tallest buildings in 1950.
Last edited by ChiSoxRox; Aug 18, 2021 at 10:07 PM. Reason: Allentown and Worcester
Reply With Quote
     
     
  #2758  
Old Posted Aug 18, 2021, 10:02 PM
SIGSEGV's Avatar
SIGSEGV SIGSEGV is offline
look at us still talking
  
Join Date: Jun 2018
Location: Loop, Chicago
Posts: 6,570
Are you including Allentown with Philly? Looks like Lehigh County would make the cut with 29,319: https://mtgis-server.geo.census.gov/...Default&f=html

Also Worcester County in Massachusetts is 26,374!
__________________
And here the air that I breathe isn't dead.

All you need is a modest house in a modest neighborhood, in a modest town where honest people dwell.
Reply With Quote
     
     
  #2759  
Old Posted Aug 18, 2021, 10:03 PM
ChiSoxRox's Avatar
ChiSoxRox ChiSoxRox is offline
Registered User
  
Join Date: Mar 2007
Location: Boston, MA
Posts: 2,509
Quote:
Originally Posted by SIGSEGV View Post
Are you including Allentown with Philly? Looks like Lehigh County would make the cut with 29,319: https://mtgis-server.geo.census.gov/...Default&f=html
No, since Allentown is outside the MSA. Likewise for Boulder with Denver. Added Allentown.
__________________
Like the pre-war masonry skyscrapers? Then check out my list of the tallest buildings in 1950.
Reply With Quote
     
     
  #2760  
Old Posted Aug 18, 2021, 10:22 PM
craigs's Avatar
craigs craigs is offline
Registered User
  
Join Date: May 2019
Location: Los Angeles
Posts: 10,378
I tried the query tool but my search was 'rejected.'

Anybody want to run a query with Census tracts of, say, 30,000+ ppsm?
__________________
Chaos upon my enemies, chaos upon my enemies, chaos upon my enemies.
Reply With Quote
     
     
This discussion thread continues

Use the page links to the lower-right to go to the next page for additional posts
 
 
Reply
Viewing Page 138 of 235

Go Back   SkyscraperPage Forum > Discussion Forums > City Discussions
Reload this Page The US Census Bureau thread
Forum Jump

« Previous Thread | Next Thread »

« Previous Thread | Next Thread »

Forum Jump


All times are GMT. The time now is 11:04 AM.

      
SkyscraperPage.com - Privacy Statement - Top

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