Converter and Routing Engine for Openstreetmap.

learn more… | top users | synonyms

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 ...
0
votes
0answers
39 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 ...
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
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
37 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 ...
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 ...
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
votes
1answer
78 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
90 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 ...
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
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() ...
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 ...
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" ...
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
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
3answers
154 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
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
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, ...
1
vote
1answer
96 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
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
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 ...
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 ...
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
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.
2
votes
1answer
254 views

What does the values in column clazz (osm2po) mean?

I have a given table in postgreSQL with OSM data which is used for routing purposes in Java with PGRouting. There exist two columns which I don't understand. They belong to osm2po. They are labeled ...
0
votes
1answer
72 views

How to configure osm2po to use maxspeed:seasonal:winter if available?

In Finland, the speed limits on some roads are different in the winter. These roads are usually tagged with maxspeed:seasonal:winter in OpenStreetMap. Is there a way of configuring osm2po to use the ...
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 ...
1
vote
1answer
338 views

Calculate shortest path between each lat/lon point in one table and each lan/lon point in another in Postgresql

I have two tables, both of them have only 2 columns. The first one contain only latitude and longitude coordinates of my source points and the other one only latitude and longitude coordinates of my ...
2
votes
0answers
117 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 ...
2
votes
2answers
246 views

How to create more networking osm

Using localhost page generated by osm2po roteamente noticed that the link is made to link even disabling snapping. Logically thought to create more nodes in the network, but how can I do this ...
1
vote
1answer
289 views

How do osm2pgrouting and osm2po differ in their ways creation?

How do osm2po and osm2pgrouting differ in their algorithms for creating their ways table ? I've seen significant differences between their processing of the same osm extract. Processing the same ...
2
votes
1answer
441 views

How to generate pgrouting source and target with OSM?

Is there anyone here can explain me more details for pgrouting's source and target? I'm wondering how to generate with the given lonlat in OSM PostGIS entities. In pgrouting's website, they are ...
1
vote
1answer
115 views

How to configure osm2po to ignore certain class types?

I'm trying to import data using osm2po but am only interested in driving distances, so I'd like to omit all footway, cycleway, steps, etc. in the imported dataset. How can I configure osm2po to do ...
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 ...
0
votes
1answer
80 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. ...
1
vote
3answers
287 views

Generating a routing database for the entire world while keeping the tags

I've been looking into this matter for a few days now, but I haven't come up with a working solution. Basically, what we are trying to do is create an entire world database, preferably in PostgreSQL, ...
0
votes
1answer
66 views

Improving speed on pgRouting on table update with many rows: faster to loop on each row than a table update call?

I am updating thousands of rows in a survey table finding shortest path from each place a survey respondent visits. My code below is the query I use to update the blank route column. The function ...