 He was elected and took office in January 2004 before being appointed City Council President in December 2005.After the death of Pittsburgh mayor Bob O'Connor, Ravenstahl became the mayor, per the city's charter, on September 1, 2006.He later won a special election in 2007, and a regular election in 2009.