Converter and Routing Engine for Openstreetmap.

learn more… | top users | synonyms

3
votes
1answer
338 views

How to get different clazz/flags for roundabout?

I'm using osm2po to import Open Street Map data. I want to get information about roundabouts. In the final SQL file I need to know if a road is part of a roundabout or not. The only way to get this ...
1
vote
2answers
182 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 ...
1
vote
1answer
174 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 ...
4
votes
1answer
489 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 geofabrik. The data was imported correctly. When I execute a sample query in ...
0
votes
1answer
84 views

How to make osm2po 5.1 write an SQL file?

With osm2po 5.1, I can get the osm2po router running D:\osm2po-5.1.0>java -Xmx1024m -jar osm2po-core-5.1.0-signed.jar prefix=vie ..\vienna_austria.osm.pbf but the resuting vie folder only ...
1
vote
1answer
227 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
0answers
33 views

Adding Special Nodes to OSM Data for pgRouting

I am currently creating a system to route pedestrian to open areas. I used OSM data and osm2po to parse the data for pgRouting. Now, I want to create new nodes with an additional attribute or flag to ...
0
votes
0answers
38 views

Is it possible to convert osm2postgres table to pgrouting with osm2po?

I have already imported osm files with osm2psql in postgres. I would like to know if it's possible to convert osm data from this postgres table to pgrouting directly in the database with osm2po? Or ...
0
votes
1answer
22 views

SAXParseException in OSM2PO

I am getting the following error message when trying to utilise an osm pbf from the Geofabrik (latest Europe file): org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not ...
1
vote
1answer
90 views

Column osm_meta in osm2po 4.6.9?

What's the utility of osm_meta column in osm2po (Version: 4.6.9) generated data?
0
votes
1answer
25 views

My osm2po java program compiles but gives a runtime error

I need road distances and I'm trying to use osm2po to do this. After downloading the OSM files and converting them to gph format, using the osm2po program, I start at the very beginning with the ...
0
votes
1answer
36 views

osm2po traffic signals -128

Using osm2po to extract traffic signal in the vertices used to provide the value 1 in the clazz column of the vertex table: Add vertices costs to postgresql routable network For some reason I keep ...
0
votes
1answer
31 views

The format of the result TSP at OSM2PO

Good day! I use JavaScript to work with the program OSM2PO. I want to solve the problem of TSP. I need to get the order Vertex Ids and array waypoints in one query. Is it possible in the format Json? ...
0
votes
1answer
34 views

Adding detailled costs in osm2po

I want to improve my bike routing. I know, that I can change the "costs" by changing the speed in the config file, but for me it's not detailed enough. A small subset of my config file looks like ...
1
vote
3answers
1k views

How to speed up osm2po when using as java lib?

I'am trying to utilize osm2po as java lib for calculation of distances matrix between some set of points (lat/lon) and for each pair of points I call the following method that code is based on sample ...
0
votes
1answer
66 views

Parameters start_id and end_id when calling http://localhost:8888/Osm2poService?cmd=ft&tsp=

Good day! How to pass parameters start_id and end_id when calling http://localhost:8888/Osm2poService?cmd=ft&tsp=1,2,3,4,5?
1
vote
3answers
251 views

Why won't osm2po setup table correctly?

OK, I have no idea what's going on. I'm using a Mac and successfully installed pgRouting. I used osm2po on some data, which created a sql file. I imported the sql file into a pgRouting database and ...
0
votes
2answers
389 views

error while loading osm2po routing sql-script into PostgreSQL

please advice what could be wrong in my situation: I succesfully generated sql-file using osm2po I tried to run it within PostgreSQL and got the following error: ********** Error ********** ERROR: ...
0
votes
1answer
24 views

Speed limits osm2po

I ran into the problem, that in the US there are very different speed limits depending on each state. So using default values from osm2po.config does not really help (or am I wrong?). For some areas ...
1
vote
1answer
43 views

Extracting car-ferry routes with osm2po

I am building a routable network from OpenStreetMap using osm2po (v5.0.0). I would like to include ferry routes, but limit them to car ferries only. I am using the following config (excerpt): ...
-1
votes
1answer
77 views

I need detailed direction to use osm2po or osm2pgrouting

