Tagged Questions

pgRouting extends the PostGIS / PostgreSQL geospatial database to provide geospatial routing functionality.

learn more… | top users | synonyms

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 ...
1
vote
1answer
128 views

Possible to use same database for mapnik and pgRouting?

I am already running an OGCServer (mapnik) with an postgis database. I want to also run pgRouting on preferably the same database, so that I do not have to maintain two separate databases. I ...
1
vote
1answer
419 views

How to solve the “Undefined symbols in librouting.dylib” issue on Mac Os X?

I'm trying to create a Homebrew formula to let anybody install pgrouting on his or her mac. I've seen this question: How to fix pgRouting librouting_dd.so: undefined symbol error? I'm also following ...
1
vote
0answers
139 views

How to add column “EDGE” in pgRouting?

I am a newbie in PostGis and pgRouting. I have installed and configured both on my windows PC, following FOSS4G tutorial. I am able to see the result in browser, using GeoServer and OpenLayers. ...
1
vote
0answers
134 views

dijkstra_sp_directed not returning any result

I am trying to create a routing application with OSM data. What I am working with is an almost square area of about 30x30 kilometers, so nothing too big. But when I do something like SELECT ...
1
vote
2answers
310 views

How can I calculate the amount of memory required to run osm2pgrouting?

I have read that osm2pgrouting loads all the data into memory, which makes it faster. On the other side the size of the .osm file which it can parse is limited. How can I exactly know how much ...
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
1answer
112 views

Open Source GIS Problem [closed]

I am new at open source GIS platform. I am using Ubuntu 12.10. I have tried to install the followings but without 2-3 tools I could not install anyone. Can any body help me how can I install the ...
0
votes
1answer
94 views

how to find vertices for a geometry in OpenLayers

I am having a LineString, where I need to find the vertices logically and save those vertices. Can anyone help me out. Or else how below can help me. OpenLayers.Geometry.LineString = ...
0
votes
2answers
513 views

osm2pgrouting connection failed

I'm importing data from my OSM file to a postgresql database using osm2pgrouting. I followed everything in from here and it went smoothly, until I try using osm2pgrouting. This is what happens: ...
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 ...
0
votes
1answer
483 views

osm2po vs osm2pgrouting: workshop pgRouting

As osm2po was a more reliable way to convert an .osm I went for that solution to load my date in postgres. In the workshop however the author points out to check the result after osm2pgrouting. The ...
0
votes
1answer
221 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
137 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 ...
0
votes
2answers
73 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
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
2answers
85 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
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?
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 ...
0
votes
1answer
246 views

Do postgres 9.1, postgis 2.0 from stackbuilder and pgrouting 1.0.3. work together?

I am new to pgrouting and I would like to check if the version I have installed works fine with postgres and postgis. I have installed postgres 9.1, postgis 2.0 from stackbuilder and pgrouting 1.03. ...
0
votes
2answers
106 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 ...
0
votes
1answer
70 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. ...
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 ...
0
votes
1answer
860 views

Pgrouting OpenLayers all together

I'm new to all this I'm still trying to understand how things work.I have found a tutorial for pgrouting that shows the shortest path with Dijsktra or A* or shooting star at a map . I followed the ...
0
votes
2answers
570 views

How to build pgRouting with CGAL?

When running cmake . for CGAL 3.9, i get the following output: root@postgresql local/CGAL-3.9# cmake -DWITH_CGAL_Qt3=OFF -DWITH_CGAL_Qt4=OFF -DWITH_CGAL_ImageIO=OFF . -- The C compiler identification ...
0
votes
2answers
231 views

Installing TSP functionality on win7

I'm very new to pgRouting! I installed PostgreSQL 8.4, and pgrouting 1.03 on win7. I need to solve a TSP problem so I was trying to install the TSL functionality as showen at: ...
0
votes
0answers
13 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
0answers
15 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 ...
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 ...
0
votes
0answers
37 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
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
12 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 ...
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
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
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 ...
0
votes
0answers
57 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
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 ...
0
votes
0answers
50 views

how to group interconnected edges inside a table?

Given a table and a random set of edges with source and target columns, how can I find out which edges connect with each other and then group them together using PostgreSQL?
0
votes
0answers
83 views

Routing between two nodes in PGROUTING

I import osm data into postgresql using the tutorial: http://workshop.pgrouting.org/ . I want to do the shortest_path between two nodes in the table nodes, but this function work over the table ways, ...
0
votes
0answers
57 views

Wrong order to the path

I have a query which i use to find a route between two points . Even though the route is displayed good on the map the order i get from pgrouting is wrong the query is this one SELECT rt.gid, ...
0
votes
0answers
24 views

why there are links in streets table on navteq with zero value in the FEAT_ID field?

I have too many links with FEAT_ID = 0. Those links are transitable ways, but in the navteqs tables the associate FEAT_ID value is 0. Also, the street name and other fields are in 0. What does this ...
0
votes
0answers
181 views

assign_vertex_id error

I am trying to test if pgrouting works fine or not. To do so I have created a table containing the following attributes. Columns: gid | length | the_geom | source | target Now my ...
0
votes
0answers
55 views

(pgrouting)Problem using shortest path function

I have a problem using the shortest_path function ERROR: function "shortest path" in FROM has unsupported return type path_result(PSQL EXCEPTION) i have intalled the postgresql ...
-1
votes
1answer
329 views

pgrouting how to implement driving directions with php

I am stuck on implementing driving directions. I have no clue how to do it. I wanted to do it just like this: iMaptool LeadDog routing example Please advise
-2
votes
1answer
635 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 ...

1 2 3 4 5 6