pgRouting extends the PostGIS / PostgreSQL geospatial database to provide geospatial routing functionality.

learn more… | top users | synonyms

1
vote
1answer
15 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 ...
2
votes
1answer
357 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 ...
0
votes
2answers
14 views

routing core smart sql functions

I found routing core smart file here but unfortunately is for version 1 of pgrouting... and when i want to use it in pgrouting v2 i get a lot of errors ( because of functions that have been changed in ...
0
votes
0answers
17 views

Method to translate PgRouting to ESRI Network Analyst network dataset?

I have a network dataset in a PostGIS database that is set up and routable via PgRouting. I would like to take this dataset and import it into Network Analyst in ArcMap in order to make some ...
3
votes
2answers
2k views

Query failed: ERROR: Operation on two geometries with different SRID

Following the pgRouting workshop here, I have the routing query below: $sql = "SELECT gid, start_id AS source, end_id AS target, the_geom, distance(the_geom, GeometryFromText( ...
0
votes
2answers
189 views

trsp route between two points ( not edge to edge )

I'm trying to solve common problem, how to generate route/navigate between two GPS coordinates and not between two edges using trsp algorithm. I did read many articles here but i'm not sure how should ...
0
votes
0answers
32 views

Splitting lines table using point table in PostGIS

My problem is that I want to get the shortest route between multiple point pairs which are stored in a table (PostGIS). In PostGIS I also have a network created using pgr_createTopology on a table ...
0
votes
0answers
60 views

Is there any algorithm or library can generate alternative path?

I want to generate alternative path for the plane to avoid colliding with the polygons (red area) using C or PHP or Nodejs etc in Linux. Currently, I have developed a Web page to display the flight ...
0
votes
1answer
17 views

Creating network for pgRouting from set of multiline strings?

I have a table which is a set of multiline strings. I wish to create a pgrouting topology from that table so I can do shortest-path problems. I have tried pgr_createTopology but it failed. Is ...
1
vote
2answers
65 views

Shortest Path Matrix with QGIS/GRASS

I signed up just a minute ago, because I am working on my Master's thesis and could not find a working solution for the following problem: I am analyzing Germany's high voltage electricity grid. I ...
1
vote
1answer
128 views

Install pgRouting on Postgres 9.1 and Win 32

I referred some documents on GIS-stackexchange and over internet regarding installation of pgRouting on Postgres v9.1 and windows 32. I am not getting the correct version of pgRouting to install. Can ...
1
vote
1answer
134 views

Route through water polygons

I have a water-polygon grid shape file as shown (Each grid is 1latx1long): I have created this in QGIS and files (coastal lines and land polygons) selected from http://openstreetmapdata.com/data ...
0
votes
0answers
12 views

pgRouting pgr_trsp returns no route

Installed a fresh PostgreSQL v9.4.1 x64 on Windows, and used the Application Stack Builder to install PostGIS 2.1 bundle which includes pgRouting 2.0. I created the sample data ...
0
votes
0answers
26 views

How to update the OSM data in a PGRouting Database built with osm2pgrouting?

I'm using a PGRouting database originally built with osm2pgrouting from a *.osm file downloaded from Mapzen. If I want to update the OSM data in that database, ie. re-build my PGRouting Database, ...
4
votes
3answers
2k views

How to make routable OSM map

I have some routable data for testing my pgRouting functions, and everything is fine. Now I have to download some more countries from OSM. I downloaded Germany shape files, but OSM maps are not ...
0
votes
2answers
152 views

Enlisting all OpenStreetMap (OSM) street names for General Transit Feed Specification (GTFS) routes?

I have exported OpenStreetMap (OSM) data of a city to my local postgresql db using osm2pgsql. I would like to add the General Transit Feed Specification (GTFS) routes information (say bus routes) ...
1
vote
1answer
200 views

QGIS Contour plugin: Creating complex isolines leads to isolated areas

I use the contour plugin (v1.1) within QGIS 2.4 to create contour lines. I have streets with different travel costs. I observe problems for streets with low travel costs if they are surrounded by ...
0
votes
1answer
337 views

missing tables vertices_tmp and vertices_tmp_id_seq pgrouting workshop

I'm using OSgeo 6.5 dvd and studing pgrouting workshop for get shortest path. I created database call "routing" and used "template_routing" for create tables but only 3 tables created. So then I ...
3
votes
1answer
238 views

Get Multiple Shortest Path using PgRouting in One Query

I am trying to get multiple shortest path using A* Algorithm available in PgRouting. I referred Solution given by UnderDark ( Link of the Stakoverflow Post ) . But it is not giving me proper Output. ...
1
vote
1answer
57 views

Speeding Up pgr_dijkstra using bounding box in PostGis2.0

I'm using PostGIS for the first time to calculate distances between two points, for a driving school booking system I am working on. I have loaded in all of the maps for Australia, but the query I ...
2
votes
1answer
571 views

Create isochrone from multiple start points

I want to create an isochrone. For this I could use the pgr_drivingDistance function with pgRouting (http://docs.pgrouting.org/dev/src/driving_distance/doc/index.html) but it only takes one start ...
2
votes
1answer
520 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 ...
1
vote
2answers
81 views

How to make a routable network topology?

We are trying to make a network topology for pgRouting from our own data. But there is a problem we could not resolve; our road data look like this; The red edge is a single geometry, so we can not ...
1
vote
2answers
173 views

adding geometries to a source, target table for multiple rows in pgrouting

I am having an issue trying to perform the pgr_dijkstra algorithm and getting back a line in my table for multiple rows. I have a table that has a columns of source, target node id's but I cannot ...
0
votes
1answer
70 views

pgrouting pgr_dijkstra forcing route along a selected edge?

I have routing working where a user clicks 2 points on the map, I find the closest vertex to those 2 clicked locations and pass that to a pgr_dijkstra function. What I would like is give the edge a ...
1
vote
1answer
124 views

Change The OpenLayers 3 script into openlayers 2.13

Hi all I want to change the code from pgrouting latest workshop which is used the Openlayers 3 beta to Openlayers 2.13 The code is in here http://workshop.pgrouting.org/chapters/ol3_client.html I ...
0
votes
1answer
61 views

Installing pgrouting on mac os x

Regarding installing (build) pgrouting I could install pgrouting-2.0.0 by using a command brew install pgrouting and following this Build manual: ...
2
votes
1answer
1k views

routing using openlayers and pgrouting

I would like to do a Dijkstra routing using pgrouting and openlayers. I have the downloaded osm data. I am following the workshop given in this link. But since I am very new to this I found it ...
0
votes
0answers
61 views

Create a route by using points (pgRouting)

I'm currently working on a routing model for 17th and 18th century voyages. These routes are based on data from old shipping logbooks. I made a separate layer in QGIS which contains point. I exported ...
0
votes
1answer
123 views

Using Pgrouting dijkstra algorithm in PostGIS?

I own two tables one with streets and one points, i use the table with the roads to calculate routes with dijkstra algorithm. But I want when someone add one point in the table Point and this point is ...
2
votes
0answers
52 views

Cost_Matrix Distance: Vehicle routing problem!

I'd like to calculate the "real distance" between one source and many targets, such as we do in the "vehicle routing problem", in order to get the matrix distance at the end. after using the osm2po, ...
0
votes
1answer
33 views

pgrouting pgr_ksp with large dataset

I have a large osm dataset. When I execute a pgr_ksp query, it takes +30 minutes Example: SELECT seq , id1 , id2 , cost FROM pgr_ksp( 'SELECT id, source, target, cost FROM myways', 524356, ...
1
vote
0answers
26 views

pgRouting. pgr_ksp() returns -1 as id3

The documentation (http://docs.pgrouting.org/dev/src/ksp/doc/index.html) says that the result should be 0 for the last row. Is the same 0 than -1? I'm new on this. Thaks for the help.
0
votes
2answers
100 views

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
1answer
38 views

How to fix pgr_dijkstra error, query must return columns 'id', 'source', 'target' and 'cost'?

I followed the steps in "pgRouting 2.0 for Windows quick guide". At the step of running pgr_dijkstra using the sql below: SELECT id, id1 AS node, id2 AS edge, cost, the_geom FROM pgr_dijkstra( ...
0
votes
1answer
45 views

What are the OSM 'class' cost settings for OSRM?

I'm looking to set up a routing system that will give distances based on network routes, rather than straight lines (ie. ST_Distance). To do this, I'd like to set up a pgRouting database where the ...
0
votes
0answers
71 views

Live routing with instructions is show in a windows info if click in road

I have make a web application , the application have in a server a database in Postgresql with a table roads , i have make a php with pgRoutong query , in the web site the user give two points , or ...
0
votes
1answer
52 views

how to fix this ERROR: Start vertex was not found

I am attempting to make an SQL selection but receive an error. My statement: SELECT * FROM network JOIN (SELECT * FROM shortest_path(' SELECT gid AS id, start_id::int4 AS source, end_id::int4 ...
0
votes
1answer
40 views

OSM 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 ...
0
votes
2answers
36 views

“linestringZ” kills “pgr_createTopology”

I'm trying to make a postgis tabel ready for pgrouting. But when I run SELECT pgr_createTopology('network.VEJM_BR_SL', 0.001, 'geom', 'id'); I get an error: "Geometry has Z dimension but column ...
0
votes
0answers
21 views

Query processing time for network table creation using pgRouting 1.05

I am trying to follow these steps for creation of a network table using pgRouting 1.05. In my case I have two road geometry tables, one is bangalore_road and the other is all_india_roads. Obviously ...
1
vote
2answers
43 views

Routing two not-node points and road side with pgrouting

I'm starting to use pgrouting and I have a couple of problems. In my project I have a lot of points which are near one of the road sides. I'd like to know how I can route two of these points since ...
0
votes
0answers
40 views

Indoor routing using Leaflet and pgrouting

I am going to create a project with leaflet and pgrouting for indoor mapping. now I want to search for possibilities of doing this,I want to chose right library for this .Does any one has any ...
42
votes
10answers
14k views

Creating drive time polygons using open source tools

Is anyone using open source tools and/or data to generate drive time polygons that radiate out from a given location? For example, I have used ESRI products like Network Analyst and Business Analyst ...
0
votes
0answers
36 views

How to get a time cost related to polyline geometric characteristics in postgis using OSM data?

I'm trying to make an isochrone mapping of the emergency facilities in my region, I'm using a street map loaded in postgis by osm2pgrouting, data is supplied by OSM. The only cost I got for every ...
1
vote
1answer
92 views

Isochrone driving/public transport map : Grass or postgis?

I have to do Isochrone driving / public transport map. It would seem that the two better open-source solutions are grass and postgis. Could you tell me which one is the better? the easier to ...
2
votes
1answer
96 views

Creating Isochrones with pgrouting - Network set up, locations (from point shapefile) imported into PostgreSQL/PostGIS DB and now?

I want to calculate isochrones representing the accessability of certain locations in a city. So I have set up the pgrouting enabled database, imported the OSM-Roads and created a network (thanks ...
0
votes
1answer
284 views

pgRouting cannot find extension control file

I am trying to use pgrouting on OS X. I installed the following: brew install postgres brew install postgis brew install pgrouting When I try to create the extension pgrouting I get the following ...
1
vote
0answers
34 views

Network Analysis for Pickup and Dropoff

I have a bit of a problem that I need help with. I am looking at a set of lat/long with a time stamp for the desired pickup or drop-off for passengers. There are multiple pick-ups and drop-offs within ...
0
votes
2answers
66 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 ...