Data Analysis & Visualization
Change in commute patterns in Texas
I wanted to track how the state of Texas has been doing on returning to “normal” following the COVID-19 pandemic. Google’s Mobility data tracks the % change (relative to February 2020) to how often their users are going to residential areas, parks, grocery stores, and others. I was particularly interested in the “workplaces” category which should be a good indicator of how many workers are returning to office.
The return to the office hasn’t been even. The cities and the Permian Basin are lagging behind the more rural areas of the state.
Created with: Python + Geopandas
COVID-19 Mobility Impacts Dashboard
Starting in April 2020, I created a blogpost tracking the changes to Austin’s mobility caused by COVID-19. Using data sourced from the City’s open data portal, I created some live-updating charts showing vehicle volume, micromobility trips, and traffic incidents. About every month I create a full report showing trends in the data along with a few takeways of mine. Check out my archive of my thoughts & takeaways, too.
Created with: Google apps script, plotly studio
Austin MetroBike Trips Visualization
Using a tool called flowmap.blue I was able to quickly visualize multiple years of docked bicycle data. It is featured on flowmap.blue’s examples page.
Created with: Python, Google sheets
Video of @ATXMetroBike trips from 2015 to 2020. https://t.co/dcUSltaPG3 pic.twitter.com/UpxtwVJ4jV— Charlie Henry (@ShiftModal) May 25, 2021
Bluetooth Sensor Travel Times Performance and Visualization
The city of Austin publishes travel time data using bluetooth sensors. These are largely no longer maintained but some sensors are still operational. I was interested in how COVID-19 impacted travel times and congestion. Using methodology from the Federal Highway Administration, I calculated some performance measures for each segment.
Created with: Python, Mapbox GL JS
TxDOT Lufkin District ITS Projects Map
An interactive map with a Google Sheet backend that enables TxDOT to track their progress in implementing their district’s ITS plan.
Created with: Google Sheets, Mapbox GL JS
American Society Of Highway Engineers Central Texas Region July 2021 Meeting: Planes, Strains, and Automobiles - Presentation Slides
South by Southwest 2019 Lightning Talk: Unlocking the future of Transportation with Open Data
Open Austin July 2020 Meeting: Measuring COVID-19 Update - Presentation slides
Saving Lives with Connected Vehicle Data: Link to webinar recording