Tagged Questions

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

learn more… | top users | synonyms

1
vote
1answer
258 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
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 ...
1
vote
1answer
190 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
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
434 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
142 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
314 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
266 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
114 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
109 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
525 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
60 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
502 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
234 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
145 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
93 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
46 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
103 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
31 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
111 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
261 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
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 ...
0
votes
1answer
73 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
103 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
876 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
575 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
236 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
16 views

pgrouting sample html on osgeo-6.05 not working

I am trying to get pgrouting workshop done. I did all the things which are mentioned in the workshop. But still call to http://localhost/pgrouting/routing-final.html in browser doesn't display ...
0
votes
1answer
34 views

Libraries to navigate and choose path based on congestion level?

I'm trying to develop a system to get best path to travel user based on road traffic (congestion level). Functionality of the system should be provide least congested path for traveler given ...
0
votes
1answer
45 views

SELECT assign_vertex_id('ways', 0.00001, 'the_geom', 'gid'); not work

I'm using using OSgeo 6.5 dvd and studing pgrouting workshop (link) for get shortest path. I created network topology call "pgrouting - workshop". There are three commands to execute in section 5.2 ...
0
votes
1answer
48 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
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 ...
0
votes
0answers
50 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
28 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
46 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
15 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
21 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
49 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
15 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
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 ...
0
votes
0answers
61 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
34 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
30 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
0answers
51 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
88 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
25 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 ...

1 2 3 4 5 6