Progressive Web Application Geographic Information System for Offline Spatial Data Collection: A Case Study of Robusta Coffee Disease and Pest Survey

Main Article Content

Norathep Sakphet
Chatirot Jitrugtham
Wanida Petlamul
Vilerswat Noosaeng
Pikul Somjit
Sanit Haruehansawasin

Abstract

The purpose of this research is to develop a Geographic Information System (GIS) based on a Progressive Web Application (PWA) for offline spatial data collection. It aims to solve the problem of field data collection in remote areas with limited internet signals. This study uses a case study of Robusta coffee disease and pest surveys conducted in Khlong Hoi Khong District, Songkhla Province. The system is developed with PWA technology, which uses IndexedDB for offline data storage and supports automatic data syncing when there is an Internet connection. This research also presents an innovative display of location accuracy in a percentage format to make it easier for users to understand. Field performance tests indicate that the system is 100% effective in tracking location and data recording even without Internet, and 95% of maps can be displayed (subject to pre-caching of maps). The system can reduce survey time by 43.4%, increase data accuracy by 7.8%, increase data completeness by 13.2%, and save battery power. In addition, the satisfaction ratings from 30 users average "Extreme" (4.47 out of 5). The developed system has the potential to be applied to other spatial data collection activities, such as natural resource surveys, agricultural area management, or disaster data collection in remote areas, especially in the context of digital infrastructure constraints

Article Details

How to Cite
Sakphet, N., Jitrugtham, C., Petlamul, W. ., Noosaeng, V., Somjit, P., & Haruehansawasin, S. (2026). Progressive Web Application Geographic Information System for Offline Spatial Data Collection: A Case Study of Robusta Coffee Disease and Pest Survey. KKU Science Journal, 54(1), 232–251. https://doi.org/10.14456/kkuscij.2026.17
Section
Research Articles

References

กรมวิชาการเกษตร. (2563). คู่มือโรคและแมลงศัตรูพืชในประเทศไทย. กรมวิชาการเกษตร กระทรวงเกษตรและสหกรณ์.

กรมวิชาการเกษตร. (2565). การป้องกันกำจัดมอดเจาะผลกาแฟแบบผสมผสาน. สำนักวิจัยและพัฒนาการเกษตร กรมวิชาการเกษตร.

ชนินทร์ ศิริขันตยกุล. (2560). โครงการทดสอบพันธุ์และเทคโนโลยีการผลิตกาแฟโรบัสต้าที่เหมาะสมในพื้นที่ภาคใต้ตอนล่าง. กรมวิชาการเกษตร.

Apple Developer. (2023). Updates to storage policy. WebKit Blog. Source: https://webkit.org/blog/14403/updates-to-storage-policy/. Retrieved date 7 May 2025.

Aristizábal, L.F., Johnson, M.A., Marino, Y.A., Bayman, P. and Wright, M.G. (2023). Establishing an integrated pest management program for coffee berry borer in Hawaii and Puerto Rico coffee agroecosystems. Insects 14(8): 603. doi: 10.3390/insects14070603.

Best, J.W. and Kahn, J.V. (2006) Research in Education. 10th Edition, Pearson Education Inc., Cape Town.

Biørn-Hansen, Andreas & Majchrzak, Tim A. and Grønli, Tor-Morten. (2017). Progressive Web Apps: The Possible Web-native Unifier for Mobile Development 344 - 351. doi: 10.5220/0006353703440351.

Boone, H.N. and Boone, D.A. (2012). Analyzing Likert data. Journal of Extension 50(2): 1 - 5. doi: 10.34068/joe.50.02.48.

Brainhub. (2025). PWA on iOS – Current status & limitations for users. Source: https://brainhub.eu/library/pwa-on-ios. Retrieved date 6 May 2025.

Cox, D.R. (2006). Principles of statistical inference. Cambridge: Cambridge University Press. doi: 10.1017/CBO9780511813559.

Dida, G. (2022). Coffee production: Opportunities, challenges and genetic diversity in Ethiopia. International Journal of Research Studies in Agricultural Sciences 8(3): 1 - 9. doi: 10.20431/2454-6224.0803001.

Etikan, I., Musa, S.A. and Alkassim, R.S. (2016). Comparison of convenience sampling and purposive sampling. American Journal of Theoretical and Applied Statistics 5(1): 1 - 4. doi: 10.11648/j.ajtas.20160501.11.

