Wow that is complicated! Thanks for sharing, it's good to know how time consuming this could be if I take it further.

It sounds like Overpass is the way to get the data I need - once I figure out how to reference it in Overpass (network/relation details).