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
0
votes
1 answer

Calculating route with pgrouting

How can i, if it's even posible, calculate a route between two points using only existing points as a source? No network/roads provided, i have only points. I've tried this http://docs.pgrouting.org/dev/src/tsp/doc/index.html, but i think i'm…
Arman Khubezhov
  • 103
  • 1
  • 6
0
votes
0 answers

Edges are missed by osm2po when imported to postgresql

I am using osm2po for importing pbf file to postgresql but when i find route using built-in algorithms i found that some of the edges are missing so route does not match with road. Did anybody know why this is happening, thanks in advance Example is…
Mawa
  • 63
  • 9
0
votes
1 answer

Can't use pgRouting functions in PostgreSQL 9.2

I have 3 pgRouting sql files, routing_core routing_core_wrappers routing_topology And I run the code in the first one in PostgreSQL 9.2, I got this error, PS. although there are already pgRouting functions in extensions of 9.2, I still can't run…
Heinz
  • 2,415
  • 6
  • 26
  • 34
0
votes
1 answer

Use pgRouting without executing sql files in PostgreSQL every time

I have installed pgRouting and whenever I create a new database in PostgreSQL, and in order to use the pgRouting function, I have to execute 3 sql files of pgRouting, routing_core routing_core_wrappers routing_core_wrappers Can I use the pgRouting…
Heinz
  • 2,415
  • 6
  • 26
  • 34
0
votes
1 answer

Python error as using rcost to route in PostgreSQL

I use pyscripter to call PostgreSQL from outside and route my network, and here's my code, import sys, os #set up psycopg2 environment import psycopg2 #driving_distance module query = """ select * from driving_distance ($$ select …
Heinz
  • 2,415
  • 6
  • 26
  • 34
0
votes
1 answer

Is there any equivalent of pgRouting for mongodb

I'm currently considering mongoDb for a geospatial project, in a near future the app should have a geospatial routing functionality. But I can't find something like pgRouting equivalent for mongoDb Is there any solution to calculate a route with…
al3x
  • 1,756
  • 2
  • 13
  • 10
0
votes
1 answer

How to use python to loop through all possible results in postgresql？

I use driving_distance function in pgRouting to work with my river network. There are 12 vertices in my river network, and I want to get the distance between all of these 12 vertices, starting from vertex_id No.1. The result is fine, but I want to…
Heinz
  • 2,415
  • 6
  • 26
  • 34
0
votes
1 answer

Chosing the clicked point as an end point of the route on OSM

i am really new with osm. I would like ask a question considering my code down there. Currenty my code makes pgrouting work between two points. And start point is chosen by geolocation and the end point i wrote down it manually as…
Nil
  • 201
  • 3
  • 12
0
votes
2 answers

Issues with pgrouting workshop code in postgis 2.11/pgrouting 2.0

I'm having issues getting the pgrouting workshop to work on Postgresql 9.2/PostGIS 2.11 and pgrouting 2.0 on windows. How can I rewrite the following php/sql code and make it compatible with my version:
user3158780
  • 1
0
votes
1 answer

PostgreSQL function and memory issues

After receiving a lot of help from this site I have finally created a set of functions that does the job I wanted. Thank you for that, but it seems there is one final issue, that of efficient memory usage. Here is the problem: In postgreSQL 9.3,…
Petros Apotsos
  • 615
  • 2
  • 6
  • 13
0
votes
2 answers

pgr_astar and impossible edges (e.g., locked doors)

I'm using postgresql / PostGIS with pgrouting and I need to compute the shortest path. In a previous version of pgrouting, I was using shortest_path_astar. In my routing graph I had impossible segments, such as locked doors. I used: SELECT id FROM…
Antonin
  • 1,748
  • 7
  • 19
  • 24
0
votes
1 answer

Pgrouting functions and geoms type not found

I have installed a postgresql 9.1 and postgis 2.0 from source. Now I compiled and installed pgrouting 2.0 (after one hour searching the dependencies). I created the extension on my database in postgres. I included the function from the sql files…
Mirza Selimovic
  • 1,669
  • 15
  • 18
0
votes
2 answers

trouble getting route distance using pgrouting

I started with the pgrouting-workshop files, but I'm having trouble getting an accurate route length using multiple methods. The first method is just adding up the length variables returned from the ajax call to the pgrouting.php script. The length…
nomadicME
  • 1,389
  • 5
  • 15
  • 35
0
votes
1 answer

Postgresql extension: edit the source code (pgRouting, for example)

How do I modify source code for a postgres extension? I'm trying to do it with pgRouting: so the code is in ../postgresql/9.1/contrib, and when I save the changes, nothing's applied. I tried to restart postgresql service, to drop and re-create…
rocknrollnerd
  • 2,564
  • 1
  • 16
  • 20
0
votes
1 answer

'Relation already exists' error in pgrouting

I am creating a TABLE with the following sql: -- Table: buildings -- DROP TABLE buildings; CREATE TABLE buildings ( osm_id integer NOT NULL, "name" character varying(255), "type" character varying(255), "geometry" geometry, CONSTRAINT…
Mahfuzur Rahman Pallab
  • 67
  • 2
  • 8
1 2 3
…
9
10