The Problem • A “twenty-something” couple are moving from Boston to Pittsburgh • Where should they live?
About the Couple • They are pretty typical twenty-somethings • He will be attending the University of Pittsburgh’s School of Pharmacy • She works in fundraising • They like being outdoors (biking, hiking, swimming, etc.) • They are excited to own a place and live in a neighborhood
Their neighborhood wish list • Close to Oakland • Single family housing less than $150,000 • Safe • Young (for Pittsburgh) • Urban area - able to walk or bike to shops and restaurants • Near a park Not very specific…
Broke region into census tracts Defined “close to Oakland” as 5 mile radius from Pitt’s School of Pharmacy Criterion 1: Close to Oakland
Criterion 2: Homes <$150,000 • Used median house value data from 2000 Census • Need to factor in appreciation over past seven years • NAR data provides average metro area appreciation from 2000 to 2006: 24.5%
Criterion 3: Safety • Desire to live in a “relatively safe” neighborhood • Defined “relatively safe” as the 50% of tracts in target area with the lowest violent crime rates • Information was only available by neighborhoods and municipalities, not census tracts • Violent crime rate was applied to all tracts within a given neighborhood or municipality
Criterion 4: Younger neighborhood • Approximately 23.9% of all Americans are 22-39 (2005 American Community Survey) • Half of tracts of interest have more than 25.40% of population aged 22-39 • Using Median Age • Skews neighborhoods close to universities • Rachel would like to live in a neighborhood, not a transient college area
Criterion 5: Mixed-use Area • Walkability • Multiple restaurants, bars, shops • Data very hard to find • Found a site that listed ~1400 bars and restaurants in Allegheny County • Resulted in 648 bars and restaurants for tracts within 5 miles of School of Pharmacy