Questions tagged [osm2pgrouting]

osm2pgrouting is a command line tool that allows to import OpenStreetMap data into a pgRouting database.

Filter by
Sorted by
Tagged with
22
votes
4answers
6k views

How can I optimize pgrouting for speed?

I am using pgrouting on a postgis database created through osm2pgrouting. It performs very good on a limited dataset (3.5k ways, all shortest path A* searches < 20 ms). However since I have ...
13
votes
2answers
7k views

Performing route analysis in R based on OSM transport network?

I'm analysing the likely paths taken by commuters on their way to work, based on Census flow data, job density distributions and the transport network. At the moment I'm using pgRouting and the ...
11
votes
2answers
2k views

Is there a way to add turn restrictions in A* and Dijkstra?

We are currently working with pgRouting and found that there's no way of implementing turn restrictions (e.g. banned right or left turns). While it is possible to assign "to_cost" and "rule" in ...
10
votes
1answer
8k views

Computing Walking and Cycling Isochrone maps using QGIS & pgRouting?

Just installed QGIS as I believe I should be able to produce walking and cycling isochrones from a specified point. I have done this pretty easily before using ArcMap, however, I am really struggling ...
7
votes
3answers
13k views

How to extract primary and secondary roads from OSM data?

After importing my country roads from OSM data, I need to create a network ( roads connecting big cities ) for use with pgRouting. For this, I need the green, blue and red ones (http://www....
5
votes
1answer
6k views

What is a Multilinestring?

What is multiline string in gis? I have found when I use pgrouting certain edges have this geometric property mentioned as multiline string. I am not sure what's the purpose of this geometry and how ...
5
votes
1answer
466 views

Is PostGis suitable for Global data routing?

I'm searching quite some time now... Is it possible to load the global routing data into PostGis? What can I expect from a performance point of view? It's for routing purposes only. I've downloaded ...
5
votes
1answer
655 views

Using OSM data, pgRouting, and dummy data to develop an origin/destination travel matrix

Further to my previous question I was wondering if it is possible to add dummy node data without to do routing analysis. ISSUE I have a polygon layer that represents zonal attributes I created a ...
5
votes
1answer
369 views

osm2pgrouting stuck (showing classes table created) when importing an osm file

I am trying to import an osm file using osm2pgrouting. while following the pgrouting workshop. (file is 700mb~) im running ubuntu 12.04 on m1.large on amazon. the same file was successfully upload ...
4
votes
1answer
4k views

How to install osm2pgrouting on Windows?

I've only done networking using ArcGIS, but am now trying to set up with OpenSource software in a Windows environment. I have PostGIS installed and found a Windows binary for pgRouting (although I'm ...
4
votes
3answers
2k views

How to import OpenStreetMap data into GraphX?

How to import OpenStreetMap data into a Spark GraphX RDD? Would like to see feasibility of doing drive-time analysis in our own Spark cluster. Thought to use osm2pgsql or a similar project, but not ...
4
votes
2answers
379 views

Using pgRouting for 'multiple pedestrians' on an existing table of 'students'?

I'm trying to use the pgRouting sample for 'multiple pedestrians going to the same destination' to determine the 1) length and 2)geometry of students to their schools. Essentially I'm trying to write ...
4
votes
2answers
567 views

pgr_createTopology - how tolerance?

I've proceed by this tutorial to create routing topology: Create a Network Topology They are using osm2pgsql tool for import data and next call pgr_createTopology function. When I proceed step by ...
4
votes
1answer
1k views

Transit routing using pgrouting as core routing engine?

I'm a student and I'm working on a project. The aim is given two sets of coordinates (origin & destination) route through the map to determine the optimum path using public transportation and of ...
4
votes
2answers
720 views

Why is osm2pgrouting not importing?

I installed pgrouting successfully and did a little import with a 20Mb file. Works good! Now I'm trying to import a file with the size of a country and it doesn't even start to import. The last 2 ...
4
votes
0answers
113 views

pgr_drivingdistance seems to be excluding nodes that should fall within the cost parameters set

I am getting a result that I don't understand and I am not sure if its my lack of understanding of OSM. I am using the pgrouting functions pgr_drivingdistance to get the list nodes reachable within ...
3
votes
2answers
598 views

Keeping up to date with OSM changes in pgRouting

I'm working on a routing application using OSM and pgRouting. I'm only interested in a subset of data, mostly North America (performance was difficult for large amounts of data, so don't want to use ...
3
votes
1answer
97 views

pgrouting - Choosing an algorithm with a predominance for a specific type of road

I would like to use one of pgrouting's algorithm to find the (shortest) path between 2 points with predominance for a specific type of road. To build the data I used the osm2pgrouting. Is there an ...
3
votes
2answers
922 views

How can I identify oneways at pgrouting

I have set pgrouting and inserted my data with osm2pgrouting . I would like to know how can I find out which way is one way. Also I read that if I assign the reverse_cost of an one way to -1 only ...
3
votes
1answer
758 views

How to connect PostgreSQL from osm2pgrouting

I am using OSGeo Live. It is an Ubuntu system. I installed it in my PC. I was following one pgRouting workshop. https://workshop.pgrouting.org/index.html In one step, I needed to connect ...
3
votes
1answer
489 views

Is there an open source directions webclient for pgRouting like the directions API from Google?

I am looking for an open source webclient with (Google) directions functionality (like draggable lines to create extra waypoints) based on an pgrouting database (with an osm2pgrouting topology). I ...
3
votes
1answer
49 views

osm2pgrouting creates erroneous roads

osm2pgrouting works without giving any errors but most of the roads have lost their geometry. Result is ; What I've done so far; OSM Data downloaded from http://download.geofabrik.de/ in pbf ...
3
votes
0answers
60 views

Installing external software for QGIS Plugin

I'm wondering if anybody has experience in installing external software for QGIS plugins. I am developing one and I feel like I have hit a wall. I need to use osm2pgrouting, but it is written in C ...
3
votes
0answers
443 views

From pgRouting shortest_path back to osm node id

I'm successfully performing path finding queries like shortest_path on data imported with osm2pgrouting. The tables I have inside my pgrouting DB are the following: List of relations ...
3
votes
0answers
1k views

Is there a way to start the route on pgrouting from a coordinate that is not a node?

After execute all steps from this pgRouting tutorial, now I have a map that creates and displays routes, but as the routing methods rely on parameters representing vertex Ids that was created using ...
2
votes
1answer
199 views

How can I get the length of segments from the output of pgr_dijkstra?

I created a topology from OSM data with osm2pgrouting. I use a very simple Query SELECT * FROM pgr_dijkstra(' SELECT gid AS id, source, target, cost_s AS cost, ...
2
votes
1answer
1k views

How are cost and reverse cost computed in pgrouting?

I downloaded the nyc osm metro extract from Mapzen. I then used osm2pgrouting to import that data into postgis, pgrouting and now I have all these columns cost and reverse_cost, but I'm not sure how ...
2
votes
1answer
121 views

Temporary additions to OSM data

I'm planning on building a transportation related GIS App. In the app, users will be allowed to add their own links to the network. For example, let's say a user wants to add a "driveway" in front of ...
2
votes
2answers
299 views

How to calculate only walking routes?

I am using osm2pgrouting to import data to my PostGIS database from OSM and I was wondering if there is some way to specify to pgRouting to calculate paths with only ways that can be walked by people? ...
2
votes
2answers
1k views

osm2pgrouting command not found

I have installed osm2pgrouting on my Ubuntu 12.04 server with the following code from this tutorial: sudo add-apt-repository ppa:georepublic/pgrouting-unstable sudo apt-get update sudo apt-get ...
2
votes
2answers
2k 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 ...
2
votes
1answer
1k views

troubles with osm2pgrouting

I'm trying desperately to write my first query in pgRouting using maps in osm format (as shown in http://www.carsonfarmer.com/?p=799). Im using Ubuntu 10.10 with Postgresql 8.4 ang postgis 1.5. After ...
2
votes
1answer
158 views

pgRouting from geocoded user input

have created database by tool osm2pgrouting. On my website can user enter start and end point. How can I find ids of nodes? Because I have only text value of nodes which enter user, but tables ...
2
votes
1answer
378 views

Error while installing osm2pgrouting Ubuntu14.04

I'm trying to install osm2pgrouting. I have installed all the required packages and I also have changed the #include "libpq-fe.h" to #include postgresql/libpq-fe.h" in the src/Export2DB.h. However ...
2
votes
1answer
70 views

How to restrict level crossings in route?

I want to evaluate if it is useful to bypass a level crossing through a nearby tunnel or overpass when the LC is closed or if it is worth waiting. I want to use the OSM data for realistic scenarios ...
2
votes
1answer
1k views

Using osm2pgsql data with pgrouting 2.0

I have successfully manage to make the workshop from of pgrouting (wrote for v1) with pgrouting v2. Now I want to use pgrouting 2 on my postgis database created with osm2pgsql. The problem is first ...
2
votes
1answer
546 views

osm2pgsql finishes processing without creating vertices_tmp table

I am using postgresql 9.1 database with posgis installed. I also have pgroute installed on same database. I am trying to use osm2pgsql tool to import data for routing. But osm2pgsql tool finishes ...
2
votes
0answers
137 views

Weird (longer) route from using cost_s as cost in pgRouting?

I am currently developing application that want to use the fastest time to arrive as parameter for the routing. And i know that pgRouting has 'cost_s' column which calculated from length_m and ...
2
votes
0answers
57 views

Routing for specific subjects (cars, pedestrians, ..) dynamically

I need create app which will be provide routing for specific category. For example only for cars, only for bikes or only for pedestrians. For importing OSM data I'll used default mapconfig for all way ...
2
votes
0answers
32 views

Osm2pgrouting - edit final route

I've imported my data to database by osm2pgrouting. This tool created network topology which contains vertices and edges between them. Problem is when I need get route to specific point which is not ...
2
votes
0answers
92 views

Exported OSM database do not contains node names

I've used osm2pgrouting tool to export data from osm file to my postgresql database. Now I have database with this schema: osm_node: -node_id -osm_id -lon -lat -numofuse -the_geom ...
2
votes
1answer
746 views

How can I find route between two points over pgrouting? [closed]

I have imported osm file to postgresql with this table schema(under question). I used osm2pgrouting tool to create this. How can I find route between two points (for example between NY and Detroid). I ...
2
votes
0answers
478 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
3answers
182 views

Strange results in pgRouting

I get results using pgRouting I cannot explain. I created a topology using osm2pgrouting. I then want to find the shortest way through this topology, for someone walking on foot. To calculate the ...
1
vote
1answer
67 views

PgRouting Obtain RoadNetwork data from osm file

I am trying to obtain road-network data from OSM file using pgrouting and for this I am following this tutorial: http://workshop.pgrouting.org/ The format I am looking for is following(bidirectional)...
1
vote
2answers
73 views

osm2pgrouting fails with “cannot open”

I try this code: cd osm2pgrouting file http://.....com/veriler/andorra.osm conf mapconfig.xml dbname postgres username postgres dbname, username and web address are correct. But it gives an error.
1
vote
1answer
362 views

osm2pgrouting --> option '--conf' cannot be specified more than once

I'm attempting to import some OSM files using osm2pgrouting via command line on a windows 10. When I specify the mapconfig.xml with the -c switch, I am getting the following error: option '--conf' ...
1
vote
1answer
82 views

unknown parameter: -conf Error in osm2pgrouting

I was just going through the following tutorial HERE. I have extracted all the files succesfully using the below commands: cd ~/Desktop/pgrouting-workshop/ tar -xvzf data.tar. But when i run the ...
1
vote
1answer
595 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 ...
1
vote
1answer
379 views

can I add additional data to an existing pgrouting postgis database using osm2pgrouting?

This is just a simple question but I could not find the information in the documentation. If I have an existing pgrouting database table named routing, can I add additional OpenStreetMap data to this ...