Questions tagged [pgrouting]

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

pgRouting logo

Project resources:

901 questions
9
votes
2 answers

Determining pgrouting version

Is there a way to know what version of pgrouting I have? My OS is ubuntu 12.04. I want to know my pgrouting version because the 1.05 version has some issues with shooting start and the directed graphs and the last stable version which has this…
José Alejandro
  • 591
  • 1
  • 4
  • 11
7
votes
1 answer

What does pgRouting's architecture look like?

I know that pgRouting is a pretty nice tool, but I would like to use something of my own in my application, mainly because I don't know C and I don't know how to tweak the performance of pgRouting. Thus I am interested in how pgRouting's internals…
skanatek
  • 629
  • 1
  • 5
  • 13
6
votes
2 answers

How does assign_vertex_id() in pgRouting work?

I'm trying to follow this tutorial, http://www.pgrouting.org/docs/foss4g2008/ch06.html but on the step with assign_vertex_id() it shows an error for executing the SQL query: SQL error: ERROR: column "’ways’" does not exist LINE 1: SELECT…
user10528
  • 275
  • 2
  • 5
6
votes
0 answers

Is PgRouting DARP Function still being supported?

I'm asking this, because I need some tool to solve a DARP problem. After researching I found PgRouting had included this functionality in one of its branches. But after installing it, getting stuck and looking for other people problems similar to…
Laggel
  • 241
  • 2
  • 8
6
votes
2 answers

Query failed: ERROR: Operation on two geometries with different SRID

Following the pgRouting workshop here, I have the routing query below: $sql = "SELECT gid, start_id AS source, end_id AS target, the_geom, distance(the_geom, GeometryFromText( 'POINT(".$lonlat[0]."…
okello
  • 1,780
  • 1
  • 25
  • 45
6
votes
2 answers

How to compile pgRouting 1.05 binaries for Windows?

Anybody with a compiled 1.05 binary for (Windows / PostgreSQL 8.4 / PostGIS 1.5.3) or a detailed description on how to compile?
frodewj
  • 168
  • 4
6
votes
2 answers

How does pgRouting shortest_path work?

I am running the shortest_path function but it will not return rows of lines to follow from source id to target id. Is there a specific way to digitise my dataset? Does pgrouting understand intersections between lines? I digitised my lines one by…
Antony
  • 925
  • 1
  • 11
  • 23
6
votes
1 answer

Problem with shooting star with pgRouting: doesn't respect the one ways

I used osm2po to create a table for pgRouting. I notice a problem: for a route with dijkstra or a* the route is correct and respect the one ways. But with shooting*, it doesn't respect the one ways. The route is from 11 baulacre geneve (46.2159082,…
5
votes
1 answer

Is there a maximun number of edges/vertices PGRouting can cope with?

We have imported OSM networks to route on. So our IDs sometimes grow abnormally big ;) It seems that PGRouting is failing with IDs like 633719916... We got this error message from postgresql: "terminate called after throwing an instance of…
4
votes
1 answer

Is there any working example for pgr_trsp ?

I'm trying to use pgrouting pgr_trsp function but result is useless. Exactly same code with pgr_dijkstra working OK and find shortest path between start and stop but with pgr_trsp it is look like random jumps around map. I'm using this code SELECT…
Matus
  • 77
  • 6
4
votes
1 answer

How to use navteq information for turn restrictions in pgrouting?

I'm developing a pgrouting application using navteq information but I don't know how to use the navteq information to add turn restriction in pgrouting. Even, I don't know where to find this kind of information in the navteq tables. I guess this…
José Alejandro
  • 591
  • 1
  • 4
  • 11
4
votes
2 answers

Shortest path between multiple points in pgRouting

I have used this great tutorial, and shortest part between two points works fine. My question is: How to calculate shortest path between multiple points?
Marko
  • 139
  • 1
  • 5
4
votes
2 answers

How to add a new road to an existing pgRouting graph?

I have an existing pgrouting network topology that I would like to add a road to. The road is a linestring from a shapefile and will intersect several roads in the existing network. Is there an easy way to add the road into 'ways' so it is…
mdslva
  • 41
  • 1
4
votes
1 answer

pgRouting for postgresql 9.0?

Is pgRouting 1.05 compatible with postgresql9.0 Win32? I am a newbie, and I have spent three days trying to build it for postgresql9.0, but without success in the end. Thanks. Yes, you are right. I am using postgresql 9.0. Building all of those…
JJZ
  • 41
  • 3
3
votes
1 answer

dijkstra_sp_directed() not returning valid paths

I think I have found a major issue with pgrouting. I hope I am just doing something wrong due to my inexperience. I am plotting the following query using OpenLayers. select transform(the_geom, 900913) from dijkstra_sp_directed('ways', 52343, 39219,…
user2583
1
2 3 4 5 6 7