Converter and Routing Engine for Openstreetmap.

learn more… | top users | synonyms

2
votes
3answers
158 views

How to get the nearest points from pgrouting linestring result?

I'm trying to get the points or landmarks nearest to the result of pgrouting linestring( the shortest path ). I'm using OSM map entities and working with planet_osm_point. Here's my code: SELECT ...
0
votes
2answers
47 views

Not able to create postgres Sql file using Osm2po

I am newbie to the GIS community. After downloading the osm2po jar file, I have run following the instructions from underdark tutorial. Also, from Carsten's answer in gis stack exchange, I have ...
0
votes
2answers
55 views

successful import of osm2po results

I would like to know if my import of some osm2po results into a PostgreSQL database have been successful or not. Is there something like: 'Import successful' or a simple 'Done'? All I got was: ...
4
votes
1answer
571 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 ...
2
votes
1answer
219 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 ...
1
vote
1answer
102 views

OSM2PO Postgres to graph for A*

I have created a directed graph from the nodes stored within my Postgres db but the resulting graph doesn't seem to be fully connected and as a result my shortest path algorithm is not able to find a ...
1
vote
1answer
65 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): wtr....
0
votes
1answer
33 views

osm2po highways and surfaces

Is it possible in osm2po to additionally consider surfaces as edge weights along with the highways? I've tried the following: wtr.tag.highway.pedestrian = 1,1,5, foot wtr.tag.highway.footway = 1,1,...
0
votes
1answer
35 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
36 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 I'...
0
votes
1answer
185 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
104 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. ...
2
votes
0answers
43 views

Cannot parse walking routes in Osm2po

I really am at a loss with trying to figure out how to parse only walking routes using OSM2PO. I've modified the config file to add foot to the routes which can be walked along, as follows: wtr.tag....
1
vote
0answers
164 views

How to use OSM2PO for transit routing?

I'm using OSM2PO (4.6.9) for "classic" routing, I mean highway network and everything works fine. Now, I want to use it to route in a "transport" network, a bus network for instance. But I want the ...
1
vote
0answers
70 views

how to group interconnected edges inside a table?

Given a table and a random set of edges with source and target columns, how can I find out which edges connect with each other and then group them together using PostgreSQL?
1
vote
0answers
49 views

given sets of vehicle passing on each edge, how to get most used vehicle to avoid transition?

I have two tables: one, the resulting table from converting osm.xml via osm2po so I can use pgRouting, and another one that contains information on what edges each public vehicle passes through (|...
1
vote
0answers
135 views

Graph of a specific area of USA

I am trying to get the network graph of a specific reason of USA. I have got a couple of options. One of them is using osm2po tool to extract the nodes and edge table from the osm map of a specific ...
0
votes
0answers
57 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
0answers
45 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
52 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
0answers
66 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
0answers
127 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
0answers
178 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?
0
votes
0answers
75 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
0answers
257 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 osm2po-core-4.7.7-...