Mohammad Adiwisanghagni, Mohammad Suyanto, Sudarmawan Sudarmawan



Often the emergence of less effective and efficient problems in the search for the nearest BTS with the location of complaints from the customer and VIP customer XL provider underlies the request of NetOptim Department PT. Huawei Service to build a tool to facilitate their work. Based on these problems, then conducted a search research location to solve the problems Engineering by designing the concept of searching the nearest site that will be applied to an android application using the SQL Haversine formula. The goal is to measure the accuracy of the SQL Haversine Formula compared to manual system calculations and and build an application prototype that can be used as the nearest BTS location search tool from XL operator based on longitude and latitude complaint. Research method using Prospective Case Study which will be developed with Action Research.

Data obtained by observation and interview method to get Gcell or BTS Database operator XL and and customer complaints, VIP and sales complaints data. The nearest complaint location with BTS data, will be processed for comparison of manual system distance calculation and distance calculations using SQL Haversine formula.     

From validation analysis of SQL Haversine formula calculation, the result of the presentation of accuracy is 84.23% and the resutl of imprecise accuracy is 15.77% due to error data on the calculation.Which means, the SQL Haversine formula is considered sufficient to meet the expectations to apply in application of andorid-based site locator.

Keyword: site locator, longitude, latitude, BTS, haversine


Teks Lengkap:



McLeod Jr., Raymond; Schell, George p.; (2007), Management Information Systems, Ten Edition, Pearson Prentice Hall, New Jersey.

Sudra, Irawan; Gusti, Hermawansyah, Putra., (2016), Aplikasi Pencarian Tambal Ban Motor Terdekat Berbasis Andorid (Studi Kasus Tambal Ban Di Kota Batam), TEKNOMATIKA Vol. 9, No. 1, JULI 2016 ISSN: 1979-7656

Latif, Abdul; Mulyani, Astriana; Rahmawati. Evi., (2016), Aplikasi Location-Based Service Pencarian Lokasi Masjid Terdekat Di Kota Jakarta Berbasis Android, SNIPTEK 2016, ISBN: 978-602-72850-3-3.

Layona, Rita; Yulianto, Budi., (2016), Aplikasi Pencarian Informasi Dan Lokasi Tempat Makan Pada Perangkat Mobile Berbasis Android, TEKNOSI, Vol. 02, No. 02, Agustus 2016, ISSN 2476 – 8812.

Erika, Orien Rindy; Kurniawan,Didik; Febriansyah, Febi Eka., (2016) Aplikasi Pencarian Letak ATM Berbasis Android Dengan GIS Di Kota Bandar Lampung, Jurnal Komputasi, Vol. 4 No. 1, 2016.

Najirah, Umar; Billy, Eden, William, Arsul., (2017) Aplikasi Pencarian Lokasi Wisata Berbasis Android Di Kota Palopo, Seminar Nasional APTIKOM (SEMNASTIKOM), FaveHotel Jayapura, November 2017.

Van Brummelen, Glen Robert. (2013). Heavenly Mathematics: The Forgotten Art of Spherical Trigonometry, Princeton University Press. ISBN 9780691148922.

Muhadjir, Noeng. (2002). Metodologi Penelitian Kualitatif. Bumi Aksara. Jakarta.

Zainal A. Hasibuan, (2007), Metodologi Penelitian Pada Bidang Ilmu Komputer Dan Teknologi Informasi, Konsep, Teknik, dan Aplikasi,Fakultas Ilmu Komputer, Universitas Indonesia.


  • Saat ini tidak ada refbacks.


Program Studi Teknik Informatika Unversitas Janabadra