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

learn more… | top users | synonyms

1
vote
3answers
28 views

problem to use openstreetmap data file with pgrouting2.0 on PostgreSql9.3

I'm a newcomer on pgrouting, and I want to test its functionalities. I've installed and configured my computer with Postgresql9.3, pgrouting2, and PostGIS. I've downloaded from openstreetmap the ...
6
votes
2answers
289 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
286 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 ...
2
votes
1answer
177 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. ...
3
votes
1answer
50 views

Drawing isochrones on map?

I am a fourth year graduation student of the Amsterdam University of Applied Sciences. I am currently working on my final thesis for which I am doing research on the Amsterdam Airport catchment area. ...
0
votes
2answers
29 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
2answers
90 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) ...
2
votes
1answer
389 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
1answer
43 views

Repair topology before pgrouting / No results of pgrouting

My goal is to calculate lots of distances along the streets. I followed http://workshop.pgrouting.org/ tutorial except that I used osm2po instead of osm2pgrouting to import osm file. The only problem ...
2
votes
1answer
360 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 ...
0
votes
0answers
42 views

Project with Postgresql and PHP and GoogleMaps

i like to make samething like this https://sites.google.com/site/mapperzmapdemo/ put i stack in the conection database and web application I try to explane my problem i make a code to read first ...
2
votes
1answer
290 views

openlayers 3 pgrouting: unable to get lat/long by clicking on the map

I followed all the steps from the pgrouting workshop using pg routing 2.0 and geoserver 2.5 from this site http://workshop.pgrouting.org/ . I can generate an itinerary in QGis by requesting Postgres ...
1
vote
1answer
183 views

PGRouting Layer plugin error in QGIS 2.2

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 ...
2
votes
1answer
38 views

What does the values in column clazz (osm2po) mean?

I have a given table in postgreSQL with OSM data which is used for routing purposes in Java with PGRouting. There exist two columns which I don't understand. They belong to osm2po. They are labeled ...
1
vote
2answers
29 views

How to find a route given a set of noisy points

First of all, I'm a total noob to GIS problems. Let's say I have a set of noisy GPS points (tracked while driving) along a number of streets. Is there a way to get the most likely route that generated ...
2
votes
1answer
47 views

If do not want to use pgRouting then what?

Good evening fellow GISers, I am interested in creating an online routing application. So supposing I have all the data I want into a postGIS database and loaded onto GeoServer and I am willing to ...
2
votes
1answer
18 views

GTFS import and pgRouting

I know there are some questions out there already. I'm looking at a fresh approach. I found the gtfs2pgrouting project from pgRoutings' GitHub page. But it's three years old and doesn't work with ...
1
vote
1answer
28 views

How to create a routable network with PGRouting

I have two sets of data Table A: Stations - contains postal code (which I can convert to lat/long), name and code. Table B: Connections - contains a possible list of connections including source, ...
0
votes
2answers
170 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 ...
1
vote
3answers
54 views

take from multilinestring the start & end points

I have to use the A* algorithm and my geometry is in multilinestring and i want to take stratpoint(x1,y1) and endpoint(x2,y2) . I use this queries but the colums after the execute is still empty ...
1
vote
1answer
41 views

Using pgrouting and algorithms in PostgreSQL?

I am trying my first pgrouting in a roads shape file i load it in postgresql first, the table has osm_id gid name ref type oneway maxspeed after i add columns source and target in table ALTER ...
0
votes
2answers
141 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 ...
0
votes
0answers
26 views

How to calculate fastest bicycle routes in Stockholm with QGIS?

Hello StackExchangers, I would really appreciate if expert users could point out a few directions for me, this is what I wanna do: Access an online map from my iPhone that gives me the possibility ...
2
votes
0answers
31 views

A* pgRouting issue with x1,y1 and x2,y2 values

Hello I try to use the A* algorithm in a topology i have make in the postgres but i can fill the x1,y1 and x2,y2 the latitute/longitude and i read same version have problem with ST_startpoint & ...
1
vote
1answer
51 views

problem in pgRouting with data from google earth

Hello i am new in forum an in Postgesql,postgis and pgRouting. I try to make a pgrouting for my city roads. I use googlemaps to make a lines with coordinates of the roads and export the results in ...
1
vote
2answers
101 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
18 views

Run pgr_createTopology() on custom geometry(linestring) table

How could I create a topology for a custom generated geometry table having just the_geom geometry(linestring) column? Because pgr_createTopolgy() asks for the gid column also for a given table, which ...
3
votes
1answer
799 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 ...
3
votes
3answers
254 views

How Does Directed and has_reverse_cost Arguments when set to [true, false] and [true, true] Affect Routing?

What will be the difference on the routing behaviour when I try to play with the directed and has_reverse_cost arguments on all the three routing algorithms? Example: the following SQL queries give ...
0
votes
1answer
441 views

SELECT assign_vertex_id('ways', 0.00001, 'the_geom', 'gid'); not work

I'm using using OSgeo 6.5 dvd and studing pgrouting workshop (link) for get shortest path. I created network topology call "pgrouting - workshop". There are three commands to execute in section 5.2 ...
1
vote
1answer
207 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 ...
6
votes
1answer
382 views

Route analysis in R based on the OSM transport network: possible?

I'm analysing the likely paths taken by commuters on their way to work, based on Census flow data, job density distributions and the transport network. At the moment I'm using pgRouting and the ...
0
votes
2answers
67 views

Shapefile to Network xml

I have a shapefile representing the US freight highway network available from Oak Ridge National Lab. I'm trying to prepare this as a .xml network for processing with MATSim. The output structure is ...
2
votes
1answer
102 views

pgRouting and Openlayers error when insert controls variable

I've got another problem here :( I'm following the foss4g_w12 tutorial for building a pgRouting WebApp using openlayers, everything goes well until I added the following statement to my code: ...
0
votes
2answers
44 views

pgRouting pgr_tsp() not returning results when used with SQL parameter

I’m trying to solve the travelling salesman problem with locations pulled from a database, e.g.: mydb=# SELECT id::integer, location_lng::float AS x, location_lat::float AS y FROM addresses where ...
0
votes
1answer
62 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
104 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 ...
1
vote
0answers
31 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 ...
39
votes
8answers
11k 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 ...
1
vote
1answer
70 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 ...
2
votes
2answers
178 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
48 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
87 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
83 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 ...
2
votes
1answer
81 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
46 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
42 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
575 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. ...
1
vote
1answer
50 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 ...
2
votes
2answers
98 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 ...