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
0 votes
0 answers
6 views

Finding the shortest path length between two coordinates using pgRouting [duplicate]

Given two pairs of latitude and longitude, how can I find the length of the shortest path, traveled by car? Following the instructions and tutorials from OpenStreetMap, pgRouting, osm2pgsql, ...
user avatar
  • 111
1 vote
1 answer
54 views

pgRouting ways table attributes description

I've imported an extract of OSM data for my region of interest to Postgresql using osm2pgrouting 2.3.6 in Linux, using mapconfig_for_cars.xml configuration file, and I've found that it created tables ...
user avatar
2 votes
1 answer
52 views

pgRouting: How to get other edge attributes

I have imported some OSM data in a PostGIS database (using osm2pgrouting) to use with pgRouting. I use Python to send the SQL queries. It works fine, however I noticed that the result includes many ...
user avatar
  • 55
0 votes
1 answer
100 views

osm2pgrouting how to configure mapconfig.xml file

I need to customize mapconfig.xml file. I have to do bike routing so I start with mapconfig_for_bicycles.xml https://github.com/pgRouting/osm2pgrouting/blob/master/mapconfig_for_bicycles.xml This ...
user avatar
  • 471
4 votes
1 answer
135 views

pgr_dijkstra is considering one-way streets as bidirectional

I imported data from a map extracted from OpenStreetMap. With osm2pgrouting I imported it into PostgreSQL, to be worked with pgRouting and PostGIS. Command used: osm2pgrouting -f DIRECTORY/map.osm -d ...
user avatar
3 votes
1 answer
192 views

osm2pgrouting ERROR: relation "__ways****" does not exist

I'm using osm2pgrouting. It works for small datasets very well but when I run it on a large dataset, it start good but after some processing like 40% it starts giving following error [*****************...
user avatar
  • 995
1 vote
0 answers
52 views

TSP function with pgrouting

I'm trying the TSP function with pgrouting with just a few of the many nodes obtained with osm2pgrouting (I also have the edges, of course). I'm not an expert but once I run the query, it works and ...
user avatar
1 vote
1 answer
94 views

What is priority in mapconfig_for_cars.xml of osm2pgrouting?

I am new user to pgrouting. I wonder what the meaning of "priority" value means? By default, the values are 1, 1.05, 1.15, 1.5, etc. How to calculate it and why it becomes a value. Also, is ...
user avatar
0 votes
2 answers
275 views

Launch of osm2pgrouting: fe_sendauth: no password supplied

I am trying to launch the osm2pgrouting thru the command below and load data (file) into it, but i get the following message: $ osm2pgrouting --f osnabrueck.osm --conf mapconfig.xml --dbname routing -...
user avatar
  • 11
0 votes
1 answer
320 views

osm2pgsql failed import The system cannot find the file specified

I got error message, when loading osm file to PostgreSQL by osm2pgsql command. I run the following command line : osm2pgsql -c -G -U postgres --hstore -S D:\osm2pgsql\default.style -U postgres -W ...
user avatar
  • 1,095
2 votes
1 answer
267 views

pgr_dijkstra return empty set after using osm2pgRouting

I recently started to work with pgRouting with this osm file So I used osm2pgRouting to parse the file and load it into the DB. osm2pgRouting (using the mapconfig_for_pedestrian.xml) work's fine, ...
user avatar
  • 23
1 vote
1 answer
55 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 ...
user avatar
2 votes
1 answer
254 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 ...
user avatar
  • 405
1 vote
0 answers
100 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 ...
user avatar
0 votes
2 answers
80 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 ...
user avatar
  • 195
5 votes
2 answers
161 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 ...
user avatar
  • 307
0 votes
1 answer
82 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 ...
user avatar
-2 votes
2 answers
193 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 ...
user avatar
0 votes
1 answer
661 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" --...
user avatar
0 votes
0 answers
240 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 ...
user avatar
  • 316
0 votes
2 answers
239 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 ...
user avatar
  • 103
1 vote
1 answer
261 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....
user avatar
1 vote
1 answer
186 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 ...
user avatar
  • 1,033
2 votes
2 answers
186 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 ...
user avatar
1 vote
0 answers
456 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 ...
user avatar
  • 345
3 votes
0 answers
64 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 ...
user avatar
  • 3,246
1 vote
2 answers
161 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.
user avatar
0 votes
1 answer
665 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 ...
user avatar
  • 317
1 vote
0 answers
39 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 ...
user avatar
  • 157
3 votes
1 answer
214 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 ...
user avatar
3 votes
0 answers
266 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 ...
user avatar
2 votes
0 answers
382 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 ...
user avatar
5 votes
2 answers
601 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 ...
user avatar
2 votes
0 answers
80 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 ...
user avatar
2 votes
0 answers
37 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 ...
user avatar
0 votes
1 answer
644 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, ...
user avatar
5 votes
2 answers
2k 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 ...
user avatar
5 votes
0 answers
149 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 ...
user avatar
  • 161
1 vote
3 answers
321 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 ...
user avatar
  • 3,017
0 votes
1 answer
333 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.
user avatar
2 votes
1 answer
312 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, ...
user avatar
  • 3,017
1 vote
0 answers
140 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. ...
user avatar
2 votes
1 answer
264 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 ...
user avatar
  • 133
1 vote
2 answers
480 views

Cannot create pgr_PointsAsPolygon from pgr_DrivingDistance function?

I have successfully build a pgr_DrivingDistance query, select id::int4, lon::float8 as x, lat::float8 as y from pgr_DrivingDistance( 'select gid as id, source, target, length as ...
user avatar
2 votes
0 answers
142 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 ...
user avatar
2 votes
1 answer
1k 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 ...
user avatar
0 votes
1 answer
237 views

How to quick-fix drive time in residential area with Osm2PgRouting?

I'm currently testing pgRouting using OpenStreempMap XML dataset loaded via Osm2PgRouting. My goal is to solve shortest path problems using time driven costs instead of path length. I noticed that ...
user avatar
  • 1,230
1 vote
1 answer
496 views

Changing projection of PostGIS data? [duplicate]

I have exported osm data using osm2pgrouting in the database, it has SRID 4326. I want to change projection of all the tables created to a particular SRID in UTM. I read the post FIrst and Second, ...
user avatar
  • 245
1 vote
2 answers
252 views

May I use OSM in pgRouting to determine TSP solution?

I have a TSP problem that I'd to determine if my solution path is correct. As stated, a classic TSP, I have a number of locations (bikeshare stations) within a city centre (Glasgow, Scotland) that I'd ...
user avatar
  • 325
4 votes
1 answer
2k 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 ...
user avatar
  • 143