Tagged Questions
0
votes
0answers
15 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
22 views
How to use for loop to make driving_distance more efficiently？
I use driving_distance function in pgRouting to work with my river network. There are 159 nodes in my river network, and I want to get the distance between all of the nodes. This is my code so far：
...
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 ...
0
votes
0answers
12 views
Can driving_distance return all sets of distance from different starting points at one time？
I'm now using the extension of pgRouting, driving_distance, to search for the distance along the river system：
In the figure, the starting point is 3, but I want to get the distance starting from ...
0
votes
0answers
17 views
driving_distance does not return all sets of distance
As title, I am working with pgRouting, trying to get the distance matrix along the river system.
I use driving_distance function and it seems like I am getting what I want：
But when I check the ...
1
vote
1answer
65 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
33 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. ...
-3
votes
0answers
49 views
What versions of Postgres, PostGIS and pgRouting shall I use on a 64bit windows os? [closed]
Please give me the links and stepwise instructions briefly for installing all the three.
Condition : There shouldn't be any bug in shooting star algorthm. So the comaptable stable versions of the ...
0
votes
1answer
50 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
50 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
42 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
48 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
0answers
31 views
Do I need to deal with warnings about row count and spatial index to use pgRouting?
After read this nice post from underdark A Beginner’s Guide to pgRouting, although I still have some little problems, I think I can begin the "Creating a routable road network" stage right now.
I got ...
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
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
2answers
201 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 ...
3
votes
1answer
89 views
pgRouting Dijkstra returns wrong [duplicate]
I've just observed something quite odd.
I have created a table with data for routing, and this table contains data for a graph over six different hour conditions. So when performing shortest_path, I ...
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
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?
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 ...
1
vote
0answers
113 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 ...
3
votes
1answer
155 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 ...
7
votes
3answers
192 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
1answer
106 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
101 views
How to link pgrouting edges with street names to rout 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 ...
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
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
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
174 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 ...
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 ...
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
246 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
78 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 ...
5
votes
5answers
339 views
Improve performances on distance coverage routing - PostgreSQL
I have to create layers of land coverage from one point to anywhere around on a given street network for a given distance (ex: FROM house, DISTANCE 30000m)
An important factor to understand; I need ...
2
votes
1answer
541 views
pgRouting: unable to execute routing_core.sql
I'm unable to execute the routing_core.sql, receiving following error.
I'm using pgAdmin III, Windows 7, PostgreSQL 9.1, PostGIS 2.0.
ERROR: could not load library "C:/Program ...
1
vote
1answer
128 views
Interpreting the geom_way in the table created using osm2po [duplicate]
Possible Duplicate:
Issues while plotting the results of pgRouting shortest path
I am trying to actually figure out what this column exactly represents and how to use that in my case. I ...
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 ...
2
votes
4answers
246 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 ...
1
vote
1answer
132 views
Is it possible to use assign_vertex_id() POLYGONs?
I'm trying to use pgrouting in order to create a graphe and I have two questions :
Is it possible to use the function assign_vertex_id() with a POLYGON geometry type? I always have the following ...
2
votes
1answer
271 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 ...
4
votes
2answers
758 views
Is Shooting Star broken in PGRouting 1.05?
I'm using pgrouting DLL 1.05 with postgresql 9.1.
All required function installed.
Astar and Dijkstra work fine with sample data but "SHOOTING STAR" is not considering "reverse_cost".
Also if i try ...
3
votes
1answer
391 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
2answers
445 views
How to route between lat/lon pairs in pgRouting?
I have set up Postgresql, PostGIS and pgrouting on Ubuntu.
I have imported an osm for wales using the following command:
./osm2pgrouting -file wales.osm \
-conf ...
4
votes
3answers
938 views
How to make pgRouting faster?
I have table network which has about 2 million records (only 3 countries in Europe). When I run Shorthest-path it is very slow, it takes 3 min to take records only.
I tried with ...
2
votes
1answer
146 views
PostgreSQL / PgRouting syntax error
My question is about Postgres/PgRouting syntax, when I wrote query like this:
SELECT * FROM shortest_path('SELECT gid AS id,
source::int4 AS source,
target::int4 AS target,
...
3
votes
2answers
439 views
How to use pgRouting's dijkstra_sp_delta_directed with WHERE clause?
Right now I am using PgRouting for vehicle routing and I have problem with Dijkstra shortest path. My query is:
SELECT * FROM shortest_path('SELECT gid AS id,
source::int4 AS source,
...
4
votes
2answers
275 views
Why is osm2pgrouting not importing?
I installed pgrouting successfully and did a little import with a 20Mb file. Works good!
Now I'm trying to import a file with the size of a country and it doesn't even start to import. The last 2 ...
13
votes
3answers
2k views
How can I optimize pgrouting for speed?
I am using pgrouting on a postgis database created through osm2pgrouting. It performs very good on a limited dataset (3.5k ways, all shortest path A* searches < 20 ms).
However since I have ...
3
votes
2answers
375 views
pgRouting: Is it possible to do multiple (concurrent) Dijkstra/A*/A_shooting_star queries at a time?
Disclaimer: the author of the question is a novice in PostgreSQL and pgRouting.
As I understand doing a shortest path query in pgRouting is a complicated SELECT underneath.
And as I know unlike any ...
