Greetings Chuck-

You continue to be an amazing resource. Are you ever going to retire…completely?

Thank you for the LODE/LEHD analysis tools.

559/224-7388: Landline (not answered unless I know the number)

559/355-1678: cell

Due to the current health emergency, Caltrans' Planning & Local Assistance staff are working remotely whenever possible. While there may be some delay in our response times, we continue to be available via email and remain committed to customer service.

From: Charles Purvis <clpurvis@att.net>
Sent: Wednesday, May 17, 2023 2:45 PM
To: The Census Transportation Products Program Community of Practice/Users discussion and news list <ctpp@listserv.transportation.org>
Subject: [CTPP News] Updated R package lehdr released May 14th, for LODES/LEHD analysis

EXTERNAL EMAIL. Links/attachments may not be safe.

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_2020.R

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