pgRouting extends the PostGIS / PostgreSQL geospatial database to provide geospatial routing functionality.
2
votes
0answers
108 views
Is there a way to start the route on pgrouting from a coordinate that is not a node?
After execute all steps from this pgRouting tutorial, now I have a map that creates and displays routes, but as the routing methods rely on parameters representing vertex Ids that was created using ...
1
vote
1answer
48 views
segment lines according to point using pgRouting?
I'm working on postgresql and I am trying to create table to generate graphs. I have a table that contains all the objects of a city (points) and another contains the city street. My goal now is to ...
1
vote
2answers
68 views
Problem using shortest_path with find_nearest_link_within_distance function
I'm tried to work on the scenario that avoiding go through some path if there is a barrier near that path. It can run well with the query below:
SELECT * FROM shortest_path('SELECT gid AS id, ...
4
votes
2answers
2k views
Installing pgRouting in Windows 7
Can you please help me out in Installing pgRouting in Windows 7 64-bit version.
I have been trying it for days. Since I am completely new to this please provide me the initial requirements and steps ...
1
vote
2answers
205 views
Which version of pgRouting should I use with PostgreSQL 9.1 and PostGIS 2.0 (on win xp)?
I am new to GIS.
I want to install pgRouting on my system (win-xp 32-bit). I am trying to run routing_core.sql file and got the following error:
ERROR: incompatible library "C:/Program ...
4
votes
1answer
193 views
pgrouting: Directed Shortest Path calculation using Dijkstra ignores one-way streets
I think I found an interesting bug in pgrouting. When I use the Dijkstra algorithm (no matter if I use the shortest_path() or dijkstra_sp_delta_directed() method) to calculate the directed shortest ...
4
votes
0answers
75 views
osm2pgrouting stuck (showing classes table created) when importing an osm file
I am trying to import an osm file using osm2pgrouting. while following the pgrouting workshop. (file is 700mb~)
im running ubuntu 12.04 on m1.large on amazon.
the same file was successfully upload ...
4
votes
2answers
899 views
tool to find the routing distance between two latitude/longitude points using OSM data
I need a tool to find the distance between two points whose longitude and latitude are given. I am making an application so it will require bulk queries, so i cannot use google maps distance matrix ...
0
votes
0answers
58 views
ST_intersects and shortest_path to optimize routing in respect to (de-)acceleration
Is there a way to consider a more complex cost field in the PG_Routing algorithm?
I am currently trying to get more realistic routing costs. I have a map based on the German ATKIS standard with road ...
0
votes
0answers
24 views
step by step tutorial for using pgrouting [duplicate]
I have installed pgrouting from source and want to use it to make myself familiar with it. Is there any step by step tutorial for beginners?
I am trying to use this. But the database link given here ...
0
votes
0answers
27 views
I dont get any result after i executed the shortest_path() (pgrouting) [closed]
i'm following the tutorial :
http://underdark.wordpress.com/2011/02/07/a-beginners-guide-to-pgrouting/
everything seems working , no errors !
when i execute the shortest path i dont get any result ...
4
votes
0answers
486 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 ...
3
votes
1answer
123 views
Routing with multiple points
I am using postgreSQL, postGIS and pgrouting. Now I am really confused on how am I going to find the shortest path between multiple points.
I know how to find it between two points through dijkstra ...
2
votes
2answers
129 views
How to visualize pgRouting layer in leaflet?
I have completed all the queries of the of pgRouting tutorial by Underdark where visualization was done with the help of RT SQL Layer Plugin. As I am using Windows OS I have no access of that tool. ...
2
votes
3answers
208 views
PgRouting routing algorithm from start to end via nodes with restrictions
I have the following situation:
I want to find the shortest route from A to B through nodes (C,D,E, etc.) with turn directions and road type filtering.
Is there a way to accomplish this using ...
1
vote
0answers
41 views
PgRouting: Connect route to table
I would like to show the edges of the result route in a table, like this:
http://routing.geosdi.org/
I did the pgrouting part, just have to make the table and connect it.
How can I achieve this?
2
votes
4answers
438 views
How to fix Error: could not access file “$libdir/librouting”?
I am trying to run the sql file of pgrouting-> routing_core.sql in mac. However it displays the following error
psql:routing_core.sql:32: Error: could not access file "$libdir/librouting": No such ...
1
vote
2answers
81 views
How to change the function of cost of osm2po?
As the column 'kmh' shows speed limits wrong for my city, and I didn't want to modify the configuration file of osm2po for each type of road, is there a way to change the cost function? I wish:
cost= ...
9
votes
3answers
354 views
How to add offsets to the route?
Edited:
I want to ilustrate my question. Suppose that you're in "Point A" and want to go to "Point B". This points wouldn't be in "at_2po_4pgr" table cause aren't source/targets nodes.
Then, I ...
1
vote
2answers
188 views
Turn-by-turn direction using PgRouting
How can I generate turn-by-turn directions using PgRouting?
At the moment, I have a web-page where a user can enter and start/end location and a route is generated on a map (using PgRouting and ...
1
vote
1answer
42 views
Installation problem for pgrouting
When compiling pgrouting from source for Ubuntu 12.10, I got the following error message. The version of boost is 1.52, is it too new for building pgrouting?
[ 37%] Building CXX object ...
4
votes
1answer
88 views
finding routes just for cyclists
I have created a PostGIS DB using osm2po and I am using pgrouting to calculate the routes.
The application I am creating should find routes for cyclists so I want the route finder to prefer roads ...
2
votes
0answers
55 views
Pgrouting can't find postgresql (on Mac)
I've installed both postgreSQL 9.0 and postgreSQL 9.1 on my mac, using binaries from http://www.kyngchaos.com. I also have postgis 1.5 installed.
I tried to install pgrouting, again using binaries ...
0
votes
1answer
95 views
how to find vertices for a geometry in OpenLayers
I am having a LineString, where I need to find the vertices logically and save those vertices. Can anyone help me out. Or else how below can help me.
OpenLayers.Geometry.LineString = ...
1
vote
0answers
158 views
How to calculate the shortest path between two points characterized by latitude and longitude with pgrouting?
I have to calculate the length of the shortest path between A (lat1, long1) and B (lat2, long2). But all the solutions I've found do not get a correct result because they only calculate the distance ...
30
votes
7answers
5k 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 ...
5
votes
1answer
445 views
Speed up pgRouting point_to_id using new <-> operator in PostGIS 2.0.0
The point_to_id function, which assigns a node id to a point based on existing nodes and tolerance, is using a query as follows:
SELECT
id, the_geom
FROM vertices_tmp WHERE
...
2
votes
2answers
112 views
What is geom_way column in osm2po generated data?
Could anybody tell me the meaning of geom_way column generated by osm2po?
0
votes
0answers
50 views
how to group interconnected edges inside a table?
Given a table and a random set of edges with source and target columns, how can I find out which edges connect with each other and then group them together using PostgreSQL?
8
votes
2answers
270 views
How to calculate heuristic shooting star algorithm?
I have a problem with the shooting star algorithm. It's my final project and I need some help.
My question is how can I calculate the heuristic shooting star algorithm?
I can use the pgrouting ...
1
vote
0answers
39 views
given sets of vehicle passing on each edge, how to get most used vehicle to avoid transition?
I have two tables: one, the resulting table from converting osm.xml via osm2po so I can use pgRouting, and another one that contains information on what edges each public vehicle passes through ...
2
votes
1answer
55 views
turn osm2po vertex table restrictions column into turn cost for shooting star pgrouting?
i found this thread
Does OSM2PO take into consideration turn restrictions?
but im kind of new to sql and database so me, making my own query or sp to achieve the above suggestion by myself is kind ...
1
vote
0answers
115 views
pgrouting shortest path result in wrong order
I am using the Dijkstra shortest path algorithm to plot a route between two points using the latest version of pgrouting in postgresql 9.1 with postGIS 2.0.1.
I am able to get a correct result ...
7
votes
6answers
624 views
Shortest Path using interpolated OSM points
I have a set of GPS points which I have snapped to the OSM network. In the below screenshot GPS points are red, snapped points are green.
I want to calculate the shortest path that includes all of ...
3
votes
2answers
97 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 ...
3
votes
1answer
157 views
Transit Routing using pgrouting as core routing engine?
i'm a student and i'm working on a project. the aim is given two sets of coordinates(origin & destination) route through the map to determine the optimum path using public transportation and of ...
3
votes
0answers
83 views
create minimal spanning tree using table of distances between nodes rather than TSP
I am working on a transportation (linear programming) problem. Each potential solution also requires checking the distance of approx 20,000 routes with 5 to 15 nodes per route.
Calculating the ...
8
votes
1answer
726 views
How to work with shortest_path_shooting_star() in pgRouting?
It's been a while we are using PostGIS to store our Geometry information in our Postgres database. We have developed vertex-to-vertex routing ourselves using iGraph library. Yesterday I read about ...
4
votes
0answers
89 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 ...
2
votes
0answers
92 views
How to PGRoute from OpenLayers via PostGIS/PostgreSQL [duplicate]
I need to route a shortest distance for a map which I have loaded from a PostgreSQL by means of JSON file. I can project the map in my browser and I can identify the linestrings. For a particular ...
2
votes
4answers
248 views
Any pgrouting enabled hosting providers?
I am really interested if any of you know about a hosting provider that offers postgis & pgrouting pre-installed?
If not, can I just go ahead and purchase a linode hosting account and do all the ...
2
votes
1answer
107 views
Why is pgrouting astar not consistent?
I route from 1 end of a circular route to the opposite end. Visually it is obvious that going clockwise is shorter, however shortest_path_astar sometimes picks clockwise and sometimes anti-clockwise.
...
1
vote
1answer
179 views
Is it possible to use Leaflet, PostGIS and PGRouting for web mapping?
I am newbie at Open Source GIS. I have already create a web mapping using custom tiles and leaflet. I have used my my own database. Tilemill was used to create the tiles and leaflet was used to ...
2
votes
1answer
112 views
How to create a network with all the track points
I have created a sample network through the use of gps visualizer. Than I used the ogr2ogr function to import this data in my database.
Now I have a table which holds all the track points of these ...
1
vote
1answer
95 views
Do vertex IDs stay the same every time I run osm2po?
Does anybody knows if vertex (source, target columns) in osm2po tables are always the same?
I have my dr_2po_4pgr table with routing data and dr_matrix with routes already made. In this table I have ...
2
votes
2answers
441 views
How to find the Shortest Path between two coordinates points using pgrouting A-Star?
In PostGIS I have two tables: an osm road network and a table that contains the start and end coordinate points of each path (i.e. userid, start_x1, start_y1, end_x2, end_y2). I would like to know:
1) ...
3
votes
2answers
51 views
pgRouting - Make fails on Mac
I am having trouble getting started with pgRouting.
1) from binary
The Kyngchaos binary just won't install and says it requires PostgreSQL 9.1.
I do have it, but probably not where the binary ...
2
votes
1answer
85 views
How to create infrastructure coverage using pgRouting?
I'm trying to reproduce what Underdark did here.
I succesfully installed pgrouting and the two required function (nearest neighbour and driving_distance).
cdv_osm_v contains all the openstreetmap ...
1
vote
1answer
91 views
How to resolve pgrouting dijkstra_sp() function error?
insert into dijsktra_results(geom) select ST_UNION(the_geom) from dijkstra_sp('roads_layer',
(select source_id from roads_layer where gid=9975)::integer,
(select target_id from ...
1
vote
2answers
113 views
Using the PgRouting driving_distance function can we see the edges?
I have a directed graph and am using PgRouting's driving_distance function. My application needs it (or a related PostreSQL procedure) to return a full set of EDGES emanating out of the source, and ...
