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

learn more… | top users | synonyms

0
votes
1answer
1k 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
709 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
274 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
1answer
24 views

(Pgrouting) Finding the best path within some maximal length

Is it possible to find the best path (where cost is not length) with the length limit? For example, find the best path that is shorter than 10km? I currently use pgr_astar from Pgrouting to find the ...
0
votes
1answer
20 views

pgrouting crashes and restarts the postgresql server when searching for endpoints in 2 disjoints graphs

I have >apt-show-versions postgresql-9.1-pgrouting postgresql-9.1-pgrouting/precise uptodate 2.0.0-release-ppa1~precise2 Whenever I do a search ...
0
votes
0answers
16 views

Problem running the pgr_trsp algorithm from pgrouting

I was studying the pgRouting Documentation 2.0. I was trying to run the pgr_trsp algorithm as shown in the tutorial: SELECT seq, id1 AS node, id2 AS edge, cost FROM pgr_trsp('SELECT id, source, ...
0
votes
0answers
32 views

pgrouting shortestpathfromAtoB multiple pairs

I've got to solve a shortest path problem between multiple location pairs. E.g.: A to B C to D E to F etc. These pairs are stored in a table routing_basis like hkey; A; a.lat; a.lon; B; b.lat; b.lon ...
0
votes
2answers
27 views

How to set the tolerance value in pgr_createTopolgy function of pgrouting?

I am making a map based on the floor plan of a building. I made the shapefile and added it to the postgresql database. I created the topology for the map using the following code: SELECT ...
0
votes
3answers
115 views

Faster routing algorithm on pgrouting

I have downloaded data for india as a dbf file then converted it using osm2po to make it routable but the problem is when i make any routing query it takes a lot of time around 300 seconds and these ...
0
votes
0answers
18 views

problems using GRASS v.net and v.net.allpairs

I am using GRASS 6.4.3, and I am trying to use it to do network analysis. I have a line shapefile and a point shapefile, and here is my code(I take v.net.allpairs as my reference): v.net tc_bf25 ...
0
votes
0answers
20 views

pgrouting - possible to find route through points rather than links? [duplicate]

Probably a daft question, but... I've been looking at using pgrouting to analyse paths between start/end points, but this analysis seems only to find routes through links (edges). Is there any way ...
0
votes
0answers
30 views

display route from database(postgresql) on

For first part: Link i have postgresql9.1,postgis2,pgrouting2 and qgis2.2 this is the second part of what i need to do: Search in a database (postgresql with pgrouting) for a line from public ...
0
votes
2answers
101 views

Unable to implement pgrouting(plugin) pgr_astar routing algorithm (shortest path) [duplicate]

I have been working on a project for indoor navigation. I made the floorplan of the building and road-map for routing purposes as shp files (using JOSM, making GeoJSON and then converting to shp file ...
0
votes
0answers
10 views

Prepare OSM file for PGROUTING use [duplicate]

Well I am new in the GIS World :p well I have a webGIS to realise and I want use OpenStreetMap. well the region I need wasn't vectorised so I modified it with JOSM ( Added Roads and buildings) and ...
0
votes
1answer
37 views

How to add Routing Table Query-Result on pgrouting?

I've followed the pgrouting latest workshop http://workshop.pgrouting.org. I wanted to know how to add the routing table query-result into my webpage directly after the route showed up? regards
0
votes
1answer
62 views

How to use osm2po to solve TSP

I've got a TSP to solve. I created a routable street graph using osm2po and imported the result to PostGIS. On my PG db I installed the pgrouting extension (over PGAdmin3 GUI --> right click ...
0
votes
1answer
55 views

Routing result not showed up [closed]

I'm following the http://workshop.pgrouting.org/ but my routing result not showed up at all, like the picture below: my firebug also didn't give me an error, I'm using geoserver 2.4.2, postgresql ...
0
votes
1answer
65 views

Aiming to retrieve source and destination from Android, use pgrouting dijkstra to find shortest path and display it back on Android

I have created an Android application that will accept source and destination from the user. It then calls a php page which takes in the lattitude and longitude of the destination and the source. I am ...
0
votes
0answers
39 views

Maximum number of points in a linestring?

I have a database (in Postgres/PostGIS) of GPS points recorded all over a rail network. The only data available is the lat/long coords of each point (no timestamps, links between points, or anything ...
0
votes
0answers
52 views

What the pgr_createTopology() expect from a table param?

In this sample http://docs.pgrouting.org/2.0/en/doc/src/developer/sampledata.html#sampledata there is this struction SELECT pgr_createTopology('edge_table',0.001); I understand that create a topology ...
0
votes
0answers
63 views

Problem with pgRouting and pgr_createTopology

I follow this tutorial: http://anitagraser.com/2013/07/06/pgrouting-2-0-for-windows-quick-guide/ and create a graph using OSM data (planet_osm_roads table). All goes with no error, but searching ...
0
votes
1answer
71 views

pgRouting CMAKE cannot find CGAL

I'm not able to install pgrouting on Centos 6.4 with Postgresql 9,3 and postgis 2.0. I tried from the rpm, but I didn't found the repository. I tried building from the source but I got the following ...
0
votes
1answer
40 views

Issues with pgrouting workshop code in postgis 2.11/pgrouting 2.0

I'm having issues getting the pgrouting workshop to work on Postgresql 9.2/PostGIS 2.11 and pgrouting 2.0 on windows. How can I rewrite the following php/sql code and make it compatible with my ...
0
votes
0answers
24 views

How to turn this into a routable network that works with pgRouting? [duplicate]

I'm only asking again since I didn't get any answer and I'm still stuck here... I updated my last question with more info, but it wasn't answered. When I draw a line with snapping enabled and try to ...
0
votes
0answers
30 views

Could this ugly work-around work to fake a Multimodal network with pgRouting and QGIS?

I have a road network that is working with pgRoutingLayer in QGIS (I imported the layer to my dbserver, ran psql pgr_createTopology and got it back into QGIS as a new PostGIS layer. From here I can ...
0
votes
0answers
20 views

Can PGrouting be used to identify which path fits a known distance between a start and end node?

I am involved in a research project that uses historic transport data for England and Wales mostly in the nineteenth century. One particular problem concerns coaching data where all that is known is ...
0
votes
0answers
63 views

How to simplify osm2po's routable graph?

I'm building a pgrouting routable network thanks to osm2po, the problem is that my network is too big. Indeed I want to create isochron and 1 node = 1 canvas circle, so I don't want too many nodes. I ...
0
votes
0answers
30 views

SQL questions testing pgRouting 2.0

Following the post:pgRouting 2.0 for Windows quick guide, cuz I have some problem with DB manager(here is the problem I posted:DB manager in QGIS 2.0), I skip DB manager and save the test shapefile, ...
0
votes
0answers
44 views

PGRouting 2.0 for RHEL5

Is there a PGRouting 2.0 rpm package available for Redhat Enterprise Linux 5.8 and has anyone managed to install it successfully?
0
votes
0answers
30 views

Are there any code examples of plotting pgRouting on Google Maps available?

Does any colleague know about a code example of plotting pgRouting on Google Maps?
0
votes
1answer
41 views

pgrouting 2: missing pgr_findnearestnodedwithin function

With the PgRouting 1.5 I was using the find_nearest_node_within_distance function and it works, but now I'm moving the project to PgRouting 2 + Postgis 2 + PostgreSQL 9.1, and now that function, I ...
0
votes
1answer
29 views

How to get edge length(distance) from pgrouting DB

I have implemented pgRouting workshop and it's working fine. I need to get every edges length in kilometers to do some calculations I studied the ways table. It contains a length attribute, but it ...
0
votes
1answer
43 views

Identify the direction of traveling road segment

I'm using pgRouting to find the least congested path using time as the cost metric. I am using average speed between two nodes to calculate time taken to travel in a segment. In pgRouting there is a ...
0
votes
2answers
110 views

How to achieve point to point routing?

Currently, the pgrouting 1. 5 version has a shortest path function which actually traces a path from nearest vertex of source to nearest vertex of destination but. As, Dijkstra's algorithm works on ...
0
votes
0answers
26 views

Shortest path with varying costs

I have three different layers on different road types in three tables in PostGIS 2.0; freeways, main_roads, and small_roads. I want to calculate the shortest path with the pgRouting function ...
0
votes
0answers
95 views

getting a geoJSON string using pgrouting and path drawing in an Android application

Currently I am working on a project that displays a route in an Android application. I have configured pgrouting 1.5 workshop and it's working fine using a web browser. In order to draw the path in ...
0
votes
2answers
87 views

trsp route between two points ( not edge to edge )

I'm trying to solve common problem, how to generate route/navigate between two GPS coordinates and not between two edges using trsp algorithm. I did read many articles here but i'm not sure how should ...
0
votes
0answers
26 views

Identify road segments of pgrouting for update values

I'm using pgrouting for discover least congested path for some destination for that i have to change the cost value from distance to some dynamic value. I calculate that value from some data which ...
0
votes
1answer
26 views

Unable to download osm2po from the original site

I've been trying to download the osm2po tool, in order to import the openstreetmap data into postgis database, from the original site and is impossible for me. All links I find in the page are cyclic, ...
0
votes
0answers
88 views

pgRouting TSP with distance matrix when the end node is specified

I'm a little bit lost: how does it actually work? Here's the query: SELECT * FROM pgr_tsp('{{0.0,0.0215410000058,0.0445673059851,0.0427254110132,0.0504644580794}, ...
0
votes
0answers
60 views

Route through water polygons

I have a water-polygon grid shape file as shown (Each grid is 1latx1long): I have created this in QGIS and files (coastal lines and land polygons) selected from http://openstreetmapdata.com/data ...
0
votes
0answers
50 views

How to avoid intersection in pgRouting

I'm a newbie in pgrouting. I want to create a web-app with routing function. I want to ask how to avoid a road intersection with pgRouting? For example, there are some traffic jams happened in several ...
0
votes
0answers
106 views

pg_routing / osm2po routing not working

I'm trying to make working pgrouting 2 but no luck. Generally it is working but routing table is completely wrong. I did import osm database using osm2po(): java -Xmx1024m -jar ...
0
votes
0answers
60 views

What is default unit of st_length in pgrouting for osm shapefiles?

I am using st_length to find the distance between two nodes on a way. What is the default unit of the distance returned. I am using data from openstreetmap shapefiles
0
votes
0answers
54 views

osm2pgrouting can't get ways.the_geom srid

When I try to launch osm2pgrouting osm2pgrouting -file ~/Téléchargements/mayotte-latest.osm -conf /usr/share/osm2pgrouting/mapconfig.xml -dbname routing -user gisuser -passwd fred1490 -clean I get ...
0
votes
0answers
50 views

Basic use of pgrouting 2.0

i'm fighting with pgrouting 2.0 and lack of documentation or examples. I did import map to psql using osm2po tool, then i build topography, i locate start and end points ids - ( they match database, ...
0
votes
2answers
413 views

PGROuting 2 : Getting nearest node to a given point (with lat - long given)

I have a point whose latitude and longitude (only) are known, and a table of nodes with their geom. I want to find the closest node in the table to the given point. I think I can achieve this with ...
0
votes
0answers
40 views

Osm2pgsql and pgr_astar

How can I use the osm2pgsql schema with pgr_astar? How to do this(1*) using osm2pgsql? 1* SELECT id, source, target, cost, x1, y1, x2, y2 [,reverse_cost] FROM edge_table
0
votes
1answer
73 views

create node ids with a multilinestring

I've got to make a route with my multilinestring table "routebus", but I can't create the node ids... maybe the fact that it's a multilinestring is the problem, but I really don't know how to solve ...
0
votes
0answers
53 views

pgRouting Win 7 installation problem

I have run into a problem installing pgRouting. Following Anita Grasers guide, I have gotten as far as to execute the three .sql files. The first sql file (routing_core) runs fine, but for the second ...