Questions tagged [pgrouting]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
6 views

PostgreSQL: How to install pgrouting with yum on PostgreSQL

Does someone know how to install pgRouting on PostgreSQL? I have tried with PostgreSQL10. I have tried using: sudo yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-...
0
votes
1answer
35 views

Multiple versions of PostGIS and PgRouting on CentOS 7

I'm trying to install multiple versions of PostGis and PgRouting in the same instance of PostgreSQL v9.6, using CentOS 7.5. I've been fighting with dependencies and shared libraries, to make all ...
0
votes
1answer
32 views

Three WHERE slow query down

I have a table adjacency, which stores information about connected lines and their angle to each other is build by CREATE TABLE public.adjacency ( currentedge integer, currentgeom geometry(...
0
votes
3answers
54 views

Help to improve a function

I have this function working fine: CREATE or replace FUNCTION pointscanner( IN source integer, IN target integer, IN k integer, IN directed boolean, IN quant integer ) RETURNS ...
0
votes
1answer
46 views

How make my architecture scalable to handle linear process

I have a system to calculate Real Time Traffic (RTT), using Automatic Vehicle Location (AVL). I can know where the car was, where is now, and calculating distance and time can estimate the traffic ...
2
votes
1answer
440 views

Problem with shortest distance calculation in PostGIS

While working with PostGIS pgrouting, for calculating the distance between two roads (lines) I'm using the shortest_path function. The logic is based on start_point(Start_id) and end_point(end_id) ...