Tagged Questions
1
vote
1answer
24 views
Pgrouting - Networking
my problem is regarding routing.
I have a network based on bicycle graph links (SRID: 4326), with bidirected and directed ways.
I want to give the user the functionality to draw a route (shortest ...
0
votes
0answers
16 views
How to find all possible paths by Postgis / Pgrout [duplicate]
There are functions available to find the shortest paths in Postgis / Pgrouting extension. But is it possible to find all the possible paths between two points/nodes ?
Is there any such function ...
0
votes
0answers
39 views
Shooting star algorithm in postgres 8.4 and postgis1.4 showing fatal error and remaining are working fine
When I try to run this shooting star algorithm, the postgis suddenly loosing connection to postgres and showing error no connection to server
SELECT * FROM shortest_path_shooting_star('
SELECT gid ...
1
vote
1answer
68 views
Win7 Senior users_Which pgRouting and postGIS versions are stable with postgreSQL8.4?
I'm working on a postgreSQL ,postGIS and pgRouting project on Windows 7
I need to work on a stable version (no time for risks), and I can see that many people are asking the same question many ...
2
votes
1answer
38 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. ...
1
vote
1answer
53 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
...
0
votes
0answers
42 views
What are the rules for digitizing roads for creating a road network?
I want to create shortest route tool using pgRouting. But I digitised roads in a random manner. Shall I need to give a separate row for each road segment?
1
vote
1answer
52 views
pgRouting：how to use reverse_cost？
I add a new column, naming it "reverse_cost", and give it the same data in the shape_leng column.
But as I run the shortest path algorithm in pgadmin, I got an error message.
here's my sql code
...
0
votes
1answer
52 views
Creating the node ids：Is this SQL error related to geometry type？
I loaded a multilinestring layer into PostGIS Manager：
and use the SQL query, trying to get the table with the node ids：
ALTER TABLE split_4 ADD COLUMN source integer;
ALTER TABLE split_4 ADD ...
2
votes
0answers
51 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 ...
1
vote
1answer
43 views
SQL Command to convert pgRouting result to GeoJSON
My goal is to produce a Web UI for pgRouting using this tutorial. I have already imported my data from an OSM pBF to PostGIS using osm2po. Using the pgRoutingLayer plugin for QGIS, I was able to ...
2
votes
0answers
49 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.
...
1
vote
1answer
70 views
How to visualize pgrouting query results in mapguide open source
I would like to make a spatial query using postgis 2.0 and pgrouting 1.05 then visualize results in Mapguide open source.Any suggestions?
1
vote
1answer
188 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
49 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
129 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 ...
0
votes
1answer
160 views
Creating routable network table in PostGIS
I am trying to create the routable network table, as per http://underdark.wordpress.com/2011/02/07/a-beginners-guide-to-pgrouting/. Everytime I do it in PostGIS extension, QGIS crashes. The area is no ...
3
votes
1answer
126 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 ...
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 ...
2
votes
1answer
117 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 ...
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
0answers
117 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
3answers
197 views
Why doesn't pgRouting return the best path?
Let the next portion of a graph:
When I use the function shortest_path between the points A and B, I got the blue path. Why does this happen?
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 ...
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
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.
...
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
103 views
How to link pgrouting edges with street names to route user based in street names?
I have installed postgreSql + postGis + pgrouting and I have loaded OSM data into my database using osm2po and shp2pgsql. How can I search for points in the map using the street names and then route ...
2
votes
0answers
113 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
...
3
votes
2answers
126 views
Multiple queries in a row
I have osm data imported into PostgreSQL with osm2po tool (wich makes the data routable). Also I have imported data relationed with nodes and node_tags with osmosis tool.
I need to obtain a set of ...
2
votes
0answers
109 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 ...
9
votes
3answers
357 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 ...
2
votes
0answers
92 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 ...
4
votes
2answers
176 views
Creating many origin-destination routes with pgRouting
I'm using a PostGIS / pgRouting database setup with a road network. I'm trying to create an origin-destination table with the complete route information, so not just the sum of the length, like in ...
2
votes
1answer
113 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
3answers
140 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
1answer
176 views
Problem with Pgrouting 1.5
Hi all and thanks in advance.
I have Postgis 2.0.1 and PgRouting latest version. I'm using osm2pgrouting to import OpenStreetMap data everything goes ok the trouble is that I always get source and ...
3
votes
1answer
86 views
Calculating from a location to another location (calculation must be on a line/road path)
I'm using QGIS. I'm new.
I have a CSV file, with the source point (the_geom) and destination point (the_geom).
I have a road network already imported into PostGIS with pgRouting, and I need to have ...
1
vote
0answers
56 views
Database has duplicate values after running pgrouting
I am a newbie with postgresql and sql statements so maybe it is a trivial question, I'm sorry for that.
I am working on a postgis database and try to use the pgrouting function. My goal is to store ...
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 ...
0
votes
0answers
181 views
assign_vertex_id error
I am trying to test if pgrouting works fine or not. To do so I have created a table containing the following attributes.
Columns:
gid |
length |
the_geom |
source |
target
Now my ...
0
votes
1answer
249 views
Do postgres 9.1, postgis 2.0 from stackbuilder and pgrouting 1.0.3. work together?
I am new to pgrouting and I would like to check if the version I have installed works fine with postgres and postgis.
I have installed postgres 9.1, postgis 2.0 from stackbuilder and pgrouting 1.03.
...
1
vote
0answers
80 views
Is this pgRouting perfomance acceptable for my tiny server?
I'm testing pgrouting functions in a tiny server with 2GB of RAM and a dual core processor.
I wrote a program that create client process and they connect to the server in a specific hour to perform a ...
3
votes
0answers
135 views
Shortest distance from pgrouting with cost not being length: optimal solution
I'm using pgrouting shortest_path_astar with a complicated cost function. It gives back the edges, vertices and costs.
I would like to get the total distance of this shortest path (i.e., the sum of ...
2
votes
2answers
193 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 ...
0
votes
2answers
107 views
dijkstra_sp runs without error in postgres query terminal, but triggers an error in Java
I am running this simple query
select id,gid from dijkstra_sp('roads',22,33)
This works perfectly fine and returns results in postgres query terminal. However running exactly the same query in java ...
1
vote
1answer
126 views
ERROR: type “geoms” does not exist. What version of pgRouting should I use for postgres 8.4 & postgis 1.5?
I am running this on windows 7:
Postgres 8.4
postgis 1.5
I installed pgrouting, but I am getting the error: ERROR: type "geoms" does not exist.
so my question is: which version of pgRouting should ...
1
vote
1answer
102 views
postgresql pgrouting define C function function with int* arguments
I want to create a psql-C function with an undefined length list of integers (GIDs for example).
An erratic example using V0 function definition that works is like:
int mytest4(int *x, int i){
int ...
2
votes
2answers
126 views
Does PostGIS/pgrouting actually come with street info?
I've been looking at getting a new GIS setup going, involving QGIS/PostgreSQL/PostGIS/pgrouting, and so far it has been relatively easy. One thing I want to be able to do is to work out travel times, ...
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 ...
