Welcome to City-Data.com Forum!
U.S. CitiesCity-Data Forum Index
Go Back   City-Data Forum > U.S. Forums > General U.S. > City vs. City
 [Register]
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
View detailed profile (Advanced) or search
site with Google Custom Search

Search Forums  (Advanced)
Reply Start New Thread
 
Old 09-27-2021, 04:21 PM
 
Location: Green Country
2,868 posts, read 2,825,123 times
Reputation: 4798

Advertisements

It seems like a common refrain when comparing MSAs is that they vary significantly in size. Cleveland's MSA is less than 2,000 square miles (1,999.4 to be exact) whereas Phoenix's is 14,566.7 square miles. That's a huge difference!

But what would happen if we standardized it and tried to compare city sizes at fixed areas. This thread does that by using a 2,500 square mile benchmark.

The rules are simple. Starting with the center county, I'll adjacent counties (prioritizing those with higher density) until the area is 2,500 square miles, +-10% max deviation.

For counties that are themselves > 2,500 square miles, I'll use the Census Bureau's hidden weapon: Census County Divisions.

The end result should allow us to compare metro areas controlling for land area.

Because CCDs are hard to find, and not yet available for 2020 Census data, I'll be using ACS 2019 data.
Reply With Quote Quick reply to this message

 
Old 09-27-2021, 04:35 PM
 
Location: Green Country
2,868 posts, read 2,825,123 times
Reputation: 4798
County - Population - Land Area (square miles)

ATLANTA
  • Clayton County, GA - 292,256 - 142
  • Cobb County, GA - 760,141 - 340
  • DeKalb County, GA - 759,297 - 268
  • Douglas County, GA - 146,343 - 200
  • Fayette County, GA - 114,421 - 194
  • Forsyth County, GA - 244,252 - 225
  • Fulton County, GA - 1,063,937 - 527
  • Gwinnett County, GA - 936,250 - 431
  • Henry County, GA - 234,561 - 319

TOTAL POPULATION - 4,551,458
Land Area: 2,646

---------------------------------------------------------------------------------------------------------------------------------------------------------------

AUSTIN
Hays County, TX - 230,191 - 678
Travis County, TX - 1,273,954 - 992
Williamson County, TX excl. Granger CCP - 587,198 - 994

TOTAL POPULATION - 2,091,343
Land Area: 2,664

---------------------------------------------------------------------------------------------------------------------------------------------------------------

BOSTON-PROVIDENCE
Bristol County, MA - 565,217 - 553
Essex County, MA - 789,034 - 493
Middlesex County, MA - 1,611,699 - 818
Norfolk County, MA - 706,775 - 396
Providence County, RI - 638,931 - 410
Suffolk County, MA - 803,907 - 58

TOTAL POPULATION - 5,115,563
Land Area: 2,728
Reply With Quote Quick reply to this message
 
Old 09-27-2021, 04:51 PM
 
8,875 posts, read 6,885,926 times
Reputation: 8699
Good luck with West. Seattle's central county is mostly mountains and forest, but is around 2,000 square miles.

I'd suggest omitting the rural parts of even the central counties. But that wouldn't be fair to the East so maybe do the same there.
Reply With Quote Quick reply to this message
 
Old 09-27-2021, 04:54 PM
 
Location: Green Country
2,868 posts, read 2,825,123 times
Reputation: 4798
CHARLOTTE
Cabarrus County, NC - 216,453 - 361
Gaston County, NC - 224,529 - 356
Lancaster County, SC (Van Wyck CCD only) - 34,903 - 66
Mecklenburg County, NC - 1,110,356 - 524
Union County, NC - 239,859 - 633
York County, SC - 280,979 - 681

TOTAL POPULATION - 2,107,079
Land Area: 2,621

---------------------------------------------------------------------------------------------------------------------------------------------------------------

CHICAGO
Cook County, IL - 5,150,233 - 945
DuPage County, IL - 922,921 - 328
Kane County, IL - 532,403 - 519
Lake County, IL - 696,535 - 444
Lake County, IN - Calumet Township - 97,791 - 61
Lake County, IN - North Township - 152,912 - 53
Will County, IL - 690,743 - 836 excl: (what a cluster)
- Crete Township - 23,401 - 44
- Custer Township - 1,324 - 26
- Florence Township - 1,029 - 37
- Green Garden Township - 3,981 - 37
- Manhattan Township - 9,928 - 37
- Monee Township - 15,531 - 36
- Peotone Township - 4,392 - 36
- Reed Township - 7,046 - 17
- Washington Township - 6,337 - 45
- Wesley Township - 2,244 - 28
- Will Township - 1,866 - 36
- Wilmington Township - 6,137 - 33
- Wilton Town - 724 - 36

