pgRouting extends the PostGIS / PostgreSQL geospatial database to provide geospatial routing functionality.
2
votes
2answers
126 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
1answer
54 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 ...
2
votes
1answer
73 views
Relevant data for cost attribute to calculate route time
I have imported OSM data into PgRouting database.
I would like to use driving_distance() function to calculate route time.
How to add relevant time cost into database ?
Thanks
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?
2
votes
4answers
433 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 ...
2
votes
1answer
577 views
troubles with osm2pgrouting
I'm trying desperately to write my first query in pgRouting using maps in osm format (as shown in http://www.carsonfarmer.com/?p=799).
Im using Ubuntu 10.10 with Postgresql 8.4 ang postgis 1.5.
After ...
2
votes
1answer
32 views
How to install multiple versions of postgres in same os windows 7 64-bit?
I have already installed PostGIS along with opengeosuite and it is the latest version. Now I want to run pgrouting but the latest stable version does not compatible to the latest postgres versions. ...
2
votes
1answer
114 views
How to add Custom data (like for Indoor floors) and find routes using open source software?
I am a newbie to GIS platforms so maybe whatever I am asking is very simple or obvious. I have read documentation/tutorials and as a last resort I am posting here, so any help is appreciated. I am not ...
2
votes
1answer
105 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.
...
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 ...
2
votes
1answer
88 views
Is there a way to show the direction of a route?
I use pgrouting and openstreetmaps .I would like to know if there is a way to show the direction of the route on the map (eg something like this ---->---- or any other way,idea)
Thanks in advance.
2
votes
1answer
115 views
how do i know my pgrouting version?
Is there a way to know what version of pgrouting do I have?
My OS is ubuntu 12.04.
I want to know my pgrouting version because the 1.05 version has some issues with shooting start and the directed ...
2
votes
2answers
437 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) ...
2
votes
1answer
267 views
Plot the nodes of the shortest path found by dijkstra algorithm
I am using qgis and pgrouting plugin to find the shortest path between two nodes and display the route. Currently, the plot shows the shortest path. However, I also want to know which nodes the path ...
2
votes
1answer
67 views
How to add a new road to an existing pgRouting graph?
I have an existing pgrouting network topology that I would like to add a road to. The road is a linestring from a shapefile and will intersect several roads in the existing network. Is there an easy ...
2
votes
1answer
269 views
osm2pgsql finishes processing without creating vertices_tmp table
I am using postgresql 9.1 database with posgis installed. I also have pgroute installed on same database. I am trying to use osm2pgsql tool to import data for routing. But osm2pgsql tool finishes ...
2
votes
1answer
184 views
How can I convert geoJSON data to GPX format
I want to know how I can convert geoJSON data to GPX format.
2
votes
1answer
83 views
Is there a straightforward way to get the source/target point geometry of an edge?
I was wondering if there is a straightforward way to get the source or target point geometry of an edge?
It is still not clear to me how the source-target works. For example, if I use ...
2
votes
1answer
267 views
pgrouting with Navteq data
I realized that osm-data is not as complete as I need to have it for my work.
I'm considering trying a branch of navteq and later buy the data branch for my region.
Has anyone tried routing with ...
2
votes
0answers
49 views
assign_vertex_id：problems when creating the node ids
Before using pgrouting, I have to create the node ids.
I loaded my polyline layer into PostGIS Manager：
I type this in SQL query：
select assign_vertex_id('split_4', 800, 'geom', 'gid')
But as ...
2
votes
0answers
47 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.
...
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 ...
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
1answer
84 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 ...
2
votes
0answers
109 views
From pgRouting shortest_path back to osm node id
I'm successfully performing path finding queries like shortest_path on data imported with osm2pgrouting.
The tables I have inside my pgrouting DB are the following:
List of relations
...
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 ...
2
votes
0answers
91 views
Create a consistent topology using pgrouting
I'm developing an application that needs routing information for certain cities. First, I downloaded a openstreetmap datafile (*.osm) and then I imported it into a postgreSQL database using ...
2
votes
1answer
73 views
problems installing pgrouting from source
I'm running into a problem once I try
[cmake_dir]/bin/cmake .
I get these errors:
Boost headers were found here: /usr/include
Output directory for libraries is set to sh: ...
2
votes
2answers
191 views
Reinventing the wheel: Public Transit System
I'm building a public transit service in South Africa, and I initially started the project on PHP and MySQL. I've managed to get far with the simple stack, with:
Routing algorithm in PHP
Data ...
2
votes
1answer
116 views
Issues when using pgrouting's shortest path
I am having some issues when using pgrouting's shortest path. I am following this tutorial available at http://workshop.pgrouting.org/chapters/shortest_path.html#dijkstra. This query returns a list of ...
2
votes
0answers
179 views
Convert SmallWorld GIS topology to pgRouting topology
Is there any way to convert SmallWorld GIS topology to the format that pgRouting use?
My costumer have use SmallWorld GIS and make his topology on it. but when he export his information as shape file, ...
1
vote
3answers
211 views
Is it possible to make a routable graph from Polygons?
I would like to know if it is possible to make a graph with pgrouting 1.05 on polygons. What I mean is that I have to make a graph on a database without roads but with polygon geometry. I would like ...
1
vote
2answers
83 views
How to fix “Error, query must return columns 'id', 'source', 'target' and 'cost'”?
I have one spatial table with gid, FNODE_, TNODE_ and LENGTH column in my Postgresql/PostGIS database. I am using pgRouting. Problem is, when i try with shortest path query it shows following error. ...
1
vote
1answer
94 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 ...
1
vote
1answer
204 views
PgRouting Driving Distance crashing postgis server
I haven't used PgRouting much so I'm a little in the dark here. However, I am attempting a driving distance calculation like the one described by Underdark here.
My SQL is identical, I have a ...
1
vote
2answers
139 views
Is it possible to get 10 (some) ordered shortest paths ordered by distance (cost) with PgRouting (ex: SELECT TOP 10 SHORTEST)?
I'm new in pgrouting.
Is it possible to get 10 (some) ordered shortest paths ordered by distance (cost) with PgRouting (ex: SELECT TOP 10 SHORTEST)?
Update: why "second shortest" needed?
"second ...
1
vote
2answers
185 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
3answers
132 views
Is it possible to change the projection used in OSM2PO?
Is it possible to change the projection used in OSM2PO? I used the following command to generate a SQL file which I loaded into my database:
java -jar osm2po-core-4.2.30-signed.jar prefix=at ...
1
vote
2answers
296 views
Issues with installing pgrouting in mac
I installed both postgresql and postgis using brew in mac. How can I now install pgrouting. I couldn't install it using brew. Any suggestions?
1
vote
2answers
311 views
How to restart an osm2po service from a previous run?
I have followed underdark's clear and concise "how to" to get osm2po running. The web service is a great little tool for inspecting the data. Is there a way to restart the service using an existing ...
1
vote
1answer
48 views
Does each road segment need to be digitized into a separate entry for a road network?
I am trying to understand this code in pgRouting for creating topology:
CREATE OR REPLACE VIEW road_ext AS
SELECT *, startpoint(the_geom), endpoint(the_geom)
FROM road;
CREATE TABLE node AS
...
1
vote
1answer
186 views
Unreachable vertex
I'm developing an application for academic purposes that mainly gives to the user a recommended itinerary for a previously introduced preferences (Gastronomy, Leisure,etc.).
For this purpose, I use ...
1
vote
1answer
47 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
1answer
122 views
How to create routable network by pgrouting with assign_vertex_id?
I'm trying to create the routable network as per http://underdark.wordpress.com/2011/02/07/a-beginners-guide-to-pgrouting/and use assign_vertex_id. Do I still need to create the node table? How would ...
1
vote
2answers
79 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= ...
1
vote
1answer
568 views
Query failed: ERROR: Operation on two geometries with different SRID
Following the pgRouting workshop here, I have the routing query below:
$sql = "SELECT gid, start_id AS source, end_id AS target, the_geom,
distance(the_geom, GeometryFromText(
...
1
vote
3answers
261 views
Why is pgRouting shortest route function complaining about wrong source and target IDs?
This question is somewhat linked to underdark post, but I think here it would more helpful:
https://underdark.wordpress.com/2011/12/18/osm2po-part-2-pgrouting-on-osm-the-easy-way/#comment-2636
I ...
1
vote
1answer
94 views
It is possible to add A* to the pgrouting plug-in?
I am using pgrouting layer plug-in as described in this post:
http://underdark.wordpress.com/2011/12/18/osm2po-part-2-pgrouting-on-osm-the-easy-way/
I am now able to calculate the shortest path using ...
1
vote
1answer
117 views
Geometry of edges created after using osm2pgsql
I used osm2pgsql to convert osm data to postgresql. Now I have a table with edges and they have geometry like multilinestring. I am not sure what is meant be geometry of an edge. An edge is supposed ...
1
vote
1answer
310 views
Generating nodes where edges meet, PostGIS, pgRouting
Recently I was doing some research on how to assign nodes (as POINT type geometry) to existing edges of a topology network and store them in a different table. Call it nodes table.
I have all the ...
