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

learn more… | top users | synonyms

0
votes
1answer
13 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
228 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 ...
1
vote
1answer
90 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 ...
2
votes
1answer
429 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 ...
2
votes
1answer
477 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 ...
0
votes
2answers
111 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) ...
6
votes
2answers
316 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 ...
3
votes
1answer
202 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. ...
0
votes
1answer
301 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 ...
40
votes
10answers
12k 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
21 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 ...
0
votes
1answer
41 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
15 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, ...
0
votes
2answers
163 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 ...
1
vote
2answers
45 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 ...
1
vote
1answer
135 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
39 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
32 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) ...
3
votes
1answer
83 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 ...
0
votes
0answers
68 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 ...
1
vote
2answers
143 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
61 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 ...
0
votes
0answers
29 views

Generate polygon from html

I would like to generate a polygon using Postgis - pgRouting ( osm_network ) + Geoserver ( Sql code) + Html5 . I Have followed pgRouting workshop r5 tutorial to get shortest path between two points ...
2
votes
1answer
289 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 ...
2
votes
0answers
41 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
27 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
150 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
47 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
498 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
31 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
57 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
49 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
16 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
88 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
803 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
51 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
60 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
289 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
31 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
73 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
25 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
21 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
240 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
79 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
20 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
82 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
461 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
190 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
5k 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
100 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 ...