A a converter and a routing engine for Openstreetmap data

learn more… | top users | synonyms

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 ...
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
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.
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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
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
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 ...
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
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
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
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
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, ...
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 ...
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 ...
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 ...
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
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?
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 ...
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 ...
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 ...
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 ...
0
votes
0answers
68 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
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?
0
votes
0answers
158 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 ...
0
votes
1answer
111 views

Does osm2po find routes of alternating modes e.g. car, ferry, car

I loaded europe-latest.pbf into osm2po using the default osm2po.config and java -Xmx8g -jar ../osm2po-4.6.9/osm2po-core-4.6.9-signed.jar prefix=eu tileSize=x,c ../europe-latest.osm.pbf and looked at ...
0
votes
1answer
195 views

Using pgr_drivingDistance with large ids

I have little experience with postgres and none with pgrouting. I'm trying to use the pgr_drivingDistance function with Open Street Map data (generated through osm2po), but whenever I run my query: ...
1
vote
1answer
154 views

OSM2PO Routing - reroute when traffic jam

is possible to force osm2po to reroute when traffic jam or other problem is detected on the route ? Or is it possible to tell osm2po routing to avoid some node/way even when it is best route ? thanks ...