<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:12pt"><div id="yiv8090803121"><div><div style="background-color: rgb(255, 255, 255); font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><div id="yiv8090803121yui_3_13_0_1_1396824182071_23783" style="color: rgb(0, 0, 0); font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12pt;">Dear pgrouting users,</div><div id="yiv8090803121yui_3_13_0_1_1396824182071_23786" style="color: rgb(0, 0, 0); font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12pt;">I am begginer at using pgrouting and SQL as a whole, but this tool would be very useful for my projects. My task is to perform traffic assignment on the road network of Bulgaria. I use routable map prepared with
Osm2po. My start/end points are defined according to the map nodes. Using the code from the example </div><div id="yiv8090803121yui_3_13_0_1_1396824182071_23786" style="color: rgb(0, 0, 0); font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12pt;"><br></div><div id="yiv8090803121yui_3_13_0_1_1396824182071_23786"><div id="yiv8090803121yui_3_13_0_1_1396824182071_23786">SELECT seq, id1 AS node, id2 AS edge, cost FROM pgr_dijkstra('</div><div id="yiv8090803121yui_3_13_0_1_1396824182071_23786"> SELECT id,</div><div id="yiv8090803121yui_3_13_0_1_1396824182071_23786"> source,</div><div id="yiv8090803121yui_3_13_0_1_1396824182071_23786"> target,</div><div
id="yiv8090803121yui_3_13_0_1_1396824182071_23786"> cost</div><div id="yiv8090803121yui_3_13_0_1_1396824182071_23786"> FROM osm',</div><div id="yiv8090803121yui_3_13_0_1_1396824182071_23786"> 30, 60, false, false);</div><div id="yiv8090803121yui_3_13_0_1_1396824182071_23786"><br></div><div id="yiv8090803121yui_3_13_0_1_1396824182071_23786">how can I read my start/end points from another table and attach traffic value to the edges in new column?</div><div id="yiv8090803121yui_3_13_0_1_1396824182071_23786">Thanks in advance.</div><div id="yiv8090803121yui_3_13_0_1_1396824182071_23786"><br></div><div id="yiv8090803121yui_3_13_0_1_1396824182071_23786">Best regards</div><div id="yiv8090803121yui_3_13_0_1_1396824182071_23786">Lyubomir
Klyambarski</div></div></div></div></div></div></body></html>