pgRouting extends the PostGIS / PostgreSQL geospatial database to provide geospatial routing functionality.
0
votes
0answers
16 views
pgrouting reverse cost problem
I already read some about the problem and tried to handle it, but there is something that is wrong. Reverse cost simply dont working. Here is the code:
case 'SPS' : // Shortest Path Shooting*
...
0
votes
1answer
25 views
missing tables vertices_tmp and vertices_tmp_id_seq pgrouting workshop
I'm using OSgeo 6.5 dvd and studing pgrouting workshop for get shortest path.
I created database call "routing" and used "template_routing" for create tables but only 3 tables created. So then I ...
1
vote
0answers
22 views
travel survey multi stop routing problem
I have a travel diary survey dataset that I am attempting to transform into more useful information. Currently, the data comes in the format of:
Survey# , PlaceVisited#, TravelMode, TripPurpose, ...
1
vote
1answer
16 views
pgRouting on RHEL6: issues with driving distance library
I installed pgrouting on RHEL6 via yum and the ELGIS 6 repo (the only place where I could find pgrouting for RHEL6).
The problem is that the librouting_dd.so library (for driving distance) is ...
0
votes
0answers
16 views
How to find all possible paths by Postgis / Pgrout [duplicate]
There are functions available to find the shortest paths in Postgis / Pgrouting extension. But is it possible to find all the possible paths between two points/nodes ?
Is there any such function ...
1
vote
0answers
43 views
Looking for best practice to connect multiple road vector line layers for routing (pgRouting) purposes
The Data I have:
Bridges (line layer)
Municipal_roads (line layer and does not include information in Bridges)
State_roads (line layer that doesn't include Municipal_roads or Bridges)
Question:
...
0
votes
2answers
75 views
Emergency Services: How to optimize routing by measured travel time?
I would like to optimize the service areas / catchment areas for an emergency service. Therefore, I have several measurement points on the streetmap, where people have stopped the travel time from ...
0
votes
0answers
38 views
pgrouting core function in php
I would like to use pgroutings core functions instead of wrapper. I need to do this because of the wrong edge order the wrapper gives. Please tell me how can i modify my code, im not familiar with php ...
0
votes
0answers
23 views
How to use for loop to make driving_distance more efficiently？
I use driving_distance function in pgRouting to work with my river network. There are 159 nodes in my river network, and I want to get the distance between all of the nodes. This is my code so far：
...
0
votes
0answers
39 views
Shooting star algorithm in postgres 8.4 and postgis1.4 showing fatal error and remaining are working fine
When I try to run this shooting star algorithm, the postgis suddenly loosing connection to postgres and showing error no connection to server
SELECT * FROM shortest_path_shooting_star('
SELECT gid ...
0
votes
0answers
13 views
Can driving_distance return all sets of distance from different starting points at one time？
I'm now using the extension of pgRouting, driving_distance, to search for the distance along the river system：
In the figure, the starting point is 3, but I want to get the distance starting from ...
0
votes
0answers
17 views
driving_distance does not return all sets of distance
As title, I am working with pgRouting, trying to get the distance matrix along the river system.
I use driving_distance function and it seems like I am getting what I want：
But when I check the ...
1
vote
1answer
66 views
Win7 Senior users_Which pgRouting and postGIS versions are stable with postgreSQL8.4?
I'm working on a postgreSQL ,postGIS and pgRouting project on Windows 7
I need to work on a stable version (no time for risks), and I can see that many people are asking the same question many ...
2
votes
1answer
33 views
How to install multiple versions of postgres in same os windows 7 64-bit?
I have already installed PostGIS along with opengeosuite and it is the latest version. Now I want to run pgrouting but the latest stable version does not compatible to the latest postgres versions. ...
-3
votes
0answers
49 views
What versions of Postgres, PostGIS and pgRouting shall I use on a 64bit windows os? [closed]
Please give me the links and stepwise instructions briefly for installing all the three.
Condition : There shouldn't be any bug in shooting star algorthm. So the comaptable stable versions of the ...
1
vote
1answer
50 views
Does each road segment need to be digitized into a separate entry for a road network?
I am trying to understand this code in pgRouting for creating topology:
CREATE OR REPLACE VIEW road_ext AS
SELECT *, startpoint(the_geom), endpoint(the_geom)
FROM road;
CREATE TABLE node AS
...
0
votes
0answers
40 views
What are the rules for digitizing roads for creating a road network?
I want to create shortest route tool using pgRouting. But I digitised roads in a random manner. Shall I need to give a separate row for each road segment?
0
votes
0answers
12 views
pgRouting：routing problems using reverse_cost
I saw this post：Routing issues with pgrouting, and try the ability of reverse_cost.
As the result of this post, if there is only one way to go from one node to another, even though the reverse_cost ...
0
votes
1answer
41 views
Can pgRouting work more efficiently？
I use a river network on which has a lot of nodes to test pgRouting,
and I run the SQL, searching for the shortest path between nodes.
SELECT * FROM shortest_path('
SELECT gid as id,
...
1
vote
1answer
51 views
pgRouting：how to use reverse_cost？
I add a new column, naming it "reverse_cost", and give it the same data in the shape_leng column.
But as I run the shortest path algorithm in pgadmin, I got an error message.
here's my sql code
...
0
votes
1answer
50 views
Creating the node ids：Is this SQL error related to geometry type？
I loaded a multilinestring layer into PostGIS Manager：
and use the SQL query, trying to get the table with the node ids：
ALTER TABLE split_4 ADD COLUMN source integer;
ALTER TABLE split_4 ADD ...
2
votes
0answers
50 views
assign_vertex_id：problems when creating the node ids
Before using pgrouting, I have to create the node ids.
I loaded my polyline layer into PostGIS Manager：
I type this in SQL query：
select assign_vertex_id('split_4', 800, 'geom', 'gid')
But as ...
1
vote
1answer
42 views
SQL Command to convert pgRouting result to GeoJSON
My goal is to produce a Web UI for pgRouting using this tutorial. I have already imported my data from an OSM pBF to PostGIS using osm2po. Using the pgRoutingLayer plugin for QGIS, I was able to ...
2
votes
0answers
48 views
Get Multiple Shortest Path using PgRouting in One Query
I am trying to get multiple shortest path using A* Algorithm available in PgRouting.
I referred Solution given by UnderDark ( Link of the Stakoverflow Post ) . But it is not giving me proper Output.
...
1
vote
0answers
31 views
Do I need to deal with warnings about row count and spatial index to use pgRouting?
After read this nice post from underdark A Beginner’s Guide to pgRouting, although I still have some little problems, I think I can begin the "Creating a routable road network" stage right now.
I got ...
0
votes
0answers
29 views
How to find dijkstra's shortest path in OpenLayers [duplicate]
I have just hard coded the routes and calculating distance for each node from the source node, but I could not find the shortest path . I am just trying to move or find the nodes of a LineString by ...
1
vote
1answer
70 views
How to visualize pgrouting query results in mapguide open source
I would like to make a spatial query using postgis 2.0 and pgrouting 1.05 then visualize results in Mapguide open source.Any suggestions?
1
vote
1answer
187 views
Unreachable vertex
I'm developing an application for academic purposes that mainly gives to the user a recommended itinerary for a previously introduced preferences (Gastronomy, Leisure,etc.).
For this purpose, I use ...
1
vote
1answer
48 views
segment lines according to point using pgRouting?
I'm working on postgresql and I am trying to create table to generate graphs. I have a table that contains all the objects of a city (points) and another contains the city street. My goal now is to ...
1
vote
2answers
67 views
Problem using shortest_path with find_nearest_link_within_distance function
I'm tried to work on the scenario that avoiding go through some path if there is a barrier near that path. It can run well with the query below:
SELECT * FROM shortest_path('SELECT gid AS id, ...
1
vote
2answers
71 views
osm2pgrouting hangs on “classes table created”
I'm trying to run osm2pgrouting and on Ubuntu 12.04...everything looks like it's working until it gets to "classes table created" when it just stops. I'm watching the process with the system monitor ...
1
vote
2answers
203 views
Which version of pgRouting should I use with PostgreSQL 9.1 and PostGIS 2.0 (on win xp)?
I am new to GIS.
I want to install pgRouting on my system (win-xp 32-bit). I am trying to run routing_core.sql file and got the following error:
ERROR: incompatible library "C:/Program ...
4
votes
0answers
74 views
osm2pgrouting stuck (showing classes table created) when importing an osm file
I am trying to import an osm file using osm2pgrouting. while following the pgrouting workshop. (file is 700mb~)
im running ubuntu 12.04 on m1.large on amazon.
the same file was successfully upload ...
1
vote
1answer
127 views
How to create routable network by pgrouting with assign_vertex_id?
I'm trying to create the routable network as per http://underdark.wordpress.com/2011/02/07/a-beginners-guide-to-pgrouting/and use assign_vertex_id. Do I still need to create the node table? How would ...
0
votes
0answers
58 views
ST_intersects and shortest_path to optimize routing in respect to (de-)acceleration
Is there a way to consider a more complex cost field in the PG_Routing algorithm?
I am currently trying to get more realistic routing costs. I have a map based on the German ATKIS standard with road ...
0
votes
1answer
32 views
Problem in executing the routing_core.sql
I am getting the following error:
ERROR: could not access file "$libdir/librouting": No such file or directory
How can I fix it?
0
votes
0answers
24 views
step by step tutorial for using pgrouting [duplicate]
I have installed pgrouting from source and want to use it to make myself familiar with it. Is there any step by step tutorial for beginners?
I am trying to use this. But the database link given here ...
0
votes
2answers
86 views
how to solve “could not access file '$libdir/librouting'” problem in ubuntu 12.04
I am trying to install pgrouting in my ubuntu 12.04 machine using the instructions of this link. However, when I try to execute the following command based on step 3, it generates some error.
command
...
0
votes
0answers
25 views
I dont get any result after i executed the shortest_path() (pgrouting) [closed]
i'm following the tutorial :
http://underdark.wordpress.com/2011/02/07/a-beginners-guide-to-pgrouting/
everything seems working , no errors !
when i execute the shortest path i dont get any result ...
0
votes
1answer
159 views
Creating routable network table in PostGIS
I am trying to create the routable network table, as per http://underdark.wordpress.com/2011/02/07/a-beginners-guide-to-pgrouting/. Everytime I do it in PostGIS extension, QGIS crashes. The area is no ...
1
vote
0answers
41 views
PgRouting: Connect route to table
I would like to show the edges of the result route in a table, like this:
http://routing.geosdi.org/
I did the pgrouting part, just have to make the table and connect it.
How can I achieve this?
1
vote
2answers
81 views
How to change the function of cost of osm2po?
As the column 'kmh' shows speed limits wrong for my city, and I didn't want to modify the configuration file of osm2po for each type of road, is there a way to change the cost function? I wish:
cost= ...
0
votes
1answer
28 views
pgRouting one way segment direction
How can one acquire information about direction of a one way road from OpenStreetMap data converted to a postresql database with osm2pgrouting?
3
votes
1answer
123 views
Routing with multiple points
I am using postgreSQL, postGIS and pgrouting. Now I am really confused on how am I going to find the shortest path between multiple points.
I know how to find it between two points through dijkstra ...
2
votes
2answers
129 views
How to visualize pgRouting layer in leaflet?
I have completed all the queries of the of pgRouting tutorial by Underdark where visualization was done with the help of RT SQL Layer Plugin. As I am using Windows OS I have no access of that tool. ...
4
votes
1answer
193 views
pgrouting: Directed Shortest Path calculation using Dijkstra ignores one-way streets
I think I found an interesting bug in pgrouting. When I use the Dijkstra algorithm (no matter if I use the shortest_path() or dijkstra_sp_delta_directed() method) to calculate the directed shortest ...
3
votes
1answer
89 views
pgRouting Dijkstra returns wrong [duplicate]
I've just observed something quite odd.
I have created a table with data for routing, and this table contains data for a graph over six different hour conditions. So when performing shortest_path, I ...
1
vote
1answer
42 views
Installation problem for pgrouting
When compiling pgrouting from source for Ubuntu 12.10, I got the following error message. The version of boost is 1.52, is it too new for building pgrouting?
[ 37%] Building CXX object ...
2
votes
0answers
55 views
Pgrouting can't find postgresql (on Mac)
I've installed both postgreSQL 9.0 and postgreSQL 9.1 on my mac, using binaries from http://www.kyngchaos.com. I also have postgis 1.5 installed.
I tried to install pgrouting, again using binaries ...
4
votes
1answer
88 views
finding routes just for cyclists
I have created a PostGIS DB using osm2po and I am using pgrouting to calculate the routes.
The application I am creating should find routes for cyclists so I want the route finder to prefer roads ...
