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

Project repo


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.

Link to the interactive

Created with: Python, Google sheets

Interactive Mapping

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

Project repo

Full Screen

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

Project repo

Full Screen


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