pgRouting extends the PostGIS / PostgreSQL geospatial database to provide geospatial routing functionality.
1
vote
1answer
107 views
What is the difference between the astar_sp and shortest_path_astar functions?
I want to ask about what different of function :
"astar_sp" and "shortest_path_astar" ?
Do you think the query's result from both of them is same or different?
3
votes
1answer
487 views
How to get started with pgRouting and OSM?
I have followed these instructions to install postgresql and pgrouting on our ubuntu server:
...
0
votes
1answer
223 views
postgis problem with shortest distance calculation
while working with POSTGIS pgrouting, for calculateing the distance between two roads(lines) i got the shortest_path function.
But the logic is based on Start_point(Start_id) and end_point(end_id) ...
0
votes
2answers
107 views
dijkstra_sp runs without error in postgres query terminal, but triggers an error in Java
I am running this simple query
select id,gid from dijkstra_sp('roads',22,33)
This works perfectly fine and returns results in postgres query terminal. However running exactly the same query in java ...
1
vote
2answers
216 views
Routing issues with pgrouting
I was using the pgrouting plugin to display the shortestpath. I used the plugin as suggested by underdark to display the shortest path in qgis.
My source node is 283 and my target node is 172. When I ...
2
votes
1answer
268 views
Plot the nodes of the shortest path found by dijkstra algorithm
I am using qgis and pgrouting plugin to find the shortest path between two nodes and display the route. Currently, the plot shows the shortest path. However, I also want to know which nodes the path ...
1
vote
0answers
138 views
About the shortest path returned by pgrouting
I have a couple of questions related to the shortest path returned by pgrouting. I have this result for example.
edge_id cost reverse_cost x1 y1 x2 y2
1 ...
1
vote
1answer
249 views
How to get travel time and link used from osm2po http service
I used osm2po to get shortest paths but I would like to get travel time and osm links ids used in the path. Is it possible?
Here is the osm2po service url format I use (this is an example):
...
3
votes
1answer
79 views
How to check that a point is outside of a route?
I am newbie in PostGIS and also GIS particularly.
I need to check that a vehicle is outside of a route. This route has been defined in advance, and of course it stores in a table: RROUTEDETAIL. This ...
0
votes
2answers
139 views
how to build a routeable network for pgRouting with srid 3785
I'm following the pgrouting-workshop http://workshop.pgrouting.org/chapters/topology.html and It works, but in my project I'm working with the mercator projection(srid 3785) and there is not a routed ...
1
vote
1answer
101 views
postgresql pgrouting define C function function with int* arguments
I want to create a psql-C function with an undefined length list of integers (GIDs for example).
An erratic example using V0 function definition that works is like:
int mytest4(int *x, int i){
int ...
3
votes
1answer
263 views
How to create a QGIS road style for OSM data?
I am trying to use qgis to visualize the shortest path algorithm's result. I managed to import the osm map into qgis
But I think it looks kind of different. I was referring to this link and she ...
1
vote
0answers
85 views
Why are start and end segment not partially skipped?
Im using TRSP routing algo. I want to skip partially start and end segment part for point to point routing. Percent along start edge 0.6, percent along end edge 0.4. Route generated but start and end ...
1
vote
0answers
53 views
pgrouting with TRSP in LINUX [duplicate]
Possible Duplicate:
Why are start and end segment not partially skipped?
Im using turn_restrict_shortest_path algo for routing. For start and end segment it is not skipping the partial part ...
2
votes
1answer
309 views
routing using openlayers and pgrouting
I would like to do a Dijkstra routing using pgrouting and openlayers. I have the downloaded osm data. I am following the workshop given in this link. But since I am very new to this I found it ...
5
votes
3answers
704 views
How to add column length in a pgRouting PostGIS database?
I have 50 3d linestrings in postgis database, and I need to add column length so I could use pgRouting for calculating shortest path with Dijkstra. How can I add it?
2
votes
1answer
821 views
How to find the nearest point projected on the road network?
I would like to know if there is a function at pgRouting that given a point (lon/lat) can give you the projection of that point to the road network .
Thanks in advance
john
1
vote
1answer
62 views
Issues when using geometry in pgrouting
I am trying to use pgrouting to get the shortest path. I executed the shortest_path function and in return I got the set of edges belonging to that shortest path. When I got the geometry for each edge ...
1
vote
1answer
250 views
Issues while plotting the results of pgRouting shortest path
I am trying to plot the shortest path returned by pgRouting. However, I am having some issues. Sometimes it comes out a mess.
I have just joined the coordinates of the edges returned by the ...
1
vote
1answer
129 views
Interpreting the geom_way in the table created using osm2po [duplicate]
Possible Duplicate:
Issues while plotting the results of pgRouting shortest path
I am trying to actually figure out what this column exactly represents and how to use that in my case. I ...
1
vote
1answer
117 views
Geometry of edges created after using osm2pgsql
I used osm2pgsql to convert osm data to postgresql. Now I have a table with edges and they have geometry like multilinestring. I am not sure what is meant be geometry of an edge. An edge is supposed ...
1
vote
2answers
299 views
Issues with installing pgrouting in mac
I installed both postgresql and postgis using brew in mac. How can I now install pgrouting. I couldn't install it using brew. Any suggestions?
2
votes
2answers
126 views
Does PostGIS/pgrouting actually come with street info?
I've been looking at getting a new GIS setup going, involving QGIS/PostgreSQL/PostGIS/pgrouting, and so far it has been relatively easy. One thing I want to be able to do is to work out travel times, ...
0
votes
1answer
72 views
shortest_path is not working on large source/target
I tried to find a route using shortest_path function of pgrouting, and it took to the server (postgres) a lot time to process my query (more then 5 minutes!) even I have only 10 rows in my table.
...
1
vote
1answer
315 views
Generating nodes where edges meet, PostGIS, pgRouting
Recently I was doing some research on how to assign nodes (as POINT type geometry) to existing edges of a topology network and store them in a different table. Call it nodes table.
I have all the ...
1
vote
0answers
94 views
OSM_id missing from ways table created by Osm2pgrouting
GIS newbie here so excuse my ignorance if this has a simple answer.
I have been playing about with pgRouting and using Osm2pgrouting to load OSM files from Geofabrik.
However I just noticed that the ...
3
votes
1answer
182 views
How to get point file in 5km Buffer of route generated in pgrouting
I am using pgrouting to get shortest route. Now i want to get point that comes in buffer of 5km along router.Point is other shape file. route is using road shape so any one give me idea for same.
1
vote
3answers
211 views
Is it possible to make a routable graph from Polygons?
I would like to know if it is possible to make a graph with pgrouting 1.05 on polygons. What I mean is that I have to make a graph on a database without roads but with polygon geometry. I would like ...
1
vote
1answer
133 views
Is it possible to use assign_vertex_id() POLYGONs?
I'm trying to use pgrouting in order to create a graphe and I have two questions :
Is it possible to use the function assign_vertex_id() with a POLYGON geometry type? I always have the following ...
4
votes
3answers
2k views
How does assign_vertex_id() in pgRouting work?
I'm trying to follow this tutorial,
http://www.pgrouting.org/docs/foss4g2008/ch06.html
but on the step with assign_vertex_id() it shows an error for executing the SQL query:
SQL error:
ERROR: ...
2
votes
1answer
273 views
osm2pgsql finishes processing without creating vertices_tmp table
I am using postgresql 9.1 database with posgis installed. I also have pgroute installed on same database. I am trying to use osm2pgsql tool to import data for routing. But osm2pgsql tool finishes ...
5
votes
1answer
242 views
What is a Multilinestring?
What is multiline string in gis? I have found when I use pgrouting certain edges have this geometric property mentioned as multiline string.
I am not sure what's the purpose of this geometry and how ...
2
votes
1answer
187 views
How can I convert geoJSON data to GPX format
I want to know how I can convert geoJSON data to GPX format.
1
vote
1answer
111 views
How to interpret this pgRouting shortest path result?
I am trying to use pgrouting's shortestpath function. It returns a set of edges for the shortest path. However, the start node of the next edge is not the end node of the previous edge. I mean they ...
1
vote
1answer
157 views
Returning gps points in the form of gpx files in pgrouting
I am trying to create a service that returns the shortest path for a given start and end destination. What I did was used shortest path query provided by pgrouting to calculate the vertex and edges ...
1
vote
1answer
119 views
Get the shortest path between a start point and end point in pgrouting
I want to find the shortest path for a start point and end point chosen by the user. How can I accomplish this in pgrouting. I have the latitude and longitude of the start point as well as for the end ...
1
vote
1answer
102 views
Generate source_id and target_ id for every segment in a multilinestring geometry (PostGIS|PgRouting)
I am working on a project that requires finding the shortest path and to achieve this, I've used the PgRouting dijkstra function and it's all worked out perfectly.
Initially, the road network was ...
3
votes
2answers
282 views
Web-based user editable routing application
I am totally new to web-based GIS (and open source GIS) and am now working on a web-based travel planner using Postgis and Pgrouting with multicriteria costs. I want the end users (the traveler) to be ...
7
votes
1answer
362 views
How to Simplify a Line Network Preserving Topology?
I have a Shapefile (consisting of European major roads) with about 250.000 Segments which I have to simplify for pgrouting. But I can't seem to find a way to do that properly.
This is what it looks ...
10
votes
2answers
300 views
How to route over waterways?
There is a lot of information about (pg)routing over normal ways. Normal ways are man made and kind of ideal for routing.
However i am interested in routing over waterways. In theory this should be ...
1
vote
2answers
139 views
Is it possible to get 10 (some) ordered shortest paths ordered by distance (cost) with PgRouting (ex: SELECT TOP 10 SHORTEST)?
I'm new in pgrouting.
Is it possible to get 10 (some) ordered shortest paths ordered by distance (cost) with PgRouting (ex: SELECT TOP 10 SHORTEST)?
Update: why "second shortest" needed?
"second ...
1
vote
1answer
184 views
How to get route plan with certain distance with pgRouting?
I am working for a project. I have a road network which has been imported in PostgreSQL/PostGIS database. I can query shortest path between two points. I want to get route plan with certain distance. ...
1
vote
2answers
84 views
How to fix “Error, query must return columns 'id', 'source', 'target' and 'cost'”?
I have one spatial table with gid, FNODE_, TNODE_ and LENGTH column in my Postgresql/PostGIS database. I am using pgRouting. Problem is, when i try with shortest path query it shows following error. ...
1
vote
0answers
129 views
How will I get route along 3 points?
Can any one help me out to find route for three points. the points are start-via(Mid)-End. I want route to get create from start point to via(mid) point and via point to end point. Can any one can ...
0
votes
1answer
102 views
How to resolve case when routing result does not contain start and end point?
I have routing case shown on picture, SP=start point, EP=end point.
A-----SP-----B------------C----------D--------E-----EP------F
Routing result is BC, CD and DE. My points are not on route. I think ...
3
votes
0answers
148 views
How to handle updates to pgRouting network in webmapping environment?
I'm building an application for a client of mine that will need to create routes in a PostgreSQL database.
So far so good, but I need to support edits and changes to my network and I need to support ...
4
votes
1answer
779 views
Sea routes network dataset
I am now working on a system to perform routing on a network of shipping lanes.
See this dataset that I have as the base: http://geocommons.com/maps/109850
I have postgres and pgrouting up and running ...
1
vote
1answer
183 views
SQL sub-queries for -say- dijkstra_sp
I want to combine the following 3 commands (and eventually other ones such as functions from matching.sql right after...):
routing=> select source as s from ways where gid=10213;
s
------
...
-2
votes
1answer
640 views
I need QGIS routing plug-in
I am new to pgrouting. How does it work? What benefits can I get from it? I tried the examples, read some articles, but could not find the QGIS routing plugin for Windows.
It is not showing up in the ...
18
votes
8answers
3k views
Alternatives to pgRouting
I was wondering if there are any alternatives to pgRouting tools.
Thinking about it for a bit, I think the only alternative is to use R or RPY to do the analysis.
Basically I'm trying to solve ...
