CTPP

ctpp@listserv.transportation.org

3041 discussions

FW: Spring 2023 CTPP Newsletter

by Rob Schiffer

(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]

10 months, 3 weeks

Call for CTPP users to Beta test the new web-based GUI!

by Colby Brown

Hello all, We're excited to formally announce that a new version of the web based CTPP data access user interface is available for Beta testing. If you're interested in joining our Beta testing group, please sign up here: https://forms.office.com/r/fBPwnrnG62 This is a great opportunity to try out the latest features and improvements before anyone else and help us improve access to CTPP data—don't miss this chance! Thank you, Colby Brown Founding Principal and CEO [cid:43146d89-4c95-44b9-a55c-b2a59ba00168]<http://manhan.co/> https://manhan.co<https://manhan.co/> +1 (413) 282-8629<http://voice.google.com/calls?a=nc,%2B14132828629> Mastodon<https://transportation.social/web/@colby> | LinkedIn<https://www.linkedin.com/in/colbymbrown/> | Calendly<https://calendly.com/manhangroup/45min> pronouns: he/him

11 months

FW: Datapalooza! Call for content! Please distribute!

by Penelope Weinberger

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

11 months, 1 week

Obtaining Census Population Estimates using the R package tidycensus

by Charles Purvis

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

11 months, 2 weeks

Comparison maps for San Francisco City: Population Density (PL94171) and Job Density(LEHD)

by Charles Purvis

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

11 months, 3 weeks

Updated R package lehdr released May 14th, for LODES/LEHD analysis

by Charles Purvis

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/#lodes https://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 ###

11 months, 3 weeks

by Penelope Weinberger

From: NASEM Division of Behavioral and Social Sciences and Education <NASEM_DBASSE(a)nas.edu<mailto:NASEM_DBASSE@nas.edu>> Sent: Monday, April 17, 2023 10:00 AM Subject: Register Now! Public Webinar: Enhancing Survey Programs by Using Multiple Data Sources Join us Monday April 24th for the spring CNSTAT webinar. View this email in your browser<https://mailchi.mp/nas/cnstat-seminar-using-multiple-data-sources-data-infr…> [National Academies of Sciences, Engineering, and Medicine] Committee on National Statistics PUBLIC WEBINAR Enhancing Survey Programs by Using Multiple Data Sources [https://mcusercontent.com/86e1b30d7b026cdd15adc841f/images/c2d86045-6596-7a…] Monday, April 24, 2023 3:00 p.m. - 4:30 p.m. (EDT) REGISTER NOW<https://nationalacademies.us8.list-manage.com/track/click?u=86e1b30d7b026cd…> Join us for the Committee on National Statistics spring webinar focusing on the recently released report Toward a 21st Century National Data Infrastructure: Enhancing Survey Programs by Using Multiple Data Sources<https://nationalacademies.us8.list-manage.com/track/click?u=86e1b30d7b026cd…>. This is the second report in a series funded by the National Science Foundation. The report discusses how use of multiple data sources can improve the quality of national and subnational statistics while promoting data equity. It explores implications of combining survey data with other data sources through examples relating to the areas of income, health, crime, and agriculture. This is a completely virtual event. Agenda * Welcome, Introduction Melissa Chiu, Director, CNSTAT * Overview of Toward a 21st Century National Data Infrastructure: Enhancing Survey Program by Using Multiple Data Sources Sharon Lohr, Arizona State University (Emerita) * Using Multiple Data Sources to Enhance Data Equity Kimberlyn Leary, Harvard Medical School * Creating New Data Resources with Administrative Records David Mancuso, Washington State, Department of Social and Health Services * Q&A Melissa Chiu, Moderator You can learn more about the project and download the report here<https://nationalacademies.us8.list-manage.com/track/click?u=86e1b30d7b026cd…>. The Committee on National Statistics was established in 1972 at the National Academies of Sciences, Engineering, and Medicine to improve the statistical methods and information on which public policy decisions are based. The committee carries out studies, workshops, and other activities to foster better measures and fuller understanding of the economy, the environment, public health, crime, education, immigration, poverty, welfare, and other public policy issues. It also evaluates ongoing statistical programs and tracks the statistical policy and coordinating activities of the federal government, serving a unique role at the intersection of statistics and public policy. The committee's work is supported by a consortium of federal agencies through a National Science Foundation grant, a National Agricultural Statistics Service cooperative agreement, and several individual contracts. [https://mcusercontent.com/86e1b30d7b026cdd15adc841f/images/fd8ae7c4-a07c-e1…] FOLLOW US [Facebook]<https://nationalacademies.us8.list-manage.com/track/click?u=86e1b30d7b026cd…> [Twitter]<https://nationalacademies.us8.list-manage.com/track/click?u=86e1b30d7b026cd…> [LinkedIn]<https://nationalacademies.us8.list-manage.com/track/click?u=86e1b30d7b026cd…> [RSS]<https://nationalacademies.us8.list-manage.com/track/click?u=86e1b30d7b026cd…> [Website]<https://nationalacademies.us8.list-manage.com/track/click?u=86e1b30d7b026cd…> Copyright (c) 2023 National Academy of Sciences, All rights reserved. You are receiving this email because you signed up to receive emails from the Division of Behavioral and Social Sciences and Education of the National Academies of Sciences, Engineering, and Medicine. Our mailing address is: National Academy of Sciences Division of Behavioral and Social Sciences and Education 500 5th Street, NW Washington, DC 20001 Add us to your address book<https://nationalacademies.us8.list-manage.com/vcard?u=86e1b30d7b026cdd15adc…> Want to change how you receive these emails? You can update your preferences<https://nationalacademies.us8.list-manage.com/profile?u=86e1b30d7b026cdd15a…> or unsubscribe from this list<https://nationalacademies.us8.list-manage.com/unsubscribe?u=86e1b30d7b026cd…>. [Email Marketing Powered by Mailchimp]<http://www.mailchimp.com/email-referral/?utm_source=freemium_newsletter&utm…>

