This thesis explores the integration of the Land Administration Domain Model (LADM) with Sustainable Development Goal (SDG) indicator 1.4.2, which focuses on land tenure security and the availability of legal documentation. The primary objective is to design and implement a dynamic database system that simulates real-world land administration changes over time, incorporating the complexities of land rights transfers, party relationships, and spatial units. The research leverages PostgreSQL and PostGIS to create a flexible and scalable system capable of managing temporal data and generating SDG 1.4.2 reports.

Through the use of multiple constraints and custom functions, the system ensures data integrity while dynamically tracking changes in land tenure and ownership. Testing was conducted using simulated datasets across three years, which modeled evolving land rights, population changes, and administrative updates. The results were validated by comparing manual calculations with the system’s automated outputs, demonstrating the accuracy and reliability of the approach.

The findings highlight the potential of using LADM in SDG indicator calculations and demonstrate the system’s ability to handle complex, multi-dimensional land administration scenarios. However, limitations such as the use of artificial data and a focus solely on SDG 1.4.2 suggest that further work is needed to validate the model with real-world data and expand its application to other SDG indicators and land-related policies. This thesis contributes to the ongoing efforts to modernize land administration systems and provides a scalable solution for tracking land tenure security in line with global sustainability goals.