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
2
votes
0 answers

PostgreSQL Function Error: No function matches the given name and argument types. You might need to add explicit type casts

I am currently new to PostgreSQL and I am implementing pgrouting using Esri Shapefiles. The query I am writing is : SELECT pgr_createTopology('point_file'::text,0.000001,'the_geom'::text, 'gid'::text); "point_file" is the table name ,"the_geom" is…
SudarshanK
  • 108
  • 14
2
votes
1 answer

Need Path in the form of Lat,long using pgrouting

I am using this query for finding the path using postgresql , postgis, pgrouting, postgis_topology using nodejs client.query( "WITH dijkstra AS ( SELECT * FROM pgr_dijkstra('SELECT id,source,target,distance AS cost FROM…
M.HUSSAIN
  • 153
  • 8
2
votes
1 answer

PostgreSQL out of memory: Linux OOM killer

I am having issues with a large query, that I expect to rely on wrong configs of my postgresql.config. My setup is PostgreSQL 9.6 on Ubuntu 17.10 with 32GB RAM and 3TB HDD. The query is running pgr_dijkstraCost to create an OD-Matrix of ~10.000…
PaDe
  • 51
  • 1
  • 3
2
votes
0 answers

I'm creating an edge table, how to prevent duplicating edges

The query is like so: CREATE TABLE Edge_Table AS SELECT a.*gid,nextval('ty') AS edge_gid, ST_SetSRID(ST_MakeLine(a.geom, getcentroids(a.gid)),4326) AS geom_line FROM Points_table a; where my getcentroids Function…
shivam thakur
  • 109
  • 10
2
votes
1 answer

C++ and Postgresql without libpq++ and SQLAPI++

How can I make an interface between C++ and Postgresql without using libpq++ or SQLAPI++ because I tried to install these two libraries but I wasn't able (no tutorials for windows). I know that Postgis and Pgrouting use C++ .. Maybe they use another…
Ahabchane.C
  • 21
  • 2
2
votes
0 answers

How to use OSM2pgrouting's mapconfig.xml

I would like to find out how to make use of osm2pgrouting's mapconfig.xml to filter out certain types of roads (e.g. roads with private access or highways and highway links). Would prefer to understand how to use them rather than having a answer…
YWK
  • 21
  • 2
2
votes
2 answers

how to add pgrouting on postgresql-9.3 on ubuntu 12.04LTS Precise

I am newcomer and want to discover pgrouting. I've already installed postgresql-9.3 and the postgis 2.1 extension on my laptop which runs ubuntu 12.04 Lts precise. I don't want to have to re-install postgresql. Now I want to add the pgrouting…
dadson
  • 57
  • 7
2
votes
1 answer

shortest_path with bus lines and time tables

I'm looking for a solution since days but can't find a way to solve it. My goal is to find the shortest way between 2 bus stops, based on the time the bus takes between them. So I have bus lines, and time tables for each of them. The cost is…
theplayer777
  • 163
  • 1
  • 15
2
votes
2 answers

pgRouting Front End/API

I can't find any reliable info about some kind of "human" readable front end or api to pgRouting. I have OSM PostGIS/pgRouting database which I would like to use to calculate paths between points. The problem is that I can't find any software that…
dr4cul4
  • 258
  • 4
  • 14
2
votes
1 answer

Installing pgrouting in mac

I am having issues with installing pgrouting in mac. It's not available in brew. Is there any way to install it using brew install pgrouting.
rajan sthapit
  • 4,194
  • 10
  • 42
  • 66
1
vote
0 answers

pgr_dijkstraCostMatrix different from single pgr_Dijkstra, error: direction choose wrong way verse

I've a graph (no OSM) and I try with 14 of 468 nodes to resolve this problem. System: Ubuntu Server + Postgres 14 + pgRouting 3.5 When I use pgr_TSP() function I use pgr_dijkstraCostMatrix() with Edges and my 14 Nodes, with directed=>true, but in…
pjhooker
  • 51
  • 5
1
vote
1 answer

Issues with pgrouting createtopology() and rows_where condition

I am attempting to run createtopology on a database where tags match certain conditions with a jsonb datacolumn but the command fails on the rows_where condition and I don't know why. The Database is setup under the schema 'berlin' and has tables…
evan
  • 169
  • 3
  • 12
1
vote
1 answer

Problem with syntax error at or near 'select'

I'm trying to code about how to create isochrones, this is my code: SELECT i As time_access, ST_SetSRID(pgr_pointsAsPolygon( ‘SELECT id, ST_X (geom) AS x, ST_Y (geom) As y FROM dd_caserne WHERE access_time <= ‘|| i :: text), 4326) As geom FROM…
lirim bokshi
  • 11
  • 2
1
vote
0 answers

Is it possible to run pgRouting functions pgr_nodeNetwork and pgr_createTopology from Python to create topology in PostgreSQL?

I successfully created a series of queries using PostgreSQL's great extension pgRouting. Now I'm trying to set up a python script to run the whole process from python. I connected to the PostgreSQL database using sqlalchemy library. All queries are…
HumanoVirtual
  • 57
  • 9
1
vote
0 answers

pgRouting - querying with edge dependencies

I would like to know if it is possible to add dependencies to an edge? (In form of a sql sub-select) For example: We have bidirectional (default) edges from node A to B and another "special" edge from B to C. In my case this might be a ship transfer…
Jan Rembold
  • 43
  • 6
1
2
3
…
9 10