TOTAL POPULATION - 8,159,598
Land Area: 2,738

---------------------------------------------------------------------------------------------------------------------------------------------------------------

CINCINNATI-DAYTON
Boone County, KY - 133,581 - 246
Butler County, OH - 383,134 - 467
Campbell County, KY - 93,584 - 151
Clermont County, OH - 206,428 - 452
Hamilton County, OH - 817,473 - 405
Kenton County, KY - 166,998 - 160
Montgomery County, OH - 531,687 - 462
Warren County, OH - 234,602 - 401

TOTAL POPULATION - 2,567,487
Land Area: 2,744
Reply With Quote Quick reply to this message
 
Old 09-27-2021, 04:57 PM
 
Location: Green Country
2,868 posts, read 2,825,123 times
Reputation: 4798
Quote:
Originally Posted by mhays25 View Post
Good luck with West. Seattle's central county is mostly mountains and forest, but is around 2,000 square miles.

I'd suggest omitting the rural parts of even the central counties. But that wouldn't be fair to the East so maybe do the same there.
Yes, I'll chop out weird quirks like that. Another East Coast example is Miami, where a majority of the metro area is protected swampland. All of those will get surgically removed.

The biggest issue is that I'm starting with the center city and then adding counties based on density counts. If, during the course of adding counties, I go over 2,750 (+10% deviation), then I try to pull out the least dense land (see how I removed the farmland of northern Williamson to get it under 2,750).

And sometimes, like the Cincinnati example above, that means adding an entirely different metro to the counts. So Cincinnati becomes Cincinnati-Dayton since that's the most cohesively dense 2,500 square mile catchment area I can get.
Reply With Quote Quick reply to this message
 
Old 09-27-2021, 06:25 PM
 
Location: Green Country
2,868 posts, read 2,825,123 times
Reputation: 4798
CLEVELAND
Cuyahoga County, OH - 1,235,072 - 457
Lake County, OH - 230,149 - 229
Lorain County, OH - 309,833 - 491
Medina County, OH - 179,746 - 422
Stark County, OH - 370,606 - 575
Summit County, OH - 541,013 - 413

TOTAL POPULATION - 2,866,419
Land Area: 2,587

---------------------------------------------------------------------------------------------------------------------------------------------------------------

DALLAS-FORT WORTH
Collin County, TX excl. CCDs of Anna, Blue Ridge, Celina, Farmersville, and Nevada - 935,921 - 339
Dallas County, TX - 2,635,516 - 872
Denton County, TX - only CCDs of Carrollton, Denton, Lewisville-Flower Mound, Pilot Point and The Colony - 794,432 - 455
Rockwall County, TX - 104,915 - 127
Tarrant County, TX - 2,102,515 - 864

TOTAL POPULATION - 6,573,299
Land Area: 2,657

Dallas performs far better than expected.

---------------------------------------------------------------------------------------------------------------------------------------------------------------

DENVER
Adams County, CO excl. East Adams CCD - 507,302 - 303
Arapahoe County, CO excl. East Arapahoe CCD - 618,459 - 147
Broomfield County, CO - 70,465 - 33
Boulder County, CO - 326,196 - 726
Denver County, CO - 727,211 - 153
Douglas County, CO - 351,154 - 840
Jefferson County, CO - Northeast CCD - 485,555 - 167
Larimer County, CO - Berthould CCD - 14,115 - 58
Weld County, CO - Erie-Frederick CCD - 51,547 - 99
Weld County, CO - Johnstown-Milliken CCD - 33,904 - 151

TOTAL POPULATION - 3,185,908
Land Area: 2,677

Denver is also surprisingly high.

Last edited by manitopiaaa; 09-27-2021 at 07:05 PM..
Reply With Quote Quick reply to this message
 
Old 09-27-2021, 06:38 PM
 
Location: Green Country
2,868 posts, read 2,825,123 times
Reputation: 4798
DETROIT
Macomb County, MI - 873,972 - 479
Oakland County, MI - 1,257,584 - 867
Washtenaw County, MI - 367,601 - 706
Wayne County, MI - 1,749,343 - 612
Windsor city, ON - 235,428 - 57

