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
1
vote
1answer
124 views

Different databases using different ways to export xml file

I tried to use different ways to get road osmid database, for same region. The bounding box of that region with north latitude, south latitude, east longitude, west longitude are equal to 30....
1
vote
1answer
22 views

Find every possible user to user travel time duration using pgr_dijkstra or pgr_kDijkstra

I have this below GetNearest function that will get every user's nearest node from ways (imported using osm2pgrouting). CREATE or REPLACE FUNCTION GetNearest(NUMERIC, NUMERIC) RETURNS BIGINT AS ...
1
vote
0answers
267 views

Given an array of OSM point IDs, how can I create a path of connected roads?

I'm writing a shortest route script in Python using geospatial data from a Postgres DB with PostGIS extension and pgRouting to make the points from OSM data. I have a path of OSM IDs by points. I ...
1
vote
1answer
32 views

Creating Isochrones - pgr_drivingDistance 2.6 SQL error

Im trying to create a matrix of driving distances from an osm2pgrouting parsed dataset. Following many blogs I have the below incorrect SQL: SELECT * from ways join ( SELECT * FROM ...
0
votes
0answers
26 views

Configure mapconfig.xml for null tag_value

I am using osm2pgrouting version 2.3.6. When using osm2pgrouting for .osm file, I created tables ways. However, when I compared it with table planet_osm_line, it lost a lot of line. I determined ...
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 ...
1
vote
2answers
838 views

PostGIS pgr_dijkstra function not finding node that appears in ways table?

I am having a problem with pgr_dijkstra algorithm not finding some of the node vertices in my table. I have a large dataset of survey travel diaries and am trying to determine their shortest paths ...
0
votes
2answers
68 views

Using original shapefile vs osm for routing in South Australia using pgRouting?

I'm looking at building a simple routing application using pgRouting. I'm running on Windows 10 at the moment but could migrate to Windows Server at some point. I'm trying to figure out how best to ...
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 ...
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 ...
0
votes
2answers
29 views

osm2pgrouting can't connect to postGIS

I want to do some isochrones with pgrouting, and I am failing in setting up the network in the first place. osm2pgrouting doesn't find my postGIS installation. Also, the error message is not very ...
0
votes
0answers
9 views

Seeking approach to simulate taxi on NYC map data? [duplicate]

I am new to GIS field. As part of my class project we want to simulate 100-1000 taxi agents on NYC map.We plan to write java application which fetches road network information and moves these agents ...
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 ...
0
votes
1answer
73 views

Using contextual information to plan route?

I downloaded the .osm map data, and I imported it to postgresql using the m2pgrouting. I have a CSV file on violence data, with three attributes, nature of occurrence, latitude and longitude. How do ...
1
vote
2answers
202 views

pgRouting not importing 'to_cost' values for osm2pgrouting?

I am struggling with the latest pgrouting & osm2pgrouting V2. The toolchain is installed on my server without any issues, I tried to install it from github and compile it - and I tried it from a ...
0
votes
1answer
121 views

OpenStreetMap to pgRouting missing attributes?

We are trying routing with pgrouting for our project but we noticed that NOT all the attributes we had in the row OSM data are in our database after we imported the data. we have checked in the ...
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 ...
0
votes
1answer
118 views

Handling relations with osm2pgrouting?

I'm trying to create a topology of the public transport in Paris. I use a OSM export, osm2pgrouting with the correspondent mapconfig.xml and Postgis. Everything works fine, except one thing. In Paris,...
0
votes
2answers
91 views

Getting closest node point (within 2km) from current location using pgrouting?

I'm very new to the GIS, and grasping the pgrouting function to see the possibles develop this feature. Basically I wanted to know all the next end points distance within 2KM from the current ...
1
vote
2answers
117 views

Dead-ends are connected by osm2pgrouting

I've downloaded an extent of OSM data with QGIS's OpenStreetMap downloader, and want to use this data for with pgRouting. I can load it without problems as: osm2pgrouting --f data.osm --conf ...
0
votes
2answers
79 views

Creating Drive Time Polygons Across State Boundaries Using OSM?

I am using pgRouting on OpenStreetMaps to create drive time polygons. The challenge is that at state boundaries, these polygons effectively stop, since the roads in OSM are segmented at the state ...
0
votes
1answer
181 views

How can I cluster a small area (say a circle of 20 meters diameter) in OSM to check the different node Ids in the area

I have a node ID(Say Z) which will be in the road/way. How do I find the node IDs around this point Z in certain radius.
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.
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 ...
0
votes
1answer
404 views

OSRM how to use my own map

I download a cartography bike from the open data data link to Postgres then I convert it to osm using: python ogr2osm.py "PG:dbname=x user=x host=localhost" --sql="SELECT * FROM bike_network" --...
0
votes
0answers
122 views

osm2pgrouting tables emtpy

When I use the osm2pgrouting I only get emtpy tables. I got my .osm file from this Wien.os.gz and use the mapconfig.xml from Github. I run the follwing command: ./osm2pgrouting -f path/Wien.osm -c ...
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 ...
1
vote
1answer
124 views

pgrouting OSM data with tolls

Is there any way to import the OSM data into pgRouting with the toll data? I already have a database with OSM data with topology, and working with pgRouting, but I need to add some nodes to it. I ...
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? ...
0
votes
1answer
370 views

Getting osm2pgrouting working

Using PostgreSQL 9.6 and osm2pgrouting 2.2 I am not able to let osm2pgrouting work. Starting from the command line, I get always some mistakes. I think I tried everything, and am getting a bit ...
0
votes
1answer
100 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" id="...
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 ...
1
vote
0answers
37 views

Getting base GIS files for use with pgRouting library

I'm just starting to read the tutorial for pgRouting and the first issue that troubles me is the origin of the "base map" to feed pgRouting with. I'm aware that there's available a tool called ...
1
vote
0answers
157 views

OSM_id missing from ways table created by Osm2pgrouting

GIS newbie here so excuse my ignorance if this has a simple answer. I have been playing about with pgRouting and using Osm2pgrouting to load OSM files from Geofabrik. However I just noticed that the ...
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 ...
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 ...
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 ...
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
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 ...
4
votes
2answers
380 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 ...
-2
votes
1answer
539 views

I need detailed direction to use osm2po or osm2pgrouting [closed]

I am a very beginner with osm2po and osm2pgrouting. I read lots of materials (e.g., http://anitagraser.com/2011/12/15/an-osm2po-quickstart/) regarding these two software, but I can't even start how to ...
1
vote
0answers
245 views

Importing OSM data to pgRouting enabled database including turn restrictions

I recently used the tool pypgroutingloader to import OSM data into a pgRouting database. For a small amount of data, this tool works perfectly. Most routing restrictions are present and it modifies ...
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 ...
0
votes
1answer
428 views

pgr_dijkstra function with geometry column in result

can you help me to edit my pgr_dijkstra function to required result? Currently I had this select: SELECT * FROM pgr_dijkstra(' SELECT gid AS id, source, target, cost, ...
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 ...
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 ...
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 ...
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, ...
1
vote
0answers
78 views

After loading osm data using osm2pgrouting how can I add my point data for kdijikstra

I have imported osm data to postgis by osm2pgrouting. Now I want to add point data of my locations, to find distance from one point to multiple points through the osm ways data. I am new to pgrouting. ...