Hello and happy new year CTPP!
It's the email you've all been waiting for! The CTPP 2012 to 2016 dataset was released in 2019 and you all have been working with it since. We are specifying the next special tabulation of census data. It will be based on the 2017 to 2021 ACS and now is your chance to tell us what you need. As you know, the 2012 to 2016 data was very pared down from the previous tab, we now have the opportunity to review if we lost critical tables and want to add them back, or if your analytical needs have changed to the point where you need new cross tabs to complete your varied mandates.
If you would like to suggest a table be added back or created anew, please
* reply to me directly pweinberger(a)aashto.org<mailto:firstname.lastname@example.org> or jzang(a)camsys.com<mailto:email@example.com> with your feedback, or
* reply directly to the list to stimulate discussion, or
* if you prefer anonymity, you can answer your questions here: https://tinyurl.com/CTPPFeedback<https://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fprotect-u…>
To download a current list of tables go to https://ctpp.transportation.org/2012-2016-5-year-ctpp/
And click: The specific data tabulations and available geographies can be found HERE<https://ctpp.transportation.org/wp-content/uploads/sites/57/2019/01/CTPP-ta…>.
CTPP Program Manager
Question: When will Census 2020 Geographies be available to use in GIS work?
Answer: February-March 2021, according to the PSAP website (as of 1/1/2021)
The PSAP is the Census Bureau’s Participant Statistical Areas Program (PSAP).
I’m not sure if that’s the current word from the Census Bureau on release. The state-level counts, which were due 12/31/2020, have yet to be delivered.
From the Census Bureau’s 12/30/2020 news release:
“The schedule for reporting this data is not static. Projected dates are fluid. We continue to process the data collected and plan to deliver a complete and accurate state population count for apportionment in early 2021, as close to the statutory deadline as possible.”
And there’s still the April 1, 2021 deadline for releasing the reapportionment file (the PL 94-171 file). No word if that date will slip as well.
Hopefully the GIS files will be available before April 1st to allow your GIS staff to hit the ground running with the new data.
The proposed 2020 census tracts, block groups, Census Designated Places, etc., are available on the Bureau’s TIGERweb site, here:
“The "Current" vintage reflects planned 2020 geographies for census tracts, census block groups, census designated places (CDPs), census county divisions (CCDs), tribal census tracts, tribal block groups, Alaska Native village statistical areas (ANVSAs), Oklahoma tribal statistical areas (OTSAs) and their tribal subdivisions, state American Indian Reservations (SAIRs), state designated tribal statistical areas (SDTSAs), and tribal designated statistical areas (TDSAs) as collected through the 2020 Participant Statistical Areas Program (PSAP). PSAP participants are reviewing and verifying these areas, and identifying corrections where needed, before they are used in the tabulation and publication of data.”
When I think of “vintage” I think of table wine… I guess if you’re a geographer “vintage” takes on a whole different meaning!
# # #
What is kind of cool on the PSAP page is the list of new proposed census designated places (CDPs) for the 2020 Census.
Some of my favorites:
Big Rock, Iowa (as well as Big Rocks in Tennessee and Virginia. Alas, no Big Rock Candy Mountain!)
Bug Tussle, Oklahoma
Candy Rock Kitchen, New Mexico
Centerville, Arkansas (not to be confused with Centervilles in Kansas, Louisiana and Montana!)
Dime Box, Texas
Dumb Hundred, Pennsylvania
Four Square Mile, Colorado
Knob Lick, Missouri
Pumpkin Center, California (and Pumpkin Hollow, Oklahoma!)
Volcano Golf Course, Hawaii
Alas, I still can’t find East Cupcake.
Happy New Years, and Stay Safe!
The Census Bureau released the newest 5-year set of American Community Survey data (2015-2019) just last month. This is important! We now have 3-sets of non-overlapping 5-year databases: 2005-2009, 2010-2014, and 2015-2019. I’ve been focusing on the 1-year databases up until now (2005-2019), but there are times when only the 5-year datasets will work (e.g., examining all counties within a particular state, region, or nation.)
My first attempt was to try a simple analysis of total population, household population, etc., for all places in California. The r-package “tidycensus” works great in extracting the 5-year ACS databases.
(By the way, the 2005-09 ACS does indeed have estimates for “total population” even though “group quarters” data was not collected in the year 2005. Somehow the Census Bureau used the 2006-09 data on GQ to make it up for 2005?)
I ran this for 2005-2009, 2010-2014, and 2015-2019. Then stitched them together creating a database of California places with lots of variables. Perfect!
Well, geographies change.
I then had an “ah ha!” moment: the 2005-2009 geographies are based on the 2000 Census; and the 2010-2014 and 2015-2019 geographies are based on the 2010 Census. There are new and re-named places (at least in the Bay Area and California) in the 2010 Census relative to the 2000 Census.
But this is not entirely accurate.
The geographies in each of the 5-year ACS databases may be different. They reflect the “last year” vintage of each database. I had to look this up on the Census Bureau’s website to clear things up!
So, for California:
2005-2009 ACS: 1,066 places in California
2010-2014 ACS: 1,543 places in California
2015-2019 ACS: 1,549 places in California
2010 Decennial Census SF1: 1,527 places in California.
My merged database of the three sets of ACS data plus the decennial yields 1,558 records. So, I still have some work to do to clean this up. (The decennial census is used to append a county code to place records. I still haven’t figure out how I want to handle multi-county places, but I’ll leave that for another time.)
Question: What is the vintage of the geography used in the 2015-2019 American Community Survey? 2015? 2019?
“For ACS 5-year estimates, use the last year of the estimate period to determine the vintage. For example, the following datasets use the same vintages of geographic boundaries:
2019 ACS 1-year estimates
2015-2019 ACS 5-year estimates”
I thought there was a list of “new places” in the 2019 ACS products. I can’t seem to find it now. Just another buried treasure on the Census Bureau website.
Happy New Years to All, and Stay Safe!