The US Census Bureau thread

[ChiSoxRox]

Originally Posted by Phil McAvity

Does anyone know when the metro area populations will be released from last year's census?

Here, under the CBSA tab

[Steely Dan]

Originally Posted by ChiSoxRox

Wikipedia has a list from the 2010 Census I'll see about updating. But since none of the Illinois cities had drastic changes, the ranking probably still holds. So 7 Illinois municipalities over 10k ppsm.

1. Stone Park. By Maywood and Bellwood, small even by near west suburb standards.

2. Cicero

3. Berwyn

4. Elmwood Park

5. Chicago

6. Oak Park

7. Harwood Heights (entirely inside Chicago by O'Hare)

Oh yeah, stupid little old stone park.

It's not even a half square mile in area. That falls into the "doesn't really count" category in my mind.

But I did forget about Elmwood park and Harwood heights.

That west side inner suburban cluster really is a density standout in the metro area. All 4 of those burbs, along with enclaved burbs Harwood heights and norridge could be annexed into the city without anyone noticing, as they're all over 10K ppsm. That'd be a significant addition to the city (not that it'd ever happen.

Originally Posted by ChiSoxRox

Chicago by O'Hare)

As for Evanston: 9,445 ppsm in 2010. The north and west sides of Evanston see quite the density drop towards Wilmette and Skokie. Since Evanston is its own township, it's outlined nicely on the Census map.

ETA: Evanston was up 4k in the 2020 census, so it's just past 10k ppsm again. Harwood Heights also had growth, so Evanston is likely 8th. Still, it won't have caught the top 5.

It's good to see Evanston back over 10K ppsm. Not that it means a whole kot on the ground, but it's grear to see the inner ring growing along with the city proper.

[dave8721]

Originally Posted by cabasse

found the api endpoint with a sniffer, and playing with it with postman at mtgis-server.geo.census.gov/arcgis/rest/services/PL_Press_Release_2020/PopDen/MapServer/15/query.
looks like it's a get call with the following params when you click on a tract:

f: json
returnGeometry: true
spatialRef: esriSpatialRelIntersects
geometry: {"xmin":-9395670.984029967,"ymin":4000525.228632153,"xmax":-9395556.32848754,"ymax":4000639.8841745807,"spatialReference":{"wkid":102100,"latestWkid":3857}}
geometryType: esriGeometryEnvelope
inSR: 102100
 outFields: OBJECTID,SHAPE_Length,SHAPE_Area,AFFGEOID,GEOID,STATEFP,COUNTYFP,TRACTCE,NAME,NAMELSAD,STUSPS,NAMELSADCO,STATE_NAME,ALAND,AWATER,POP2020,POPDEN2020,VOTEAGE_PCT,VOTEAGE_TOT,GQ_PCT,GQ_TOT,GQ_IN_PCT,GQ_IN_TOT,GQ_NON_PCT,GQ_NON_TOT,WHITE_PCT,WHITE_TOT,BLACK_PCT,BLACK_TOT,AIAN_PCT,AIAN_TOT,ASIAN_PCT,ASIAN_TOT,NHOPI_PCT,NHOPI_TOT,SORACE_PCT,SORACE_TOT,TWORACE_PCT,TWORACE_TOT,WHITE_C_PCT,WHITE_C_TOT,BLACK_C_PCT,BLACK_C_TOT,AIAN_C_PCT,AIAN_C_TOT,ASIAN_C_PCT,ASIAN_C_TOT,NHOPI_C_PCT,NHOPI_C_TOT,SORACE_C_PCT,SORACE_C_TOT,HISPLAT_PCT,HISPLAT_TOT,NOHISPLAT_PCT,NOHISPLAT_TOT,HU_TOT,HUOCCUPIED_TOT,HUOCCUPIED_PCT,AREALAND_SQMI
outSR: 102100

but you can throw different queries at it based on what i'm seeing here Query (Map Service/Layer)—ArcGIS REST APIs | ArcGIS Developers

as an example, i tried this and it seemed to pull back a list of IDs or coordinates for what i assume are each tract in the state: mtgis-server.geo.census.gov/arcgis/rest/services/PL_Press_Release_2020/PopDen/MapServer/15/query?where=STATE_NAME='Georgia'&f=json

If you know the fips code for your state and County you can do it. This query for example returns the 20k+ population density tracts in Florida (12) and Miami-Dade County (086):
https://mtgis-server.geo.census.gov/...Geometry=true&

[SIGSEGV]

Originally Posted by cabasse

found the api endpoint with a sniffer, and playing with it with postman at mtgis-server.geo.census.gov/arcgis/rest/services/PL_Press_Release_2020/PopDen/MapServer/15/query.
looks like it's a get call with the following params when you click on a tract:

f: json
returnGeometry: true
spatialRef: esriSpatialRelIntersects
geometry: %7B%22xmin%22%3A-9395670.984029967%2C%22ymin%22%3A4000525.228632153%2C%22xmax%22%3A-9395556.32848754%2C%22ymax%22%3A4000639.8841745807%2C%22spatialReference%22%3A%7B%22wkid%22%3A102100%2C%22latestWkid%22%3A3857%7D%7D
geometryType: esriGeometryEnvelope
inSR: 102100
outFields: OBJECTID%2CSHAPE_Length%2CSHAPE_Area%2CAFFGEOID%2CGEOID%2CSTATEFP%2CCOUNTYFP%2CTRACTCE%2CNAME%2CNAMELSAD%2CSTUSPS%2CNAMELSADCO%2CSTATE_NAME%2CALAND%2CAWATER%2CPOP2020%2CPOPDEN2020%2CVOTEAGE_PCT%2CVOTEAGE_TOT%2CGQ_PCT%2CGQ_TOT%2CGQ_IN_PCT%2CGQ_IN_TOT%2CGQ_NON_PCT%2CGQ_NON_TOT%2CWHITE_PCT%2CWHITE_TOT%2CBLACK_PCT%2CBLACK_TOT%2CAIAN_PCT%2CAIAN_TOT%2CASIAN_PCT%2CASIAN_TOT%2CNHOPI_PCT%2CNHOPI_TOT%2CSORACE_PCT%2CSORACE_TOT%2CTWORACE_PCT%2CTWORACE_TOT%2CWHITE_C_PCT%2CWHITE_C_TOT%2CBLACK_C_PCT%2CBLACK_C_TOT%2CAIAN_C_PCT%2CAIAN_C_TOT%2CASIAN_C_PCT%2CASIAN_C_TOT%2CNHOPI_C_PCT%2CNHOPI_C_TOT%2CSORACE_C_PCT%2CSORACE_C_TOT%2CHISPLAT_PCT%2CHISPLAT_TOT%2CNOHISPLAT_PCT%2CNOHISPLAT_TOT%2CHU_TOT%2CHUOCCUPIED_TOT%2CHUOCCUPIED_PCT%2CAREALAND_SQMI
outSR: 102100

but you can throw different queries at it based on what i'm seeing here Query (Map Service/Layer)—ArcGIS REST APIs | ArcGIS Developers

as an example, i tried this and it seemed to pull back a list of IDs or coordinates for what i assume are each tract in the state: mtgis-server.geo.census.gov/arcgis/rest/services/PL_Press_Release_2020/PopDen/MapServer/15/query?where=STATE_NAME='Georgia'&f=json

Yeah I got about as far as that using Firefox dev tools earlier today but then I had to do other things. Using the returned json, should be straightforward to make a table of census tract number / center/ density and then it'd just a matter of cutting on 20k and counting.

[mhays]

Originally Posted by dave8721

I did Miami/South Florida which was a pain since there are 10k census tracts extending 70+ miles from the core so finding the 20k ones wasn't easy with those awful colors on the census map.

Combining with previous posts:
Los Angeles: 1,832,775
Chicago: 1,236,115
Miami/Ft.Lauderdale: 368,418
Seattle: 156,537
Twin Cities - 51,643
Milwaukee - 41,037
Madison - 35,514
Columbus - 31,592
Champaign - 22,271

Filling in a few more for tracts over 20,000:
Houston: 81,279
Denver/Boulder: 52,256
Portland: 38,057

[ChiSoxRox]

Originally Posted by dave8721

If you know the fips code for your state and County you can do it. This query for example returns the 20k+ population density tracts in Florida (12) and Miami-Dade County (086):
https://mtgis-server.geo.census.gov/...Geometry=true&

I'm compiling NYC right now. Should have the value within 15 minutes

[craigs]

Okay, so far:

Total MSA population living in Census tracts with population densities of 20,000+ ppsm:

New York: (TBD)
Los Angeles: 1,832,775
Chicago: 1,236,115
Miami: 368,418
Seattle: 156,537
Houston: 81,279
Denver: 52,256
Minneapolis: 51,643
Milwaukee: 41,037
Portland: 38,057
Madison: 35,514
Columbus: 31,592
Champaign: 22,271

Thanks to everyone crunching the numbers!

[dave8721]

Originally Posted by craigs

Okay, so far:

Total MSA population living in Census tracts with population densities of 20,000+ ppsm:

New York: (TBD)
Los Angeles: 1,832,775
Chicago: 1,236,115
Miami: 368,418
Seattle: 156,537
Houston: 81,279
Denver: 52,256
Minneapolis: 51,643
Milwaukee: 41,037
Portland: 38,057
Madison: 35,514
Columbus: 31,592
Champaign: 22,271

Thanks to everyone crunching the numbers!

A couple more easy ones:
Orlando: 0
Jacksonville: 0
Tampa: 2662

[ChiSoxRox]

It's here.

• Video Link

New York MSA - 9,151,543

New York State - 7,939,713
New York City - 7,728,457
New Jersey - 1,211,830
(Pike, PA - 0)

729 tracts alone in Brooklyn.

What a monster.

[iheartthed]

Originally Posted by ChiSoxRox

It's here.

New York MSA - 9,151,543

New York State - 7,939,713
New York City - 7,728,457
New Jersey - 1,211,830
(Pike, PA - 0)

729 tracts alone in Brooklyn.

What a monster.

So, almost half of the people residing in the New York MSA live in densities of +20,000 ppsm. Obviously, that's the highest ratio. It looks like Chicago might have the second highest ratio? Has the Bay Area been done yet? That's probably the only potential rival to Chicago's ratio.

[ChiSoxRox]

While at it, checking MSAs compiled so far:

Los Angeles: 1,919,006
Chicago: 1,238,801
Miami: 396,021
Seattle: 160,101
Houston: 88,080

[craigs]

Updated with Tampa, Sacramento, San Diego, New York:

Total MSA population living in Census tracts with population densities of 20,000+ ppsm:

New York: 9,151,543
Los Angeles: 1,832,775
Chicago: 1,236,115
Miami: 368,418
Seattle: 156,537
San Diego: 97,708
Houston: 81,279
Denver: 52,256
Minneapolis: 51,643
Milwaukee: 41,037
Portland: 38,057
Madison: 35,514
Columbus: 31,592
Champaign: 22,271
Sacramento: 7,761
Tampa: 2,662

[dave8721]

Using the query below I found some tracts i missed and updated Miami to:
395,991


New York: 9,151,543
Los Angeles: 1,832,775
Chicago: 1,236,115
Miami: 395,991
Seattle: 156,537
San Diego: 97,708
Houston: 81,279
Denver: 52,256
Minneapolis: 51,643
Milwaukee: 41,037
Portland: 38,057
Madison: 35,514
Columbus: 31,592
Champaign: 22,271
Tampa: 2,662

[SIGSEGV]

Originally Posted by ChiSoxRox

I'm compiling NYC right now. Should have the value within 15 minutes

Annoyingly it will only return up to 1000 values, which means you can't just do all of New York state in one fell swoop, but you can do Illinois:

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

[ChiSoxRox]

Fully updated, corrected against the query tool:

New York: 9,151,543
Los Angeles: 1,919,006
Chicago: 1,238,801
Miami: 396,021
Seattle: 160,101
San Diego: 103,421
Houston: 88,080
Minneapolis: 52,998
Denver: 49,423
Milwaukee: 47,988
Portland: 38,057
Madison: 35,514
Columbus: 31,592

(Using MSA defs for consistency, sorry Boulder)

[dave8721]

7,903 for New Orleans (i only checked Jefferson and Orleans parrishes).

[craigs]

Originally Posted by ChiSoxRox

While at it, checking MSAs compiled so far:

Los Angeles: 1,919,006
Chicago: 1,238,801
Miami: 396,021
Seattle: 160,101
Houston: 88,080

I'm confused, how did you get these figures?

[sopas ej]

Originally Posted by craigs

Updated with Tampa, Sacramento, San Diego, New York:

Total MSA population living in Census tracts with population densities of 20,000+ ppsm:

New York: 9,151,543
Los Angeles: 1,832,775
Chicago: 1,236,115
Miami: 368,418
Seattle: 156,537
San Diego: 97,708
Houston: 81,279
Denver: 52,256
Minneapolis: 51,643
Milwaukee: 41,037
Portland: 38,057
Madison: 35,514
Columbus: 31,592
Champaign: 22,271
Sacramento: 7,761
Tampa: 2,662

Surprised San Francisco isn't included... is it posted somewhere else in this thread? I must've missed it... (I'm at work right now and I'm not really working, but trying to look like I am, so I can't be looking at this website too carefully... it's one of those days at work where I've had it and I'm just gonna fake it til I make it).

[craigs]

Originally Posted by sopas ej

Surprised San Francisco isn't included... is it posted somewhere else in this thread? I must've missed it... (I'm at work right now and I'm not really working, but trying to look like I am, so I can't be looking at this website too carefully... it's one of those days at work where I've had it and I'm just gonna fake it til I make it).

Hey, I did San Diego, Sacramento, and the beast that is LA (and apparently I may have missed some tracts if the query tool data is correct). It took hours. Somebody else can do the San Francisco MSA!

[ChiSoxRox]

Originally Posted by craigs

I'm confused, how did you get these figures?

Using the query tool linked above, here is LA County for example.

Pop into notepad, strip off the POP2020 string, pop into Excel, sum.

Unfortunately, we must have missed a few tracts.