Automated Conversion of Unstructured Geospatial Feeder Data into Analytical Models: An 11 kV Case Study
DOI:
https://doi.org/10.64470/elene.2026.20Keywords:
Data-driven diagnostics, Distribution networks, KMZ metadata extraction, Power system modelling, Topological healingAbstract
The modernization of power distribution grids, driven by the integration of DER, necessitates advanced modelling capabilities. A critical challenge is the semantic gap between the extensive geospatial asset data and the detailed electrical models required for engineering analysis. This data is often stored in static, unstructured KMZ formats that contain inherent topological errors. To address this, this paper presents a novel low-cost, Python framework that fully automates the conversion of this raw GIS data into solvable mathematical models for computation. This process generates executable files for industry-standard, script-based simulators such as MATPOWER and OpenDSS. The framework's core technical contributions include an XPath and Regex-based engine for metadata extraction. A graph-theory pipeline then utilizes a Minimum Spanning Tree (MST) algorithm to algorithmically heal topological disconnections. A Dijkstra-based method is then used for model abstraction. The core methodology was first validated using a bidirectional, reverse-engineering process on a 4-bus test case. This confirmed a lossless round-trip conversion to and from a data-rich KMZ format. Subsequently, it was applied to a complex, real-world 11 kV Kenyan distribution feeder. The generated model converged in a Newton-Raphson power flow. This demonstrated its utility as a powerful diagnostic instrument by enabling detailed feeder voltage profiling and loss analysis. Results were cross-validated against DIgSILENT PowerFactory, a graphic-based simulator, showing excellent numerical agreement. This study validates a scalable framework that transforms static, error-prone GIS data into dynamic, multi-platform diagnostic models. This approach provides a feasible pathway to accelerate grid modernization.
Downloads
References
Abeysinghe, S., Abeysekera, M., Wu, J., & Sooriyabandara, M. (2021). Electrical properties of medium voltage electricity distribution networks. CSEE Journal of Power and Energy Systems, 7(3), 497–509. https://doi.org/10.17775/CSEEJPES.2020.01640
AL-Jumaili, A. H. A., Muniyandi, R. C., Hasan, M. K., Paw, J. K. S., & Singh, M. J. (2023). Big Data Analytics Using Cloud Computing Based Frameworks for Power Management Systems: Status, Constraints, and Future Recommendations. Sensors, 23(6), 2952. https://doi.org/10.3390/s23062952
Anderson, A., Stephan, E., & McDermott, T. (2022). Enabling Data Exchange and Data Integration with the Common Information Model: An Introduction for Power Systems Engineers and Application Developers. Pacific Northwest National Laboratory (PNNL). https://doi.org/10.2172/1922947
De-Jesús-Grullón, R. E., Batista Jorge, R. O., Espinal Serrata, A., Bueno Díaz, J. E., Pichardo Estévez, J. J., & Guerrero-Rodríguez, N. F. (2024). Modeling and Simulation of Distribution Networks with High Renewable Penetration in Open-Source Software: QGIS and OpenDSS. Energies, 17(12), 2925. https://doi.org/10.3390/en17122925
Deka, D., Kekatos, V., & Cavraro, G. (2024). Learning Distribution Grid Topologies: A Tutorial. IEEE Transactions on Smart Grid, 15(1), 999–1013. https://doi.org/10.1109/TSG.2023.3271902
Geth, F., Vanin, M., & Van Hertem, D. (2023). Data quality challenges in existing distribution network datasets (Version 1). arXiv. https://doi.org/10.48550/ARXIV.2308.00487
Javed, A. H., Nguyen, P. H., Morren, J., & Slootweg, J. G. H. (2021). Review of Operational Challenges and Solutions for DER Integration with Distribution Networks. 2021 56th International Universities Power Engineering Conference (UPEC), 1–6. https://doi.org/10.1109/upec50034.2021.9548198
Kenya Power Strategic Plan 2023/24-2027/28. (n.d.). Retrieved October 12, 2025, from https://kplc.co.ke/storage/01J1BWDEZDE872C70P1CVD6BC2.pdf
Khanh, N. B., Ngo, P. L., Giap, L. N., An, T. N. T., Tien, T. B., Vinh, T. T., Van Nghia, L., & Trong Dat, T. (2025). A review of open-source energy system modeling tools. International Journal of Advances in Applied Sciences, 14(2), 469. https://doi.org/10.11591/ijaas.v14.i2.pp469-480
Matanov, N., & Nankinsky, P. (2021). Modern aspects of the digitalization in distribution systems. 2021 13th Electrical Engineering Faculty Conference (BulEF), 1–7. https://doi.org/10.1109/bulef53491.2021.9690811
Mohd Azmi, K. H., Mohamed Radzi, N. A., Azhar, N. A., Samidi, F. S., Thaqifah Zulkifli, I., & Zainal, A. M. (2022). Active Electric Distribution Network: Applications, Challenges, and Opportunities. IEEE Access, 10, 134655–134689. https://doi.org/10.1109/access.2022.3229328
Montano-Martinez, K., Ma, S., Vittal, V., & Rojas, C. (2024). Automated Correction of GIS Data for Loads and Distributed Energy Resources in Secondary Distribution Networks. IEEE Transactions on Power Systems, 39(1), 1628–1636. https://doi.org/10.1109/TPWRS.2023.3243550
Montenegro, D., Dugan, R., Taylor, J., & McGranaghan, M. (2022). Open-source software projects for advancing the power systems analysis. 2022 Open Source Modelling and Simulation of Energy Systems (OSMSES), 1–6. https://doi.org/10.1109/osmses54027.2022.9768968
Mukherjee, M., Lee, E., Bose, A., Gibson, J., & McDermott, T. E. (2020). A CIM Based Data Integration Framework for Distribution Utilities. 2020 IEEE Power & Energy Society General Meeting (PESGM), 1–5. https://doi.org/10.1109/pesgm41954.2020.9281658
Patel, P. H., Juthani, J. R., Patel, B., & Vahoniya, D. R. (2025). Quantification and Analysis of Human Errors Across the Life Cycle of Electrical Installations. Archives of Current Research International, 25(1), 113–123. https://doi.org/10.9734/acri/2025/v25i11043
Rahman, M. A., Abdul Maulud, K. N., Saiful Bahri, M. A., Hussain, M. S., Ridzuan Oon, A. O., Suhatdi, S., Che Hashim, C. H., & Mohd, F. A. (2020). Development of GIS Database for Infrastructure Management: Power Distribution Network System. IOP Conference Series: Earth and Environmental Science, 540(1), 012067. https://doi.org/10.1088/1755-1315/540/1/012067
Subasic, M., Ave, G. D., Giuntoli, M., Noglik, P., Knezovic, K., Shchetinin, D., Peterson, W., & Li, W. (2022). Distribution Grid Topology Calibration Based on a Data-Driven Approach. 2022 IEEE PES Innovative Smart Grid Technologies Conference Europe (ISGT-Europe), 1–5. https://doi.org/10.1109/ISGT-Europe54678.2022.9960588
Tóth, R., Balla, D., & Zichar, M. (2020). ANALYSIS AND OPTIMIZATION OF KML FILES. INTED Proceedings, 1, 4209–4216. https://doi.org/10.21125/inted.2020.1175
Downloads
Published
Data Availability Statement
The data that support the findings of this study are available from the authors upon reasonable request.
Issue
Section
License
Copyright (c) 2025 Okemo Amon, C M Muriithi, J N Nderu
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors retain copyright of their work and grant the journal the right to publish it under the Creative Commons Attribution 4.0 International License (CC BY 4.0). This allows for maximum dissemination and reuse with appropriate citation.
ORCID 
