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

learn more… | top users | synonyms

0
votes
0answers
26 views

Pgrouting: Dijkstra - three-point turn

i'm using the PgRouting directed Dijkstra algorithm to calculate a route between 2 points. When my route needs to change the direction of travel, Dijkstra retuns me a three-point turn. There is any ...
0
votes
1answer
33 views

pgrouting to calculate distance using a chosen highway system

I am working on a research to calculate the distance of firms (scattering around the nation) to several metropolises via selected national highway system. Then I overlay the highway map with firms' ...
1
vote
0answers
19 views

Output shortest route shapefile using pgRouting and JSON data

I'm interested in finding the shortest route between two sets of bike share stations (22/21 stations each) in the city of Glasgow. Note, I need to overlay the final shapefile onto an OSM basemap in ...
2
votes
1answer
21 views

Geometry route in pgr_tsp

I currently use pgr_tsp and returns the list (apparently) correct. But I find no reference on how to get the lines that make up the optimal route. Is it possible that can help me? I only need to ...
2
votes
2answers
64 views

How to extract shortest path from floydwarshall algorithm pgrouting

I've tried Floyd-Warshall algorithm using pgrouting with the following code; SELECT * FROM pgr_floydwarshall( 'SELECT gid AS id, source, target, meters AS cost FROM jalan') ...
1
vote
2answers
24 views

May I use OSM in pgRouting to determine TSP solution?

I have a TSP problem that I'd to determine if my solution path is correct. As stated, a classic TSP, I have a number of locations (bikeshare stations) within a city centre (Glasgow, Scotland) that I'd ...
2
votes
1answer
42 views

Seeking updated pgRouting Tutorial?

Is there an updated pGRouting tutorial to this: https://anitagraser.com/2013/07/06/pgrouting-2-0-for-windows-quick-guide/ Trying to following it using QGIS 2.14.0 Essen + PostgreSql 9.5 (pgAdmin ...
0
votes
0answers
24 views

line_locate_point: 1st arg isnt a line

i used this query for routing procedure SELECT pgr_nodeNetwork('edges', .006); I am following this workshop http://workshops.boundlessgeo.com/tutorial-routing/ and this is the error, I can't ...
1
vote
1answer
27 views

Return result of pgr_dijkstra() in pgrouting 2.2

I am testing pgr_dijkstra() in pgrouting 2.2, but got columns (seq, id1, id2, cost) in the return result rather than columns (seq, path_seq, node, edge, cost, agg_cost) as described in the pgrouting 2....
0
votes
1answer
26 views

How are cost and reverse cost computed in pgrouting?

I downloaded the nyc osm metro extract from Mapzen. I then used osm2pgrouting to import that data into postgis, pgrouting and now I have all these columns cost and reverse_cost, but I'm not sure how ...
0
votes
1answer
16 views

update pgrouting from 2.0.0 to 2.2.0 due to malfunctioning

I have postgresql 9.1 and postgis 2.0 on ubuntu 12.04 currently installed, but when I try to execute the following command: psql -d routing_test ALTER EXTENSION pgrouting UPDATE TO "2.2.0"; output ...
1
vote
0answers
37 views

Pg_dijkstra empty results

I am currently working on PgAdmin, and the pgrouting extension, in order to get the length and the path of the shortest path between every LNG terminal over the world (I have them as a table of points)...
1
vote
1answer
74 views

How to add more vertexes to a LineString

I created a map of LineStrings using QGis and then it was exported to a Postgis DB, then I used the query below in order to create the vertexes in the map so it could be used with the functions of ...
0
votes
1answer
29 views

pgr_drivingdistance returning no results

I've imported the latest North America OSM extract into postgres using osm2po so that I can use the pgr_drivingDistance function of pgRouting to create a drive-time polygon. I'm at the final step, ...
0
votes
1answer
19 views

Topology processing after osm2pgrouting?

I imported an OSM dataset using osm2pgrouting, and checked the topology like this: pgr_sfbay=# select pgr_analyzegraph('ways', 0.001, id:='gid'); NOTICE: PROCESSING: NOTICE: pgr_analyzeGraph('ways'...
0
votes
2answers
28 views

Creating Drive Time Polygons Across State Boundaries Using OSM?

I am using pgRouting on OpenStreetMaps to create drive time polygons. The challenge is that at state boundaries, these polygons effectively stop, since the roads in OSM are segmented at the state ...
1
vote
1answer
67 views

