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.
The episode that mentions the experience of walking 800m in Houston from a hotel to a shop reminds me of an experience where a group of us (drunken Europeans) were trying to get from a bar in one hotel to another bar in another hotel in that city... I'm surprised we weren't arrested.
[1]: https://www.youtube.com/c/NotJustBikes [2]: https://www.youtube.com/playlist?list=PLJp5q-R0lZ0_FCUbeVWK6...