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

learn more… | top users | synonyms

0
votes
1answer
88 views

pgRouting not returning node with correct z-value

have an issue with pgRouting that I've modified to consider multi-floor indoor areas. I've created a mock floor plan of any typical hotel. I copied the floor plan and assigned a different z-value to ...
1
vote
1answer
91 views

Visualising Multiple Routes from pgrouting in QGIS

I am able to Visualise the Single Route from Source A to Target B by the following code in QGIS SQL "id" in ( SELECT id2 as id FROM pgr_dijkstra( 'SELECT id, source, target, cost FROM ways', ...
0
votes
1answer
202 views

pgRouting with multiple floors [duplicate]

Hoping I might get some help with indoor multi-floor routing using pgRouting. At the moment, I have a dummy network system created to analyze shortest routes between locations with the results served ...
12
votes
4answers
3k views

Route optimisation for multiple vehicles

I have 100 destinations and 5 vehicles and I need to code a solution that efficiently routes the vehicles to each destination, so each destination is visited by 1 of the vehicles. Some of these ...
1
vote
1answer
959 views

pgrouting php problem “pg_fetch_result(): Unable to jump to row 0 on PostgreSQL result index 3”

I'm trying to build a simple routing web-app using pgrouting, followed some tutorial and the latest workshop. Because I'm using PostgreSQL 9.3(x64), Postgis 2.1.1, and pgrouting 2.0 so I did some ...
1
vote
1answer
102 views

How to check if a node is in route computed with pgRouting?

I'm new to the GIS system and I'm following the pgRouting workshop. I've imported the locations of nodes (points, highway=street_lamp) using osm2pgsql. now I'm calculating a few paths between two ...
2
votes
0answers
107 views

PostGIS for GPX analysis

I have GPX trails of vehicles/bikes of a particular city. Meaning, lat/lon, timestamp of bike trails from where a particular bike started and ended at different hours of the day. I have sets of these ...
0
votes
1answer
53 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="...
11
votes
4answers
822 views

How to add offsets to the route?

Edited: I want to ilustrate my question. Suppose that you're in "Point A" and want to go to "Point B". This points wouldn't be in "at_2po_4pgr" table cause aren't source/targets nodes. Then, I ...
0
votes
1answer
25 views

PGR_Djikstra function error

I'm trying to find a shortest path between 2 nodes using djikstra method but it keeps saying ERROR: Error, query must return columns 'id', 'source', 'target' and 'cost' this is my query: ...
0
votes
1answer
79 views

Add columns with information OSM by osm2po?

I imported the europa.osm network within my spatial database thanks to the osm2po tool. I use this with pgrouting. My problem is that I need to know the information provided by the tag address (city, ...
0
votes
1answer
47 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
1answer
48 views

What can I use to generate an interconnected graph from a series of coordinates?

I have a table containing latitude and longitude coordinates, and I'd like to be able to build an interconnected graph from it to use with pgRouting. Is there an existing feature of postGIS or ...
0
votes
0answers
46 views

Densifying OpenStreetMap (OSM) network nodes?

I am working with osmconverter to convert osm files(*.osm) to *.pbf, then i use osm2po to get sql file that run into PostGis to get a network table. The last step is to run a createTopology ...
0
votes
0answers
91 views

Error of doing pgr_analyzeGraph

I just completed the command pgr_createTopology, but it fails to do pgr_analyzeGraph & pgr_createTopology. The error is as below: Anyone can give me an idea? Thanks ERROR: isring() should only ...
1
vote
1answer
59 views

Best way to filter points given a starting point and max travel time

I have a database of about 1M geolocated addresses and I'm looking for a way to sort/filter these records based on a starting point and max travel time. Ex: "find every baker shop within 30 min ...
0
votes
1answer
41 views

Using virtual or temporary geometry with PostGIS and pgRouting

I am attempting to find the shortest/fastest routes from GPS point to GPS point as described in this post: Create closest point on multilinestring to use in shortest_path() I have seen many solutions ...
2
votes
1answer
769 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
1answer
158 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 ...
1
vote
0answers
124 views

How to split a road network into parts of same length?

It's my first time trying to use routing software. I prefer to use free and open source software but ArcGIS Network Analyst is available, too. For an university course i need a solution for the ...
1
vote
3answers
232 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 ...
0
votes
2answers
86 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
93 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 ...
4
votes
2answers
3k 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
0answers
121 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
1answer
37 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
375 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 ...
2
votes
1answer
288 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 ...
5
votes
3answers
3k 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 ...
1
vote
1answer
177 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 ...
1
vote
2answers
237 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 ...
0
votes
1answer
379 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 ...
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 ...
1
vote
0answers
182 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
278 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
147 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
88 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
49 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
1answer
150 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
185 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
81 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
70 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
167 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
41 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
86 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 ...
2
votes
1answer
255 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
771 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
43 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
200 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 ...
2
votes
2answers
389 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 ...