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

learn more… | top users | synonyms

1
vote
1answer
129 views

Calculate shortest path between each lat/lon point in one table and each lan/lon point in another in Postgresql

I have two tables, both of them have only 2 columns. The first one contain only latitude and longitude coordinates of my source points and the other one only latitude and longitude coordinates of my ...
0
votes
3answers
125 views

What Open Source Packages are available to provide routing

I am looking for ways to validate mileage charged by our contractors. They are paid from a central location to a customer, and then from the customer to a drop off location. I use QGIS for a bunch ...
2
votes
2answers
701 views

Problem with running PostgreSQL 9.3 after installing pgRouting

I have PostgreSQL 9.3 installed on the server. It worked just fine. I also had a webservice which connected to a database. That also worked like a charm. Later, I decided to install and use pgRouting. ...
0
votes
2answers
86 views

Add locations to pgRouting network

Using pgRouting I wish to run an analysis from a location's nearest point on the network. This question seems to have been asked and discussed in several locations on the web including here and in the ...
3
votes
1answer
122 views

Using OpenStreetMap for simulation of commuter routes

I'm seeking some advice on how to build a simulation based on OpenStreetMap Data for my masterthesis. My knowledge of spatial data is very limited, since I come from another field of science, namely ...
2
votes
1answer
175 views

How to calculate the shortest distance for multiple source and targets using PgRouting?

I have a table with points and a road network which includes driveways (where you enter the highway). I want to find the point which is closest to a driveway. So I was thinking I can calculate the ...
3
votes
1answer
144 views

nearest facility with pgrouting

I have a postgres table of students with lat, lon and geom, , and a table of schools with the same, and a table of roads that has been converted to nodes. I'm trying to find the driving distance to ...
1
vote
1answer
63 views

Implementing Wrapper of PostgreSQL?

How can I implement the Wrapper of PostgreSQL? I found this useful looking wrapper from a FOSS4G routing with pgRouting Workshop but I do not know how to implement it!
2
votes
0answers
72 views

How to get the nearest points from pgrouting linestring result?

I'm trying to get the points or landmarks near from the result of pgrouting linestring( the shortest path ). I'm using OSM map entities and working with planet_osm_point. Here's my codes. SELECT ...
6
votes
1answer
588 views

Problem with shooting star with pgRouting: doesn't respect the one ways

I used osm2po to create a table for pgRouting. I notice a problem: for a route with dijkstra or a* the route is correct and respect the one ways. But with shooting*, it doesn't respect the one ways. ...
2
votes
2answers
170 views

How to create more networking osm

Using localhost page generated by osm2po roteamente noticed that the link is made to link even disabling snapping. Logically thought to create more nodes in the network, but how can I do this ...
1
vote
0answers
129 views

send viewparams geoserver using leaflet

I need to pass my longitudes and latitudes of origin and destination for a sql view in geoserver to get a WMS layer with the route. I've performed in qgis to view and is working perfectly. This is ...
2
votes
0answers
74 views

How to calculate bus route transfer by using pgrouting?

Let say I have route 1 from A -> B -> C, route 2 from C -> B -> D, how can I write SQL for pgRouting which can let me have the result route 1 -> route 2 when I want to get the shortest path from A ...
4
votes
3answers
577 views

Create a network topology for pgrouting with grade separation

I have built a network using Ordnance Survey's ITN data and I can solve routes across the network. What I need is to build in grade separation topology for overpasses and underpasses on the network so ...
2
votes
1answer
59 views

avoid using the same road twice

I am currently developing an application to create tours for motorbikes. At the current stage of development there is a start/endpoint and several points which outline the tour. Between these points ...
1
vote
2answers
98 views

Get km route between two points with lat / lng

I'm doing the following query to get the distance between two points with pgrouting: SELECT sum(cost) AS cost FROM pgr_dijkstra( 'SELECT id, source, target, km as cost FROM ...
0
votes
1answer
80 views

No result from pgRoutingLayer tsp(euclid) algorithm

I use QGIS plugin pgRoutingLayer for displaying the shortest route. Dijkstra algorithm works fine. I tried tsp (euclid) algorithm but it drew nothing (even no error message). I thought it may be ...
1
vote
3answers
196 views

How to set the tolerance value in pgr_createTopology function of pgrouting?

I am making a map based on the floor plan of a building. I made the shapefile and added it to the PostgreSQL database. I created the topology for the map using the following code: SELECT ...
1
vote
0answers
30 views

PgRouting: What index should have the restriction table

I have this tables to feed my routing engine using pgr_trsp: vzla_rto have the links and nodes (650k) vzla_restriction have the turn restrictions (10k) CREATE TABLE map.vzla_restrictions ( rid ...
2
votes
1answer
164 views

How to generate pgrouting source and target with OSM?

Is there anyone here can explain me more details for pgrouting's source and target? I'm wondering how to generate with the given lonlat in OSM PostGIS entities. In pgrouting's website, they are ...
0
votes
1answer
25 views

How to get pgrouting source and target value using openlayers 2/3?

Is there anyone can teach me how to get the pgrouting's source and target parameters in openlayers 2/3? I plan to get those parameters by click the OSM map layer. Currently, I can only get the lonlat ...
0
votes
0answers
56 views

Problem in importing .osm file with osm2pgrouting 2.0

i've got two different systems: First system is: Ubuntu linux 64bit Postgres 8.4.8 Postgis 1.5.1 pgrouting 1.05 osm2pgrouting 0.2.0 This the system i've used for an old project that is already ...
0
votes
1answer
133 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
107 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
694 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 ...
2
votes
1answer
64 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
139 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
76 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 ...
2
votes
2answers
148 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
20 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
157 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
112 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
172 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
49 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
252 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
26 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
47 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
64 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
53 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 ...
1
vote
0answers
56 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
31 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
167 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
28 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
88 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
54 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
81 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
527 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
223 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
81 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
72 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 ...