CityofToronto / bdit_congestion

Determining most congested streets and days in Toronto
https://github.com/orgs/CityofToronto/teams/bigdatainnovationteam
GNU General Public License v3.0
0 stars 0 forks source link

Create table of all intersections representing links to pairs of streets, both at minor arterial or above #39

Open aharpalaniTO opened 4 years ago

chmnata commented 4 years ago

All segments from intersection to intersection: congestion.route_int2int3 contains routed segments and congestion.route_int2int2_missing(segments that can't be routed e.g. streetcar island, ramps)

Tables containing merged results: 1st merge: congestion.mergedshort_result1_v2 2nd merge: congestion.mergedshort_result2_v2 3rd merge: congestion.mergedshort_result3_v2 4th merge: congestion.mergedshort_result4_v2

Tables containing partitioned segments: partitioned_segments_v2: resulted from greedy 200m partitioning