1 year

2020 LODES/LEHD dat (onTheMap) released April 4 2023

by Charles Purvis

OnTheMap Update and 2020 LODES Data <https://www.census.gov/newsroom/press-releases/2023/onthemap-2020-lodes-dat…> April 4 — The U.S. Census Bureau released an updated version of its Longitudinal Employer-Household Dynamics (LEHD) Origin-Destination Employment Statistics (LODES) <https://lehd.ces.census.gov/data/#lodes> data product. The 8.0 version of LODES add data for 2020 and recast all historical LODES years into 2020 census blocks. The OnTheMap <https://onthemap.ces.census.gov/> application is updated to include these new LODES tabulations that will contain 19 years of data from 2002 to 2020. https://lehd.ces.census.gov/data/#lodes Alas, the r-package “lehdr” needs to be updated by the package authors. They probably need to specify if you’re looking to use 2020 Census geography (LODES8) or older, 2010 Census geography (LODES7). The lehdr package works great with LODES7!!! (I tested my existing r scripts to use lehdr. It’s not working for year 2020, yet.) The lehdr package authors are aware of the issue and are on it.) This is like the old U2 song “I Still Haven’t Found What I’m Looking For” - - I’m trying to find the release schedule for the 2022 American Community Survey. The Census Bureau’s website can be a challenge! Chuck

1 year

Census Bureau Releases New Journey-to-Work Report

by Charles Purvis

APRIL 6, 2023 — The U.S. Census Bureau today released a report describing trends in working from home before and after the COVID-19 pandemic hit the United States in March 2020. The report, Home-Based Workers and the COVID-19 Pandemic <https://www.census.gov/library/publications/2023/acs/acs-52.html>, uses 2019 and 2021 American Community Survey (ACS) 1-year estimates to compare teleworking sociodemographic, geographic and occupational patterns the year before and after the pandemic’s onset. https://www.census.gov/newsroom/press-releases/2023/journey-to-work.html Census Bureau Releases New Journey-to-Work Report census.gov https://www.census.gov/library/publications/2023/acs/acs-52.html Home-Based Workers and the COVID-19 Pandemic census.gov Congratulations to the Census Bureau Journey-to-Work & Migration Statistics Branch!! Job well done!

1 year

RFP for Services to the CTPP program

by Penelope Weinberger

Dear colleagues, Attached please find a request for proposals for technical services for the CTPP program. Bidders may respond to any or all services outlined, proposals are due by April 20, 2023. The RFP can also be found at: https://ctpp.transportation.org/whats-new/ Penelope Weinberger Program Manager for Transportation Data, AASHTO Data.transportation.org

1 year, 1 month

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

1999

1998

CTPP