Propuesta de base de datos espacial multipropósito para la gestión catastral de predios en la cabecera cantonal de Limón Indanza

Abstract

This paper develops the design of a geospatial database for cadastral management in the Limón Indanza canton, in response to the need to modernize and unify information about the territory. The analysis begins with the contextualization of the problem, justification, objectives, and a technical diagnosis, which reveals fragmented management, lack of interoperability, and absence of standardization in accordance with the National Technical Standard for Cadastres. To address the gaps identified in the diagnosis, a cadastral management model structured in PostgreSQL/PostGIS is proposed. The design incorporates enumerated types standardized in the National Technical Standard for Cadastres, trigger functions that automate information entry and update processes, and the development of EPIC views, which enable the generation of standard information products that are interoperable in accordance with MIDUVI requeriments. The model was verified using real data provided by the Decentralized Autonomous Municipal Government of Limón Indanza, using information management software such as QGIS and PgAdmin. The results show that the database is functional and applicable to municipal operations. Overall, the proposal constitutes a technical tool that contributes to the modernization of the cadastre and lays the foundation for future planning processes.