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

learn more… | top users | synonyms

0
votes
1answer
36 views

pgrouting pgr_dijkstra forcing route along a selected edge?

I have routing working where a user clicks 2 points on the map, I find the closest vertex to those 2 clicked locations and pass that to a pgr_dijkstra function. What I would like is give the edge a ...
0
votes
1answer
44 views

Installing pgrouting on mac os x

Regarding installing (build) pgrouting I could install pgrouting-2.0.0 by using a command brew install pgrouting and following this Build manual: ...
1
vote
2answers
56 views

How to make a routable network topology?

We are trying to make a network topology for pgRouting from our own data. But there is a problem we could not resolve; our road data look like this; The red edge is a single geometry, so we can not ...
0
votes
0answers
47 views

Create a route by using points (pgRouting)

I'm currently working on a routing model for 17th and 18th century voyages. These routes are based on data from old shipping logbooks. I made a separate layer in QGIS which contains point. I exported ...
2
votes
0answers
39 views

Cost_Matrix Distance: Vehicle routing problem!

I'd like to calculate the "real distance" between one source and many targets, such as we do in the "vehicle routing problem", in order to get the matrix distance at the end. after using the osm2po, ...
0
votes
1answer
24 views

pgrouting pgr_ksp with large dataset

I have a large osm dataset. When I execute a pgr_ksp query, it takes +30 minutes Example: SELECT seq , id1 , id2 , cost FROM pgr_ksp( 'SELECT id, source, target, cost FROM myways', 524356, ...
1
vote
0answers
21 views

pgRouting. pgr_ksp() returns -1 as id3

The documentation (http://docs.pgrouting.org/dev/src/ksp/doc/index.html) says that the result should be 0 for the last row. Is the same 0 than -1? I'm new on this. Thaks for the help.
0
votes
1answer
32 views

How to fix pgr_dijkstra error, query must return columns 'id', 'source', 'target' and 'cost'?

I followed the steps in "pgRouting 2.0 for Windows quick guide". At the step of running pgr_dijkstra using the sql below: SELECT id, id1 AS node, id2 AS edge, cost, the_geom FROM pgr_dijkstra( ...
0
votes
1answer
29 views

What are the OSM 'class' cost settings for OSRM?

I'm looking to set up a routing system that will give distances based on network routes, rather than straight lines (ie. ST_Distance). To do this, I'd like to set up a pgRouting database where the ...
0
votes
0answers
67 views

Live routing with instructions is show in a windows info if click in road

I have make a web application , the application have in a server a database in Postgresql with a table roads , i have make a php with pgRoutong query , in the web site the user give two points , or ...
0
votes
0answers
17 views

Query processing time for network table creation using pgRouting 1.05

I am trying to follow these steps for creation of a network table using pgRouting 1.05. In my case I have two road geometry tables, one is bangalore_road and the other is all_india_roads. Obviously ...
0
votes
2answers
29 views

“linestringZ” kills “pgr_createTopology”

I'm trying to make a postgis tabel ready for pgrouting. But when I run SELECT pgr_createTopology('network.VEJM_BR_SL', 0.001, 'geom', 'id'); I get an error: "Geometry has Z dimension but column ...
0
votes
1answer
34 views

OSM to pgRouting -missing attributes

we are trying routing with pgrouting for our project but we noticed that NOT all the attributes we had in the row OSM data are in our database after we imported the data. we have checked in the ...
0
votes
1answer
35 views

how to fix this ERROR: Start vertex was not found

I am attempting to make an SQL selection but receive an error. My statement: SELECT * FROM network JOIN (SELECT * FROM shortest_path(' SELECT gid AS id, start_id::int4 AS source, end_id::int4 ...
1
vote
2answers
35 views

Routing two not-node points and road side with pgrouting

I'm starting to use pgrouting and I have a couple of problems. In my project I have a lot of points which are near one of the road sides. I'd like to know how I can route two of these points since ...
0
votes
0answers
29 views

Indoor routing using Leaflet and pgrouting

I am going to create a project with leaflet and pgrouting for indoor mapping. now I want to search for possibilities of doing this,I want to chose right library for this .Does any one has any ...
0
votes
0answers
27 views

How to get a time cost related to polyline geometric characteristics in postgis using OSM data?

I'm trying to make an isochrone mapping of the emergency facilities in my region, I'm using a street map loaded in postgis by osm2pgrouting, data is supplied by OSM. The only cost I got for every ...
0
votes
1answer
79 views

Isochrone driving/public transport map : Grass or postgis?

I have to do Isochrone driving / public transport map. It would seem that the two better open-source solutions are grass and postgis. Could you tell me which one is the better? the easier to ...
2
votes
1answer
73 views

Creating Isochrones with pgrouting - Network set up, locations (from point shapefile) imported into PostgreSQL/PostGIS DB and now?

I want to calculate isochrones representing the accessability of certain locations in a city. So I have set up the pgrouting enabled database, imported the OSM-Roads and created a network (thanks ...
1
vote
0answers
30 views

Network Analysis for Pickup and Dropoff

I have a bit of a problem that I need help with. I am looking at a set of lat/long with a time stamp for the desired pickup or drop-off for passengers. There are multiple pick-ups and drop-offs within ...
4
votes
0answers
62 views

Error installing PGRouting database extensions

Im trying to install pgRouting and I cannot reach the end of the way because of the following error: psql:/home/user/share/postgresql/contrib/pgrouting-2.0/pgrouting.sql:2459: ERROR: could not load ...
1
vote
1answer
49 views

How I can use TSP function in pgRouting 2.0?

I've spent years working with pgRouting and so far he had solved the problems I had needed. With the change to version 2.0, things improved, everything was much more organized and new algorithms that, ...
0
votes
1answer
53 views

Find nearest node function

I am trying to get work the next function but i don't know if it is incomplete because the query SELECT * FROM pgr_nearest_node1('jaen',-3.75,37.779); does not provide any results. Here is the ...
0
votes
1answer
78 views

pgr_drivingdistance wrapper

Pgr_drivingdistance function works as : SELECT seq, id1 AS node, cost FROM pgr_drivingDistance( 'SELECT id, source, target, cost FROM edge_table', id, distance, false, ...
1
vote
0answers
43 views

Is there any VRP solver in Pgrouting 2.0?

after looking at older posts and googling for a while i guess there is not vrp solver (multiple trucks). there was DARP in pgr1.x but i can't see it in 2.x. i found a lot of information on ...
0
votes
0answers
30 views

Syntax error drivingdistance

I am new in sql and i am trying to get that works a subquery with pgr_drivingdistance and pgr_pointsaspolygon but i get the next error: subqueries in FROM must to have an alias,for example, FROM ...
0
votes
1answer
106 views

Using Pgrouting dijkstra algorithm in PostGIS?

I own two tables one with streets and one points, i use the table with the roads to calculate routes with dijkstra algorithm. But I want when someone add one point in the table Point and this point is ...
0
votes
1answer
82 views

PgRouting function wrapper

I'm trying to adapt the pgr_fromAtoB function to pgr_fromAtoMult replacing pgr_dijkstra function to pgr_drivingdistance.Here is the code: CREATE OR REPLACE FUNCTION pgr_fromAtoMult(IN tbl character ...
0
votes
2answers
54 views

Find closest points in routing network for a set of points to pick shortest route

I have the following WITH SQL Query which does select a set of filling stations along a route within the distance of 1000m. In the SQL statement I fetch 1 Point from the station and search the closest ...
0
votes
1answer
86 views

How do I create a new vertex in the middle of an edge in postGIS?

I have a postGIS database populated with OSM data with the osm2po import tool. I have a number of fixed points that I want to route between using pgrouting. In order to do this accurately, I want to ...
0
votes
0answers
70 views

Package pgrouting_93 rhel7 rpm is not signed

I am trying to install pgrouting on Centos 7 like this: 1) Install Postgresql RPM - 9.3 on Centos 7 : http://yum.postgresql.org/repopackages.php#pg93 2) Install Postgresql 9.3 , PostGIS 2_93, ...
1
vote
2answers
227 views

UbuntuGIS packages on ppa.launchpad

I am trying to install pgrouting on ubuntu 14.04 like this: Add pgRouting launchpad repository sudo apt-add-repository -y ppa:ubuntugis/ppa sudo apt-add-repository -y ppa:georepublic/pgrouting sudo ...
0
votes
1answer
86 views

How to find routes between for each entry in a list of point pairs?

I have a postgis database with two tables. In the first table I have linestrings of a street network. The second table has points that are located on the street network. What I want is to find the ...
3
votes
1answer
267 views

How to compute Walking and Cycling Isochrone maps using QGIS & pgRouting?

Just installed QGIS as I believe I should be able to produce walking and cycling isochrones from a specified point. I have done this pretty easily before using ArcMap, however, I am really struggling ...
1
vote
0answers
68 views

instal pgrouting on postgres 9.3 + postgis 2.1

Just installed postgres 9.3 + postgis 2.1 on debian 7. Postgis works fine, but installation of PGrouting fails in psql. (no errors while installing sudo apt-get install postgresql-9.3-pgrouting) ...
1
vote
1answer
101 views

Removing pseudo nodes from PostGIS database using ST_ModEdgeHeal()?

I have used osm2po (5.0.0) and its autogenerated SQL file to load some 25% of Europe.osm.pbf as a network table into my PostGIS database. I have also created an associated nodes table with select ...
0
votes
1answer
225 views

pgRouting cannot find extension control file

I am trying to use pgrouting on OS X. I installed the following: brew install postgres brew install postgis brew install pgrouting When I try to create the extension pgrouting I get the following ...
2
votes
0answers
69 views

pgrouting librouting.dll library is supposedly missing when it is not

Yesterday, I successfully installed pgrouting from the most recent x64 2.0.0 binaries, at least this is what I thought. I was able to perform first query - select pgr_createTopology() from the ...
1
vote
1answer
73 views

how to Find nearest line for the given point from a collection of lines?

I have table with lines(linestring).For a point wich i give it , I want to find out nearest line in point. I almost developed a query, but it is return the same line every point i give. the query ...
1
vote
2answers
42 views

Learning pg_routing - shortest_path error

I'm learning PostGIS and pg_routing to help in our project planning and grant applications at my transportation agency (we wanted to move beyond the limitations of the 1/4 mile walking buffer we use ...
0
votes
2answers
59 views

How to get the closest point from a table in PostGIS?

I have a table of pgrouting nodes, structured like this: CREATE TABLE ways_vertices_pgr ( id bigserial NOT NULL, cnt integer, chk integer, ein integer, eout integer, the_geom ...
3
votes
2answers
86 views

pgrouting - network distance many-to-one shortest paths

I want to find the distance (km) between each origin point to the closest destination point (restaurants) using pgrouting. I have 3 tables my road network with nodes and edges 140 origin points - ...
0
votes
0answers
27 views

Error of doing pgr_analyzeGraph

I just completed the command pgr_createTopology, but it fails to do pgr_analyzeGraph & pgr_createTopology. The error is as below: Anyone can give me an idea? Thanks ERROR: isring() should only ...
1
vote
1answer
61 views

Get closest (source or target) of an edge from a point in postgres

I have a Postgres custom function that uses pgr_dijkstra to generate a route working. It works be passing the lat/lon of the start and destination points. I then find the closest segment vertice to ...
0
votes
0answers
76 views

How to split linestrings where start/end points don't touch nearby lines

I am trying to figure out some basic routing with PostgreSQL/pgRouting and I'm struggling a bit. Our network of linestrings are not topologically correct, tracks that should be connected don't touch, ...
1
vote
1answer
98 views

Solving “Traveling Purchaser Problem”

Till now, I was using PostGIS-pgrouting pgr_tsp function to solve Travelling Salesman Problems. This function can give us the best possible route depending upon the cost parameter when the starting, ...
0
votes
1answer
30 views

pgrouting with wms [closed]

I able to successfully perform pgrouting using wms but I am looking to show the cost (the length) on the webpage (not only the line on the map but the length of the line) some where in a div next to ...
1
vote
1answer
37 views

calculate route in road network [closed]

I have a shape file of road network. I have found out the nodes on the network. I want to calculate all the possible routes from a start point to the end point. I am using Postgres,postgis and ...
-1
votes
1answer
113 views

How to create a Network Topology in a shapefile that contains only nodes(geometry points)?

I want to use pgrouting with the shapefile but when I use : alter table network.publictransport add column source integer; alter table network.publictransport add column target integer; select ...
2
votes
0answers
28 views

pgRouting only partially segments network

I have a road network traced from an old map with 360 MultiLineString features in table aroads. Many meet at endpoints or intermediate vertices, but some intersect. When I run SELECT ...