Projects

Pedestrian Activity & San Francisco's Hills

Fall 2022
Future Mobility Workshop
Columbia GSAPP
Prof. Anthony Vanky

Team:
Kirthi Balakrishnan,
Lizzie Lee

Do San Francisco's steep blocks (≥20% grade) actually keep people from walking through them? AOMA trip data says yes — pedestrian trips drop 60% above 20% grade even where transit is right there.

Scroll
01

Research Question

Method
AOMA trip data
Terrain analysis
Spatial correlation

San Francisco has hills — specifically, blocks with slopes of 20% or greater, which the city's planning department calls "significant." We wanted to know whether those slopes actually change how people walk, or whether transit access is doing all the work.

The test set: AOMA trip data (Activity-Oriented Mobile Application), cleaned in Python and joined against terrain slope rasters. Visualized in Kepler.gl.

02

Data Cleaning

Before and after processing the AOMA trip dataset
Raw AOMA trip data before cleaning — noisy GPS traces across San Francisco
RAW DATA
Before cleaning — noisy GPS traces with vehicle and transit trips mixed in.
Cleaned AOMA trip data showing pedestrian activity patterns
PROCESSED
After cleaning — pedestrian-only trips. The gaps where the hills are show up clearly.
03

Analysis

Kirthi Balakrishnan & Lizzie Lee

Instructor: Professor Anthony Vanky