Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 21952

consist of finding optimal paths along geographic networks such as roads or trail systems.

1 vote

ST_Intersects returning incorrect result on routing problem?

I seemed to have solved the problem by taking this approach: 1) perform create table highwaysinglegeom as select st_union(the_geom) from analysis.po_highway 2) perform the update query above using t …
EconGeo's user avatar
  • 311
1 vote
1 answer
166 views

ST_Intersects returning incorrect result on routing problem?

I have a table that contains the shortest path between destinations for survey respondents on an osm2po created network. When calculating the shortest path result, I store the geometry in a column. …
EconGeo's user avatar
  • 311
2 votes
2 answers
506 views

problem transforming pgr route to a line - unexpected extra lines from St_MakeLine

I have created a line geometry from a pgr_dijkstra querry and I am getting an unexpected looking line in qgis. The following image illustrates the problem: The magenta line is the line created fro …
EconGeo's user avatar
  • 311
3 votes
2 answers
1k views

adding geometries to a source, target table for multiple rows in pgrouting

I am having an issue trying to perform the pgr_dijkstra algorithm and getting back a line in my table for multiple rows. I have a table that has a columns of source, target node id's but I cannot fig …
EconGeo's user avatar
  • 311
1 vote

adding geometries to a source, target table for multiple rows in pgrouting

I have solved the problem with the simple querry update analysis.routing set routeline = (select st_makeline(pgr.geom) , from (select * from pgr_dijkstra('ways',source,target)) as pgr)
EconGeo's user avatar
  • 311