Skip to main content

Preprocessing and Adaptive Parsing of Unstructured Voter Turnout Data with Spatial Feature Enrichment

Author(s): Arya Pratama Tarigan , Mohammad Andri Budiman ORCID https://orcid.org/0000-0002-7716-2206 , Ade Candra
Author(s) information:
Faculty of Computer Science and Information Technology, Master’s Program in Data Science and Artificial Intelligence, Universitas Sumatera Utara, Medan, Indonesia

Corresponding author

The raw input data exhibited severe structural heterogeneity, manifesting as seven distinct structural formats (Formats A–G) characterized by inconsistent header placement, nested merged cells, variable string representations, and missing values. To address these challenges without relying on static rule-based scripts, an intelligent adaptive parser was developed using dynamic regular expressions (regex) and token-density schema mapping based on normalized Levenshtein distance. The adaptive pipeline automatically identified table structures and standardized heterogeneous column definitions into a unified relational database, achieving a data-cleaning accuracy of 99.4%. To enhance the analytical value of conventional demographic data, a spatial feature enrichment pipeline was implemented by integrating three external Application Programming Interfaces (APIs): OpenStreetMap Nominatim for high-precision geocoding, the Google Maps Distance Matrix API for calculating actual road-network distances and travel times, and the Open-Meteo Elevation API for extracting elevation data. This study contributed to public sector data engineering by demonstrating that the integration of automated adaptive parsing with geospatial multi-API enrichment successfully transformed fragmented public documents into a high-fidelity, multidimensional data repository suitable for robust spatial–demographic policy analysis.

Previous article
Next article

Angrist, N.; Djankov, S.; Goldberg, P.K.; Patrinos, H.A. (2021). Measuring human capital using global learning data. Nature, 592, 403–408. https://doi.org/10.1038/s41586-021-03323-7.

Wicesa, N.A. (2021). Human capital, economic growth, and convergence: A case study in Indonesia. International Journal of Business, Economics and Law, 24, 172–183.

Sari, V.K.; Prasetyani, D. (2025). Does human capital matter for Indonesia's economic growth? Jurnal Ekonomi Pembangunan, 22, 291–302. https://doi.org/10.29259/jep.v22i2.23186.

Hamzah, B.; Liliweri, A.; Sayrani, L.P.; Rohi, R.; Doctoral Program of Administrative Science, Faculty of Social and Political Sciences, Universitas Nusa Cendana. (2025). From Policy to Practice: What Explains the Gaps in Voter List Accuracy in Indonesia's Dispersed Island Districts? Journal Public Policy, 11(4).

Dankyi, A.B.; Abban, O.J.; Yusheng, K.; Coulibaly, T.P. (2022). Human capital, foreign direct investment, and economic growth: Evidence from ECOWAS in a decomposed income level panel. Environmental Challenges, 9, 100602. https://doi.org/10.1016/j.envc.2022.100602.

Doré, N.I.; Teixeira, A.A.C. (2023). The role of human capital, structural change, and institutional quality on Brazil's economic growth over the last two hundred years (1822–2019). Structural Change and Economic Dynamics, 66, 1–12. https://doi.org/10.1016/j.strueco.2023.04.003.

Carillo, M.F. (2024). Human capital composition and long-run economic growth. Economic Modelling, 137, 106760. https://doi.org/10.1016/j.econmod.2024.106760.

Bedianashvili, G.; Tsartsidze, M.; Mikeladze, N.; Gabroshvili, Z. (2024). Human capital and economic growth under modern globalization. Entrepreneurship and Sustainability Issues, 12, 268–289. https://doi.org/10.9770/jesi.2024.12.1(19).

Asada, H. (2024). Impact of public sector governance and human capital development on Myanmar's economic growth. Economic Journal of Emerging Markets, 16, 27–37. https://doi.org/10.20885/ejem.vol16.iss1.art3.

