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-29-2021, 02:11 PM
 
Location: Green Country
2,868 posts, read 2,816,527 times
Reputation: 4798

Advertisements

Quote:
Originally Posted by Mutiny77 View Post
I like CCDs also but unfortunately, they aren't used in all states. https://www.federalregister.gov/d/2018-24566/p-20
Yeah, I've been using state legislative districts in places where CCDs aren't available. No way in hell, I'm spending 3 hours adding up townships in Pennsylvania!
Reply With Quote Quick reply to this message

 
Old 09-29-2021, 02:17 PM
 
Location: Green Country
2,868 posts, read 2,816,527 times
Reputation: 4798
Quote:
Originally Posted by manitopiaaa View Post
Since there's a lot of demand in Raleigh, I'm leapfrogging to add it now.

Here was Charlotte for reference:

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

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

RALEIGH
Chatham County, NC - only CCDs of Baldwin and Williams - 27,697 - 94
Durham County, NC - 321,488 - 287
Franklin County, NC - only 4 southermost Townships + Louisburg - 49,000 - 250
Granville County, NC - only Dutchville and Brassfield Township - 28,313 - 132
Harnett County, NC - only Black River Township CCD - 11,787 - 29
Johnston County, NC - 209,339 - 791
Orange County, NC excl. Bingham, Cedar Grove and Little River Townships - 132,015 - 203
Wake County, NC - 1,111,761 - 835

TOTAL POPULATION - 1,891,400
Land Area: 2,621

At exactly the same perimeter (2,621 square miles), Charlotte has 2,107,079 people to Raleigh's 1,891,400.

It goes to show just how rural much of Charlotte's CSA is. Raleigh's 1,891,400 is only a smidge lower than the Raleigh CSA totals, while Charlotte's 2,107,079 is 700k below their CSA counts.

So while Charlotte is still bigger in 2,500 square miles than Raleigh, the latter does get much closer to parity than the CSA counts would imply. Both cities have something to crow about.
Also, I should add that in the above I stopped at 2,621 for Raleigh so they would match Charlotte. This was only as a comparison point to Charlotte.

For the purposes of this thread, I will add the townships of Melville, Haw River, Burlington, Graham, and Boone Station (all in Alamance County) to Raleigh and still be under 2,750 square miles (my max). So for this thread, Raleigh is:

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

RALEIGH
Alamance County, NC - Boone Station, Burlington, Graham, Haw River, and Melville Townships - 118,743 - 109
Chatham County, NC - only CCDs of Baldwin and Williams - 27,697 - 94
Durham County, NC - 321,488 - 287
Franklin County, NC - only 4 southermost Townships + Louisburg - 49,000 - 250
Granville County, NC - only Dutchville and Brassfield Township - 28,313 - 132
Harnett County, NC - only Black River Township CCD - 11,787 - 29
Johnston County, NC - 209,339 - 791
Orange County, NC excl. Bingham, Cedar Grove and Little River Townships - 132,015 - 203
Wake County, NC - 1,111,761 - 835

TOTAL POPULATION - 2,010,143
Land Area: 2,730

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

Charlotte is still 129 square miles under my cap as well, so I'll have to go back and see if I can add another township or two to its count. I suspect whatever I add will have ~50k total, since there's no target as juicy as Burlington for Charlotte to absorb into its numbers.
Reply With Quote Quick reply to this message
 
Old 09-29-2021, 02:28 PM
 
93,255 posts, read 123,876,708 times
Reputation: 18258
Perhaps using PUMA's may be an easier way of doing this: https://censusreporter.org/profiles/...allen-puma-va/
Reply With Quote Quick reply to this message
 
Old 09-29-2021, 02:36 PM
 
Location: Green Country
2,868 posts, read 2,816,527 times
Reputation: 4798
Quote:
Originally Posted by ckhthankgod View Post
Perhaps using PUMA's may be an easier way of doing this: https://censusreporter.org/profiles/...allen-puma-va/
Thanks! I've never even heard of PUMAs, so will definitely consult this when doing the second round scrub.
Reply With Quote Quick reply to this message
 
Old 09-29-2021, 03:10 PM
 
4,159 posts, read 2,846,281 times
Reputation: 5516
Quote:
Originally Posted by WASD44 View Post
The entire CSA is barely more populated than Charlotte's population at 2600 sq mi....
Well, it honestly depends on how you go about divvying up the counties and/or townships. Angier is a dozen miles from Raleigh city limits and not even in the CSA at the moment (Harnett is the once and future Triangle county). Johnston County is huge and majority rural, but 60% of the population lives in the small strip adjacent to the Wake County line, so unsure how that would be treated. And even in Wake, the eastern third provides maybe 40,000 people while 900,000 people squeeze into 260 square miles.

