The Design and Implementation of a Cadastral Database with a Spatiotemporal Modeling Approach in Turkey

Abstract The cadastral data in Turkey form a large spatial dataset and require efficient data management tools. A fruitful and effective database should be designed and developed therefore to manage cadastral data. The database to be developed should be modeled using a spatial and temporal modeling technique. This study describes the design and implementation of a cadastral database with a spatiotemporal modeling approach in Turkey. The objectives are to propose a design of a spatiotemporal database that fulfills the requirements for spatial, temporal, and spatiotemporal queries for cadastral data, to implement the proposed design in a study area, and to enforce the development of multipurpose-motivated cadastral data. In order to meet the study objectives, the required characteristics of a cadastral database were taken into consideration while performing the design. The phases followed during database design process include the requirements collection and analysis, the conceptual design, the choice of a database, the logical design, the physical design, and the implementation of the database system. The proposed design was implemented in Cayyolu quarter of Ankara. Oracle 8i Spatial was chosen as the Database Management System since it provides the storage and the management of spatial data in an object-relational structure. MapInfo 6.0 GIS software was used to display, manipulate, and query the cadastral data.