Abduh, M.; Alawiyah, T.; Apriansyah, G.; Sirodj, R.A.; Afgani, M.W. (2022). Survey design: Cross sectional dalam penelitian kualitatif. Jurnal Pendidikan Sains dan Komputer, 3, 31–39. https://doi.org/10.47709/jpsk.v3i01.1955.

Ridwan, M.; Ulum, B.; Muhammad, F. (2021). Pentingnya penerapan literature review pada penelitian ilmiah (The importance of application of literature review in scientific research). Jurnal Masohi, 2, 42–51. (accessed on 30 June 2026). Available online: http://journal.fdi.or.id/index.php/jmas/article/view/356.

Romdona, S.; Junista, S.S.; Gunawan, A. (2025). Teknik pengumpulan data: Observasi, wawancara dan kuesioner. JISOSEPOL: Jurnal Ilmu Sosial Ekonomi dan Politik, 3, 39–47. (accessed on 30 June 2026). Available online: https://samudrapublisher.com/index.php/JISOSEPOL.

Siregar, I.A. (2021). Analisis dan interpretasi data kuantitatif. ALACRITY: Journal of Education, 2, 39–48. https://doi.org/10.52121/alacrity.v1i2.25.

Liu, F.T.; Ting, K.M.; Zhou, Z.-H. (2012). Isolation-based anomaly detection. ACM Transactions on Knowledge Discovery from Data, 6. https://doi.org/10.1145/2133360.2133363.

Lundberg, S.M.; Lee, S.-I. (2017). A Unified Approach to Interpreting Model Predictions. In I. Guyon, U. von Luxburg, S. Bengio, H. Wallach, R. Fergus, S.V.N. Vishwanathan, & R. Garnett (Eds.), Advances in Neural Information Processing Systems 30 (Proceedings of the 31st Conference on Neural Information Processing Systems (NeurIPS 2017), Long Beach, CA, USA, December 4–9, 2017) (pp. 4765–4774).

Medaglia, R.; Gil-Garcia, J.R.; Pardo, T.A. (2023). Artificial intelligence in government: Taking stock and moving forward. Social Science Computer Review, 41, 123–140. https://doi.org/10.1177/08944393211034087.

Yang, K.; Miller, P.; Martinez-del-Rincon, J. (2025). DIP-ECOD: Improving Anomaly Detection in Multimodal Distributions. In Conference on Applied Machine Learning for Information Security (CAMLIS 2024): Proceedings (pp. 145–160). CEUR Workshop Proceedings, Vol. 3920. CEUR-WS.

Kasus Manipulasi Kehadiran ASN Terus Berulang, Pemerintah Didesak Evaluasi Sistem. (accessed on 30 June 2026). Available online: https://www.kompas.id/artikel/kasus-manipulasi-absensi-asn-terus-berulang-pemerintah-didesak-evaluasi-sistem.

Nazara, E.M.; Nasien, D. (2024). Sistem employee attendance system using Rapid Application Development method based on Location Based Service. Journal of Applied Business and Technology, 5, 96–104. https://doi.org/10.35145/jabt.v5i2.148.

Bupati Madiun Lantik 93 PNS, BKPSDM Bongkar Praktik Titip Absen di Kecamatan. (accessed on 30 June 2026). Available online: https://suryanenggala.id/2026/04/09/bupati-madiun-lantik-93-pns-bkpsdm-bongkar-praktik-titip-absen-di-kecamatan/.

About this article

SUBMITTED: 01 July 2026
ACCEPTED: 24 July 2026
PUBLISHED: 31 July 2026
SUBMITTED to ACCEPTED: 23 days
DOI: https://doi.org/10.53623/gisa.v6i2.1282

Cite this article
Tarigan, A. P., Budiman, M. A. ., & Candra, A. . (2026). Preprocessing and Adaptive Parsing of Unstructured Voter Turnout Data with Spatial Feature Enrichment. Green Intelligent Systems and Applications, 6(2), 195–206. https://doi.org/10.53623/gisa.v6i2.1282
Citations
0
Share this article