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

learn more… | top users | synonyms

0
votes
1answer
63 views

Pgrouting install debian 7.5 whezy

I need to install pgRouting on a Debian 7.5 64-bit server. I have PostgreSQL 9.1 and PostGIS 1.5 running. But somehow I can not install pgRouting. 1 - To use add-apt-repository ran the command: ...
0
votes
1answer
51 views

Routes Consult with pgrouting / openlayers [closed]

I'm starting with pgrouting. After suffering a bit unable to put the data in osm postgis using osm2po with the excellent tutorial http://anitagraser.com/2011/12/15/an-osm2po-quickstart/ ran the sql ...
1
vote
1answer
183 views

Cannot add layer Openlayers 3

I have been trying for a couple of days to perform three very simple tasks combining Geoserver, Opencycle maps base map and open layers 3. I am following the pg_routing workshop as I am using a ...
1
vote
1answer
34 views

How to export drivingDistance results in pgRoutingLayer on QGIS 2.2.0?

Hi and first of all congratulation for the great work on working and explaining the posGIS functions in QGIS : it makes this rich GIS enven richer. Thank's to Underdark's pgRoutingLayer extension, I ...
1
vote
1answer
113 views

pgRouting on RHEL6: issues with driving distance library

I installed pgrouting on RHEL6 via yum and the ELGIS 6 repo (the only place where I could find pgrouting for RHEL6). The problem is that the librouting_dd.so library (for driving distance) is ...
0
votes
0answers
49 views

Calculating driving distance from many nodes (sources) to one target using PgRouting?

I'm using a PostGIS / pgRouting database setup with a road network. And I want to calculate a driving distance and shortest path from many sources to one target. I found that pgr_kDijkstra can ...
0
votes
0answers
101 views

What does pgr_createTopology() expect for a table parameter?

In this sample http://docs.pgrouting.org/2.0/en/doc/src/developer/sampledata.html#sampledata there is this function: SELECT pgr_createTopology('edge_table',0.001); I understand that this creates a ...
0
votes
2answers
57 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 ...
0
votes
0answers
18 views

Calculate distance between point and linestring, save the distance as table and represent that on QGIS? [duplicate]

I have loaded my data with osm2pgrouting and I have my network with ways (Linestring) and nodes (Point). The problem is : I have a database of doctors addresses (point) and I should calculate the ...
1
vote
3answers
126 views

Generating a routing database for the entire world while keeping the tags

I've been looking into this matter for a few days now, but I haven't come up with a working solution. Basically, what we are trying to do is create an entire world database, preferably in PostgreSQL, ...
0
votes
1answer
58 views

pgRouting: calculate many-to-one shortest paths

In a previous question on how to calculate many shortest paths, @dkastl pointed to the pgr_kdijkstra function, which allows to calculate each time the total cost of one source-to-many targets shortest ...
0
votes
2answers
82 views

pgRouting - calculating route from point to point

I have three shapefiles: roads(lines), logistic center(one point feature) and places(a lot of point features). I have tried to calculate route from logistic center to places by ArcMap network ...
0
votes
1answer
17 views

PGRouting analyzegraph

It shows the message when I try to execute the command SELECT pgr_analyzeGraph('Highway','the_geom',0.0001);. I confirmed that the pgrouting, postgis, postgis_topology does including into the ...
0
votes
1answer
24 views

Invalid references created by pgr_createTopology

I am trying pgr_createTopology on a simple network and it is leaving invalid node references in the source and target columns. Apparently the segments table is not being updated with the new ...
0
votes
3answers
194 views

Faster routing algorithm on pgrouting [duplicate]

I have downloaded data for india as a dbf file then converted it using osm2po to make it routable but the problem is when i make any routing query it takes a lot of time around 300 seconds and these ...
0
votes
0answers
19 views

PgRouting - TRSP usage

I have tried to use TRSP function to compute the route using turn restriction feature. Imagine we have such path A --> B --> C --> D and I have add a restriction on link B --> C. Normally when I run ...
0
votes
1answer
30 views

Improving speed on pgRouting on table update with many rows: faster to loop on each row than a table update call?

I am updating thousands of rows in a survey table finding shortest path from each place a survey respondent visits. My code below is the query I use to update the blank route column. The function ...
0
votes
1answer
33 views

Empty geometry resulting from pgrouting function

Let me start by saying I'm assuming I'm missing something very silly but I can't see it. I have a table of points and I'm trying to generate a polygon around each point that estimates a maximum of ...
1
vote
1answer
30 views

OSM data - ways table features

I have made this web-app http://160.75.133.173/openWebApp/routing.jsp Users just have to click two points to figure out the shortest possible route available connecting them. I am using OSM data and ...
0
votes
0answers
34 views

PgRouting-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
0answers
22 views

PgRouting TRSP functions issue

I have tried to use the pg_trsp functions to compute the shortest path from an edge A to an edge B. When I call pgr_trsp, I need to inverse the order of edge in the call like this SELECT * FROM ...
1
vote
1answer
126 views

Routing in MS SQL 2012

I would like to perform routing in MS SQL 2012 similar to pgRouting. In pgRouting, I'd do the following steps to create a routable network: Create a database routing with template template_routing ...
0
votes
0answers
24 views

Using pgr_createTopology on only a subgroup of the table

Lets say I have a table with the standard id, source, target, and cost needed for pgr_createTopology. Now lets also say I have a 5th column called floor. Is it possible to run pgr_createTopology on ...
0
votes
1answer
60 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
40 views

