Natalie

Decided just to re-route the Lakeshore segments, created materialized view that only has lakeshore and cherry st segments in `natalie.lakeshore_routing` ``` --re-route lakeshore segments with lookup as ( select analysis_id,...

> Decided just to re-route the Lakeshore segments, created materialized view that only has lakeshore and cherry st segments in `natalie.lakeshore_routing` > > ``` > --re-route lakeshore segments > with...

update `natalie.new_bluetooth_routes` with trimmed segment ``` update natalie.new_bluetooth_routes set geom = a.geom from (with closest as (select analysis_id, direction, ST_linelocatepoint(geom, ST_closestpoint(pt, geom)), geom from natalie.new_bluetooth_routes, (select ST_startpoint(geom) as pt from...

Because we are using undirected routing, the function does not take into account of street direction. Resulting in an Adelaide segment routed to Richmond. 

> Should've just created a materialized view with all centreline without Gardiner....created a table `natalie.new_bluetooth_routes` and inserted 6 new lakeshore segments Did that and created a materialized view `natalie.centreline_routing_undirected_bluetooth` without...

> Because we are using undirected routing, the function does not take into account of street direction. Resulting in an Adelaide segment routed to Richmond. >  another example at...

updated bloor and parliament's int id and re-routed again with the following, final table in `natalie.bluetooth_routed` ``` create table bluetooth_routed as with lookup as ( select analysis_id, from_id, from_intid as...

Steps to route bluetooth segments: 1) Prepare table with : - analysis_id (or any sets of unique identifier) - start centreline intersection - end centreline intersection - direction of the...

> > > `mohan.bt_segments_new` is created > > **Steps followed** > > 1. Tabulate all bluetooth nodes that are missing segments. > > 2. Used the same sql created earlier...

The segments in `mohan.bt_segments_newest` looks good! Can you post the sql in the comment?