Converter and Routing Engine for Openstreetmap.

learn more… | top users | synonyms

1
vote
1answer
31 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
25 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
1answer
76 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
70 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
23 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
26 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
47 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, ...
0
votes
1answer
36 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
106 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
38 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
80 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
39 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
76 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
65 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
89 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
76 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
49 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
101 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 ...
0
votes
1answer
160 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
128 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
91 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
36 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
89 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
83 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
101 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
152 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
70 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
117 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
229 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
95 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
220 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
245 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
336 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
98 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
198 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
64 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
217 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
59 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
93 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
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
2answers
403 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
115 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
172 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
330 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
42 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
46 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
34 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
133 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
92 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: ...
2
votes
1answer
413 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 ...