How can I change start and end point of a linestring?

I have a linestring from a pgRouting query. The start point and/or end poit of this line does not connect exactly the points I've clicked on the road and give me all the road segment of that edge (...
0
votes
1answer
45 views

Problem with loop for pgr_Dijkstra

I try to use pgr_Dijkstra through Postgis and Pgadmin to find the shortest path in a network between a lot of nodes. So I thought I could to "automate" the process with a PLSQL query. Here is a query ...
0
votes
1answer
42 views

pgRouting - How get all pubs that are less than x meters from a point

I'm building a Mobile App to discover all pubs that are less than 2 km away from my position! First I obtained all the roads of a town using Open Street Maps "osm2po" Next I obtained all ...
1
vote
1answer
46 views

pgRouting problem: creating topology where segments touch

I am working my way through the example in the pgRouting manual (2.2). After running pgr_createTopology() and pgr_analyzeGraph(): pgr_test=# SELECT pgr_createTopology('edge_table',0.001); NOTICE: ...
3
votes
1answer
94 views

How to loop in PostGIS to add the next lat long to a route

I want to loop over the results of a query and then pass row(n)'s longitude, latitude and row(n+1)'s longitude and latitude to another function. I have a query which returns a set of coordinates from ...
0
votes
2answers
42 views

Does pgrouting support multi-modal routing?

Is it true that pgrouting cannot handle public transport routing as it does not support multi-modal routing? Can we do it by some workarounds?
1
vote
0answers
13 views

Single WMS pgRouting Layer from Array of Lat Longs

I am using the following loop for displaying the a bus route. 'stopLonLat' is a JavaScript object with all the latitude and longitude values of various bus stops. Since I am not looking for shortest ...
3
votes
1answer
43 views

pgrouting: how to temporarily increase some edges' cost without affecting concurrent queries?

How to temporarily increase some edges' cost for one query without affecting other concurrent query? The case is, I would like to develop a system that allows users to query the shortest path of a ...
0
votes
0answers
27 views

Problem with projection in pgRouting layer in GeoServer

I followed this tutorial for creating a pgRouting layer in GeoServer. When I try to publish this layer Native Bounding Box and Lat/Lon Bounding Box are not getting generated correctly. For my road ...
1
vote
0answers
36 views

Generate more nodes for routing

The following picture shows my routing database all set for querying loaded to QGIS. Red line is the road I want to select route from, yellow points are the vertices generated after running ...
0
votes
0answers
14 views

pgRouting Indoor Map pgr_createTopology()

I want to my indoor map in create route.But I'm having problems when creating networks.I have more than one map and multiple overlapping layers. Each route map and a separate network for each supposed ...
1
vote
1answer
74 views

PostGIS: How can I improve the response time for getting the routed distance between addresses?

I need the ability to calculate the driving distance between two addresses for possibly hundreds of thousands of records. I have decided on PostGIS because it can geocode and perform routing all in ...
1
vote
1answer
49 views

How can rewrite this query for using with commonly used lat-long values

I have this query to get the nearest road vertices from a bus stop point. Ho can a re-write this query to pass commonly used lat-long values like in google maps instead of 715127 957625 SELECT * ...
0
votes
0answers
47 views

Generating a route from an array of lat-long values in OpenLayers 3

I have developed a web application for bus tracking using GPS devices fitted on them. I am using MySQL to store and retrieve the lat-long values coming from the device. Also I have the route names and ...
3
votes
1answer
56 views

Create an optimised path between nodes avoiding polygons entities

I have a point shapefile representing seaports. I have the linear cost of shipping for every seaport pairing (specific shipping cost to go from one point to another point). I want to find a way of ...
0
votes
1answer
48 views

Using pgRouting through PostgreSQL

I followed the guideline from this tutorial to use pgrouting through PostgreSQL but I can't understand the first instruction: CREATE OR REPLACE VIEW road_ext AS SELECT *, st_startpoint(the_geom), ...
1
vote
0answers
40 views

pgRouting “Can't find Table”

I am using pgRouting version 2.1.0. I am using pgAdmin III. I have created a street network using Anita Graser's guide: https://anitagraser.com/2013/07/06/pgrouting-2-0-for-windows-quick-guide/ But ...
0
votes
0answers
18 views

