This project is used to navigation with postgis and pgrouting in postgresql. You can create a function with this in postgresql.

This time,it can complete one-way navigation.

Install postgis and pgrouting extension

add pgr_fromatob function to your database

SQL Usage:

SELECT ST_AsGeoJson(pgr_fromatob) AS geojson FROM pgr_fromAtoB('102.73590087890626', '36.13787471840729', '103.06686401367188','36.13787471840729','line_guide',true,'geom');

SELECT ST_AsGeoJson(pgr_fromatob) AS geojson FROM pgr_fromAtoB('102.73590087890626', '36.13787471840729', '103.06686401367188','36.13787471840729');

• First Version

• reconstruction code
• allow mutilinestring as result,so the path is more accurate
• change function pgr_kdijkstraPath to function pgr_dijkstra
• set pgr_dijkstra only for directed
• fixed un-directed problem
• fixed on path sub problem

• function add default parm
• function add some parms
• add prepare line of start and end line to result

• Email:itas109@qq.com
• QQ Group:129518033

• itas109 Blog

• http://blog.csdn.net/longshengguoji/article/details/46793111