learned from AACADIS By Dereje Gizaw Advisor Alemahyew Berhe July - PowerPoint PPT Presentation

HiLC LCoE School of Computer Science & Technology MODEL DATABASE DESIGN FOR THE CADASTRE AND LAND REGISTRATION SYSTEM IN ETHIOPIA: Based on lesson learned from AACADIS By Dereje Gizaw Advisor Alemahyew Berhe July 2015

Introduction • Interest towards modern cadastre and Land registration system has recently shown rapid growth throughout the country. • Related policy and strategic documents envisioned the system to play an important role in the fight against the prevalent problem of good governance in the sector. • The AACADIS(land registration and cadastre system of Addis Ababa) is one that comes ahead of similar cadastre and urban land 2

Introduction registration system development efforts in the country by holding the role to serve as a model implementation from which other regions are to derive best practices. • The cadastre and land registration system in Addis Ababa is currently hosting controversial views as to whether the system can meet its sought purposes. • The sources of the controversies range from the question of the project scope up to missing and changing requirements of the system. 3

Introduction • This thesis singles out the conceptual database aspects of the requirement engineering , data base analysis and design of land registration and cadastre system in the country taken the AACADIS as the case study. • AACADIS owned by AACA and contracted to German company Hansa Luftbuild , is composed of two sub- systems – the real property registration systems (RPRS) and the real estate cadastre system (RECS).see • The purpose is to review the database design issues of the AACADIS in the light of new developments in the legal framework, operational procedures and implementation strategies, and scope of the system development among others. 4

Statement of problem • When the system is initially developed it used the existing structures of the land administration institutions of AACA to perform the requirement analysis and design and without a clear and well defined legal base for the cadastre and land registration system. • Afterwards the institutional structure of the land administration offices has undergone different changes and, irrespective of the developed system, new land registration law is issued in federal level. 5

Statement of problem • These sequences of events that could have come first made the developed AACADIS system one that appeared untimely. In addition to that, though the system is supposed to be developed based on the legal cadastre concept, according to the government strategy, it has included mixture of other cadastre elements outside its scope. 6

Statement of problem • The Government strategy has been to develop first the legal cadastre and upon which incrementally build other cadastre system. On top of the short fall in maintaining strategic issues, developing the system outside the required scope has also brought different technical and procedural problems in the effective use of the system. 7

Objective • General Objective : By reviewing the system requirement study and Database design for the AA_CADIS in the light of the changing requirements, scope of the legal cadastre system and international standards to develop a reference Database model for the cadastre and land registration system in the country that will comprise the following specific objectives: 8

Specific objective • To review the business processes of the Land Administration system in the AACA and its relationships to similar functions of the regional states to come up with the complete view of the cadastre and land registration system in the country. • Review and identify the gaps in the implemented Database design of the AA_CADIS against the functional requirements of the business processes of the cadastre and land registration system and requirements imposed by the urban land registration law. • To develop and recommend a new and reference Database model for the cadastre and land registration system which is complete and that can meet all necessary requirements or operation of business process of land registry and cadastre and the international standards. 9

Methodology • The research design approach used in this study is mainly qualitative analysis by taking AA_CADIS as case study. The AACADIS is reviewed using widely applied criteria for the evaluation of conceptual database design, and made by defining elaborate evaluation questions and indicators. • The evaluation criteria are identified for the three quality components of the database design; namely, content, coverage and technology. • For each evaluation criteria evaluation questions and indicators are developed and applied to find out gaps in the database design taken the international domain standards, prevailing legal and operational grounds, technology aspects, etc as a baseline. 10

Methodology • Content describes the schema completeness of user requirement the level of detail of the schema. • COVERAGE describes technically relevant aspects of the schema and the scope of the schema . • TECHNOLOGY point view of the schema for instance requirements engineering in correctness , consistency , minimal and Ability of integration evaluation. • Additional data is collected by using questionnaires and interviews to unfold missing requirements that may result either because of changing circumstances among users , developers and regions out side Addis Ababa 11

Literature review CADASTRE SYSTEM AND IT’S DATABASE DESIGN • Cadastre system basic concept • Why cadastre changes • Current trend and traditional. • Geo database design in Cadastre system • vision cadastre 2014 • LADM as Object framework • Three core package of ISO LADM 12

Cont.. • Cadastral systems are depicted as having textual and spatial information; a geometric description of the land parcels, linked to the textual records or registers describing the nature of interests and ownership of the land parcel (ibid, 2004). • A Cadastre may be established for fiscal purposes (valuation and taxation), legal purposes (conveyancing), and Multi-purpose to assist in the management of land and land-use control (planning and administration), and enables sustainable development and environmental improvement” (Enemark, 2003). • The legal cadastre constitutes the primary evidence for landholding certification purpose. Legal cadastre therefore means an updated landholding information system containing a record of the rights, restrict ions and responsibilities on a defined legal boundary for each landholdings demarcated as parcel on map. 13

Cont.. • In geospatial Databases definition of the spatial representation of the objects or concepts of interest together with their spatial and topological relationships (Javiewer M. Morales G ,2004.). This means that after we have created the conceptual schema and identified objects and relationships, we determine whether these objects are represented as points, lines, polygons or grids. • Another important issue in the design of a geographic Database is the determination and assignment of the coordinate system that references spatial contents of the Database. • Why Cadastre changes? Cadastre and land registration systems have always been in continues changes and developments due to the dynamics of legal and environmental issues, tremendous technological progress, social change, and globalization factors. Aspects of Traditional Cadastre and future trends Among the various aspects characterizing the traditional cadastre is the split system that setup the mapping and registration components into separate systems and organizational structure. The trend in today’s cadastre is a complete integration of the mapping and the registers to form a whole. 14

Cont.. • ISO LADM: Drawn from the Cadastre 2014, the LADM is another international initiative developed to standardize the conceptual database model for the Cadastre and land registration system. LADM evolved from the CCDM, as developed by the a team in the Netherlands, and adopted as the ISO standard in 2011. • Having taken that every cadastre in the world should be included and regarded as extension of the LADM, as being a specialization of the reference model, countries without cadastral registration could benefit from using the core to develop their own specific system. • Using this model driven approach every cadastral system should consequently be compared through this mutual reference model. This would facilitate cross-border transactions with real properties; accordingly, such approach could work within a country cadastral system that applied a distributed environment in exchanging data with its different municipalities or across the border with the neighboring countries. 15

• Land Administration Domain Model establishes the relationship between person (natural/non natural) and land (object) via right, restriction and responsibility which can be expanded into a number of specialized child or sub-classes. Fig 1 depicts the context level (higher level) representation of the three core classes. 16