Routing on centreline returns wonky results on one way streets

[radumas]

Thanks to @Nate-Wessel for pointing out this example in Queen's Park Crescent.

SELECT *
FROM gis_core.get_centreline_btwn_intersections(
     13466931, 13463747 -- northbound from adelaide to bloor routes the wrong way around queens park
    --13463747, 13466931 -- southbound from bloor to adelaide goes way off-course
)

Giving the wrong direction around the park

[radumas]

The problem lies in how gis_core.routing_centreline_directional is handling the one-way encoding

https://github.com/CityofToronto/bdit_data-sources/blob/51be37001abf4a829f53a27c4367263568707233/gis/centreline/sql/create_view_routing_centreline_directional.sql#L12-L31

One way streets can have their flow either with or against the direction of digitization (the from-to intersection nodes match the drawing order, so they must be reversed only if drawn against digitization).

[Nate-Wessel]

To be clear, @radumas whatever quick fix you applied has fixed this issue for me.

[radumas]

Thanks for confirming!