More than even most places, a multipolar region is a hard one to gauge. At the easiest level (Johnston+Wake+Durham+Orange), you get 2300 square miles and 1.82 million (more or less where Charlotte is with density). But I don’t know how the op is treating things with regard to density levels. Also where Alamance fits in, which commuter wise is more tied to the Triangle than the Triad, but the MSA split means that point is moot.

Well, poop. Never mind. Thanks to the OP for making this post dated before I had even hit send.
Reply With Quote Quick reply to this message
 
Old 09-29-2021, 03:15 PM
 
4,159 posts, read 2,846,281 times
Reputation: 5516
Quote:
Originally Posted by manitopiaaa View Post
Also, I should add that in the above I stopped at 2,621 for Raleigh so they would match Charlotte. This was only as a comparison point to Charlotte.

For the purposes of this thread, I will add the townships of Melville, Haw River, Burlington, Graham, and Boone Station (all in Alamance County) to Raleigh and still be under 2,750 square miles (my max). So for this thread, Raleigh is:

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

RALEIGH
Alamance County, NC - Boone Station, Burlington, Graham, Haw River, and Melville Townships - 118,743 - 109
Chatham County, NC - only CCDs of Baldwin and Williams - 27,697 - 94
Durham County, NC - 321,488 - 287
Franklin County, NC - only 4 southermost Townships + Louisburg - 49,000 - 250
Granville County, NC - only Dutchville and Brassfield Township - 28,313 - 132
Harnett County, NC - only Black River Township CCD - 11,787 - 29
Johnston County, NC - 209,339 - 791
Orange County, NC excl. Bingham, Cedar Grove and Little River Townships - 132,015 - 203
Wake County, NC - 1,111,761 - 835

TOTAL POPULATION - 2,010,143
Land Area: 2,730

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

Charlotte is still 129 square miles under my cap as well, so I'll have to go back and see if I can add another township or two to its count. I suspect whatever I add will have ~50k total, since there's no target as juicy as Burlington for Charlotte to absorb into its numbers.
You must spread some Reputation around before giving it to manitopiaaa again.
Reply With Quote Quick reply to this message
 
Old 09-29-2021, 08:55 PM
 
1,026 posts, read 446,955 times
Reputation: 686
Columbus OH

Pop-Sq-Density

Frankling - 1,323,807 - 544 - 2,400
Delaware - 214,124 - 457 - 470
Fairfield - 158,921 - 509 - 310
Licking - 178,519 - 687 - 260
Union - 62,784 - 437 - 140
Pickaway - 58,539 - 507 - 120

Total Population: 1,996,694

Land Area: 2,704

Last edited by MPK21; 09-29-2021 at 09:14 PM..
Reply With Quote Quick reply to this message
 
Old 09-29-2021, 09:28 PM
 
1,026 posts, read 446,955 times
Reputation: 686
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


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

I see what you did here, added Montgomery County to Cincy MSA. Was a bit puzzled in that Cincy MSA is over 4,808 sq miles with a population of 2,137,500. Without Montgomery County, the Cincinnati MSA must include lots of rural counties.

Expanding CLE MSA to even the size of Columbus MSA takes it over 3,000,000 and the size of CIN MSA takes it closer to its CSA population of 3,633,000.

It gives a good perspective of Ohio's 3C cities MSAs:

CIN 4,808 sq miles Population: 2,137,500 in a CSA population of 2,316,022
COL 3,169 sq miles Population: 2,078,725 in a CSA population of 2,544,048
CLE 1,996 sq miles Population: 2,058,844 in a CSA population of 3,633,962

Last edited by MPK21; 09-29-2021 at 10:05 PM..
Reply With Quote Quick reply to this message
 
Old 09-30-2021, 05:50 AM
 
93,255 posts, read 123,876,708 times
Reputation: 18258
Quote:
Originally Posted by manitopiaaa View Post
Thanks! I've never even heard of PUMAs, so will definitely consult this when doing the second round scrub.
No problem and to be honest, this was new to me until I saw this on the Census Reporter website while looking at NYC Community Board information. A community board there is the same as a PUMA. Some information on Public Use Microdata Areas: https://www.census.gov/programs-surv...eas/pumas.html
Reply With Quote Quick reply to this message
 
Old 09-30-2021, 01:15 PM
 
Location: Lebanon, OH
7,079 posts, read 8,941,070 times
Reputation: 14739
Quote:
Originally Posted by MPK21 View Post
I see what you did here, added Montgomery County to Cincy MSA. Was a bit puzzled in that Cincy MSA is over 4,808 sq miles with a population of 2,137,500. Without Montgomery County, the Cincinnati MSA must include lots of rural counties.
It does, rural counties should not be in a MSA to begin with because they have more farm animals than people.

Brown (OH), Bracken, Gallatin, Grant, Pendleton(KY) Franklin, Union(IN) are too far flung to be a metro. 75% of Warren county is closer to Dayton which does not even have Preble county in its metro which is a cornfield county right next to Montgomery, Dayton and Springfield are separate metro areas despite being practically next to each other.
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.

© 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