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

learn more… | top users | synonyms

1
vote
2answers
195 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 ...
1
vote
1answer
60 views

How I can use TSP function in pgRouting 2.0?

I've spent years working with pgRouting and so far he had solved the problems I had needed. With the change to version 2.0, things improved, everything was much more organized and new algorithms that, ...
1
vote
1answer
108 views

Removing pseudo nodes from PostGIS database using ST_ModEdgeHeal()?

I have used osm2po (5.0.0) and its autogenerated SQL file to load some 25% of Europe.osm.pbf as a network table into my PostGIS database. I have also created an associated nodes table with select ...
0
votes
1answer
59 views

Find nearest node function

I am trying to get work the next function but i don't know if it is incomplete because the query SELECT * FROM pgr_nearest_node1('jaen',-3.75,37.779); does not provide any results. Here is the ...
0
votes
1answer
100 views

pgr_drivingdistance wrapper

Pgr_drivingdistance function works as : SELECT seq, id1 AS node, cost FROM pgr_drivingDistance( 'SELECT id, source, target, cost FROM edge_table', id, distance, false, ...
1
vote
0answers
63 views

Is there any VRP solver in Pgrouting 2.0?

after looking at older posts and googling for a while i guess there is not vrp solver (multiple trucks). there was DARP in pgr1.x but i can't see it in 2.x. i found a lot of information on ...
0
votes
0answers
33 views

Syntax error drivingdistance

I am new in sql and i am trying to get that works a subquery with pgr_drivingdistance and pgr_pointsaspolygon but i get the next error: subqueries in FROM must to have an alias,for example, FROM ...
0
votes
1answer
90 views

PgRouting function wrapper

I'm trying to adapt the pgr_fromAtoB function to pgr_fromAtoMult replacing pgr_dijkstra function to pgr_drivingdistance.Here is the code: CREATE OR REPLACE FUNCTION pgr_fromAtoMult(IN tbl character ...
1
vote
1answer
276 views

PGRouting Layer plugin “UnboundLocalError: local variable 'db' referenced before assignment”

I am trying to do some basic computations using the PGRouting plugin for QGIS, but I am getting this error all time: An error has occured while executing Python code: Traceback (most recent call ...
7
votes
2answers
355 views

How to handle updates to pgRouting network in webmapping environment?

I'm building an application for a client of mine that will need to create routes in a PostgreSQL database. So far so good, but I need to support edits and changes to my network and I need to support ...
0
votes
1answer
103 views

How do I create a new vertex in the middle of an edge in postGIS?

I have a postGIS database populated with OSM data with the osm2po import tool. I have a number of fixed points that I want to route between using pgrouting. In order to do this accurately, I want to ...
0
votes
0answers
80 views

Package pgrouting_93 rhel7 rpm is not signed

I am trying to install pgrouting on Centos 7 like this: 1) Install Postgresql RPM - 9.3 on Centos 7 : http://yum.postgresql.org/repopackages.php#pg93 2) Install Postgresql 9.3 , PostGIS 2_93, ...
1
vote
2answers
328 views

UbuntuGIS packages on ppa.launchpad

I am trying to install pgrouting on ubuntu 14.04 like this: Add pgRouting launchpad repository sudo apt-add-repository -y ppa:ubuntugis/ppa sudo apt-add-repository -y ppa:georepublic/pgrouting sudo ...
0
votes
1answer
94 views

How to find routes between for each entry in a list of point pairs?

I have a postgis database with two tables. In the first table I have linestrings of a street network. The second table has points that are located on the street network. What I want is to find the ...
1
vote
0answers
87 views

instal pgrouting on postgres 9.3 + postgis 2.1

Just installed postgres 9.3 + postgis 2.1 on debian 7. Postgis works fine, but installation of PGrouting fails in psql. (no errors while installing sudo apt-get install postgresql-9.3-pgrouting) ...
4
votes
1answer
353 views

How to compute Walking and Cycling Isochrone maps using QGIS & pgRouting?

Just installed QGIS as I believe I should be able to produce walking and cycling isochrones from a specified point. I have done this pretty easily before using ArcMap, however, I am really struggling ...
2
votes
0answers
85 views

pgrouting librouting.dll library is supposedly missing when it is not

Yesterday, I successfully installed pgrouting from the most recent x64 2.0.0 binaries, at least this is what I thought. I was able to perform first query - select pgr_createTopology() from the ...
1
vote
2answers
45 views

Learning pg_routing - shortest_path error

I'm learning PostGIS and pg_routing to help in our project planning and grant applications at my transportation agency (we wanted to move beyond the limitations of the 1/4 mile walking buffer we use ...
0
votes
1answer
154 views

Open Source GIS Problem [closed]

I am new at open source GIS platform. I am using Ubuntu 12.10. I have tried to install the followings but without 2-3 tools I could not install anyone. Can any body help me how can I install the ...
1
vote
1answer
82 views

how to Find nearest line for the given point from a collection of lines?

I have table with lines(linestring).For a point wich i give it , I want to find out nearest line in point. I almost developed a query, but it is return the same line every point i give. the query ...
2
votes
2answers
614 views

How can I convert geoJSON data to GPX format

I want to know how I can convert geoJSON data to GPX format.
0
votes
2answers
77 views

How to get the closest point from a table in PostGIS?

I have a table of pgrouting nodes, structured like this: CREATE TABLE ways_vertices_pgr ( id bigserial NOT NULL, cnt integer, chk integer, ein integer, eout integer, the_geom ...
3
votes
2answers
97 views

pgrouting - network distance many-to-one shortest paths

I want to find the distance (km) between each origin point to the closest destination point (restaurants) using pgrouting. I have 3 tables my road network with nodes and edges 140 origin points - ...
0
votes
0answers
61 views

What does it mean when I get rows executed, but with no resulted table?

While applying the following tutorial: http://anitagraser.com/2011/02/09/creating-catchment-areas-with-pgrouting-and-qgis/ utilizing vector network which has been tested (and demonstrated ...
0
votes
0answers
31 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
124 views

Pgrouting, pgr_dijkstra function error

I'm starting to use the Pgrouting function on my database Postgresl. I have the table of links (id, source, target, cost) which contains the set of edges of my graph. I want to calculate the shortest ...
5
votes
1answer
896 views

How to create a routable road network from Ordnance Survey data?

I've been following the "Beginners Guide to pgRouting" in an attempt to create an in-house application that provides drive-time isochrones. I have a server, postgreSQL and PostGIS and pgRouting - no ...
1
vote
1answer
69 views

Get closest (source or target) of an edge from a point in postgres

I have a Postgres custom function that uses pgr_dijkstra to generate a route working. It works be passing the lat/lon of the start and destination points. I then find the closest segment vertice to ...
0
votes
0answers
82 views

How to split linestrings where start/end points don't touch nearby lines

I am trying to figure out some basic routing with PostgreSQL/pgRouting and I'm struggling a bit. Our network of linestrings are not topologically correct, tracks that should be connected don't touch, ...
1
vote
3answers
333 views

Why is pgrouting driving distance skipping edges?

I have a road network where I do a driving distance operation through pgrouting. This is my SQL: SELECT * FROM driving_distance('SELECT gid AS id,source,target, cost FROM ...
1
vote
0answers
45 views

pgRouting with TomTom multiNet

I would like to use TomTom multiNet data with pgRouting to create drive time/distance polygons. I have gone through the documentation regarding network topology creation, but am still confused to ...
1
vote
1answer
112 views

Solving “Traveling Purchaser Problem”

Till now, I was using PostGIS-pgrouting pgr_tsp function to solve Travelling Salesman Problems. This function can give us the best possible route depending upon the cost parameter when the starting, ...
0
votes
1answer
32 views

pgrouting with wms [closed]

I able to successfully perform pgrouting using wms but I am looking to show the cost (the length) on the webpage (not only the line on the map but the length of the line) some where in a div next to ...
1
vote
1answer
41 views

calculate route in road network [closed]

I have a shape file of road network. I have found out the nodes on the network. I want to calculate all the possible routes from a start point to the end point. I am using Postgres,postgis and ...
1
vote
2answers
314 views

Why does Driving distance of pgRouting return disconnected results?

I am trying the driving distance function of pgRouting 2.0 beta, with an extract of OSM data. The problem i have is illustrated on the following image : On this picture i try to get all the ways ...
-1
votes
1answer
125 views

How to create a Network Topology in a shapefile that contains only nodes(geometry points)?

I want to use pgrouting with the shapefile but when I use : alter table network.publictransport add column source integer; alter table network.publictransport add column target integer; select ...
2
votes
0answers
31 views

pgRouting only partially segments network

I have a road network traced from an old map with 360 MultiLineString features in table aroads. Many meet at endpoints or intermediate vertices, but some intersect. When I run SELECT ...
1
vote
2answers
111 views

How to visualize pgrouting result?

So I use this query SELECT seq, id1 AS node, id2 AS edge, cost FROM pgr_dijkstra(' SELECT gid AS id, source::integer, ...
4
votes
1answer
512 views

PostgreSQL: How to use more than one CPU?

I'm creating a real time traffic application. I read the AVL car data from a web service and insert the records in a PostgreSQL table. Then a trigger calculates the closest link and if there is a ...
0
votes
2answers
209 views

How to achieve point to point routing?

Currently, the pgrouting 1. 5 version has a shortest path function which actually traces a path from nearest vertex of source to nearest vertex of destination but. As, Dijkstra's algorithm works on ...
24
votes
10answers
6k views

Alternatives to pgRouting

I was wondering if there are any alternatives to pgRouting tools. Thinking about it for a bit, I think the only alternative is to use R or RPY to do the analysis. Basically I'm trying to solve ...
1
vote
2answers
144 views

How to easily remove loose/isolated edges from pgRouting network?

I wondered if there's an easy way to 'clean up' a pgRouting network by removing those edges that do not connect with the global network. Otherwise you risk to end up with cost values of -1, meaning ...
0
votes
0answers
46 views

pgRouting with my bus network and select the best of the available routes? [duplicate]

so here's the case: I have been using postgresql/postgis, openlayers and pgrouting to create an online application that selects and visualizes the best of the availabble routes. My problem is though: ...
0
votes
1answer
166 views

How to calculate the optimum bus route using pgrouting?

My setup for my web page is OpenLayers, Postgresql/postgis and pgrouting. What I do not understand is how I am going to do the routing.I have read many tutorials but I don't understand what my next ...
0
votes
1answer
138 views

st_startpoint(the_geom) returning empty values

When I upload a shapefile to PostgreSQL using the QGIS tool I can create the routing topology following this tutorial without any problem. But when I use the PostGis Shapefile Import/Export Manager ...
2
votes
0answers
47 views

Why pgRouting GUI panel may not work in QGIS?

What could be the reason behind the mal-functionality of the pgRouting Layer GUI panel? In order to route shortest path via dijkstra function code I'm able to conduct the task using the following ...
1
vote
0answers
27 views

pgrouting query [closed]

I saw on the pgrouting workshop the following way to calculate a route: http://workshop.pgrouting.org/chapters/advanced.html SELECT seq, id1 AS node, id2 AS edge, cost FROM pgr_dijkstra(' ...
3
votes
1answer
915 views

How to use the pgRouting TSP function?

For more than two days I'm trying to make the TSP algorithm work in PostgreSQL/PostGIS. My problem seems to occur when I'm trying to take into account the road network for TSP algorithm. I know that ...
0
votes
2answers
49 views

PGRouting analyzegraph

I got an error message when I try to execute the command SELECT pgr_analyzeGraph('Highway','the_geom',0.0001); Error message: function pgr_analyzegraph(unknown, unknown, numeric) does not exist ...
0
votes
1answer
109 views

from coordinates can i find from multilinestring from database

Hello i have the coordinates from two points(x,y) and i have a database with roads and i want to find with dijstrak algorithm wich road i take but the algorithm want source and target but in my ...