pgRouting extends the PostGIS / PostgreSQL geospatial database to provide geospatial routing functionality.
0
votes
2answers
67 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 ...
1
vote
0answers
19 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
12 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
2answers
84 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
1answer
244 views
How to generate all possible routes between two points?
I have a network dataset in ArcGIS and I need to generate all possible (not only the shortest one) routes between two given points (A, B). Is it possible to do it with the Network Analyst? Or with any ...
0
votes
0answers
15 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 ...
2
votes
1answer
116 views
Issues when using pgrouting's shortest path
I am having some issues when using pgrouting's shortest path. I am following this tutorial available at http://workshop.pgrouting.org/chapters/shortest_path.html#dijkstra. This query returns a list of ...
3
votes
2answers
354 views
Does pgRouting support turn-by-turn routing?
I have route list as result of pgRouting with street names. How to get messages "Turn left", "Go along" etc ...
Can pgRouting do this or I need some other source and which?
1
vote
0answers
42 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:
...
5
votes
5answers
338 views
Improve performances on distance coverage routing - PostgreSQL
I have to create layers of land coverage from one point to anywhere around on a given street network for a given distance (ex: FROM house, DISTANCE 30000m)
An important factor to understand; I need ...
0
votes
1answer
157 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 ...
0
votes
0answers
34 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 ...
8
votes
3answers
1k views
How to emulate Google Maps driving directions using pgRouting?
Would like to emulate google maps' driving directions functionality but use pgRouting instead. google's data over the project area & scale is quite a bit off so we want to use our own transport ...
3
votes
1answer
390 views
How to use the pgRouting TSP function?
For more than two days I'm trying to make the TSP algorithm work in PostgreSQL/PostGIS. My problem seems to occur when I'm trying to take into account the road network for TSP algorithm. I know that ...
0
votes
0answers
22 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
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 ...
0
votes
0answers
11 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 ...
2
votes
3answers
250 views
ERROR: function shortest_path(unknown, integer, integer, boolean, boolean) does not exist
I have my roads and locations added into my PostGis DB, and have installed pgRouting's SQL files. However, when I attempt to run:
SELECT * FROM shortest_path('
SELECT gid AS id,
...
1
vote
1answer
122 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 ...
1
vote
1answer
65 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 ...
1
vote
1answer
100 views
How to link pgrouting edges with street names to rout user based in street names?
I have installed postgreSql + postGis + pgrouting and I have loaded OSM data into my database using osm2po and shp2pgsql. How can I search for points in the map using the street names and then route ...
2
votes
1answer
32 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
48 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
39 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
1answer
30 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?
2
votes
1answer
73 views
problems installing pgrouting from source
I'm running into a problem once I try
[cmake_dir]/bin/cmake .
I get these errors:
Boost headers were found here: /usr/include
Output directory for libraries is set to sh: ...
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?
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,
...
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 ...
1
vote
1answer
45 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
48 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
49 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 ...
3
votes
2answers
437 views
How to use pgRouting's dijkstra_sp_delta_directed with WHERE clause?
Right now I am using PgRouting for vehicle routing and I have problem with Dijkstra shortest path. My query is:
SELECT * FROM shortest_path('SELECT gid AS id,
source::int4 AS source,
...
1
vote
1answer
41 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
47 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
2answers
70 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 ...
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
302 views
Using OSM data, pgRouting, and dummy data to develop an origin/destination travel matrix
Further to my previous question I was wondering if it is possible to add dummy node data without to do routing analysis.
ISSUE
I have a polygon layer that represents zonal attributes
I created a ...
7
votes
3answers
191 views
Why doesn't pgRouting return the best path?
Let the next portion of a graph:
When I use the function shortest_path between the points A and B, I got the blue path. Why does this happen?
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 ...
3
votes
5answers
2k views
Problems in installation of PostGIS
I will be installing PostGIS for my project using PostgreSQl (OSM) in Ubuntu 9.04. I had all the requirements prior to the installation (PostgreSQL, Proj4, GEOS). When I unzip the PostGIS tar, then ...
3
votes
1answer
88 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 ...
2
votes
1answer
115 views
How to add Custom data (like for Indoor floors) and find routes using open source software?
I am a newbie to GIS platforms so maybe whatever I am asking is very simple or obvious. I have read documentation/tutorials and as a last resort I am posting here, so any help is appreciated. I am not ...
0
votes
1answer
91 views
Why is pgrouting driving distance skipping edges?
I have a road network where I do a driving distance operation through pgrouting. This is my SQL:
SELECT * FROM driving_distance('SELECT gid AS id,source,target, cost FROM ...
1
vote
1answer
186 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 ...
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 ...
2
votes
0answers
108 views
Is there a way to start the route on pgrouting from a coordinate that is not a node?
After execute all steps from this pgRouting tutorial, now I have a map that creates and displays routes, but as the routing methods rely on parameters representing vertex Ids that was created using ...
1
vote
1answer
47 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 ...