Feehan, L.M., Geldman, J., Sayre, E.C., Park, C., Ezzat, A.M., Yoo, J.Y. and Li, L.C. (2018). Accuracy of Fitbit Devices: Systematic Review and Narrative Syntheses of Quantitative Data. JMIR mHealth and uHealth 6(8): e10527. doi: 10.2196/10527.

Gustafson, A. (2008). Understanding Progressive Enhancement. A List Apart. Source: https://alistapart.com/article/understandingprogressiveenhancement/. Retrieved date 6 May 2025.

Kamilaris, A. and Prenafeta-Boldú, F.X. (2018). Deep learning in agriculture: A survey. Computers and Electronics in Agriculture 147: 70 - 90. doi: 10.1016/j.compag.2018.02.016.

Likert, R. (1961) New Patterns of Management. New York: McGraw-Hill.

Love2Dev. (2021). Progressive web apps on iOS 13 & 14, iPhone & iPad. Source: https://love2dev.com/pwa/ios/. Retrieved date 5 May 2025.

MDN Web Docs. (2023). IndexedDB API. Source: https://developer.mozilla.org/en-US/docs/Web/API/Indexed DB_API. Retrieved date 4 May 2025.

MDN Web Docs. (2023). Progressive Web Apps (PWAs). Source: https://developer.mozilla.org/en-US/docs/Web/Progressiv e_web_apps. Retrieved date 4 May 2025.

Merry, K. and Bettinger, P. (2019). Smartphone GPS accuracy study in an urban environment. PLOS ONE 14(7): e0219890. doi: 10.1371/journal.pone.0219890.

Nie, B. (2015). A study on the second-person narrative in Jennifer Egan’s Black Box. Open Journal of Social Sciences 3(10): 51 - 58. doi: 10.4236/jss.2015.310008.

Singh, P.S., Chutia, D. and Sudhakar, S. (2012). Development of a Web Based GIS Application for Spatial Natural Resources Information System Using Effective Open Source Software and Standards. Journal of Geographic Information System 4(3): 261 - 266. doi: 10.4236/jgis.2012.43031.

Sommerville, I. (2015). Software engineering (10th ed.). Boston: Pearson Education.

Sonti, S.H. (2015). Application of Geographic Information System (GIS) in Forest Management. Journal of Geography & Natural Disasters 5(3): 145. doi: 10.4172/2167-0587.1000145.

Tigren. (2025). Current progressive web app limitations to iOS users. Source: https://www.tigren.com/blog/progressive-web-app-limitations/. Retrieved date 2 May 2025.

United Nations. (2015). Transforming our world: The 2030 Agenda for Sustainable Development. New York: United Nations.

Vega, F.E., Infante, F. and Johnson, A.J. (2015). The genus Hypothenemus, with emphasis on H. hampei, the coffee berry borer. In F.E. Vega & R.W. Hofstetter (Eds.), Bark beetles: Biology and ecology of native and invasive species. Cambridge: Academic Press. 427 - 494.

Vinova. (2025). Navigating Safari/iOS PWA limitations and bugs. Source: https://vinova.sg/navigating-safari-ios-pwa-limitations/. Retrieved date 27 April 2025.

Vinueza-Martinez, J., Correa-Peralta, M., Ramirez-Anormaliza, R., Franco Arias, O. and Vera Paredes, D. (2024). Geographic information systems based on WebGIS architecture: Bibliometric analysis of the current status and research trends. Sustainability 16(15): 6439. doi: 10.3390/su16156439.

W3C. (2022a). Geolocation API specification (2nd ed.). Source: https://www.w3.org/TR/geolocation-API/. Retrieved date 28 April 2025.

W3C. (2022b). Service workers W3C recommendation. Source: https://www.w3.org/TR/service-workers/. Retrieved date 28 April 2025.

Wang, Y., Zhang, H. and Li, D. (2019). Performance assessment of mobile GIS data collection applications: A systematic review. International Journal of Digital Earth 12(6): 671 - 687.

WebKit. (2018). IndexedDB quota changes [Bug 190598]. WebKit Bugzilla. Source: https://bugs.webkit.org/show_ bug.cgi?id=190598. Retrieved date 27 April 2025.

Zandbergen, P.A. (2009). Accuracy of iPhone Locations: A Comparison of Assisted GPS, WiFi and Cellular Positioning. Transactions in GIS 13(s1): 5 - 25. doi: 10.1111/j.1467-9671.2009.01152.x.