CityofToronto / bdit_volumes

Traffic Volumes Modelling Project
7 stars 6 forks source link

Centreline Grouping: new directional bin matching logic for like segments #72

Open aharpalaniTO opened 6 years ago

aharpalaniTO commented 6 years ago

Query find_same_volume_segments.sql for creating truth table for segments that should be grouped will not work properly for corridors which straddle the NW or SE azimuth.

Current logic dictates that two segments that are to be considered for grouping must have identical directional bins (i.e. cl1.dir_bin = cl2.dir_bin). This is usually true, but not always.

Possible approach may be to leverage intersecting node instead.