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.
software | version |
---|---|
postgresql | 9.6.3 |
postgis | 2.3.2 |
pgrouting | 2.4.1 |
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