Open aharpalaniTO opened 7 years ago
One idea: merge segments by corridor, and then re-split by streets >= collector roads.
This is complete. Logic for identifying whether two centreline_id
s share same profile implemented in Postgres; aggregate grouping of all segments implemented in Python. @aharpalaniTO to review later.
@sunnyqywang Some additional commenting in SQL script here on step-by-step process.
Will close issue after complete.
This involves some sort of GIS process for identifying segments that are split by non-road links, and therefore should have volume profiles that are identical or near-identical.
Ideally, this should implemented as a function in PostGIS with a call similar to the following: share_profile(_centreline_id1, _centreline_id2) returns (TRUE, FALSE) and then further scaled up to apply to all count data.
Alternative ideas or implementations welcome.