A a converter and a routing engine for Openstreetmap data

learn more… | top users | synonyms

1
vote
2answers
110 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 ...
0
votes
1answer
62 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
22 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 ...
1
vote
1answer
272 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 ...
0
votes
0answers
24 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" ...
2
votes
1answer
47 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
90 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
44 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
64 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
52 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 ...
2
votes
1answer
62 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 ...
3
votes
3answers
318 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
89 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 ...
1
vote
1answer
127 views

How can I relate the osm2po osm_source_id to data in OpenStreetMap?

I created and imported OpenStreetMap (OSM) data into Postgres using osm2po: e.g. java -Xmx8g -jar osm2po-4.6.9/osm2po-core-4.6.9-signed.jar config=osm2po.config.eu_xc prefix=eu tileSize=x,c ...
2
votes
0answers
58 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
134 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
119 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
131 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
63 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 ...
0
votes
1answer
46 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
148 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
3answers
225 views

Faster routing algorithm on pgrouting [duplicate]

I have downloaded data for india as a dbf file then converted it using osm2po to make it routable but the problem is when i make any routing query it takes a lot of time around 300 seconds and these ...
0
votes
1answer
43 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 ...
0
votes
3answers
114 views

How to extract shape of each segment?

osm2po library does a great job in creating the data required by pgRouting to calculate theshortest paths. But I need the shape (Geometry - LineString 4326) to be extracted when osm2po generates the ...
0
votes
1answer
79 views

osm2po is missing edges while importing to pgrouting

I am using osm2po for importing pbf file to postgresql but when i find route using built-in algorithms i found that some of the edges are missing so route does not match with road. Did anybody know ...
1
vote
2answers
903 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 ...
0
votes
0answers
43 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
2answers
222 views

creating isochrones in postgis/osm2po/pgrouting and then saving the isochrones as polygons

So I am creating some isochrones in pgrouting based upon a table from osm2po. Now I have a query that will get all of the edges that are c driving distance away from a point. My question is, how can I ...
0
votes
1answer
87 views

osm2po errors when converting pbf file

I am trying to prepare OpenStreetMap data for routing. I have downloaded version 4.8.8 of osm2po. I also downloaded north-america-latest.osm.pbf from Geofabrik. The command I am running is: $ java ...
0
votes
2answers
128 views

Osm2po : Querying generated table to get the closet line from a point

I generate the OSM data of Africa postgis and I want to launch queries for a list of gps points to project them into the closest line. I made this request to a single point but took around 3 ...
0
votes
1answer
38 views

osm2po: access values of maxweight tag

What is a best way to access osm's maxweight tag value to be able to use it in edge router? Basically my goal is to overwrite EdgeRouter's calcEdgeCost and check there if given edgeIdx has maxweight ...
0
votes
1answer
40 views

null pointer Exception in osm2Po

I am tring to use OSM2PO on Windows 7 but nothing works. I have JAVA Already installed. When I launch the command java -jar osm2po-core-4.7.7-signed.jar prefix=at "USTHB.osm" I get this : ...
1
vote
0answers
26 views

Creating a .shp with OSM and import it to POSTGIS [closed]

Any suggestions ? I can't launch osm2po I don't know why, when I click on the jar file, nothing happen :p
0
votes
1answer
91 views

How to use osm2po to solve TSP

I've got a TSP to solve. I created a routable street graph using osm2po and imported the result to PostGIS. On my PG db I installed the pgrouting extension (over PGAdmin3 GUI --> right click ...
0
votes
1answer
62 views

How to configure osm2po to use the specified maxCost in TspDefaultMatrix

The problem I am using osm2po's TspDefaultMatrix to create a cost (time) matrix: new TspDefaultMatrix(graph, vertexIds, maxCost, Log.stdout(Log.LEVEL_LOG), properties) Where properties contains: ...
1
vote
1answer
101 views

How can I use osm2po to calculate distance matrix in Km?

How can I use osm2po to calculate distance matrix in Km? There is an example that calculates distance matrix in time but I cannot make it turn into kilometers. I dont understand how should I use the ...
0
votes
1answer
68 views

Graph.traverse() maximum targetIds?

First of all, huge thanks to Carsten for writing this amazing tool. I love it. I am using the function traverse(Graph graph, int sourceId, int[] targetIds, float maxCost, ...
3
votes
1answer
101 views

Add vertices costs to postgresql routable network

In osm2po it's possible to create custom routers as the sample router TrafficSignalsRouter, but the costs seem to be added on vertices after the routing. Is it possible to add these costs on the ...
0
votes
0answers
89 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 ...
1
vote
2answers
98 views

Where can I find osm2po javadoc

I would like to build an offline routing engine to compute route distance between two coordinates. I found osm2po but I didn't found any sort of documentation. As far as i understood osm2po can be ...
1
vote
3answers
746 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
85 views

How can a truck network be built / extracted using osm2po?

Is it possible to adjust the config of osm2po to build a truck / lorry (in German: LKW) network?
1
vote
1answer
73 views

Can't get osm2po to work

I have downloaded osm2po 4.7.7 but when trying to follow the instrutions in either the documentation but I'm not able to access the map in my browser on http://localhost:8888/Osm2poService. What I ...
2
votes
1answer
232 views

Routing with osm2po - starting from middle of the street

I'm currently looking at using osm2po's java library to build a simple application that builds a shortest path between my favorite bars :) However, I'd like to start at any location, not at an ...
0
votes
1answer
172 views

osm2po Java API documentation

I would like to get started writing a custom TagResolver, and I'm fairly unexperienced in Java. Is there a osm2po Java API reference somewhere for the 'Default' classes (DefaultJoinInterceptor, ...
0
votes
0answers
113 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?
3
votes
3answers
380 views

How to extend OSM2PO with ferry durations?

I would like to have the ferry duration [1] taken into account, when transforming OSM files to SQL. But I'm not sure if I need to write my own waytagresolver, or it is possible to simply add it to ...
1
vote
1answer
189 views

osm2po: import multiple .osm files for disparate regions?

Does osm2po support importing multiple OpenStreetMap files into the same Postgres/PostGIS database (i.e., to be used for routing)? If yes, can the OSM files be for geographic regions that are not ...
0
votes
1answer
204 views

How to correctly convert data from OSM with osm2po to use it with A* algorithm?

I want to make my A-Star fast, by using heuristics. At the moment it is very slow and even slower than my Dijkstra. I thougt A-Star is in the worst case as fast as Dijkstra. I convert my OSM bounding ...
5
votes
2answers
573 views

Why is any pgr_* routing function taking forever based on OSM data in an pgrouting enabled DB

I loaded the German OSM dataset into the pgrouting DB by using osm2po 4.7.7. Everything works fine i have osm2po set up via it's config and it's working like a charm through it's Java part. I had the ...