Integrating Geospatial Intelligence and Public Procurement Data for Fiscal Oversight: Design, Implementation, and Evaluation of a Geoportal for Public Infrastructure Monitoring

The increasing availability of public-sector data creates opportunities for spatially enabled fiscal oversight, but procurement, project-monitoring, financial, and geographic information are commonly maintained in heterogeneous institutional systems. This work presents the design, implementation, deployment, and evaluation of a geospatial intelligence geoportal for public-infrastructure oversight in Colombia. Its contribution is architectural and integrative rather than algorithmic: source-specific ETL pipelines, explicit administrative-to-spatial relationships, thematic federation, standardized GIS publication, and multi-scale interaction are combined into a recurrent and traceable decision-support environment. The infrastructure pipeline processed approximately 258,528 AppUI source records into 25,897 analytical records. A polygon-intensive environmental module was used as a technical stress case for the shared geospatial infrastructure, where coordinated database, geometry, GIS-service, and client-side optimizations reduced mean feature-service loading time from 51.92 s to 1.48 s, while representative DISTINCT queries improved by 96–99%. The platform supports territorial, attribute-based, and project-level examination of spatial, contractual, temporal, financial, and execution-related information while preserving source traceability. An operational load-and-stress session analyzed 1054 HTTP requests with a 99.9% successful-request rate; however, the protocol was not a standardized high-concurrency benchmark and does not establish maximum concurrent-user capacity. The results provide evidence of technical feasibility and operational behavior in the evaluated public-sector deployment but do not establish improvements in audit outcomes, transparency, or decision quality. The architecture documents a potentially reusable implementation pattern for other public-sector monitoring contexts; its transferability and scalability require independent replication and standardized evaluation.