Here is a rather nice document that gives you an idea of the type of thinking that goes into bike facilities in Pittsburgh-- an old city with minimal resources that I would categorize as marginally bike-friendly.
http://www.city.pittsburgh.pa.us/cp/...l_document.pdf
The guidelines are quite sensible. I think they intelligently address some of the shortcomings mentioned here.
Opinions?