The YouTube channel Not Just Bikes [1] explores this in a short series [2]. I'm not very knowledgeable in this area, but what he discusses rings true for my city at least.
[1]: https://www.youtube.com/c/NotJustBikes [2]: https://www.youtube.com/playlist?list=PLJp5q-R0lZ0_FCUbeVWK6...