I am a very beginner with osm2po and osm2pgrouting. I read lots of materials (e.g., http://anitagraser.com/2011/12/15/an-osm2po-quickstart/) regarding these two software, but I can't even start how to ...
2
votes
2answers
89 views

I import map from file osm.pbf using osm2po. Why the low speed function call pgr_dijkstra in database Postgresql?

Good day! I import map from file russia.osm.pbf using osm2po. Why the low speed function call pgr_dijkstra in database Postgresql (>2 minute)? My steps: java -Xmx6g -jar osm2po-core-5.0.0-signed.jar ...
0
votes
2answers
197 views

Encoding error when importing to PostgreSQL using osm2po SQL file

After running osm2po on a pbf file for Europe I am importing the resulting files into a PostGIS and pgRouting enabled database. During the import psql it reporting many encoding errors because the ...
1
vote
1answer
405 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
1answer
58 views

Get all streets within a certain radius with osm2po

I'm trying to get all street segments out of osm2po graph, given a geo point and a certain radius. Right now I just do a breadth first search out of the street that's closest to my point, but is there ...
0
votes
1answer
36 views

Which OSM2PO method returns segment speed?

In OSM2PO, RoutingResultSegment has a getH() method - what values does it return? I was looking for a method that returns kmh, similarly to what is stored in the DB, but it doesn't seem like getH() ...
1
vote
2answers
1k 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
44 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 ...
1
vote
1answer
953 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 ...
2
votes
1answer
99 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 ...
0
votes
1answer
34 views

Get road type (clazz) is osm2po 5.0.0

I looked into using getFlags() for this as described here, Get road type (clazz) in osm2po but for some reason I'm getting 65551 instead of 15, and 65557 instead of 21. Seems like if I unset the 16th ...
0
votes
1answer
40 views

Importing map information with osm2pgrouting

I'm importing the cartography of Spain with osm2pgrouting. I want to import address information, that is, the tag addr = *. I modified the file mapconfig.xml follows: <type name="junction" ...
11
votes
4answers
758 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 ...
0
votes
1answer
67 views

Add columns with information OSM by osm2po?

I imported the europa.osm network within my spatial database thanks to the osm2po tool. I use this with pgrouting. My problem is that I need to know the information provided by the tag address (city, ...
1
vote
3answers
153 views

Getting route segments from OSM data and assigning ETA for them

I have a problem of assigning possible ETA for a route. So far, I have the following: OSM data for a city. I have open source data of taxi trails for the same city. Now, I am planning to divide ...
0
votes
0answers
46 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
1answer
99 views

Extracting restrictions with osm2po

I am trying to create a complex routable graph with osm2po. For this I need to extract relations (restrictions for example) and attach them to my graph. Does anyone know what I need to override/extend ...
0
votes
1answer
50 views

osm2po network access

How can i access osm2po Webservice in my local network? I can access http://localhost:8888/Osm2poService but if i try (on the same machine) to use the assigned ip adress with ...
1
vote
1answer
87 views

osm2po cycle routes

I'd like to use osm2po for a little bike routing planner. Is there a way I can mark those edges that are part of some national, regional or local bike network? It would be nice to give them a higher ...
0
votes
1answer
104 views

Getting all possible directions from a geo point in osm2po

Wanted to share some of my code I use to get all possible routes from a random geopoint in osm2po. Graph graph = loadGraph(); OverlayNode node = new OverlayNode(lat, lon); if (node.snap(graph, ...
0
votes
1answer
86 views

start osm2po without parsing osm.pbf

I use the demo batch to start osm2po java -Xmx1408m -jar osm2po-core-5.0.0-signed.jar prefix=hh tileSize=x,c map.osm.pbf How can i start the webserver without parsing all the data again (because i ...
0
votes
2answers
152 views

Find closest points in routing network for a set of points to pick shortest route

I have the following WITH SQL Query which does select a set of filling stations along a route within the distance of 1000m. In the SQL statement I fetch 1 Point from the station and search the closest ...
1
vote
1answer
95 views

Use osm2po to extract additional tags

We would like to improve our bike routing to also incorporate, for example, the information on the surface of the used streets. I don't quiet get how I should use the Osm2Po plugin in mechanism. I've ...
0
votes
1answer
53 views

osm2po street IDs

Is it somehow possible to always get the same IDs in the _2po_4pgr table and in the routing graph when it's run on newer version on the map? So if I ran it on OSM from today, and then on the same area ...
0
votes
1answer
95 views

Split OSM highways at vertice

I am looking for a tool or query to split the OSM highways into multiple segments. Each segment should only consist of two nodes (start and end). I should do the same as described in this GIS ...
0
votes
1answer
45 views

Change LineString type of Osm2Po edge and vertex file

Is it possible to change the linestring type from 2 to 3 dimensions in osm2po, and if so, how? Currently the generated table column looks like this: geom_way geometry(LineString,4326), but I would ...
2
votes
1answer
104 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 ...
1
vote
2answers
282 views

How to easily remove loose/isolated edges from pgRouting network?

I wondered if there's an easy way to 'clean up' a pgRouting network by removing those edges that do not connect with the global network. Otherwise you risk to end up with cost values of -1, meaning ...
1
vote
1answer
172 views

How to export a postgis table to a pbf file?

I need a tool like osm2po or osm2pgsql but that does the opposite thing, convert a postgis table to a pbf file. I think qgis can do this but I can't find that option.
0
votes
1answer
146 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 ...