Converter and Routing Engine for Openstreetmap.

learn more… | top users | synonyms

1
vote
2answers
151 views

Is there a way to keep toll_booth nodes in osm2po's output?

I am writing a code that performs a custom routing on the sql relation generated by osm2po. Amongst several other things, I need to detect if the selected route (list of ids) passes through one or ...
2
votes
1answer
79 views

Solving java.lang.RuntimeException: No osm2po-GraphFile?

I tried to use osm2po as library and to write a simple routing program based on the sample code listed in (http://osm2po.de/) However, when I try to load the .pbf file into the data structure ...
2
votes
1answer
381 views

pgRouting 2.0 slow execution of A star algorithm

Recently, I wanted to test pgRouting ver. 2.0. I created the database structure with osm2po and imported UK map from http://download.geofabrik.de/europe.html. The data was imported correctly. When I ...
1
vote
1answer
116 views

Removing pseudo nodes from PostGIS database using ST_ModEdgeHeal()?

I have used osm2po (5.0.0) and its autogenerated SQL file to load some 25% of Europe.osm.pbf as a network table into my PostGIS database. I have also created an associated nodes table with select ...
0
votes
1answer
123 views

How do I create a new vertex in the middle of an edge in postGIS?

I have a postGIS database populated with OSM data with the osm2po import tool. I have a number of fixed points that I want to route between using pgrouting. In order to do this accurately, I want to ...
0
votes
1answer
103 views

Repair topology before pgrouting / No results of pgrouting

My goal is to calculate lots of distances along the streets. I followed http://workshop.pgrouting.org/ tutorial except that I used osm2po instead of osm2pgrouting to import osm file. The only problem ...
0
votes
1answer
56 views

ST_Intersects returning incorrect result on routing problem

I have a table that contains the shortest path between destinations for survey respondents on an osm2po created network. When calculating the shortest path result, I store the geometry in a column. ...
2
votes
0answers
89 views

How to get the nearest points from pgrouting linestring result?

I'm trying to get the points or landmarks near from the result of pgrouting linestring( the shortest path ). I'm using OSM map entities and working with planet_osm_point. Here's my codes. SELECT ...
1
vote
0answers
13 views

osm2po to import whole planet

My point is to use pgrouting with planet data. osm2pgrouting fails at importing whole planet, so I tried osm2po. Looked fine, it generated sql file in around 2,5h. After importing it to the db though ...
1
vote
0answers
143 views

How to use OSM2PO for transit routing?

I'm using OSM2PO (4.6.9) for "classic" routing, I mean highway network and everything works fine. Now, I want to use it to route in a "transport" network, a bus network for instance. But I want the ...
1
vote
0answers
68 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
48 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 ...
1
vote
0answers
128 views

Graph of a specific area of USA

I am trying to get the network graph of a specific reason of USA. I have got a couple of options. One of them is using osm2po tool to extract the nodes and edge table from the osm map of a specific ...
0
votes
0answers
19 views

Osm2po missing some streets in SF

I recently used osm2po (v 5.0.0) on SF with these parameters: java -Xmx8g -jar osm2po-core.jar cmd=tjspg prefix=sf tileSize=x california-latest.osm.pbf and everything looks great in the whole city ...
0
votes
0answers
32 views

OSM2PO get all nodes included in a segment

We have been working with osm2po tool to load data to a Postgis Database. We would need all the nodes included in a segment not just the source and target node. Is there any way to change the ...
0
votes
0answers
75 views

Query for finding nearest distance and driving time from objects in a different tables

I have 4 postGIS tables: employees_wgs Facilites and (created by osm2po): at_2po_4pgr at_2po_4pgr_vertices_pgr What I want to do is: make a query to populate two columns in "employees_wgs" ...
0
votes
0answers
55 views

How to get the public transportation in Osm2po?

I'm developing a app guiding users to their destnation by public transportation.I need to use Osm2po to transfer osm data to sql, which including public transportation data.So how can i achieve it? Do ...
0
votes
0answers
100 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
129 views

Is it possible to load multiple OSM regions in osm2po?

I need to use a few smaller European countries (100MB). Is it possible to do this in osm2po? Or can some other tool be used to merge the maps into one pbf file?
0
votes
0answers
73 views

Adding countries to database using osm2po one by one

Is it possible to import countries into postgresql using osm2po one by one, mean not whole europe at once but split and import it by countries to lower load, increase speed etc.
0
votes
0answers
199 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 ...