Questions tagged [pgrouting]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
20 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
27 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
45 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
437 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) ...