A PostgreSQL/PostGIS Implementation for the Sightseeing Tour Planning Problem

A PostgreSQL/PostGIS Implementation for the Sightseeing Tour Planning Problem

This article discusses a procedure for finding the best multi stops route for sightseeing tour through a road network. The procedure involves building a database containing nodes and road network in PostgreSQL, calculating the shortest distance between a pair of nodes using pgDijkstra module, and solving the tour problem using a function written in PL/pgSQL. The function was developed based on the Nearest Insertion Algorithm for solving the Travelling Salesman Problem. The algorithm inserts a sightseeing attraction (node) at the best position in the existing route, which is between a pair of nodes that yields the minimum difference between the total tour time before and after the new node was inserted. The test result shows that the function can solve the problem within acceptable runtime for web application for total destination nodes of 22. It is concluded that the whole procedure was suitable for developing Web GIS application that solve the sightseeing tour planning problem.

., Ardiansyah

Rainis, Ruslan

Jurnal Rekayasa Elektrika; Vol 10, No 3 (2013); 115-119

2252-620X

1412-4785

Universitas Syiah Kuala

2013-04-30

http://jurnal.unsyiah.ac.id/JRE/article/view/1011/10_3_1

application/pdf

eng

info:eu-repo/semantics/article

info:eu-repo/semantics/publishedVersion

Peer-reviewed Article

http://jurnal.unsyiah.ac.id/JRE/article/view/1011

10.17529/jre.v10i3.1011