Design and Implementation of A Scalable and Efficient Geo-Portal System for Geospatial Data Management

Abstract
Efficient geospatial data management is crucial for urban planning, land administration, and infrastructure development. Conventional static databases often lack real-time access and advanced spatial processing capabilities. This study aims to design and develop a scalable and efficient geo-portal system for managing second-order geodetic control points' geospatial data in Ibadan, Nigeria. The system integrates MongoDB for fast spatial data querying, Node.js and Express.js for server-side operations, and Leaflet.js for interactive mapping. It supports real-time data access, spatial indexing, and on-the-fly coordinate transformation between WGS84 and Minna Datum. Performance testing demonstrated an average response time of 200ms and a 92% user satisfaction rate, indicating system efficiency and usability. The developed geo-portal enhances access to geospatial information, supporting better decision-making in urban planning and land administration. Future improvements include predictive spatial analytics and integration with commercial geospatial platforms.
Keywords
geoportal, Geospatial Data Management, MongoDB Database, Urban Planning, Control Point Visualization
References
- M. F. Goodchild, "Citizens as sensors: The world of volunteered geography," GeoJournal, vol. 69, no. 4, pp. 211-221. https://doi.org/10.1007/s10708-007-9111-y, 2007.
- O. I. Apeh, O. C. Nwaka, R. I. Ndukwu, I. Maduako and O. Arilewola, "E-beacon: A web-based survey control finder application," South African Journal of Geomatics, vol. 8, no. 2, pp. 178-190. https://doi.org/10.4314/sajg.v8i2.5, 2019.
- I. G. Ajao and O. Olaniyi, "Geodetic control networks in Nigeria: Standards and challenges," Journal of Geospatial Science, vol. 14, no. 2, pp. 45-58, 2018.
- A. Oyeyode, D. Olayinka-Dosumu and T. Idowu, "Development of an application tool for the site location of survey control beacons in Oyo Town, Oyo State, Nigeria," International Journal of Modelling & Applied Science Research, vol. 26, no. 9, pp. 1758-8117, 2022.
- J. Crompvoets, A. K. Bregt, A. Rajabifard and I. P. Williamson, "Assessing the worldwide developments of national spatial data clearinghouses," International Journal of Geographical Information Science, vol. 18, no. 7, pp. 665-689. https://doi.org/10.1080/13658810410001705311, 2014.
- P. M. Atkinson, G. M. Foody, P. W. Gething and P. J. Radtke, "Web-based geospatial applications: Architectures and solutions," International Journal of Geographical Information Science, vol. 28, no. 2, pp. 271-293, 2014.
- N. R. Budhathoki, B. C. Bruce and Z. Nedovic-Budic, "Reconceptualizing the role of the user of spatial data infrastructure," GeoJournal, vol. 72, no. 3-4, pp. 149-160. https://doi.org/10.1007/s10708-008-9189-x, 2008.
- Land Information New Zealand, "Advancing geospatial data management through innovative geo-portal solutions," 2018. [Online]. Available: https://www.linz.govt.nz. [Accessed 20 01 2025].
- I. Masser, GIS worlds: Creating spatial data infrastructures, ESRI Press, 2005.
- National Population Commission, Population and housing census of the Federal Republic of Nigeria: National and state population and housing tables, priority tables (Volume I), National Population Commission, 2006.
- E. Gamma, R. Helm, R. Johnson and J. & Vlissides, Design patterns: Elements of reusable object-oriented software, Addison-Wesley, 1995.
- S. Roy, A. Nandy and R. Das, "MVC architecture-based web application development with JSP and servlet," International Journal of Computer Applications, vol. 98, no. 20, pp. 12-17, 2014.
- K. Chodorow, MongoDB: The definitive guide, (2nd ed.) ed., O'Reilly Media, 2013.
- K. Banker, MongoDB in action, (2nd ed.) ed., Manning Publications, 2016.
- E. Marcotte, Responsive web design, A Book Apart, 2011.
- Open Geospatial Consortium, "OGC API Features - Part 1: Core. OGC Standard Document," 2019.
- J. B. Olaleye and J. O. Olusina, "Transformation models for GPS coordinates between WGS84 and Minna Datum," Nigerian Journal of Surveying and Geoinformatics, vol. 1, no. 1, pp. 45-57, 2014.
- A. Leff and J. T. Rayfield, "Web-application development using the Model/View/Controller design pattern," 2001.
- F. I. Okeke, E. C. Moka, V. N. Uzodinma and M. Ono, "The determination of datum transformation parameters for Nigeria," Journal of Geodesy, vol. 1, no. 1, p. nag.com.ng, 2017.
- M. N. David, B. K. Kenduiywo and E. H. Waithaka, "A web-Based GIS Portal for Simulating Geodetic Control Networks in Republic of Kenya," Geodesy and Cartography, pp. Vol. 26(No. 4), 170-181, 2020.
- I. Kalu, C. E. Ndehedehe and A. E. Eyoh, "A comparison of existing transformation models to improve coordinate conversion between geodetic reference frames in Nigeria," Modeling Earth Systems and Environment, vol. 8, pp. 611–624. https://doi.org/10.1007/s40808-021-01090-y, 2022.
- P. J. Sadalage and M. Fowler, NoSQL distilled: A brief guide to the emerging world of polyglot persistence, Addison-Wesley, 2013.
- C. Gormley and Z. Tong, Elasticsearch: The definitive guide, O'Reilly Media, 2015.
- J. Pokorny, "NoSQL databases: A step to database scalability in web environments," ACM Computing Surveys, vol. 45, no. 2, p. 16, 2013.
- M. Haklay, A. Singleton and C. Parker, "Web mapping 2.0: The neogeography of the GeoWeb," Geoforum, vol. 39, no. 6, pp. 680-689, 2008.
- R. T. Fielding, "Architectural styles and the design of network-based software architectures," (Doctoral dissertation, University of California, Irvine, 2000.
- W3C., Indexed Database API 2.0. World Wide Web Consortium, 2021.
- Google-Developers, "Progressive Web Apps (PWAs)," 2022. [Online]. Available: https://developer.chrome.com/docs/workbox/. [Accessed 13 01 2025].
- H. N. Habeeb and Y. T. Mustafa, "Deep Learning-Based Prediction of Forest Cover Change in Duhok, Iraq: Past and Future," 2025.
- H. N. Habeeb and Y. T. Mustafa, "Analyzing the Impact of Geoenvironmental Factors on the Spatiotemporal Dynamics of Forest Cover via Random Forest," Earth, vol. 6, no. 1, p. 3, 2025.