pgRouting extends the PostGIS / PostgreSQL geospatial database to provide geospatial routing functionality.
3
votes
2answers
126 views
Multiple queries in a row
I have osm data imported into PostgreSQL with osm2po tool (wich makes the data routable). Also I have imported data relationed with nodes and node_tags with osmosis tool.
I need to obtain a set of ...
2
votes
0answers
109 views
From pgRouting shortest_path back to osm node id
I'm successfully performing path finding queries like shortest_path on data imported with osm2pgrouting.
The tables I have inside my pgrouting DB are the following:
List of relations
...
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
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 ...
1
vote
1answer
148 views
Does OSM2PO take into consideration turn restrictions?
It is supposed that for using Shooting star function in pgrouting, we need to have RULE and TO_COST fields in our table, but OSM2PO hasn't created those fields. what must i do for OSM2PO takes into ...
1
vote
1answer
143 views
How to control what kind of tags / flags are imported with osm2po?
With the help of osm2po, I have successfully inserted the contents of the italian files (italy.osm.pbf) in a pgrouting-enabled database (postgresql 8.4)
It displays fine in Qgis, using rule based ...
4
votes
2answers
171 views
Creating many origin-destination routes with pgRouting
I'm using a PostGIS / pgRouting database setup with a road network. I'm trying to create an origin-destination table with the complete route information, so not just the sum of the length, like in ...
3
votes
1answer
327 views
What is the difference between Astar and Dijkstra algorithms in Pgrouting?
I would like to know what is the difference between A* algorithm and Dijkstra at finding the shortest path at pgrouting.
Which one is faster ,has better performance and returns better results.
Also ...
2
votes
0answers
91 views
Create a consistent topology using pgrouting
I'm developing an application that needs routing information for certain cities. First, I downloaded a openstreetmap datafile (*.osm) and then I imported it into a postgreSQL database using ...
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, ...
3
votes
1answer
86 views
Calculating from a location to another location (calculation must be on a line/road path)
I'm using QGIS. I'm new.
I have a CSV file, with the source point (the_geom) and destination point (the_geom).
I have a road network already imported into PostGIS with pgRouting, and I need to have ...
1
vote
0answers
74 views
Didn't find route with pgRouting
I try to using pgrouting to find route, first I'm using assign_vertex_id and when I calculate the shortest route, i didn't find the route in my pgAdmin data output, and in the messages :
"row number ...
1
vote
3answers
132 views
Is it possible to change the projection used in OSM2PO?
Is it possible to change the projection used in OSM2PO? I used the following command to generate a SQL file which I loaded into my database:
java -jar osm2po-core-4.2.30-signed.jar prefix=at ...
1
vote
1answer
242 views
PgRouting: Driving_distance() or shootingstar_sp()?
I use OSM data imported into PgRouting database.
I developped a web application with a map to use OSM data.
I trace routes using shooting_star_sp() function.
For example, to have time cost between ...
1
vote
1answer
571 views
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(
...
3
votes
2answers
248 views
How can I identify oneways at pgrouting
I have set pgrouting and inserted my data with osm2pgrouting .
I would like to know how can I find out which way is one way.
Also I read that if I assign the reverse_cost of an one way to -1 only ...
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, ...
4
votes
2answers
275 views
Why is osm2pgrouting not importing?
I installed pgrouting successfully and did a little import with a 20Mb file. Works good!
Now I'm trying to import a file with the size of a country and it doesn't even start to import. The last 2 ...
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 ...
1
vote
0answers
66 views
Some help installing pgrouting_dd on mac os x
I hope someone may be able to help me but i've been grapling for hours trying to install pgrouting with Driving Time to no success. I have been able to build pg routing no problem.
However if i ...
4
votes
2answers
758 views
Is Shooting Star broken in PGRouting 1.05?
I'm using pgrouting DLL 1.05 with postgresql 9.1.
All required function installed.
Astar and Dijkstra work fine with sample data but "SHOOTING STAR" is not considering "reverse_cost".
Also if i try ...
2
votes
1answer
88 views
Is there a way to show the direction of a route?
I use pgrouting and openstreetmaps .I would like to know if there is a way to show the direction of the route on the map (eg something like this ---->---- or any other way,idea)
Thanks in advance.
2
votes
1answer
73 views
Relevant data for cost attribute to calculate route time
I have imported OSM data into PgRouting database.
I would like to use driving_distance() function to calculate route time.
How to add relevant time cost into database ?
Thanks
1
vote
0answers
30 views
Do any know another application like pgrouting? [duplicate]
Possible Duplicate:
Alternatives to pgRouting
I'm using pgrouting to generate routes over a network based on navteq information. It look like a good application but I would like to know if ...
2
votes
1answer
115 views
how do i know my pgrouting version?
Is there a way to know what version of pgrouting do 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 ...
4
votes
1answer
156 views
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 ...
1
vote
1answer
174 views
Problem with Pgrouting 1.5
Hi all and thanks in advance.
I have Postgis 2.0.1 and PgRouting latest version. I'm using osm2pgrouting to import OpenStreetMap data everything goes ok the trouble is that I always get source and ...
1
vote
0answers
56 views
Database has duplicate values after running pgrouting
I am a newbie with postgresql and sql statements so maybe it is a trivial question, I'm sorry for that.
I am working on a postgis database and try to use the pgrouting function. My goal is to store ...
4
votes
1answer
186 views
estimate travelling time for the route using pgRouting and OSM data
Could someone share with me some ideas or your experience how to estimate travelling time based on the provided route within pgRouting? The problem is that roads inside and outside cities have the ...
3
votes
2answers
313 views
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?
Thanks, Marko
1
vote
1answer
204 views
PgRouting Driving Distance crashing postgis server
I haven't used PgRouting much so I'm a little in the dark here. However, I am attempting a driving distance calculation like the one described by Underdark here.
My SQL is identical, I have a ...
1
vote
2answers
311 views
How to restart an osm2po service from a previous run?
I have followed underdark's clear and concise "how to" to get osm2po running. The web service is a great little tool for inspecting the data. Is there a way to restart the service using an existing ...
0
votes
0answers
180 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 ...
1
vote
0answers
78 views
Is this pgRouting perfomance acceptable for my tiny server?
I'm testing pgrouting functions in a tiny server with 2GB of RAM and a dual core processor.
I wrote a program that create client process and they connect to the server in a specific hour to perform a ...
2
votes
2answers
191 views
Reinventing the wheel: Public Transit System
I'm building a public transit service in South Africa, and I initially started the project on PHP and MySQL. I've managed to get far with the simple stack, with:
Routing algorithm in PHP
Data ...
1
vote
3answers
262 views
Why is pgRouting shortest route function complaining about wrong source and target IDs?
This question is somewhat linked to underdark post, but I think here it would more helpful:
https://underdark.wordpress.com/2011/12/18/osm2po-part-2-pgrouting-on-osm-the-easy-way/#comment-2636
I ...
1
vote
0answers
67 views
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 ...
1
vote
1answer
94 views
It is possible to add A* to the pgrouting plug-in?
I am using pgrouting layer plug-in as described in this post:
http://underdark.wordpress.com/2011/12/18/osm2po-part-2-pgrouting-on-osm-the-easy-way/
I am now able to calculate the shortest path using ...
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 ...
5
votes
2answers
1k views
How to get multiple shortest paths with PgRouting in one query?
I want to run shortest path algorithm on multiple source&target pairs at once and get a result as a table and process it then.
How do I do this? This query does not work:
SELECT a.source, ...
4
votes
3answers
935 views
How to make pgRouting faster?
I have table network which has about 2 million records (only 3 countries in Europe). When I run Shorthest-path it is very slow, it takes 3 min to take records only.
I tried with ...
2
votes
1answer
67 views
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 ...
8
votes
1answer
230 views
Which pgrouting workshop or tutorial is most current?
Please recommend pgrouting tutorials or workshops that are most current.
I ask because I just read a post that claims a tutorial is deprecated. (see osm2po vs osm2pgrouting: workshop post)
I am ...
5
votes
2answers
784 views
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?
3
votes
0answers
131 views
Shortest distance from pgrouting with cost not being length: optimal solution
I'm using pgrouting shortest_path_astar with a complicated cost function. It gives back the edges, vertices and costs.
I would like to get the total distance of this shortest path (i.e., the sum of ...
5
votes
1answer
251 views
Is PostGis suitable for Global data routing?
I'm searching quite some time now...
Is it possible to load the global routing data into PostGis?
What can I expect from a performance point of view?
It's for routing purposes only.
I've downloaded ...
0
votes
1answer
478 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 ...
1
vote
1answer
125 views
ERROR: type “geoms” does not exist. What version of pgRouting should I use for postgres 8.4 & postgis 1.5?
I am running this on windows 7:
Postgres 8.4
postgis 1.5
I installed pgrouting, but I am getting the error: ERROR: type "geoms" does not exist.
so my question is: which version of pgRouting should ...
1
vote
1answer
107 views
What is the difference between the astar_sp and shortest_path_astar functions?
I want to ask about what different of function :
"astar_sp" and "shortest_path_astar" ?
Do you think the query's result from both of them is same or different?
3
votes
1answer
479 views
How to get started with pgRouting and OSM?
I have followed these instructions to install postgresql and pgrouting on our ubuntu server:
...
