pgRouting extends the PostGIS / PostgreSQL geospatial database to provide geospatial routing functionality.
1
vote
1answer
21 views
Pgrouting - Networking
my problem is regarding routing.
I have a network based on bicycle graph links (SRID: 4326), with bidirected and directed ways.
I want to give the user the functionality to draw a route (shortest ...
1
vote
1answer
103 views
How to link pgrouting edges with street names to route 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 ...
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
1answer
28 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 ...
2
votes
1answer
79 views
How to install pgrouting from source on CentOS 6.3?
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: ...
0
votes
0answers
18 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
2answers
77 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
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
17 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
88 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
247 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
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 ...
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
358 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
45 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
341 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
160 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
39 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
393 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
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
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
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 ...
2
votes
3answers
256 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
129 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
68 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
37 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. ...
1
vote
1answer
53 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
42 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?
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
52 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
52 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
51 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
445 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
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
49 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
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 ...
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
303 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
197 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
90 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
117 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
92 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
188 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
30 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 ...
