2017 DevFestMN Sara Robinson

on YouTube ↗42m

" summary

Analyzes 33 million trips using BigQuery + Cloud Storage, imports monthly CSVs via the REST API, and runs SQL to find 10,500 bikes in circulation, East 17th/Broadway as the busiest station (291k trips), and one bike with 5,594 trips; visualizes routes and an animated bike path in Carto and charts in Exploratory; queries GitHub: counts 275 million .js files and extracts package.json deps; flags a surprising Minneapolis ridership drop in 2016 for further investigation.

AI-written summary · about

" chapters (8)

1. 0:00Introduction
2. 3:54NYC bike share data
3. 9:10Importing to BigQuery
4. 16:01Analyzing trip patterns
5. 23:09Visualizing data
6. 28:58GitHub data at scale
7. 32:55Weather correlation
8. 36:34Q&A

" related talks

• 30mAnalyzing 33 million bike trips with BigQuerySara Robinson · NDC Oslo 2017
• 33mAnalyzing 33 million bike trips with BigQuerySara Robinson · NDC Sydney 2017
• 16mTidy Transit: Real Life Data Modeling for Public TransportationHunter Owens · rstudio::conf 2019
• 25mAtlas of Popular Transport: Democratizing mobility dataAlberto Meouchi · BUILD with Mapbox 2025
• 45mMining dockless bikeshare and dockless scootershare trip dataStefanie Brodie, Kiana Roshan Zamir · PyData DC 2018
• 10mSmart CommutingShiva Shivakumar · DLDcities SFO 2014
• 16mTidy Transit: Real Life Data Modeling for Public TransportationHunter Owens · rstudio::conf(2022)
• 10mCivic Hacking & Urban Informatics: Mapping Data with GeoPandasKatelyn Morrison · PyOhio 2020