Tagged Questions
1
vote
1answer
188 views
Unreachable vertex
I'm developing an application for academic purposes that mainly gives to the user a recommended itinerary for a previously introduced preferences (Gastronomy, Leisure,etc.).
For this purpose, I use ...
1
vote
2answers
81 views
How to change the function of cost of osm2po?
As the column 'kmh' shows speed limits wrong for my city, and I didn't want to modify the configuration file of osm2po for each type of road, is there a way to change the cost function? I wish:
cost= ...
4
votes
1answer
88 views
finding routes just for cyclists
I have created a PostGIS DB using osm2po and I am using pgrouting to calculate the routes.
The application I am creating should find routes for cyclists so I want the route finder to prefer roads ...
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?
1
vote
0answers
39 views
given sets of vehicle passing on each edge, how to get most used vehicle to avoid transition?
I have two tables: one, the resulting table from converting osm.xml via osm2po so I can use pgRouting, and another one that contains information on what edges each public vehicle passes through ...
2
votes
1answer
55 views
turn osm2po vertex table restrictions column into turn cost for shooting star pgrouting?
i found this thread
Does OSM2PO take into consideration turn restrictions?
but im kind of new to sql and database so me, making my own query or sp to achieve the above suggestion by myself is kind ...
3
votes
2answers
97 views
How Does Directed and has_reverse_cost Arguments when set to [true, false] and [true, true] Affect Routing?
What will be the difference on the routing behaviour when I try to play with the directed and has_reverse_cost arguments on all the three routing algorithms?
Example: the following SQL queries give ...
1
vote
1answer
95 views
Do vertex IDs stay the same every time I run osm2po?
Does anybody knows if vertex (source, target columns) in osm2po tables are always the same?
I have my dr_2po_4pgr table with routing data and dr_matrix with routes already made. In this table I have ...
1
vote
1answer
151 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
146 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 ...
9
votes
3answers
354 views
How to add offsets to the route?
Edited:
I want to ilustrate my question. Suppose that you're in "Point A" and want to go to "Point B". This points wouldn't be in "at_2po_4pgr" table cause aren't source/targets nodes.
Then, I ...
1
vote
3answers
140 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 ...
2
votes
2answers
442 views
How to find the Shortest Path between two coordinates points using pgrouting A-Star?
In PostGIS I have two tables: an osm road network and a table that contains the start and end coordinate points of each path (i.e. userid, start_x1, start_y1, end_x2, end_y2). I would like to know:
1) ...
1
vote
3answers
266 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 ...
2
votes
2answers
112 views
What is geom_way column in osm2po generated data?
Could anybody tell me the meaning of geom_way column generated by osm2po?
0
votes
1answer
485 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 ...
5
votes
1answer
252 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 ...
3
votes
1answer
263 views
How to create a QGIS road style for OSM data?
I am trying to use qgis to visualize the shortest path algorithm's result. I managed to import the osm map into qgis
But I think it looks kind of different. I was referring to this link and she ...
1
vote
1answer
129 views
Interpreting the geom_way in the table created using osm2po [duplicate]
Possible Duplicate:
Issues while plotting the results of pgRouting shortest path
I am trying to actually figure out what this column exactly represents and how to use that in my case. I ...
1
vote
1answer
249 views
How to get travel time and link used from osm2po http service
I used osm2po to get shortest paths but I would like to get travel time and osm links ids used in the path. Is it possible?
Here is the osm2po service url format I use (this is an example):
...
1
vote
2answers
313 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 ...
