Stack Overflow
Stack Overflow

Questions tagged [pgrouting]

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

pgRouting is an Open Source software add-on to PostgreSQL / PostGIS to find routes through road networks and solves general graph analysis problems.

Project homepage: http://pgrouting.org/index.html

144 questions
1
vote
2 answers

Query to postgreSQL from RoR slower than from prompt?

I am querying a postgreSQL DB from my ruby on rails application this way: var = Map.connection.execute(" SELECT * FROM shortest_path('SELECT * FROM japan WHERE japan.geom_way && ST_MakeEnvelope(139.68012, 35.63993, 139.71918, 35.66024)', 242945,…
user1463862
  • 101
  • 1
  • 4
0
votes
0 answers

Mismatch between PostGreSQL server version and library version

I need to install pgrouting and use it as an extension to my PostGreSQL database. But after the installation when I type "Create Extension pgrouting" I get the following error message: ERROR: Server is version 15, library is version 14.incompatible…
Soevndahl
  • 1
0
votes
0 answers

Custom heuristic on pgrouting pgr_astar function

So i'm using pgrouting to compute shortest path on transit network, The cost of my graph is time, but the graph isn't "time dependent" - which means my arcs are available at every hour everyday, the cost is not the distance between station but the…
Esdras Assikidana
  • 3
  • 3
0
votes
1 answer

Pgr_astar slower than pgr_dijkstra, Pgrouting

So i'm using pgrouting to compute shortest path on transit network, The cost of my graph is time, but the graph isn't "time dependent" - which means my arcs are available at every hour everyday, the cost is not the distance between station but the…
Esdras Assikidana
  • 3
  • 3
0
votes
1 answer

osm_relations table does not get populated

Problem When running osm2pgrouting on a typical .osm file with the --addnodes option, osm_relations table stays empty. To Reproduce osm2pgrouting -f home/map.osm -c "/usr/local/share/osm2pgrouting/mapconfig.xml" -d city_routing -U [username] -W…
theTruthIsOutThere
  • 107
  • 8
0
votes
0 answers

pgr_drivingdistance with variable distance value

I am trying to use a table subquery as a distance as the float value associated with the specific index. In this way, the allowable distance changes with each array value passed as the starting node. Using another subquery like the one th build the…
evan
  • 169
  • 3
  • 12
0
votes
1 answer

PostgreSQL: using strings in SQL subquery text in a function

I'm using the pgr_drivingDistance function that requires a SQL subquery as text like so: pgr_drivingDistance( 'SELECT id, source, target, cost, reverse_cost FROM edges', start_vid, dist, true ) I would like to subset the edges in the edges table…
Marc
  • 189
  • 1
  • 9
0
votes
0 answers

Calculating distance between two points with obstacle using PostGIS

I'm a new user of Postgis, I try to find which point is closer to start_point and end_point. for example: start_point is POINT(19.9948526769673, 0.001437951055402) end_point is POINT(19.996406755300036, 0.003174344782679) Red line is a LineString…
Mathe
  • 51
  • 3
0
votes
0 answers

Visualisation of isochrones

Im new at coding with SQL, specially with pgAdmin, right now i downloaded data form OpenStreetMap, and im trying to build questionnaires for the creation and visualization of isochrons in the road network, in intervals between : 2,5,10,15 minutes,…
lirim bokshi
  • 11
  • 2
0
votes
1 answer

pgrouting routing methods don't deliver shortest path

At first I'm pretty new to routing in general and need to use it for my bachelor thesis so I am pretty time limited to learn it. If there is anymore Information I can give to find the Problem or if you just have a idea please inform me. Thanks! I…
Sören Mehlhop
  • 11
  • 2
0
votes
0 answers

PGRouting: build path without shortcuts

I create a pathfinding algorithm using pgrouting library. This is the ouput I get with pgr_dijkstra: However, I do not need the shortcuts I'm having here. What are the possible approaches to make sure the red path will be built right down on a blue…
HardRock4Life
  • 177
  • 1
  • 9
0
votes
0 answers

I can't figure out a way to generate a route in pgRouting between 2 Points from another table

I am just starting to get into PostGIS and pgRouting and stumbled upon the following problem: I imported a Network-Graph into my DB, and the routing inside of that Table (from node A to node B) works fine. However I would like to find a route…
afflicitor
  • 1
0
votes
1 answer

pgr_dijkstra return empty result

I want to use pgr_dijkstra in postgresql for OSM data. Steps : Insert OSM data into table 'streets' that contains source and target columns. Create streets_noded table with pgr_nodenetwork function. Use streets table in pgr_dijkstra. Why the…
Alireza Asadi
  • 1
  • 1
  • 2
0
votes
1 answer

How do I calculate shortest path between Origin - Destination pairs using pgRouting?

First of all I just want to state that I'm very new to GIS and that I'm probably not that great at the terminology yet, so bear with me. I'm having my internship right now and have been tasked with making a bike commuting potential analysis. The…
SweGIS
  • 1
  • 2
0
votes
0 answers

PostGis and OSM data and pgRouting I want to put a route under maintenance

I have osm data network that I make but in the country of the data there are so many routes is maintenance so distance is wrong how can I out something or boolean in column is_maintenance = true and it will only calculate routes from the other…
BKSO
  • 23
  • 1
  • 5
1 2 3
…
9 10