Indianapolis · Transportation Planning & Data

Hi, I'm Xi Guan.

I'm a transportation planner and data analyst in Indianapolis. I hold a Master of Regional Planning from Cornell.

At The Corradino Group I build GIS tools and travel demand models for statewide corridor and freight planning. Before that, I built paratransit data pipelines and dashboards as a Data Science Intern at New York's MTA, and researched walkability and pedestrian safety at Yale's Livable City Lab and Auburn's EcoTran Lab.

View projects ↓ Get in touch
GIS & Spatial Analysis
ArcGIS Pro ArcGIS Online Experience Builder ArcGIS Dashboards arcpy QGIS
Data & Visualization
Python R SQL Power BI Excel Adobe U.S. Census/ACS LEHD
Transportation Planning
TransCAD Travel Demand Modeling AADT Processing Active Transportation Planning
Xi Guan standing outdoors on a tree-lined path

Selected work

→ 01 / Spatial Access

The Shadow Cost Project

Drive-time isochrones around criminal legal service providers across six California counties, measuring who can physically reach a provider and who quietly falls outside the count.

R Census API Mapbox
→ 02 / Corridor Planning

200 Corridor Studies, One Script

Automating map production and public web-page delivery for INDOT's statewide corridor planning study — its most visualization-heavy deliverable.

arcpy ArcGIS API for Python Experience Builder
→ 03 / Safety Modeling

Whose Safety Perception Gets Lost at Scale?

What Complete Streets and Vision Zero prioritization risk when perception data is simulated instead of collected from residents.

Vision Zero Complete Streets Equity Analysis
→ 04 / Mobility Patterns

Does Walk Score Predict How People Walk?

A national comparison of Walk Score against observed walking behavior, then a block-by-block case study of underperforming walkable neighborhoods in Los Angeles.

R Walk Score Mobility Data