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

How to calculate distance and time, using pgRouting

I'm trying to get the overal time and distance from a routing in pgRouting, using pgr_dijkstra, but I have basically no idea on how to achieve it. So far I managed to figure out that the return from pgr_dijkstra is in cost units and I summed them…
TomGeo
  • 1,213
  • 2
  • 12
  • 24
1
vote
1 answer

Postgis ST_Split not splitting roads by all points

I have a table containing the street network of Chicago, and I also have a table of crimes committed in Chicago. I am trying to to create k-means clusters for the crimes by assigning them to the cluster centre that is the shortest road distance…
Ponsietta
  • 315
  • 6
  • 17
1
vote
0 answers

pgrouting and osm2pgrouting Import Tool

osm2pgrouting -file "/home/user/OSM/sample.osm" -conf "/home/user/osm2pgrouting/mapconfig.xml" -dbname pgrouting2 -user user -host localhost -clean The previous command is a single line. and when using this one, "option '--conf' cannot be specified…
thanks
  • 11
  • 2
1
vote
1 answer

unknown parameter: -conf Error in osm2pgrouting

I was just going through the following tutorial HERE. I have extracted all the files succesfully using the below commands: cd ~/Desktop/pgrouting-workshop/ tar -xvzf data.tar. But when i run the following command: osm2pgrouting -file…
Alexander Solonik
  • 9,838
  • 18
  • 76
  • 174
1
vote
1 answer

error when compile pgrouting in mac osx

I cannot compile the pgrouting. The error message shows like below : [ 5%] Built target apsp_warshall [ 11%] Built target astar [ 17%] Built target kdijkstra [ 20%] Building CXX object…
Indrajaya
  • 83
  • 4
1
vote
0 answers

Pass coordinates parameters to geoserver pgrouting service from Leaflet wms tile layer

I've configurated a pgRouting service in Geoserver, following the steps on the documentation it's easy to accomplish. Reading the documentation, existing examples, etc.. I've come to undestand how the call must be made from the Javascript code: …
daniegarcia254
  • 1,157
  • 4
  • 17
  • 36
1
vote
1 answer

Facing issue in Postgres loading extension

I am trying to to load pgrouting in extension in postgis database named as "routing" the problem I am facing is I type in osgeo shell in "C:\Program Files (x86)\Boundless\OpenGeo\bin" "psql -U postgres routing" and it gives the error of "psql :…
Zeshan Hassan
  • 11
  • 2
1
vote
1 answer

Postgres pgrouting2 Dijkstra shortest path returns edges that don't exist

I am struggling with a very strange problem for a few days now that I can't find a solution. I am using postgresql 9.3 with postgis 2 and pgrouting 2 extentions. I have imported OSM data for a city and created topology network successfully with…
geoandri
  • 2,360
  • 2
  • 15
  • 28
1
vote
0 answers

Create Function Failed in Postgres - language C Does not exist error

CREATE OR REPLACE FUNCTION shortest_path( sql text, source_id integer, target_id integer, directed boolean, has_reverse_cost…
Anas A
  • 199
  • 4
  • 19
1
vote
1 answer

Run pgrouting 1.x and 2.x on same machine

We want to run pgrouting 2.x on our test server. Additionally, we want existing applications still run on pgrouting 1.x. Does anyone know, if it's possible installing and running them in parallel? Currently, we run on Postgres 9.1.9 and PostGIS…
ulrich
  • 1,431
  • 3
  • 17
  • 46
1
vote
2 answers

How to get the OSM file to generate width of the streets?

I'm attempting to load osm data into a database and i've used both osm2p0 and osm2pgrouting and kept realizing I wasnt seeing anything that referenced the width of the streets. This is important for me as I am writing a program to perform search…
Jeremy
  • 935
  • 5
  • 18
  • 33
1
vote
2 answers

search recursively for dead-ends in topological network table

I've been trying for weeks to figure this out: I need to recursively search a topological network, OpenStreetMap streets in this case, for dead ends, and neighborhoods that hang from the rest of the network by only one edge. These are places where…
Nate Wessel
  • 162
  • 1
  • 7
1
vote
1 answer

pgRouting assign number of source and target

I have a river network shapefile and I use pgRouting 2.0 to route it. I use the following sql code to make it routable, alter table tc_15000_w_area add column source integer; alter table tc_15000_w_area add column target integer; select…
Heinz
  • 2,415
  • 6
  • 26
  • 34
1
vote
2 answers

get osm data directly from database for pgrouting

I am creating an application which requires a route finder. I have OSM data stored in a PostGIS database and currently this data may be manipulated by my application e.g. roads may be moved, added or deleted. I was looking into pgRouting however it…
sam
  • 2,469
  • 8
  • 37
  • 57
1
vote
2 answers

Assign_vertex_id function

When I execute the following query; SELECT Assign_vertex_id('ways', 0.00001, 'the_geom', 'gid') I am getting the following error; NOTICE: CREATE TABLE will create implicit sequence "vertices_tmp_id_seq" for serial column "vertices_tmp.id" …
IT_info
  • 707
  • 4
  • 16
  • 36
1 2 3
…
9 10