Object-Relational Modelling and Establishment of a Generic Database for the Management and Monitoring of Urban Planning Permissions in the City of El-Eulma (Algeria)

Ahmed AKAKBA¹, Abdelwahhab FILALI*²
* Corresponding author
¹ University of Batna 2, Earth and Universe Sciences Institute, Department of Geography, Fesdis, Wilaya of Batna, ALGERIA
² University of Batna 2, Laboratory of Natural Hazards and Spatial Planning (LRNAT), Fesdis, Wilaya of Batna, ALGERIA
E-mail: djalal.akakba@gmail.com, abdelwahhabfilali@gmail.com
Pages: 139-145. DOI: 10.24193/JSSP.2017.2.07

Cite: Akakba A., Filali A. (2017), Object-Relational Modelling and Establishment of a Generic Database for the Management and Monitoring of Urban Planning Permissions in the City of El-Eulma (Algeria). Journal of Settlements and Spatial Planning, 8(2), 139-145. DOI: 10.24193/JSSP.2017.2.07

Abstract. The decision to issue urban planning permissions (e.g.: deeds) at the local communities level in Algeria is based on the cadastral plan (land administration) which defines the owners of the land and the Land Use Plan (LUP, French: POS); in turn, LUP defines the allocation of land and the applicable planning rules. The aim of the present task is therefore to contribute to the development of a Geo-referenced database that would enable us to exploit LUP data (geometric and attribute) as well as the cadastral plan. This approach would allow us to produce a wide range of spatialized, structured and standardized information, thus facilitating the provision of planning documents, the preparation of fiscal reports, the evaluation of spatio-temporal changes, etc. The modelling of data is based on the object-relational modelling adopted by ESRI; this model has been built using the extension “ArcInfo UML Model” integrated in Microsoft Visio. Importing the model into a geodatabase module is done using the “ESRI Schema Creation Wizard” available in ArcCatalog. Furthermore, a municipal one-stop shop for all the formalities required, which was recently established by Decree #19/15, brings together stakeholders in a single commission to deal with all relevant cases of El-Eulma city. The Geomatics approach adopted is a Geo-decisional tool for the one-stop-shop allowing for a good diffusion and communication of information in real time.

K e y w o r d s: urban planning reports, LUP, cadastral plan, GIS, object-relational modelling