{"id":2483,"date":"2024-02-03T11:14:18","date_gmt":"2024-02-03T11:14:18","guid":{"rendered":"https:\/\/geografie.ubbcluj.ro\/pages\/jssp\/?p=2483"},"modified":"2024-02-24T09:57:13","modified_gmt":"2024-02-24T09:57:13","slug":"abstract-07jssp022017","status":"publish","type":"post","link":"https:\/\/geografie.ubbcluj.ro\/pages\/jssp\/?p=2483","title":{"rendered":"Abstract 07JSSP022017"},"content":{"rendered":"\n

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) <\/a><\/strong><\/p>\n\n\n\n

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

Cite<\/strong>:\u00a0Akakba 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<\/a><\/p>\n\n\n\n

Abstract<\/strong>. <\/strong><\/em>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 \u201cArcInfo UML Model\u201d integrated in Microsoft Visio. Importing the model into a geodatabase module is done using the \u201cESRI Schema Creation Wizard\u201d 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.<\/p>\n\n\n\n

K e y w o r d s<\/strong>:<\/em> <\/strong>urban planning reports, LUP, cadastral plan, GIS, object-relational modelling<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

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 AKAKBA1, Abdelwahhab FILALI*2* Corresponding author1 University of Batna 2, Earth and Universe Sciences Institute, Department of Geography, Fesdis, Wilaya of Batna, ALGERIA2 University of Batna 2, Laboratory of Natural Hazards and … <\/p>\n

Read the full post →“Abstract 07JSSP022017”<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"_links":{"self":[{"href":"https:\/\/geografie.ubbcluj.ro\/pages\/jssp\/index.php?rest_route=\/wp\/v2\/posts\/2483"}],"collection":[{"href":"https:\/\/geografie.ubbcluj.ro\/pages\/jssp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/geografie.ubbcluj.ro\/pages\/jssp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/geografie.ubbcluj.ro\/pages\/jssp\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/geografie.ubbcluj.ro\/pages\/jssp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2483"}],"version-history":[{"count":3,"href":"https:\/\/geografie.ubbcluj.ro\/pages\/jssp\/index.php?rest_route=\/wp\/v2\/posts\/2483\/revisions"}],"predecessor-version":[{"id":2873,"href":"https:\/\/geografie.ubbcluj.ro\/pages\/jssp\/index.php?rest_route=\/wp\/v2\/posts\/2483\/revisions\/2873"}],"wp:attachment":[{"href":"https:\/\/geografie.ubbcluj.ro\/pages\/jssp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/geografie.ubbcluj.ro\/pages\/jssp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2483"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/geografie.ubbcluj.ro\/pages\/jssp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}