The next several months should keep census data analysts quite busy.
https://www.census.gov/newsroom.html
New decennial census (2020) products will include:
Thursday, August 31, 2023: DHC file for 118th Congressional Districts; Current State houses. This will be the first Census 2020 data products using the new congressional district boundaries based on Census 2020, and as used in the November 2022 general election. This will include summary levels at the new state house and state senates for all states.
Thursday, September 21, 2023: DHC-A file with the detailed race-ethnicity groups.
https://www.census.gov/newsroom/press-releases/2023/2020-census-detailed-dh…
New American Community Survey data products including 2022 data will include:
Thursday, September 14, 2023: 1-year Data Release (2022)
Thursday, October 19, 2023: 1-year Public Use Microdata Sample (2022)
Thursday, December 7, 2023: 5-year Data Release(2018-2022)
Thursday, January 25, 2024: 5-year Public Use Microdata Sample (2018-2022)
https://www.census.gov/programs-surveys/acs/news/data-releases/2022/release…
My guess is that these data will be readily accessible via data.census.gov <http://data.census.gov/> and the census bureau’s API structure. I will probably be using the tidycensus, tidyverse, ggplot2 R packages to retrieve, reduce, report, chart and map results.
Hope this helps:
Chuck Purvis
retired person,
Hayward California
This may be of interest to some.
-------- Forwarded Message --------
Subject: Participants Needed for Research Study - CEDSCI study
Date: 15 Aug 2023 18:34:11 +0000
From: American Community Survey Data Users Group <noreply(a)prb.org>
To: Ed Christopher <edc(a)berwyned.com>
[Population Reference Bureau] Update from American Community Survey
Data Users Group
<https://acsdatacommunity.prb.org/>
<https://acsdatacommunity.prb.org/members/gretchen.gooding> Gretchen
Gooding <https://acsdatacommunity.prb.org/members/gretchen.gooding>
CEDSCI, with the assistance of RTI International, is conducting research
to improve the data dissemination website data.census.gov. Each
participant will receive $40 for participating in the study. (Federal
employees are not eligible to receive the $40.)
We would like to talk with people who meet one or more of the following
criteria:
* Have any experience downloading and using datasets data.
* Have recent experience in using datasets provided by the U.S. Census
Bureau.
* Use data from data.census.gov or other statistical sites (e.g.,
demographic/economic data) for research or decision-making.
If you know anyone who meets ANY of these criteria, we would appreciate
it if you let them know of this research opportunity.
The study session will last approximately 60 minutes and will take place
virtually using Microsoft Teams to video conference with RTI staff. The
study began on August 14, 2023, and concludes on September 8, 2023.
While current federal employees are allowed to participate in off-duty
time, they are not eligible to receive the incentive payment.
Please have interested participants complete a short questionnaire at
https://research.rm.census.gov/jfe/form/SV_3vGixRNbURopVf8
<https://research.rm.census.gov/jfe/form/SV_3vGixRNbURopVf8>or contact
Patrick Hsieh at 312-777-5234 or yph(a)rti.org <mailto:yph@rti.org>for
further information. Please mention the code Data Website when you call
or email.
View online
<https://acsdatacommunity.prb.org/discussion-forum/f/forum/1267/participants…>
You received this notification because you subscribed to the forum. To
stop receiving updates from only this thread, go here
<https://acsdatacommunity.prb.org/discussion-forum/f/forum/1267/participants…>.
Flag
<https://acsdatacommunity.prb.org/discussion-forum/f/forum/1267/participants…> this
post as spam/abuse.
We are excited to announce the following:
AED20(1) Census Data for Transportation Planning Subcommittee
of the Urban Transportation Data and Information Systems Committee
is seeking submissions for
a 2024 TRB Annual Meeting poster session on
Census Data Time Series: Investigating changes in population, households, and behavior over time
Poster session details and information on how to submit your abstract are included in the attached Call for Posters. We look forward to your submissions.
Regards,
Kathy Yu and Kyla Elzinga
AED20(1) Census Data for Transportation Planning Subcommittee
https://ctpp.transportation.org/trb-aed201/
The Spring 2023 ACTS Status Report (AKA CTPP Newsletter) is now available online as well. The live URL is:
https://www.fhwa.dot.gov/planning/census_issues/ctpp/status_report/
(Please note that web browsers cache most page content. If you're still seeing your old content, press Ctrl+F5 (Internet Explorer) or Shift+F5 (Chrome, Firefox) to force a reload.)
From: Rob Schiffer
Sent: Thursday, June 8, 2023 9:58 PM
To: The Census Transportation Products Program Community of Practice/Users discussion and news list <ctpp(a)listserv.transportation.org>
Subject: Spring 2023 CTPP Newsletter
It's been a long time coming but attached to this email is the Spring 2023 CTPP Newsletter. In case you were not aware, rebranding of all AASHTO products has resulted in a new name... CTPP will now be known as AASHTO Census Transportation Solutions, or ACTS! Future products and publications will feature the new name as well.
[A picture containing text, font, logo, graphics Description automatically generated]
Should this newsletter inspire you to write an article about your use of CTPP/ACTS for our Summer 2023 Newsletter, please submit an article for potential publication to this email address. Happy reading!
-Rob
Robert G. Schiffer, AICP
National Practice Leader, Travel Demand Forecasting
[cid:image003.png@01D99F97.82985640]<https://metroanalytics.com/>
[cid:image004.png@01D99F97.82985640]
+1 850-570-8958
[cid:image005.png@01D99F97.82985640]
rob(a)metroanalytics.com<mailto:rob@metroanalytics.com>
[cid:image006.png@01D99F97.82985640]
www.metroanalytics.com<https://metroanalytics.com/>
[Facebook]<https://www.facebook.com/Metro-Analytics-101572229079920>
[Twitter]<https://twitter.com/metroanalytics>
[Instagram]<https://www.instagram.com/metroanalytics/>
[LinkedIn]<https://www.linkedin.com/company/metro-analytics>
Robert G. Schiffer, AICP
President, FuturePlan Consulting, LLC
1256 Walden Road | Tallahassee, FL 32317
850-570-8958 | 850-877-1995
rob.schiffer(a)futureplan.us<mailto:rob.schiffer@futureplan.us>
https://futureplan.us/
[Logo Description automatically generated]
-Rob
(It appears that this message was not sent out last week so I'm resending it from my other email address...)
It's been a long time coming but attached to this email is the Spring 2023 CTPP Newsletter. In case you were not aware, rebranding of all AASHTO products has resulted in a new name... CTPP will now be known as AASHTO Census Transportation Solutions, or ACTS! Future products and publications will feature the new name as well.
[A picture containing text, font, logo, graphics Description automatically generated]
Should this newsletter inspire you to write an article about your use of CTPP/ACTS for our Summer 2023 Newsletter, please submit an article for potential publication to this email address. Happy reading!
-Rob
Robert G. Schiffer, AICP
National Practice Leader, Travel Demand Forecasting
[cid:image003.png@01D99A54.3BB8FDD0]<https://metroanalytics.com/>
[cid:image004.png@01D99A54.3BB8FDD0]
+1 850-570-8958
[cid:image005.png@01D99A54.3BB8FDD0]
rob(a)metroanalytics.com<mailto:rob@metroanalytics.com>
[cid:image006.png@01D99A54.3BB8FDD0]
www.metroanalytics.com<https://metroanalytics.com/>
[Facebook]<https://www.facebook.com/Metro-Analytics-101572229079920>
[Twitter]<https://twitter.com/metroanalytics>
[Instagram]<https://www.instagram.com/metroanalytics/>
[LinkedIn]<https://www.linkedin.com/company/metro-analytics>
Robert G. Schiffer, AICP
President, FuturePlan Consulting, LLC
1256 Walden Road | Tallahassee, FL 32317
850-570-8958 | 850-877-1995
rob.schiffer(a)futureplan.us<mailto:rob.schiffer@futureplan.us>
https://futureplan.us/
[Logo Description automatically generated]
Hello CTPP Fam,
This is a little outside our regular types of emails, but perhaps you or someone in your organization has something to share.
Are you working on a data project that's neat, cool, or keen; one that has you excited and makes you glow with pride? Perhaps someone in your DOT or organization is.
Showcase this project at the AASHTO Committee on Data Management and Analytics Datapalooza!
Datapalooza is a two day remote/virtual event August 22 and 23, 2023.
We are seeking Innovative, Collaborative, Educational (ICE) content to cool us off in the heat of August.
Send us a description of your:
* Demonstration Projects
* Analytics Projects
* Rapid Innovation Projects
* Any other super interesting projects!
Please use the link below to submit an abstract by June 2nd
https://www.surveymonkey.com/r/DatapaloozaContent
Penelope Weinberger
Program Manager for Transportation Data,
AASHTO
Data.transportation.org
I’m forwarding a “toot” (Mastodon equivalent of a tweet) regarding an updated version of the r package tidycensus.
All of the hub bub in the current news is about the new vintage 2022 population estimates released by the Census Bureau this past Thursday, May 18th. Lots of interesting stories are being told!!
I tested tidycensus for California and US states, counties, and places, and it works great. It’s a little awkward since you need to split your analysis into the 2010-2019 period from the 2020-2022 period (i.e., can’t get 2019 thru 2022 in one call!)
My tidycensus population estimates r script is available here:
https://github.com/chuckpurvis/r_scripts/blob/main/popestimates_calif_01.R
###########
UPCOMING:
The “SF1” equivalent to Census 2020 is embargoed right now (media has access to the data; public, doesn’t) and will be released this Thursday, May 25th. This is the “DHC” "Demographic and Housing Characteristics” file. My expectation is that Professor Walker will have updated tidycensus to read DHC by the end of my morning coffee on Thursday.
###########
“A brand-new version of the #rstats tidycensus package is now on CRAN, supporting the brand-new 2022 Population Estimates (which you can't get from the API). Download the new version today and start making charts like this!” - author Kyle Walker
https://walker-data.com/tidycensus

Attached are two maps created using the R package ggplot2. The data is from Census 2020, PL 94-171 for population density (persons per square mile) and the Census Bureau’s LEHD/LODES estimates for 2020 (total jobs per square mile).
My six “density categories” are defined as follows:
dplyr::mutate(density_grp = case_when(
jobs_per_sqmi < 500 ~ "1.rural",
jobs_per_sqmi < 1000 ~ "2.rural-suburb",
jobs_per_sqmi < 6000 ~ "3.suburb-disperse",
jobs_per_sqmi < 10000 ~ "4.suburb-dense",
jobs_per_sqmi < 20000 ~ "5.urban",
jobs_per_sqmi >= 20000 ~ "6.urban core",
TRUE ~ "0.missing data”))
“Mutate” sounds horrible, but it’s just the “dplyr” verb for “create a new variable”. (“dplyr” is a very handy-dandy R package).
Certain block groups in the City of San Francisco have “rural” population density. These are our parks: Golden Gate Park, Lincoln Park, McLaren Park. The Presidio might be categorized as a “dispersed suburb”. Most block groups in San Francisco are “urban core” (greater than 20,000 persons per square mile).
Some block groups in downtown San Francisco are not that heavily populated, such as the Financial District and Union Square areas. (Of course, vast overwhelming anecdotal evidence suggests that downtown San Francisco is a ghost town due to the pandemic. Ain’t necessarily true, of course.)
But the San Francisco financial district could not be considered a “suburb” by any stretch of the imagination. This is why we should also review data on jobs per square mile (job density) as a counter measure to simple population density.
My resulting hybrid measure would use the maximum value of population density (total population per square mile) and job density (jobs per square mile) in determining if a neighborhood is rural, suburban, or urban. I would use the same density ranges as shown above.
I could use a compound density measure (e.g., (population + jobs) / land area), but I’m satisfied with using the maximum of population OR jobs to typify a neighborhood.
(Our San Francisco financial district block group - tract 117.00, block group #3 - bounded by Bush-Kearny-Sacramento-Drumm-Market, is 0.07984 square miles, with a population of 442 and a job base of 49,634 employees, for a population density of 5,535 persons per square mile and a job density of 621,613 jobs per square mile. Yes, over 600,000 jobs per square mile!!)
Hope this is of interest.
Chuck Purvis,
Hayward, California
The R package “lehdr” created by Professor Jamaal Green at Penn (and others) was updated on 5/14/2023 to include year 2020 data from the Census Bureau. Yay!!
This is a great way to acquire (free) data on workers-at-block (block group, tract, county, state) of residence and of workplace. The user can then link the data with census GIS files using the R program “tigris” and map and display all sorts of data.
The LEHD/LODES data also has origin-destination “flows” (block-to-block, block group-to-block group, tract-to-tract, county-to-county, state-to-state).
My r script using lehdr and tigris for California is free to share, here:
https://github.com/chuckpurvis/r_scripts/blob/main/lehdr_California_2020.R
My r script for using tidycensus to map population density (Census 2020, PL 94-171) for the Bay Area and San Francisco City is here:
https://github.com/chuckpurvis/r_scripts/blob/main/PL94171_Calif_PopDensity…
The “lehdr” ( pronounced “lee-ter”) package is used to download and format data from the Census Bureau’s LEHD / LODES program.
## LED = Local Employment Dynamics
## LEHD = Longitudinal Employer Household Dynamics Program
## LODES = LEHD Origin-Destination Employment Statistics
## UI = Unemployment Insurance
## QCEW = Quarterly Census of Employment and Wages
## RAC = Residence Area Characteristics
## WAC = Workplace Area Characteristics
## CES = Center for Economic Studies, US Bureau of the Census
Documentation on LEHD/LODES is available from the Census Bureau here:
https://lehd.ces.census.gov/data/#lodeshttps://lehd.ces.census.gov/data/lodes/LODES8/LODESTechDoc8.0.pdf
Also of interest to MPOs and State DOTs will be the NCHRP report published 12 years ago (September 2011):
https://onlinepubs.trb.org/onlinepubs/nchrp/docs/NCHRP08-36(98)_FR.pdf
“Improving Employment Data for Transportation Planning”
Hope this is of interest!
Chuck Purvis
Hayward, California
###