With osm2pgrouting, how to handle relations?

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

Common Web Server for Web Mapping?

I'm planning to create interactive routing map system( for small town only ) which will be running online. My server side language will be PHP and PostGIS/PostgreSQL with using pgRouting and client ...
0
votes
0answers
326 views

Postgres SSL SYSCALL error: EOF detected with python and psycopg

Using psycopg2 package with python 2.7 I keep getting the titled error: psycopg2.DatabaseError: SSL SYSCALL error: EOF detected It only occurs when I add a WHERE column LIKE ''%X%'' clause to my ...
0
votes
1answer
175 views

Aiming to retrieve source and destination from Android, use pgrouting dijkstra to find shortest path and display it back on Android

I have created an Android application that will accept source and destination from the user. It then calls a php page which takes in the lattitude and longitude of the destination and the source. I am ...
0
votes
1answer
72 views

osm2po is missing edges while importing to pgrouting

I am using osm2po for importing pbf file to postgresql but when i find route using built-in algorithms i found that some of the edges are missing so route does not match with road. Did anybody know ...
0
votes
2answers
50 views

pgRouting - no 'to_cost' values imported (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
0answers
45 views

pgrouting pgr_drivingdistance() query gives inconsistent results

So I have been working on a query(with the help of other stackexchangers :)) to get the edges in an isochrone from a particular point and then update the count_events field of those edges by some ...
1
vote
2answers
830 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 ...
0
votes
1answer
41 views

query to get predicted location after traveling on pgrouting route for some hours, postgis 2, postgresql 9.3

I am using Postgis 2.0 on Postgresql 9.3 on Ubuntu 14.04 x64. I am trying to find an efficient way to fulfill this routing request. So I am able to get the shortest route using the source and target ...
0
votes
1answer
152 views

Can't load pgrouting extension, could not load library librouting_dd.ddl error 998 windows

I have a windows 7 machine 64-bit, I installed Postgresql 9.3 via the opengeo suite 4.0.2 in the program files (x86) folder, so I guess I have to install the 32-bit version of the extension. I am ...
0
votes
1answer
53 views

How to implement stopovers in pgrouting?

I used to use Dijkstra to find the shortest path between two points. Now I have a shortest route, which uses a street forbidden to use because of internal rules (too slow due to shopping mall). Now ...
0
votes
1answer
44 views

problem transforming pgr route to a line - unexpected extra lines from St_MakeLine

I have created a line geometry from a pgr_dijkstra querry and I am getting an unexpected looking line in qgis. The following image illustrates the problem: The magenta line is the line created ...
0
votes
2answers
138 views

creating isochrones in postgis/osm2po/pgrouting and then saving the isochrones as polygons

So I am creating some isochrones in pgrouting based upon a table from osm2po. Now I have a query that will get all of the edges that are c driving distance away from a point. My question is, how can I ...
0
votes
1answer
29 views

PGrouting encapsulated queries error [quotes problem]

I'm facing a quote problem on a pgrouting query. What I'm thinking is wrong is that my query only works if I use one, then four, then eight quotes on encapsulated queries. Is there a way to simplify ...
4
votes
2answers
139 views

How to connect points (bus stops), which don't lie on the lines (LINESTRING), to a network?

I need to connect bus stops (points) to a network layer (OSM data). These bus stops do not lie directly on the lines (see screenshot) nor should their location be moved. I use PostGIS, pgrouting and ...
0
votes
1answer
135 views

Is there any working example for pgr_trsp ?

I'm trying to use pgrouting pgr_trsp function but result is useless. Exactly same code with pgr_dijkstra working OK and find shortest path between start and stop but with pgr_trsp it is look like ...
0
votes
1answer
58 views

an efficient way to find the pgrouting edges contained within an isochrone

So I am working with some pgrouting road network data in postgis2.0/postgresql 9.1. I am interested in routing around certain types of disasters like tornados or such. If a disaster event happens at ...
1
vote
1answer
51 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 ...
4
votes
3answers
634 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 ...
5
votes
1answer
135 views

How to filter the graph on which I want to find the shortest path

I have a large graph that contains edges of Europe. I want to calculate the shortest path between two points on this graph with pgRouting that have a function pgr_trsp for shortest path calculations. ...
1
vote
1answer
54 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
votes
1answer
142 views

how to build and install pgrouting-2.0 on postgresql-9.3 on ubutntu 12.04 Lts precise?

I try to build following instructions from this link https://github.com/pgRouting/pgrouting after downloading from the github. I have done the cmake command and there is my error output: ...
3
votes
2answers
70 views

How to deal with Roundabouts in PgRouting

Can anybody guide me to to deal with roundabouts in pgrouting?? I have some roundabouts in my road network and when i try to make route from one point to another, it gives me wrong direction where it ...
1
vote
0answers
26 views

Use pgRouting with a PaaS

Is it a way to use a postGIS/pgRouting enabled database with a PaaS like Windows Azure? If not, do you know alternatives?
0
votes
0answers
32 views

Why there is no output (path) for Dijkstra in pgrouting

I have a road network table and I am implementing pgRouting. everything was working fine previously but now there is something odd here. I am getting no route now. I am checking through sql query in ...
2
votes
1answer
126 views

assign_vertex_id:problems when creating the node ids

Before using pgrouting, I have to create the node ids. I loaded my polyline layer into PostGIS Manager: I type this in SQL query: select assign_vertex_id('split_4', 800, 'geom', 'gid') But as ...