TOTAL POPULATION - 4,483,928
Land Area: 2,721

---------------------------------------------------------------------------------------------------------------------------------------------------------------

HOUSTON
Fort Bend County, TX - Fulshear-Simonton CCD - 174,558 - 161
Fort Bend County, TX - Rosenberg-Richmond CCD - 109,201 - 205
Fort Bend County, TX - Stafford-Missouri City CCD - 160,829 - 84
Fort Bend County, TX - Sugar Land CCD - 303,793 - 95
Galveston County, TX - 342,139 - 379
Harris County, TX - 4,713,325 - 1,706

TOTAL POPULATION - 5,803,845
Land Area: 2,630

---------------------------------------------------------------------------------------------------------------------------------------------------------------

KANSAS CITY
Clay County, MO - 249,948 - 398
Douglas County, KS - 122,259 - 456
Jackson County, MO - 703,011 - 605
Johnson County, KS - 602,401 - 474
Leavenworth County, KS - Leavenworth City CCD - 36,064 - 24
Platte County, MO - 104,418 - 420
Shawnee County, KS - Tecumseh Township CCD - 7,781 - 33
Shawnee County, KS - Topeka City CCD - 125,318 - 61
Wyandotte County, KS - 165,429 - 152

TOTAL POPULATION - 2,116,629
Land Area: 2,623
Reply With Quote Quick reply to this message
 
Old 09-27-2021, 06:44 PM
 
Location: Northeast states
14,057 posts, read 13,953,593 times
Reputation: 5198
Los Angeles County is bigger than state of Rhode Island and 85% of Connecticut size.
Reply With Quote Quick reply to this message
 
Old 09-27-2021, 06:45 PM
 
4,344 posts, read 2,816,648 times
Reputation: 5273
Very interesting thread.
It's as close to apples to apples comparisons of development patterns we can get.
2500 sq miles is a good limit.

Information like this thread dispels exaggerated comments such as DFW is only big because it is 10,000 sq miles. It is clear from your data that most of that area is fluff.

Can't wait to see how many people the Bay Area squeezes in 2500 sq miles.
Reply With Quote Quick reply to this message
 
Old 09-27-2021, 06:58 PM
 
Location: Green Country
2,868 posts, read 2,825,123 times
Reputation: 4798
MEMPHIS
Crittenden County, AR - 48,672 - 610
DeSoto County, MS - 184,945 - 476
Shelby County, TN - 937,166 - 764
Tate County, MS - 28,404 - 405
Tipton County, TN - 61,447 - 458

TOTAL POPULATION - 1,260,634
Land Area: 2,713

---------------------------------------------------------------------------------------------------------------------------------------------------------------

MIAMI
Broward County, FL excl. Conservation CCD - 1,952,778 - 404
Indian River County, FL excl. Fellsmere CCD - 137,526 - 117
Martin County, FL excl. Indiantown CCD - 139,463 - 134
Miami-Dade County, FL excl. Everglades CCD - 2,710,289 - 970
Monroe County, FL excl. Cape Sable CCD - 74,209 - 123
Palm Beach County, FL excl. CCDs of Belle Glades, Glades, and Western Community - 1,428,291 - 591
St. Lucie County, FL excl. West St. Lucie CCD - 322,168 - 208

TOTAL POPULATION - 6,764,724
Land Area: 2,547

Extremely impressive numbers for Miami. The Everglades really do take away from just how dense the metro is.

---------------------------------------------------------------------------------------------------------------------------------------------------------------

MINNEAPOLIS-SAINT PAUL
Anoka County, MN - 356,921 - 422
Carver County, MN excl. Carter Township + New Germany City - 103,776 - 319
Dakota County, MN - 429,021 - 563
Hennepin County, MN - 1,265,843 - 554
Ramsey County, MN - 550,321 - 152
Scott County, MN - 149,013 - 356
Washington County, MN - 262,440 - 384

TOTAL POPULATION - 3,117,335
Land Area: 2,750 (exact max)
Reply With Quote Quick reply to this message
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.

Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.


Reply
Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply
Message:


Over $104,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > U.S. Forums > General U.S. > City vs. City
Similar Threads

All times are GMT -6. The time now is 10:40 AM.

© 2005-2024, Advameg, Inc. · Please obey Forum Rules · Terms of Use and Privacy Policy · Bug Bounty

City-Data.com - Contact Us - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37 - Top