multigtfs and pgr_createTopology

Could anyone know how to create a Topology on imported GTFS data into PostGIS with multigtfs? In fact, pgr_createTopology needs the edge_table or network table. Here are tables obtained after the ...
1
vote
0answers
27 views

Driving_distance() for pgRouting

I am trying to create an isochrone that would show all the points that can be reached within a certain distance time, starting from a central point. I have installed pgRoutine (v. 2.2) as per ...
0
votes
1answer
39 views

Will a basic pgRouting/OSM data setup allow me to calculate travel-times?

I have a PostGIS database and I need to figure out a quick (in terms of setup) way of calculating the travel-time between points corresponding to geocoded addresses taking into account the route and ...
2
votes
3answers
65 views

QGIS Pgrouting layer plugin error

I followed the instructions for loading OSM data into pgrouting found here: http://anitagraser.com/2011/12/18/osm2po-part-2-pgrouting-on-osm-the-easy-way/ Everything works fine using osm2po to ...
0
votes
2answers
94 views

Routing using OSM data, osm2po, and pgrouting: strange route produced

I downloaded latest data from Geofabrik and ran the data through osm2po. osm2po web service works fine. I tried to find the route from node 103843 to 170597 and got the following route: However, ...
0
votes
0answers
68 views

Openlayers pgRouting route should start from the point selected

I have implemented a routing application using OpenLayers 3, pgRouting, OSM and GeoServer. In my program, I can click on the map and that will be the starting point of the route. I set my Web Map ...
0
votes
1answer
60 views

osm2po > PostGIS > QGIS/pgRoutingLayer Extension Issue

I've just been testing osm2po and everything worked fine and straightforward until it comes to the QGIS pgRoutingLayer Extension. Selecting the Database and selecting source and target node works fine ...
3
votes
1answer
30 views

Assign_vertex_id function does not exist

I would like to add unique start/end nodes for each feature in my road network. I ran across some posts referencing the pgrouting assign_vertex_id function, which appears to do exactly what I want, ...
1
vote
2answers
54 views

How does pgr_createTopology assign source and target?

This is the first time I post a question here. I was following the tutorial from Anita Graser http://anitagraser.com/2013/07/06/pgrouting-2-0-for-windows-quick-guide/ , on a roads table which ...
0
votes
1answer
40 views

Importing information on bridges into postgis-table using OSM2PGROUTING

In OpenStreetMap (OSM) road data there is information about whether or not a road feature is a bridge or not (boolean). However, when importing into a postgreSQL data base for routing (pgrouting), ...
0
votes
2answers
55 views

successful import of osm2po results

I would like to know if my import of some osm2po results into a PostgreSQL database have been successful or not. Is there something like: 'Import successful' or a simple 'Done'? All I got was: ...
0
votes
1answer
21 views

How to access pgRouting Layers via script

I would like to provide input to the pgRouting Layers through a script. The scenario is as follows: I have a bunch of points whereof every point is representing a starting point and I have another ...
0
votes
1answer
77 views

Alpha Shapes in pgRouting

I am attempting to follow Anita Grazer's post on creating alpha shapes in pgRouting. My query: CREATE TABLE home_isodist (id serial, max_cost double precision); SELECT addgeometrycolumn('...
0
votes
1answer
42 views

pgr_dijkstra working but pgr_ksp is returning empty an resultset

This pgr_ksp function is not working, as answered in an earlier question SELECT seq , id1 , id2 , cost FROM pgr_ksp( 'SELECT gid as id, fnode_ as source, tnode_ as target, length as cost ...
1
vote
1answer
54 views

Referencing variables inside ST_Distance_Sphere function

I trying to create an UPDATE function that will ultimately return straight-line distance to the nearest node on an OSM network (which will be later added to pgrouting distances I have already ...
1
vote
0answers
27 views

My OSM country roads network is not routable [duplicate]

I need a routable shapefile in order to execute pgrouting algorithms. I download a national zip from http://download.geofabrik.de/europe/greece-latest.shp.zip and import the roads shapefile in my ...
1
vote
0answers
59 views

Why does Floyd-Warshall not return all pairs in my pgrouting SQL?

As a follow up from 1-center and k-center problem / maxmin facility problem in PostGIS I have a strange behavior for the Floyd-Warshall algorithm which seems to give not all pairs. Why are so many ...